diff options
Diffstat (limited to 'database/database.4.0.mysql')
| -rw-r--r-- | database/database.4.0.mysql | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/database/database.4.0.mysql b/database/database.4.0.mysql index e6a57a4a3..b4a4dcc4f 100644 --- a/database/database.4.0.mysql +++ b/database/database.4.0.mysql @@ -412,17 +412,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) ); -- @@ -634,7 +635,7 @@ CREATE TABLE sequences ( -- 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', |