diff options
author | Dries Buytaert <dries@buytaert.net> | 2006-01-04 09:17:02 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2006-01-04 09:17:02 +0000 |
commit | 9af704d3cf5a35a148c19526e7ac21346aaee084 (patch) | |
tree | c4c76fe89436a344b8aa52bcf837b0eaa2ea1fc9 /database | |
parent | 9e23a23d7371a555f23da840a9f58f6469c42ad2 (diff) | |
download | brdo-9af704d3cf5a35a148c19526e7ac21346aaee084.tar.gz brdo-9af704d3cf5a35a148c19526e7ac21346aaee084.tar.bz2 |
- Modified patch #39697 by nedjo: enable sites to post information on their modules, themes.
Diffstat (limited to 'database')
-rw-r--r-- | database/database.mysql | 24 | ||||
-rw-r--r-- | database/database.pgsql | 22 | ||||
-rw-r--r-- | database/updates.inc | 58 |
3 files changed, 97 insertions, 7 deletions
diff --git a/database/database.mysql b/database/database.mysql index f08db4f6f..e84d4518b 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -229,17 +229,33 @@ CREATE TABLE node_comment_statistics ( ) TYPE=MyISAM; -- --- Table structure for table 'directory' +-- Table structure for table 'client' -- -CREATE TABLE directory ( +CREATE TABLE client ( + cid int(10) unsigned NOT NULL auto_increment, link varchar(255) NOT NULL default '', name varchar(128) NOT NULL default '', mail varchar(128) NOT NULL default '', slogan longtext NOT NULL, mission longtext NOT NULL, - timestamp int(11) NOT NULL default '0', - PRIMARY KEY (link) + users int(10) NOT NULL default '0', + nodes int(10) NOT NULL default '0', + version varchar(35) NOT NULL default'', + created int(11) NOT NULL default '0', + changed int(11) NOT NULL default '0', + PRIMARY KEY (cid) +) TYPE=MyISAM; + +-- +-- Table structure for table 'client_system' +-- + +CREATE TABLE client_system ( + cid int(10) NOT NULL default '0', + name varchar(255) NOT NULL default '', + type varchar(255) NOT NULL default '', + PRIMARY KEY (cid,name) ) TYPE=MyISAM; -- diff --git a/database/database.pgsql b/database/database.pgsql index 782ca52ce..8b7659f5a 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -230,14 +230,30 @@ CREATE INDEX node_comment_statistics_last_comment_timestamp_idx ON node_comment_ -- Table structure for directory -- -CREATE TABLE directory ( +CREATE TABLE client ( + cid SERIAL, link varchar(255) NOT NULL default '', name varchar(128) NOT NULL default '', mail varchar(128) NOT NULL default '', slogan text NOT NULL default '', mission text NOT NULL default '', - timestamp integer NOT NULL default '0', - PRIMARY KEY (link) + users integer NOT NULL default '0', + nodes integer NOT NULL default '0', + version varchar(35) NOT NULL default'', + created integer NOT NULL default '0', + changed integer NOT NULL default '0', + PRIMARY KEY (cid) +); + +-- +-- Table structure for table 'client_system' +-- + +CREATE TABLE client_system ( + cid integer NOT NULL, + name varchar(255) NOT NULL default '', + type varchar(255) NOT NULL default '', + PRIMARY KEY (cid,name) ); -- diff --git a/database/updates.inc b/database/updates.inc index 04bd928b7..cfdce0df4 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -1341,3 +1341,61 @@ function system_update_165() { variable_del('ping_cron_last'); return array(); } + +function system_update_166() { + $ret = array(); + + $ret[] = update_sql("DROP TABLE {directory}"); + switch ($GLOBALS['db_type']) { + case 'mysqli': + case 'mysql': + update_sql("CREATE TABLE client ( + cid int(10) unsigned NOT NULL auto_increment, + link varchar(255) NOT NULL default '', + name varchar(128) NOT NULL default '', + mail varchar(128) NOT NULL default '', + slogan longtext NOT NULL, + mission longtext NOT NULL, + users int(10) NOT NULL default '0', + nodes int(10) NOT NULL default '0', + version varchar(35) NOT NULL default'', + created int(11) NOT NULL default '0', + changed int(11) NOT NULL default '0', + PRIMARY KEY (cid) + ) TYPE=MyISAM"); + update_sql("CREATE TABLE client_system ( + cid int(10) NOT NULL default '0', + name varchar(255) NOT NULL default '', + type varchar(255) NOT NULL default '', + PRIMARY KEY (cid,name) + ) TYPE=MyISAM"); + break; + + case 'pgsql': + update_sql("CREATE TABLE client ( + cid SERIAL, + link varchar(255) NOT NULL default '', + name varchar(128) NOT NULL default '', + mail varchar(128) NOT NULL default '', + slogan text NOT NULL default '', + mission text NOT NULL default '', + users integer NOT NULL default '0', + nodes integer NOT NULL default '0', + version varchar(35) NOT NULL default'', + created integer NOT NULL default '0', + changed integer NOT NULL default '0', + PRIMARY KEY (cid) + )"); + update_sql("CREATE TABLE client_system ( + cid integer NOT NULL, + name varchar(255) NOT NULL default '', + type varchar(255) NOT NULL default '', + PRIMARY KEY (cid,name) + )"); + break; + } + + return $ret; +} + + |