diff options
Diffstat (limited to 'database/database.mysql')
-rw-r--r-- | database/database.mysql | 24 |
1 files changed, 20 insertions, 4 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; -- |