--- C:/bb/Racktables/SF_Copy/install/init-structure.sql	Sat Apr 10 05:26:04 2010
+++ C:/bb/Racktables/My_Copy/install/init-structure.sql	Fri May  7 14:28:37 2010
@@ -148,15 +148,22 @@
   CONSTRAINT `IPv4LB-FK-rspool_id` FOREIGN KEY (`rspool_id`) REFERENCES `IPv4RSPool` (`id`)
 ) ENGINE=InnoDB;
 
-CREATE TABLE `IPv4Network` (
+CREATE TABLE IF NOT EXISTS `IPv4Network` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `ip` int(10) unsigned NOT NULL,
   `mask` int(10) unsigned NOT NULL,
   `name` char(255) default NULL,
   `comment` text,
+  `VLAN` int(10) default NULL,
+  `Location` varchar(50) default NULL,
+  `DHCP_Start` varchar(15) default NULL,
+  `DHCP_End` varchar(15) default NULL,
+  `Default_Gateway` varchar(15) default NULL,
+  `DNS_Primary` varchar(15) default NULL,
+  `DNS_Secondary` varchar(15) default NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `base-len` (`ip`,`mask`)
-) ENGINE=MyISAM;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
 
 CREATE TABLE `IPv4RS` (
   `id` int(10) unsigned NOT NULL auto_increment,
@@ -355,3 +362,9 @@
   `user` char(64) NOT NULL,
   UNIQUE KEY `user_varname` (`user`,`varname`)
 ) TYPE=InnoDB;
+
+CREATE TABLE `PatchPanelMap` (
+  `patchPanel1` int(10) NOT NULL,
+  `patchPanel2` int(10) NOT NULL,
+  KEY `patchPanel1` (`patchPanel1`)
+) TYPE=InnoDB;
\ No newline at end of file