xdmy/doc/sql/c.sql

create table `sapLog` (
    id int(11) not null auto_increment,
    name varchar(56) not null default ''comment '接口类型',
    SysName  varchar(255) not null default ''comment ,
    url varchar(128) not null default '' ,
    status varchar(56) not null default ''comment '状态',
    msgtext varchar(256) not null default ''comment '消息',
    param text not null default '',
    created_at datetime not null default '0000-00-00 00:00:00'comment '创建时间',, 
    flag int(11) not null default 0,
    primary key (id),
    key (name),
    key (flag),
    key (created_at)
);

create table temDict (
    CostCenter  values(50) not null default '',
    CostCenter_name values(128) not null default '',
    personal varchar(128) not null default '',
    CostCenter_type varchar(50) not null default '',
    company_code varchar(56) not null default '' ,
    business_scopes varchar(56) not null default '',
    currency_code varchar(50) not null default '',
    ProfitCenter varchar(128) not null default '',
    stage  varchar(50) not null default '',
    factory_code varchar(56) not null default '' ,
    factory_name varchar(56) not null default '',
    market_group_code varchar(50) not null default '' ,
    market_group_name varchar(56) not null default '',
    company_name varchar(112) not null default '',

    index  (factory_name)
    unique index (factory_code)
)

create table sys_detail_log (
id int(11) not null auto_increment primary key ,
name varchar(50) not null default '',
code varchar(50) not null default '',
error_text text default '',
index (name),
index (code)
)ENGINE=InnoDB DEFAULT CHARSET=utf8   comment 'sap日志明细'
insert into temDict (factory_code, factory_name, company_code, company_name) values

CREATE UNIQUE INDEX temDict_factory_code   ON temDict(factory_code);

create table temDict_costcenter  (
CostCenter_code varchar(50) not null default '',
CostCenter_name varchar(50) not null default '',
factory_name varchar(50) not null default ''
)

CREATE TEMPORARY table dept_Data ( CostCenter_code VARCHAR(50),center_name varchar(50));
CREATE TEMPORARY table if not exists temDict_CostCenter (CostCenter_code VARCHAR
CREATE TEMPORARY table if not  exists part_Data  (old_partcode VARCHAR(50),new_partcode varchar(50),unit varchar(50),issave integer default 0);
create temporary table cost_center_temp(code varchar(50),name varchar(50),type varchar(50));
update department d join  cost_center_temp c on d.name =c.name 
set d.CostCenter_code =c.code 
where d.parentid =115

mysql -ueq -h192.168.61.42 -P3306 -p'Xdmy@1234' eq