forked from cdzombak/Stuck
-
Notifications
You must be signed in to change notification settings - Fork 1
/
pgsql.sql
88 lines (80 loc) · 2.33 KB
/
pgsql.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
--- SQL Files for PostgreSQL
--- Constaints and specific types
--
-- Table structure for table ci_sessions
--
CREATE TABLE ci_sessions (
session_id varchar(40) NOT NULL default '0' PRIMARY KEY,
ip_address varchar(16) NOT NULL default '0',
user_agent varchar(50) NOT NULL,
last_activity int NOT NULL default '0' CHECK (last_activity>0) ,
session_data text NOT NULL,
user_data text NOT NULL
) ;
--
-- Table structure for table languages
--
CREATE TABLE languages (
code varchar(12) NOT NULL PRIMARY KEY,
description varchar(32) NOT NULL,
extension varchar(12) NOT NULL,
"isMain" int NOT NULL default '0'
) ;
--
-- 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 pastes (
id SERIAL NOT NULL PRIMARY KEY,
pid INTEGER NOT NULL,
title varchar(128) NOT NULL,
name varchar(64) NOT NULL,
lang varchar(32) NOT NULL,
private int NOT NULL,
paste text NOT NULL,
raw text NOT NULL,
filename varchar(132) NOT NULL,
created int NOT NULL,
expire int NOT NULL default '0',
toexpire int NOT NULL CHECK (toexpire> 0),
snipurl varchar(64) NOT NULL default '0',
replyto varchar(8) NOT NULL
) ;