Skip to content

Instantly share code, notes, and snippets.

@aliirz

aliirz/cauto.MemberList.sql

Created April 27, 2017 07:10
Show Gist options
  • Save aliirz/1440572a5b8af78b8894921567cb5edb to your computer and use it in GitHub Desktop.
Save aliirz/1440572a5b8af78b8894921567cb5edb to your computer and use it in GitHub Desktop.
Download ZIP
MemberList
Raw
cauto.MemberList.sql
CREATE TABLE [cauto].[MemberList]
(
[MemberNo] [varchar](10) NOT NULL DEFAULT (space((0))),
[FirstName] [varchar](30) NOT NULL DEFAULT (space((0))),
[LastName] [varchar](30) NOT NULL DEFAULT (space((0))),
[AddressLine1] [varchar](60) NOT NULL DEFAULT (space((0))),
[AddressLine2] [varchar](60) NOT NULL DEFAULT (space((0))),
[City] [varchar](60) NOT NULL DEFAULT (space((0))),
[StateCode] [varchar](5) NOT NULL DEFAULT (space((0))),
[PostalCode] [varchar](10) NOT NULL DEFAULT (space((0))),
[Tags] [varchar](512) NOT NULL,
[DateFrom] [date] NULL,
[DateTo] [date] NULL,
[DateCreated] [datetime] NOT NULL DEFAULT (getdate()),
[DateModified] [datetime] NOT NULL DEFAULT (getdate()),
[LastSqlUser] [varchar](50) NOT NULL DEFAULT (left(suser_sname(),(50)))
)
ALTER TABLE [cauto].[MemberList] ADD CONSTRAINT PK_MemberList PRIMARY KEY ([MemberListId])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment