DB tables

tables

--
-- Table structure for table `emails_events`
--

DROP TABLE IF EXISTS `emails_events`;
CREATE TABLE IF NOT EXISTS `emails_events` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(120) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `emails_events`
--

INSERT INTO `emails_events` (`id`, `name`, `slug`, `created`, `modified`) VALUES
(1, 'After Create Order', 'after-create-order', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(2, 'Cancel Order', 'cancel-order', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(3, 'Approve Free Order', 'approve-free-order', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(4, 'Payment Successfull', 'payment-successfull', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(5, 'Failed Payment', 'failed-payment', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(6, 'Order Shipment', 'order-shipment', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(7, 'Order Shipment cancel', 'order-shipment-cancel', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(8, 'Order Billing cancel', 'order-billing-cancel', '2014-12-08 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `groups_permissions`
--

DROP TABLE IF EXISTS `groups_permissions`;
CREATE TABLE IF NOT EXISTS `groups_permissions` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `permission_id` int(8) NOT NULL,
  `group_id` int(2) NOT NULL,
  `user_id` int(5) NOT NULL,
  `permission_type` int(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `slug`, `created`, `modified`) VALUES
(1, 'Create order', 'create-order', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(2, 'View order', 'view-order', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(3, 'Cancel order', 'cancel-order', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(4, 'Approve Free order', 'approve-free-order', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(5, 'Process Checkout', 'process-checkout', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(6, 'Cancel Billing', 'cancel-billing', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(7, 'Complete Shipment', 'complete-shipment', '2014-12-08 00:00:00', '0000-00-00 00:00:00'),
(8, 'Cancel Shipment', 'cancel-shipment', '2014-12-08 00:00:00', '0000-00-00 00:00:00');