CREATE TABLE lion_data.dbo.lion_Tasks (
  uid_obj UNIQUEIDENTIFIER NOT NULL
 ,uid_parent UNIQUEIDENTIFIER NOT NULL
 ,uid_customer UNIQUEIDENTIFIER NOT NULL
 ,email_performer NVARCHAR(800) NOT NULL
 ,name NVARCHAR(MAX) NOT NULL
 ,comment NVARCHAR(MAX) NOT NULL
 ,status INT NOT NULL
 ,uid_project UNIQUEIDENTIFIER NOT NULL
 ,date_create DATETIME NULL
 ,date_modify DATETIME NULL
 ,__usn_field_uid_parent INT NOT NULL
 ,__usn_field_uid_customer INT NOT NULL
 ,__usn_field_email_performer INT NOT NULL
 ,__usn_field_name INT NOT NULL
 ,__usn_field_comment INT NOT NULL
 ,__usn_field_status INT NOT NULL
 ,__usn_field_date_modify INT NOT NULL
 ,__usn_field_uid_project INT NOT NULL
 ,customer_order INT NULL
 ,customer_date_begin DATETIME NULL
 ,customer_date_end DATETIME NULL
 ,__usn_field_customer_order INT NULL
 ,__usn_field_customer_date INT NULL
 ,CreateTime DATETIME NULL
 ,__usn_field_createtime INT NULL
 ,PerformTime DATETIME NULL
 ,__usn_field_performtime INT NULL
 ,SeriesType INT NULL
 ,SeriesAfterType INT NULL
 ,SeriesAfterCount INT NULL
 ,SeriesWeekCount INT NULL
 ,SeriesWeekMon INT NULL
 ,SeriesWeekTue INT NULL
 ,SeriesWeekWed INT NULL
 ,SeriesWeekThu INT NULL
 ,SeriesWeekFri INT NULL
 ,SeriesWeekSat INT NULL
 ,SeriesWeekSun INT NULL
 ,SeriesMonthType INT NULL
 ,SeriesMonthCount INT NULL
 ,SeriesMonthDay INT NULL
 ,SeriesMonthWeekType INT NULL
 ,SeriesMonthDayOfWeek INT NULL
 ,SeriesYearType INT NULL
 ,SeriesYearMonth INT NULL
 ,SeriesYearMonthDay INT NULL
 ,SeriesYearWeekType INT NULL
 ,SeriesYearDayOfWeek INT NULL
 ,SeriesEnd DATETIME NULL
 ,__usn_field_series INT NULL
 ,CompleteTime DATETIME NULL
 ,__usn_field_completetime INT NULL
 ,order_new FLOAT NULL
 ,__usn_field_order_new INT NULL
 ,PerformerReaded INT NULL
 ,__usn_field_performerreaded INT NULL
 ,plugin NVARCHAR(MAX) NULL
 ,__usn_field_plugin INT NULL
 ,time INT NULL
 ,__usn_field_time INT NULL
 ,InWorkTime DATETIME NULL
 ,__usn_field_inworktime INT NULL
 ,[plan] INT NULL
 ,__usn_field_plan INT NULL
 ,Emails NVARCHAR(MAX) NULL
 ,__usn_field_list_members INT NULL
 ,checklist NVARCHAR(MAX) NULL
 ,__usn_field_checklist INT NULL
 ,CONSTRAINT PK_lion_Tasks PRIMARY KEY CLUSTERED (uid_obj)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX IX_lion_Tasks_CustomerUID
ON lion_data.dbo.lion_Tasks (uid_customer)
ON [PRIMARY]
GO

CREATE INDEX IX_lion_Tasks_email_performer
ON lion_data.dbo.lion_Tasks (email_performer)
ON [PRIMARY]
GO

CREATE INDEX IX_lion_Tasks_uid_project
ON lion_data.dbo.lion_Tasks (uid_project)
ON [PRIMARY]
GO

************************************************************************

CREATE TABLE lion_data.dbo.lion_Tasks_Changes_Parts (
  uid_obj_cp UNIQUEIDENTIFIER NOT NULL
 ,uid_task_cp UNIQUEIDENTIFIER NOT NULL
 ,uid_user_cp UNIQUEIDENTIFIER NOT NULL
 ,_order_cp INT NOT NULL
 ,uid_marker_cp UNIQUEIDENTIFIER NOT NULL
 ,date_begin_cp DATETIME NULL
 ,date_end_cp DATETIME NULL
 ,readed_cp INT NOT NULL
 ,collapsed_cp INT NOT NULL
 ,__usn_entity_cp INT NOT NULL
 ,__usn_field_order_cp INT NOT NULL
 ,__usn_field_uid_marker_cp INT NOT NULL
 ,__usn_field_date_begin_cp INT NOT NULL
 ,__usn_field_date_end_cp INT NOT NULL
 ,__usn_field_readed_cp INT NOT NULL
 ,__usn_field_collapsed_cp INT NOT NULL
 ,__usn_field_list_tags_cp INT NULL
 ,Contacts NVARCHAR(MAX) NULL
 ,__usn_field_contacts_cp INT NULL
 ,uid_user_marker UNIQUEIDENTIFIER NULL
 ,__usn_field_uid_user_marker INT NULL
 ,focus_cp INT NULL
 ,__usn_field_focus_cp INT NULL
 ,CONSTRAINT PK_lion_Tasks_Changes_Parts PRIMARY KEY CLUSTERED (uid_obj_cp)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX IDX_lion_Tasks_Changes_Parts_uid_marker_cp
ON lion_data.dbo.lion_Tasks_Changes_Parts (uid_marker_cp)
ON [PRIMARY]
GO

CREATE INDEX IX_lion_Tasks_CP_Uid_Task
ON lion_data.dbo.lion_Tasks_Changes_Parts (uid_task_cp)
ON [PRIMARY]
GO

CREATE INDEX IX_lion_Tasks_CP_Uid_User
ON lion_data.dbo.lion_Tasks_Changes_Parts (uid_user_cp)
ON [PRIMARY]
GO

CREATE UNIQUE INDEX UK_lion_Tasks_Changes_Parts
ON lion_data.dbo.lion_Tasks_Changes_Parts (uid_task_cp, uid_user_cp)
WITH (IGNORE_DUP_KEY = ON)
ON [PRIMARY]
GO

****************************************************************************

CREATE TABLE lion_data.dbo.lion_Tasks_Common (
  uid_task UNIQUEIDENTIFIER NULL
 ,uid_user UNIQUEIDENTIFIER NULL
) ON [PRIMARY]
GO

CREATE INDEX IDX_lion_Tasks_Common_uid_task
ON lion_data.dbo.lion_Tasks_Common (uid_task)
ON [PRIMARY]
GO

CREATE INDEX IDX_lion_Tasks_Common_uid_user
ON lion_data.dbo.lion_Tasks_Common (uid_user)
ON [PRIMARY]
GO

****************************************************************************

CREATE TABLE lion_data.dbo.lion_Projects_Changes_Parts (
  uid_obj_cp UNIQUEIDENTIFIER NOT NULL
 ,email_user_cp NVARCHAR(800) NOT NULL
 ,uid_project_cp UNIQUEIDENTIFIER NOT NULL
 ,_order_cp INT NOT NULL
 ,collapsed_cp INT NOT NULL
 ,show_cp INT NULL
 ,favorite_cp INT NULL
 ,__usn_entity_cp INT NOT NULL
 ,__usn_field_order_cp INT NOT NULL
 ,__usn_field_collapsed_cp INT NOT NULL
 ,__usn_field_show_cp INT NULL
 ,__usn_field_favorite_cp INT NULL
 ,quiet_cp INT NULL
 ,__usn_field_quiet_cp INT NULL
 ,CONSTRAINT PK_lion_Projects_Changes_Parts PRIMARY KEY CLUSTERED (uid_obj_cp)
) ON [PRIMARY]
GO

CREATE INDEX IX_lion_Projects_Changes_Parts_email_user_cp
ON lion_data.dbo.lion_Projects_Changes_Parts (email_user_cp)
ON [PRIMARY]
GO

CREATE INDEX IX_lion_Projects_Changes_Parts_uid_project_cp
ON lion_data.dbo.lion_Projects_Changes_Parts (uid_project_cp)
ON [PRIMARY]
GO

CREATE UNIQUE INDEX UK_lion_Projects_Changes_Parts
ON lion_data.dbo.lion_Projects_Changes_Parts (email_user_cp, uid_project_cp)
WITH (IGNORE_DUP_KEY = ON)
ON [PRIMARY]
GO