diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-12-07 16:55:38 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-12-07 16:55:38 +0000 |
| commit | 60352821bfd61c266c6cda5f797cc7036a9499d2 (patch) | |
| tree | 9bdf38ec0b9c752caab1397a24a21fff78099151 /database/database.pgsql | |
| parent | 1365740f6eab386aa16ba39c6f324a3c30adb78d (diff) | |
| download | brdo-60352821bfd61c266c6cda5f797cc7036a9499d2.tar.gz brdo-60352821bfd61c266c6cda5f797cc7036a9499d2.tar.bz2 | |
- Refactored the queue module: removed the queue module's field from the node table. With help from Gerhard.
- Slight addition to INSTALL.txt with regard to PHP versions.
- Updated/reworded some node type descriptions as per Boris' suggestions.
- Adding missing {} around a table name in update.php.
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 16 |
1 files changed, 13 insertions, 3 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index df50d5d84..f78326980 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -395,15 +395,12 @@ CREATE TABLE node ( nid SERIAL, type varchar(16) NOT NULL default '', title varchar(128) NOT NULL default '', - score integer NOT NULL default '0', - votes integer NOT NULL default '0', uid integer NOT NULL default '0', status integer NOT NULL default '1', created integer NOT NULL default '0', comment integer NOT NULL default '0', promote integer NOT NULL default '0', moderate integer NOT NULL default '0', - users text NOT NULL default '', teaser text NOT NULL default '', body text NOT NULL default '', changed integer NOT NULL default '0', @@ -544,6 +541,19 @@ CREATE TABLE poll_choices ( CREATE INDEX poll_choices_nid_idx ON poll_choices(nid); -- +-- Table structure for queue +-- + +CREATE TABLE queue ( + nid integer NOT NULL default '0', + uid integer NOT NULL default '0', + vote integer NOT NULL default '0', + PRIMARY KEY (nid, uid) +) +CREATE INDEX queue_nid_idx ON queue(nid); +CREATE INDEX queue_uid_idx ON queue(uid); + +-- -- Table structure for role -- |