/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50519
Source Host           : localhost:3306
Source Database       : bookstore

Target Server Type    : MYSQL
Target Server Version : 50519
File Encoding         : 65001

Date: 2023-09-05 19:35:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `previllage`
-- ----------------------------
DROP TABLE IF EXISTS `previllage`;
CREATE TABLE `previllage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ability` int(11) DEFAULT NULL,
  `add` int(11) DEFAULT NULL,
  `update` int(11) DEFAULT NULL,
  `delete` int(11) DEFAULT NULL,
  `search` int(11) DEFAULT NULL,
  `status` varchar(5) DEFAULT NULL,
  `pages_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `usertype_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_previllage_pages1_idx` (`pages_id`),
  KEY `fk_previllage_usertype1_idx` (`usertype_id`),
  KEY `fk_previllage_user1_idx` (`user_id`),
  CONSTRAINT `fk_previllage_pages1` FOREIGN KEY (`pages_id`) REFERENCES `pages` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_previllage_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_previllage_usertype1` FOREIGN KEY (`usertype_id`) REFERENCES `usertype` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1400 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of previllage
-- ----------------------------
INSERT INTO `previllage` VALUES ('365', '1', '0', '0', '0', '0', '1', '1', null, '4');
INSERT INTO `previllage` VALUES ('366', '1', '1', '1', '1', '1', '1', '2', null, '4');
INSERT INTO `previllage` VALUES ('367', '1', '1', '1', '1', '1', '1', '3', null, '4');
INSERT INTO `previllage` VALUES ('368', '1', '1', '1', '1', '1', '1', '4', null, '4');
INSERT INTO `previllage` VALUES ('369', '1', '1', '1', '1', '1', '1', '5', null, '4');
INSERT INTO `previllage` VALUES ('370', '1', '1', '1', '1', '1', '1', '6', null, '4');
INSERT INTO `previllage` VALUES ('371', '1', '1', '1', '1', '1', '1', '7', null, '4');
INSERT INTO `previllage` VALUES ('372', '1', '1', '1', '1', '1', '1', '8', null, '4');
INSERT INTO `previllage` VALUES ('373', '1', '1', '1', '1', '1', '1', '9', null, '4');
INSERT INTO `previllage` VALUES ('374', '1', '1', '1', '1', '1', '1', '10', null, '4');
INSERT INTO `previllage` VALUES ('375', '1', '1', '1', '1', '1', '1', '11', null, '4');
INSERT INTO `previllage` VALUES ('376', '1', '1', '1', '1', '1', '1', '12', null, '4');
INSERT INTO `previllage` VALUES ('377', '1', '1', '1', '1', '1', '1', '13', null, '4');
INSERT INTO `previllage` VALUES ('378', '1', '0', '0', '1', '0', '1', '14', null, '4');
INSERT INTO `previllage` VALUES ('379', '1', '0', '0', '1', '0', '1', '15', null, '4');
INSERT INTO `previllage` VALUES ('1295', '0', '0', '0', '0', '0', '1', '1', null, '2');
INSERT INTO `previllage` VALUES ('1296', '1', '1', '1', '1', '0', '1', '2', null, '2');
INSERT INTO `previllage` VALUES ('1297', '1', '1', '1', '1', '0', '1', '3', null, '2');
INSERT INTO `previllage` VALUES ('1298', '1', '1', '1', '1', '0', '1', '4', null, '2');
INSERT INTO `previllage` VALUES ('1299', '1', '1', '0', '1', '0', '1', '5', null, '2');
INSERT INTO `previllage` VALUES ('1300', '1', '1', '1', '1', '0', '1', '6', null, '2');
INSERT INTO `previllage` VALUES ('1301', '1', '0', '0', '0', '0', '1', '7', null, '2');
INSERT INTO `previllage` VALUES ('1302', '1', '1', '1', '1', '0', '1', '8', null, '2');
INSERT INTO `previllage` VALUES ('1303', '1', '1', '1', '1', '0', '1', '9', null, '2');
INSERT INTO `previllage` VALUES ('1304', '1', '1', '1', '1', '1', '1', '10', null, '2');
INSERT INTO `previllage` VALUES ('1305', '1', '0', '0', '0', '1', '1', '11', null, '2');
INSERT INTO `previllage` VALUES ('1306', '1', '1', '1', '1', '1', '1', '12', null, '2');
INSERT INTO `previllage` VALUES ('1307', '1', '1', '1', '1', '0', '1', '13', null, '2');
INSERT INTO `previllage` VALUES ('1308', '1', '0', '0', '1', '1', '1', '14', null, '2');
INSERT INTO `previllage` VALUES ('1309', '1', '0', '0', '1', '0', '1', '15', null, '2');
INSERT INTO `previllage` VALUES ('1355', '1', '0', '0', '0', '0', '1', '1', null, '3');
INSERT INTO `previllage` VALUES ('1356', '0', '0', '0', '0', '0', '1', '2', null, '3');
INSERT INTO `previllage` VALUES ('1357', '0', '0', '0', '0', '0', '1', '3', null, '3');
INSERT INTO `previllage` VALUES ('1358', '0', '0', '0', '0', '0', '1', '4', null, '3');
INSERT INTO `previllage` VALUES ('1359', '0', '0', '0', '0', '0', '1', '5', null, '3');
INSERT INTO `previllage` VALUES ('1360', '0', '0', '0', '0', '0', '1', '6', null, '3');
INSERT INTO `previllage` VALUES ('1361', '0', '0', '0', '0', '0', '1', '7', null, '3');
INSERT INTO `previllage` VALUES ('1362', '0', '0', '0', '0', '0', '1', '8', null, '3');
INSERT INTO `previllage` VALUES ('1363', '0', '0', '0', '0', '0', '1', '9', null, '3');
INSERT INTO `previllage` VALUES ('1364', '1', '0', '0', '0', '1', '1', '10', null, '3');
INSERT INTO `previllage` VALUES ('1365', '1', '0', '0', '0', '1', '1', '11', null, '3');
INSERT INTO `previllage` VALUES ('1366', '0', '0', '0', '0', '0', '1', '12', null, '3');
INSERT INTO `previllage` VALUES ('1367', '0', '0', '0', '0', '0', '1', '13', null, '3');
INSERT INTO `previllage` VALUES ('1368', '1', '0', '0', '0', '1', '1', '14', null, '3');
INSERT INTO `previllage` VALUES ('1369', '0', '0', '0', '0', '0', '1', '15', null, '3');
INSERT INTO `previllage` VALUES ('1385', '1', '0', '0', '0', '0', '1', '1', null, '1');
INSERT INTO `previllage` VALUES ('1386', '1', '1', '1', '1', '0', '1', '2', null, '1');
INSERT INTO `previllage` VALUES ('1387', '1', '1', '1', '1', '0', '1', '3', null, '1');
INSERT INTO `previllage` VALUES ('1388', '1', '1', '1', '1', '0', '1', '4', null, '1');
INSERT INTO `previllage` VALUES ('1389', '1', '1', '1', '1', '0', '1', '5', null, '1');
INSERT INTO `previllage` VALUES ('1390', '1', '1', '1', '1', '0', '1', '6', null, '1');
INSERT INTO `previllage` VALUES ('1391', '1', '0', '0', '0', '0', '1', '7', null, '1');
INSERT INTO `previllage` VALUES ('1392', '1', '1', '1', '1', '0', '1', '8', null, '1');
INSERT INTO `previllage` VALUES ('1393', '1', '1', '1', '1', '0', '1', '9', null, '1');
INSERT INTO `previllage` VALUES ('1394', '1', '1', '1', '1', '1', '1', '10', null, '1');
INSERT INTO `previllage` VALUES ('1395', '1', '0', '0', '0', '1', '1', '11', null, '1');
INSERT INTO `previllage` VALUES ('1396', '1', '1', '1', '1', '1', '1', '12', null, '1');
INSERT INTO `previllage` VALUES ('1397', '1', '1', '1', '1', '0', '1', '13', null, '1');
INSERT INTO `previllage` VALUES ('1398', '1', '0', '0', '1', '1', '1', '14', null, '1');
INSERT INTO `previllage` VALUES ('1399', '1', '0', '0', '1', '0', '1', '15', null, '1');
