author | Dan |
Wed, 17 Oct 2007 23:44:22 -0400 | |
changeset 4 | c31210950118 |
parent 1 | 6f8b7c6fac02 |
child 6 | 3f66ec435f08 |
permissions | -rw-r--r-- |
0 | 1 |
CREATE TABLE decir_forums( |
2 |
forum_id int(12) unsigned NOT NULL auto_increment, |
|
3 |
forum_type tinyint(2) unsigned NOT NULL DEFAULT 1, |
|
4 |
forum_name varchar(255) NOT NULL, |
|
5 |
forum_desc text NOT NULL, |
|
6 |
parent int(12) unsigned NOT NULL DEFAULT 0, |
|
7 |
forum_order int(12) unsigned NOT NULL DEFAULT 1, |
|
8 |
last_post_id int(18) unsigned, |
|
9 |
last_post_topic int(12) unsigned, |
|
10 |
last_post_user int(12) unsigned, |
|
11 |
num_topics int(15) unsigned, |
|
12 |
num_posts int(18) unsigned, |
|
13 |
forum_extra text, |
|
14 |
PRIMARY KEY ( forum_id ) |
|
15 |
); |
|
16 |
CREATE TABLE decir_topics( |
|
17 |
topic_id int(15) unsigned NOT NULL auto_increment, |
|
18 |
forum_id int(12) unsigned NOT NULL, |
|
19 |
topic_title varchar(255) NOT NULL, |
|
20 |
topic_icon tinyint(3) unsigned NOT NULL, |
|
21 |
topic_starter int(12) unsigned NOT NULL, |
|
22 |
topic_type tinyint(2) unsigned NOT NULL DEFAULT 1, |
|
23 |
topic_locked tinyint(1) unsigned NOT NULL DEFAULT 0, |
|
24 |
topic_moved tinyint(1) unsigned NOT NULL DEFAULT 0, |
|
25 |
timestamp int(11) unsigned NOT NULL, |
|
1
6f8b7c6fac02
Let's just say: major progress and still only 20% complete. So many changes I forgot to commit.
Dan
parents:
0
diff
changeset
|
26 |
topic_deleted tinyint(1) NOT NULL DEFAULT 0, |
6f8b7c6fac02
Let's just say: major progress and still only 20% complete. So many changes I forgot to commit.
Dan
parents:
0
diff
changeset
|
27 |
topic_deletor int(12) DEFAULT NULL, |
6f8b7c6fac02
Let's just say: major progress and still only 20% complete. So many changes I forgot to commit.
Dan
parents:
0
diff
changeset
|
28 |
topic_delete_reason varchar(255) DEFAULT NULL, |
0 | 29 |
PRIMARY KEY ( topic_id ) |
30 |
); |
|
31 |
CREATE TABLE decir_posts( |
|
32 |
post_id bigint(18) unsigned NOT NULL auto_increment, |
|
33 |
topic_id bigint(15) unsigned NOT NULL, |
|
34 |
poster_id int(12) unsigned NOT NULL, |
|
35 |
poster_name varchar(255) NOT NULL, |
|
1
6f8b7c6fac02
Let's just say: major progress and still only 20% complete. So many changes I forgot to commit.
Dan
parents:
0
diff
changeset
|
36 |
post_subject varchar(255) NOT NULL DEFAULT '', |
0 | 37 |
timestamp int(11) unsigned NOT NULL, |
38 |
last_edited_by int(12) unsigned DEFAULT NULL, |
|
1
6f8b7c6fac02
Let's just say: major progress and still only 20% complete. So many changes I forgot to commit.
Dan
parents:
0
diff
changeset
|
39 |
edit_count int(5) unsigned NOT NULL DEFAULT 0, |
0 | 40 |
edit_reason varchar(255), |
1
6f8b7c6fac02
Let's just say: major progress and still only 20% complete. So many changes I forgot to commit.
Dan
parents:
0
diff
changeset
|
41 |
post_deleted tinyint(1) NOT NULL DEFAULT 0, |
0 | 42 |
PRIMARY KEY ( post_id ) |
43 |
); |
|
44 |
CREATE TABLE decir_posts_text( |
|
45 |
post_id bigint(18) unsigned NOT NULL, |
|
46 |
post_text longtext NOT NULL, |
|
47 |
bbcode_uid varchar(10) NOT NULL, |
|
48 |
PRIMARY KEY ( post_id ) |
|
49 |
); |
|
50 |
CREATE TABLE decir_hits( |
|
51 |
hit_id bigint(21) unsigned NOT NULL auto_increment, |
|
52 |
user_id int(12) unsigned NOT NULL DEFAULT 1, |
|
53 |
topic_id bigint(15) unsigned NOT NULL, |
|
54 |
timestamp int(11) unsigned NOT NULL, |
|
55 |
PRIMARY KEY ( hit_id ) |
|
56 |
); |