Skip to content

Instantly share code, notes, and snippets.

@sakilimran
Created December 8, 2014 12:38
Show Gist options
  • Save sakilimran/0115367199048e50fcd1 to your computer and use it in GitHub Desktop.
Save sakilimran/0115367199048e50fcd1 to your computer and use it in GitHub Desktop.
update db
--
-- Table structure for table `emails_receivers`
--
DROP TABLE IF EXISTS `emails_receivers`;
CREATE TABLE IF NOT EXISTS `emails_receivers` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`event_id` int(8) NOT NULL,
`user_id` int(5) NOT NULL,
`attachment_invoice` tinyint(1) NOT NULL,
`attachment_slip` tinyint(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 `events`
--
DROP TABLE IF EXISTS `events`;
CREATE TABLE IF NOT EXISTS `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 `events`
--
INSERT INTO `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');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment