-- -------------------------------------------------------- -- -- Table structure for table `permissions` -- -- Creation: Aug 27, 2015 at 04:22 PM -- DROP TABLE IF EXISTS `permissions`; CREATE TABLE IF NOT EXISTS `permissions` ( `id` int(10) NOT NULL, `name` varchar(50) COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- RELATIONS FOR TABLE `permissions`: -- -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`); -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;