m4NNn1uG

1use [master]
2	 
3	IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N'NewspaperAdsHandler_5')
4	    CREATE DATABASE [NewspaperAdsHandler_5]
5	else
6	    DROP DATABASE [NewspaperAdsHandler_5]
7	    CREATE DATABASE [NewspaperAdsHandler_5]
8	go
9	use [NewspaperAdsHandler_5]
10	 
11	create table AdCustomer
12	(
13	    AdCustomerID INT NOT NULL   PRIMARY KEY,
14	    Name_   varchar(40)     NOT NULL,
15	    Surname varchar(40) NOT NULL,
16	    PhoneNumber varchar(40),
17	    Email varchar(40) not null,
18	    CreditCardNumber varchar(40) not null ,
19	 
20	);
21	 
22	create table AdRedactor
23	(
24	    AdRedactorID INT NOT NULL   PRIMARY KEY,
25	    Name_   varchar(40)     NOT NULL,
26	    Surname varchar(40) NOT NULL,
27	    PhoneNumber varchar(40),
28	    Email varchar(40) not null,
29	    CreditCardNumber varchar(40) ,
30	);
31	 
32	create table OrderList
33	(
34	    OrderID INT NOT NULL    PRIMARY KEY,
35	    OrderAdsCount int ,
36	    AdRedactorID int REFERENCES AdRedactor(AdRedactorID ),
37	    AdCustomerID int REFERENCES AdCustomer(AdCustomerID ),
38	    OrderTime DateTime,
39	    OrderPrice int
40	);
41	 
42	create table AdsList
43	(
44	    AdID INT NOT NULL PRIMARY KEY,
45	    AdName varchar(40) Not null,
46	    AdPublicationDate DateTime ,
47	    AdPrice int,
48	    OrderID int REFERENCES OrderList(OrderID ),
49		AdsTextPrice int,
50		AdsHashtagsPrice int,
51		AdsImagesPrice int,
52		
53	);
54	 
55	create table AdsTextList
56	(
57	    AdsTextID INT NOT NULL PRIMARY KEY,
58	    AdID int  REFERENCES AdsList(AdID ),
59	    AdText Text,
60		FixedAdTextPrice int,
61	);
62	 
63	create table AdHashtagList
64	(
65	    AdHashtagID INT NOT NULL PRIMARY KEY,
66	    AdID int  REFERENCES AdsList(AdID ),
67	    HashtagName varchar(50),
68		FixedAdHashtagPrice int,
69	);
70/*	create table AdsTextTarif
71	(
72	    AdsTextTarifID INT NOT NULL PRIMARY KEY,
73	    AdTextID int REFERENCES AdsTextList(AdsTextID),
74	    EstimatedTextPrice Int,
75	);*/
76	 
77	create table AdsImageList
78	(
79	    AdImageID INT NOT NULL PRIMARY KEY,
80	    AdID int  REFERENCES AdsList(AdID ),
81	    Image_ Image,
82		FixedAdImagePrice int,
83	);
84	 
85/*	create table AdsImageTarif
86	(
87	 
88	 
89	    AdsImageTarifID INT NOT NULL PRIMARY KEY,
90	    AdID int  REFERENCES AdsList(AdID ),
91	    EstimatedAdImagesPrice Int,
92	);
93	create table AdHashtagList
94	(
95	    AdHashtagID INT NOT NULL PRIMARY KEY,
96	    AdID int  REFERENCES AdsList(AdID ),
97	    HashtagName varchar(50),
98	);
99	 
100	create table AdsHashtagTarif
101	(
102	    AdHashtagTarifID INT NOT NULL PRIMARY KEY,
103	    AdID int  REFERENCES AdsList(AdID ),
104	    EstimatedAdHashtagsPricePrice Int,
105	);*/