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
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
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
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
|
# 01/04/2001:
CREATE TABLE access (
id tinyint(10) DEFAULT '0' NOT NULL auto_increment,
mask varchar(255) DEFAULT '' NOT NULL,
reason text NOT NULL,
UNIQUE mask (mask),
PRIMARY KEY (id)
);
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)
);
CREATE TABLE story (
lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
nid int(10) unsigned DEFAULT '0' NOT NULL,
abstract text NOT NULL,
body text NOT NULL,
section varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (lid)
);
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) NOT NULL,
KEY type (lid, type),
KEY author (author),
KEY title (title, type),
PRIMARY KEY (nid)
);
alter table users change stories nodes tinyint(2) DEFAULT '10';
alter table comments drop link;
# 07/04/2001:
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)
);
CREATE TABLE variable (
name varchar(32) DEFAULT '' NOT NULL,
value text DEFAULT '' NOT NULL,
PRIMARY KEY (name)
);
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)
);
CREATE TABLE watchdog (
id int(5) DEFAULT '0' NOT NULL auto_increment,
user int(6) DEFAULT '0' NOT NULL,
type varchar(16) DEFAULT '' NOT NULL,
link varchar(16) DEFAULT '' NOT NULL,
message varchar(255) DEFAULT '' NOT NULL,
location varchar(128) DEFAULT '' NOT NULL,
hostname varchar(128) DEFAULT '' NOT NULL,
timestamp int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
ALTER TABLE users CHANGE rating rating decimal(8,2);
# 14/04/2001:
ALTER TABLE node ADD cid int(10) unsigned DEFAULT '0' NOT NULL;
ALTER TABLE node ADD tid int(10) unsigned DEFAULT '0' NOT NULL;
ALTER TABLE story DROP section;
ALTER TABLE comments ADD KEY(lid);
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),
PRIMARY KEY (cid)
);
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),
PRIMARY KEY (tid)
);
# 19/04/2001:
ALTER TABLE node ADD comment int(2) DEFAULT '1' NOT NULL;
ALTER TABLE node ADD promote int(2) DEFAULT '1' NOT NULL;
ALTER TABLE category ADD promote int(2) unsigned DEFAULT '0' NOT NULL;
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
);
# 27/04/2001:
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)
);
# 01/05/2001:
ALTER TABLE node ADD moderate TEXT NOT NULL;
# 10/05/2001:
ALTER TABLE topic ADD moderate TEXT NOT NULL;
# 16/05/2001
ALTER TABLE node ADD users TEXT NOT NULL;
ALTER TABLE comments ADD users TEXT NOT NULL;
ALTER TABLE users DROP history;
# 19/05/2001
DROP TABLE crons;
# 25/05/2001 - TEMPORARY - UNDER HEAVY CHANGE -
CREATE TABLE entry (
eid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
name varchar(32) DEFAULT '' NOT NULL,
keyword varchar(255) DEFAULT '' NOT NULL,
collection varchar(32) DEFAULT '' NOT NULL,
UNIQUE name (name, collection),
PRIMARY KEY (eid)
);
CREATE TABLE bundle (
bid int(11) DEFAULT '0' NOT NULL auto_increment,
title varchar(255) DEFAULT '' NOT NULL,
attribute varchar(255) DEFAULT '' NOT NULL,
UNIQUE (title),
PRIMARY KEY (bid)
);
CREATE TABLE feed (
fid int(11) DEFAULT '0' NOT NULL auto_increment,
title varchar(255) DEFAULT '' NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
link varchar(255) DEFAULT '' NOT NULL,
refresh int(11),
uncache int(11),
timestamp int(11),
attribute varchar(255) DEFAULT '' NOT NULL,
UNIQUE (title),
UNIQUE (link),
PRIMARY KEY (fid)
);
CREATE TABLE item (
iid int(11) DEFAULT '0' NOT NULL auto_increment,
fid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
link varchar(255) DEFAULT '' NOT NULL,
author varchar(255) DEFAULT '' NOT NULL,
description TEXT DEFAULT '' NOT NULL,
timestamp int(11),
attribute varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (iid)
);
# 31/05/01
CREATE TABLE poll (
lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
nid int(10) unsigned DEFAULT '0' NOT NULL,
runtime int(10) DEFAULT '0' NOT NULL,
voters text NOT NULL,
active int(2) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (lid)
);
CREATE TABLE poll_choices (
chid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
nid int(10) unsigned DEFAULT '0' NOT NULL,
chtext varchar(128) DEFAULT '' NOT NULL,
chvotes int(6) DEFAULT '0' NOT NULL,
chorder int(2) DEFAULT '0' NOT NULL,
PRIMARY KEY (chid)
);
# 04/06/01
ALTER TABLE node ADD timestamp_posted int(11) NOT NULL;
ALTER TABLE node ADD timestamp_queued int(11) NOT NULL;
ALTER TABLE node ADD timestamp_hidden int(11) NOT NULL;
ALTER TABLE node ADD attribute varchar(255) DEFAULT '' NOT NULL;
# 10/06/01
ALTER TABLE node DROP cid;
ALTER TABLE node DROP tid;
# 11/06/01
UPDATE users SET access = REPLACE(access, ':', '=');
UPDATE users SET access = REPLACE(access, ';', ',');
UPDATE comments SET users = REPLACE(users, ';', ',');
UPDATE comments SET users = REPLACE(users, ':', '=');
UPDATE node SET users = REPLACE(users, ';', ',');
UPDATE node SET users = REPLACE(users, ':', '=');
UPDATE node SET attributes = REPLACE(attributes, ';', ',');
UPDATE node SET attributes = REPLACE(attributes, ':', '=');
UPDATE entry SET attributes = REPLACE(attributes, ';', ',');
UPDATE entry SET attributes = REPLACE(attributes, ':', '=');
ALTER TABLE entry CHANGE keyword attributes varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE node CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE bundle CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE feed CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE item CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL;
# 12/06/01
ALTER TABLE watchdog DROP link;
# 15/06/01
CREATE TABLE tag (
tid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
name varchar(32) DEFAULT '' NOT NULL,
attributes varchar(255) DEFAULT '' NOT NULL,
collections varchar(32) DEFAULT '' NOT NULL,
UNIQUE name (name, collections),
PRIMARY KEY (tid)
);
CREATE TABLE collection (
cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
name varchar(32) DEFAULT '' NOT NULL,
types varchar(128) DEFAULT '' NOT NULL,
UNIQUE name (name),
PRIMARY KEY (cid)
);
# 17/06/01
ALTER TABLE book ADD pid int(10) DEFAULT '0' NOT NULL;
ALTER TABLE book ADD log text NOT NULL;
ALTER TABLE node DROP pid;
ALTER TABLE node DROP log;
DROP TABLE headlines;
# 20/06/01
CREATE TABLE role (
rid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
name varchar(32) DEFAULT '' NOT NULL,
perm text DEFAULT '' NOT NULL,
UNIQUE name (name),
PRIMARY KEY (rid)
);
ALTER TABLE users ADD role varchar(32) DEFAULT '' NOT NULL;
ALTER TABLE users DROP access;
UPDATE users SET role = 'authenticated user';
# 23/06/01
ALTER TABLE users CHANGE userid userid VARCHAR(32) DEFAULT '' NOT NULL;
# 24/06/01
CREATE TABLE referer (
url varchar(255) DEFAULT '' NOT NULL,
timestamp int(11) NOT NULL
);
# 30/06/01
ALTER TABLE boxes CHANGE subject title varchar(64) DEFAULT '' NOT NULL;
ALTER TABLE boxes CHANGE content body TEXT;
ALTER TABLE boxes CHANGE id bid tinyint(4) DEFAULT '0' NOT NULL auto_increment;
CREATE TABLE cache (
url varchar(255) DEFAULT '' NOT NULL,
data text NOT NULL,
timestamp int(11) NOT NULL,
PRIMARY KEY (url)
);
# 08/06/01
CREATE TABLE site (
sid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
title varchar(128) DEFAULT '' NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
size text NOT NULL,
timestamp int(11) NOT NULL,
UNIQUE (title),
UNIQUE (url),
PRIMARY KEY (sid)
);
# 09/06/01
ALTER TABLE feed CHANGE link url varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE feed ADD link varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE feed ADD description TEXT DEFAULT '' NOT NULL;
# 12/06/01
CREATE TABLE blog (
lid int(10) unsigned NOT NULL auto_increment,
nid int(10) unsigned NOT NULL,
body text NOT NULL,
PRIMARY KEY (lid)
);
#13/06/01
ALTER TABLE site CHANGE title name varchar(128) DEFAULT '' NOT NULL;
ALTER TABLE site CHANGE url link varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE site ADD feed varchar(255) DEFAULT '' NOT NULL;
#17/06/01
ALTER TABLE page ADD link varchar(128) DEFAULT '' NOT NULL AFTER nid;
#09/08/01
ALTER TABLE users ADD UNIQUE name (name);
ALTER TABLE users ADD UNIQUE userid (userid);
ALTER TABLE users ADD UNIQUE real_email (real_email);
UPDATE users SET name = userid WHERE name = '';
|
