- Timestamp:
- 03/15/12 13:26:25 (12 years ago)
- Location:
- branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3
- Files:
-
- 3 added
- 3 deleted
- 7 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/HeuristicLab.Services.Access.DataAccess-3.3.csproj
r7367 r7619 53 53 <DependentUpon>ASPNETAuthentication.dbml</DependentUpon> 54 54 </Compile> 55 <Compile Include=" ClientManagement.designer.cs">56 <DependentUpon> ClientManagement.dbml</DependentUpon>55 <Compile Include="AccessService.designer.cs"> 56 <DependentUpon>AccessService.dbml</DependentUpon> 57 57 <DesignTime>True</DesignTime> 58 58 <AutoGen>True</AutoGen> … … 72 72 <SubType>Designer</SubType> 73 73 </None> 74 <None Include=" ClientManagement.dbml">74 <None Include="AccessService.dbml"> 75 75 <Generator>MSLinqToSQLGenerator</Generator> 76 <LastGenOutput> ClientManagement.designer.cs</LastGenOutput>76 <LastGenOutput>AccessService.designer.cs</LastGenOutput> 77 77 <SubType>Designer</SubType> 78 78 </None> … … 93 93 </ItemGroup> 94 94 <ItemGroup> 95 <None Include=" ClientManagement.dbml.layout">96 <DependentUpon> ClientManagement.dbml</DependentUpon>95 <None Include="AccessService.dbml.layout"> 96 <DependentUpon>AccessService.dbml</DependentUpon> 97 97 </None> 98 98 </ItemGroup> -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/Properties/Settings.Designer.cs
r6815 r7619 2 2 // <auto-generated> 3 3 // This code was generated by a tool. 4 // Runtime Version:4.0.30319. 2374 // Runtime Version:4.0.30319.530 5 5 // 6 6 // Changes to this file may cause incorrect behavior and will be lost if … … 38 38 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 39 39 [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)] 40 [global::System.Configuration.DefaultSettingValueAttribute("Data Source=.;Initial Catalog=HeuristicLab. ClientManagement;Integrated Security=T" +41 " rue")]40 [global::System.Configuration.DefaultSettingValueAttribute("Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True" + 41 "")] 42 42 public string HeuristicLab_ClientManagementConnectionString { 43 43 get { -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/Properties/Settings.settings
r6815 r7619 14 14 <DesignTimeValue Profile="(Default)"><?xml version="1.0" encoding="utf-16"?> 15 15 <SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> 16 <ConnectionString>Data Source=.;Initial Catalog=HeuristicLab. ClientManagement;Integrated Security=True</ConnectionString>16 <ConnectionString>Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True</ConnectionString> 17 17 <ProviderName>System.Data.SqlClient</ProviderName> 18 18 </SerializableConnectionString></DesignTimeValue> 19 <Value Profile="(Default)">Data Source=.;Initial Catalog=HeuristicLab. ClientManagement;Integrated Security=True</Value>19 <Value Profile="(Default)">Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True</Value> 20 20 </Setting> 21 21 </Settings> -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Create ClientManagement.sql
r6815 r7619 2 2 GO 3 3 4 /****** Object: Database [HeuristicLab. ClientManagement] Script Date: 09/19/2011 13:21:28 ******/5 CREATE DATABASE [HeuristicLab. ClientManagement] ON PRIMARY6 ( NAME = N'HeuristicLab. ClientManagement', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HeuristicLab.ClientManagement.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )4 /****** Object: Database [HeuristicLab.AccessService] Script Date: 09/19/2011 13:21:28 ******/ 5 CREATE DATABASE [HeuristicLab.AccessService] ON PRIMARY 6 ( NAME = N'HeuristicLab.AccessService', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HeuristicLab.AccessService.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) 7 7 LOG ON 8 ( NAME = N'HeuristicLab. ClientManagement_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HeuristicLab.ClientManagement_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)8 ( NAME = N'HeuristicLab.AccessService_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HeuristicLab.AccessService_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) 9 9 GO 10 10 11 ALTER DATABASE [HeuristicLab. ClientManagement] SET COMPATIBILITY_LEVEL = 10011 ALTER DATABASE [HeuristicLab.AccessService] SET COMPATIBILITY_LEVEL = 100 12 12 GO 13 13 14 14 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) 15 15 begin 16 EXEC [HeuristicLab. ClientManagement].[dbo].[sp_fulltext_database] @action = 'enable'16 EXEC [HeuristicLab.AccessService].[dbo].[sp_fulltext_database] @action = 'enable' 17 17 end 18 18 GO 19 19 20 ALTER DATABASE [HeuristicLab. ClientManagement] SET ANSI_NULL_DEFAULT OFF20 ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_NULL_DEFAULT OFF 21 21 GO 22 22 23 ALTER DATABASE [HeuristicLab. ClientManagement] SET ANSI_NULLS OFF23 ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_NULLS OFF 24 24 GO 25 25 26 ALTER DATABASE [HeuristicLab. ClientManagement] SET ANSI_PADDING OFF26 ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_PADDING OFF 27 27 GO 28 28 29 ALTER DATABASE [HeuristicLab. ClientManagement] SET ANSI_WARNINGS OFF29 ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_WARNINGS OFF 30 30 GO 31 31 32 ALTER DATABASE [HeuristicLab. ClientManagement] SET ARITHABORT OFF32 ALTER DATABASE [HeuristicLab.AccessService] SET ARITHABORT OFF 33 33 GO 34 34 35 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_CLOSE OFF35 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_CLOSE OFF 36 36 GO 37 37 38 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_CREATE_STATISTICS ON38 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_CREATE_STATISTICS ON 39 39 GO 40 40 41 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_SHRINK OFF41 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_SHRINK OFF 42 42 GO 43 43 44 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_UPDATE_STATISTICS ON44 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_UPDATE_STATISTICS ON 45 45 GO 46 46 47 ALTER DATABASE [HeuristicLab. ClientManagement] SET CURSOR_CLOSE_ON_COMMIT OFF47 ALTER DATABASE [HeuristicLab.AccessService] SET CURSOR_CLOSE_ON_COMMIT OFF 48 48 GO 49 49 50 ALTER DATABASE [HeuristicLab. ClientManagement] SET CURSOR_DEFAULT GLOBAL50 ALTER DATABASE [HeuristicLab.AccessService] SET CURSOR_DEFAULT GLOBAL 51 51 GO 52 52 53 ALTER DATABASE [HeuristicLab. ClientManagement] SET CONCAT_NULL_YIELDS_NULL OFF53 ALTER DATABASE [HeuristicLab.AccessService] SET CONCAT_NULL_YIELDS_NULL OFF 54 54 GO 55 55 56 ALTER DATABASE [HeuristicLab. ClientManagement] SET NUMERIC_ROUNDABORT OFF56 ALTER DATABASE [HeuristicLab.AccessService] SET NUMERIC_ROUNDABORT OFF 57 57 GO 58 58 59 ALTER DATABASE [HeuristicLab. ClientManagement] SET QUOTED_IDENTIFIER OFF59 ALTER DATABASE [HeuristicLab.AccessService] SET QUOTED_IDENTIFIER OFF 60 60 GO 61 61 62 ALTER DATABASE [HeuristicLab. ClientManagement] SET RECURSIVE_TRIGGERS OFF62 ALTER DATABASE [HeuristicLab.AccessService] SET RECURSIVE_TRIGGERS OFF 63 63 GO 64 64 65 ALTER DATABASE [HeuristicLab. ClientManagement] SET DISABLE_BROKER65 ALTER DATABASE [HeuristicLab.AccessService] SET DISABLE_BROKER 66 66 GO 67 67 68 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_UPDATE_STATISTICS_ASYNC OFF68 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 69 69 GO 70 70 71 ALTER DATABASE [HeuristicLab. ClientManagement] SET DATE_CORRELATION_OPTIMIZATION OFF71 ALTER DATABASE [HeuristicLab.AccessService] SET DATE_CORRELATION_OPTIMIZATION OFF 72 72 GO 73 73 74 ALTER DATABASE [HeuristicLab. ClientManagement] SET TRUSTWORTHY OFF74 ALTER DATABASE [HeuristicLab.AccessService] SET TRUSTWORTHY OFF 75 75 GO 76 76 77 ALTER DATABASE [HeuristicLab. ClientManagement] SET ALLOW_SNAPSHOT_ISOLATION OFF77 ALTER DATABASE [HeuristicLab.AccessService] SET ALLOW_SNAPSHOT_ISOLATION OFF 78 78 GO 79 79 80 ALTER DATABASE [HeuristicLab. ClientManagement] SET PARAMETERIZATION SIMPLE80 ALTER DATABASE [HeuristicLab.AccessService] SET PARAMETERIZATION SIMPLE 81 81 GO 82 82 83 ALTER DATABASE [HeuristicLab. ClientManagement] SET READ_COMMITTED_SNAPSHOT OFF83 ALTER DATABASE [HeuristicLab.AccessService] SET READ_COMMITTED_SNAPSHOT OFF 84 84 GO 85 85 86 ALTER DATABASE [HeuristicLab. ClientManagement] SET HONOR_BROKER_PRIORITY OFF86 ALTER DATABASE [HeuristicLab.AccessService] SET HONOR_BROKER_PRIORITY OFF 87 87 GO 88 88 89 ALTER DATABASE [HeuristicLab. ClientManagement] SET READ_WRITE89 ALTER DATABASE [HeuristicLab.AccessService] SET READ_WRITE 90 90 GO 91 91 92 ALTER DATABASE [HeuristicLab. ClientManagement] SET RECOVERY FULL92 ALTER DATABASE [HeuristicLab.AccessService] SET RECOVERY FULL 93 93 GO 94 94 95 ALTER DATABASE [HeuristicLab. ClientManagement] SET MULTI_USER95 ALTER DATABASE [HeuristicLab.AccessService] SET MULTI_USER 96 96 GO 97 97 98 ALTER DATABASE [HeuristicLab. ClientManagement] SET PAGE_VERIFY CHECKSUM98 ALTER DATABASE [HeuristicLab.AccessService] SET PAGE_VERIFY CHECKSUM 99 99 GO 100 100 101 ALTER DATABASE [HeuristicLab. ClientManagement] SET DB_CHAINING OFF101 ALTER DATABASE [HeuristicLab.AccessService] SET DB_CHAINING OFF 102 102 GO 103 103 -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Create Initial Values.sql
r6852 r7619 1 USE [HeuristicLab. ClientManagement]1 USE [HeuristicLab.AccessService] 2 2 GO 3 3 4 4 /** Client Configuration **/ 5 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[ClientConfiguration] (Hash, Description) VALUES ('','Custom Configuration');5 INSERT INTO [HeuristicLab.AccessService].[dbo].[ClientConfiguration] (Hash, Description) VALUES ('','Custom Configuration'); 6 6 7 7 /** Country **/ 8 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('N/A');9 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Asia/Pacific Region');10 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Europe');11 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Andorra');12 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('United Arab Emirates');13 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Afghanistan');14 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Antigua and Barbuda');15 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Anguilla');16 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Albania');17 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Armenia');18 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Netherlands Antilles');19 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Angola');20 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Antarctica');21 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Argentina');22 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('American Samoa');23 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Austria');24 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Australia');25 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Aruba');26 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Azerbaijan');27 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bosnia and Herzegovina');28 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Barbados');29 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bangladesh');30 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Belgium');31 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Burkina Faso');32 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bulgaria');33 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bahrain');34 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Burundi');35 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Benin');36 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bermuda');37 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Brunei Darussalam');38 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bolivia');39 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Brazil');40 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bahamas');41 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bhutan');42 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Bouvet Island');43 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Botswana');44 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Belarus');45 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Belize');46 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Canada');47 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cocos (Keeling) Islands');48 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Congo, The Democratic Republic of the');49 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Central African Republic');50 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Congo');51 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Switzerland');52 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cote D''Ivoire');53 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cook Islands');54 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Chile');55 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cameroon');56 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('China');57 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Colombia');58 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Costa Rica');59 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cuba');60 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cape Verde');61 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Christmas Island');62 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cyprus');63 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Czech Republic');64 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Germany');65 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Djibouti');66 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Denmark');67 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Dominica');68 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Dominican Republic');69 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Algeria');70 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Ecuador');71 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Estonia');72 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Egypt');73 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Western Sahara');74 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Eritrea');75 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Spain');76 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Ethiopia');77 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Finland');78 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Fiji');79 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Falkland Islands (Malvinas)');80 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Micronesia, Federated States of');81 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Faroe Islands');82 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('France');83 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('France, Metropolitan');84 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Gabon');85 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('United Kingdom');86 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Grenada');87 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Georgia');88 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('French Guiana');89 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Ghana');90 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Gibraltar');91 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Greenland');92 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Gambia');93 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Guinea');94 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Guadeloupe');95 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Equatorial Guinea');96 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Greece');97 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('South Georgia and the South Sandwich Islands');98 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Guatemala');99 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Guam');100 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Guinea-Bissau');101 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Guyana');102 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Hong Kong');103 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Heard Island and McDonald Islands');104 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Honduras');105 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Croatia');106 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Haiti');107 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Hungary');108 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Indonesia');109 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Ireland');110 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Israel');111 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('India');112 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('British Indian Ocean Territory');113 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Iraq');114 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Iran, Islamic Republic of');115 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Iceland');116 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Italy');117 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Jamaica');118 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Jordan');119 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Japan');120 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Kenya');121 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Kyrgyzstan');122 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cambodia');123 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Kiribati');124 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Comoros');125 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Kitts and Nevis');126 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Korea, Democratic People''s Republic of');127 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Korea, Republic of');128 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Kuwait');129 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Cayman Islands');130 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Kazakhstan');131 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Lao People''s Democratic Republic');132 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Lebanon');133 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Lucia');134 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Liechtenstein');135 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Sri Lanka');136 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Liberia');137 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Lesotho');138 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Lithuania');139 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Luxembourg');140 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Latvia');141 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Libyan Arab Jamahiriya');142 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Morocco');143 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Monaco');144 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Moldova, Republic of');145 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Madagascar');146 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Marshall Islands');147 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Macedonia, the Former Yugoslav Republic of');148 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Mali');149 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Myanmar');150 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Mongolia');151 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Macau');152 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Northern Mariana Islands');153 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Martinique');154 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Mauritania');155 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Montserrat');156 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Malta');157 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Mauritius');158 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Maldives');159 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Malawi');160 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Mexico');161 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Malaysia');162 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Mozambique');163 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Namibia');164 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('New Caledonia');165 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Niger');166 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Norfolk Island');167 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Nigeria');168 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Nicaragua');169 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Netherlands');170 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Norway');171 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Nepal');172 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Nauru');173 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Niue');174 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('New Zealand');175 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Oman');176 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Panama');177 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Peru');178 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('French Polynesia');179 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Papua New Guinea');180 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Philippines');181 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Pakistan');182 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Poland');183 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Pierre and Miquelon');184 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Pitcairn');185 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Puerto Rico');186 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Palestinian Territory, Occupied');187 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Portugal');188 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Palau');189 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Paraguay');190 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Qatar');191 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Reunion');192 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Romania');193 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Russian Federation');194 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Rwanda');195 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Saudi Arabia');196 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Solomon Islands');197 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Seychelles');198 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Sudan');199 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Sweden');200 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Singapore');201 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Helena');202 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Slovenia');203 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Svalbard and Jan Mayen');204 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Slovakia');205 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Sierra Leone');206 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('San Marino');207 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Senegal');208 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Somalia');209 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Suriname');210 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Sao Tome and Principe');211 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('El Salvador');212 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Syrian Arab Republic');213 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Swaziland');214 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Turks and Caicos Islands');215 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Chad');216 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('French Southern Territories');217 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Togo');218 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Thailand');219 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Tajikistan');220 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Tokelau');221 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Turkmenistan');222 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Tunisia');223 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Tonga');224 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Timor-Leste');225 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Turkey');226 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Trinidad and Tobago');227 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Tuvalu');228 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Taiwan');229 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Tanzania, United Republic of');230 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Ukraine');231 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Uganda');232 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('United States Minor Outlying Islands');233 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('United States');234 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Uruguay');235 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Uzbekistan');236 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Holy See (Vatican City State)');237 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Vincent and the Grenadines');238 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Venezuela');239 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Virgin Islands, British');240 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Virgin Islands, U.S.');241 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Vietnam');242 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Vanuatu');243 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Wallis and Futuna');244 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Samoa');245 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Yemen');246 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Mayotte');247 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Serbia');248 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('South Africa');249 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Zambia');250 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Montenegro');251 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Zimbabwe');252 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Anonymous Proxy');253 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Satellite Provider');254 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Other');255 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Aland Islands');256 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Guernsey');257 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Isle of Man');258 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Jersey');259 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Barthelemy');260 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Martin');8 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('N/A'); 9 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Asia/Pacific Region'); 10 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Europe'); 11 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Andorra'); 12 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United Arab Emirates'); 13 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Afghanistan'); 14 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Antigua and Barbuda'); 15 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Anguilla'); 16 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Albania'); 17 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Armenia'); 18 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Netherlands Antilles'); 19 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Angola'); 20 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Antarctica'); 21 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Argentina'); 22 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('American Samoa'); 23 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Austria'); 24 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Australia'); 25 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Aruba'); 26 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Azerbaijan'); 27 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bosnia and Herzegovina'); 28 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Barbados'); 29 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bangladesh'); 30 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belgium'); 31 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Burkina Faso'); 32 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bulgaria'); 33 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bahrain'); 34 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Burundi'); 35 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Benin'); 36 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bermuda'); 37 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Brunei Darussalam'); 38 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bolivia'); 39 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Brazil'); 40 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bahamas'); 41 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bhutan'); 42 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bouvet Island'); 43 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Botswana'); 44 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belarus'); 45 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belize'); 46 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Canada'); 47 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cocos (Keeling) Islands'); 48 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Congo, The Democratic Republic of the'); 49 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Central African Republic'); 50 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Congo'); 51 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Switzerland'); 52 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cote D''Ivoire'); 53 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cook Islands'); 54 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Chile'); 55 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cameroon'); 56 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('China'); 57 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Colombia'); 58 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Costa Rica'); 59 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cuba'); 60 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cape Verde'); 61 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Christmas Island'); 62 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cyprus'); 63 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Czech Republic'); 64 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Germany'); 65 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Djibouti'); 66 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Denmark'); 67 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Dominica'); 68 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Dominican Republic'); 69 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Algeria'); 70 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ecuador'); 71 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Estonia'); 72 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Egypt'); 73 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Western Sahara'); 74 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Eritrea'); 75 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Spain'); 76 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ethiopia'); 77 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Finland'); 78 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Fiji'); 79 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Falkland Islands (Malvinas)'); 80 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Micronesia, Federated States of'); 81 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Faroe Islands'); 82 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('France'); 83 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('France, Metropolitan'); 84 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gabon'); 85 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United Kingdom'); 86 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Grenada'); 87 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Georgia'); 88 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Guiana'); 89 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ghana'); 90 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gibraltar'); 91 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Greenland'); 92 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gambia'); 93 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guinea'); 94 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guadeloupe'); 95 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Equatorial Guinea'); 96 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Greece'); 97 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('South Georgia and the South Sandwich Islands'); 98 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guatemala'); 99 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guam'); 100 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guinea-Bissau'); 101 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guyana'); 102 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Hong Kong'); 103 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Heard Island and McDonald Islands'); 104 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Honduras'); 105 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Croatia'); 106 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Haiti'); 107 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Hungary'); 108 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Indonesia'); 109 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ireland'); 110 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Israel'); 111 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('India'); 112 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('British Indian Ocean Territory'); 113 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iraq'); 114 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iran, Islamic Republic of'); 115 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iceland'); 116 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Italy'); 117 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jamaica'); 118 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jordan'); 119 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Japan'); 120 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kenya'); 121 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kyrgyzstan'); 122 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cambodia'); 123 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kiribati'); 124 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Comoros'); 125 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Kitts and Nevis'); 126 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Korea, Democratic People''s Republic of'); 127 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Korea, Republic of'); 128 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kuwait'); 129 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cayman Islands'); 130 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kazakhstan'); 131 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lao People''s Democratic Republic'); 132 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lebanon'); 133 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Lucia'); 134 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Liechtenstein'); 135 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sri Lanka'); 136 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Liberia'); 137 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lesotho'); 138 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lithuania'); 139 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Luxembourg'); 140 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Latvia'); 141 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Libyan Arab Jamahiriya'); 142 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Morocco'); 143 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Monaco'); 144 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Moldova, Republic of'); 145 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Madagascar'); 146 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Marshall Islands'); 147 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Macedonia, the Former Yugoslav Republic of'); 148 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mali'); 149 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Myanmar'); 150 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mongolia'); 151 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Macau'); 152 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Northern Mariana Islands'); 153 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Martinique'); 154 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mauritania'); 155 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Montserrat'); 156 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malta'); 157 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mauritius'); 158 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Maldives'); 159 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malawi'); 160 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mexico'); 161 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malaysia'); 162 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mozambique'); 163 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Namibia'); 164 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('New Caledonia'); 165 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Niger'); 166 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Norfolk Island'); 167 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nigeria'); 168 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nicaragua'); 169 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Netherlands'); 170 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Norway'); 171 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nepal'); 172 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nauru'); 173 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Niue'); 174 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('New Zealand'); 175 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Oman'); 176 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Panama'); 177 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Peru'); 178 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Polynesia'); 179 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Papua New Guinea'); 180 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Philippines'); 181 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Pakistan'); 182 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Poland'); 183 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Pierre and Miquelon'); 184 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Pitcairn'); 185 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Puerto Rico'); 186 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Palestinian Territory, Occupied'); 187 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Portugal'); 188 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Palau'); 189 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Paraguay'); 190 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Qatar'); 191 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Reunion'); 192 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Romania'); 193 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Russian Federation'); 194 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Rwanda'); 195 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saudi Arabia'); 196 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Solomon Islands'); 197 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Seychelles'); 198 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sudan'); 199 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sweden'); 200 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Singapore'); 201 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Helena'); 202 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Slovenia'); 203 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Svalbard and Jan Mayen'); 204 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Slovakia'); 205 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sierra Leone'); 206 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('San Marino'); 207 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Senegal'); 208 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Somalia'); 209 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Suriname'); 210 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sao Tome and Principe'); 211 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('El Salvador'); 212 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Syrian Arab Republic'); 213 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Swaziland'); 214 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turks and Caicos Islands'); 215 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Chad'); 216 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Southern Territories'); 217 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Togo'); 218 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Thailand'); 219 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tajikistan'); 220 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tokelau'); 221 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turkmenistan'); 222 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tunisia'); 223 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tonga'); 224 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Timor-Leste'); 225 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turkey'); 226 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Trinidad and Tobago'); 227 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tuvalu'); 228 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Taiwan'); 229 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tanzania, United Republic of'); 230 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ukraine'); 231 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uganda'); 232 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United States Minor Outlying Islands'); 233 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United States'); 234 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uruguay'); 235 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uzbekistan'); 236 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Holy See (Vatican City State)'); 237 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Vincent and the Grenadines'); 238 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Venezuela'); 239 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Virgin Islands, British'); 240 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Virgin Islands, U.S.'); 241 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Vietnam'); 242 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Vanuatu'); 243 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Wallis and Futuna'); 244 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Samoa'); 245 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Yemen'); 246 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mayotte'); 247 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Serbia'); 248 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('South Africa'); 249 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Zambia'); 250 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Montenegro'); 251 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Zimbabwe'); 252 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Anonymous Proxy'); 253 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Satellite Provider'); 254 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Other'); 255 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Aland Islands'); 256 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guernsey'); 257 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Isle of Man'); 258 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jersey'); 259 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Barthelemy'); 260 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Martin'); -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Initialize ClientManagement.sql
r7534 r7619 1 USE [HeuristicLab. ClientManagement]1 USE [HeuristicLab.AccessService] 2 2 GO 3 3 … … 24 24 GO 25 25 26 USE [HeuristicLab.ClientManagement] 27 GO 28 29 /****** Object: Table [dbo].[ClientError] Script Date: 09/27/2011 17:05:38 ******/ 30 SET ANSI_NULLS ON 31 GO 32 33 SET QUOTED_IDENTIFIER ON 34 GO 35 36 CREATE TABLE [dbo].[ClientError]( 37 [Id] [uniqueidentifier] NOT NULL, 38 [Timestamp] [datetime] NOT NULL, 39 [Exception] [nvarchar](max) NULL, 40 [UserComment] [nvarchar](max) NULL, 41 [ConfigDump] [nvarchar](max) NULL, 42 [ClientId] [uniqueidentifier] NULL, 43 [UserId] [uniqueidentifier] NULL, 44 CONSTRAINT [PK_ClientError] PRIMARY KEY CLUSTERED 45 ( 46 [Id] ASC 47 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 48 ) ON [PRIMARY] 49 50 GO 51 52 ALTER TABLE [dbo].[ClientError] WITH CHECK ADD CONSTRAINT [FK_ClientError_Resource] FOREIGN KEY([ClientId]) 53 REFERENCES [dbo].[Resource] ([Id]) 54 GO 55 56 ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_Resource] 57 GO 58 59 ALTER TABLE [dbo].[ClientError] WITH CHECK ADD CONSTRAINT [FK_ClientError_UserGroup] FOREIGN KEY([UserId]) 60 REFERENCES [dbo].[UserGroup] ([Id]) 61 GO 62 63 ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_UserGroup] 64 GO 65 66 ALTER TABLE [dbo].[ClientError] ADD CONSTRAINT [DF_ClientError_Id] DEFAULT (newsequentialid()) FOR [Id] 67 GO 68 69 USE [HeuristicLab.ClientManagement] 70 GO 71 72 /****** Object: Table [dbo].[ClientLog] Script Date: 09/27/2011 17:05:50 ******/ 73 SET ANSI_NULLS ON 74 GO 75 76 SET QUOTED_IDENTIFIER ON 77 GO 78 79 CREATE TABLE [dbo].[ClientLog]( 80 [Timestamp] [datetime] NOT NULL, 81 [ResourceId] [uniqueidentifier] NOT NULL, 82 [Message] [nvarchar](max) NULL, 83 CONSTRAINT [PK_ClientLog] PRIMARY KEY CLUSTERED 84 ( 85 [Timestamp] ASC, 86 [ResourceId] ASC 87 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 88 ) ON [PRIMARY] 89 90 GO 91 92 ALTER TABLE [dbo].[ClientLog] WITH CHECK ADD CONSTRAINT [FK_ClientLog_Resource] FOREIGN KEY([ResourceId]) 93 REFERENCES [dbo].[Resource] ([Id]) 94 GO 95 96 ALTER TABLE [dbo].[ClientLog] CHECK CONSTRAINT [FK_ClientLog_Resource] 97 GO 98 99 100 USE [HeuristicLab.ClientManagement] 26 USE [HeuristicLab.AccessService] 101 27 GO 102 28 … … 122 48 GO 123 49 124 USE [HeuristicLab. ClientManagement]50 USE [HeuristicLab.AccessService] 125 51 GO 126 52 … … 146 72 GO 147 73 148 USE [HeuristicLab. ClientManagement]74 USE [HeuristicLab.AccessService] 149 75 GO 150 76 … … 170 96 GO 171 97 172 USE [HeuristicLab. ClientManagement]98 USE [HeuristicLab.AccessService] 173 99 GO 174 100 … … 196 122 GO 197 123 198 199 USE [HeuristicLab.ClientManagement] 200 GO 201 202 /****** Object: Table [dbo].[ResourcePlugin] Script Date: 09/27/2011 17:07:01 ******/ 203 SET ANSI_NULLS ON 204 GO 205 206 SET QUOTED_IDENTIFIER ON 207 GO 208 209 CREATE TABLE [dbo].[ResourcePlugin]( 210 [ResourceId] [uniqueidentifier] NOT NULL, 211 [PluginId] [uniqueidentifier] NOT NULL, 212 CONSTRAINT [PK_ResourcePlugin] PRIMARY KEY CLUSTERED 213 ( 214 [ResourceId] ASC, 215 [PluginId] ASC 216 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 217 ) ON [PRIMARY] 218 219 GO 220 221 ALTER TABLE [dbo].[ResourcePlugin] WITH CHECK ADD CONSTRAINT [FK_ResourcePlugin_Plugin] FOREIGN KEY([PluginId]) 222 REFERENCES [dbo].[Plugin] ([Id]) 223 GO 224 225 ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Plugin] 226 GO 227 228 ALTER TABLE [dbo].[ResourcePlugin] WITH CHECK ADD CONSTRAINT [FK_ResourcePlugin_Resource] FOREIGN KEY([ResourceId]) 229 REFERENCES [dbo].[Resource] ([Id]) 230 GO 231 232 ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Resource] 233 GO 234 235 236 USE [HeuristicLab.ClientManagement] 237 GO 238 239 /****** Object: Table [dbo].[ResourceResourceGroup] Script Date: 09/27/2011 17:07:08 ******/ 240 SET ANSI_NULLS ON 241 GO 242 243 SET QUOTED_IDENTIFIER ON 244 GO 245 246 CREATE TABLE [dbo].[ResourceResourceGroup]( 247 [ResourceId] [uniqueidentifier] NOT NULL, 248 [ResourceGroupId] [uniqueidentifier] NOT NULL, 249 CONSTRAINT [PK_ResourceResourceGroup_Id] PRIMARY KEY CLUSTERED 250 ( 251 [ResourceId] ASC, 252 [ResourceGroupId] ASC 253 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 254 ) ON [PRIMARY] 255 256 GO 257 258 ALTER TABLE [dbo].[ResourceResourceGroup] WITH CHECK ADD CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId] FOREIGN KEY([ResourceGroupId]) 259 REFERENCES [dbo].[Resource] ([Id]) 260 GO 261 262 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId] 263 GO 264 265 ALTER TABLE [dbo].[ResourceResourceGroup] WITH CHECK ADD CONSTRAINT [FK_ResourceResourceGroup_ResourceId] FOREIGN KEY([ResourceId]) 266 REFERENCES [dbo].[Resource] ([Id]) 267 GO 268 269 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceId] 270 GO 271 272 USE [HeuristicLab.ClientManagement] 124 USE [HeuristicLab.AccessService] 273 125 GO 274 126 … … 334 186 GO 335 187 336 USE [HeuristicLab.ClientManagement] 188 USE [HeuristicLab.AccessService] 189 GO 190 191 /****** Object: Table [dbo].[ResourceResourceGroup] Script Date: 09/27/2011 17:07:08 ******/ 192 SET ANSI_NULLS ON 193 GO 194 195 SET QUOTED_IDENTIFIER ON 196 GO 197 198 CREATE TABLE [dbo].[ResourceResourceGroup]( 199 [ResourceId] [uniqueidentifier] NOT NULL, 200 [ResourceGroupId] [uniqueidentifier] NOT NULL, 201 CONSTRAINT [PK_ResourceResourceGroup_Id] PRIMARY KEY CLUSTERED 202 ( 203 [ResourceId] ASC, 204 [ResourceGroupId] ASC 205 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 206 ) ON [PRIMARY] 207 208 GO 209 210 ALTER TABLE [dbo].[ResourceResourceGroup] WITH CHECK ADD CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId] FOREIGN KEY([ResourceGroupId]) 211 REFERENCES [dbo].[Resource] ([Id]) 212 GO 213 214 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId] 215 GO 216 217 ALTER TABLE [dbo].[ResourceResourceGroup] WITH CHECK ADD CONSTRAINT [FK_ResourceResourceGroup_ResourceId] FOREIGN KEY([ResourceId]) 218 REFERENCES [dbo].[Resource] ([Id]) 219 GO 220 221 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceId] 222 GO 223 224 USE [HeuristicLab.AccessService] 225 GO 226 227 /****** Object: Table [dbo].[ResourcePlugin] Script Date: 09/27/2011 17:07:01 ******/ 228 SET ANSI_NULLS ON 229 GO 230 231 SET QUOTED_IDENTIFIER ON 232 GO 233 234 CREATE TABLE [dbo].[ResourcePlugin]( 235 [ResourceId] [uniqueidentifier] NOT NULL, 236 [PluginId] [uniqueidentifier] NOT NULL, 237 CONSTRAINT [PK_ResourcePlugin] PRIMARY KEY CLUSTERED 238 ( 239 [ResourceId] ASC, 240 [PluginId] ASC 241 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 242 ) ON [PRIMARY] 243 244 GO 245 246 ALTER TABLE [dbo].[ResourcePlugin] WITH CHECK ADD CONSTRAINT [FK_ResourcePlugin_Plugin] FOREIGN KEY([PluginId]) 247 REFERENCES [dbo].[Plugin] ([Id]) 248 GO 249 250 ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Plugin] 251 GO 252 253 ALTER TABLE [dbo].[ResourcePlugin] WITH CHECK ADD CONSTRAINT [FK_ResourcePlugin_Resource] FOREIGN KEY([ResourceId]) 254 REFERENCES [dbo].[Resource] ([Id]) 255 GO 256 257 ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Resource] 258 GO 259 260 USE [HeuristicLab.AccessService] 337 261 GO 338 262 … … 357 281 GO 358 282 359 USE [HeuristicLab. ClientManagement]283 USE [HeuristicLab.AccessService] 360 284 GO 361 285 … … 394 318 395 319 396 397 398 399 400 401 402 403 320 USE [HeuristicLab.AccessService] 321 GO 322 323 /****** Object: Table [dbo].[ClientError] Script Date: 09/27/2011 17:05:38 ******/ 324 SET ANSI_NULLS ON 325 GO 326 327 SET QUOTED_IDENTIFIER ON 328 GO 329 330 CREATE TABLE [dbo].[ClientError]( 331 [Id] [uniqueidentifier] NOT NULL, 332 [Timestamp] [datetime] NOT NULL, 333 [Exception] [nvarchar](max) NULL, 334 [UserComment] [nvarchar](max) NULL, 335 [ConfigDump] [nvarchar](max) NULL, 336 [ClientId] [uniqueidentifier] NULL, 337 [UserId] [uniqueidentifier] NULL, 338 CONSTRAINT [PK_ClientError] PRIMARY KEY CLUSTERED 339 ( 340 [Id] ASC 341 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 342 ) ON [PRIMARY] 343 344 GO 345 346 ALTER TABLE [dbo].[ClientError] WITH CHECK ADD CONSTRAINT [FK_ClientError_Resource] FOREIGN KEY([ClientId]) 347 REFERENCES [dbo].[Resource] ([Id]) 348 GO 349 350 ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_Resource] 351 GO 352 353 ALTER TABLE [dbo].[ClientError] WITH CHECK ADD CONSTRAINT [FK_ClientError_UserGroup] FOREIGN KEY([UserId]) 354 REFERENCES [dbo].[UserGroup] ([Id]) 355 GO 356 357 ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_UserGroup] 358 GO 359 360 ALTER TABLE [dbo].[ClientError] ADD CONSTRAINT [DF_ClientError_Id] DEFAULT (newsequentialid()) FOR [Id] 361 GO 362 363 USE [HeuristicLab.AccessService] 364 GO 365 366 /****** Object: Table [dbo].[ClientLog] Script Date: 09/27/2011 17:05:50 ******/ 367 SET ANSI_NULLS ON 368 GO 369 370 SET QUOTED_IDENTIFIER ON 371 GO 372 373 CREATE TABLE [dbo].[ClientLog]( 374 [Timestamp] [datetime] NOT NULL, 375 [ResourceId] [uniqueidentifier] NOT NULL, 376 [Message] [nvarchar](max) NULL, 377 CONSTRAINT [PK_ClientLog] PRIMARY KEY CLUSTERED 378 ( 379 [Timestamp] ASC, 380 [ResourceId] ASC 381 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 382 ) ON [PRIMARY] 383 384 GO 385 386 ALTER TABLE [dbo].[ClientLog] WITH CHECK ADD CONSTRAINT [FK_ClientLog_Resource] FOREIGN KEY([ResourceId]) 387 REFERENCES [dbo].[Resource] ([Id]) 388 GO 389 390 ALTER TABLE [dbo].[ClientLog] CHECK CONSTRAINT [FK_ClientLog_Resource] 391 GO 392 393 394 395 396 397 -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/app.config
r6815 r7619 6 6 <add name="HeuristicLab.Services.Directoy.DataAccess.Properties.Settings.HeuristicLab_AuthenticationConnectionString" 7 7 connectionString="Data Source=.;Initial Catalog=HeuristicLab.Authentication;Integrated Security=True" 8 providerName="System.Data.SqlClient" /> 8 providerName="System.Data.SqlClient" /> 9 9 <add name="HeuristicLab.Services.Access.DataAccess.Properties.Settings.HeuristicLab_ClientManagementConnectionString" 10 connectionString="Data Source=.;Initial Catalog=HeuristicLab.ClientManagement;Integrated Security=True" 10 connectionString="Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True" 11 providerName="System.Data.SqlClient" /> 12 <add name="HeuristicLab.Services.Access.DataAccess.Properties.Settings.HeuristicLab_AuthenticationConnectionString" 13 connectionString="Data Source=.;Initial Catalog=HeuristicLab.Authentication;Integrated Security=True" 11 14 providerName="System.Data.SqlClient" /> 12 15 </connectionStrings>
Note: See TracChangeset
for help on using the changeset viewer.