forked from das867/IVSystems
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathadditems.sql
More file actions
93 lines (86 loc) · 5.06 KB
/
additems.sql
File metadata and controls
93 lines (86 loc) · 5.06 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
89
90
91
92
93
/*id:DS.attr(),
price:DS.attr(),
name:DS.attr(),
lineitems:DS.hasMany('line-item'),
tags:DS.hasMany('item-tag'),
vendor_id:DS.belongsTo('vendor'),
brand:DS.belongsTo('brand'),
collects:DS.hasMany('item'),
//For Trades
trade:DS.attr('boolean'),
vol_num:DS.attr(),
Illustrators:DS.hasMany('illustrator'),
Writers:DS.hasMany('writer'),
quanity:DS.attr(),
bindingType:DS.attr(),
//For apparel
apparel:DS.attr('boolean'),
size:DS.attr(),
gender:DS.attr(),
//For Comics
comic:DS.attr('boolean'),
issue_num:DS.attr(),
includedIn:DS.hasMany('item'),
subscriptions:DS.hasMany('subscription_box'),
//For Figures
figure:DS.attr('boolean'),
figureType:DS.attr(),
materialType:DS.attr(),
//For games
game:DS.attr('boolean'),
gameType:DS.attr(),*/
/*Create Some Comics*/
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('838383904','4.00','Civil War',false,false,true,false,false,'1');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('393849302','5.00','Civil War',false,false,true,false,false,'2');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('857393948','4.00','Civil War',false,false,true,false,false,'3');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('398584940','3.50','Civil War',false,false,true,false,false,'4');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('867499494','6.00','Civil War',false,false,true,false,false,'5');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('486940868','3.00','Civil War',false,false,true,false,false,'6');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('485994838','5.67','Civil War',false,false,true,false,false,'7');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('484994983','4.46','Justice League',false,false,true,false,false,'1');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('000000001','6.48','The Dark Knight Returns',false,false,true,false,false,'1');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('000000002','6.48','The Dark Knight Returns',false,false,true,false,false,'2');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('000000003','6.48','The Dark Knight Returns',false,false,true,false,false,'3');
INSERT INTO item (id,price,name,trade,apparel,comic,figure,game,issue_num) VALUES ('000000004','6.48','The Dark Knight Returns',false,false,true,false,false,'4');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'Mark','Miller');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'Frank','Miller');
/*
INSERT INTO writer (id,first_name,last_name) VALUES (null,'','');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'','');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'','');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'','');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'','');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'','');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'','');
INSERT INTO writer (id,first_name,last_name) VALUES (null,'','');
*/
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'Steve','McNiven');
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'Klaus','Janson');
/*
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'','');
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'','');
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'','');
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'','');
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'','');
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'','');
INSERT INTO illustrator (id,first_name,last_name) VALUES (null,'','');
*/
/*illustrator_items__item_illustrators
id | varchar(255) for ITEMS
+-------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| illustrator_Items | int(11) | YES | | NULL | |
| item_Illustrators | varchar(255) | YES | | NULL | |
+-------------------+------------------+------+-----+---------+----------------+
*/
/*item_writers__writer_items
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| item_Writers | varchar(255) | YES | | NULL | |
| writer_Items | int(11) | YES | | NULL | |
+--------------+------------------+------+-----+---------+----------------+
*/