diff options
author | Dries Buytaert <dries@buytaert.net> | 2006-05-09 14:42:08 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2006-05-09 14:42:08 +0000 |
commit | 88723451becc5e55d1521e7bb70f837e3104499f (patch) | |
tree | 4368c732452b78cafa68a2532f748a2ff7f1f179 /database/database.4.1.mysql | |
parent | b28ce3b0b1ac5c5f4cfd8082a80bb66ae618d7b4 (diff) | |
download | brdo-88723451becc5e55d1521e7bb70f837e3104499f.tar.gz brdo-88723451becc5e55d1521e7bb70f837e3104499f.tar.bz2 |
- Patch #62478 by Matt: database schema cleanup.
Diffstat (limited to 'database/database.4.1.mysql')
-rw-r--r-- | database/database.4.1.mysql | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/database/database.4.1.mysql b/database/database.4.1.mysql index f15de50d7..52eebe6e3 100644 --- a/database/database.4.1.mysql +++ b/database/database.4.1.mysql @@ -440,17 +440,18 @@ CREATE TABLE node ( promote int(2) NOT NULL default '0', moderate int(2) NOT NULL default '0', sticky int(2) NOT NULL default '0', - PRIMARY KEY (nid), + PRIMARY KEY (nid, vid), + UNIQUE KEY vid (vid), KEY node_type (type(4)), - KEY node_title_type (title,type(4)), + KEY node_title_type (title, type(4)), KEY status (status), KEY uid (uid), - KEY vid (vid), KEY node_moderate (moderate), KEY node_promote_status (promote, status), KEY node_created (created), KEY node_changed (changed), - KEY node_status_type (status, type, nid) + KEY node_status_type (status, type, nid), + KEY nid (nid) ) DEFAULT CHARACTER SET utf8; @@ -678,7 +679,7 @@ DEFAULT CHARACTER SET utf8; -- CREATE TABLE node_counter ( - nid int(11) NOT NULL default '0', + nid int(10) NOT NULL default '0', totalcount bigint(20) unsigned NOT NULL default '0', daycount mediumint(8) unsigned NOT NULL default '0', timestamp int(11) unsigned NOT NULL default '0', |