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

CREATE TABLE `Templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `note_id` int(10) unsigned DEFAULT NULL,
  `owner_id` int(10) unsigned NOT NULL,
  `type` enum('reseller','client','domain','domain_addon') NOT NULL,
  `uuid` varchar(36) CHARACTER SET ascii NOT NULL,
  `external_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `note_id` (`note_id`),
  KEY `owner_id` (`owner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1

CREATE TABLE `Templates` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 NOT NULL, `note_id` int(10) unsigned DEFAULT NULL, `owner_id` int(10) unsigned NOT NULL, `type` enum('reseller','client','domain','domain_addon') NOT NULL, `uuid` varchar(36) CHARACTER SET ascii NOT NULL, `external_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `uuid` (`uuid`), KEY `note_id` (`note_id`), KEY `owner_id` (`owner_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1