1
2
3
4
5
6
7
8

CREATE TABLE `SiteAppResources` (
  `app_id` int(10) unsigned NOT NULL,
  `type` enum('database','dbuser','custom_button') NOT NULL DEFAULT 'database',
  `res_id` int(10) unsigned NOT NULL,
  `res_param_1` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT '',
  UNIQUE KEY `type` (`type`,`res_id`),
  KEY `app_id` (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `SiteAppResources` ( `app_id` int(10) unsigned NOT NULL, `type` enum('database','dbuser','custom_button') NOT NULL DEFAULT 'database', `res_id` int(10) unsigned NOT NULL, `res_param_1` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT '', UNIQUE KEY `type` (`type`,`res_id`), KEY `app_id` (`app_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1