database.mysql 8.88 KB
Newer Older
Dries's avatar
   
Dries committed
1
2
3
4
# MySQL dump 7.1
#
# Host: localhost    Database: drop
#--------------------------------------------------------
Dries's avatar
   
Dries committed
5
# Server version  3.22.32
Dries's avatar
   
Dries committed
6
7
8
9

#
# Table structure for table 'access'
#
Dries's avatar
   
Dries committed
10
11
12
13
14
15
16
17
18
DROP TABLE IF EXISTS access;
CREATE TABLE access (
  id tinyint(10) DEFAULT '0' NOT NULL auto_increment,
  mask varchar(255) DEFAULT '' NOT NULL,
  type varchar(16) DEFAULT '' NOT NULL,
  reason text NOT NULL,
  UNIQUE mask (mask),
  PRIMARY KEY (id)
);
Dries's avatar
   
Dries committed
19

Dries's avatar
   
Dries committed
20
21
22
#
# Table structure for table 'blocks'
#
Dries's avatar
   
Dries committed
23
DROP TABLE IF EXISTS blocks;
Dries's avatar
   
Dries committed
24
25
26
27
CREATE TABLE blocks (
  name varchar(64) DEFAULT '' NOT NULL,
  module varchar(64) DEFAULT '' NOT NULL,
  offset tinyint(2) DEFAULT '0' NOT NULL,
Dries's avatar
Dries committed
28
  status tinyint(2) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
29
30
  weight tinyint(1) DEFAULT '0' NOT NULL,
  region tinyint(1) DEFAULT '0' NOT NULL,
31
  remove tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
32
33
34
  PRIMARY KEY (name)
);

Dries's avatar
   
Dries committed
35
36
37
#
# Table structure for table 'book'
#
Dries's avatar
   
Dries committed
38
39
40
41
42
43
44
45
46
47
48
DROP TABLE IF EXISTS book;
CREATE TABLE book (
  lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  nid int(10) unsigned DEFAULT '0' NOT NULL,
  body text NOT NULL,
  section int(10) DEFAULT '0' NOT NULL,
  parent int(10) DEFAULT '0' NOT NULL,
  weight tinyint(3) DEFAULT '0' NOT NULL,
  PRIMARY KEY (lid)
);

Dries's avatar
   
Dries committed
49
50
51
#
# Table structure for table 'boxes'
#
Dries's avatar
   
Dries committed
52
DROP TABLE IF EXISTS boxes;
Dries's avatar
   
Dries committed
53
54
55
56
57
58
59
60
61
62
63
64
CREATE TABLE boxes (
  id tinyint(4) DEFAULT '0' NOT NULL auto_increment,
  subject varchar(64) DEFAULT '' NOT NULL,
  content text,
  info varchar(128) DEFAULT '' NOT NULL,
  link varchar(128) DEFAULT '' NOT NULL,
  type tinyint(2) DEFAULT '0' NOT NULL,
  UNIQUE subject (subject),
  UNIQUE info (info),
  PRIMARY KEY (id)
);

Dries's avatar
   
Dries committed
65
66
67
68
69
70
71
72
73
74
75
76
77
#
# Table structure for table 'category'
#
DROP TABLE IF EXISTS category;
CREATE TABLE category (
  cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  name varchar(32) DEFAULT '' NOT NULL,
  type varchar(16) DEFAULT '' NOT NULL,
  post int(3) DEFAULT '0' NOT NULL,
  dump int(3) DEFAULT '0' NOT NULL,
  expire int(3) DEFAULT '0' NOT NULL,
  comment int(2) unsigned DEFAULT '0' NOT NULL,
  submission int(2) unsigned DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
78
  promote int(2) unsigned DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
79
80
81
82
83
84
85
  UNIQUE name (name),
  PRIMARY KEY (cid)
);

#
# Table structure for table 'channel'
#
Dries's avatar
   
Dries committed
86
DROP TABLE IF EXISTS channel;
Dries's avatar
 
