forked from jsbin/jsbin
-
Notifications
You must be signed in to change notification settings - Fork 0
/
full-db-v3.mysql.sql
42 lines (40 loc) · 1.37 KB
/
full-db-v3.mysql.sql
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
CREATE TABLE IF NOT EXISTS `sandbox` (
`id` INT(11) NOT NULL auto_increment,
`javascript` TEXT NOT NULL DEFAULT '',
`html` TEXT NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`last_viewed` datetime DEFAULT NULL,
`url` VARCHAR(255) DEFAULT NULL,
`streaming` VARCHAR(1) DEFAULT 'n',
`streaming_key` VARCHAR(32) NOT NULL,
`streaming_read_key` VARCHAR(32) NOT NULL,
`active_tab` VARCHAR(10) NOT NULL,
`active_cursor` INT(11) NOT NULL,
`revision` INT(11) DEFAULT '1',
`css` TEXT NOT NULL DEFAULT '',
`settings` TEXT DEFAULT '',
PRIMARY KEY (`id`),
KEY `viewed` (`last_viewed`),
KEY `url` (`url`),
KEY `streaming_key` (`streaming_key`),
KEY `spam` (`created`,`last_viewed`),
KEY `revision` (`url`,`revision`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ownership` (
`name` VARCHAR(50) NOT NULL,
`key` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL DEFAULT '',
`last_login` datetime NOT NULL,
`created` datetime NOT NULL,
`updated` datetime NOT NULL,
PRIMARY KEY (`name`),
KEY `name_key` (`name`,`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `owners` (
`id` INT(11) NOT NULL auto_increment,
`name` VARCHAR(25) NOT NULL,
`url` VARCHAR(255) NOT NULL,
`revision` INT(11) DEFAULT '1',
PRIMARY KEY (`id`),
KEY `name_url` (`name`,`url`,`revision`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;