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

CREATE TABLE `Subscriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `object_id` int(10) unsigned NOT NULL,
  `object_type` enum('client','domain') NOT NULL,
  `locked` enum('true','false') NOT NULL DEFAULT 'false',
  `synchronized` enum('true','false') NOT NULL DEFAULT 'true',
  `custom` enum('true','false') NOT NULL DEFAULT 'false',
  `uuid` varchar(36) CHARACTER SET ascii NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `object_id` (`object_id`,`object_type`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1

CREATE TABLE `Subscriptions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `object_id` int(10) unsigned NOT NULL, `object_type` enum('client','domain') NOT NULL, `locked` enum('true','false') NOT NULL DEFAULT 'false', `synchronized` enum('true','false') NOT NULL DEFAULT 'true', `custom` enum('true','false') NOT NULL DEFAULT 'false', `uuid` varchar(36) CHARACTER SET ascii NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `object_id` (`object_id`,`object_type`), UNIQUE KEY `uuid` (`uuid`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1