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
|
# 25/03/2001:
CREATE TABLE book (
id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
node 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 (id)
);
CREATE TABLE story (
id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
node int(10) unsigned DEFAULT '0' NOT NULL,
abstract text NOT NULL,
body text NOT NULL,
section varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE nodes (
nid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
lid int(6) DEFAULT '0' NOT NULL,
pid int(6) 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;
|
