18 lines
787 B
Transact-SQL
18 lines
787 B
Transact-SQL
CREATE TABLE [dbo].[_Countries] (
|
|
[CountryId] INT IDENTITY (1, 1) NOT NULL,
|
|
[CountryName] VARCHAR (50) NOT NULL,
|
|
[CountryDesc] VARCHAR (200) NULL,
|
|
[RegionId] SMALLINT NOT NULL,
|
|
[CountryCode] VARCHAR (5) NOT NULL,
|
|
[CountrySymbol] CHAR (2) NOT NULL,
|
|
[NumCode] VARCHAR (10) NULL,
|
|
[PhonePrefix] VARCHAR (10) NULL,
|
|
[DisableCountryDate] DATETIME NULL,
|
|
[LanguageId] TINYINT NULL,
|
|
[IsRestricted] BIT CONSTRAINT [DF__Countries_IsRestricted] DEFAULT ((0)) NULL,
|
|
[InsertDate] DATETIME NULL,
|
|
[LastModifyDate] DATETIME NULL,
|
|
CONSTRAINT [PK__Countries] PRIMARY KEY CLUSTERED ([CountryId] ASC)
|
|
);
|
|
|