← All changes | database/Migrations/TaskMigrator.php +3 -1 1.95.3 → 2.2.0 View file →

		@@ -31,9 +31,9 @@
31	31	`status` VARCHAR(50) NULL DEFAULT 'open' COMMENT 'open, completed, for Boards, Won or Lost for Pipelines',
32	32	`stage_id` INT UNSIGNED NULL,
33	33	`source` VARCHAR(50) NULL DEFAULT 'web' COMMENT 'web, funnel, contact-section etc.',
34	34	`source_id` VARCHAR(255) NULL,
35		- `priority` VARCHAR(50) NULL DEFAULT 'low' COMMENT 'low, medium, high',
	35	+ `priority` VARCHAR(50) NULL DEFAULT NULL COMMENT 'urgent, high, medium, low',
36	36	`description` LONGTEXT NULL,
37	37	`lead_value` DECIMAL(10,2) DEFAULT 0.00,
38	38	`created_by` BIGINT UNSIGNED NULL,
39	39	`position` decimal(10,2) NOT NULL DEFAULT '1' COMMENT 'Position of the stage or label. 1 = first, 2 = second, etc.',
		@@ -47,8 +47,10 @@
47	47	`last_completed_at` TIMESTAMP NULL,
48	48	`archived_at` TIMESTAMP NULL,
49	49	`created_at` TIMESTAMP NULL,
50	50	`updated_at` TIMESTAMP NULL,
	51	+ KEY `fbs_stage_id` (`stage_id`),
	52	+ KEY `fbs_parent_id` (`parent_id`),
51	53	KEY `type` (`type`),
52	54	KEY `board_id` (`board_id`),
53	55	KEY `slug` (`slug`),
54	56	KEY `comments_count` (`comments_count`),