Changeset 245 for trunk/install/schema.sql

Timestamp:

06/22/2011 08:18:46 PM (11 months ago)

Author:

sque

Message:

Merge branches/awmn 221:235
[awmn] Allow users to delete zones and nameservers without making a request to hostmaster
[awmn] Untaint sprintf
[awmn] Don't change to php script dir
[awmn] Add support to dump list of stealth nameservers
[awmn] Add active peers search fields to hostmaster's ranges page
[awmn] Redirect errors to stderr
[awmn] Don't explicitly set owner to 'N' (#146)
[awmn] Restrict ip ranges to valid b-classes (0-255)
[awmn] Escape HTML special characters
[awmn] Use appropriate entities for < and > HTML special characters
[awmn] Add missing 'alt' attribute for 'img' element
[awmn] Close 'td' and 'tr' elements properly
[awmn] Escape HTML special characters in services URLs
[awmn] Remove end of line carriage returns

Location:

trunk

Files:

• . (modified) (1 prop)
• install/schema.sql (modified) (4 diffs)

trunk/install/schema.sql

@@ -21 +21 @@
   `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',
   PRIMARY KEY  (`id`),
   UNIQUE KEY `unique_keys` (`name`,`node_id`),
@@ -27 +26 @@
   KEY `node_id` (`node_id`),
   KEY `ip` (`ip`),
-  KEY `status` (`status`),
-  KEY `delete_req` (`delete_req`)
+  KEY `status` (`status`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -39 +37 @@
   `status` enum('waiting','active','pending','rejected','invalid') NOT NULL default 'waiting',
   `info` text,
-  `delete_req` enum('Y','N') NOT NULL default 'N',
   PRIMARY KEY  (`id`),
   UNIQUE KEY `unique_keys` (`name`,`type`),
@@ -45 +42 @@
   KEY `date_in` (`date_in`),
   KEY `node_id` (`node_id`),
-  KEY `status` (`status`),
-  KEY `delete_req` (`delete_req`)
+  KEY `status` (`status`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;