· 8 years ago · Jul 10, 2018, 11:24 PM
1
2
3# Dump of table users
4# ------------------------------------------------------------
5
6DROP TABLE IF EXISTS `users`;
7
8CREATE TABLE `users` (
9 `id` int(11) NOT NULL AUTO_INCREMENT,
10 `nickname` varchar(40) NOT NULL,
11 `email` varchar(255) NOT NULL,
12 `password` varchar(20) NOT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=utf8;
15
16
17
18# Dump of table worksheet_columns
19# ------------------------------------------------------------
20
21DROP TABLE IF EXISTS `worksheet_columns`;
22
23CREATE TABLE `worksheet_columns` (
24 `id` int(11) NOT NULL AUTO_INCREMENT,
25 `worksheet_id` int(11) DEFAULT NULL,
26 `label` text,
27 `order` int(4) DEFAULT NULL,
28 PRIMARY KEY (`id`)
29) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
30
31LOCK TABLES `worksheet_columns` WRITE;
32/*!40000 ALTER TABLE `worksheet_columns` DISABLE KEYS */;
33INSERT INTO `worksheet_columns` (`id`,`worksheet_id`,`label`,`order`)
34VALUES
35 (1,1,'Column 1',1),
36 (2,1,'Column 2',2),
37 (3,1,'Column 3',3),
38 (4,1,'Column 4',4),
39 (5,1,'Column 5',5),
40 (6,1,'Column 6',6);
41
42/*!40000 ALTER TABLE `worksheet_columns` ENABLE KEYS */;
43UNLOCK TABLES;
44
45
46# Dump of table worksheet_data
47# ------------------------------------------------------------
48
49DROP TABLE IF EXISTS `worksheet_data`;
50
51CREATE TABLE `worksheet_data` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `date` datetime NOT NULL,
54 `worksheet_id` int(11) NOT NULL,
55 `column_id` int(11) DEFAULT NULL,
56 `notes` text,
57 `rating` int(3) DEFAULT NULL,
58 PRIMARY KEY (`id`)
59) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
60
61LOCK TABLES `worksheet_data` WRITE;
62/*!40000 ALTER TABLE `worksheet_data` DISABLE KEYS */;
63INSERT INTO `worksheet_data` (`id`,`date`,`worksheet_id`,`column_id`,`notes`,`rating`)
64VALUES
65 (1,'2009-07-31 07:02:48',1,1,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. ',1),
66 (2,'2009-07-31 07:02:48',1,2,'Lorem ipsum dolor sit amet, consectetur adipiscing elit.',1),
67 (3,'2009-07-31 07:02:48',1,3,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. ',1),
68 (4,'2009-07-31 07:02:48',1,4,'Lorem ipsum dolor sit amet, consectetur adipiscing elit.',1),
69 (5,'2009-07-31 07:02:48',1,5,'Lorem ipsum dolor sit amet, consectetur adipiscing elit.',1),
70 (6,'2009-07-31 07:02:48',1,6,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. ',1);
71
72/*!40000 ALTER TABLE `worksheet_data` ENABLE KEYS */;
73UNLOCK TABLES;
74
75
76# Dump of table worksheets
77# ------------------------------------------------------------
78
79DROP TABLE IF EXISTS `worksheets`;
80
81CREATE TABLE `worksheets` (
82 `id` int(11) NOT NULL AUTO_INCREMENT,
83 `user_id` int(11) NOT NULL,
84 `title` varchar(255) NOT NULL,
85 PRIMARY KEY (`id`)
86) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
87
88LOCK TABLES `worksheets` WRITE;
89/*!40000 ALTER TABLE `worksheets` DISABLE KEYS */;
90INSERT INTO `worksheets` (`id`,`user_id`,`title`)
91VALUES
92 (1,0,'Test Worksheet');
93
94/*!40000 ALTER TABLE `worksheets` ENABLE KEYS */;
95UNLOCK TABLES;
96
97
98
99
100
101/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
102/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
103/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
104/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
105/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
106/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
107/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;