summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2001-03-03 15:27:00 +0000
committerDries Buytaert <dries@buytaert.net>2001-03-03 15:27:00 +0000
commit07cccc9e552a066ad3178814b9edd42b0bf0d2c4 (patch)
tree0291c3afb8d4836ff128afacee8d7bb033a162c1
parentfa26457895a602d356c1878aefa1d1de0a86dfce (diff)
downloadbrdo-07cccc9e552a066ad3178814b9edd42b0bf0d2c4.tar.gz
brdo-07cccc9e552a066ad3178814b9edd42b0bf0d2c4.tar.bz2
- renamed upgrade file
-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);