Dries committed
87
88
89
90
91
92
93
94
95
96
97
98
99
CREATE TABLE channel (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  site varchar(255) DEFAULT '' NOT NULL,
  file varchar(255) DEFAULT '' NOT NULL,
  url varchar(255) DEFAULT '' NOT NULL,
  contact varchar(255) DEFAULT '',
  timestamp int(11),
  UNIQUE site (site),
  UNIQUE file (file),
  UNIQUE url (url),
  PRIMARY KEY (id)
);

Dries's avatar
   
Dries committed
100
101
102
#
# Table structure for table 'comments'
#
Dries's avatar
   
Dries committed
103
DROP TABLE IF EXISTS comments;
Dries's avatar
 
Dries committed
104
105
106
CREATE TABLE comments (
  cid int(6) DEFAULT '0' NOT NULL auto_increment,
  pid int(6) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
107
  lid int(6) DEFAULT '0' NOT NULL,
Dries's avatar
 
Dries committed
108
109
110
111
112
113
114
  author int(6) DEFAULT '0' NOT NULL,
  subject varchar(64) DEFAULT '' NOT NULL,
  comment text NOT NULL,
  hostname varchar(128) DEFAULT '' NOT NULL,
  timestamp int(11) DEFAULT '0' NOT NULL,
  score int(6) DEFAULT '0' NOT NULL,
  votes int(6) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
115
  link varchar(16) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
116
  users text NOT NULL,
Dries's avatar
   
Dries committed
117
118
  PRIMARY KEY (cid),
  KEY lid (lid)
Dries's avatar
 
Dries committed
119
120
);

Dries's avatar
   
Dries committed
121
122
123
#
# Table structure for table 'crons'
#
Dries's avatar
   
Dries committed
124
DROP TABLE IF EXISTS crons;
Dries's avatar
   
Dries committed
125
126
CREATE TABLE crons (
  module varchar(64) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
127
128
129
130
131
  scheduled int(11),
  timestamp int(11),
  PRIMARY KEY (module)
);

Dries's avatar
   
Dries committed
132
133
134
135
136
137
138
139
140
141
142
143
#
# Table structure for table 'cvs'
#
DROP TABLE IF EXISTS cvs;
CREATE TABLE cvs (
  user varchar(32) DEFAULT '' NOT NULL,
  files text,
  status int(2) DEFAULT '0' NOT NULL,
  message text,
  timestamp int(11) DEFAULT '0' NOT NULL
);

Dries's avatar
   
Dries committed
144
145
146
#
# Table structure for table 'diaries'
#
Dries's avatar
   
Dries committed
147
DROP TABLE IF EXISTS diaries;
Dries's avatar
 
Dries committed
148
149
150
151
152
153
154
155
CREATE TABLE diaries (
  id int(5) DEFAULT '0' NOT NULL auto_increment,
  author int(6) DEFAULT '0' NOT NULL,
  text text,
  timestamp int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id)
);

Dries's avatar
   
Dries committed
156
157
158
159
160
161
162
163
164
165
166
#
# Table structure for table 'forum'
#
DROP TABLE IF EXISTS forum;
CREATE TABLE forum (
  lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  nid int(10) unsigned DEFAULT '0' NOT NULL,
  body text NOT NULL,
  PRIMARY KEY (lid)
);

Dries's avatar
   
Dries committed
167
168
169
#
# Table structure for table 'headlines'
#
Dries's avatar
   
Dries committed
170
DROP TABLE IF EXISTS headlines;
Dries's avatar
 
Dries committed
171
172
173
174
175
176
177
178
179
CREATE TABLE headlines (
  id int(11) DEFAULT '0' NOT NULL,
  title varchar(255) DEFAULT '' NOT NULL,
  link varchar(255) DEFAULT '' NOT NULL,
  number int(3) DEFAULT '0' NOT NULL,
  UNIQUE title (title),
  UNIQUE link (link)
);

Dries's avatar
   
Dries committed
180
181
182
#
# Table structure for table 'layout'
#
Dries's avatar
   
Dries committed
183
DROP TABLE IF EXISTS layout;
Dries's avatar
   
