This repository has been archived by the owner on Jan 18, 2018. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
mysql.sql
95 lines (86 loc) · 3.41 KB
/
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
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
94
95
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Table structure for table `ci_sessions`
--
CREATE TABLE IF NOT EXISTS `ci_sessions` (
`session_id` varchar(40) character set utf8 NOT NULL default '0',
`ip_address` varchar(16) character set utf8 NOT NULL default '0',
`user_agent` varchar(50) character set utf8 NOT NULL,
`last_activity` int(10) unsigned NOT NULL default '0',
`session_data` text character set utf8 NOT NULL,
`user_data` text character set utf8 NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
--
-- Table structure for table `languages`
--
CREATE TABLE IF NOT EXISTS `languages` (
`code` varchar(12) character set utf8 collate utf8_general_ci NOT NULL,
`description` varchar(32) character set utf8 collate utf8_general_ci NOT NULL,
`extension` varchar(12) character set utf8 collate utf8_general_ci NOT NULL,
`isMain` tinyint(1) NOT NULL default '0',
KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
--
-- Data for table `languages`
--
INSERT INTO `languages` (`code`, `description`, `extension`, `isMain`) VALUES
('c', 'C', 'c', 1),
('css', 'CSS', 'css', 1),
('cpp', 'C++', 'cpp', 1),
('html4strict', 'HTML (4 Strict)', 'html', 0),
('java', 'Java', 'java', 0),
('perl', 'Perl', 'pl', 1),
('php', 'PHP', 'php', 1),
('python', 'Python', 'py', 1),
('ruby', 'Ruby', 'rb', 1),
('text', 'Plain Text', 'txt', 1),
('asm', 'ASM (Nasm Syntax)', 'asm', 0),
('xhtml', 'XHTML', 'html', 1),
('actionscript', 'Actionscript', 'actionscript', 0),
('apache', 'Apache Log', 'log', 0),
('applescript', 'AppleScript', 'applescript', 0),
('bash', 'Bash', 'sh', 1),
('c_mac', 'C for Macs', 'c', 0),
('csharp', 'C#', 'cs', 0),
('delphi', 'Delphi', 'pas', 0),
('fortran', 'Fortran', 'for', 0),
('inno', 'Inno Setup', 'iss', 0),
('java5', 'Java 5', 'java', 0),
('javascript', 'Javascript', 'js', 0),
('latex', 'LaTeX', 'latex', 0),
('mirc', 'mIRC Script', 'mrc', 0),
('mysql', 'MySQL', 'sql', 1),
('nsis', 'NSIS', 'nsi', 0),
('objc', 'Objective C', 'm', 0),
('orcale8', 'Orcale 8 SQL', 'sql', 0),
('pascal', 'Pascal', 'pas', 0),
('robots', 'robots.txt', 'txt', 0),
('sql', 'SQL', 'sql', 1),
('winbatch', 'Windows Batch', 'bat', 0),
('xml', 'XML', 'xml', 0),
('verilog', 'Verilog', 'v', 0);
--
-- Table structure for table `pastes`
--
CREATE TABLE IF NOT EXISTS `pastes` (
`id` int(10) NOT NULL auto_increment,
`pid` varchar(8) character set utf8 collate utf8_general_ci NOT NULL,
`title` varchar(128) character set utf8 collate utf8_general_ci NOT NULL,
`name` varchar(64) character set utf8 collate utf8_general_ci NOT NULL,
`lang` varchar(32) character set utf8 collate utf8_general_ci NOT NULL,
`private` tinyint(1) NOT NULL,
`paste` longtext character set utf8 collate utf8_general_ci NOT NULL,
`raw` longtext character set utf8 collate utf8_general_ci NOT NULL,
`filename` varchar(132) character set utf8 collate utf8_general_ci NOT NULL,
`created` int(10) NOT NULL,
`expire` int(10) NOT NULL default '0',
`toexpire` tinyint(1) unsigned NOT NULL,
`snipurl` varchar(64) character set utf8 collate utf8_general_ci NOT NULL default '0',
`replyto` varchar(8) character set utf8 collate utf8_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;