-
Notifications
You must be signed in to change notification settings - Fork 1
/
content.sql
214 lines (189 loc) · 7.74 KB
/
content.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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
# MySQL dump 7.1
#
# Host: localhost Database: dries
#--------------------------------------------------------
# Server version 3.22.32
#
# Table structure for table 'authors'
#
CREATE TABLE authors (
aid varchar(30) DEFAULT '' NOT NULL,
name varchar(50),
url varchar(60),
email varchar(60),
pwd varchar(12),
PRIMARY KEY (aid)
);
#
# Dumping data for table 'authors'
#
INSERT INTO authors VALUES ('Dries','God','http://www.buytaert.net/','[email protected]','pa55w0rd');
#
# Table structure for table 'blocks'
#
CREATE TABLE blocks (
id tinyint(4) DEFAULT '0' NOT NULL auto_increment,
author varchar(30),
title varchar(60),
content text,
PRIMARY KEY (id)
);
#
# Dumping data for table 'blocks'
#
#
# Table structure for table 'comments'
#
CREATE TABLE comments (
tid int(11) DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0',
sid int(11) DEFAULT '0',
date datetime,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60),
url varchar(60),
host_name varchar(60),
subject varchar(60) DEFAULT '' NOT NULL,
comment text NOT NULL,
score tinyint(4) DEFAULT '0' NOT NULL,
reason tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (tid)
);
#
# Dumping data for table 'comments'
#
INSERT INTO comments VALUES (1,0,9,'2000-05-03 20:47:54','','','','127.0.0.1','Re: my subject','my reply',0,2);
#
# Table structure for table 'poll'
#
CREATE TABLE poll (
id int(11) DEFAULT '0' NOT NULL auto_increment,
question varchar(150),
answer1 varchar(100),
answer2 varchar(100),
answer3 varchar(100),
answer4 varchar(100),
answer5 varchar(100),
answer6 varchar(100),
votes1 tinyint(4),
votes2 tinyint(4),
votes3 tinyint(4),
votes4 tinyint(4),
votes5 tinyint(4),
votes6 tinyint(4),
status tinyint(4) DEFAULT '0',
PRIMARY KEY (id)
);
#
# Dumping data for table 'poll'
#
INSERT INTO poll VALUES (8,'What chips do you prefer?','Mama Mia\'s','Doritos','Chipsletten','Hula Hoops','Pepper n\' Salt','Regular salt',NULL,0,0,0,0,NULL,0);
INSERT INTO poll VALUES (3,'My favorite puppet is?','Kermit','Miss Piggy','Gonzo','Dr. Teeth','UnConeD','',0,0,1,NULL,5,NULL,0);
INSERT INTO poll VALUES (4,'I eat my waffles ...','in fork sized pieces','one square at the time','one huge bite','on a train','I hate waffles','huh?',1,3,9,1,NULL,NULL,0);
INSERT INTO poll VALUES (9,'Fear leads to anger, anger leads to hate, and hate leads to ...','war','revolution','suffering','migraine','alcohol abuse','',NULL,1,1,2,2,NULL,0);
INSERT INTO poll VALUES (10,'Fear leads to anger, anger leads to hate, and hate leads to ...','war','revolution','suffering','migraine','alcohol abuse','',NULL,1,4,3,5,NULL,1);
#
# Table structure for table 'queue'
#
CREATE TABLE queue (
qid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
uid mediumint(9) DEFAULT '0' NOT NULL,
uname varchar(40) DEFAULT '' NOT NULL,
subject varchar(100) DEFAULT '' NOT NULL,
article text,
timestamp int(11),
category varchar(64),
abstract text,
value int(11),
votes int(11),
PRIMARY KEY (qid)
);
#
# Dumping data for table 'queue'
#
#
# Table structure for table 'refer'
#
CREATE TABLE refer (
url varchar(255) DEFAULT '' NOT NULL,
name varchar(255),
status int(1) DEFAULT '1',
refers int(7) DEFAULT '0',
create_dt int(11),
access_dt int(11),
PRIMARY KEY (url)
);
#
# Dumping data for table 'refer'
#
INSERT INTO refer VALUES ('http://www.buytaert.net/','buytaert.net',1,42,NULL,NULL);
INSERT INTO refer VALUES ('http://www.atlantis.lan/','',1,7,955955129,955957398);
#
# Table structure for table 'stories'
#
CREATE TABLE stories (
sid int(11) DEFAULT '0' NOT NULL auto_increment,
aid varchar(30) DEFAULT '' NOT NULL,
subject varchar(255),
time int(11),
abstract text,
comments text,
article text,
category varchar(128),
informant varchar(20) DEFAULT '' NOT NULL,
department varchar(128),
PRIMARY KEY (sid)
);
#
# Dumping data for table 'stories'
#
INSERT INTO stories VALUES (9,'Dries','my subject',957369475,'my abstract','an acoomenttenjejee','my full story','Announcements','','we-added-a-department');
INSERT INTO stories VALUES (6,'Dries','test subject',957298138,'a story','editor\'s note','article','Space','','cool');
INSERT INTO stories VALUES (7,'Dries','now as a logged on user',957298203,'storietje','cool story','article','Gaming','Dries','beta-test');
INSERT INTO stories VALUES (8,'Dries','a real story',957301647,'abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract abstract ','','story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story story','Girls','','');
INSERT INTO stories VALUES (10,'Dries','no article, just an abstract',957369541,'lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala lala','','','Announcements','','huh-huh-huh-huh');
#
# Table structure for table 'users'
#
CREATE TABLE users (
uid int(11) DEFAULT '0' NOT NULL auto_increment,
name varchar(60) DEFAULT '' NOT NULL,
uname varchar(15) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
femail varchar(60) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
pass varchar(20) DEFAULT '' NOT NULL,
storynum tinyint(4) DEFAULT '10' NOT NULL,
umode varchar(10) DEFAULT '' NOT NULL,
uorder tinyint(1) DEFAULT '0' NOT NULL,
thold tinyint(1) DEFAULT '0' NOT NULL,
noscore tinyint(1) DEFAULT '0' NOT NULL,
bio tinytext NOT NULL,
ublockon tinyint(1) DEFAULT '0' NOT NULL,
ublock text,
theme varchar(255) DEFAULT '' NOT NULL,
signature varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid)
);
#
# Dumping data for table 'users'
#
INSERT INTO users VALUES (1,'D. Buytaert','Dries','[email protected]','grmbl_at_buytaert.net','http://www.buytaert.net/','pa55w0rd',8,'threaded',2,-1,0,'Information highways will make a greater impact on society then railways, electronic power and telephone!\r\n<BR>\r\n20, male, Antwerp, undergaduate CS at University of Antwerp\r\n',1,'<LI><A HREF=\"http://www.slashdot.org/\">slashdot.org</A></LI>\r\n<LI><A HREF=\"http://www.freshmeat.net/\">freshmeat.net</A></LI>\r\n<LI><A HREF=\"http://www.linux.com/\">linux.com</A></LI>\r\n<LI><A HREF=\"http://www.themes.org/\">themes.org</A></LI>\r\n<HR>\r\n<LI><A HREF=\"http://projectx.mx.dk/\">ProjectX</A></LI>\r\n<LI><A HREF=\"http://www.mirc.net/\">mIRC.net</A></LI>\r\n<LI><A HREF=\"http://www.irc-scripts.com/\">irc-scripts.com</A></LI>','starlight','-- Dries\r\n\r\n--\r\nI would hate to die.');
INSERT INTO users VALUES (2,'','dummy','[email protected]','dummy_at_fakeuser.com','http://www.fake.com/','javahack',10,'threaded',0,0,0,'I\'m a fake user created for testing purpose! =)',0,'','','Pfft. I\'m fake but so what?');
#
# Table structure for table 'webboard'
#
CREATE TABLE webboard (
topic_id int(11) DEFAULT '0' NOT NULL auto_increment,
parent_id int(11) DEFAULT '0',
root_id int(11) DEFAULT '0',
subject varchar(255),
message text,
create_dt int(11) DEFAULT '0',
author varchar(255),
hostname varchar(255),
PRIMARY KEY (topic_id)
);
#
# Dumping data for table 'webboard'
#