summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'database/database.mysql')
-rw-r--r--database/database.mysql24
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;
--