hrsys.sql

来自「这是一个企业版的人力资源管理源码,很适合初级开发人员」· SQL 代码 · 共 32 行

USE master
GO
CREATE DATABASE HrSys 
ON
PRIMARY ( NAME = Hr1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData1.mdf',
      SIZE = 100MB,
      MAXSIZE = 200,
      FILEGROWTH = 20),
( NAME = Hr2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData2.ndf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20),
( NAME = Hr3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData3.ndf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20)
LOG ON 
( NAME = HrLog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrLog1.ldf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20),
( NAME = HrLog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrLog2.ldf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20)
GO