Dries committed
184
185
CREATE TABLE layout (
  user int(11) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
186
  block varchar(64) DEFAULT '' NOT NULL
Dries's avatar
   
Dries committed
187
188
);

Dries's avatar
   
Dries committed
189
190
191
#
# Table structure for table 'locales'
#
Dries's avatar
   
Dries committed
192
DROP TABLE IF EXISTS locales;
Dries's avatar
   
Dries committed
193
194
CREATE TABLE locales (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
Dries's avatar
Dries committed
195
  location varchar(128) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
196
197
198
199
200
201
202
203
204
  string text NOT NULL,
  da text NOT NULL,
  fi text NOT NULL,
  fr text NOT NULL,
  en text NOT NULL,
  es text NOT NULL,
  nl text NOT NULL,
  no text NOT NULL,
  sw text NOT NULL,
Dries's avatar
   
Dries committed
205
206
207
  PRIMARY KEY (id)
);

Dries's avatar
   
Dries committed
208
209
210
#
# Table structure for table 'modules'
#
Dries's avatar
   
Dries committed
211
DROP TABLE IF EXISTS modules;
Dries's avatar
   
Dries committed
212
213
214
215
216
CREATE TABLE modules (
  name varchar(64) DEFAULT '' NOT NULL,
  PRIMARY KEY (name)
);

Dries's avatar
   
Dries committed
217
218
219
#
# Table structure for table 'node'
#
Dries's avatar
   
Dries committed
220
221
222
DROP TABLE IF EXISTS node;
CREATE TABLE node (
  nid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
Dries's avatar
   
Dries committed
223
224
  lid int(10) DEFAULT '0' NOT NULL,
  pid int(10) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
225
226
227
228
229
230
231
232
  log text NOT NULL,
  type varchar(16) DEFAULT '' NOT NULL,
  title varchar(128) DEFAULT '' NOT NULL,
  score int(11) DEFAULT '0' NOT NULL,
  votes int(11) DEFAULT '0' NOT NULL,
  author int(6) DEFAULT '0' NOT NULL,
  status int(4) DEFAULT '1' NOT NULL,
  timestamp int(11) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
233
234
235
236
237
238
  cid int(10) unsigned DEFAULT '0' NOT NULL,
  tid int(10) unsigned DEFAULT '0' NOT NULL,
  comment int(2) DEFAULT '1' NOT NULL,
  promote int(2) DEFAULT '1' NOT NULL,
  moderate text NOT NULL,
  users text NOT NULL,
Dries's avatar
   
Dries committed
239
240
241
  KEY type (lid,type),
  KEY author (author),
  KEY title (title,type),
Dries's avatar
   
Dries committed
242
243
244
  PRIMARY KEY (nid),
  KEY promote (promote),
  KEY status (status)
Dries's avatar
   
Dries committed
245
246
);

Dries's avatar
   
Dries committed
247
248
249
#
# Table structure for table 'page'
#
Dries's avatar
   
Dries committed
250
251
252
253
254
255
256
257
258
DROP TABLE IF EXISTS page;
CREATE TABLE page (
  lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  nid int(10) unsigned DEFAULT '0' NOT NULL,
  body text NOT NULL,
  format tinyint(2) DEFAULT '0' NOT NULL,
  PRIMARY KEY (lid)
);

Dries's avatar
   
Dries committed
259
260
261
262
263
264
265
266
267
#
# Table structure for table 'rating'
#
DROP TABLE IF EXISTS rating;
CREATE TABLE rating (
  user int(6) DEFAULT '0' NOT NULL,
  new int(6) DEFAULT '0' NOT NULL,
  old int(6) DEFAULT '0' NOT NULL,
  PRIMARY KEY (user)
Dries's avatar
Dries committed
268
269
);

Dries's avatar
   
Dries committed
270
271
272
#
# Table structure for table 'story'
#
Dries's avatar
   
Dries committed
273
274
275
276
DROP TABLE IF EXISTS story;
CREATE TABLE story (
  lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  nid int(10) unsigned DEFAULT '0' NOT NULL,
Dries's avatar
 
Dries committed
277
  abstract text NOT NULL,
Dries's avatar
   
Dries committed
278
279
  body text NOT NULL,
  PRIMARY KEY (lid)
Dries's avatar
 
Dries committed
280
281
);

