summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2001-04-16 08:36:25 +0000
committerDries Buytaert <dries@buytaert.net>2001-04-16 08:36:25 +0000
commit49a7dccb64a239097d44e235b525708c6a39d29e (patch)
tree9aade81c1085c577494f3334857fc2f0e19342a5
parent9505251f0d4b133481b7321bc105b7629127fb79 (diff)
downloadbrdo-49a7dccb64a239097d44e235b525708c6a39d29e.tar.gz
brdo-49a7dccb64a239097d44e235b525708c6a39d29e.tar.bz2
- make the version CVS function a bit better
-rw-r--r--includes/node.inc7
-rw-r--r--updates/2.00-to-x.xx.sql37
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,