1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

CREATE TABLE `IP_Addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serviceNodeId` int(10) unsigned NOT NULL DEFAULT '1',
  `ip_address` varchar(39) CHARACTER SET ascii NOT NULL,
  `mask` varchar(15) CHARACTER SET ascii NOT NULL DEFAULT '255.255.255.0',
  `iface` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `ssl_certificate_id` int(10) unsigned NOT NULL,
  `default_domain_id` int(10) unsigned DEFAULT NULL,
  `ftps` enum('false','true') NOT NULL DEFAULT 'false',
  `main` enum('false','true') NOT NULL DEFAULT 'false',
  `status` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip_address` (`ip_address`),
  KEY `ssl_certificate_id` (`ssl_certificate_id`),
  KEY `default_domain_id` (`default_domain_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE `IP_Addresses` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `serviceNodeId` int(10) unsigned NOT NULL DEFAULT '1', `ip_address` varchar(39) CHARACTER SET ascii NOT NULL, `mask` varchar(15) CHARACTER SET ascii NOT NULL DEFAULT '255.255.255.0', `iface` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `ssl_certificate_id` int(10) unsigned NOT NULL, `default_domain_id` int(10) unsigned DEFAULT NULL, `ftps` enum('false','true') NOT NULL DEFAULT 'false', `main` enum('false','true') NOT NULL DEFAULT 'false', `status` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `ip_address` (`ip_address`), KEY `ssl_certificate_id` (`ssl_certificate_id`), KEY `default_domain_id` (`default_domain_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1