Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
03/22/10 16:54:45 (14 years ago)
Author:
gkronber
Message:

Updated SQL script to create the DB for the deployment service. #918.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sources/HeuristicLab.Services.Deployment.DataAccess/3.3/CreateDeploymentServiceDatabase.sql

    r3086 r3180  
    1 USE [master]
     1USE [HeuristicLab.Deployment]
    22GO
    3 
    4 /****** Object:  Database [HeuristicLab.PluginStore]    Script Date: 02/08/2010 19:01:45 ******/
    5 CREATE DATABASE [HeuristicLab.PluginStore] ON  PRIMARY
    6 ( NAME = N'HeuristicLab.PluginStore', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\HeuristicLab.PluginStore.mdf' , SIZE = 22528KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
    7  LOG ON
    8 ( NAME = N'HeuristicLab.PluginStore_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\HeuristicLab.PluginStore_log.ldf' , SIZE = 2816KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
     3/****** Object:  User [DeploymentService]    Script Date: 03/22/2010 15:57:21 ******/
     4CREATE USER [DeploymentService] FOR LOGIN [SERVDEV\DeploymentService] WITH DEFAULT_SCHEMA=[dbo]
    95GO
    10 
    11 ALTER DATABASE [HeuristicLab.PluginStore] SET COMPATIBILITY_LEVEL = 90
    12 GO
    13 
    14 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
    15 begin
    16 EXEC [HeuristicLab.PluginStore].[dbo].[sp_fulltext_database] @action = 'enable'
    17 end
    18 GO
    19 
    20 ALTER DATABASE [HeuristicLab.PluginStore] SET ANSI_NULL_DEFAULT OFF
    21 GO
    22 
    23 ALTER DATABASE [HeuristicLab.PluginStore] SET ANSI_NULLS OFF
    24 GO
    25 
    26 ALTER DATABASE [HeuristicLab.PluginStore] SET ANSI_PADDING OFF
    27 GO
    28 
    29 ALTER DATABASE [HeuristicLab.PluginStore] SET ANSI_WARNINGS OFF
    30 GO
    31 
    32 ALTER DATABASE [HeuristicLab.PluginStore] SET ARITHABORT OFF
    33 GO
    34 
    35 ALTER DATABASE [HeuristicLab.PluginStore] SET AUTO_CLOSE OFF
    36 GO
    37 
    38 ALTER DATABASE [HeuristicLab.PluginStore] SET AUTO_CREATE_STATISTICS ON
    39 GO
    40 
    41 ALTER DATABASE [HeuristicLab.PluginStore] SET AUTO_SHRINK OFF
    42 GO
    43 
    44 ALTER DATABASE [HeuristicLab.PluginStore] SET AUTO_UPDATE_STATISTICS ON
    45 GO
    46 
    47 ALTER DATABASE [HeuristicLab.PluginStore] SET CURSOR_CLOSE_ON_COMMIT OFF
    48 GO
    49 
    50 ALTER DATABASE [HeuristicLab.PluginStore] SET CURSOR_DEFAULT  GLOBAL
    51 GO
    52 
    53 ALTER DATABASE [HeuristicLab.PluginStore] SET CONCAT_NULL_YIELDS_NULL OFF
    54 GO
    55 
    56 ALTER DATABASE [HeuristicLab.PluginStore] SET NUMERIC_ROUNDABORT OFF
    57 GO
    58 
    59 ALTER DATABASE [HeuristicLab.PluginStore] SET QUOTED_IDENTIFIER OFF
    60 GO
    61 
    62 ALTER DATABASE [HeuristicLab.PluginStore] SET RECURSIVE_TRIGGERS OFF
    63 GO
    64 
    65 ALTER DATABASE [HeuristicLab.PluginStore] SET  DISABLE_BROKER
    66 GO
    67 
    68 ALTER DATABASE [HeuristicLab.PluginStore] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
    69 GO
    70 
    71 ALTER DATABASE [HeuristicLab.PluginStore] SET DATE_CORRELATION_OPTIMIZATION OFF
    72 GO
    73 
    74 ALTER DATABASE [HeuristicLab.PluginStore] SET TRUSTWORTHY OFF
    75 GO
    76 
    77 ALTER DATABASE [HeuristicLab.PluginStore] SET ALLOW_SNAPSHOT_ISOLATION OFF
    78 GO
    79 
    80 ALTER DATABASE [HeuristicLab.PluginStore] SET PARAMETERIZATION SIMPLE
    81 GO
    82 
    83 ALTER DATABASE [HeuristicLab.PluginStore] SET READ_COMMITTED_SNAPSHOT OFF
    84 GO
    85 
    86 ALTER DATABASE [HeuristicLab.PluginStore] SET  READ_WRITE
    87 GO
    88 
    89 ALTER DATABASE [HeuristicLab.PluginStore] SET RECOVERY SIMPLE
    90 GO
    91 
    92 ALTER DATABASE [HeuristicLab.PluginStore] SET  MULTI_USER
    93 GO
    94 
    95 ALTER DATABASE [HeuristicLab.PluginStore] SET PAGE_VERIFY CHECKSUM 
    96 GO
    97 
    98 ALTER DATABASE [HeuristicLab.PluginStore] SET DB_CHAINING OFF
    99 GO
    100 
    101 USE [HeuristicLab.PluginStore]
    102 GO
    103 
    104 /****** Object:  Table [dbo].[Dependencies]    Script Date: 02/08/2010 19:02:19 ******/
     6/****** Object:  Table [dbo].[Plugin]    Script Date: 03/22/2010 15:57:25 ******/
    1057SET ANSI_NULLS ON
    1068GO
    107 
    1089SET QUOTED_IDENTIFIER ON
    10910GO
    110 
    111 CREATE TABLE [dbo].[Dependencies](
    112   [PluginId] [bigint] NOT NULL,
    113   [DependencyId] [bigint] NOT NULL,
    114  CONSTRAINT [PK_Dependencies] PRIMARY KEY CLUSTERED
    115 (
    116   [PluginId] ASC,
    117   [DependencyId] ASC
    118 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    119 ) ON [PRIMARY]
    120 
    121 GO
    122 
    123 ALTER TABLE [dbo].[Dependencies]  WITH CHECK ADD  CONSTRAINT [FK_Dependencies_Plugin] FOREIGN KEY([DependencyId])
    124 REFERENCES [dbo].[Plugin] ([Id])
    125 GO
    126 
    127 ALTER TABLE [dbo].[Dependencies] CHECK CONSTRAINT [FK_Dependencies_Plugin]
    128 GO
    129 
    130 ALTER TABLE [dbo].[Dependencies]  WITH CHECK ADD  CONSTRAINT [FK_Dependencies_Plugin2] FOREIGN KEY([PluginId])
    131 REFERENCES [dbo].[Plugin] ([Id])
    132 GO
    133 
    134 ALTER TABLE [dbo].[Dependencies] CHECK CONSTRAINT [FK_Dependencies_Plugin2]
    135 GO
    136 
    137 
    138 USE [HeuristicLab.PluginStore]
    139 GO
    140 
    141 /****** Object:  Table [dbo].[Plugin]    Script Date: 02/08/2010 19:02:48 ******/
    142 SET ANSI_NULLS ON
    143 GO
    144 
    145 SET QUOTED_IDENTIFIER ON
    146 GO
    147 
    14811CREATE TABLE [dbo].[Plugin](
    14912  [Id] [bigint] IDENTITY(1,1) NOT NULL,
    15013  [Name] [nvarchar](300) NOT NULL,
    15114  [Version] [nvarchar](50) NOT NULL,
     15  [ContactName] [text] NULL,
     16  [ContactEmail] [text] NULL,
     17  [License] [text] NULL,
    15218 CONSTRAINT [PK_Plugin] PRIMARY KEY CLUSTERED
    15319(
    … …  
    15925  [Version] ASC
    16026)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    161 ) ON [PRIMARY]
    162 
     27) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    16328GO
    164 
    165 
    166 USE [HeuristicLab.PluginStore]
    167 GO
    168 
    169 /****** Object:  Table [dbo].[PluginPackage]    Script Date: 02/08/2010 19:02:53 ******/
     29/****** Object:  Table [dbo].[Product]    Script Date: 03/22/2010 15:57:25 ******/
    17030SET ANSI_NULLS ON
    17131GO
    172 
    17332SET QUOTED_IDENTIFIER ON
    17433GO
    175 
    176 CREATE TABLE [dbo].[PluginPackage](
    177   [PluginId] [bigint] NOT NULL,
    178   [FileName] [text] NOT NULL,
    179   [Data] [image] NOT NULL,
    180  CONSTRAINT [PK_PluginPackage] PRIMARY KEY CLUSTERED
    181 (
    182   [PluginId] ASC
    183 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    184 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    185 
    186 GO
    187 
    188 ALTER TABLE [dbo].[PluginPackage]  WITH CHECK ADD  CONSTRAINT [FK_PluginPackage_Plugin] FOREIGN KEY([PluginId])
    189 REFERENCES [dbo].[Plugin] ([Id])
    190 GO
    191 
    192 ALTER TABLE [dbo].[PluginPackage] CHECK CONSTRAINT [FK_PluginPackage_Plugin]
    193 GO
    194 
    195 
    196 
    197 USE [HeuristicLab.PluginStore]
    198 GO
    199 
    200 /****** Object:  Table [dbo].[Product]    Script Date: 02/08/2010 19:02:56 ******/
    201 SET ANSI_NULLS ON
    202 GO
    203 
    204 SET QUOTED_IDENTIFIER ON
    205 GO
    206 
    20734CREATE TABLE [dbo].[Product](
    20835  [Id] [bigint] IDENTITY(1,1) NOT NULL,
    … …  
    21946)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    22047) ON [PRIMARY]
    221 
    22248GO
    223 
    224 
    225 USE [HeuristicLab.PluginStore]
    226 GO
    227 
    228 /****** Object:  Table [dbo].[ProductPlugin]    Script Date: 02/08/2010 19:03:01 ******/
     49/****** Object:  Table [dbo].[ProductPlugin]    Script Date: 03/22/2010 15:57:25 ******/
    22950SET ANSI_NULLS ON
    23051GO
    231 
    23252SET QUOTED_IDENTIFIER ON
    23353GO
    234 
    23554CREATE TABLE [dbo].[ProductPlugin](
    23655  [ProductId] [bigint] NOT NULL,
    … …  
    24261)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    24362) ON [PRIMARY]
    244 
    24563GO
    246 
     64/****** Object:  Table [dbo].[PluginPackage]    Script Date: 03/22/2010 15:57:25 ******/
     65SET ANSI_NULLS ON
     66GO
     67SET QUOTED_IDENTIFIER ON
     68GO
     69CREATE TABLE [dbo].[PluginPackage](
     70  [PluginId] [bigint] NOT NULL,
     71  [Data] [image] NOT NULL,
     72 CONSTRAINT [PK_PluginPackage] PRIMARY KEY CLUSTERED
     73(
     74  [PluginId] ASC
     75)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     76) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
     77GO
     78/****** Object:  Table [dbo].[Dependencies]    Script Date: 03/22/2010 15:57:25 ******/
     79SET ANSI_NULLS ON
     80GO
     81SET QUOTED_IDENTIFIER ON
     82GO
     83CREATE TABLE [dbo].[Dependencies](
     84  [PluginId] [bigint] NOT NULL,
     85  [DependencyId] [bigint] NOT NULL,
     86 CONSTRAINT [PK_Dependencies] PRIMARY KEY CLUSTERED
     87(
     88  [PluginId] ASC,
     89  [DependencyId] ASC
     90)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     91) ON [PRIMARY]
     92GO
     93/****** Object:  Check [CK_Dependencies]    Script Date: 03/22/2010 15:57:25 ******/
     94ALTER TABLE [dbo].[Dependencies]  WITH CHECK ADD  CONSTRAINT [CK_Dependencies] CHECK  (([PluginId]<>[DependencyId]))
     95GO
     96ALTER TABLE [dbo].[Dependencies] CHECK CONSTRAINT [CK_Dependencies]
     97GO
     98/****** Object:  ForeignKey [FK_ProductPlugin_Plugin]    Script Date: 03/22/2010 15:57:25 ******/
    24799ALTER TABLE [dbo].[ProductPlugin]  WITH CHECK ADD  CONSTRAINT [FK_ProductPlugin_Plugin] FOREIGN KEY([PluginId])
    248100REFERENCES [dbo].[Plugin] ([Id])
    249101GO
    250 
    251102ALTER TABLE [dbo].[ProductPlugin] CHECK CONSTRAINT [FK_ProductPlugin_Plugin]
    252103GO
    253 
     104/****** Object:  ForeignKey [FK_ProductPlugin_Product]    Script Date: 03/22/2010 15:57:25 ******/
    254105ALTER TABLE [dbo].[ProductPlugin]  WITH CHECK ADD  CONSTRAINT [FK_ProductPlugin_Product] FOREIGN KEY([ProductId])
    255106REFERENCES [dbo].[Product] ([Id])
    256107GO
    257 
    258108ALTER TABLE [dbo].[ProductPlugin] CHECK CONSTRAINT [FK_ProductPlugin_Product]
    259109GO
    260 
    261 
     110/****** Object:  ForeignKey [FK_PluginPackage_Plugin]    Script Date: 03/22/2010 15:57:25 ******/
     111ALTER TABLE [dbo].[PluginPackage]  WITH CHECK ADD  CONSTRAINT [FK_PluginPackage_Plugin] FOREIGN KEY([PluginId])
     112REFERENCES [dbo].[Plugin] ([Id])
     113GO
     114ALTER TABLE [dbo].[PluginPackage] CHECK CONSTRAINT [FK_PluginPackage_Plugin]
     115GO
     116/****** Object:  ForeignKey [FK_Dependencies_Plugin]    Script Date: 03/22/2010 15:57:25 ******/
     117ALTER TABLE [dbo].[Dependencies]  WITH CHECK ADD  CONSTRAINT [FK_Dependencies_Plugin] FOREIGN KEY([DependencyId])
     118REFERENCES [dbo].[Plugin] ([Id])
     119GO
     120ALTER TABLE [dbo].[Dependencies] CHECK CONSTRAINT [FK_Dependencies_Plugin]
     121GO
     122/****** Object:  ForeignKey [FK_Dependencies_Plugin2]    Script Date: 03/22/2010 15:57:25 ******/
     123ALTER TABLE [dbo].[Dependencies]  WITH CHECK ADD  CONSTRAINT [FK_Dependencies_Plugin2] FOREIGN KEY([PluginId])
     124REFERENCES [dbo].[Plugin] ([Id])
     125GO
     126ALTER TABLE [dbo].[Dependencies] CHECK CONSTRAINT [FK_Dependencies_Plugin2]
     127GO
Note: See TracChangeset for help on using the changeset viewer.