diff options
-rw-r--r-- | updates/1.00-to-2.00 (renamed from updates/1.00-to-1.xx) | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/updates/1.00-to-1.xx b/updates/1.00-to-2.00 index 98209523b..dd9bec7aa 100644 --- a/updates/1.00-to-1.xx +++ b/updates/1.00-to-2.00 @@ -1,3 +1,13 @@ +# 03/03/2001: FAQ module +CREATE TABLE faqs ( + id int(11) DEFAULT '0' NOT NULL auto_increment, + question varchar(255) DEFAULT '' NOT NULL, + answer text NOT NULL, + weight tinyint(3) DEFAULT '0' NOT NULL, + UNIQUE question (question), + PRIMARY KEY (id) +); + # 26/02/2001: performance optimization ALTER TABLE comments ADD INDEX lid_link (lid, link); |