/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50624
Source Host : localhost:3306
Source Database : ck
Target Server Type : MYSQL
Target Server Version : 50624
File Encoding : 65001
Date: 2015-08-10 16:15:36
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for contract
-- ----------------------------
DROP TABLE IF EXISTS `contract`;
CREATE TABLE `contract` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`number` varchar(255) DEFAULT NULL,
`company_name` varchar(255) DEFAULT NULL,
`company_address` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`web_site` varchar(255) DEFAULT NULL,
`supplier` varchar(255) DEFAULT NULL,
`buyer` varchar(255) DEFAULT NULL,
`sign_date` datetime DEFAULT NULL,
`sign_address` varchar(255) DEFAULT NULL,
`delivery_date` datetime DEFAULT NULL,
`delivery_address` varchar(255) DEFAULT NULL,
`quality` varchar(255) DEFAULT NULL,
`package_form` varchar(255) DEFAULT NULL,
`acceptance_method` varchar(255) DEFAULT NULL,
`breach_liability` varchar(255) DEFAULT NULL,
`other` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of contract
-- ----------------------------
INSERT INTO `contract` VALUES ('1', 'ht201507220001', '华联期货', '金源中心16楼', '22228888', 'hlqh@126.com', '22228888', 'www.hlqh.com', '大红公司', '华联期货', '2015-07-31 00:00:00', '华联期货', '2015-08-08 00:00:00', '金源中心1楼', '好', '纸皮包装', '当场拆箱查验', '无条件换货', '无', '已批');
INSERT INTO `contract` VALUES ('2', 'ht201507220002', '华联期货', '金源中心16楼', '22228888', 'hlqh@126.com', '22228888', 'www.hlqh.com', '天尊公司', '华联期货', '2015-08-13 00:00:00', '华联期货', '2015-08-28 00:00:00', '金源中心1楼', '好', '纸皮包装', '当场拆箱查验', '无条件换货', '无', '完成');
INSERT INTO `contract` VALUES ('3', '', '名字', '公司地址', '1233445', '33333', '12344', null, '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', null);
INSERT INTO `contract` VALUES ('4', '', '名字', '公司地址', '1233445', '33333', '12344', null, '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', null);
INSERT INTO `contract` VALUES ('5', '', '名字', '公司地址', '1233445', '33333', '12344', null, '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '垃圾');
INSERT INTO `contract` VALUES ('6', '', '名字', '公司地址', '1233445', '33333', '12344', null, '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '垃圾');
INSERT INTO `contract` VALUES ('7', '', '名字', '公司地址', '1233445', '33333', '12344', '', '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '垃圾');
INSERT INTO `contract` VALUES ('8', '', '名字', '公司地址', '1233445', '33333', '12344', '', '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '草稿');
INSERT INTO `contract` VALUES ('9', '', '名字', '公司地址', '1233445', '33333', '12344', '33333', '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '草稿');
INSERT INTO `contract` VALUES ('10', '', '名字', '公司地址', '1233445', '33333', '12344', '33333', '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '垃圾');
INSERT INTO `contract` VALUES ('11', '', '名字', '公司地址', '1233445', '33333', '12344', '33333', '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '垃圾');
INSERT INTO `contract` VALUES ('12', '', '名字', '公司地址', '1233445', '33333', '12344', '33333', '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '垃圾');
INSERT INTO `contract` VALUES ('13', '', '名字123', '公司地址', '1233445', '33333', '12344', '33333', '公司', '公司2', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '垃圾');
INSERT INTO `contract` VALUES ('14', '', '名字123', '公司地址', '1233445', '33333', '12344', '33333', '公司', '公司1444', '2015-08-01 00:00:00', '11111', '2015-08-29 00:00:00', '22222', 'a', 'q', 'q', 'q', 'qqq', '垃圾');
INSERT INTO `contract` VALUES ('15', 'HT20150728test1', '公司15new', '地址15', '1111111', '111111@126.com', '1111111', '11111.com', '红石茶厂', '华联', '2015-09-01 00:00:00', '11115', '2015-09-10 00:00:00', '11111115', 'a', 'bb', 'cc', 'ddd', 'eee', '完成');
INSERT INTO `contract` VALUES ('16', '', '华联期货', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '其他', '垃圾');
INSERT INTO `contract` VALUES ('17', '', 'hlqh', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '', '垃圾');
INSERT INTO `contract` VALUES ('18', '', 'hlqqq', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '', '垃圾');
INSERT INTO `contract` VALUES ('19', '', 'hlqqq', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '', '垃圾');
INSERT INTO `contract` VALUES ('20', '', 'qihuo27', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', 'aa', '垃圾');
INSERT INTO `contract` VALUES ('21', '', 'qihuo27', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', 'aa', '垃圾');
INSERT INTO `contract` VALUES ('22', '', 'qihhh11', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '', '垃圾');
INSERT INTO `contract` VALUES ('23', '', 'qihhh11', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '', '垃圾');
INSERT INTO `contract` VALUES ('24', '', 'fffffff', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '', '垃圾');
INSERT INTO `contract` VALUES ('25', '', 'aaaaaatest2711', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '', '垃圾');
INSERT INTO `contract` VALUES ('26', '', '华联企划', '金源路1号16楼', '22222222', 'hlqh@126.com', '1111111', 'www.hlqh.com', '新疆葡萄公司', '华联期货', '2015-09-09 00:00:00', '金源中心', '2015-09-10 00:00:00', '金源中心17楼', 'c', 'c', 'c', 'c', 'c', '已批');
INSERT INTO `contract` VALUES ('27', '', '华联企划', '金源路1号16楼', '22222222', 'hlqh@126.com', '11111112', 'www.hlqh.com', '新疆葡萄公司', '华联期货', '2015-09-09 00:00:00', '金源中心', '2015-09-10 00:00:00', '金源中心17楼', 'c', 'c', 'c', 'c', 'c', '已批');
INSERT INTO `contract` VALUES ('28', '', '华联企划', '金源路1号16楼', '22222222', 'hlqh@126.com', '11111112', 'www.hlqh.com', '新疆葡萄公司123', '华联期货', '2015-09-09 00:00:00', '金源中心', '2015-09-10 00:00:00', '金源中心17楼', 'c', 'c', 'c', 'c', 'c', '已批');
INSERT INTO `contract` VALUES ('29', 'HT20150728test2', '华联企划', '金源路1号16楼', '22222222', 'hlqh@126.com', '11111112', 'www.hlqh.com', '新疆核桃', '华联期货', '2015-09-09 00:00:00', '金源中心', '2015-09-10 00:00:00', '金源中心17楼', 'c', 'c', 'c', 'c', 'cab', '完成');
INSERT INTO `contract` VALUES ('30', '', '', '', '', '', '', '', '', '', null, '', null, '', '', '', '', '', '', '草稿');
INSERT INTO `contract` VALUES ('31', '', '', '', '', '', '', '', '', '', '2015-09-01 00:00:00', '', '2015-09-01 00:00:00', '', '', '', '', '', '', '草稿');
INSERT INTO `