scj/sqls/采购环节第一次修改

CREATE TABLE `system_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property` varchar(100) NOT NULL,
  `value` longtext NOT NULL,
  PRIMARY KEY (`id`),
  INDEX (`property`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into django_content_type (app_label,model) values ('config','config');
INSERT into `auth_permission` (name, content_type_id, codename) values("修改",(select id from django_content_type where app_label = "config" and model = "config"),"edit_config");

ALTER TABLE `purchase_order`
ADD COLUMN `consignee_name`  varchar(100) NULL ,
ADD COLUMN `consignee_tel`  varchar(100) NULL  ;
UPDATE `purchase_order` SET `consignee_name` = "仓管 周二静", `consignee_tel` = "13781741826";

ALTER TABLE `purchase_plan_price`
ADD COLUMN `tax_rate`  float NULL  ;