Changeset 156 for trunk/install/schema.sql

Timestamp:

03/12/2006 08:41:00 AM (6 years ago)

Author:

Winner

Message:

Add: Regions and areas management from administrator. Close #84
Bug fix: SQL schema - force signed integer values for ips (see ip2long function).
Bug fix: SQL schema - auto_increment option for id on tables areas, regions.
Fix: Help info on services admin pages.

File:

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

trunk/install/schema.sql

@@ -1 +1 @@
 
 CREATE TABLE `areas` (
-  `id` int(10) unsigned NOT NULL default '0',
+  `id` int(10) unsigned NOT NULL auto_increment,
   `region_id` int(10) unsigned NOT NULL default '0',
   `name` varchar(40) NOT NULL default '',
-  `ip_start` int(10) unsigned NOT NULL default '0',
-  `ip_end` int(10) unsigned NOT NULL default '0',
+  `ip_start` int(10) NOT NULL default '0',
+  `ip_end` int(10) NOT NULL default '0',
   `info` text,
   PRIMARY KEY  (`id`),
@@ -19 +19 @@
   `node_id` int(10) unsigned NOT NULL default '0',
   `name` enum('ns0','ns1','ns2','ns3') NOT NULL default 'ns0',
-  `ip` int(10) unsigned NOT NULL default '0',
+  `ip` int(10) NOT NULL default '0',
   `status` enum('waiting','active','pending','rejected','invalid') NOT NULL default 'waiting',
   `delete_req` enum('Y','N') NOT NULL default 'N',
@@ -62 +62 @@
   `date_in` datetime NOT NULL default '0000-00-00 00:00:00',
   `hostname` varchar(50) NOT NULL default '',
-  `ip` int(10) unsigned NOT NULL default '0',
+  `ip` int(10) NOT NULL default '0',
   `mac` varchar(17) default NULL,
   `node_id` int(10) unsigned NOT NULL default '0',
@@ -79 +79 @@
   `date_in` datetime NOT NULL default '0000-00-00 00:00:00',
   `node_id` int(10) unsigned NOT NULL default '0',
-  `ip_start` int(10) unsigned NOT NULL default '0',
-  `ip_end` int(10) unsigned NOT NULL default '0',
+  `ip_start` int(10) NOT NULL default '0',
+  `ip_end` int(10) NOT NULL default '0',
   `status` enum('waiting','active','pending','rejected','invalid') NOT NULL default 'waiting',
   `info` text,
@@ -165 +165 @@
 
 CREATE TABLE `regions` (
-  `id` int(10) unsigned NOT NULL default '0',
+  `id` int(10) unsigned NOT NULL auto_increment,
   `name` varchar(40) NOT NULL default '',
-  `ip_start` int(10) unsigned NOT NULL default '0',
-  `ip_end` int(10) unsigned NOT NULL default '0',
+  `ip_start` int(10) NOT NULL default '0',
+  `ip_end` int(10) NOT NULL default '0',
   `info` text,
   PRIMARY KEY  (`id`),
@@ -198 +198 @@
   `date_in` datetime NOT NULL default '0000-00-00 00:00:00',
   `node_id` int(10) unsigned default NULL,
-  `ip_start` int(10) unsigned NOT NULL default '0',
-  `ip_end` int(10) unsigned NOT NULL default '0',
+  `ip_start` int(10) NOT NULL default '0',
+  `ip_end` int(10) NOT NULL default '0',
   `type` enum('local','link','client') NOT NULL default 'local',
   `link_id` int(10) unsigned default NULL,