sql_table.sql

一套宾馆管理系统

CREATE TABLE [BackupFileList] (
	[file_no] [int] IDENTITY (1, 1) NOT NULL ,
	[device_no] [int] NOT NULL ,
	[backup_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[createtime] [datetime] NULL CONSTRAINT [DF__BackupFil__creat__1C0818FF] DEFAULT (getdate()),
	[memo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__BackupFile__memo__1CFC3D38] DEFAULT (space(0))
) ON [PRIMARY]
GO
CREATE TABLE [RestoreList] (
	[retore_id] [int] IDENTITY (1, 1) NOT NULL ,
	[backfile_id] [int] NOT NULL ,
	[retore_date] [datetime] NULL CONSTRAINT [DF__RestoreLi__retor__164F3FA9] DEFAULT (getdate()),
	[memo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO
CREATE TABLE [BackupDevice] (
	[back_id] [int] IDENTITY (1, 1) NOT NULL ,
	[back_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[back_filePath] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__BackupDev__back___192BAC54] DEFAULT (space(0)),
	[back_adddate] [datetime] NULL CONSTRAINT [DF__BackupDev__back___1A1FD08D] DEFAULT (getdate()),
	 UNIQUE  NONCLUSTERED 
	(
		[back_name]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO