EvZTCCRG

1--------------------------------------------------------------------------------------------
2--- LBPro SOFTWARE SCRIPT SQL
3--- TABLE DEFINITION
4--- dbo.SPTaxRate - ##### DESCRIPTION #####
5--------------------------------------------------------------------------------------------
6IF db_name()<>'master' and
7	NOT EXISTS (	SELECT *
8	FROM information_schema.tables
9	WHERE table_name='SPTaxRate' AND table_type='BASE TABLE')
10BEGIN
11	Print 'Create table SPTaxRate';
12	CREATE TABLE [SPTaxRate]
13	(
14		[Id] uniqueidentifier NOT NULL ROWGUIDCOL CONSTRAINT [DF_SPTaxRate_Id] DEFAULT NewSequentialId() ,
15		-- PRIMARY KEY
16		[Value] int NOT NULL,
17
18		CONSTRAINT [DF_SPTaxRate_Id] PRIMARY KEY CLUSTERED ([Id] ASC)
19	);
20
21END;
22--- END SPTaxRate
23
24--------------------------------------------------------------------------------------------
25--- LBPro SOFTWARE SCRIPT SQL
26--- TABLE DEFINITION
27--- dbo.SPLockerSize - ##### DESCRIPTION #####
28--------------------------------------------------------------------------------------------
29IF db_name()<>'master' and
30	NOT EXISTS (	SELECT *
31	FROM information_schema.tables
32	WHERE table_name='SPLockerSize' AND table_type='BASE TABLE')
33BEGIN
34	Print 'Create table SPLockerSize';
35	CREATE TABLE [SPLockerSize]
36	(
37		[SizeId] BIGINT IDENTITY NOT FOR REPLICATION NOT NULL,
38		-- PRIMARY KEY
39		[PriceNet] int NOT NULL,
40		[Length] int NOT NULL,
41		[Width] int NOT NULL,
42		[Depth] int NOT NULL,
43
44		CONSTRAINT [PK_SPLockerSize] PRIMARY KEY CLUSTERED ([SizeId])
45	);
46
47END;
48--- END SPLockerSize
49
50--------------------------------------------------------------------------------------------
51--- LBPro SOFTWARE SCRIPT SQL
52--- TABLE DEFINITION
53--- dbo.SPPricing - ##### DESCRIPTION #####
54--------------------------------------------------------------------------------------------
55IF db_name()<>'master' and
56	NOT EXISTS (	SELECT *
57	FROM information_schema.tables
58	WHERE table_name='SPPricing' AND table_type='BASE TABLE')
59BEGIN
60	Print 'Create table SPPricing';
61	CREATE TABLE [SPPricing]
62	(
63		[Id] uniqueidentifier NOT NULL ROWGUIDCOL CONSTRAINT [DF_SPPricing_Id] DEFAULT NewSequentialId() ,
64		[LocationId] uniqueidentifier NULL ,		
65		[IsEnabled] bit NOT NULL ,
66		[IsDeleted] bit NOT NULL ,
67		[DictPricingType] tinyint NULL ,
68		[ValidFrom] datetime2(7) NULL ,
69		[ValidTo] datetime2(7) NULL ,
70		[TaxRateId] uniqueidentifier NULL ,
71		[LockerSizeId] uniqueidentifier NULL ,
72
73
74		CONSTRAINT [DF_SPPricing_Id] PRIMARY KEY CLUSTERED ([Id] ASC),
75		CONSTRAINT [FK_LocationId_SPLocation] FOREIGN KEY ([LocationId])  REFERENCES [SPLocation]([Id]) ,
76		CONSTRAINT [FK_TaxRateId_SPTaxRate] FOREIGN KEY ([TaxRateId])  REFERENCES [SPTaxRate]([Id]),
77		CONSTRAINT [FK_LockerSizeId_SPLockerSize] FOREIGN KEY ([LockerSizeId])  REFERENCES [SPLockerSize]([SizeId])
78	);
79
80END;
81--- END SPPricing