diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-01-20 12:20:31 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-01-20 12:20:31 +0000 |
| commit | 2952d16f78eea91724760f526504010cb8f796a9 (patch) | |
| tree | 21598276fd9bc316be320308c5cd8eeafa77c12d /database | |
| parent | 53b92a614a9e30b693760b8299342f9bfb01320b (diff) | |
| download | brdo-2952d16f78eea91724760f526504010cb8f796a9.tar.gz brdo-2952d16f78eea91724760f526504010cb8f796a9.tar.bz2 | |
- updated/improved discussion engine: it needs additional fine-tuning
though but I think this is stable enough for public consumption and
real-life testing.
==> a first big step towards a flexible comment engine.
IMPORTANT:
- Required theme updatins:
UnConeD: check your $theme->controls() as I added a very, very
dummy implementation
- Required database updates:
alter table users modify mode tinyint(1) DEFAULT '' NOT NULL;
alter table comments change sid lid int(6) DEFAULT '0' NOT NULL;
alter table comments add link varchar(16) DEFAULT '' NOT NULL;
update comments set link = 'story';
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/database/database.mysql b/database/database.mysql index 699407a45..e293a2eb0 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -57,7 +57,8 @@ CREATE TABLE channel ( CREATE TABLE comments ( cid int(6) DEFAULT '0' NOT NULL auto_increment, pid int(6) DEFAULT '0' NOT NULL, - sid int(6) DEFAULT '0' NOT NULL, + lid int(6) DEFAULT '0' NOT NULL, + link varchar(16) DEFAULT '' NOT NULL; author int(6) DEFAULT '0' NOT NULL, subject varchar(64) DEFAULT '' NOT NULL, comment text NOT NULL, @@ -137,7 +138,7 @@ CREATE TABLE users ( fake_email varchar(60) DEFAULT '' NOT NULL, url varchar(100) DEFAULT '' NOT NULL, stories tinyint(2) DEFAULT '10', - mode varchar(10) DEFAULT '', + mode tinyint(1) DEFAULT '0', sort tinyint(1) DEFAULT '0', threshold tinyint(1) DEFAULT '0', bio tinytext NOT NULL, |