text: USE [master]
  GO
  /****** Object:  Database [Lv-139.Net.PrompterPro.V7]    Script Date: 4/16/2015 1:12:30 PM ******/
  CREATE DATABASE [Lv-139.Net.PrompterPro.V7]
   CONTAINMENT = NONE
   ON  PRIMARY 
   /****** Please pay attention to the bit version of your system and SQL server version in the following path specifying******/ 
  ( NAME = N'Lv-139.Net.PrompterPro.V7', FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Lv-139.Net.PrompterPro.V7.mdf' , SIZE = 3136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
   LOG ON
  /****** Please pay attention to the bit version of your system and SQL server version in the following path specifying******/  
  ( NAME = N'Lv-139.Net.PrompterPro.V7_log', FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Lv-139.Net.PrompterPro.V7_log.ldf' , SIZE = 832KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET COMPATIBILITY_LEVEL = 110
  GO
  IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  begin
  EXEC [Lv-139.Net.PrompterPro.V7].[dbo].[sp_fulltext_database] @action = 'enable'
  end
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET ANSI_NULL_DEFAULT OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET ANSI_NULLS OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET ANSI_PADDING OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET ANSI_WARNINGS OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET ARITHABORT OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET AUTO_CLOSE OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET AUTO_CREATE_STATISTICS ON 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET AUTO_SHRINK OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET AUTO_UPDATE_STATISTICS ON 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET CURSOR_CLOSE_ON_COMMIT OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET CURSOR_DEFAULT  GLOBAL 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET CONCAT_NULL_YIELDS_NULL OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET NUMERIC_ROUNDABORT OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET QUOTED_IDENTIFIER OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET RECURSIVE_TRIGGERS OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET  ENABLE_BROKER 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET DATE_CORRELATION_OPTIMIZATION OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET TRUSTWORTHY OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET ALLOW_SNAPSHOT_ISOLATION OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET PARAMETERIZATION SIMPLE 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET READ_COMMITTED_SNAPSHOT ON 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET HONOR_BROKER_PRIORITY OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET RECOVERY FULL 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET  MULTI_USER 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET PAGE_VERIFY CHECKSUM  
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET DB_CHAINING OFF 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET TARGET_RECOVERY_TIME = 0 SECONDS 
  GO
  EXEC sys.sp_db_vardecimal_storage_format N'Lv-139.Net.PrompterPro.V7', N'ON'
  GO
  USE [Lv-139.Net.PrompterPro.V7]
  GO
  /****** Object:  Table [dbo].[__MigrationHistory]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_PADDING ON
  GO
  CREATE TABLE [dbo].[__MigrationHistory](
  	[MigrationId] [nvarchar](150) NOT NULL,
  	[ContextKey] [nvarchar](300) NOT NULL,
  	[Model] [varbinary](max) NOT NULL,
  	[ProductVersion] [nvarchar](32) NOT NULL,
   CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY CLUSTERED 
  (
  	[MigrationId] ASC,
  	[ContextKey] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
  GO
  SET ANSI_PADDING OFF
  GO
  /****** Object:  Table [dbo].[Diagnostics]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Diagnostics](
  	[DiagnosticsId] [int] IDENTITY(1,1) NOT NULL,
  	[UserId] [int] NOT NULL,
  	[ExceptionName] [nvarchar](max) NOT NULL,
  	[Message] [nvarchar](max) NOT NULL,
  	[Date] [datetime] NOT NULL,
   CONSTRAINT [PK_dbo.Diagnostics] PRIMARY KEY CLUSTERED 
  (
  	[DiagnosticsId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
  GO
  /****** Object:  Table [dbo].[History]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[History](
  	[HistoryId] [int] IDENTITY(1,1) NOT NULL,
  	[Description] [nvarchar](max) NULL,
  	[Date] [datetime] NOT NULL,
  	[ScriptId] [int] NOT NULL,
  	[PrompterId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.History] PRIMARY KEY CLUSTERED 
  (
  	[HistoryId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
  GO
  /****** Object:  Table [dbo].[Options]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Options](
  	[OptionsId] [int] IDENTITY(1,1) NOT NULL,
  	[FontSize] [int] NOT NULL,
  	[ReadingSpeed] [int] NOT NULL,
  	[AnnouncerName] [nvarchar](50) NOT NULL,
  	[Description] [nvarchar](500) NULL,
   CONSTRAINT [PK_dbo.Options] PRIMARY KEY CLUSTERED 
  (
  	[OptionsId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  /****** Object:  Table [dbo].[Roles]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Roles](
  	[RoleId] [int] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](50) NOT NULL,
   CONSTRAINT [PK_dbo.Roles] PRIMARY KEY CLUSTERED 
  (
  	[RoleId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  /****** Object:  Table [dbo].[Scripts]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Scripts](
  	[ScriptId] [int] IDENTITY(1,1) NOT NULL,
  	[Title] [nvarchar](250) NOT NULL,
  	[Description] [nvarchar](500) NULL,
  	[OperatorId] [int] NOT NULL,
  	[PrompterId] [int] NULL,
  	[OptionsId] [int] NOT NULL,
  	[CreatedDate] [datetime] NOT NULL,
  	[LastEditedDate] [datetime] NOT NULL,
   CONSTRAINT [PK_dbo.Scripts] PRIMARY KEY CLUSTERED 
  (
  	[ScriptId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  /****** Object:  Table [dbo].[Sections]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Sections](
  	[SectionId] [int] IDENTITY(1,1) NOT NULL,
  	[Order] [int] NOT NULL,
  	[Text] [nvarchar](max) NOT NULL,
  	[ScriptId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.Sections] PRIMARY KEY CLUSTERED 
  (
  	[SectionId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
  GO
  /****** Object:  Table [dbo].[UserActivity]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[UserActivity](
  	[LogId] [int] IDENTITY(1,1) NOT NULL,
  	[UserId] [int] NOT NULL,
  	[UserName] [nvarchar](50) NOT NULL,
  	[UserRoleName] [nvarchar](50) NOT NULL,
  	[Date] [datetime] NOT NULL,
  	[Description] [nvarchar](max) NOT NULL,
   CONSTRAINT [PK_dbo.UserActivity] PRIMARY KEY CLUSTERED 
  (
  	[LogId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
  GO
  /****** Object:  Table [dbo].[Users]    Script Date: 4/16/2015 1:12:31 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Users](
  	[UserId] [int] IDENTITY(1,1) NOT NULL,
  	[Login] [nvarchar](50) NOT NULL,
  	[Password] [nvarchar](50) NOT NULL,
  	[Disabled] [bit] NOT NULL,
  	[PrompterStatus] [nvarchar](50) NULL,
  	[RoleId] [int] NOT NULL,
   CONSTRAINT [PK_dbo.Users] PRIMARY KEY CLUSTERED 
  (
  	[UserId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  INSERT [dbo].[__MigrationHistory] ([MigrationId], [ContextKey], [Model], [ProductVersion]) VALUES (N'201504061920284_InitialCreate', N'SoftServe.ITA.PrompterPro.Infrastructure.Data.EF.PrompterDbContext.CreateDbContext', 0x1F8B0800000000000400ED5DDB6EE4B8117D0F907F10F49404B3DDB6070B24467B175E5F12239E0BA6BD8BBC0D6889EE11A24B47527BED04FB65FB904FCA2F8494448A5789A4D8EA9E20D8876D8BE2E1A50EABC8A2AAE63FBFFE7BF5FD4B9606CFB0AC9222BF084F17276100F3A888937C7311EEEAA76FFE187EFFDD6F7FB3BA89B397E027F2DE5BFC1EAA995717E197BADE9E2F9755F40566A05A6449541655F1542FA2225B82B8589E9D9CFC69797ABA840822445841B0FAB4CBEB2483CD1FE8CFAB228FE0B6DE81F45D11C3B4EA9EA39275831ABC0719ACB6208217E11A41AF61F90C17770F978B8F65916D6B58A2FF2FEEF2A7125475B98BEA5D0917D7A0068B9B5BFACAF5236AA6862F75185CA609403D5FC3F4290C409E1735A8D1B8CE7FACE0BA2E8B7CB3DEA207207D78DD42F4DE13482BD88DF7BC7FDD74E8276778E8CBBE22818A76555D649680A76FBBB95C8AD59D2412D2B946B37D83A452BFE25137337E115E27609317559D44551888ED9D5FA5257E774826D7A842922F5AB12E18B8378161A5379475889CF8BF37C1D52EC512BEC8E1AE2E41FA26F8B87B4C93E8AFF0F5A1F83BCC2FF25D9AB2E342234365DC03F408B5B48565FDFA093EC9A3BD8BC360C9432C450C8AA0AEDE4ECD5D5EBF3D0B83F7A84BE03185944CCC34AEEBA2847F86392C410DE38FA046D380B87017C3461C524784661169CBF1F686316E5EF0FA439DC17F1228B4149016088377E0E51EE69BFACB45887E86C16DF20263F2A483FF314F90D24095D0F283D6CDBF83550536076818E908DA2AFEFD90646320AB65BF4A06D7CE5F12B45CCA571FEBA6833AC635D375CD65BD3055E75A2BD7B08ACA64DB6ACBC964F3CE2D1964DD7477EAF22644B1C6790F9E934D33F31AC430F804D3E685EA4BB26D4D2AA1EBE7FEA55BF4EB5391F642A7659FD7C5AE8CF044159A171E40B981B579D7DA291BEC187945EE565BA2ED5457ACEA92B15EC0FADA8752C038C7A811883DB255076676CC9F2EB82F36C99016F8F6641F16E723A8AA9F8B329EBDE1EBA4C26FD3867F2810B341EEAC4BD6480ABB6AFA30865BC3CBCF9FD6C2684AC580B9F7B92DED75027D28A983BE649226681B9CAE0930CE316A02223C5B4D6026747F9A6064D3EB693D6A5989D954B9D092904FA62521AC132D89759C4ECC16E918A9D9EFAB6CC969BA23F347CF87A44E87F879B6278361B457FEF6C4879AFFB0C573534C3EC76A37BA63CD370B6F6AEB5725C402F6B2F1BF07557D1327CE705A6DD36E6513A8D638C63B6451F76836D0A6BD22045076AAC3ECDFE97B251449965A2CB73D4C74CC18EE56F78AA2574D89BE536DB16D9F06CF5E1DB6EAE82514E9BAE57EF082D1C064B5850A62F12512B184E249968D8A6ABA69EBA08ED1B631DACCD6B8192B427FD6EDB6C8EB75F24F384DF57E82005F59ACB7104E54E2976864BB3C82E53CBBC2398DEE88CB64A2969316AE5A09BA6D495B25E0654FDA421DE3C2EDBAE6B42BEDABCEB5703F9431B62F53D6DA43731B37B7D3DFD1A7EAE27034B67A922D561B456787E325827B6E84EAC7F148F08E7119DD171B9725D455FB9AAEED30C641CC146E1813F53036D2C7F9CAEF4D90D38DE165551551D2908999D6D6DFC3F7FD268F03AD4FB2ED3B7117A1EEA365956CD142424D5E847F90264205466D770FD6BA9D78B053090CAD3A5862C283F40A693EB48E93BC9697689247C916A4BA76850A16CE443CBB145E2CB9865B98E3E5A89BBC69ED527841D18CCDC96AC9487E9810D24D9A4E94FA6BB55EA2F442DA9C21DACBB811D679228AAE7913B9A9AFA1ACF8A29B5493E6594FD441A8233A4D7422D67A507A0993DD8B396F746E977968A3697D26D66826D4A475D60D7A58D2B487BD51F10AFE2D2F94114E933D263D82EE97345CFB6652D3F85BDC68C3CDE9E4F6E723CDA88DD2FA1F3DD0C6D6409D2C167E79732013A599D3AFC342F18763AD843527658635C43B64411B8DD3798C8ABE48A36CDE446ABA8B4B3BD628A7746AF333EE874728A3FB9ACBCB5EF8409451373F1B65D4537A7494694FDAF8437F540396DCC52C13002039C1902AEEFC605577A617698071D7B0567D18DF1FEF3B2270A512A17824E63E56C2A12C1DC1E8BE2091EAB7966FA43296AFAA72EB0018A94C6F0EA4EA64318C00D04D9D04404BC6BA40AF1DE53E10C360307F9D47532D08DE852AA03154E421BB4F779872E9BB1E71450C797A68AFA9C0A50535E4DB61AA7722173DA4FC400C06297FE82B8F75D88561E6C460BACE2C9781D16BFD166373E83009D2D709F21C0C9EC58D4EE34CBFE9921B18BFEEFCBDCFE1778B7060F48A43A5C9B1D275ECFC419241D16916E7C10FF17FF07464743E721BFF2CD417AEB714A31FD8E39BECF2D9B1533D3F3478F5BE7E7C0A27683FFDE887B6AB261B5667BDE773F8E4FA826EAA68D96AD98667760F564B4D1CE7EA1DD86E937CC3C475764F82751BD479F5CDDA3E7A316B319611A753C42D206D094D0CD840A114358D7A7A9B94558DE3451F01BEBCB98A33F935610BA9D95090D6E45DA22C34B2C72075F0EF6E5D4D8E715D0C34DD4FFF2D9A910CEFF19BBB4C862583B5031C960B52504A11065CFCE35591EEB2DC20B2720893B84858309DDB448F228437B260429139268D5964D1E843739CF636939BACE6898CB05A0A62938E5312A784352ED2D488C4BDE69999C2E4F4634F5F6D4D9D109850445612DAE0C64181B237CB9C5CD9827D104487D09FC05914FDB95C8FC4FA0C59AC215FE2C188DBEE7266266D73E4B667ACBADA7EB5621700C782748F2C0841C3D9383AD0A71634A7F169BCE1204FED494A22D454442565E6A8E43B00164DF76DC0C128DF1EEC67A6BCCA9161407975353FD3AF4391EDBFCEEC1F4880647B3EB308D507140321EA2AEEDF147551512C4CF7E870A69ABDBF67E186EEF5F5686EC656DF377A4BCC774D7B79ACC7E2029D5834AEC0C21209C14E9C4912CA8E66A9EAFD597B5DAA9A660DD6AAB6E61C94E9C33C58A8FEA98521E6423D387BC09598230A211F2CA450B47FD57228BB439C6B731B9EEE86C6C1F2E86A6A4D4F1F22C1D91E5DD0C5105617FBC0AD8AF69185016B6E2239FBD53CD9E7B9EE802731E67EED0047327A79E77634D3571F385C898251C6250C61F839E6F54102228EAD4EE3BFFA17D1FA92397D1B47A9672597B9F80A6D9DBACE0517F9AA73578FE74394FCD7ED2B618026EA3989B1EF7AFD5AD5306B57C8FA1FE9559AA0F1F62FBC0379F204ABBA8DBA09CF4E4ECF841489C793AE70595571AA70F76B7216F2223B5812C0044FF768BC90430C8ED0848FAC7FF93328A32FA0FC5D065E7E3F3593DF343036D02746BFEB3D64E7736088CF94777B618622B6492B08DB4C7686729041C4A8CB66E4D2775877790C5F2EC27F3595CE83BBBF7D26F5DE04CD0EEB3C38097EF19017C4B4F9BEA64507EC72C13950D04F8EB5BD908F4BAB46682745054ECC9AE60B574C8AF698D86B51D1A56CDC43FBFC67A6A46D6BED83B08AE0C4195381ED85B02AE367C72BDBCC5A0EF3E72F5FD55EE6904B51A59CC43397D5A9B763723A0CBB7525279C325D5B7DCDA3B548661320647A311F7F5771D2F015A9B29C7716EA5459BE378CEA98B8D913F2EC65F98A39785C0E13AA0C3C2E38CAFC3BDEECBD2F8D629DB9C645E77B4C07B317DA7019605C64CDE67F9976549CF174E19677C541FE3EF2981CA9E7414C5CE26B7DABF29278D31D3E6C95CDD17CCFA944DAE014EB8C1F7C888943FE11A7E837CD3726A6078DC0364DC8FF506A1023310DC99946A1B9C44F3A27889939C9C75712326D98D463B2CC494C83436CFED14B5CFBB1936AE7FE7524E4A0114D2EE9320E2775FDB72C1687A8FDC9FEEB48AB61B4D695F92EFEBFDC8F4EBF1BA6C43015D7A0CC4970B44B268D09A952664F73717C590A9C135B7811FCFCFBB9B9056FB3A73B86F4145208A2283AE7E413EDC720E8C0FA582079B7E74AFBEC14AF43B929544DD824AED0E6AD5001AB239745D8F6242BC1B68F55B0EA8408222C596A1230295041EB026E45708344182A78CB2C1943493294BDD7045D0FA5D050B1852FD64976E6141B2C4DFA9094A1F86A96AF7DDC96792CB56E289E13691875536D13145194D387E7354586FDE0F875CBC6AD781CDAF4F4178206184A5531F7F08678699EE0E2C824E73179856937D51B70C557EDFE548A87EC146EC3F3A3522CB24FC89FCCA29D1AF30F8DA36D62956C7A08FCCF8EE7ED7CF7A0E49DBBFCA9209B45A147E415E9D3C71AC468037759D6C913886A541CC1AA6A528AFF04D21D7AE5267B84F15DFE61576F77351A32CC1E536E32F09673A8FD26C506DFE755A7227C0C017533C1571B1FF21F76491AD37EDF2A6E223410782FDB5D356159D6F8CA69F34A91DE17B92150377D740BFE00B36D8AC0AA0FF91A3C4397BE2175730F37207A255F3EEB41C605C14FFB0A6FAA4B90551D465F1FFD89381C672FDFFD171187D2796F7F0000, N'6.1.2-31219')
  GO
  SET IDENTITY_INSERT [dbo].[Roles] ON 
  
  GO
  INSERT [dbo].[Roles] ([RoleId], [Name]) VALUES (1, N'Admin')
  GO
  INSERT [dbo].[Roles] ([RoleId], [Name]) VALUES (2, N'Operator')
  GO
  INSERT [dbo].[Roles] ([RoleId], [Name]) VALUES (3, N'Prompter')
  GO
  SET IDENTITY_INSERT [dbo].[Roles] OFF
  GO
  SET IDENTITY_INSERT [dbo].[Users] ON 
  
  GO
  INSERT [dbo].[Users] ([UserId], [Login], [Password], [Disabled], [PrompterStatus], [RoleId]) VALUES (1, N'Admin', N'e3afed0047b08059d0fada10f400c1e5', 0, NULL, 1)
  GO
  INSERT [dbo].[Users] ([UserId], [Login], [Password], [Disabled], [PrompterStatus], [RoleId]) VALUES (4, N'Operator', N'e1b3ec89ead7f83a9245ed5c9cacfdbf', 0, NULL, 2)
  GO
  INSERT [dbo].[Users] ([UserId], [Login], [Password], [Disabled], [PrompterStatus], [RoleId]) VALUES (8, N'Prompter', N'ef3318023090fa958a484c126ba577f2', 0, N'Off', 3)
  GO
  SET IDENTITY_INSERT [dbo].[Users] OFF
  GO
  /****** Object:  Index [IX_PrompterId]    Script Date: 4/16/2015 1:12:31 PM ******/
  CREATE NONCLUSTERED INDEX [IX_PrompterId] ON [dbo].[History]
  (
  	[PrompterId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  /****** Object:  Index [IX_ScriptId]    Script Date: 4/16/2015 1:12:31 PM ******/
  CREATE NONCLUSTERED INDEX [IX_ScriptId] ON [dbo].[History]
  (
  	[ScriptId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  /****** Object:  Index [IX_OperatorId]    Script Date: 4/16/2015 1:12:31 PM ******/
  CREATE NONCLUSTERED INDEX [IX_OperatorId] ON [dbo].[Scripts]
  (
  	[OperatorId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  /****** Object:  Index [IX_OptionsId]    Script Date: 4/16/2015 1:12:31 PM ******/
  CREATE NONCLUSTERED INDEX [IX_OptionsId] ON [dbo].[Scripts]
  (
  	[OptionsId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  /****** Object:  Index [IX_PrompterId]    Script Date: 4/16/2015 1:12:31 PM ******/
  CREATE NONCLUSTERED INDEX [IX_PrompterId] ON [dbo].[Scripts]
  (
  	[PrompterId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  /****** Object:  Index [IX_ScriptId]    Script Date: 4/16/2015 1:12:31 PM ******/
  CREATE NONCLUSTERED INDEX [IX_ScriptId] ON [dbo].[Sections]
  (
  	[ScriptId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  /****** Object:  Index [IX_RoleId]    Script Date: 4/16/2015 1:12:31 PM ******/
  CREATE NONCLUSTERED INDEX [IX_RoleId] ON [dbo].[Users]
  (
  	[RoleId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  ALTER TABLE [dbo].[History]  WITH CHECK ADD  CONSTRAINT [FK_dbo.History_dbo.Scripts_ScriptId] FOREIGN KEY([ScriptId])
  REFERENCES [dbo].[Scripts] ([ScriptId])
  GO
  ALTER TABLE [dbo].[History] CHECK CONSTRAINT [FK_dbo.History_dbo.Scripts_ScriptId]
  GO
  ALTER TABLE [dbo].[History]  WITH CHECK ADD  CONSTRAINT [FK_dbo.History_dbo.Users_PrompterId] FOREIGN KEY([PrompterId])
  REFERENCES [dbo].[Users] ([UserId])
  GO
  ALTER TABLE [dbo].[History] CHECK CONSTRAINT [FK_dbo.History_dbo.Users_PrompterId]
  GO
  ALTER TABLE [dbo].[Scripts]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Scripts_dbo.Options_OptionsId] FOREIGN KEY([OptionsId])
  REFERENCES [dbo].[Options] ([OptionsId])
  GO
  ALTER TABLE [dbo].[Scripts] CHECK CONSTRAINT [FK_dbo.Scripts_dbo.Options_OptionsId]
  GO
  ALTER TABLE [dbo].[Scripts]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Scripts_dbo.Users_OperatorId] FOREIGN KEY([OperatorId])
  REFERENCES [dbo].[Users] ([UserId])
  GO
  ALTER TABLE [dbo].[Scripts] CHECK CONSTRAINT [FK_dbo.Scripts_dbo.Users_OperatorId]
  GO
  ALTER TABLE [dbo].[Scripts]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Scripts_dbo.Users_PrompterId] FOREIGN KEY([PrompterId])
  REFERENCES [dbo].[Users] ([UserId])
  GO
  ALTER TABLE [dbo].[Scripts] CHECK CONSTRAINT [FK_dbo.Scripts_dbo.Users_PrompterId]
  GO
  ALTER TABLE [dbo].[Sections]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Sections_dbo.Scripts_ScriptId] FOREIGN KEY([ScriptId])
  REFERENCES [dbo].[Scripts] ([ScriptId])
  GO
  ALTER TABLE [dbo].[Sections] CHECK CONSTRAINT [FK_dbo.Sections_dbo.Scripts_ScriptId]
  GO
  ALTER TABLE [dbo].[Users]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Users_dbo.Roles_RoleId] FOREIGN KEY([RoleId])
  REFERENCES [dbo].[Roles] ([RoleId])
  GO
  ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_dbo.Users_dbo.Roles_RoleId]
  GO
  USE [master]
  GO
  ALTER DATABASE [Lv-139.Net.PrompterPro.V7] SET  READ_WRITE 
  GO
  