/*
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:34:54
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `pages`
-- ----------------------------
DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(45) DEFAULT NULL COMMENT 'web or mobile page',
  `name` varchar(45) DEFAULT NULL,
  `link` longtext,
  `status` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pages
-- ----------------------------
INSERT INTO `pages` VALUES ('1', 'WEB', 'Dashboard', null, '1');
INSERT INTO `pages` VALUES ('2', 'WEB', 'Banner', null, '1');
INSERT INTO `pages` VALUES ('3', 'WEB', 'Welcome Page', null, '1');
INSERT INTO `pages` VALUES ('4', 'WEB', 'Home Page', null, '1');
INSERT INTO `pages` VALUES ('5', 'WEB', 'Category', null, '1');
INSERT INTO `pages` VALUES ('6', 'WEB', 'Genre', null, '1');
INSERT INTO `pages` VALUES ('7', 'WEB', 'Authors', null, '1');
INSERT INTO `pages` VALUES ('8', 'WEB', 'Publisher', null, '1');
INSERT INTO `pages` VALUES ('9', 'WEB', 'Events', null, '1');
INSERT INTO `pages` VALUES ('10', 'WEB', 'Book', null, '1');
INSERT INTO `pages` VALUES ('11', 'WEB', 'Reports', null, '1');
INSERT INTO `pages` VALUES ('12', 'WEB', 'User', null, '1');
INSERT INTO `pages` VALUES ('13', 'WEB', 'FAQ', null, '1');
INSERT INTO `pages` VALUES ('14', 'WEB', 'Book - Review', null, '1');
INSERT INTO `pages` VALUES ('15', 'WEB', 'User - Access', null, '1');
