/[AnywhereTS-MSSQL]/trunk/TSAdminTool/CreateDatabase.sql
ViewVC logotype

Contents of /trunk/TSAdminTool/CreateDatabase.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 22 - (show annotations) (download) (as text)
Wed Jul 11 20:13:17 2012 UTC (8 years, 6 months ago) by william
File MIME type: application/octet-stream
File size: 1500 byte(s)
+ finish support for creating tables in an empty database (incase the database are pre-created, but contains no tables)
- still have AD login issues when creating the database from scratch (ie. it did not exist to begin with)

1 ÿþ-- This is the Anywhere TS main database creation script
2
3 --[Datadir] will be replaced runtime with the actual database directory, as chosen on the ATS config form.
4
5 USE [master]
6
7 GO
8
9 --CREATE DATABASE [AnywhereTS] ON PRIMARY
10
11 --( NAME = N'ats', FILENAME = N'[DataDir]\ats.mdf' , SIZE = 1536KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
12
13 -- LOG ON
14
15 --( NAME = N'ats_log', FILENAME = N'[DataDir]\ats_log.ldf' , SIZE = 768KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
16
17 CREATE DATABASE [AnywhereTS] ON PRIMARY
18
19 ( NAME = N'ats', FILENAME = N'[DataDir]\ats.mdf' , SIZE = 4096KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
20
21 LOG ON
22
23 ( NAME = N'ats_log', FILENAME = N'[DataDir]\ats_log.ldf' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
24
25

Properties

Name Value
svn:mime-type application/octet-stream

  ViewVC Help
Powered by ViewVC 1.1.22