summaryrefslogtreecommitdiffstats
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert2003-07-16 20:14:26 (GMT)
committerDries Buytaert2003-07-16 20:14:26 (GMT)
commit8759ca7368fbe6014286b320cf25185fc1e1a602 (patch)
tree866d91c2a873e06d7ef8bc2af5afeb9d60c5235f /database
parent1252d51264e9cc45062fe60c2a6b5d6ccf18b8cc (diff)
- Commited the URL aliasing patch. Thanks Matt.
This update requires you to run update.php!
Diffstat (limited to 'database')
-rw-r--r--database/database.mssql1
-rw-r--r--database/database.mysql1
-rw-r--r--database/database.pgsql1
3 files changed, 3 insertions, 0 deletions
diff --git a/database/database.mssql b/database/database.mssql
index f4b60db..a5f1a69 100644
--- a/database/database.mssql
+++ b/database/database.mssql
@@ -186,6 +186,7 @@ CREATE TABLE [dbo].[node] (
[nid] [numeric](10, 0) NULL ,
[type] [varchar] (16) NOT NULL ,
[title] [varchar] (128) NOT NULL ,
+ [path] [varchar] (250) NULL ,
[score] [int] NOT NULL ,
[votes] [int] NOT NULL ,
[uid] [int] NOT NULL ,
diff --git a/database/database.mysql b/database/database.mysql
index 1862f66..dda4cc8 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -262,6 +262,7 @@ CREATE TABLE node (
nid int(10) unsigned NOT NULL auto_increment,
type varchar(16) NOT NULL default '',
title varchar(128) NOT NULL default '',
+ path varchar(250) NULL default '',
score int(11) NOT NULL default '0',
votes int(11) NOT NULL default '0',
uid int(10) NOT NULL default '0',
diff --git a/database/database.pgsql b/database/database.pgsql
index 061cfb1..2e26a9f 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -261,6 +261,7 @@ 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',