34 lines
1010 B
Transact-SQL
34 lines
1010 B
Transact-SQL
USE AW_Marketing
|
|
GO
|
|
|
|
-- Óäàëèòü òàáëèöû åñëè îíè óæå ñóùåñòâóþò
|
|
IF EXISTS (SELECT * FROM sys.tables t
|
|
JOIN sys.schemas s ON t.schema_id = s.schema_id
|
|
WHERE t.[Name] = 'SpecialOffers'
|
|
AND s.[Name] = 'Promotions')
|
|
DROP TABLE Promotions.SpecialOffers
|
|
|
|
IF EXISTS (SELECT * FROM sys.tables t
|
|
JOIN sys.schemas s ON t.schema_id = s.schema_id
|
|
WHERE t.[Name] = 'SpecialOffers'
|
|
AND s.[Name] = 'PastPromotions')
|
|
DROP TABLE PastPromotions.SpecialOffers
|
|
GO
|
|
|
|
|
|
-- Ñîçäàòü òàáëèöó äëÿ ñïåöèàëüíûõ ïðåäëîæåíèé. Íå óêàçàíî filegroup
|
|
CREATE TABLE Promotions.SpecialOffers
|
|
(OfferID int IDENTITY PRIMARY KEY,
|
|
Description nvarchar(200),
|
|
StartDate datetime,
|
|
EndDate datetime,
|
|
DiscountPercent decimal)
|
|
|
|
-- Ñîçäàòü òàáëèöó äëÿ àðõèâíûõ ïðåäëîæåíèÿ ïî ArchivedData filegroup
|
|
CREATE TABLE PastPromotions.SpecialOffers
|
|
(OfferID int IDENTITY PRIMARY KEY,
|
|
Description nvarchar(200),
|
|
StartDate datetime,
|
|
EndDate datetime,
|
|
DiscountPercent decimal)
|
|
ON ArchivedData |