 -- AUTO_INCREMENT for table `employee`
 --
 ALTER TABLE `employee`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
+  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
 --
 -- AUTO_INCREMENT for table `orders`
 --
 ALTER TABLE `orders`
-  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
+  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=40;
 --
 -- AUTO_INCREMENT for table `order_product`
 --
 ALTER TABLE `order_product`
-  MODIFY `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=50;
+  MODIFY `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=97;
 --
 -- AUTO_INCREMENT for table `order_status`
 --

(5, '1', 2, 0, '2017-01-22', '18:51:38', 4, 0),
(8, '1', 4, 0, '2017-01-24', '02:51:16', 4, 0),
(9, '1', 3, 0, '2017-01-25', '17:17:28', 4, 0),
(11, '1', 4, 0, '2017-02-19', '14:22:50', 0, 0),
(12, '5', 2, 0, '2017-02-21', '16:15:40', 0, 0),
(13, '5', 2, 0, '2017-03-02', '12:27:19', 4, 0),
(14, '5', 2, 0, '2017-03-03', '10:53:20', 0, 0),
(16, '5', 3, 0, '2017-03-09', '13:30:41', 0, 0),
(17, '1', 2, 0, '2017-03-14', '16:56:55', 4, 0),
(19, '0', 2, 0, '2017-03-14', '16:57:35', 4, 0),

  `id` int(11) NOT NULL,
  `role` varchar(20) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- 转存表中的数据 `role`
--

INSERT INTO `role` (`id`, `role`, `pid`) VALUES
(1, 'Manager', 3),
(2, 'Worker', 1),
(3, 'Super Admin', 0),
(4, 'Unvalidated', 2);

-- --------------------------------------------------------

