1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
CREATE TABLE dbo.AWBuildVersion (
SystemInformationID tinyint IDENTITY(1,1) NOT NULL,
Database Version nvarchar(25) NOT NULL,
VersionDate datetime NOT NULL,
ModifiedDate datetime NOT NULL DEFAULT (getdate())
)
GO
CREATE TABLE Person.Address (
AddressID int IDENTITY NOT NULL,
AddressLine1 nvarchar(60) NOT NULL,
AddressLine2 nvarchar(60) NULL,
City nvarchar(30) NOT NULL,
StateProvinceID int NOT NULL,
PostalCode nvarchar(15) NOT NULL,
rowguid uniqueidentifier ROWGUIDCOL NOT NULL DEFAULT (newid()),
ModifiedDate datetime NOT NULL DEFAULT (getdate())
)
GO
CREATE TABLE Person.AddressType (
AddressTypeID int IDENTITY NOT NULL,
Name Name NOT NULL,
rowguid uniqueidentifier ROWGUIDCOL NOT NULL DEFAULT (newid()),
ModifiedDate datetime NOT NULL DEFAULT (getdate())
)
GO
.......... |
Partager