From dc8f6be46fade9c10146a20f18fbc5afc450c941 Mon Sep 17 00:00:00 2001 From: Kjartan Mannes Date: Sun, 27 Jan 2002 19:27:17 +0000 Subject: - added default value to enable user block to update.php - did a new dump of the database from a clean upgrade as my local devel is a little infected with additional tables. --- database/database.mysql | 23 ++--------------------- 1 file changed, 2 insertions(+), 21 deletions(-) (limited to 'database/database.mysql') diff --git a/database/database.mysql b/database/database.mysql index 2e96cda1e..2adcf53be 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -202,7 +202,7 @@ CREATE TABLE item ( # Table structure for table 'layout' # CREATE TABLE layout ( - user int(11) DEFAULT '0' NOT NULL, + uid int(11) DEFAULT '0' NOT NULL, block varchar(64) DEFAULT '' NOT NULL ) TYPE=MyISAM; @@ -316,25 +316,6 @@ CREATE TABLE poll_choices ( PRIMARY KEY (chid) ) TYPE=MyISAM; -# -# Table structure for table 'project' -# - -CREATE TABLE project ( - nid int(10) unsigned NOT NULL default '0', - pid int(10) unsigned NOT NULL default '0', - pstatus tinyint(2) NOT NULL default '0', - area varchar(255) NOT NULL default '', - priority tinyint(2) NOT NULL default '0', - version varchar(255) NOT NULL default '', - assigned int(10) unsigned NOT NULL default '0', - file text, - ptype varchar(255) NOT NULL default '', - PRIMARY KEY (nid), - KEY pid (pid), - KEY assigned (assigned) -) TYPE=MyISAM; - # # Table structure for table 'rating' # @@ -421,7 +402,7 @@ CREATE TABLE users ( sid varchar(32) NOT NULL default '', init varchar(64) default '', session varchar(32) NOT NULL default '', - extrafields text, + data text, PRIMARY KEY (uid), UNIQUE KEY name (name) ) TYPE=MyISAM; -- cgit v1.2.3