CREATE TABLE `orders2` (
  `order_id` INT(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` INT(11) DEFAULT NULL,
  `order_state_id` INT(11) DEFAULT NULL,
  `customer_id` INT(11) DEFAULT NULL,
  `paid` tinyint(1) NOT NULL,
  `created` datetime NOT NULL,
  `note` text NOT NULL,
  `admin_note` text NOT NULL,
  `shipping_name` VARCHAR(40) NOT NULL,
  `shipping_street` VARCHAR(40) NOT NULL,
  `shipping_city` VARCHAR(40) NOT NULL,
  `shipping_zip` VARCHAR(5) NOT NULL,
  `delivery` CHAR(1) NOT NULL,
  `payment` CHAR(1) NOT NULL,
  `points` FLOAT NOT NULL,
  `sub_points` FLOAT NOT NULL,
  `shipping_price` FLOAT NOT NULL,
  `total_price` FLOAT NOT NULL,
  `exported` CHAR(1) NOT NULL DEFAULT '0',
  `discount` FLOAT NOT NULL,
  `gift` tinyint(1) NOT NULL,
  `used_code` VARCHAR(10) NOT NULL,
  `absolute_discount` FLOAT NOT NULL,
  PRIMARY KEY (`order_id`),
  KEY `order_state_id` (`order_state_id`),
  KEY `customer_id` (`customer_id`),
  KEY `invoice_id` (`invoice_id`),
  CONSTRAINT `orders2_ibfk_1` FOREIGN KEY (`order_state_id`) REFERENCES `list_order_states` (`order_state_id`) ON DELETE SET NULL,
  CONSTRAINT `orders2_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`customer_id`) ON DELETE SET NULL,
  CONSTRAINT `orders2_ibfk_3` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`invoice_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;