xdmy/doc/sql/a.sql

alter table provider 
add column sort_name varchar(255) not null default '',
add index sort_name(sort_name);
add  column company_code varchar(50) not null default '' ,
add index company_code(company_code);


select * from parts where partscode='04.06.03.02.000089';
update parts set unit='桶' where partscode='04.06.03.02.000089';

select *  from warehourse limit 10;
select *  from warehouse_provider limit 10;
insert into warehouse 
(warehosetName,warehoseCode,pid,pastureId,isWhPostion,enable)
values('test-001','TT-001',2954,18,1,1) ;

select * from warehouse where warehosetName='test-001';

insert into warehouse_provider  (warehouseId,providerId) values(27177,2954);


alter table equipment add column modifyTime datetime ;
alter table equipment add column CompanyCode  varchar(50) not null default '' ;
alter table equipment add column Quantity       varchar(50) not null default 0 ;
alter table equipment add column CostCenter    varchar(50) not null default ''  ;
alter table equipment add column Unit             varchar(50) not null default '' ;
alter table equipment add column ProfitCenter     varchar(50) not null default '';
alter table equipment add column created_at    datetime;
alter table equipment add column updated_at    datetime;
alter table equipment add column sonCode     varchar(50) not null default '';



alter table BigPartUse 
add column ProofCode  varchar(50) not null default '' 
alter table BigPartrefund
add column ProofCode  varchar(50) not null default '' 
alter  table  BigBuyDetail  add column srmStatus integer  default  0;
alter  table  BigBuyDetail  add column srmNumber varchar(50)  default  '';
alter  table  BigBuyDetail  add column sapError varchar(100)  default  '';
alter  table  BigBuyDetail  add column srmError varchar(100)  default  '';
srmStatus
srmNumber
sapError
srmError
add column SapStatus  int not null default 0
add column sapNumber  varchar(50) not null default ''

alter table BigPartLaid
add column ProofCode  varchar(50) not null default ''
add column Proofyear  varchar(50) not null default ''

modify contractId bigint not null default 0
add column rowNumber int(10)  default 0
alter table partlaid add column dflag int(8) default 0;
alter table PartUse add column dflag int(8) default 0;
alter table Partquit  add column dflag int(8) default 0;
alter table PartRefund  add column dflag int(8) default 0;
add column rowNumber int(10)  default 0
modify contractId bigint not null default 0
add column dflag int not null default 0;
alter table Partquit  add column rowNumber int(10)  default 0;
alter table PartRefund  add column rowNumber int(10) default 0;

alter table sapLog 
add column status varchar(56) not null default ''comment '状态',
add column msgtext varchar(256) not null default ''comment '消息';
 
modify column param text;
alter table provider add column  updated_at datetime ;
 add  column created_at datetime;
add column modifyTime datetime ,
alter table parts 
 add column modifyTime datetime ,
add  column created_at datetime;

alter table equipment add column  updated_at datetime ,add  column created_at datetime,add column modifyTime datetime ;
alter table provider drop key providerName;
show index from provider;


alter table pasture  add column parchase_organization varchar(50) default '' 
rename column   company_name to companyname
add column factory_code varchar(56) not null default '' ,
add column factory_name varchar(56) not null default '',
add column company_code varchar(56) not null default '' ,
add column company_name varchar(112) not null default '',
add index  (factory_name)

alter table  warehouse
add column factory_code varchar(56) not null default '' ,
add column factory_name varchar(56) not null default ''

insert into warehouse    (factory_code,factory_name,warehoseCode,warehosetName,enable)
alter table warehouse  add column pasture_name varchar(56)  default ''
add index (warehoseCode,warehosetName)
drop index warehoseCode;

alter table buydetail
add column rowNumber INT default 0 

alter table contract 
modify id int(11) not null auto_increment
delete from warehouse where warehoseCode <> ''

show create table pasture;

select contractId from partlaid order by contractId desc limit 1

select * from contract where id =623930
alter table equipment
add unique index (eqcode)
add column soncode varchar(50) default ''

alter table department 
rename column CostCenter_code to costCenter_code
add column pasturename varchar(100) default ''

alter table temDict
add CostCenter varchar(50) default '',
add deptname varchar(50) default ''



alter table parts add column  old_partcode varchar(50) default '';
alter table parts add index  (old_partcode);
alter table parts add unique index(partcode,name,specification) ;
alter table parts add unique index(partcode) ;
alter table parts drop index partCode ;
alter table parts add column  new_partcode varchar(50) default '';
alter table parts add column  isSave integer default  0;
alter table parts add unique  index (partcode) ;

delete from parts where partcode  like '14%'
select count(id) from parts where partcode  like '14%'


-- count =31568

alter table part_class add column pname varchar(50) default '';
alter table part_class add column new_partcode varchar(50) default '';


alter table BigPartTransfer add column deptId integer default 0;
alter table BigPartTransfer add column sapStatus integer default 0;
alter table BigPartTransfer add column sapText text default '';
alter table emp add index(pastureId)
-- alter table equipment modify column employeeId bigint(50) 
alter table equipment add index(employeName)