table.txt

来自「自动升级」· 文本 代码 · 共 21 行

CREATE TABLE sys_verfile
(
systemname varchar(20) not NULL,
version varchar(20) NOT NULL, 
filename varchar(40) NOT NULL,
filepath varchar(40) NOT NULL,
filesize int NULL,
way int null, 
zip int null,
filebodyid int not null,
filebody image NULL,
CONSTRAINT pk_fn PRIMARY KEY (systemname, filename,filebodyid )
);

create index idx_sys_verfile on sys_verfile (systemname ,filename);
/*
way:
1: 覆盖 
2: 不覆盖
3: 覆盖并执行
*/