summaryrefslogtreecommitdiffstats
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert2003-09-30 17:01:34 (GMT)
committerDries Buytaert2003-09-30 17:01:34 (GMT)
commit5a667eb580be3f20bde78232f564152f1cb869a9 (patch)
treecd347ca532f72b7527c37c2bd4b4009dacf5a2c3 /database
parent13f12eb4177d79ffb1347aba355040a4e6b85738 (diff)
- Url aliasing improvements. Patch by Matt. See mailing list for more
information.
Diffstat (limited to 'database')
-rw-r--r--database/database.mysql15
1 files changed, 13 insertions, 2 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 1a53c39..f4438cd 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -264,7 +264,6 @@ 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',
@@ -286,7 +285,6 @@ CREATE TABLE node (
KEY status (status),
KEY uid (uid),
KEY node_moderate (moderate),
- KEY node_path (path(5)),
KEY node_promote_status (promote, status)
) TYPE=MyISAM;
@@ -304,6 +302,19 @@ CREATE TABLE page (
) TYPE=MyISAM;
--
+-- Table structure for table 'path'
+--
+
+CREATE TABLE path (
+ alid int(10) unsigned NOT NULL auto_increment,
+ old varchar(128) NOT NULL default '',
+ new varchar(128) NOT NULL default '',
+ PRIMARY KEY (alid),
+ UNIQUE KEY new (new),
+ UNIQUE KEY old (old)
+) TYPE=MyISAM;
+
+--
-- Table structure for table 'permission'
--