master_table_restorelist.sql

来自「一套宾馆管理系统」· SQL 代码 · 共 23 行

create table RestoreList
(retore_id int not null identity(1,1),
 backfile_id int not null,
 retore_date datetime default (getdate()),
 memo varchar(30)
)
--
create table BackupDevice
(
 back_id int not null identity(1,1),
 back_name varchar(30) not null unique,
 back_filePath varchar(300) default(space(0)),
 back_adddate datetime default(getdate())
)
--
create table BackupFileList
(
 file_no int not null identity(1,1),
 device_no int not null ,
 backup_name varchar(20),
 createtime datetime default(getdate()),
 memo varchar(30) default (space(0))
)