--
-- Structure table `theret_hikashop_orderstatus`
--
CREATE TABLE IF NOT EXISTS `theret_hikashop_orderstatus` (
`orderstatus_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`orderstatus_namekey` varchar(255) NOT NULL,
`orderstatus_name` varchar(255) NOT NULL DEFAULT '',
`orderstatus_description` text NOT NULL,
`orderstatus_published` tinyint(4) NOT NULL DEFAULT '0',
`orderstatus_ordering` int(10) unsigned NOT NULL DEFAULT '0',
`orderstatus_email_params` longtext NOT NULL,
`orderstatus_links_params` longtext NOT NULL,
PRIMARY KEY (`orderstatus_id`),
UNIQUE KEY `orderstatus_namekey` (`orderstatus_namekey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Content table `theret_hikashop_orderstatus`
--
INSERT INTO `theret_hikashop_orderstatus` (`orderstatus_id`, `orderstatus_namekey`, `orderstatus_name`, `orderstatus_description`, `orderstatus_published`, `orderstatus_ordering`, `orderstatus_email_params`, `orderstatus_links_params`) VALUES
(1, 'created', 'created', '<p>When a customer finishes a checkout, an order is created with the status created</p>', 1, 1, '', ''),
(2, 'confirmed', 'confirmed', '<p>When the payment is confirmed or that the payment is done at delivery the order becomes confirmed</p>', 1, 3, '', ''),
(3, 'cancelled', 'cancelled', '<p>When an order is cancelled before receiving a payment</p>', 1, 6, '', ''),
(4, 'refunded', 'refunded', '<p>When an order is cancelled after receiving a payment</p>', 1, 7, '', ''),
(5, 'shipped', 'shipped', '<p>When an order has been shipped</p>', 1, 4, '', ''),;
-- --------------------------------------------------------