· 7 years ago · Oct 10, 2018, 03:42 PM
1IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp307_Reference]') AND type = 'D')
2BEGIN
3ALTER TABLE [dbo].[bcWLTmp307] DROP CONSTRAINT [DF_bcWLTmp307_Reference]
4END
5GO
6IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp307_ItemLookupCode]') AND type = 'D')
7BEGIN
8ALTER TABLE [dbo].[bcWLTmp307] DROP CONSTRAINT [DF_bcWLTmp307_ItemLookupCode]
9END
10GO
11IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp307_StoreID]') AND type = 'D')
12BEGIN
13ALTER TABLE [dbo].[bcWLTmp307] DROP CONSTRAINT [DF_bcWLTmp307_StoreID]
14END
15GO
16IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp307_Quantity]') AND type = 'D')
17BEGIN
18ALTER TABLE [dbo].[bcWLTmp307] DROP CONSTRAINT [DF_bcWLTmp307_Quantity]
19END
20GO
21IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bcWLTmp307]') AND type in (N'U'))
22DROP TABLE [dbo].[bcWLTmp307]
23GO
24IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp304Store_StoreID]') AND type = 'D')
25BEGIN
26ALTER TABLE [dbo].[bcWLTmp304Store] DROP CONSTRAINT [DF_bcWLTmp304Store_StoreID]
27END
28GO
29IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp304Store_ItemLookupCode]') AND type = 'D')
30BEGIN
31ALTER TABLE [dbo].[bcWLTmp304Store] DROP CONSTRAINT [DF_bcWLTmp304Store_ItemLookupCode]
32END
33GO
34IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp304Store_Price]') AND type = 'D')
35BEGIN
36ALTER TABLE [dbo].[bcWLTmp304Store] DROP CONSTRAINT [DF_bcWLTmp304Store_Price]
37END
38GO
39IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bcWLTmp304Store]') AND type in (N'U'))
40DROP TABLE [dbo].[bcWLTmp304Store]
41GO
42IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp304Master_StoreID]') AND type = 'D')
43BEGIN
44ALTER TABLE [dbo].[bcWLTmp304Master] DROP CONSTRAINT [DF_bcWLTmp304Master_StoreID]
45END
46GO
47IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp304Master_ItemLookupCode]') AND type = 'D')
48BEGIN
49ALTER TABLE [dbo].[bcWLTmp304Master] DROP CONSTRAINT [DF_bcWLTmp304Master_ItemLookupCode]
50END
51GO
52IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp304Master_Price]') AND type = 'D')
53BEGIN
54ALTER TABLE [dbo].[bcWLTmp304Master] DROP CONSTRAINT [DF_bcWLTmp304Master_Price]
55END
56GO
57IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bcWLTmp304Master]') AND type in (N'U'))
58DROP TABLE [dbo].[bcWLTmp304Master]
59GO
60IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_bcWLTmp250_ItemLookupCode]') AND type = 'D')
61BEGIN
62ALTER TABLE [dbo].[bcWLTmp250] DROP CONSTRAINT [DF_bcWLTmp250_ItemLookupCode]
63END
64GO
65IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bcWLTmp250]') AND type in (N'U'))
66DROP TABLE [dbo].[bcWLTmp250]
67GO
68SET ANSI_NULLS ON
69GO
70SET QUOTED_IDENTIFIER ON
71GO
72IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bcWLTmp250]') AND type in (N'U'))
73BEGIN
74CREATE TABLE [dbo].[bcWLTmp250](
75 [ID] [int] IDENTITY(1,1) NOT NULL,
76 [ItemLookupCode] [nvarchar](25) NOT NULL CONSTRAINT [DF_bcWLTmp250_ItemLookupCode] DEFAULT (''),
77 [UI] [uniqueidentifier] NULL,
78 CONSTRAINT [PK_bcWLTmp250] PRIMARY KEY CLUSTERED
79(
80 [ID] ASC
81)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
82) ON [PRIMARY]
83END
84GO
85SET ANSI_NULLS ON
86GO
87SET QUOTED_IDENTIFIER ON
88GO
89IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bcWLTmp304Master]') AND type in (N'U'))
90BEGIN
91CREATE TABLE [dbo].[bcWLTmp304Master](
92 [ID] [int] IDENTITY(1,1) NOT NULL,
93 [StoreID] [int] NOT NULL CONSTRAINT [DF_bcWLTmp304Master_StoreID] DEFAULT ((0)),
94 [ItemLookupCode] [nvarchar](25) NOT NULL CONSTRAINT [DF_bcWLTmp304Master_ItemLookupCode] DEFAULT (''),
95 [Price] [money] NOT NULL CONSTRAINT [DF_bcWLTmp304Master_Price] DEFAULT ((0.0)),
96 [UI] [uniqueidentifier] NULL,
97 CONSTRAINT [PK_bcWLTmp304Master] PRIMARY KEY CLUSTERED
98(
99 [ID] ASC
100)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
101) ON [PRIMARY]
102END
103GO
104SET ANSI_NULLS ON
105GO
106SET QUOTED_IDENTIFIER ON
107GO
108IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bcWLTmp304Store]') AND type in (N'U'))
109BEGIN
110CREATE TABLE [dbo].[bcWLTmp304Store](
111 [ID] [int] IDENTITY(1,1) NOT NULL,
112 [StoreID] [int] NOT NULL CONSTRAINT [DF_bcWLTmp304Store_StoreID] DEFAULT ((0)),
113 [ItemLookupCode] [nvarchar](25) NOT NULL CONSTRAINT [DF_bcWLTmp304Store_ItemLookupCode] DEFAULT (''),
114 [Price] [money] NOT NULL CONSTRAINT [DF_bcWLTmp304Store_Price] DEFAULT ((0.0)),
115 [UI] [uniqueidentifier] NULL,
116 CONSTRAINT [PK_bcWLTmp304Store] PRIMARY KEY CLUSTERED
117(
118 [ID] ASC
119)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
120) ON [PRIMARY]
121END
122GO
123SET ANSI_NULLS ON
124GO
125SET QUOTED_IDENTIFIER ON
126GO
127IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bcWLTmp307]') AND type in (N'U'))
128BEGIN
129CREATE TABLE [dbo].[bcWLTmp307](
130 [ID] [int] IDENTITY(1,1) NOT NULL,
131 [Reference] [nvarchar](25) NOT NULL CONSTRAINT [DF_bcWLTmp307_Reference] DEFAULT (''),
132 [ItemLookupCode] [nvarchar](25) NOT NULL CONSTRAINT [DF_bcWLTmp307_ItemLookupCode] DEFAULT (''),
133 [StoreID] [int] NOT NULL CONSTRAINT [DF_bcWLTmp307_StoreID] DEFAULT ((0)),
134 [Quantity] [float] NOT NULL CONSTRAINT [DF_bcWLTmp307_Quantity] DEFAULT ((0)),
135 [UI] [uniqueidentifier] NULL,
136 CONSTRAINT [PK_bcWLTmp307] PRIMARY KEY CLUSTERED
137(
138 [ID] ASC
139)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
140) ON [PRIMARY]
141END
142GO