Dries's avatar
   
Dries committed
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
#
# Table structure for table 'testac'
#
DROP TABLE IF EXISTS testac;
CREATE TABLE testac (
  object_id int(11),
  object_title varchar(64)
);

#
# Table structure for table 'testad'
#
DROP TABLE IF EXISTS testad;
CREATE TABLE testad (
  object_id int(11),
  object_title varchar(64)
);

#
# Table structure for table 'testae'
#
DROP TABLE IF EXISTS testae;
CREATE TABLE testae (
  object_id int(11),
  object_title varchar(64)
);

Dries's avatar
   
Dries committed
309
310
311
312
313
314
315
316
#
# Table structure for table 'topic'
#
DROP TABLE IF EXISTS topic;
CREATE TABLE topic (
  tid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  pid int(10) unsigned DEFAULT '0' NOT NULL,
  name varchar(32) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
317
  moderate text NOT NULL,
Dries's avatar
   
Dries committed
318
319
320
321
322
323
324
  UNIQUE name (name),
  PRIMARY KEY (tid)
);

#
# Table structure for table 'users'
#
Dries's avatar
   
Dries committed
325
DROP TABLE IF EXISTS users;
Dries's avatar
 
Dries committed
326
327
328
329
330
331
332
333
CREATE TABLE users (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  name varchar(60) DEFAULT '' NOT NULL,
  userid varchar(15) DEFAULT '' NOT NULL,
  passwd varchar(20) DEFAULT '' NOT NULL,
  real_email varchar(60) DEFAULT '' NOT NULL,
  fake_email varchar(60) DEFAULT '' NOT NULL,
  url varchar(100) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
334
335
  nodes tinyint(2) DEFAULT '10',
  mode tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
 
Dries committed
336
337
338
339
340
341
342
343
344
  sort tinyint(1) DEFAULT '0',
  threshold tinyint(1) DEFAULT '0',
  bio tinytext NOT NULL,
  theme varchar(255) DEFAULT '' NOT NULL,
  signature varchar(255) DEFAULT '' NOT NULL,
  last_access int(10) unsigned,
  last_host varchar(255),
  status tinyint(4) DEFAULT '0' NOT NULL,
  hash varchar(12) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
345
  timezone varchar(8),
Dries's avatar
   
Dries committed
346
  rating decimal(8,2),
Dries's avatar
   
Dries committed
347
348
  language char(2) DEFAULT '' NOT NULL,
  access varchar(255) DEFAULT '' NOT NULL,
Dries's avatar
 
Dries committed
349
350
351
  PRIMARY KEY (id)
);

Dries's avatar
   
Dries committed
352
353
354
#
# Table structure for table 'variable'
#
Dries's avatar
   
Dries committed
355
356
357
DROP TABLE IF EXISTS variable;
CREATE TABLE variable (
  name varchar(32) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
358
  value text NOT NULL,
Dries's avatar
   
Dries committed
359
360
361
  PRIMARY KEY (name)
);

Dries's avatar
   
Dries committed
362
363
364
#
# Table structure for table 'watchdog'
#
Dries's avatar
   
Dries committed
365
DROP TABLE IF EXISTS watchdog;
Dries's avatar
 
Dries committed
366
367
368
CREATE TABLE watchdog (
  id int(5) DEFAULT '0' NOT NULL auto_increment,
  user int(6) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
369
370
  type varchar(16) DEFAULT '' NOT NULL,
  link varchar(16) DEFAULT '' NOT NULL,
Dries's avatar
 
Dries committed
371
  message varchar(255) DEFAULT '' NOT NULL,
Dries's avatar
Dries committed
372
  location varchar(128) DEFAULT '' NOT NULL,
Dries's avatar
 
Dries committed
373
  hostname varchar(128) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
374
  timestamp int(11) DEFAULT '0' NOT NULL,
Dries's avatar
 
Dries committed
375
376
  PRIMARY KEY (id)
);
Dries's avatar
   
Dries committed
377