/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50144
 Source Host           : localhost
 Source Database       : scrud_v1.4

 Target Server Type    : MySQL
 Target Server Version : 50144
 File Encoding         : utf-8

 Date: 03/27/2013 01:49:58 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `crud_groups`
-- ----------------------------
DROP TABLE IF EXISTS `crud_groups`;
CREATE TABLE `crud_groups` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) DEFAULT NULL,
  `group_description` text,
  `group_manage_flag` tinyint(4) DEFAULT NULL,
  `group_full_controll` tinyint(4) DEFAULT NULL,
  `group_read` tinyint(4) DEFAULT NULL,
  `group_read_write` tinyint(4) DEFAULT NULL,
  `group_read_delete` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `crud_groups`
-- ----------------------------
BEGIN;
INSERT INTO `crud_groups` VALUES ('1', 'Administrators', null, '3', '1', '2', '2', '2'), ('2', 'Super users', null, '0', '2', '2', '1', '1'), ('3', 'Users', null, '0', '2', '1', '2', '2');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
