s_file.sql

来自「可以实现应用程序上传到SYBASE数据库」· SQL 代码 · 共 28 行

create table S_FILE (
P_APP	char(4)	not null,
P_FN    varchar(20) not null,
P_VER   varchar(20) not null,
C_SIZE  int null,
C_BLOB  image   null,
C_NOTE  varchar(200)    null
)
go
create unique index NDX_FILE_APP on S_FILE(P_APP,P_FN,P_VER)
go


create table S_APPFILE (
P_APP	char(4)	not null,
P_FN    varchar(20) not null
)
go
create unique index NDX_APP on S_APPFILE(P_APP,P_FN)
go

create table S_APP (
P_APP	char(4)	not null,
P_NAME   varchar(60) not null
)
go
create unique index NDX_APP on S_APPFILE(P_APP)
go