diff options
author | Dries Buytaert <dries@buytaert.net> | 2001-04-16 08:36:25 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2001-04-16 08:36:25 +0000 |
commit | 49a7dccb64a239097d44e235b525708c6a39d29e (patch) | |
tree | 9aade81c1085c577494f3334857fc2f0e19342a5 | |
parent | 9505251f0d4b133481b7321bc105b7629127fb79 (diff) | |
download | brdo-49a7dccb64a239097d44e235b525708c6a39d29e.tar.gz brdo-49a7dccb64a239097d44e235b525708c6a39d29e.tar.bz2 |
- make the version CVS function a bit better
-rw-r--r-- | includes/node.inc | 7 | ||||
-rw-r--r-- | updates/2.00-to-x.xx.sql | 37 |
2 files changed, 3 insertions, 41 deletions
diff --git a/includes/node.inc b/includes/node.inc index 7026efbb6..3bb47832b 100644 --- a/includes/node.inc +++ b/includes/node.inc @@ -18,13 +18,6 @@ function node_get_array($field, $value) { return db_fetch_array(_node_get($field, $value)); } -function node_get_category($nid) { - db_fetch_array(db_query("SELECT FROM")); -} - -function node_get_topic($nid) { -} - function node_del($field, $value) { global $status; if ($node = node_get_object($field, $value)) { diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql index 1b10a887a..5a94039e7 100644 --- a/updates/2.00-to-x.xx.sql +++ b/updates/2.00-to-x.xx.sql @@ -1,4 +1,7 @@ # 14/04/2001: +ALTER TABLE node ADD cid int(10) unsigned DEFAULT '0' NOT NULL; +ALTER TABLE node ADD tid int(10) unsigned DEFAULT '0' NOT NULL; + CREATE TABLE category ( cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, name varchar(32) DEFAULT '' NOT NULL, @@ -20,40 +23,6 @@ CREATE TABLE topic ( PRIMARY KEY (tid) ); -CREATE TABLE node_category ( - cid int(10) unsigned DEFAULT '0' NOT NULL, - nid int(10) unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (cid, nid) -); - -CREATE TABLE node_topic ( - tid int(10) unsigned DEFAULT '0' NOT NULL, - nid int(10) unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (tid, nid) -); - -///// revise - -CREATE TABLE section ( - sid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - pid int(10) unsigned DEFAULT '0' NOT NULL, - name varchar(32) DEFAULT '' NOT NULL, - UNIQUE (name), - PRIMARY KEY (sid) -); - -CREATE TABLE section_type ( - sid int(10) unsigned DEFAULT '0' NOT NULL, - type varchar(16) DEFAULT '' NOT NULL, - PRIMARY KEY (sid, type) -); - -CREATE TABLE section_node ( - sid int(10) unsigned DEFAULT '0' NOT NULL, - nid int(10) unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (sid, nid) -); - # 07/04/2001: CREATE TABLE page ( lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, |