Changeset 153 for trunk

Timestamp:

03/09/2006 12:14:32 AM (6 years ago)

Author:

Winner

Message:

Update: Services tables in schema.sql

File:

• trunk/install/schema.sql (modified) (2 diffs)

trunk/install/schema.sql

@@ -133 +133 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0;
 
+CREATE TABLE `nodes_services` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `date_in` datetime NOT NULL default '0000-00-00 00:00:00',
+  `node_id` int(10) unsigned NOT NULL default '0',
+  `service_id` int(10) unsigned NOT NULL default '0',
+  `ip_id` int(10) unsigned default '0',
+  `url` varchar(255) default NULL,
+  `info` text,
+  `status` enum('active','inactive') NOT NULL default 'active',
+  `protocol` enum('tcp','udp') default NULL,
+  `port` int(10) unsigned default NULL,
+  PRIMARY KEY  (`id`),
+  KEY `date_in` (`date_in`),
+  KEY `node_id` (`node_id`),
+  KEY `service_id` (`service_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 CREATE TABLE `photos` (
   `id` int(10) unsigned NOT NULL auto_increment,
@@ -166 +183 @@
   UNIQUE KEY `unique_keys` (`type`,`user_id`),
   KEY `user_id` (`user_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE `services` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `title` varchar(255) NOT NULL default '',
+  `protocol` enum('tcp','udp') default NULL,
+  `port` int(10) unsigned default '0',
+  PRIMARY KEY  (`id`),
+  KEY `title` (`title`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;