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

#
# 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
78
79
80
81
82
83
84
#
# 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,
  UNIQUE name (name),
  PRIMARY KEY (cid)
);

#
# Table structure for table 'channel'
#
Dries's avatar
   
Dries committed
85
DROP TABLE IF EXISTS channel;
Dries's avatar
 
Dries committed
86
87
88
89
90
91
92
93
94
95
96
97
98
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
99
100
101
#
# Table structure for table 'comments'
#
Dries's avatar
   
Dries committed
102
DROP TABLE IF EXISTS comments;
Dries's avatar
 
Dries committed
103
104
105
CREATE TABLE comments (
  cid int(6) DEFAULT '0' NOT NULL auto_increment,
  pid int(6) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
106
  lid int(6) DEFAULT '0' NOT NULL,
Dries's avatar
 
Dries committed
107
108
109
110
111
112
113
  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
114
  link varchar(16) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
115
116
  PRIMARY KEY (cid),
  KEY lid (lid)
Dries's avatar
 
Dries committed
117
118
);

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

Dries's avatar
   
Dries committed
130
131
132
#
# Table structure for table 'diaries'
#
Dries's avatar
   
Dries committed
133
DROP TABLE IF EXISTS diaries;
Dries's avatar
 
Dries committed
134
135
136
137
138
139
140
141
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
142
143
144
#
# Table structure for table 'headlines'
#
Dries's avatar
   
Dries committed
145
DROP TABLE IF EXISTS headlines;
Dries's avatar
 
Dries committed
146
147
148
149
150
151
152
153
154
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
155
156
157
#
# Table structure for table 'layout'
#
Dries's avatar
   
Dries committed
158
DROP TABLE IF EXISTS layout;
Dries's avatar
   
Dries committed
159
160
CREATE TABLE layout (
  user int(11) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
161
  block varchar(64) DEFAULT '' NOT NULL
Dries's avatar
   
Dries committed
162
163
);

Dries's avatar
   
Dries committed
164
165
166
#
# Table structure for table 'locales'
#
Dries's avatar
   
Dries committed
167
DROP TABLE IF EXISTS locales;
Dries's avatar
   
Dries committed
168
169
CREATE TABLE locales (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
Dries's avatar
Dries committed
170
  location varchar(128) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
171
172
173
174
175
176
177
178
179
  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
180
181
182
  PRIMARY KEY (id)
);

Dries's avatar
   
Dries committed
183
184
185
#
# Table structure for table 'modules'
#
Dries's avatar
   
Dries committed
186
DROP TABLE IF EXISTS modules;
Dries's avatar
   
Dries committed
187
188
189
190
191
CREATE TABLE modules (
  name varchar(64) DEFAULT '' NOT NULL,
  PRIMARY KEY (name)
);

Dries's avatar
   
Dries committed
192
193
194
#
# Table structure for table 'node'
#
Dries's avatar
   
Dries committed
195
196
197
198
199
200
201
202
203
204
205
206
207
DROP TABLE IF EXISTS node;
CREATE TABLE node (
  nid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  lid int(10) DEFAULT '0' NOT NULL,
  pid int(10) DEFAULT '0' NOT NULL,
  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
208
209
  cid int(10) unsigned DEFAULT '0' NOT NULL,
  tid int(10) unsigned DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
210
211
212
213
214
215
  KEY type (lid,type),
  KEY author (author),
  KEY title (title,type),
  PRIMARY KEY (nid)
);

Dries's avatar
   
Dries committed
216
217
218
#
# Table structure for table 'page'
#
Dries's avatar
   
Dries committed
219
220
221
222
223
224
225
226
227
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
228
229
230
231
232
233
234
235
236
#
# 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
237
238
);

Dries's avatar
   
Dries committed
239
240
241
#
# Table structure for table 'story'
#
Dries's avatar
   
Dries committed
242
243
244
245
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
246
  abstract text NOT NULL,
Dries's avatar
   
Dries committed
247
248
  body text NOT NULL,
  PRIMARY KEY (lid)
Dries's avatar
 
Dries committed
249
250
);

Dries's avatar
   
Dries committed
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
#
# 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,
  UNIQUE name (name),
  PRIMARY KEY (tid)
);

#
# Table structure for table 'users'
#
Dries's avatar
   
Dries committed
266
DROP TABLE IF EXISTS users;
Dries's avatar
 
Dries committed
267
268
269
270
271
272
273
274
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
275
276
  nodes tinyint(2) DEFAULT '10',
  mode tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
 
Dries committed
277
278
279
280
281
282
283
284
285
286
  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,
  history text NOT NULL,
  hash varchar(12) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
287
  timezone varchar(8),
Dries's avatar
   
Dries committed
288
  rating decimal(8,2),
Dries's avatar
   
Dries committed
289
290
  language char(2) DEFAULT '' NOT NULL,
  access varchar(255) DEFAULT '' NOT NULL,
Dries's avatar
 
Dries committed
291
292
293
  PRIMARY KEY (id)
);

Dries's avatar
   
Dries committed
294
295
296
#
# Table structure for table 'variable'
#
Dries's avatar
   
Dries committed
297
298
299
DROP TABLE IF EXISTS variable;
CREATE TABLE variable (
  name varchar(32) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
300
  value text NOT NULL,
Dries's avatar
   
Dries committed
301
302
303
  PRIMARY KEY (name)
);

Dries's avatar
   
Dries committed
304
305
306
#
# Table structure for table 'watchdog'
#
Dries's avatar
   
Dries committed
307
DROP TABLE IF EXISTS watchdog;
Dries's avatar
 
Dries committed
308
309
310
CREATE TABLE watchdog (
  id int(5) DEFAULT '0' NOT NULL auto_increment,
  user int(6) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
311
312
  type varchar(16) DEFAULT '' NOT NULL,
  link varchar(16) DEFAULT '' NOT NULL,
Dries's avatar
 
Dries committed
313
  message varchar(255) DEFAULT '' NOT NULL,
Dries's avatar
Dries committed
314
  location varchar(128) DEFAULT '' NOT NULL,
Dries's avatar
 
Dries committed
315
  hostname varchar(128) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
316
  timestamp int(11) DEFAULT '0' NOT NULL,
Dries's avatar
 
Dries committed
317
318
  PRIMARY KEY (id)
);
Dries's avatar
   
Dries committed
319