diff options
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', |