From 0120c08f3911279f8d0450e74c1daa62c6465d65 Mon Sep 17 00:00:00 2001 From: Kjartan Mannes Date: Mon, 21 Jan 2002 17:37:39 +0000 Subject: - updating database/database.mysql again. Forgot to remove some contrib module tables. --- database/database.mysql | 38 ++++++++------------------------------ 1 file changed, 8 insertions(+), 30 deletions(-) diff --git a/database/database.mysql b/database/database.mysql index 7acdb36ac..2e96cda1e 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -171,22 +171,6 @@ CREATE TABLE feed ( UNIQUE KEY link (url) ) TYPE=MyISAM; -# -# Table structure for table 'file' -# - -CREATE TABLE file ( - lid int(10) unsigned NOT NULL auto_increment, - nid int(10) unsigned NOT NULL default '0', - version varchar(10) NOT NULL default '', - url varchar(255) NOT NULL default '', - downloads int(10) unsigned NOT NULL default '0', - abstract text NOT NULL, - description text NOT NULL, - homepage varchar(255) NOT NULL default '', - PRIMARY KEY (lid) -) TYPE=MyISAM; - # # Table structure for table 'history' # @@ -214,6 +198,14 @@ CREATE TABLE item ( PRIMARY KEY (iid) ) TYPE=MyISAM; +# +# Table structure for table 'layout' +# +CREATE TABLE layout ( + user int(11) DEFAULT '0' NOT NULL, + block varchar(64) DEFAULT '' NOT NULL +) TYPE=MyISAM; + # # Table structure for table 'locales' # @@ -343,20 +335,6 @@ CREATE TABLE project ( KEY assigned (assigned) ) TYPE=MyISAM; -# -# Table structure for table 'projects' -# - -CREATE TABLE projects ( - pid int(10) unsigned NOT NULL auto_increment, - name varchar(255) NOT NULL default '', - versions varchar(255) NOT NULL default '', - developers varchar(255) NOT NULL default '', - areas varchar(255) NOT NULL default '', - mail varchar(255) NOT NULL default '', - PRIMARY KEY (pid) -) TYPE=MyISAM; - # # Table structure for table 'rating' # -- cgit v1.2.3