diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-10-01 05:18:03 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-10-01 05:18:03 +0000 |
| commit | fa2581edcfa52c847db93a9421de5216fb0072f6 (patch) | |
| tree | 157fe17cb4af14b4b927ce157c29ab8fd9b894cf /database/database.pgsql | |
| parent | 392304da5f4a6f86d8ab8b5f91d38a698d1dcc88 (diff) | |
| download | brdo-fa2581edcfa52c847db93a9421de5216fb0072f6.tar.gz brdo-fa2581edcfa52c847db93a9421de5216fb0072f6.tar.bz2 | |
- Modifies path.module to get rid of pgsql reserved word. Patch by Adrian.
- Updates database.pgsql and database.mysql to work with current cvs. Patch
by Adrian.
- Updates update.php to be able to update postgres from 4.2 to current.
Patch by Adrian.
- Small fixes by me.
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 19 |
1 files changed, 15 insertions, 4 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 3e2d3183b..fd1ef5f86 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -263,7 +263,6 @@ CREATE TABLE node ( nid SERIAL, type varchar(16) NOT NULL default '', title varchar(128) NOT NULL default '', - path varchar(250) NULL default '', score integer NOT NULL default '0', votes integer NOT NULL default '0', uid integer NOT NULL default '0', @@ -281,12 +280,11 @@ CREATE TABLE node ( static integer NOT NULL default '0', PRIMARY KEY (nid) ); -CREATE INDEX node_type_idx ON node(type(4)); -CREATE INDEX node_title_idx ON node(title,type(4)); +CREATE INDEX node_type_idx ON node(type); +CREATE INDEX node_title_idx ON node(title,type); CREATE INDEX node_status_idx ON node(status); CREATE INDEX node_uid_idx ON node(uid); CREATE INDEX node_moderate_idx ON node (moderate); -CREATE INDEX node_path_idx ON node (path(8)); CREATE INDEX node_promote_status_idx ON node (promote, status); -- @@ -303,6 +301,19 @@ CREATE TABLE page ( CREATE INDEX page_nid_idx ON page(nid); -- +-- Table structure for table 'path' +-- + +CREATE TABLE path ( + pid integer NOT NULL default '0', + dst varchar(128) NOT NULL default '', + src varchar(128) NOT NULL default '', + PRIMARY KEY (pid) +); +CREATE INDEX path_src_idx ON path(src); +CREATE INDEX path_dst_idx ON path(dst); + +-- -- Table structure for permission -- |