Changeset 4381 for trunk/sources/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts

Timestamp:

09/13/10 01:21:32 (14 years ago)

Author:

swagner

Message:

Worked on OKB data model and services (#1174).

Location:

trunk/sources/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts

Files:

• Create OKB.sql (modified) (3 diffs)
• Initialize OKB.sql (modified) (previous)

trunk/sources/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts/Create OKB.sql

@@ -2 +2 @@
 GO
 
-/****** Object:  Database [HeuristicLab.OKB]    Script Date: 07/01/2009 13:11:18 ******/
+/****** Object:  Database [HeuristicLab.OKB]    Script Date: 09/12/2010 00:57:17 ******/
 IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'HeuristicLab.OKB')
 DROP DATABASE [HeuristicLab.OKB]
@@ -10 +10 @@
 GO
 
-/****** Object:  Database [HeuristicLab.OKB]    Script Date: 07/01/2009 13:11:18 ******/
+/****** Object:  Database [HeuristicLab.OKB]    Script Date: 09/12/2010 00:57:17 ******/
 CREATE DATABASE [HeuristicLab.OKB] ON  PRIMARY 
-( NAME = N'HeuristicLab.OKB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.HeuristicLab.OKB\MSSQL\DATA\HeuristicLab.OKB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
- FILEGROUP [DATA] 
-( NAME = N'HeuristicLab.OKB_DATA', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.HeuristicLab.OKB\MSSQL\DATA\HeuristicLab.OKB_DATA.ndf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
+( NAME = N'HeuristicLab.OKB', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\HeuristicLab.OKB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  LOG ON 
-( NAME = N'HeuristicLab.OKB_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.HeuristicLab.OKB\MSSQL\DATA\HeuristicLab.OKB_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
+( NAME = N'HeuristicLab.OKB_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\HeuristicLab.OKB_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
 GO
 
@@ -100 +98 @@
 GO
 
-ALTER DATABASE [HeuristicLab.OKB] SET RECOVERY FULL 
+ALTER DATABASE [HeuristicLab.OKB] SET RECOVERY SIMPLE 
 GO