1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE `APSClientApplicationItems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` int(10) unsigned NOT NULL DEFAULT '0',
  `app_item_id` int(10) unsigned NOT NULL DEFAULT '0',
  `instances_limit` int(11) NOT NULL DEFAULT '-1',
  `broadcast` enum('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE KEY `client_id_2` (`client_id`,`app_item_id`),
  KEY `client_id` (`client_id`),
  KEY `app_item_id` (`app_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `APSClientApplicationItems` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `client_id` int(10) unsigned NOT NULL DEFAULT '0', `app_item_id` int(10) unsigned NOT NULL DEFAULT '0', `instances_limit` int(11) NOT NULL DEFAULT '-1', `broadcast` enum('false','true') NOT NULL DEFAULT 'false', PRIMARY KEY (`id`), UNIQUE KEY `client_id_2` (`client_id`,`app_item_id`), KEY `client_id` (`client_id`), KEY `app_item_id` (`app_item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1