Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Schema for TeamCity DB in SQL Azure
/* DISCLAIMER
This script is published only as a reference.
No warranty is implied or offered.
If you use this and bad things happen, it's not my fault.
*/
/****** Object: Table [dbo].[action_history] Script Date: 13/11/2012 16:12:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[action_history](
[object_id] [varchar](80) NULL,
[comment_id] [bigint] NULL,
[action] [int] NULL,
[additional_data] [varchar](30) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent] Script Date: 13/11/2012 16:12:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent](
[id] [int] NOT NULL,
[name] [varchar](80) NOT NULL,
[host_addr] [varchar](80) NOT NULL,
[port] [int] NOT NULL,
[agent_type_id] [int] NOT NULL,
[status] [int] NULL,
[authorized] [int] NULL,
[registered] [int] NULL,
[registration_timestamp] [bigint] NULL,
[last_binding_timestamp] [bigint] NULL,
[unregistered_reason] [varchar](256) NULL,
[authorization_token] [varchar](32) NULL,
[status_to_restore] [int] NULL,
[status_restoring_timestamp] [bigint] NULL,
CONSTRAINT [agent_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_pool] Script Date: 13/11/2012 16:12:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_pool](
[agent_pool_id] [int] NOT NULL,
[agent_pool_name] [varchar](30) NOT NULL,
CONSTRAINT [agent_pool_pk] PRIMARY KEY CLUSTERED
(
[agent_pool_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_pool_project] Script Date: 13/11/2012 16:12:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_pool_project](
[agent_pool_id] [int] NOT NULL,
[project_id] [varchar](80) NOT NULL,
CONSTRAINT [agent_pool_project_pk] PRIMARY KEY CLUSTERED
(
[agent_pool_id] ASC,
[project_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_sources_version] Script Date: 13/11/2012 16:12:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_sources_version](
[build_type_id] [varchar](80) NOT NULL,
[vcs_root_id] [int] NOT NULL,
[agent_id] [int] NOT NULL,
[vcs_settings_hash] [varchar](16) NOT NULL,
[checkout_dir] [varchar](2048) NULL,
[current_version] [varchar](80) NULL,
CONSTRAINT [agent_sources_version_pk] PRIMARY KEY CLUSTERED
(
[build_type_id] ASC,
[vcs_settings_hash] ASC,
[vcs_root_id] ASC,
[agent_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_type] Script Date: 13/11/2012 16:12:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_type](
[agent_type_id] [int] NOT NULL,
[agent_pool_id] [int] NOT NULL,
[cloud_code] [varchar](6) NOT NULL,
[profile_id] [varchar](30) NOT NULL,
[image_id] [varchar](60) NOT NULL,
[policy] [int] NOT NULL,
CONSTRAINT [agent_type_pk] PRIMARY KEY CLUSTERED
(
[agent_type_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_type_bt_access] Script Date: 13/11/2012 16:12:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_type_bt_access](
[agent_type_id] [int] NOT NULL,
[build_type_id] [varchar](80) NOT NULL,
CONSTRAINT [agent_type_bt_access_pk] PRIMARY KEY CLUSTERED
(
[agent_type_id] ASC,
[build_type_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_type_info] Script Date: 13/11/2012 16:12:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_type_info](
[agent_type_id] [int] NOT NULL,
[os_name] [varchar](60) NOT NULL,
[cpu_rank] [int] NULL,
[created_timestamp] [datetime] NULL,
[modified_timestamp] [datetime] NULL,
CONSTRAINT [agent_type_info_pk] PRIMARY KEY CLUSTERED
(
[agent_type_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_type_param] Script Date: 13/11/2012 16:12:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_type_param](
[agent_type_id] [int] NOT NULL,
[param_kind] [char](1) NOT NULL,
[param_name] [varchar](160) NOT NULL,
[param_value] [varchar](2000) NULL,
CONSTRAINT [agent_type_param_pk] PRIMARY KEY CLUSTERED
(
[agent_type_id] ASC,
[param_kind] ASC,
[param_name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_type_runner] Script Date: 13/11/2012 16:12:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_type_runner](
[agent_type_id] [int] NOT NULL,
[runner] [varchar](250) NOT NULL,
CONSTRAINT [agent_type_runner_pk] PRIMARY KEY CLUSTERED
(
[agent_type_id] ASC,
[runner] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agent_type_vcs] Script Date: 13/11/2012 16:12:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agent_type_vcs](
[agent_type_id] [int] NOT NULL,
[vcs] [varchar](250) NOT NULL,
CONSTRAINT [agent_type_vcs_pk] PRIMARY KEY CLUSTERED
(
[agent_type_id] ASC,
[vcs] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[archived_projects] Script Date: 13/11/2012 16:12:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[archived_projects](
[project_id] [varchar](80) NOT NULL,
[user_id] [bigint] NULL,
CONSTRAINT [archived_projects_pk] PRIMARY KEY CLUSTERED
(
[project_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[audit_additional_object] Script Date: 13/11/2012 16:12:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[audit_additional_object](
[comment_id] [bigint] NULL,
[object_index] [int] NULL,
[object_id] [varchar](80) NULL,
[object_name] [varchar](max) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[backup_builds] Script Date: 13/11/2012 16:12:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[backup_builds](
[build_id] [bigint] NOT NULL,
CONSTRAINT [backup_builds_ak] UNIQUE CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[backup_info] Script Date: 13/11/2012 16:12:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[backup_info](
[mproc_id] [int] NOT NULL,
[file_name] [varchar](1000) NULL,
[file_size] [bigint] NULL,
[started] [datetime] NOT NULL,
[finished] [datetime] NULL,
[status] [char](1) NULL,
CONSTRAINT [backup_info_pk] PRIMARY KEY CLUSTERED
(
[mproc_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_artifact_dependency] Script Date: 13/11/2012 16:12:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_artifact_dependency](
[build_state_id] [bigint] NULL,
[source_build_type_id] [varchar](80) NULL,
[src_paths] [varchar](max) NULL,
[revision_rule] [varchar](80) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_attrs] Script Date: 13/11/2012 16:12:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_attrs](
[build_state_id] [bigint] NOT NULL,
[attr_name] [varchar](70) NOT NULL,
[attr_value] [varchar](1000) NULL,
CONSTRAINT [build_attrs_pk] PRIMARY KEY CLUSTERED
(
[build_state_id] ASC,
[attr_name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_checkout_rules] Script Date: 13/11/2012 16:12:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_checkout_rules](
[build_state_id] [bigint] NOT NULL,
[build_type_id] [varchar](80) NOT NULL,
[vcs_root_id] [int] NOT NULL,
[checkout_rules] [varchar](max) NULL,
CONSTRAINT [build_checkout_rules_pk] PRIMARY KEY CLUSTERED
(
[build_state_id] ASC,
[build_type_id] ASC,
[vcs_root_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_data_storage] Script Date: 13/11/2012 16:12:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[build_data_storage](
[build_id] [bigint] NOT NULL,
[metric_id] [bigint] NOT NULL,
[metric_value] [decimal](19, 0) NOT NULL,
CONSTRAINT [build_data_storage_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC,
[metric_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[build_dependency] Script Date: 13/11/2012 16:12:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[build_dependency](
[build_state_id] [bigint] NOT NULL,
[depends_on] [bigint] NOT NULL,
[dependency_options] [int] NULL,
CONSTRAINT [build_dependency_pk] PRIMARY KEY CLUSTERED
(
[build_state_id] ASC,
[depends_on] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[build_labels] Script Date: 13/11/2012 16:12:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_labels](
[build_id] [bigint] NULL,
[vcs_root_id] [bigint] NULL,
[label] [varchar](80) NULL,
[status] [int] NULL,
[error_message] [varchar](256) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_overriden_roots] Script Date: 13/11/2012 16:12:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[build_overriden_roots](
[build_state_id] [bigint] NOT NULL,
[original_vcs_root_id] [int] NOT NULL,
[substitution_vcs_root_id] [int] NOT NULL,
CONSTRAINT [build_overriden_roots_pk] PRIMARY KEY CLUSTERED
(
[build_state_id] ASC,
[original_vcs_root_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[build_problems] Script Date: 13/11/2012 16:12:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_problems](
[build_state_id] [bigint] NOT NULL,
[problem_identity] [varchar](60) NOT NULL,
[problem_type] [varchar](80) NOT NULL,
[problem_description] [varchar](max) NULL,
[is_muted] [bit] NOT NULL,
CONSTRAINT [build_problems_pk] PRIMARY KEY CLUSTERED
(
[build_state_id] ASC,
[problem_identity] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_queue] Script Date: 13/11/2012 16:12:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_queue](
[build_type_id] [varchar](80) NULL,
[agent_restrictor_type_id] [int] NULL,
[agent_restrictor_id] [int] NULL,
[requestor] [varchar](1024) NULL,
[when_queued] [bigint] NULL,
[pos] [int] NULL,
[build_state_id] [bigint] NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_revisions] Script Date: 13/11/2012 16:12:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_revisions](
[build_state_id] [bigint] NOT NULL,
[vcs_root_id] [bigint] NOT NULL,
[vcs_revision] [varchar](200) NULL,
[vcs_revision_display_name] [varchar](200) NULL,
[modification_id] [bigint] NULL,
CONSTRAINT [build_revisions_pk] PRIMARY KEY CLUSTERED
(
[build_state_id] ASC,
[vcs_root_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_runtime_info] Script Date: 13/11/2012 16:12:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_runtime_info](
[build_id] [bigint] NOT NULL,
[rkey] [varchar](64) NOT NULL,
[value] [varchar](max) NULL,
CONSTRAINT [build_runtime_info_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC,
[rkey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_set_tmp] Script Date: 13/11/2012 16:12:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[build_set_tmp](
[build_id] [bigint] NOT NULL,
CONSTRAINT [build_set_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[build_state] Script Date: 13/11/2012 16:12:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_state](
[id] [bigint] NOT NULL,
[build_type_id] [varchar](80) NULL,
[modification_id] [bigint] NULL,
[is_personal] [int] NOT NULL,
[is_canceled] [int] NOT NULL,
[is_changes_detached] [int] NOT NULL,
[is_deleted] [bit] NOT NULL,
[branch_name] [varchar](255) NULL,
[build_id] [bigint] NULL,
CONSTRAINT [build_state_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[build_type_vcs_change] Script Date: 13/11/2012 16:12:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[build_type_vcs_change](
[modification_id] [bigint] NOT NULL,
[build_type_id] [varchar](80) NOT NULL,
[branch_id] [int] NULL,
CONSTRAINT [build_type_vcs_change_ui] UNIQUE CLUSTERED
(
[modification_id] ASC,
[build_type_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[canceled_info] Script Date: 13/11/2012 16:12:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[canceled_info](
[build_id] [bigint] NOT NULL,
[user_id] [bigint] NULL,
[description] [varchar](256) NULL,
CONSTRAINT [canceled_info_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[cloud_image_without_agent] Script Date: 13/11/2012 16:12:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cloud_image_without_agent](
[profile_id] [varchar](30) NOT NULL,
[cloud_code] [varchar](6) NOT NULL,
[image_id] [varchar](80) NOT NULL,
[last_update] [datetime] NOT NULL,
CONSTRAINT [cloud_image_without_agent_pk] PRIMARY KEY CLUSTERED
(
[profile_id] ASC,
[cloud_code] ASC,
[image_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[cloud_started_instance] Script Date: 13/11/2012 16:12:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cloud_started_instance](
[profile_id] [varchar](30) NOT NULL,
[cloud_code] [varchar](6) NOT NULL,
[image_id] [varchar](80) NOT NULL,
[instance_id] [varchar](80) NOT NULL,
[last_update] [datetime] NOT NULL,
CONSTRAINT [cloud_started_instance_pk] PRIMARY KEY CLUSTERED
(
[profile_id] ASC,
[cloud_code] ASC,
[image_id] ASC,
[instance_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[comments] Script Date: 13/11/2012 16:12:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[comments](
[id] [bigint] NOT NULL,
[author_id] [bigint] NULL,
[when_changed] [bigint] NOT NULL,
[commentary] [varchar](max) NULL,
CONSTRAINT [comments_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[compiler_output] Script Date: 13/11/2012 16:12:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[compiler_output](
[build_id] [bigint] NULL,
[message_order] [int] NULL,
[message] [varchar](max) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[db_version] Script Date: 13/11/2012 16:12:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[db_version](
[version_number] [int] NOT NULL,
[version_time] [datetime] NOT NULL,
CONSTRAINT [db_version_pk] PRIMARY KEY CLUSTERED
(
[version_number] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[default_build_parameters] Script Date: 13/11/2012 16:12:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[default_build_parameters](
[build_state_id] [bigint] NULL,
[param_name] [varchar](2000) NULL,
[param_value] [varchar](max) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[deleted_build_types] Script Date: 13/11/2012 16:12:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[deleted_build_types](
[build_type_id] [varchar](80) NOT NULL,
[delete_time] [bigint] NULL,
CONSTRAINT [deleted_build_types_pk] PRIMARY KEY CLUSTERED
(
[build_type_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[downloaded_artifacts] Script Date: 13/11/2012 16:12:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[downloaded_artifacts](
[target_build_id] [bigint] NULL,
[source_build_id] [bigint] NULL,
[artifact_path] [varchar](max) NULL,
[download_timestamp] [bigint] NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[duplicate_diff] Script Date: 13/11/2012 16:12:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[duplicate_diff](
[build_id] [bigint] NOT NULL,
[hash] [bigint] NOT NULL,
CONSTRAINT [duplicate_diff_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC,
[hash] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[duplicate_fragments] Script Date: 13/11/2012 16:12:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[duplicate_fragments](
[id] [bigint] NULL,
[file_id] [bigint] NULL,
[offset_info] [varchar](100) NULL,
[line] [int] NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[duplicate_results] Script Date: 13/11/2012 16:12:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[duplicate_results](
[id] [bigint] NOT NULL,
[build_id] [bigint] NULL,
[hash] [int] NULL,
[cost] [int] NULL,
CONSTRAINT [duplicate_results_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[duplicate_stats] Script Date: 13/11/2012 16:12:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[duplicate_stats](
[build_id] [bigint] NOT NULL,
[total] [int] NULL,
[new_total] [int] NULL,
[old_total] [int] NULL,
CONSTRAINT [duplicate_stats_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[failed_tests_output] Script Date: 13/11/2012 16:12:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[failed_tests_output](
[build_id] [bigint] NOT NULL,
[test_id] [int] NOT NULL,
[problem_description] [varchar](max) NULL,
[std_output] [varchar](max) NULL,
[error_output] [varchar](max) NULL,
[stacktrace] [varchar](max) NULL,
[expected] [varchar](max) NULL,
[actual] [varchar](max) NULL,
CONSTRAINT [failed_tests_output_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC,
[test_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[final_artifact_dependency] Script Date: 13/11/2012 16:12:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[final_artifact_dependency](
[build_state_id] [bigint] NULL,
[source_build_type_id] [varchar](80) NULL,
[src_paths] [varchar](max) NULL,
[revision_rule] [varchar](80) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[fragments] Script Date: 13/11/2012 16:12:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[fragments](
[hash] [int] NULL,
[file_id] [bigint] NULL,
[build_type_id] [varchar](80) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[history] Script Date: 13/11/2012 16:12:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[history](
[build_id] [bigint] NOT NULL,
[agent_name] [varchar](80) NULL,
[build_type_id] [varchar](80) NULL,
[build_start_time_server] [bigint] NULL,
[build_start_time_agent] [bigint] NULL,
[build_finish_time_server] [bigint] NULL,
[status] [int] NULL,
[status_text] [varchar](256) NULL,
[user_status_text] [varchar](256) NULL,
[pin] [int] NULL,
[is_personal] [int] NULL,
[is_canceled] [int] NULL,
[build_number] [varchar](256) NULL,
[requestor] [varchar](1024) NULL,
[queued_time] [bigint] NULL,
[remove_from_queue_time] [bigint] NULL,
[build_state_id] [bigint] NULL,
[agent_type_id] [int] NULL,
CONSTRAINT [history_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ignored_tests] Script Date: 13/11/2012 16:12:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ignored_tests](
[build_id] [bigint] NULL,
[test_id] [int] NULL,
[test_name] [varchar](255) NULL,
[reason] [varchar](max) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[inspection_data] Script Date: 13/11/2012 16:12:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[inspection_data](
[hash] [bigint] NOT NULL,
[result] [varchar](max) NULL,
[severity] [int] NULL,
[type_pattern] [int] NULL,
[fqname] [varchar](max) NULL,
[file_name] [varchar](255) NULL,
[parent_fqnames] [varchar](max) NULL,
[parent_type_patterns] [varchar](20) NULL,
[module_name] [varchar](40) NULL,
[inspection_id] [bigint] NULL,
[is_local] [int] NULL,
CONSTRAINT [inspection_data_pk] PRIMARY KEY CLUSTERED
(
[hash] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[inspection_diff] Script Date: 13/11/2012 16:12:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[inspection_diff](
[build_id] [bigint] NOT NULL,
[hash] [bigint] NOT NULL,
CONSTRAINT [inspection_diff_ak] UNIQUE CLUSTERED
(
[build_id] ASC,
[hash] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[inspection_fixes] Script Date: 13/11/2012 16:12:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[inspection_fixes](
[hash] [bigint] NOT NULL,
[hint] [varchar](255) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[inspection_info] Script Date: 13/11/2012 16:12:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[inspection_info](
[id] [bigint] NOT NULL,
[inspection_id] [varchar](255) NULL,
[inspection_name] [varchar](255) NULL,
[inspection_desc] [varchar](max) NULL,
[group_name] [varchar](255) NULL,
CONSTRAINT [inspection_info_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[inspection_results] Script Date: 13/11/2012 16:12:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[inspection_results](
[build_id] [bigint] NOT NULL,
[hash] [bigint] NOT NULL,
[line] [int] NOT NULL
)
GO
/****** Object: Table [dbo].[inspection_stats] Script Date: 13/11/2012 16:12:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[inspection_stats](
[build_id] [bigint] NOT NULL,
[total] [int] NULL,
[new_total] [int] NULL,
[old_total] [int] NULL,
[errors] [int] NULL,
[new_errors] [int] NULL,
[old_errors] [int] NULL,
CONSTRAINT [inspection_stats_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[light_history] Script Date: 13/11/2012 16:12:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[light_history](
[build_id] [bigint] NOT NULL,
[agent_name] [varchar](80) NULL,
[build_type_id] [varchar](80) NULL,
[build_start_time_server] [bigint] NULL,
[build_start_time_agent] [bigint] NULL,
[build_finish_time_server] [bigint] NULL,
[status] [int] NULL,
[status_text] [varchar](256) NULL,
[user_status_text] [varchar](256) NULL,
[pin] [int] NULL,
[is_personal] [int] NULL,
[is_canceled] [int] NULL,
[build_number] [varchar](256) NULL,
[requestor] [varchar](1024) NULL,
[queued_time] [bigint] NULL,
[remove_from_queue_time] [bigint] NULL,
[build_state_id] [bigint] NULL,
[agent_type_id] [int] NULL,
CONSTRAINT [light_history_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[meta_file_line] Script Date: 13/11/2012 16:12:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[meta_file_line](
[file_name] [varchar](15) NOT NULL,
[line_nr] [int] NOT NULL,
[line_text] [varchar](160) NULL,
CONSTRAINT [meta_file_line_pk] PRIMARY KEY CLUSTERED
(
[file_name] ASC,
[line_nr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mute_info] Script Date: 13/11/2012 16:12:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mute_info](
[mute_id] [int] NOT NULL,
[muting_user_id] [bigint] NOT NULL,
[muting_time] [datetime] NOT NULL,
[muting_comment] [varchar](2000) NULL,
[scope] [char](1) NOT NULL,
[project_id] [varchar](80) NOT NULL,
[build_id] [bigint] NULL,
[unmute_when_fixed] [bit] NULL,
[unmute_by_time] [datetime] NULL,
CONSTRAINT [mute_info_pk] PRIMARY KEY CLUSTERED
(
[mute_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mute_info_bt] Script Date: 13/11/2012 16:12:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mute_info_bt](
[mute_id] [int] NOT NULL,
[build_type_id] [varchar](80) NOT NULL,
CONSTRAINT [mute_info_bt_pk] PRIMARY KEY CLUSTERED
(
[mute_id] ASC,
[build_type_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mute_info_test] Script Date: 13/11/2012 16:12:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mute_info_test](
[mute_id] [int] NOT NULL,
[test_name_id] [bigint] NOT NULL,
CONSTRAINT [mute_info_test_pk] PRIMARY KEY CLUSTERED
(
[mute_id] ASC,
[test_name_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[mute_test_in_bt] Script Date: 13/11/2012 16:12:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mute_test_in_bt](
[mute_id] [int] NOT NULL,
[build_type_id] [varchar](80) NOT NULL,
[test_name_id] [bigint] NOT NULL,
CONSTRAINT [mute_test_in_bt_pk] PRIMARY KEY CLUSTERED
(
[mute_id] ASC,
[build_type_id] ASC,
[test_name_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mute_test_in_proj] Script Date: 13/11/2012 16:12:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mute_test_in_proj](
[mute_id] [int] NOT NULL,
[project_id] [varchar](80) NOT NULL,
[test_name_id] [bigint] NOT NULL,
CONSTRAINT [mute_test_in_proj_pk] PRIMARY KEY CLUSTERED
(
[mute_id] ASC,
[project_id] ASC,
[test_name_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[paused_build_types] Script Date: 13/11/2012 16:12:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[paused_build_types](
[build_type_id] [varchar](80) NOT NULL,
[who_user_id] [int] NULL,
[commentary] [varchar](256) NULL,
[when_paused] [bigint] NULL,
CONSTRAINT [paused_build_types_pk] PRIMARY KEY CLUSTERED
(
[build_type_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[personal_build_relative_path] Script Date: 13/11/2012 16:12:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[personal_build_relative_path](
[build_id] [bigint] NULL,
[original_path_hash] [bigint] NULL,
[relative_path] [varchar](max) NULL,
CONSTRAINT [personal_build_relative_p_ak] UNIQUE CLUSTERED
(
[build_id] ASC,
[original_path_hash] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[personal_vcs_changes] Script Date: 13/11/2012 16:12:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[personal_vcs_changes](
[modification_id] [bigint] NULL,
[change_name] [varchar](64) NULL,
[vcs_file_name] [varchar](max) NULL,
[relative_file_name] [varchar](max) NULL,
[change_type] [int] NULL,
[before_revision] [varchar](2048) NULL,
[after_revision] [varchar](2048) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[personal_vcs_history] Script Date: 13/11/2012 16:12:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[personal_vcs_history](
[modification_id] [bigint] NOT NULL,
[user_id] [bigint] NULL,
[description] [varchar](max) NULL,
[change_date] [bigint] NULL,
[changes_count] [int] NULL,
[commit_changes] [int] NULL,
[scheduled_for_deletion] [int] NULL,
[status] [int] NULL,
CONSTRAINT [personal_vcs_history_pk] PRIMARY KEY CLUSTERED
(
[modification_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[project_files] Script Date: 13/11/2012 16:12:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[project_files](
[file_id] [bigint] NOT NULL,
[file_name] [varchar](255) NULL,
CONSTRAINT [project_files_pk] PRIMARY KEY CLUSTERED
(
[file_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[remember_me] Script Date: 13/11/2012 16:12:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[remember_me](
[user_key] [varchar](65) NOT NULL,
[secure] [bigint] NOT NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[responsibilities] Script Date: 13/11/2012 16:12:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[responsibilities](
[problem_id] [varchar](40) NOT NULL,
[state] [int] NOT NULL,
[responsible_user_id] [bigint] NOT NULL,
[reporter_user_id] [bigint] NULL,
[timestmp] [bigint] NULL,
[comments] [varchar](max) NULL,
[remove_method] [int] NOT NULL,
CONSTRAINT [responsibilities_pk] PRIMARY KEY CLUSTERED
(
[problem_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[running] Script Date: 13/11/2012 16:12:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[running](
[build_id] [bigint] NOT NULL,
[agent_id] [int] NULL,
[build_type_id] [varchar](80) NULL,
[build_start_time_agent] [bigint] NULL,
[build_start_time_server] [bigint] NULL,
[is_personal] [int] NULL,
[build_number] [varchar](256) NULL,
[requestor] [varchar](1024) NULL,
[access_code] [varchar](60) NULL,
[queued_ag_restr_type_id] [int] NULL,
[queued_ag_restr_id] [int] NULL,
[queued_time] [bigint] NULL,
[remove_from_queue_time] [bigint] NULL,
[build_state_id] [bigint] NULL,
[agent_type_id] [int] NULL,
CONSTRAINT [running_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[server] Script Date: 13/11/2012 16:12:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[server](
[server_id] [bigint] NULL
)
GO
/****** Object: Table [dbo].[server_property] Script Date: 13/11/2012 16:12:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[server_property](
[prop_name] [varchar](80) NOT NULL,
[prop_value] [varchar](256) NOT NULL,
CONSTRAINT [server_property_ak] UNIQUE CLUSTERED
(
[prop_name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[single_row] Script Date: 13/11/2012 16:12:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[single_row](
[dummy_field] [char](1) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[stats] Script Date: 13/11/2012 16:12:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[stats](
[build_id] [bigint] NOT NULL,
[test_count] [int] NULL,
[status_text] [varchar](256) NULL,
CONSTRAINT [stats_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[stats_publisher_state] Script Date: 13/11/2012 16:12:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[stats_publisher_state](
[metric_id] [bigint] NOT NULL,
[value] [bigint] NOT NULL,
CONSTRAINT [stats_publisher_state_pk] PRIMARY KEY CLUSTERED
(
[metric_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[tc_build_tags] Script Date: 13/11/2012 16:12:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tc_build_tags](
[tag] [varchar](255) NULL,
[build_id] [bigint] NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[test_failure_rate] Script Date: 13/11/2012 16:12:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[test_failure_rate](
[build_type_id] [varchar](80) NOT NULL,
[agent_id] [int] NOT NULL,
[test_name_id] [bigint] NOT NULL,
[success_count] [int] NULL,
[failure_count] [int] NULL,
[last_failure_time] [bigint] NULL,
CONSTRAINT [test_failure_rate_pk] PRIMARY KEY CLUSTERED
(
[build_type_id] ASC,
[agent_id] ASC,
[test_name_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[test_info] Script Date: 13/11/2012 16:12:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[test_info](
[build_id] [bigint] NOT NULL,
[test_id] [int] NOT NULL,
[test_name_id] [bigint] NULL,
[status] [int] NULL,
[duration] [int] NOT NULL,
CONSTRAINT [test_info_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC,
[test_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[test_info_trunk] Script Date: 13/11/2012 16:12:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[test_info_trunk](
[build_id] [bigint] NOT NULL,
[test_id] [int] NOT NULL,
[test_name_id] [bigint] NULL,
[status] [int] NULL,
[duration] [int] NOT NULL,
CONSTRAINT [test_info_trunk_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC,
[test_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[test_muted] Script Date: 13/11/2012 16:12:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[test_muted](
[build_id] [bigint] NOT NULL,
[test_name_id] [bigint] NOT NULL,
[mute_id] [int] NOT NULL,
CONSTRAINT [test_muted_pk] PRIMARY KEY CLUSTERED
(
[build_id] ASC,
[test_name_id] ASC,
[mute_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
/****** Object: Table [dbo].[test_names] Script Date: 13/11/2012 16:12:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[test_names](
[id] [bigint] NOT NULL,
[test_name] [varchar](255) NOT NULL,
CONSTRAINT [test_names_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[user_blocks] Script Date: 13/11/2012 16:12:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_blocks](
[user_id] [bigint] NOT NULL,
[block_type] [varchar](80) NOT NULL,
[state] [varchar](2048) NULL,
CONSTRAINT [user_blocks_ui] UNIQUE CLUSTERED
(
[user_id] ASC,
[block_type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[user_build_parameters] Script Date: 13/11/2012 16:12:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_build_parameters](
[build_state_id] [bigint] NULL,
[param_name] [varchar](2000) NULL,
[param_value] [varchar](max) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[user_notification_events] Script Date: 13/11/2012 16:12:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_notification_events](
[id] [bigint] NOT NULL,
[user_id] [bigint] NOT NULL,
[notificator_type] [varchar](20) NOT NULL,
[events_mask] [int] NOT NULL,
CONSTRAINT [user_notification_events_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[user_projects_order] Script Date: 13/11/2012 16:12:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_projects_order](
[user_id] [bigint] NOT NULL,
[project_id] [varchar](80) NOT NULL,
[ordernum] [int] NULL,
CONSTRAINT [user_projects_order_ui] UNIQUE CLUSTERED
(
[user_id] ASC,
[project_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[user_projects_visibility] Script Date: 13/11/2012 16:12:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_projects_visibility](
[user_id] [bigint] NOT NULL,
[project_id] [varchar](80) NOT NULL,
[visible] [int] NOT NULL,
CONSTRAINT [user_projects_visibility_ui] UNIQUE CLUSTERED
(
[user_id] ASC,
[project_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[user_property] Script Date: 13/11/2012 16:12:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_property](
[user_id] [bigint] NOT NULL,
[key1] [varchar](80) NOT NULL,
[value] [varchar](2048) NULL,
CONSTRAINT [user_property_ui] UNIQUE CLUSTERED
(
[user_id] ASC,
[key1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[user_roles] Script Date: 13/11/2012 16:12:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_roles](
[user_id] [bigint] NOT NULL,
[role_id] [varchar](80) NOT NULL,
[project_id] [varchar](80) NULL,
CONSTRAINT [user_roles_ui] UNIQUE CLUSTERED
(
[user_id] ASC,
[role_id] ASC,
[project_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[user_watch_type] Script Date: 13/11/2012 16:12:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_watch_type](
[rule_id] [bigint] NOT NULL,
[user_id] [bigint] NOT NULL,
[notificator_type] [varchar](20) NOT NULL,
[watch_type] [int] NOT NULL,
[watch_value] [varchar](80) NOT NULL,
[order_num] [bigint] NULL,
CONSTRAINT [user_watch_type_ui] UNIQUE CLUSTERED
(
[user_id] ASC,
[notificator_type] ASC,
[watch_type] ASC,
[watch_value] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[usergroup_notification_events] Script Date: 13/11/2012 16:12:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[usergroup_notification_events](
[id] [bigint] NOT NULL,
[group_id] [varchar](16) NOT NULL,
[notificator_type] [varchar](20) NOT NULL,
[events_mask] [int] NOT NULL,
CONSTRAINT [usergroup_notific_evnts_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[usergroup_roles] Script Date: 13/11/2012 16:12:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[usergroup_roles](
[group_id] [varchar](16) NOT NULL,
[role_id] [varchar](80) NOT NULL,
[project_id] [varchar](80) NULL,
CONSTRAINT [usergroup_roles_ui] UNIQUE CLUSTERED
(
[group_id] ASC,
[role_id] ASC,
[project_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[usergroup_subgroups] Script Date: 13/11/2012 16:12:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[usergroup_subgroups](
[hostgroup_id] [varchar](16) NOT NULL,
[subgroup_id] [varchar](16) NOT NULL,
CONSTRAINT [usergroup_subgroups_ui] UNIQUE CLUSTERED
(
[hostgroup_id] ASC,
[subgroup_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[usergroup_users] Script Date: 13/11/2012 16:12:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[usergroup_users](
[group_id] [varchar](16) NOT NULL,
[user_id] [bigint] NOT NULL,
CONSTRAINT [usergroup_users_ui] UNIQUE CLUSTERED
(
[group_id] ASC,
[user_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[usergroup_watch_type] Script Date: 13/11/2012 16:12:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[usergroup_watch_type](
[rule_id] [bigint] NOT NULL,
[group_id] [varchar](16) NOT NULL,
[notificator_type] [varchar](20) NOT NULL,
[watch_type] [int] NOT NULL,
[watch_value] [varchar](80) NOT NULL,
[order_num] [bigint] NULL,
CONSTRAINT [usergroup_watch_type_ui] UNIQUE CLUSTERED
(
[group_id] ASC,
[notificator_type] ASC,
[watch_type] ASC,
[watch_value] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[usergroups] Script Date: 13/11/2012 16:12:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[usergroups](
[group_id] [varchar](16) NOT NULL,
[name] [varchar](255) NOT NULL,
[description] [varchar](2000) NULL,
CONSTRAINT [usergroups_pk] PRIMARY KEY CLUSTERED
(
[group_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[users] Script Date: 13/11/2012 16:12:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[users](
[id] [bigint] NOT NULL,
[auth_type] [varchar](80) NOT NULL,
[realm] [varchar](60) NULL,
[username] [varchar](60) NOT NULL,
[name] [varchar](256) NULL,
[email] [varchar](256) NULL,
[last_login_timestamp] [bigint] NULL,
[password] [varchar](128) NULL,
CONSTRAINT [users_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[vcs_changes] Script Date: 13/11/2012 16:12:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[vcs_changes](
[modification_id] [bigint] NULL,
[change_name] [varchar](64) NULL,
[vcs_file_name] [varchar](max) NULL,
[relative_file_name] [varchar](max) NULL,
[change_type] [int] NULL,
[before_revision] [varchar](max) NULL,
[after_revision] [varchar](max) NULL
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[vcs_changes_graph] Script Date: 13/11/2012 16:12:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[vcs_changes_graph](
[child_modification_id] [bigint] NOT NULL,
[child_revision] [varchar](200) NOT NULL,
[parent_num] [int] NOT NULL,
[parent_modification_id] [bigint] NULL,
[parent_revision] [varchar](200) NOT NULL,
CONSTRAINT [vcs_changes_graph_pk] PRIMARY KEY CLUSTERED
(
[child_modification_id] ASC,
[parent_num] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[vcs_history] Script Date: 13/11/2012 16:12:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[vcs_history](
[modification_id] [bigint] NOT NULL,
[user_name] [varchar](255) NULL,
[description] [varchar](max) NULL,
[change_date] [bigint] NULL,
[register_date] [bigint] NULL,
[vcs_root_id] [int] NULL,
[changes_count] [int] NULL,
[version] [varchar](200) NOT NULL,
[display_version] [varchar](200) NULL,
CONSTRAINT [vcs_history_pk] PRIMARY KEY CLUSTERED
(
[modification_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[vcs_root_first_revision] Script Date: 13/11/2012 16:12:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[vcs_root_first_revision](
[build_type_id] [varchar](80) NOT NULL,
[parent_root_id] [bigint] NOT NULL,
[settings_hash] [bigint] NOT NULL,
[vcs_revision] [varchar](200) NOT NULL,
CONSTRAINT [vcs_settings_hash_pk] PRIMARY KEY CLUSTERED
(
[build_type_id] ASC,
[parent_root_id] ASC,
[settings_hash] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[vcs_root_instance] Script Date: 13/11/2012 16:12:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[vcs_root_instance](
[id] [int] NOT NULL,
[parent_id] [int] NOT NULL,
[settings_hash] [bigint] NOT NULL,
[body] [varchar](max) NULL,
CONSTRAINT [vcs_root_instance_pk] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[working_server] Script Date: 13/11/2012 16:12:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[working_server](
[starting_code] [bigint] NOT NULL,
[starting_time] [datetime] NULL,
[ip_address] [varchar](15) NULL,
[application_info] [varchar](80) NULL,
[pkid] [bigint] IDENTITY(1,1) NOT NULL
)
GO
INSERT [dbo].[action_history] ([object_id], [comment_id], [action], [additional_data]) VALUES (N'1', 1, 11, NULL)
GO
INSERT [dbo].[agent] ([id], [name], [host_addr], [port], [agent_type_id], [status], [authorized], [registered], [registration_timestamp], [last_binding_timestamp], [unregistered_reason], [authorization_token], [status_to_restore], [status_restoring_timestamp]) VALUES (1, N'MARK-LAPTOP', N'127.0.0.1', 9090, 1, 1, 1, 1, 1349698479646, 1349698500944, NULL, N'38e2a2342cc8fa8eed4c25cdcbfddfd5', NULL, NULL)
GO
INSERT [dbo].[agent_pool] ([agent_pool_id], [agent_pool_name]) VALUES (0, N'Default')
GO
INSERT [dbo].[agent_type] ([agent_type_id], [agent_pool_id], [cloud_code], [profile_id], [image_id], [policy]) VALUES (1, 0, N'A', N'A', N'real-1', 1)
GO
INSERT [dbo].[agent_type_info] ([agent_type_id], [os_name], [cpu_rank], [created_timestamp], [modified_timestamp]) VALUES (1, N'Windows NT (unknown), version 6.2', 447, CAST(0x0000A0E400DA42FF AS DateTime), CAST(0x0000A0E400DA42FF AS DateTime))
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.=C:', N'C:\TeamCity\buildAgent\bin')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.=ExitCode', N'00000000')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.ALLUSERSPROFILE', N'C:\ProgramData')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.APPDATA', N'C:\Users\Mark\AppData\Roaming')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.asl.log', N'Destination=file')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.CATALINA_BASE', N'C:\TeamCity\bin\..')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.CATALINA_HOME', N'C:\TeamCity\bin\..')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.CATALINA_OPTS', N' -server -Xmx512m -XX:MaxPermSize=270m -Dlog4j.configuration=file:../conf/teamcity-server-log4j.xml -Dteamcity_logs=../logs/')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.ChocolateyInstall', N'C:\Chocolatey')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.CommonProgramFiles', N'C:\Program Files (x86)\Common Files')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.CommonProgramFiles(x86)', N'C:\Program Files (x86)\Common Files')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.CommonProgramW6432', N'C:\Program Files\Common Files')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.COMPUTERNAME', N'MARK-LAPTOP')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.ComSpec', N'C:\Windows\system32\cmd.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.FP_NO_HOST_CHECK', N'NO')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.HOMEDRIVE', N'C:')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.HOMEPATH', N'\Users\Mark')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.JAVA_EXE', N'C:\TeamCity\buildAgent\bin\..\..\jre\bin\java.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.JAVA_HOME', N'C:\TeamCity\buildAgent\bin\..\..\jre')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.JDK_16', N'C:\TeamCity\buildAgent\bin\..\..\jre')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.JRE_HOME', N'C:\TeamCity\buildAgent\bin\..\..\jre')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.LOCALAPPDATA', N'C:\Users\Mark\AppData\Local')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.LOGONSERVER', N'\\MicrosoftAccount')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.NUMBER_OF_PROCESSORS', N'8')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.OS', N'Windows_NT')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.Path', N'C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\;C:\Program Files (x86)\Windows Kits\8.0\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Nuget;C:\Program Files\TortoiseHg\;C:\Program Files (x86)\nodejs\;C:\Program Files (x86)\Microsoft SDKs\TypeScript\0.8.0.0\;C:\Chocolatey\bin;C:\Users\Mark\AppData\Roaming\npm\')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PATHEXT', N'.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.CPL')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PROCESSOR_ARCHITECTURE', N'x86')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PROCESSOR_ARCHITEW6432', N'AMD64')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PROCESSOR_IDENTIFIER', N'Intel64 Family 6 Model 42 Stepping 7, GenuineIntel')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PROCESSOR_LEVEL', N'6')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PROCESSOR_REVISION', N'2a07')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.ProgramData', N'C:\ProgramData')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.ProgramFiles', N'C:\Program Files (x86)')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.ProgramFiles(x86)', N'C:\Program Files (x86)')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.ProgramW6432', N'C:\Program Files')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PROMPT', N'$P$G')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PSModulePath', N'C:\Users\Mark\Documents\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules\')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.PUBLIC', N'C:\Users\Public')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.SystemDrive', N'C:')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.SystemRoot', N'C:\Windows')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_AGENT_CONFIG_FILE', N'..\conf\buildAgent.properties')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_AGENT_CURRENT_DIR', N'C:\TeamCity\buildAgent\bin')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_AGENT_LOG_DIR', N'../logs/')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_AGENT_MEM_OPTS_ACTUAL', N'-Xmx384m')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_AGENT_OPTS_ACTUAL', N' -ea -Xmx384m -Dlog4j.configuration=file:../conf/teamcity-agent-log4j.xml -Dteamcity_logs=../logs/')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_CAPTURE_ENV', N'C:\TeamCity\jre\bin\java.exe -jar C:\TeamCity\buildAgent\plugins\environment-fetcher\bin\env-fetcher.jar')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_GIT_PATH', N'C:\Program Files (x86)\Git\bin\git.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_JRE', N'C:\TeamCity\jre')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_LAUNCHER_CLASSPATH', N'..\launcher\lib\launcher.jar')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_LAUNCHER_OPTS_ACTUAL', N' -ea')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_RUNALL_CURRENT_DIR', N'C:\TeamCity\bin')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_SERVER_CURRENT_DIR', N'C:\TeamCity\bin')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEAMCITY_SERVER_MEM_OPTS_ACTUAL', N'-Xmx512m -XX:MaxPermSize=270m')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TEMP', N'C:\Users\Mark\AppData\Local\Temp')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.TMP', N'C:\Users\Mark\AppData\Local\Temp')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.USERDOMAIN', N'MARK-LAPTOP')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.USERDOMAIN_ROAMINGPROFILE', N'MARK-LAPTOP')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.USERNAME', N'Mark')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.USERPROFILE', N'C:\Users\Mark')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.VBOX_INSTALL_PATH', N'C:\Program Files\Oracle\VirtualBox\')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.VS110COMNTOOLS', N'C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\Tools\')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'env.windir', N'C:\Windows')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.agent.home.dir', N'C:\TeamCity\buildAgent')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.agent.name', N'MARK-LAPTOP')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.agent.work.dir', N'C:\TeamCity\buildAgent\work')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.file.encoding', N'Cp1252')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.file.separator', N'\')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.MSTest.11.0', N'C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\MSTest.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.os.arch', N'x86')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.os.name', N'Windows NT (unknown)')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.os.version', N'6.2')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.path.separator', N';')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.agent.cpuBenchmark', N'447')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.build.tempDir', N'C:\TeamCity\buildAgent\temp\buildTmp')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.dotnet.nunitaddin', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.TeamCity.NUnitAddin-NUnit')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.dotnet.nunitlauncher', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.BuildServer.NUnitLauncher.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.dotnet.nunitlauncher.msbuild.task', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.BuildServer.MSBuildLoggers.dll')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.dotnet.nunitlauncher1.1', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.BuildServer.NUnitLauncher1.1.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.dotnet.nunitlauncher2.0', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.BuildServer.NUnitLauncher2.0.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.dotnet.nunitlauncher2.0.vsts', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.BuildServer.NUnitLauncher2.0.VSTS.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.teamcity.dotnet.platform', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.TeamCity.PlatformProcessRunner.1.1.exe')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.user.country', N'GB')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.user.home', N'C:\Users\Mark')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.user.language', N'en')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.user.name', N'Mark')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.user.timezone', N'Europe/London')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'B', N'system.user.variant', NULL)
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework2.0.50727_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v2.0.50727')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework2.0.50727_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v2.0.50727')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework2.0_x64', N'2.0.50727')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework2.0_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v2.0.50727')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework2.0_x86', N'2.0.50727')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework2.0_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v2.0.50727')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.0.30729.4926_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v3.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.0.30729.4926_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v3.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.0_x64', N'3.0.30729.4926')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.0_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v3.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.0_x86', N'3.0.30729.4926')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.0_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v3.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.5.30729.4926_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v3.5')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.5.30729.4926_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v3.5')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.5_x64', N'3.5.30729.4926')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.5_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v3.5')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.5_x86', N'3.5.30729.4926')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework3.5_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v3.5')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.0.30319_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.0.30319_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.0_x64', N'4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.0_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.0_x86', N'4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.0_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.5.50709_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.5.50709_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.5_x64', N'4.5.50709')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.5_x64_Path', N'C:\Windows\Microsoft.NET\Framework64\v4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.5_x86', N'4.5.50709')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'DotNetFramework4.5_x86_Path', N'C:\Windows\Microsoft.NET\Framework\v4.0.30319')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'powershell_x64', N'2.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'powershell_x64_Path', N'C:\Windows\System32\WindowsPowerShell\v1.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'powershell_x86', N'2.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'powershell_x86_Path', N'C:\Windows\SysWOW64\WindowsPowerShell\v1.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.hardware.cpuCount', N'8')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.hardware.memorySizeMb', N'4095')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.home.dir', N'C:\TeamCity\buildAgent')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.jvm.specification', N'1.6')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.jvm.version', N'1.6.0_31')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.launcher.version', N'24074')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.name', N'MARK-LAPTOP')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.ownPort', N'9090')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.tools.dir', N'C:\TeamCity\buildAgent\tools')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.work.dir', N'C:\TeamCity\buildAgent\work')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.agent.work.dir.freeSpaceMb', N'53273')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.dotCover.home', N'C:\TeamCity\buildAgent\tools\dotCover')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.dotnet.msbuild.extensions2.0', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.BuildServer.MSBuildLoggers.dll')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.dotnet.msbuild.extensions4.0', N'C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.BuildServer.MSBuildLoggers.4.0.dll')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.hg.agent.path', N'hg')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'teamcity.serverUrl', N'http://localhost:8111')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'VS2010', N'10.0.40219.1')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'VS2010_Path', N'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'VS2012', N'11.0.50727.1')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'VS2012_Path', N'C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'WindowsSDKv8.0', N'6.2..9200')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'WindowsSDKv8.0_Path', N'C:\Program Files (x86)\Windows Kits\8.0')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'WindowsSDKv8.0A', N'8.0.50709')
GO
INSERT [dbo].[agent_type_param] ([agent_type_id], [param_kind], [param_name], [param_value]) VALUES (1, N'C', N'WindowsSDKv8.0A_Path', N'C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'Ant')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'dotnet-tools-dupfinder')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'dotnet-tools-inspectcode')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'Duplicator')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'FxCop')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'gradle-runner')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'Inspection')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'Ipr')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'jb.nuget.installer')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'jb.nuget.pack')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'jb.nuget.publish')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'jetbrains.dotNetGenericRunner')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'jetbrains.mspec')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'jetbrains_powershell')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'JPS')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'Maven2')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'MSBuild')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'MSTest')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'NAnt')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'NUnit')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'rake-runner')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'simpleRunner')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'sln2003')
GO
INSERT [dbo].[agent_type_runner] ([agent_type_id], [runner]) VALUES (1, N'VS.Solution')
GO
INSERT [dbo].[agent_type_vcs] ([agent_type_id], [vcs]) VALUES (1, N'cvs')
GO
INSERT [dbo].[agent_type_vcs] ([agent_type_id], [vcs]) VALUES (1, N'jetbrains.git')
GO
INSERT [dbo].[agent_type_vcs] ([agent_type_id], [vcs]) VALUES (1, N'mercurial')
GO
INSERT [dbo].[agent_type_vcs] ([agent_type_id], [vcs]) VALUES (1, N'perforce')
GO
INSERT [dbo].[agent_type_vcs] ([agent_type_id], [vcs]) VALUES (1, N'svn')
GO
INSERT [dbo].[agent_type_vcs] ([agent_type_id], [vcs]) VALUES (1, N'tfs')
GO
INSERT [dbo].[comments] ([id], [author_id], [when_changed], [commentary]) VALUES (1, -1, 1349698479932, N'Locally installed agent is authorized by default')
GO
INSERT [dbo].[db_version] ([version_number], [version_time]) VALUES (544, CAST(0x0000A0E400DA2639 AS DateTime))
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 1, N'-- INTERNAL BACKUP CONFIGURATION')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 2, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 3, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 4, N'TABLES-NOT-TO-BACKUP')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 5, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 6, N' working_server')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 7, N' virtual$lock')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 8, N' build_set_tmp')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 9, N' backup_builds')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 10, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 11, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 12, N'TABLES-TO-FILTER-BY-BUILDS')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 13, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 14, N' build_data_storage')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 15, N' build_labels')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 16, N' build_runtime_info')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 17, N' compiler_output')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 18, N' failed_tests_output')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 19, N' ignored_tests')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 20, N' personal_build_relative_path')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 21, N' stats')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 22, N' tc_build_tags')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 23, N' test_info')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 24, N' test_info_trunk')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 25, N' inspection_results')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 26, N' inspection_stats')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 27, N' inspection_diff')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 28, N' duplicate_results')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 29, N' duplicate_diff')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 30, N' duplicate_stats')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 31, N' running')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 32, N' history')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 33, N' light_history')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 34, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 35, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 36, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 37, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 38, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'backup.config', 39, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 1, N'-- TEAMCITY DATABASE SCHEMA')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 2, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 3, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 4, N'-- Each table describes as a table name started from the first position of the line,')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 5, N'-- and followed by its inner constructions with offset. All inner constructions')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 6, N'-- should be written with the same offset.')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 7, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 8, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 9, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 10, N'-- Abbreviations')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 11, N'-- -------------')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 12, N'-- M: mandatory (not null)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 13, N'-- PK: primary key')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 14, N'-- AK: alternative key (unique index)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 15, N'-- IE: inversion entry (non-unique index)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 16, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 17, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 18, N'-- Data types')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 19, N'-- ----------')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 20, N'-- int : 4-bytes signed integer')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 21, N'-- long_int : 8-bytes signed integer')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 22, N'-- decimal(d) : d-digits integer number')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 23, N'-- str(n) : string of length n, n is limited to 2000')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 24, N'-- long_str(n) : long text of length n (CLOB)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 25, N'-- char : one character')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 26, N'-- timestamp : date and time with 1 second precision, without time zone')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 27, N'-- boolean : boolean')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 28, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 29, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 30, N'-- Notes:')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 31, N'-- 1. The first table shoule be ''db_version'', the last table should be ''server''.')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 32, N'-- 2. All names should be written in lower case; national characters are not allowed.')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 33, N'-- 3. Name of temporary tables are suffixed with ''$''.')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 34, N'-- 4. Ensure that there are no tab characters at beginning of lines.')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 35, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 36, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 37, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 38, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 39, N'db_version')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 40, N' version_number: int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 41, N' version_time: timestamp M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 42, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 43, N' db_version_pk: PK (version_number)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 44, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 45, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 46, N'meta_file_line')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 47, N' file_name: str(15) M -- metadata file name with suffix')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 48, N' line_nr: int M -- line number, started with 1')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 49, N' line_text: str(160) -- text of line')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 50, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 51, N' meta_file_line_pk: PK (file_name, line_nr)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 52, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 53, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 54, N'single_row')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 55, N' dummy_field: char')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 56, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 57, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 58, N'agent')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 59, N' id: int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 60, N' name: str(80) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 61, N' host_addr: str(80) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 62, N' port: int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 63, N' agent_type_id: int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 64, N' status: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 65, N' authorized: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 66, N' registered: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 67, N' registration_timestamp: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 68, N' last_binding_timestamp: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 69, N' unregistered_reason: str(256)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 70, N' authorization_token: str(32)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 71, N' status_to_restore: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 72, N' status_restoring_timestamp: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 73, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 74, N' agent_pk: PK (id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 75, N' agent_name_ui: AK (name)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 76, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 77, N' agent_host_address: IE (host_addr)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 78, N' agent_authorization_token: IE (authorization_token)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 79, N' agent_agent_type_id: IE (agent_type_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 80, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 81, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 82, N'deleted_build_types')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 83, N' build_type_id: str(80) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 84, N' delete_time: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 85, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 86, N' deleted_build_types_pk: PK (build_type_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 87, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 88, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 89, N'archived_projects')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 90, N' project_id: str(80) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 91, N' user_id: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 92, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 93, N' archived_projects_pk: PK (project_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 94, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 95, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 96, N'build_data_storage')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 97, N' build_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 98, N' metric_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 99, N' metric_value: decimal(19) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 100, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 101, N' build_data_storage_pk: PK (build_id, metric_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 102, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 103, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 104, N'canceled_info')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 105, N' build_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 106, N' user_id: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 107, N' description: str(256)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 108, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 109, N' canceled_info_pk: PK (build_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 110, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 111, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 112, N'running')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 113, N' build_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 114, N' agent_id: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 115, N' build_type_id: str(80)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 116, N' build_start_time_agent: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 117, N' build_start_time_server: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 118, N' is_personal: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 119, N' build_number: str(256)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 120, N' requestor: str(1024)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 121, N' access_code: str(60)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 122, N' queued_ag_restr_type_id: int -- agent restrictor type id')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 123, N' queued_ag_restr_id: int -- agent restrictor id')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 124, N' queued_time: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 125, N' remove_from_queue_time: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 126, N' build_state_id: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 127, N' agent_type_id: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 128, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 129, N' running_pk: PK (build_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 130, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 131, N' running_state_id: IE (build_state_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 132, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 133, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 134, N'build_state')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 135, N' id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 136, N' build_type_id: str(80)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 137, N' modification_id: long_int -- can be -1 if changes checking was not performed yet')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 138, N' is_personal: int M default 0')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 139, N' is_canceled: int M default 0')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 140, N' is_changes_detached: int M default 0')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 141, N' is_deleted: boolean M default 0')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 142, N' branch_name: str(255) -- null means no branch (master)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 143, N' build_id: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 144, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 145, N' build_state_pk: PK (id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 146, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 147, N' build_state_mod_id: IE (modification_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 148, N' build_state_build_type_id: IE (build_type_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 149, N' build_state_build_id: IE (build_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 150, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 151, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 152, N'build_dependency')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 153, N' build_state_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 154, N' depends_on: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 155, N' dependency_options: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 156, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 157, N' build_dependency_pk: PK (build_state_id, depends_on)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 158, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 159, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 160, N'build_attrs')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 161, N' build_state_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 162, N' attr_name: str(70) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 163, N' attr_value: str(1000)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 164, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 165, N' build_attrs_pk: PK (build_state_id, attr_name)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 166, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 167, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 168, N'build_problems')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 169, N' build_state_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 170, N' problem_identity: str(60) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 171, N' problem_type: str(80) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 172, N' problem_description: long_str(4000)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 173, N' is_muted: boolean M default 0')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 174, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 175, N' build_problems_pk: PK (build_state_id, problem_identity)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 176, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 177, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 178, N'build_artifact_dependency')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 179, N' build_state_id: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 180, N' source_build_type_id: str(80)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 181, N' src_paths: long_str(40960)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 182, N' revision_rule: str(80)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 183, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 184, N' build_artif_dep_state_id: IE (build_state_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 185, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 186, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 187, N'final_artifact_dependency')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 188, N' build_state_id: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 189, N' source_build_type_id: str(80)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 190, N' src_paths: long_str(40960)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 191, N' revision_rule: str(80)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 192, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 193, N' final_artif_dep_state_id: IE (build_state_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 194, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 195, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 196, N'agent_sources_version')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 197, N' build_type_id: str(80) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 198, N' vcs_root_id: int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 199, N' agent_id: int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 200, N' vcs_settings_hash: str(16) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 201, N' checkout_dir: str(2048)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 202, N' current_version: str(80)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 203, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 204, N' agent_sources_version_pk: PK (build_type_id, vcs_settings_hash, vcs_root_id, agent_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 205, N' agent_sources_version_hidx: IE (vcs_settings_hash)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 206, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 207, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 208, N'vcs_history')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 209, N' modification_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 210, N' user_name: str(255)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 211, N' description: long_str(4000)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 212, N' change_date: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 213, N' register_date: long_int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 214, N' vcs_root_id: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 215, N' changes_count: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 216, N' version: str(200) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 217, N' display_version: str(200)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 218, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 219, N' vcs_history_pk: PK (modification_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 220, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 221, N' vcs_history_root: IE (vcs_root_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 222, N' vcs_history_user: IE (user_name)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 223, N' vcs_version_in_root_i: IE (vcs_root_id, version)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 224, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 225, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 226, N'build_type_vcs_change')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 227, N' modification_id: long_int M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 228, N' build_type_id: str(80) M')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 229, N' branch_id: int')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 230, N'')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 231, N' build_type_vcs_change_ui: AK (modification_id, build_type_id)')
GO
INSERT [dbo].[meta_file_line] ([file_name], [line_nr], [line_text]) VALUES (N'schema.config', 232, N' build_type_vcs_change_btid: IE (build_type_id)')
GO
INSERT [dbo].[meta_file_li