 Target Server Version : 50524
 File Encoding         : 65001
 
-Date: 2015-11-20 17:02:27
+Date: 2015-11-24 17:42:11
 */
 
 SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
INSERT INTO `tbl_user` VALUES ('1', 'admin', '$2y$13$fLqoeuEaAoE/y2lFmBol7OghVwj82TUGGjJCI/llLWfQNrQuZNtEm', 'admin', 'binh.phamvan@gmail.com', 'Phạm Bình', '0', '989279795', null, null, null, null, '1448008815');
INSERT INTO `tbl_user` VALUES ('4', 'chuyenvien1', '$2y$13$GD01liz8u1QXSsKvpVcyUO50oUWiG6KHnwRgklOG0Teh9ENfmCgmG', 'author', 'chuyenvien1@gmail.com', 'chuyên viên 1', '0', '989279795', 'N-5JVLV9JcOUKepJYzEh3RHliY0MwbM4khNU_HsT6JG-WBYvp2fznJ9eYfumKG4F', null, null, null, null);
INSERT INTO `tbl_user` VALUES ('7', 'taikhoan1', '$2y$13$gPBivAxrWPZDIQJNCCLdguwu/qt0WNq9G4.96kXwM7Yd9OhS9Erq.', 'author', 'binh.phamvan@gmail.com', 'No Name', '1', '989279795', '_PVPTJzqLEhoQur_IdC0h_8eF-YsbBSTSlxrBqf9Od68DT28EbccUaWlW87PYAp7', null, null, '1447994622', null);

INSERT INTO `tbl_auth_rule` VALUES ('isAuthor', 'O:30:\"app\\components\\rbac\\AuthorRule\":3:{s:4:\"name\";s:8:\"isAuthor\";s:9:\"createdAt\";i:1447818009;s:9:\"updatedAt\";i:1447818009;}', '1447818009', '1447818009');

-- ----------------------------
-- Table structure for `tbl_category`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_category`;
CREATE TABLE `tbl_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `left` int(11) NOT NULL DEFAULT '1',
  `right` int(11) NOT NULL DEFAULT '2',
  `level` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_category
-- ----------------------------
INSERT INTO `tbl_category` VALUES ('1', 'Thể thao', 'the-thao', 'tin thể thao', '1', '2', '0');
INSERT INTO `tbl_category` VALUES ('2', 'Sức khỏe', 'suc-khoe', 'tư vấn sức khỏe', '1', '2', '0');
INSERT INTO `tbl_category` VALUES ('3', 'Khoa học', 'khoa-hoc', 'tin tức khoa học', '1', '2', '0');

-- ----------------------------
-- Table structure for `tbl_migration`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_migration`;
