summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2001-02-27 07:45:03 +0000
committerDries Buytaert <dries@buytaert.net>2001-02-27 07:45:03 +0000
commit4d31d27ff0d9270f03456d17f5387f60bc99c22d (patch)
tree351bcea4888fa43f6d754c038d6540579f2b993b /database
parent3364e843175848dc265d463eddcabcd9e2f620b2 (diff)
downloadbrdo-4d31d27ff0d9270f03456d17f5387f60bc99c22d.tar.gz
brdo-4d31d27ff0d9270f03456d17f5387f60bc99c22d.tar.bz2
- added comment index for performance sake
- improved comment module - code revision - improved backend module - moreover headlines now work - (automatically) stripped tabs and trailing whitespaces from Jeroen's theme.
Diffstat (limited to 'database')
-rw-r--r--database/database.mysql1
1 files changed, 1 insertions, 0 deletions
diff --git a/database/database.mysql b/database/database.mysql
index e91d313eb..792edd7ab 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -67,6 +67,7 @@ CREATE TABLE comments (
timestamp int(11) DEFAULT '0' NOT NULL,
score int(6) DEFAULT '0' NOT NULL,
votes int(6) DEFAULT '0' NOT NULL,
+ INDEX lid_link (lid, link),
PRIMARY KEY (cid)
);