author | Dan |
Tue, 13 Nov 2007 22:30:19 -0500 | |
changeset 8 | 850e1b1209a9 |
parent 6 | 3f66ec435f08 |
permissions | -rw-r--r-- |
6 | 1 |
CREATE TABLE {{TABLE_PREFIX}}decir_forums( |
0 | 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 |
); |
|
6 | 16 |
CREATE TABLE {{TABLE_PREFIX}}decir_topics( |
0 | 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, |
6 | 29 |
num_views bigint(21) UNSIGNED NOT NULL DEFAULT 0, |
30 |
last_post bigint(18) UNSIGNED NOT NULL, |
|
0 | 31 |
PRIMARY KEY ( topic_id ) |
32 |
); |
|
6 | 33 |
CREATE TABLE {{TABLE_PREFIX}}decir_posts( |
0 | 34 |
post_id bigint(18) unsigned NOT NULL auto_increment, |
35 |
topic_id bigint(15) unsigned NOT NULL, |
|
36 |
poster_id int(12) unsigned NOT NULL, |
|
37 |
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
|
38 |
post_subject varchar(255) NOT NULL DEFAULT '', |
0 | 39 |
timestamp int(11) unsigned NOT NULL, |
40 |
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
|
41 |
edit_count int(5) unsigned NOT NULL DEFAULT 0, |
0 | 42 |
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
|
43 |
post_deleted tinyint(1) NOT NULL DEFAULT 0, |
0 | 44 |
PRIMARY KEY ( post_id ) |
45 |
); |
|
6 | 46 |
CREATE TABLE {{TABLE_PREFIX}}decir_posts_text( |
0 | 47 |
post_id bigint(18) unsigned NOT NULL, |
48 |
post_text longtext NOT NULL, |
|
49 |
bbcode_uid varchar(10) NOT NULL, |
|
50 |
PRIMARY KEY ( post_id ) |
|
51 |
); |
|
6 | 52 |
CREATE TABLE {{TABLE_PREFIX}}decir_hits( |
0 | 53 |
hit_id bigint(21) unsigned NOT NULL auto_increment, |
54 |
user_id int(12) unsigned NOT NULL DEFAULT 1, |
|
55 |
topic_id bigint(15) unsigned NOT NULL, |
|
56 |
timestamp int(11) unsigned NOT NULL, |
|
57 |
PRIMARY KEY ( hit_id ) |
|
58 |
); |