travelsys.sql

大连市旅游资源管理系统是面向现实需求的一个实用系统。其设计的目的是为旅行社提供一个友好的、直接的交流平台。本系统主要分为九大模块：地域信息管理、景点资源管理、宾馆资源管理、餐厅资源管理、娱乐资源管理、

USE master
GO
CREATE DATABASE TravelSys
ON
PRIMARY ( NAME = Travel1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\TravelData1.mdf',
      SIZE = 10MB,
      MAXSIZE = 200,
      FILEGROWTH = 2),
( NAME = Travel2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\TravelData2.ndf',
   SIZE = 10MB,
   MAXSIZE = 200,
   FILEGROWTH = 2),
( NAME = Travel3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\TravelData3.ndf',
   SIZE = 10MB,
   MAXSIZE = 200,
   FILEGROWTH = 2)
LOG ON 
( NAME = TravelLog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\TravelLog1.ldf',
   SIZE = 1MB,
   MAXSIZE = 20,
   FILEGROWTH = 1),
( NAME = TravelLog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\TravelLog2.ldf',
   SIZE = 1MB,
   MAXSIZE = 2,
   FILEGROWTH = 1)
GO