CREATE TABLE IF NOT EXISTS `#__djc2_order_statuses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `status_code` char(1) NOT NULL,
  `is_core` tinyint(4) NOT NULL DEFAULT '0',
  `description` mediumtext,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;

INSERT IGNORE INTO `#__djc2_order_statuses` (`id`, `name`, `status_code`, `is_core`, `description`) VALUES
(1, 'New', 'N', 1, ''),
(2, 'Accepted by customer', 'A', 1, ''),
(3, 'Paid', 'P', 1, ''),
(4, 'Confirmed', 'C', 1, ''),
(5, 'Rejected', 'R', 1, ''),
(6, 'Cancelled by customer', 'W', 1, ''),
(7, 'Completed/Delivered', 'F', 1, '');