1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE `Webmails` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `version` varchar(255) CHARACTER SET utf8 NOT NULL,
  `release` varchar(255) CHARACTER SET utf8 NOT NULL,
  `docroot` varchar(255) CHARACTER SET utf8 NOT NULL,
  `enabled` enum('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_id` (`product_id`),
  UNIQUE KEY `docroot` (`docroot`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

CREATE TABLE `Webmails` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `product_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `name` varchar(255) CHARACTER SET utf8 NOT NULL, `version` varchar(255) CHARACTER SET utf8 NOT NULL, `release` varchar(255) CHARACTER SET utf8 NOT NULL, `docroot` varchar(255) CHARACTER SET utf8 NOT NULL, `enabled` enum('false','true') NOT NULL DEFAULT 'false', PRIMARY KEY (`id`), UNIQUE KEY `product_id` (`product_id`), UNIQUE KEY `docroot` (`docroot`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1