-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathscript.sql
More file actions
88 lines (83 loc) · 6.7 KB
/
Copy pathscript.sql
File metadata and controls
88 lines (83 loc) · 6.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
insert into MemberLevel values(1,'A',1);
insert into MemberLevel values(2,'B',2);
insert into MemberLevel values(3,'C',3);
insert into Coffee values(1,'Promoted','Description',1, 2, 1, 1);
insert into Coffee values(1,'NonPromoted','Description',1, 2, 1, 1);
insert into Store values(1,'StoreName_Test','StoreAddressTest','TestType',0,0);
insert into Store values(1,'StoreName_Test','StoreAddressTest','TestType',1,1);
insert into Store values(1,'StoreName_Test','StoreAddressTest','TestType',2,2);
insert into Promotion values(1,'Test_Promotion',to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'), to_date('28-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS') );
insert into HasPromotion values(1,1);
insert into PromoteFor values(1,1);
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',2,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Customer values(1,'First Name','LastName','Email',3,'0');
insert into Purchase values(1,1,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,2,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,3,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,4,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,5,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,6,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,7,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,8,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,9,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,10,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,11,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,12,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,13,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,14,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,15,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,16,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,17,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,18,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,19,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,10,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,11,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,12,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,13,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,14,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,15,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,16,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,17,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,18,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,19,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,10,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,11,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,12,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,13,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,14,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,15,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,16,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,17,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,18,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,19,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,10,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,11,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,12,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,13,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,14,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,15,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,16,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,17,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,18,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,19,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into Purchase values(1,10,1,to_date('24-FEB-2015 7:00:00','DD-MON-YYYY HH24:MI:SS'));
insert into BuyCoffee values(1,1,10,10);
insert into BUYCOFFEE values(2,2,3,1);