xFdATz24

1CREATE TABLE IF NOT EXISTS `auth_assignment` (
2  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3  `item_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
4  `user_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
5  `created_at` int(11) DEFAULT NULL,
6  `company_id` int(11) unsigned NOT NULL,
7  PRIMARY KEY (`id`),
8  KEY `company_id` (`company_id`)
9) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
10
11CREATE TABLE IF NOT EXISTS `auth_item` (
12  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
13  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
14  `type` smallint(6) NOT NULL,
15  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
16  `rule_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
17  `data` blob,
18  `created_at` int(11) DEFAULT NULL,
19  `updated_at` int(11) DEFAULT NULL,
20  `company_id` int(11) unsigned NOT NULL,
21  PRIMARY KEY (`id`),
22  KEY `company_id` (`company_id`)
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
24
25
26CREATE TABLE IF NOT EXISTS `auth_item_child` (
27  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
28  `parent` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
29  `child` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
30  `company_id` int(11) unsigned NOT NULL,
31  PRIMARY KEY (`id`),
32  KEY `company_id` (`company_id`)
33) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
34
35
36
37CREATE TABLE IF NOT EXISTS `auth_rule` (
38  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
39  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
40  `data` blob,
41  `created_at` int(11) DEFAULT NULL,
42  `updated_at` int(11) DEFAULT NULL,
43  `company_id` int(11) unsigned NOT NULL,
44  PRIMARY KEY (`id`),
45  KEY `company_id` (`company_id`)
46) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;