BS6E8eGv

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		[Id] uniqueidentifier NOT NULL ROWGUIDCOL CONSTRAINT [DF_SPLockerSize_Id] DEFAULT NewSequentialId() ,
38		-- PRIMARY KEY
39		[Size] tinyint NOT NULL,
40
41		CONSTRAINT [PK_SPLockerSize] PRIMARY KEY CLUSTERED ([Id])
42	);
43
44END;
45--- END SPLockerSize
46
47--------------------------------------------------------------------------------------------
48--- LBPro SOFTWARE SCRIPT SQL
49--- TABLE DEFINITION
50--- dbo.SPPricing - ##### DESCRIPTION #####
51--------------------------------------------------------------------------------------------
52IF db_name()<>'master' and
53	NOT EXISTS (	SELECT *
54	FROM information_schema.tables
55	WHERE table_name='SPPricing' AND table_type='BASE TABLE')
56BEGIN
57	Print 'Create table SPPricing';
58	CREATE TABLE [SPPricing]
59	(
60		[Id] uniqueidentifier NOT NULL ROWGUIDCOL CONSTRAINT [DF_SPPricing_Id] DEFAULT NewSequentialId() ,
61		[LocationId] uniqueidentifier NULL ,		
62		[IsEnabled] bit NOT NULL ,
63		[IsDeleted] bit NOT NULL ,
64		[DictPricingType] tinyint NULL ,
65		[ValidFrom] datetime2(7) NULL ,
66		[ValidTo] datetime2(7) NULL ,
67		[PriceNet] int NOT NULL,
68		[TaxRateId] uniqueidentifier NULL ,
69		[LockerSizeId] uniqueidentifier NOT NULL ,
70
71
72		CONSTRAINT [DF_SPPricing_Id] PRIMARY KEY CLUSTERED ([Id] ASC),
73		CONSTRAINT [FK_LocationId_SPLocation] FOREIGN KEY ([LocationId])  REFERENCES [SPLocation]([Id]) ,
74		CONSTRAINT [FK_TaxRateId_SPTaxRate] FOREIGN KEY ([TaxRateId])  REFERENCES [SPTaxRate]([Id]),
75		CONSTRAINT [FK_LockerSizeId_SPLockerSize] FOREIGN KEY ([LockerSizeId])  REFERENCES [SPLockerSize]([Id])
76	);
77
78END;
79--- END SPPricing