/****** Object: Table [dbo].[mantis_bug_file_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[mantis_bug_file_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [bug_id] [bigint] NOT NULL, [title] [nvarchar](250) NOT NULL, [description] [nvarchar](250) NOT NULL, [diskfile] [nvarchar](250) NOT NULL, [filename] [nvarchar](250) NOT NULL, [folder] [nvarchar](250) NOT NULL, [filesize] [int] NOT NULL, [file_type] [nvarchar](250) NOT NULL, [content] [varbinary](max) NOT NULL, [date_added] [bigint] NOT NULL, [user_id] [bigint] NOT NULL, CONSTRAINT [PK_mantis_bug_file_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[mantis_bug_history_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bug_history_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [user_id] [bigint] NOT NULL, [bug_id] [bigint] NOT NULL, [field_name] [nvarchar](64) NOT NULL, [old_value] [nvarchar](255) NOT NULL, [new_value] [nvarchar](255) NOT NULL, [type] [smallint] NOT NULL, [date_modified] [bigint] NOT NULL, CONSTRAINT [PK_mantis_bug_history_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_bug_monitor_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bug_monitor_table]( [user_id] [bigint] NOT NULL, [bug_id] [bigint] NOT NULL, CONSTRAINT [PK_mantis_bug_monitor_table_user_id] PRIMARY KEY CLUSTERED ( [user_id] ASC, [bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_bug_relationship_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bug_relationship_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [source_bug_id] [bigint] NOT NULL, [destination_bug_id] [bigint] NOT NULL, [relationship_type] [smallint] NOT NULL, CONSTRAINT [PK_mantis_bug_relationship_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_bug_revision_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bug_revision_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [bug_id] [bigint] NOT NULL, [bugnote_id] [bigint] NOT NULL, [user_id] [bigint] NOT NULL, [type] [bigint] NOT NULL, [value] [nvarchar](max) NOT NULL, [timestamp] [bigint] NOT NULL, CONSTRAINT [PK_mantis_bug_revision_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_bug_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bug_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [project_id] [bigint] NOT NULL, [reporter_id] [bigint] NOT NULL, [handler_id] [bigint] NOT NULL, [duplicate_id] [bigint] NOT NULL, [priority] [smallint] NOT NULL, [severity] [smallint] NOT NULL, [reproducibility] [smallint] NOT NULL, [status] [smallint] NOT NULL, [resolution] [smallint] NOT NULL, [projection] [smallint] NOT NULL, [eta] [smallint] NOT NULL, [bug_text_id] [bigint] NOT NULL, [os] [nvarchar](32) NOT NULL, [os_build] [nvarchar](32) NOT NULL, [platform] [nvarchar](32) NOT NULL, [version] [nvarchar](64) NOT NULL, [fixed_in_version] [nvarchar](64) NOT NULL, [build] [nvarchar](32) NOT NULL, [profile_id] [bigint] NOT NULL, [view_state] [smallint] NOT NULL, [summary] [nvarchar](128) NOT NULL, [sponsorship_total] [int] NOT NULL, [sticky] [smallint] NOT NULL, [target_version] [nvarchar](64) NOT NULL, [category_id] [bigint] NOT NULL, [date_submitted] [bigint] NOT NULL, [due_date] [bigint] NOT NULL, [last_updated] [bigint] NOT NULL, CONSTRAINT [PK_mantis_bug_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_bug_tag_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bug_tag_table]( [bug_id] [bigint] NOT NULL, [tag_id] [bigint] NOT NULL, [user_id] [bigint] NOT NULL, [date_attached] [bigint] NOT NULL, CONSTRAINT [PK_mantis_bug_tag_table_bug_id] PRIMARY KEY CLUSTERED ( [bug_id] ASC, [tag_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_bug_text_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bug_text_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [description] [nvarchar](max) NOT NULL, [steps_to_reproduce] [nvarchar](max) NOT NULL, [additional_information] [nvarchar](max) NOT NULL, CONSTRAINT [PK_mantis_bug_text_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_bugnote_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bugnote_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [bug_id] [bigint] NOT NULL, [reporter_id] [bigint] NOT NULL, [bugnote_text_id] [bigint] NOT NULL, [view_state] [smallint] NOT NULL, [note_type] [int] NULL, [note_attr] [nvarchar](250) NULL, [time_tracking] [bigint] NOT NULL, [last_modified] [bigint] NOT NULL, [date_submitted] [bigint] NOT NULL, CONSTRAINT [PK_mantis_bugnote_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_bugnote_text_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_bugnote_text_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [note] [nvarchar](max) NOT NULL, CONSTRAINT [PK_mantis_bugnote_text_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_category_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_category_table]( [id] [bigint] IDENTITY(2,1) NOT NULL, [project_id] [bigint] NOT NULL, [user_id] [bigint] NOT NULL, [name] [nvarchar](128) NOT NULL, [status] [bigint] NOT NULL, CONSTRAINT [PK_mantis_category_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [mantis_category_table$idx_category_project_name] UNIQUE NONCLUSTERED ( [project_id] ASC, [name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_config_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_config_table]( [config_id] [nvarchar](64) NOT NULL, [project_id] [int] NOT NULL, [user_id] [int] NOT NULL, [access_reqd] [int] NULL, [type] [int] NULL, [value] [nvarchar](max) NOT NULL, CONSTRAINT [PK_mantis_config_table_config_id] PRIMARY KEY CLUSTERED ( [config_id] ASC, [project_id] ASC, [user_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_custom_field_project_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_custom_field_project_table]( [field_id] [int] NOT NULL, [project_id] [bigint] NOT NULL, [sequence] [smallint] NOT NULL, CONSTRAINT [PK_mantis_custom_field_project_table_field_id] PRIMARY KEY CLUSTERED ( [field_id] ASC, [project_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_custom_field_string_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_custom_field_string_table]( [field_id] [int] NOT NULL, [bug_id] [int] NOT NULL, [value] [nvarchar](255) NOT NULL, CONSTRAINT [PK_mantis_custom_field_string_table_field_id] PRIMARY KEY CLUSTERED ( [field_id] ASC, [bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_custom_field_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_custom_field_table]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [nvarchar](64) NOT NULL, [type] [smallint] NOT NULL, [possible_values] [nvarchar](max) NOT NULL, [default_value] [nvarchar](255) NOT NULL, [valid_regexp] [nvarchar](255) NOT NULL, [access_level_r] [smallint] NOT NULL, [access_level_rw] [smallint] NOT NULL, [length_min] [int] NOT NULL, [length_max] [int] NOT NULL, [require_report] [smallint] NOT NULL, [require_update] [smallint] NOT NULL, [display_report] [smallint] NOT NULL, [display_update] [smallint] NOT NULL, [require_resolved] [smallint] NOT NULL, [display_resolved] [smallint] NOT NULL, [display_closed] [smallint] NOT NULL, [require_closed] [smallint] NOT NULL, [filter_by] [smallint] NOT NULL, CONSTRAINT [PK_mantis_custom_field_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_email_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_email_table]( [email_id] [bigint] IDENTITY(1,1) NOT NULL, [email] [nvarchar](64) NOT NULL, [subject] [nvarchar](250) NOT NULL, [metadata] [nvarchar](max) NOT NULL, [body] [nvarchar](max) NOT NULL, [submitted] [bigint] NOT NULL, CONSTRAINT [PK_mantis_email_table_email_id] PRIMARY KEY CLUSTERED ( [email_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_filters_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_filters_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [user_id] [int] NOT NULL, [project_id] [int] NOT NULL, [is_public] [smallint] NULL, [name] [nvarchar](64) NOT NULL, [filter_string] [nvarchar](max) NOT NULL, CONSTRAINT [PK_mantis_filters_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_news_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_news_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [project_id] [bigint] NOT NULL, [poster_id] [bigint] NOT NULL, [view_state] [smallint] NOT NULL, [announcement] [smallint] NOT NULL, [headline] [nvarchar](64) NOT NULL, [body] [nvarchar](max) NOT NULL, [last_modified] [bigint] NOT NULL, [date_posted] [bigint] NOT NULL, CONSTRAINT [PK_mantis_news_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_plugin_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_plugin_table]( [basename] [nvarchar](40) NOT NULL, [enabled] [smallint] NOT NULL, [protected] [smallint] NOT NULL, [priority] [bigint] NOT NULL, CONSTRAINT [PK_mantis_plugin_table_basename] PRIMARY KEY CLUSTERED ( [basename] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_project_file_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[mantis_project_file_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [project_id] [bigint] NOT NULL, [title] [nvarchar](250) NOT NULL, [description] [nvarchar](250) NOT NULL, [diskfile] [nvarchar](250) NOT NULL, [filename] [nvarchar](250) NOT NULL, [folder] [nvarchar](250) NOT NULL, [filesize] [int] NOT NULL, [file_type] [nvarchar](250) NOT NULL, [content] [varbinary](max) NOT NULL, [date_added] [bigint] NOT NULL, [user_id] [bigint] NOT NULL, CONSTRAINT [PK_mantis_project_file_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[mantis_project_hierarchy_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_project_hierarchy_table]( [child_id] [bigint] NOT NULL, [parent_id] [bigint] NOT NULL, [inherit_parent] [bigint] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_project_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_project_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [name] [nvarchar](128) NOT NULL, [status] [smallint] NOT NULL, [enabled] [smallint] NOT NULL, [view_state] [smallint] NOT NULL, [access_min] [smallint] NOT NULL, [file_path] [nvarchar](250) NOT NULL, [description] [nvarchar](max) NOT NULL, [category_id] [bigint] NOT NULL, [inherit_global] [bigint] NOT NULL, CONSTRAINT [PK_mantis_project_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [mantis_project_table$idx_project_name] UNIQUE NONCLUSTERED ( [name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_project_user_list_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_project_user_list_table]( [project_id] [bigint] NOT NULL, [user_id] [bigint] NOT NULL, [access_level] [smallint] NOT NULL, CONSTRAINT [PK_mantis_project_user_list_table_project_id] PRIMARY KEY CLUSTERED ( [project_id] ASC, [user_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_project_version_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_project_version_table]( [id] [int] IDENTITY(1,1) NOT NULL, [project_id] [bigint] NOT NULL, [version] [nvarchar](64) NOT NULL, [description] [nvarchar](max) NOT NULL, [released] [smallint] NOT NULL, [obsolete] [smallint] NOT NULL, [date_order] [bigint] NOT NULL, CONSTRAINT [PK_mantis_project_version_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [mantis_project_version_table$idx_project_version] UNIQUE NONCLUSTERED ( [project_id] ASC, [version] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_sponsorship_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_sponsorship_table]( [id] [int] IDENTITY(1,1) NOT NULL, [bug_id] [int] NOT NULL, [user_id] [int] NOT NULL, [amount] [int] NOT NULL, [logo] [nvarchar](128) NOT NULL, [url] [nvarchar](128) NOT NULL, [paid] [smallint] NOT NULL, [date_submitted] [bigint] NOT NULL, [last_updated] [bigint] NOT NULL, CONSTRAINT [PK_mantis_sponsorship_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_tag_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_tag_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [user_id] [bigint] NOT NULL, [name] [nvarchar](100) NOT NULL, [description] [nvarchar](max) NOT NULL, [date_created] [bigint] NOT NULL, [date_updated] [bigint] NOT NULL, CONSTRAINT [PK_mantis_tag_table_id] PRIMARY KEY CLUSTERED ( [id] ASC, [name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_tokens_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_tokens_table]( [id] [int] IDENTITY(1,1) NOT NULL, [owner] [int] NOT NULL, [type] [int] NOT NULL, [value] [nvarchar](max) NOT NULL, [timestamp] [bigint] NOT NULL, [expiry] [bigint] NOT NULL, CONSTRAINT [PK_mantis_tokens_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_user_pref_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_user_pref_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [user_id] [bigint] NOT NULL, [project_id] [bigint] NOT NULL, [default_profile] [bigint] NOT NULL, [default_project] [bigint] NOT NULL, [refresh_delay] [int] NOT NULL, [redirect_delay] [int] NOT NULL, [bugnote_order] [nvarchar](4) NOT NULL, [email_on_new] [smallint] NOT NULL, [email_on_assigned] [smallint] NOT NULL, [email_on_feedback] [smallint] NOT NULL, [email_on_resolved] [smallint] NOT NULL, [email_on_closed] [smallint] NOT NULL, [email_on_reopened] [smallint] NOT NULL, [email_on_bugnote] [smallint] NOT NULL, [email_on_status] [smallint] NOT NULL, [email_on_priority] [smallint] NOT NULL, [email_on_priority_min_severity] [smallint] NOT NULL, [email_on_status_min_severity] [smallint] NOT NULL, [email_on_bugnote_min_severity] [smallint] NOT NULL, [email_on_reopened_min_severity] [smallint] NOT NULL, [email_on_closed_min_severity] [smallint] NOT NULL, [email_on_resolved_min_severity] [smallint] NOT NULL, [email_on_feedback_min_severity] [smallint] NOT NULL, [email_on_assigned_min_severity] [smallint] NOT NULL, [email_on_new_min_severity] [smallint] NOT NULL, [email_bugnote_limit] [smallint] NOT NULL, [language] [nvarchar](32) NOT NULL, [timezone] [nvarchar](32) NOT NULL, CONSTRAINT [PK_mantis_user_pref_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_user_print_pref_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_user_print_pref_table]( [user_id] [bigint] NOT NULL, [print_pref] [nvarchar](64) NOT NULL, CONSTRAINT [PK_mantis_user_print_pref_table_user_id] PRIMARY KEY CLUSTERED ( [user_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_user_profile_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_user_profile_table]( [id] [bigint] IDENTITY(1,1) NOT NULL, [user_id] [bigint] NOT NULL, [platform] [nvarchar](32) NOT NULL, [os] [nvarchar](32) NOT NULL, [os_build] [nvarchar](32) NOT NULL, [description] [nvarchar](max) NOT NULL, CONSTRAINT [PK_mantis_user_profile_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[mantis_user_table] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mantis_user_table]( [id] [bigint] IDENTITY(2,1) NOT NULL, [username] [nvarchar](32) NOT NULL, [realname] [nvarchar](64) NOT NULL, [email] [nvarchar](64) NOT NULL, [password] [nvarchar](32) NOT NULL, [enabled] [smallint] NOT NULL, [protected] [smallint] NOT NULL, [access_level] [smallint] NOT NULL, [login_count] [int] NOT NULL, [lost_password_request_count] [smallint] NOT NULL, [failed_login_count] [smallint] NOT NULL, [cookie_string] [nvarchar](64) NOT NULL, [last_visit] [bigint] NOT NULL, [date_created] [bigint] NOT NULL, CONSTRAINT [PK_mantis_user_table_id] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [mantis_user_table$idx_user_cookie_string] UNIQUE NONCLUSTERED ( [cookie_string] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [mantis_user_table$idx_user_username] UNIQUE NONCLUSTERED ( [username] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Index [idx_bug_file_bug_id] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug_file_bug_id] ON [dbo].[mantis_bug_file_table] ( [bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [idx_diskfile] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_diskfile] ON [dbo].[mantis_bug_file_table] ( [diskfile] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_bug_history_bug_id] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug_history_bug_id] ON [dbo].[mantis_bug_history_table] ( [bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_history_user_id] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_history_user_id] ON [dbo].[mantis_bug_history_table] ( [user_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_relationship_destination] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_relationship_destination] ON [dbo].[mantis_bug_relationship_table] ( [destination_bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_relationship_source] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_relationship_source] ON [dbo].[mantis_bug_relationship_table] ( [source_bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_bug_rev_id_time] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug_rev_id_time] ON [dbo].[mantis_bug_revision_table] ( [bug_id] ASC, [timestamp] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_bug_rev_type] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug_rev_type] ON [dbo].[mantis_bug_revision_table] ( [type] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [idx_bug_fixed_in_version] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug_fixed_in_version] ON [dbo].[mantis_bug_table] ( [fixed_in_version] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_bug_sponsorship_total] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug_sponsorship_total] ON [dbo].[mantis_bug_table] ( [sponsorship_total] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_bug_status] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug_status] ON [dbo].[mantis_bug_table] ( [status] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_project] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_project] ON [dbo].[mantis_bug_table] ( [project_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_bug_tag_tag_id] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug_tag_tag_id] ON [dbo].[mantis_bug_tag_table] ( [tag_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_bug] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_bug] ON [dbo].[mantis_bugnote_table] ( [bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_last_mod] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_last_mod] ON [dbo].[mantis_bugnote_table] ( [last_modified] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_custom_field_bug] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_custom_field_bug] ON [dbo].[mantis_custom_field_string_table] ( [bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [idx_custom_field_name] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_custom_field_name] ON [dbo].[mantis_custom_field_table] ( [name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_project_hierarchy_child_id] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_project_hierarchy_child_id] ON [dbo].[mantis_project_hierarchy_table] ( [child_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_project_hierarchy_parent_id] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_project_hierarchy_parent_id] ON [dbo].[mantis_project_hierarchy_table] ( [parent_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_project_view] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_project_view] ON [dbo].[mantis_project_table] ( [view_state] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_project_user] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_project_user] ON [dbo].[mantis_project_user_list_table] ( [user_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_sponsorship_bug_id] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_sponsorship_bug_id] ON [dbo].[mantis_sponsorship_table] ( [bug_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_sponsorship_user_id] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_sponsorship_user_id] ON [dbo].[mantis_sponsorship_table] ( [user_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [idx_tag_name] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_tag_name] ON [dbo].[mantis_tag_table] ( [name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_typeowner] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_typeowner] ON [dbo].[mantis_tokens_table] ( [type] ASC, [owner] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_access] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_access] ON [dbo].[mantis_user_table] ( [access_level] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [idx_enable] Script Date: 15.2.2014 ã. 23:22:12 ÷. ******/ CREATE NONCLUSTERED INDEX [idx_enable] ON [dbo].[mantis_user_table] ( [enabled] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT ((0)) FOR [bug_id] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT (N'') FOR [title] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT (N'') FOR [description] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT (N'') FOR [diskfile] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT (N'') FOR [filename] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT (N'') FOR [folder] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT ((0)) FOR [filesize] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT (N'') FOR [file_type] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT ((1)) FOR [date_added] GO ALTER TABLE [dbo].[mantis_bug_file_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_bug_history_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_bug_history_table] ADD DEFAULT ((0)) FOR [bug_id] GO ALTER TABLE [dbo].[mantis_bug_history_table] ADD DEFAULT ((0)) FOR [type] GO ALTER TABLE [dbo].[mantis_bug_history_table] ADD DEFAULT ((1)) FOR [date_modified] GO ALTER TABLE [dbo].[mantis_bug_monitor_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_bug_monitor_table] ADD DEFAULT ((0)) FOR [bug_id] GO ALTER TABLE [dbo].[mantis_bug_relationship_table] ADD DEFAULT ((0)) FOR [source_bug_id] GO ALTER TABLE [dbo].[mantis_bug_relationship_table] ADD DEFAULT ((0)) FOR [destination_bug_id] GO ALTER TABLE [dbo].[mantis_bug_relationship_table] ADD DEFAULT ((0)) FOR [relationship_type] GO ALTER TABLE [dbo].[mantis_bug_revision_table] ADD DEFAULT ((0)) FOR [bugnote_id] GO ALTER TABLE [dbo].[mantis_bug_revision_table] ADD DEFAULT ((1)) FOR [timestamp] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((0)) FOR [reporter_id] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((0)) FOR [handler_id] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((0)) FOR [duplicate_id] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((30)) FOR [priority] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((50)) FOR [severity] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((10)) FOR [reproducibility] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((10)) FOR [status] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((10)) FOR [resolution] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((10)) FOR [projection] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((10)) FOR [eta] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((0)) FOR [bug_text_id] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT (N'') FOR [os] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT (N'') FOR [os_build] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT (N'') FOR [platform] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT (N'') FOR [version] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT (N'') FOR [fixed_in_version] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT (N'') FOR [build] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((0)) FOR [profile_id] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((10)) FOR [view_state] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT (N'') FOR [summary] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((0)) FOR [sponsorship_total] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((0)) FOR [sticky] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT (N'') FOR [target_version] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((1)) FOR [category_id] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((1)) FOR [date_submitted] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((1)) FOR [due_date] GO ALTER TABLE [dbo].[mantis_bug_table] ADD DEFAULT ((1)) FOR [last_updated] GO ALTER TABLE [dbo].[mantis_bug_tag_table] ADD DEFAULT ((0)) FOR [bug_id] GO ALTER TABLE [dbo].[mantis_bug_tag_table] ADD DEFAULT ((0)) FOR [tag_id] GO ALTER TABLE [dbo].[mantis_bug_tag_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_bug_tag_table] ADD DEFAULT ((1)) FOR [date_attached] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT ((0)) FOR [bug_id] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT ((0)) FOR [reporter_id] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT ((0)) FOR [bugnote_text_id] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT ((10)) FOR [view_state] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT ((0)) FOR [note_type] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT (N'') FOR [note_attr] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT ((0)) FOR [time_tracking] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT ((1)) FOR [last_modified] GO ALTER TABLE [dbo].[mantis_bugnote_table] ADD DEFAULT ((1)) FOR [date_submitted] GO ALTER TABLE [dbo].[mantis_category_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_category_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_category_table] ADD DEFAULT (N'') FOR [name] GO ALTER TABLE [dbo].[mantis_category_table] ADD DEFAULT ((0)) FOR [status] GO ALTER TABLE [dbo].[mantis_config_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_config_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_config_table] ADD DEFAULT ((0)) FOR [access_reqd] GO ALTER TABLE [dbo].[mantis_config_table] ADD DEFAULT ((90)) FOR [type] GO ALTER TABLE [dbo].[mantis_custom_field_project_table] ADD DEFAULT ((0)) FOR [field_id] GO ALTER TABLE [dbo].[mantis_custom_field_project_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_custom_field_project_table] ADD DEFAULT ((0)) FOR [sequence] GO ALTER TABLE [dbo].[mantis_custom_field_string_table] ADD DEFAULT ((0)) FOR [field_id] GO ALTER TABLE [dbo].[mantis_custom_field_string_table] ADD DEFAULT ((0)) FOR [bug_id] GO ALTER TABLE [dbo].[mantis_custom_field_string_table] ADD DEFAULT (N'') FOR [value] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT (N'') FOR [name] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [type] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT (N'') FOR [default_value] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT (N'') FOR [valid_regexp] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [access_level_r] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [access_level_rw] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [length_min] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [length_max] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [require_report] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [require_update] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [display_report] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((1)) FOR [display_update] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [require_resolved] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [display_resolved] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [display_closed] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((0)) FOR [require_closed] GO ALTER TABLE [dbo].[mantis_custom_field_table] ADD DEFAULT ((1)) FOR [filter_by] GO ALTER TABLE [dbo].[mantis_email_table] ADD DEFAULT (N'') FOR [email] GO ALTER TABLE [dbo].[mantis_email_table] ADD DEFAULT (N'') FOR [subject] GO ALTER TABLE [dbo].[mantis_email_table] ADD DEFAULT ((1)) FOR [submitted] GO ALTER TABLE [dbo].[mantis_filters_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_filters_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_filters_table] ADD DEFAULT (NULL) FOR [is_public] GO ALTER TABLE [dbo].[mantis_filters_table] ADD DEFAULT (N'') FOR [name] GO ALTER TABLE [dbo].[mantis_news_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_news_table] ADD DEFAULT ((0)) FOR [poster_id] GO ALTER TABLE [dbo].[mantis_news_table] ADD DEFAULT ((10)) FOR [view_state] GO ALTER TABLE [dbo].[mantis_news_table] ADD DEFAULT ((0)) FOR [announcement] GO ALTER TABLE [dbo].[mantis_news_table] ADD DEFAULT (N'') FOR [headline] GO ALTER TABLE [dbo].[mantis_news_table] ADD DEFAULT ((1)) FOR [last_modified] GO ALTER TABLE [dbo].[mantis_news_table] ADD DEFAULT ((1)) FOR [date_posted] GO ALTER TABLE [dbo].[mantis_plugin_table] ADD DEFAULT ((0)) FOR [enabled] GO ALTER TABLE [dbo].[mantis_plugin_table] ADD DEFAULT ((0)) FOR [protected] GO ALTER TABLE [dbo].[mantis_plugin_table] ADD DEFAULT ((3)) FOR [priority] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT (N'') FOR [title] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT (N'') FOR [description] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT (N'') FOR [diskfile] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT (N'') FOR [filename] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT (N'') FOR [folder] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT ((0)) FOR [filesize] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT (N'') FOR [file_type] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT ((1)) FOR [date_added] GO ALTER TABLE [dbo].[mantis_project_file_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_project_hierarchy_table] ADD DEFAULT ((0)) FOR [inherit_parent] GO ALTER TABLE [dbo].[mantis_project_table] ADD DEFAULT (N'') FOR [name] GO ALTER TABLE [dbo].[mantis_project_table] ADD DEFAULT ((10)) FOR [status] GO ALTER TABLE [dbo].[mantis_project_table] ADD DEFAULT ((1)) FOR [enabled] GO ALTER TABLE [dbo].[mantis_project_table] ADD DEFAULT ((10)) FOR [view_state] GO ALTER TABLE [dbo].[mantis_project_table] ADD DEFAULT ((10)) FOR [access_min] GO ALTER TABLE [dbo].[mantis_project_table] ADD DEFAULT (N'') FOR [file_path] GO ALTER TABLE [dbo].[mantis_project_table] ADD DEFAULT ((1)) FOR [category_id] GO ALTER TABLE [dbo].[mantis_project_table] ADD DEFAULT ((0)) FOR [inherit_global] GO ALTER TABLE [dbo].[mantis_project_user_list_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_project_user_list_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_project_user_list_table] ADD DEFAULT ((10)) FOR [access_level] GO ALTER TABLE [dbo].[mantis_project_version_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_project_version_table] ADD DEFAULT (N'') FOR [version] GO ALTER TABLE [dbo].[mantis_project_version_table] ADD DEFAULT ((1)) FOR [released] GO ALTER TABLE [dbo].[mantis_project_version_table] ADD DEFAULT ((0)) FOR [obsolete] GO ALTER TABLE [dbo].[mantis_project_version_table] ADD DEFAULT ((1)) FOR [date_order] GO ALTER TABLE [dbo].[mantis_sponsorship_table] ADD DEFAULT ((0)) FOR [bug_id] GO ALTER TABLE [dbo].[mantis_sponsorship_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_sponsorship_table] ADD DEFAULT ((0)) FOR [amount] GO ALTER TABLE [dbo].[mantis_sponsorship_table] ADD DEFAULT (N'') FOR [logo] GO ALTER TABLE [dbo].[mantis_sponsorship_table] ADD DEFAULT (N'') FOR [url] GO ALTER TABLE [dbo].[mantis_sponsorship_table] ADD DEFAULT ((0)) FOR [paid] GO ALTER TABLE [dbo].[mantis_sponsorship_table] ADD DEFAULT ((1)) FOR [date_submitted] GO ALTER TABLE [dbo].[mantis_sponsorship_table] ADD DEFAULT ((1)) FOR [last_updated] GO ALTER TABLE [dbo].[mantis_tag_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_tag_table] ADD DEFAULT (N'') FOR [name] GO ALTER TABLE [dbo].[mantis_tag_table] ADD DEFAULT ((1)) FOR [date_created] GO ALTER TABLE [dbo].[mantis_tag_table] ADD DEFAULT ((1)) FOR [date_updated] GO ALTER TABLE [dbo].[mantis_tokens_table] ADD DEFAULT ((1)) FOR [timestamp] GO ALTER TABLE [dbo].[mantis_tokens_table] ADD DEFAULT ((1)) FOR [expiry] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [project_id] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [default_profile] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [default_project] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [refresh_delay] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [redirect_delay] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT (N'ASC') FOR [bugnote_order] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_new] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_assigned] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_feedback] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_resolved] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_closed] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_reopened] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_bugnote] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_status] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_on_priority] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_priority_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_status_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_bugnote_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_reopened_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_closed_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_resolved_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_feedback_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_assigned_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((10)) FOR [email_on_new_min_severity] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT ((0)) FOR [email_bugnote_limit] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT (N'english') FOR [language] GO ALTER TABLE [dbo].[mantis_user_pref_table] ADD DEFAULT (N'') FOR [timezone] GO ALTER TABLE [dbo].[mantis_user_print_pref_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_user_profile_table] ADD DEFAULT ((0)) FOR [user_id] GO ALTER TABLE [dbo].[mantis_user_profile_table] ADD DEFAULT (N'') FOR [platform] GO ALTER TABLE [dbo].[mantis_user_profile_table] ADD DEFAULT (N'') FOR [os] GO ALTER TABLE [dbo].[mantis_user_profile_table] ADD DEFAULT (N'') FOR [os_build] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT (N'') FOR [username] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT (N'') FOR [realname] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT (N'') FOR [email] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT (N'') FOR [password] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT ((1)) FOR [enabled] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT ((0)) FOR [protected] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT ((10)) FOR [access_level] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT ((0)) FOR [login_count] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT ((0)) FOR [lost_password_request_count] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT ((0)) FOR [failed_login_count] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT (N'') FOR [cookie_string] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT ((1)) FOR [last_visit] GO ALTER TABLE [dbo].[mantis_user_table] ADD DEFAULT ((1)) FOR [date_created] GO /* Default user Name: Administrator Pass: root */ INSERT INTO [dbo].[mantis_user_table] ([username] ,[realname] ,[email] ,[password] ,[enabled] ,[protected] ,[access_level] ,[login_count] ,[lost_password_request_count] ,[failed_login_count] ,[cookie_string] ,[last_visit] ,[date_created]) VALUES ('administrator' ,'' ,'root@localhost' ,'63a9f0ea7bb98050796b649e85481845' ,1 ,0 ,90 ,3 ,0 ,0 ,'e01ec0fd0ab613505a2251914e10b2a318d24652bf2c41650233dcba11720b45' ,1392497832 ,1392497832) GO