migrations/Version20230911115849.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Migration 3 - create board, form related tables
  12.  */
  13. final class Version20230911115849 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql("CREATE TABLE IF NOT EXISTS `invite_user` (
  23.                           `id` int(11) NOT NULL AUTO_INCREMENT,
  24.                           `company_id` int(11) DEFAULT NULL,
  25.                           `reference_id` varchar(255) DEFAULT NULL,
  26.                           `role_id` int(11) DEFAULT NULL,
  27.                           `email_id` varchar(255) DEFAULT NULL,
  28.                           `link_type` enum('copy_link','mail_link') DEFAULT NULL,
  29.                           `is_active` tinyint(1) NOT NULL DEFAULT 1,
  30.                           `generated_at` timestamp NULL DEFAULT NULL,
  31.                           `generated_by` int(11) DEFAULT NULL,
  32.                           `deactivated_at` timestamp NULL DEFAULT NULL,
  33.                           `deactivated_by` int(11) DEFAULT NULL,
  34.                           PRIMARY KEY (`id`),
  35.                           KEY `company_id` (`company_id`),
  36.                           KEY `generated_by` (`generated_by`),
  37.                           KEY `deactivated_by` (`deactivated_by`),
  38.                           KEY `role_id` (`role_id`),
  39.                           CONSTRAINT `invite_user_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  40.                           CONSTRAINT `invite_user_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `tc_user_type` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  41.                         ) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT;");
  42.         
  43.         
  44.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_theme` (
  45.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  46.                         `label` varchar(255) NOT NULL,
  47.                         `custom_css_json` mediumtext DEFAULT NULL,
  48.                         `created_at` datetime NOT NULL,
  49.                         `updated_at` datetime DEFAULT NULL,
  50.                         `created_by` int(11) NOT NULL,
  51.                         `updated_by` int(11) DEFAULT NULL,
  52.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  53.                         `deleted_at` datetime DEFAULT NULL,
  54.                         `deleted_by` int(11) DEFAULT NULL,
  55.                         PRIMARY KEY (`id`),
  56.                         KEY `created_by` (`created_by`),
  57.                         KEY `updated_by` (`updated_by`),
  58.                         KEY `deleted_by` (`deleted_by`),
  59.                         CONSTRAINT `tc_theme_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  60.                         CONSTRAINT `tc_theme_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  61.                         CONSTRAINT `tc_theme_ibfk_3` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  62.                       ) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  63.         
  64.         $this->addSql("CREATE TABLE IF NOT EXISTS `tc_forms` (
  65.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  66.                         `company_id` int(11) NOT NULL,
  67.                         `form_label` varchar(255) NOT NULL,
  68.                         `form_type` enum('card_layout','user_form') NOT NULL DEFAULT 'card_layout',
  69.                         `card_title_label` varchar(255) DEFAULT NULL,
  70.                         `is_default` tinyint(1) NOT NULL DEFAULT 0,
  71.                         `has_multiple_section` tinyint(1) NOT NULL DEFAULT 0,
  72.                         `has_card_timer` tinyint(1) NOT NULL DEFAULT 0,
  73.                         `form_view` enum('tab_view','single_form_view') NOT NULL DEFAULT 'single_form_view',
  74.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  75.                         `created_by` int(11) NOT NULL,
  76.                         `created_at` datetime NOT NULL,
  77.                         `updated_by` int(11) DEFAULT NULL,
  78.                         `updated_at` datetime DEFAULT NULL,
  79.                         `deleted_by` int(11) DEFAULT NULL,
  80.                         `deleted_at` datetime DEFAULT NULL,
  81.                         PRIMARY KEY (`id`),
  82.                         KEY `created_by` (`created_by`),
  83.                         KEY `updated_by` (`updated_by`),
  84.                         KEY `deleted_by` (`deleted_by`),
  85.                         KEY `company_id` (`company_id`),
  86.                         CONSTRAINT `tc_forms_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  87.                         CONSTRAINT `tc_forms_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  88.                         CONSTRAINT `tc_forms_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  89.                         CONSTRAINT `tc_forms_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
  90.                       ) ENGINE=InnoDB AUTO_INCREMENT=493 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;");
  91.         
  92.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_form_section` (
  93.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  94.                         `form_id` int(11) NOT NULL,
  95.                         `section_label` varchar(255) NOT NULL,
  96.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  97.                         `created_by` int(11) NOT NULL,
  98.                         `created_at` datetime NOT NULL,
  99.                         `updated_by` int(11) DEFAULT NULL,
  100.                         `updated_at` datetime DEFAULT NULL,
  101.                         `deleted_by` int(11) DEFAULT NULL,
  102.                         `deleted_at` datetime DEFAULT NULL,
  103.                         PRIMARY KEY (`id`),
  104.                         KEY `form_id` (`form_id`),
  105.                         KEY `created_by` (`created_by`),
  106.                         KEY `updated_by` (`updated_by`),
  107.                         KEY `deleted_by` (`deleted_by`),
  108.                         CONSTRAINT `tc_form_section_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  109.                         CONSTRAINT `tc_form_section_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`),
  110.                         CONSTRAINT `tc_form_section_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`),
  111.                         CONSTRAINT `tc_form_section_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`)
  112.                       ) ENGINE=InnoDB AUTO_INCREMENT=448 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;');
  113.         
  114.         $this->addSql("CREATE TABLE `tc_form_field` (
  115.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  116.                         `form_id` int(11) NOT NULL,
  117.                         `section_id` int(11) NOT NULL,
  118.                         `parent_field_id` int(11) DEFAULT NULL,
  119.                         `field_label` varchar(255) NOT NULL,
  120.                         `field_type` enum('input','number','float','text','mediumtext','longtext','select','multi_select','checkbox','radio','date','time','datetime','normaltext','label','varchar','colour','file','email','image','user_field','table','image_icon','slider') NOT NULL DEFAULT 'normaltext',
  121.                         `sort_order` int(11) DEFAULT NULL,
  122.                         `defualt_value` varchar(255) DEFAULT NULL,
  123.                         `options` longtext DEFAULT NULL,
  124.                         `validation_rules` mediumtext DEFAULT NULL,
  125.                         `field_options` longtext DEFAULT NULL,
  126.                         `is_hidden` tinyint(1) NOT NULL DEFAULT 0,
  127.                         `has_total` tinyint(1) NOT NULL DEFAULT 0,
  128.                         `is_disabled` tinyint(1) NOT NULL DEFAULT 0,
  129.                         `is_multiselect` tinyint(1) NOT NULL DEFAULT 0,
  130.                         `is_calendar_start_date` tinyint(1) NOT NULL DEFAULT 0,
  131.                         `all_user_option` enum('all_user','all_user_from_group','custom') DEFAULT NULL,
  132.                         `all_user_selected_groups` text DEFAULT NULL,
  133.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  134.                         `created_by` int(11) NOT NULL,
  135.                         `created_at` datetime NOT NULL,
  136.                         `updated_by` int(11) DEFAULT NULL,
  137.                         `updated_at` datetime DEFAULT NULL,
  138.                         `deleted_by` int(11) DEFAULT NULL,
  139.                         `deleted_at` datetime DEFAULT NULL,
  140.                         PRIMARY KEY (`id`),
  141.                         KEY `form_id` (`form_id`),
  142.                         KEY `section_id` (`section_id`),
  143.                         KEY `created_by` (`created_by`),
  144.                         KEY `updated_by` (`updated_by`),
  145.                         KEY `deleted_by` (`deleted_by`),
  146.                         KEY `form_id_2` (`form_id`),
  147.                         KEY `section_id_2` (`section_id`),
  148.                         KEY `deleted_by_2` (`deleted_by`),
  149.                         KEY `updated_by_2` (`updated_by`),
  150.                         KEY `created_by_2` (`created_by`),
  151.                         CONSTRAINT `tc_form_field_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  152.                         CONSTRAINT `tc_form_field_ibfk_2` FOREIGN KEY (`section_id`) REFERENCES `tc_form_section` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  153.                         CONSTRAINT `tc_form_field_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`),
  154.                         CONSTRAINT `tc_form_field_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`),
  155.                         CONSTRAINT `tc_form_field_ibfk_7` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`)
  156.                        ) ENGINE=InnoDB AUTO_INCREMENT=3197 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;");
  157.         
  158.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_form_field_options` (
  159.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  160.                         `form_id` int(11) NOT NULL,
  161.                         `field_id` int(11) NOT NULL,
  162.                         `field_option` varchar(255) NOT NULL,
  163.                         `color_code` varchar(255) DEFAULT NULL,
  164.                         `image_icon` varchar(255) DEFAULT NULL,
  165.                         `is_default` tinyint(1) NOT NULL DEFAULT 0,
  166.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  167.                         `deleted_by` int(11) DEFAULT NULL,
  168.                         `deleted_at` datetime DEFAULT NULL,
  169.                         `updated_by` int(11) DEFAULT NULL,
  170.                         `updated_at` datetime DEFAULT NULL,
  171.                         `created_by` int(11) DEFAULT NULL,
  172.                         `created_at` datetime DEFAULT NULL,
  173.                         PRIMARY KEY (`id`),
  174.                         KEY `form_id` (`form_id`),
  175.                         KEY `field_id` (`field_id`),
  176.                         KEY `updated_by` (`updated_by`),
  177.                         KEY `created_by` (`created_by`),
  178.                         KEY `deleted_by` (`deleted_by`),
  179.                         CONSTRAINT `tc_form_field_options_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  180.                         CONSTRAINT `tc_form_field_options_ibfk_2` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`),
  181.                         CONSTRAINT `tc_form_field_options_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`),
  182.                         CONSTRAINT `tc_form_field_options_ibfk_4` FOREIGN KEY (`field_id`) REFERENCES `tc_form_field` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  183.                         CONSTRAINT `tc_form_field_options_ibfk_5` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`)
  184.                       ) ENGINE=InnoDB AUTO_INCREMENT=3348 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  185.         
  186.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_form_field_users` (
  187.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  188.                         `form_id` int(11) NOT NULL,
  189.                         `field_id` int(11) NOT NULL,
  190.                         `user_id` int(11) NOT NULL,
  191.                         PRIMARY KEY (`id`),
  192.                         KEY `form_id` (`form_id`),
  193.                         KEY `field_id` (`field_id`),
  194.                         KEY `user_id` (`user_id`),
  195.                         CONSTRAINT `tc_form_field_users_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  196.                         CONSTRAINT `tc_form_field_users_ibfk_2` FOREIGN KEY (`field_id`) REFERENCES `tc_form_field` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  197.                         CONSTRAINT `tc_form_field_users_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  198.                       ) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  199.         
  200.         
  201.         
  202.         $this->addSql("CREATE TABLE IF NOT EXISTS `tc_board` (
  203.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  204.                         `company_id` int(11) NOT NULL,
  205.                         `board_title` varchar(255) NOT NULL,
  206.                         `board_type` enum('kanban_board','calendar') NOT NULL DEFAULT 'kanban_board',
  207.                         `board_identifier` varchar(255) NOT NULL,
  208.                         `form_id` int(11) DEFAULT NULL,
  209.                         `theme_id` int(11) DEFAULT NULL,
  210.                         `default_card_layout_id` int(11) DEFAULT NULL,
  211.                         `is_active` tinyint(1) NOT NULL DEFAULT 1,
  212.                         `is_default` tinyint(1) DEFAULT 0,
  213.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  214.                         `created_by` int(11) DEFAULT NULL,
  215.                         `created_at` datetime DEFAULT NULL,
  216.                         `updated_by` int(11) DEFAULT NULL,
  217.                         `updated_at` datetime DEFAULT NULL,
  218.                         `deleted_by` int(11) DEFAULT NULL,
  219.                         `deleted_at` datetime DEFAULT NULL,
  220.                         PRIMARY KEY (`id`),
  221.                         KEY `company_id` (`company_id`),
  222.                         KEY `form_id` (`form_id`),
  223.                         KEY `updated_by` (`updated_by`),
  224.                         KEY `deleted_by` (`deleted_by`),
  225.                         KEY `created_by` (`created_by`),
  226.                         KEY `theme_id` (`theme_id`),
  227.                         CONSTRAINT `tc_board_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  228.                         CONSTRAINT `tc_board_ibfk_2` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  229.                         CONSTRAINT `tc_board_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`),
  230.                         CONSTRAINT `tc_board_ibfk_4` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`),
  231.                         CONSTRAINT `tc_board_ibfk_5` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`),
  232.                         CONSTRAINT `tc_board_ibfk_6` FOREIGN KEY (`theme_id`) REFERENCES `tc_theme` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  233.                       ) ENGINE=InnoDB AUTO_INCREMENT=362 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='e.g. card, cash, paypal, wire transfer';");
  234.         
  235.         
  236.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_board_columns` (
  237.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  238.                         `board_id` int(11) NOT NULL,
  239.                         `label` varchar(255) NOT NULL,
  240.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  241.                         `sort_order` int(11) DEFAULT NULL,
  242.                         `is_default` tinyint(1) NOT NULL DEFAULT 0,
  243.                         `created_by` int(11) NOT NULL,
  244.                         `created_at` datetime NOT NULL,
  245.                         `updated_by` int(11) DEFAULT NULL,
  246.                         `updated_at` datetime DEFAULT NULL,
  247.                         `deleted_by` int(11) DEFAULT NULL,
  248.                         `deleted_at` datetime DEFAULT NULL,
  249.                         PRIMARY KEY (`id`),
  250.                         KEY `board_id` (`board_id`),
  251.                         KEY `created_by` (`created_by`),
  252.                         KEY `updated_by` (`updated_by`),
  253.                         KEY `deleted_by` (`deleted_by`),
  254.                         CONSTRAINT `tc_board_columns_ibfk_1` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  255.                         CONSTRAINT `tc_board_columns_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`),
  256.                         CONSTRAINT `tc_board_columns_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`),
  257.                         CONSTRAINT `tc_board_columns_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`)
  258.                       ) ENGINE=InnoDB AUTO_INCREMENT=2224 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;');
  259.         
  260.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_board_forms` (
  261.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  262.                         `company_id` int(11) NOT NULL,
  263.                         `board_id` int(11) NOT NULL,
  264.                         `form_id` int(11) NOT NULL,
  265.                         `is_default` tinyint(4) NOT NULL DEFAULT 0,
  266.                         `assigned_at` datetime NOT NULL,
  267.                         `assigned_by` int(11) NOT NULL,
  268.                         PRIMARY KEY (`id`),
  269.                         KEY `company_id` (`company_id`),
  270.                         KEY `board_id` (`board_id`),
  271.                         KEY `form_id` (`form_id`),
  272.                         KEY `assigned_by` (`assigned_by`),
  273.                         CONSTRAINT `tc_board_forms_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  274.                         CONSTRAINT `tc_board_forms_ibfk_2` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  275.                         CONSTRAINT `tc_board_forms_ibfk_3` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  276.                         CONSTRAINT `tc_board_forms_ibfk_4` FOREIGN KEY (`assigned_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  277.                       ) ENGINE=InnoDB AUTO_INCREMENT=518 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  278.         
  279.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_board_rows` (
  280.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  281.                         `board_id` int(11) NOT NULL,
  282.                         `label` varchar(255) DEFAULT NULL,
  283.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  284.                         `sort_order` int(11) DEFAULT NULL,
  285.                         `is_default` tinyint(1) NOT NULL DEFAULT 0,
  286.                         `created_by` int(11) NOT NULL,
  287.                         `created_at` datetime NOT NULL,
  288.                         `updated_by` int(11) DEFAULT NULL,
  289.                         `updated_at` datetime DEFAULT NULL,
  290.                         `deleted_by` int(11) DEFAULT NULL,
  291.                         `deleted_at` datetime DEFAULT NULL,
  292.                         PRIMARY KEY (`id`),
  293.                         KEY `board_id` (`board_id`),
  294.                         KEY `created_by` (`created_by`),
  295.                         KEY `updated_by` (`updated_by`),
  296.                         KEY `deleted_by` (`deleted_by`),
  297.                         CONSTRAINT `tc_board_rows_ibfk_1` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  298.                         CONSTRAINT `tc_board_rows_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`),
  299.                         CONSTRAINT `tc_board_rows_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`),
  300.                         CONSTRAINT `tc_board_rows_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`)
  301.                       ) ENGINE=InnoDB AUTO_INCREMENT=1998 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;');
  302.         
  303.         $this->addSql("CREATE TABLE IF NOT EXISTS `tc_board_settings` (
  304.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  305.                         `lock_board` enum('0','1') NOT NULL DEFAULT '0',
  306.                         `card_layout_id` int(11) NOT NULL DEFAULT 1,
  307.                         `card_design_id` int(11) NOT NULL DEFAULT 1,
  308.                         `draggable` enum('0','1') NOT NULL DEFAULT '0',
  309.                         `column_width` varchar(255) DEFAULT NULL,
  310.                         `column_gap` varchar(255) DEFAULT NULL,
  311.                         `row_width` varchar(255) DEFAULT NULL,
  312.                         `row_gap` varchar(255) DEFAULT NULL,
  313.                         `has_multiple_rows` tinyint(1) NOT NULL DEFAULT 0,
  314.                         `card_title` varchar(255) DEFAULT NULL,
  315.                         `card_spacing` varchar(255) DEFAULT NULL,
  316.                         `card_outer_spacing` varchar(255) DEFAULT NULL,
  317.                         `card_gap` varchar(255) DEFAULT NULL,
  318.                         `card_title_field_label` varchar(255) DEFAULT NULL,
  319.                         `column_field_label` varchar(255) DEFAULT NULL,
  320.                         `row_field_label` varchar(255) DEFAULT NULL,
  321.                         `board_bg_color` varchar(255) DEFAULT NULL,
  322.                         `card_bg_default_color` varchar(255) DEFAULT NULL,
  323.                         `row_header_bg_color` varchar(255) DEFAULT NULL,
  324.                         `column_header_bg_color` varchar(255) DEFAULT NULL,
  325.                         `board_id` int(11) DEFAULT NULL,
  326.                         `show_card_header_only` tinyint(1) NOT NULL DEFAULT 0,
  327.                         `system_theme` varchar(255) DEFAULT NULL,
  328.                         `board_type` varchar(255) DEFAULT NULL,
  329.                         `card_fields_json` text DEFAULT NULL,
  330.                         `created_by` int(11) NOT NULL,
  331.                         `created_at` datetime NOT NULL,
  332.                         `updated_by` int(11) DEFAULT NULL,
  333.                         `updated_at` datetime DEFAULT NULL,
  334.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  335.                         `deleted_by` int(11) DEFAULT NULL,
  336.                         PRIMARY KEY (`id`),
  337.                         KEY `board_id` (`board_id`),
  338.                         KEY `created_by` (`created_by`),
  339.                         KEY `updated_by` (`updated_by`),
  340.                         KEY `deleted_by` (`deleted_by`),
  341.                         CONSTRAINT `tc_board_settings_ibfk_2` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`),
  342.                         CONSTRAINT `tc_board_settings_ibfk_3` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  343.                         CONSTRAINT `tc_board_settings_ibfk_4` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`),
  344.                         CONSTRAINT `tc_board_settings_ibfk_5` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`)
  345.                       ) ENGINE=InnoDB AUTO_INCREMENT=303 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;");
  346.         
  347.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_board_cards` (
  348.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  349.                         `company_id` int(11) DEFAULT NULL,
  350.                         `card_name` varchar(255) DEFAULT NULL,
  351.                         `ref_id` int(11) DEFAULT NULL,
  352.                         `board_id` int(11) NOT NULL,
  353.                         `form_id` int(11) DEFAULT NULL,
  354.                         `column_id` int(11) NOT NULL,
  355.                         `row_id` int(11) NOT NULL,
  356.                         `is_full_capacity` tinyint(1) NOT NULL DEFAULT 0,
  357.                         `active_section_id` int(11) DEFAULT NULL,
  358.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  359.                         `is_draft` tinyint(1) NOT NULL DEFAULT 0,
  360.                         `created_by` int(11) NOT NULL,
  361.                         `created_at` datetime NOT NULL,
  362.                         `updated_by` int(11) DEFAULT NULL,
  363.                         `updated_at` datetime DEFAULT NULL,
  364.                         `deleted_by` int(11) DEFAULT NULL,
  365.                         `deleted_at` datetime DEFAULT NULL,
  366.                         PRIMARY KEY (`id`),
  367.                         KEY `company_id` (`company_id`),
  368.                         KEY `board_id` (`board_id`),
  369.                         KEY `column_id` (`column_id`),
  370.                         KEY `row_id` (`row_id`),
  371.                         KEY `created_by` (`created_by`),
  372.                         KEY `updated_by` (`updated_by`),
  373.                         KEY `deleted_by` (`deleted_by`),
  374.                         KEY `form_id` (`form_id`),
  375.                         CONSTRAINT `tc_board_cards_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  376.                         CONSTRAINT `tc_board_cards_ibfk_2` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  377.                         CONSTRAINT `tc_board_cards_ibfk_3` FOREIGN KEY (`column_id`) REFERENCES `tc_board_columns` (`id`),
  378.                         CONSTRAINT `tc_board_cards_ibfk_4` FOREIGN KEY (`row_id`) REFERENCES `tc_board_rows` (`id`),
  379.                         CONSTRAINT `tc_board_cards_ibfk_5` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`),
  380.                         CONSTRAINT `tc_board_cards_ibfk_6` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`),
  381.                         CONSTRAINT `tc_board_cards_ibfk_7` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`),
  382.                         CONSTRAINT `tc_board_cards_ibfk_8` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  383.                       ) ENGINE=InnoDB AUTO_INCREMENT=7415 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;');
  384.         
  385.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_custom_form_file_upload_values` (
  386.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  387.                         `board_id` int(11) NOT NULL,
  388.                         `form_id` int(11) NOT NULL,
  389.                         `card_id` int(11) NOT NULL,
  390.                         `field_id` int(11) NOT NULL,
  391.                         `file_upload_id` int(11) NOT NULL,
  392.                         `assigned_by` int(11) NOT NULL,
  393.                         `assigned_at` datetime NOT NULL,
  394.                         PRIMARY KEY (`id`),
  395.                         KEY `form_id` (`form_id`),
  396.                         KEY `card_id` (`card_id`),
  397.                         KEY `field_id` (`field_id`),
  398.                         KEY `file_upload_id` (`file_upload_id`),
  399.                         KEY `assigned_by` (`assigned_by`),
  400.                         KEY `board_id` (`board_id`),
  401.                         CONSTRAINT `tc_custom_form_file_upload_values_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  402.                         CONSTRAINT `tc_custom_form_file_upload_values_ibfk_2` FOREIGN KEY (`card_id`) REFERENCES `tc_board_cards` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  403.                         CONSTRAINT `tc_custom_form_file_upload_values_ibfk_3` FOREIGN KEY (`field_id`) REFERENCES `tc_form_field` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  404.                         CONSTRAINT `tc_custom_form_file_upload_values_ibfk_4` FOREIGN KEY (`file_upload_id`) REFERENCES `tc_upload_files` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  405.                         CONSTRAINT `tc_custom_form_file_upload_values_ibfk_5` FOREIGN KEY (`assigned_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  406.                         CONSTRAINT `tc_custom_form_file_upload_values_ibfk_6` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  407.                       ) ENGINE=InnoDB AUTO_INCREMENT=315 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  408.         
  409.         $this->addSql('CREATE TABLE `tc_custom_form_multi_option_values` (
  410.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  411.                         `board_id` int(11) NOT NULL,
  412.                         `form_id` int(11) NOT NULL,
  413.                         `card_id` int(11) NOT NULL,
  414.                         `field_id` int(11) NOT NULL,
  415.                         `form_field_option_id` int(11) NOT NULL,
  416.                         `table_field_row_id` varchar(255) DEFAULT NULL,
  417.                         `assigned_by` int(11) NOT NULL,
  418.                         `assigned_at` datetime NOT NULL,
  419.                         PRIMARY KEY (`id`),
  420.                         KEY `form_id` (`form_id`),
  421.                         KEY `field_id` (`field_id`),
  422.                         KEY `form_field_option_id` (`form_field_option_id`),
  423.                         KEY `assigned_by` (`assigned_by`),
  424.                         KEY `card_id` (`card_id`),
  425.                         KEY `board_id` (`board_id`),
  426.                         CONSTRAINT `tc_custom_form_multi_option_values_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  427.                         CONSTRAINT `tc_custom_form_multi_option_values_ibfk_2` FOREIGN KEY (`field_id`) REFERENCES `tc_form_field` (`id`),
  428.                         CONSTRAINT `tc_custom_form_multi_option_values_ibfk_3` FOREIGN KEY (`form_field_option_id`) REFERENCES `tc_form_field_options` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  429.                         CONSTRAINT `tc_custom_form_multi_option_values_ibfk_4` FOREIGN KEY (`assigned_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  430.                         CONSTRAINT `tc_custom_form_multi_option_values_ibfk_5` FOREIGN KEY (`card_id`) REFERENCES `tc_board_cards` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  431.                         CONSTRAINT `tc_custom_form_multi_option_values_ibfk_6` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  432.                        ) ENGINE=InnoDB AUTO_INCREMENT=2263 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  433.         
  434.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_custom_form_user_field_values` (
  435.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  436.                         `board_id` int(11) NOT NULL,
  437.                         `form_id` int(11) NOT NULL,
  438.                         `card_id` int(11) NOT NULL,
  439.                         `field_id` int(11) NOT NULL,
  440.                         `user_id` int(11) NOT NULL,
  441.                         `assigned_by` int(11) NOT NULL,
  442.                         `assigned_at` datetime NOT NULL,
  443.                         PRIMARY KEY (`id`),
  444.                         KEY `form_id` (`form_id`),
  445.                         KEY `card_id` (`card_id`),
  446.                         KEY `field_id` (`field_id`),
  447.                         KEY `user_id` (`user_id`),
  448.                         KEY `assigned_by` (`assigned_by`),
  449.                         KEY `board_id` (`board_id`),
  450.                         CONSTRAINT `tc_custom_form_user_field_values_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  451.                         CONSTRAINT `tc_custom_form_user_field_values_ibfk_2` FOREIGN KEY (`card_id`) REFERENCES `tc_board_cards` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  452.                         CONSTRAINT `tc_custom_form_user_field_values_ibfk_3` FOREIGN KEY (`field_id`) REFERENCES `tc_form_field` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  453.                         CONSTRAINT `tc_custom_form_user_field_values_ibfk_4` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  454.                         CONSTRAINT `tc_custom_form_user_field_values_ibfk_5` FOREIGN KEY (`assigned_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  455.                         CONSTRAINT `tc_custom_form_user_field_values_ibfk_6` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  456.                       ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  457.         
  458.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_form_rule_builder` (
  459.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  460.                         `form_id` int(11) NOT NULL,
  461.                         `target_field_name` varchar(255) NOT NULL,
  462.                         `target_field_id` int(11) NOT NULL,
  463.                         `rules` text NOT NULL,
  464.                         `action_fields` text NOT NULL,
  465.                         `created_by` int(11) NOT NULL,
  466.                         `created_at` datetime NOT NULL,
  467.                         `updated_by` int(11) DEFAULT NULL,
  468.                         `updated_at` datetime DEFAULT NULL,
  469.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  470.                         `deleted_by` int(11) DEFAULT NULL,
  471.                         `deleted_at` datetime DEFAULT NULL,
  472.                         PRIMARY KEY (`id`),
  473.                         KEY `form_id` (`form_id`),
  474.                         KEY `created_by` (`created_by`),
  475.                         KEY `updated_by` (`updated_by`),
  476.                         KEY `deleted_by` (`deleted_by`),
  477.                         KEY `target_field_id` (`target_field_id`),
  478.                         CONSTRAINT `tc_form_rule_builder_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  479.                         CONSTRAINT `tc_form_rule_builder_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  480.                         CONSTRAINT `tc_form_rule_builder_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  481.                         CONSTRAINT `tc_form_rule_builder_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  482.                         CONSTRAINT `tc_form_rule_builder_ibfk_5` FOREIGN KEY (`target_field_id`) REFERENCES `tc_form_field` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  483.                       ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT;');
  484.         
  485.         
  486.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_form_selected_fields` (
  487.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  488.                         `form_id` int(11) NOT NULL,
  489.                         `board_id` int(11) DEFAULT NULL,
  490.                         `field_id` int(11) NOT NULL,
  491.                         `sort_order` int(11) NOT NULL,
  492.                         `assigned_at` datetime NOT NULL,
  493.                         `assigned_by` int(11) NOT NULL,
  494.                         PRIMARY KEY (`id`),
  495.                         KEY `form_id` (`form_id`),
  496.                         KEY `board_id` (`board_id`),
  497.                         KEY `field_id` (`field_id`),
  498.                         KEY `assigned_by` (`assigned_by`),
  499.                         CONSTRAINT `tc_form_selected_fields_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  500.                         CONSTRAINT `tc_form_selected_fields_ibfk_2` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  501.                         CONSTRAINT `tc_form_selected_fields_ibfk_3` FOREIGN KEY (`field_id`) REFERENCES `tc_form_field` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  502.                         CONSTRAINT `tc_form_selected_fields_ibfk_4` FOREIGN KEY (`assigned_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  503.                       ) ENGINE=InnoDB AUTO_INCREMENT=1490 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  504.         
  505.         
  506.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_board_user` (
  507.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  508.                         `board_id` int(11) NOT NULL,
  509.                         `user_id` int(11) NOT NULL,
  510.                         `created_by` int(11) NOT NULL,
  511.                         `created_at` datetime NOT NULL,
  512.                         PRIMARY KEY (`id`),
  513.                         KEY `board_id` (`board_id`),
  514.                         KEY `user_id` (`user_id`),
  515.                         KEY `created_by` (`created_by`),
  516.                         CONSTRAINT `tc_board_user_ibfk_1` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE,
  517.                         CONSTRAINT `tc_board_user_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  518.                         CONSTRAINT `tc_board_user_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE
  519.                       ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  520.         
  521.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_card_activity_log` (
  522.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  523.                         `company_id` int(11) NOT NULL,
  524.                         `board_id` int(11) DEFAULT NULL,
  525.                         `form_id` int(11) DEFAULT NULL,
  526.                         `card_id` int(11) NOT NULL,
  527.                         `action` varchar(255) NOT NULL,
  528.                         `from_data` mediumtext DEFAULT NULL,
  529.                         `to_data` mediumtext DEFAULT NULL,
  530.                         `done_at` datetime NOT NULL,
  531.                         `done_by` int(11) NOT NULL,
  532.                         PRIMARY KEY (`id`),
  533.                         KEY `company_id` (`company_id`),
  534.                         KEY `done_by` (`done_by`),
  535.                         KEY `board_id` (`board_id`),
  536.                         KEY `form_id` (`form_id`),
  537.                         KEY `card_id` (`card_id`) USING BTREE,
  538.                         CONSTRAINT `tc_card_activity_log_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  539.                         CONSTRAINT `tc_card_activity_log_ibfk_2` FOREIGN KEY (`card_id`) REFERENCES `tc_board_cards` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  540.                         CONSTRAINT `tc_card_activity_log_ibfk_3` FOREIGN KEY (`done_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  541.                         CONSTRAINT `tc_card_activity_log_ibfk_4` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  542.                         CONSTRAINT `tc_card_activity_log_ibfk_5` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  543.                       ) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  544.         
  545.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_card_comments` (
  546.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  547.                         `card_id` int(11) NOT NULL,
  548.                         `board_id` int(11) NOT NULL,
  549.                         `company_id` int(11) NOT NULL,
  550.                         `comment` text NOT NULL,
  551.                         `comment_by` int(11) DEFAULT NULL,
  552.                         `comment_at` datetime DEFAULT NULL,
  553.                         `is_deleted` tinyint(1) DEFAULT 0,
  554.                         `deleted_by` int(11) DEFAULT NULL,
  555.                         `deleted_at` datetime DEFAULT NULL,
  556.                         PRIMARY KEY (`id`),
  557.                         KEY `card_id` (`card_id`),
  558.                         KEY `comment_by` (`comment_by`),
  559.                         KEY `deleted_by` (`deleted_by`),
  560.                         KEY `company_id` (`company_id`),
  561.                         KEY `board_id` (`board_id`),
  562.                         CONSTRAINT `tc_card_comments_ibfk_1` FOREIGN KEY (`card_id`) REFERENCES `tc_board_cards` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  563.                         CONSTRAINT `tc_card_comments_ibfk_2` FOREIGN KEY (`comment_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  564.                         CONSTRAINT `tc_card_comments_ibfk_3` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  565.                         CONSTRAINT `tc_card_comments_ibfk_4` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  566.                         CONSTRAINT `tc_card_comments_ibfk_5` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  567.                       ) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;');
  568.         
  569.         $this->addSql("CREATE TABLE IF NOT EXISTS `tc_card_timer_session` (
  570.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  571.                         `company_id` int(11) NOT NULL,
  572.                         `board_id` int(11) NOT NULL,
  573.                         `column_id` int(11) NOT NULL,
  574.                         `card_id` int(11) NOT NULL,
  575.                         `user_id` int(11) NOT NULL,
  576.                         `start_time` datetime NOT NULL,
  577.                         `end_time` datetime DEFAULT NULL,
  578.                         `action` enum('timer','move_card') NOT NULL DEFAULT 'timer',
  579.                         PRIMARY KEY (`id`),
  580.                         KEY `company_id` (`company_id`),
  581.                         KEY `card_id` (`card_id`),
  582.                         KEY `user_id` (`user_id`),
  583.                         KEY `board_id` (`board_id`),
  584.                         KEY `column_id` (`column_id`),
  585.                         CONSTRAINT `tc_card_timer_session_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  586.                         CONSTRAINT `tc_card_timer_session_ibfk_2` FOREIGN KEY (`card_id`) REFERENCES `tc_board_cards` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  587.                         CONSTRAINT `tc_card_timer_session_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  588.                         CONSTRAINT `tc_card_timer_session_ibfk_4` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  589.                         CONSTRAINT `tc_card_timer_session_ibfk_5` FOREIGN KEY (`column_id`) REFERENCES `tc_board_columns` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  590.                       ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;");
  591.         
  592.         $this->addSql("CREATE TABLE `tc_card_track_position` (
  593.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  594.                         `company_id` int(11) NOT NULL,
  595.                         `card_id` int(11) NOT NULL,
  596.                         `board_id` int(11) NOT NULL,
  597.                         `column_id` int(11) DEFAULT NULL,
  598.                         `row_id` int(11) DEFAULT NULL,
  599.                         `in_time` datetime NOT NULL,
  600.                         `in_action` enum('create','update','drag','transfer') DEFAULT NULL,
  601.                         `in_user` int(11) NOT NULL,
  602.                         `out_time` datetime DEFAULT NULL,
  603.                         `out_action` enum('create','update','drag','transfer') DEFAULT NULL,
  604.                         `out_user` int(11) DEFAULT NULL,
  605.                         PRIMARY KEY (`id`),
  606.                         KEY `company_id` (`company_id`),
  607.                         KEY `card_id` (`card_id`),
  608.                         KEY `board_id` (`board_id`),
  609.                         KEY `column_id` (`column_id`),
  610.                         KEY `row_id` (`row_id`),
  611.                         KEY `tc_card_timer_session_ibfk_6` (`in_user`),
  612.                         KEY `tc_card_timer_session_ibfk_7` (`out_user`),
  613.                         CONSTRAINT `tc_card_timer_session_ibfk_6` FOREIGN KEY (`in_user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  614.                         CONSTRAINT `tc_card_timer_session_ibfk_7` FOREIGN KEY (`out_user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  615.                         CONSTRAINT `tc_card_track_position_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  616.                         CONSTRAINT `tc_card_track_position_ibfk_2` FOREIGN KEY (`card_id`) REFERENCES `tc_board_cards` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  617.                         CONSTRAINT `tc_card_track_position_ibfk_3` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  618.                         CONSTRAINT `tc_card_track_position_ibfk_4` FOREIGN KEY (`column_id`) REFERENCES `tc_board_columns` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  619.                         CONSTRAINT `tc_card_track_position_ibfk_5` FOREIGN KEY (`row_id`) REFERENCES `tc_board_rows` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  620.                     ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;");
  621.         
  622.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_customer_feedback` (
  623.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  624.                         `tell_us_your_experiance` text NOT NULL,
  625.                         `suggestion_to_make_better` text DEFAULT NULL,
  626.                         `customer_rating` tinyint(4) NOT NULL,
  627.                         `upload_file_id` int(11) DEFAULT NULL,
  628.                         `submitted_by` int(11) NOT NULL,
  629.                         `submitted_at` datetime NOT NULL,
  630.                         PRIMARY KEY (`id`),
  631.                         KEY `upload_file_id` (`upload_file_id`),
  632.                         KEY `submitted_by` (`submitted_by`),
  633.                         CONSTRAINT `tc_customer_feedback_ibfk_1` FOREIGN KEY (`upload_file_id`) REFERENCES `tc_upload_files` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  634.                         CONSTRAINT `tc_customer_feedback_ibfk_2` FOREIGN KEY (`submitted_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  635.                       ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  636.         
  637.         
  638.         
  639.         
  640.         
  641.         $this->addSql("CREATE TABLE IF NOT EXISTS `tc_imports` (
  642.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  643.                         `company_id` int(11) NOT NULL,
  644.                         `uploaded_filename` varchar(255) NOT NULL,
  645.                         `file_name` varchar(255) NOT NULL,
  646.                         `file_type` varchar(255) DEFAULT NULL,
  647.                         `imported_at` datetime DEFAULT NULL,
  648.                         `imported_by` int(11) DEFAULT NULL,
  649.                         `import_status` enum('failed','success') DEFAULT NULL,
  650.                         `validation_status` enum('failed','success') DEFAULT NULL,
  651.                         `is_first_row_title` tinyint(1) NOT NULL DEFAULT 1,
  652.                         `title_row` tinyint(1) NOT NULL DEFAULT 1,
  653.                         `row_starts_from` int(11) DEFAULT NULL,
  654.                         `delete_as_junk` tinyint(1) NOT NULL DEFAULT 0,
  655.                         PRIMARY KEY (`id`),
  656.                         KEY `company_id` (`company_id`),
  657.                         KEY `imported_by` (`imported_by`),
  658.                         CONSTRAINT `tc_imports_ibfk_1` FOREIGN KEY (`imported_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  659.                       ) ENGINE=InnoDB AUTO_INCREMENT=444 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;");
  660.         
  661.         $this->addSql("CREATE TABLE IF NOT EXISTS `tc_report_generation` (
  662.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  663.                         `company_id` int(11) NOT NULL,
  664.                         `report_title` varchar(255) NOT NULL,
  665.                         `type` enum('table','chart') NOT NULL,
  666.                         `show_on_dashboard` tinyint(4) NOT NULL DEFAULT 0,
  667.                         `show_on_topnav` tinyint(4) NOT NULL DEFAULT 0,
  668.                         `has_filter` tinyint(4) NOT NULL DEFAULT 0,
  669.                         `has_search` tinyint(4) NOT NULL DEFAULT 0,
  670.                         `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  671.                         `created_by` int(11) NOT NULL,
  672.                         `created_at` datetime NOT NULL,
  673.                         `updated_by` int(11) DEFAULT NULL,
  674.                         `updated_at` int(11) DEFAULT NULL,
  675.                         `deleted_by` int(11) DEFAULT NULL,
  676.                         `deleted_at` int(11) DEFAULT NULL,
  677.                         PRIMARY KEY (`id`),
  678.                         KEY `created_by` (`created_by`),
  679.                         KEY `updated_by` (`updated_by`),
  680.                         KEY `deleted_by` (`deleted_by`),
  681.                         KEY `company_id` (`company_id`),
  682.                         CONSTRAINT `tc_report_generation_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  683.                         CONSTRAINT `tc_report_generation_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  684.                         CONSTRAINT `tc_report_generation_ibfk_3` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  685.                         CONSTRAINT `tc_report_generation_ibfk_4` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  686.                       ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;");
  687.         
  688.         $this->addSql("CREATE TABLE `tc_report_generation_form_fields` (
  689.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  690.                         `report_generation_id` int(11) NOT NULL,
  691.                         `form_id` int(11) NOT NULL,
  692.                         `field_type` enum('static','custom') NOT NULL DEFAULT 'custom',
  693.                         `static_field` varchar(255) DEFAULT NULL,
  694.                         `field_id` int(11) DEFAULT NULL,
  695.                         `sort_order` int(11) NOT NULL DEFAULT 1,
  696.                         `assigned_by` int(11) NOT NULL,
  697.                         `assigned_at` datetime NOT NULL,
  698.                         PRIMARY KEY (`id`),
  699.                         KEY `report_generation_id` (`report_generation_id`),
  700.                         KEY `form_id` (`form_id`),
  701.                         KEY `field_id` (`field_id`),
  702.                         KEY `assigned_by` (`assigned_by`),
  703.                         CONSTRAINT `tc_report_generation_form_fields_ibfk_1` FOREIGN KEY (`report_generation_id`) REFERENCES `tc_report_generation` (`id`) ON DELETE CASCADE,
  704.                         CONSTRAINT `tc_report_generation_form_fields_ibfk_2` FOREIGN KEY (`form_id`) REFERENCES `tc_forms` (`id`) ON DELETE CASCADE,
  705.                         CONSTRAINT `tc_report_generation_form_fields_ibfk_3` FOREIGN KEY (`field_id`) REFERENCES `tc_form_field` (`id`) ON DELETE CASCADE,
  706.                         CONSTRAINT `tc_report_generation_form_fields_ibfk_4` FOREIGN KEY (`assigned_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  707.                        ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci");
  708.         
  709.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_saved_filter` (
  710.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  711.                         `company_id` int(11) NOT NULL,
  712.                         `filter_name` varchar(255) NOT NULL,
  713.                         `filter_data` mediumtext NOT NULL,
  714.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  715.                         `create_at` datetime NOT NULL,
  716.                         `created_by` int(11) NOT NULL,
  717.                         `updated_at` datetime DEFAULT NULL,
  718.                         `updated_by` int(11) DEFAULT NULL,
  719.                         `deleted_at` datetime DEFAULT NULL,
  720.                         `deleted_by` int(11) DEFAULT NULL,
  721.                         PRIMARY KEY (`id`),
  722.                         KEY `company_id` (`company_id`),
  723.                         KEY `created_by` (`created_by`),
  724.                         KEY `updated_by` (`updated_by`),
  725.                         KEY `deleted_by` (`deleted_by`),
  726.                         CONSTRAINT `tc_saved_filter_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  727.                         CONSTRAINT `tc_saved_filter_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  728.                         CONSTRAINT `tc_saved_filter_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  729.                         CONSTRAINT `tc_saved_filter_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  730.                       ) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  731.         
  732.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_skills` (
  733.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  734.                         `company_id` int(11) NOT NULL,
  735.                         `skill_title` varchar(255) NOT NULL,
  736.                         `is_deleted` tinyint(1) NOT NULL,
  737.                         `created_by` int(11) NOT NULL,
  738.                         `created_at` datetime NOT NULL,
  739.                         `updated_by` int(11) DEFAULT NULL,
  740.                         `updated_at` datetime DEFAULT NULL,
  741.                         `deleted_by` int(11) DEFAULT NULL,
  742.                         `deleted_at` datetime DEFAULT NULL,
  743.                         PRIMARY KEY (`id`),
  744.                         KEY `company_id` (`company_id`),
  745.                         KEY `created_by` (`created_by`),
  746.                         KEY `updated_by` (`updated_by`),
  747.                         KEY `deleted_by` (`deleted_by`),
  748.                         CONSTRAINT `tc_skills_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  749.                         CONSTRAINT `tc_skills_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  750.                         CONSTRAINT `tc_skills_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  751.                         CONSTRAINT `tc_skills_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  752.                       ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  753.         
  754.         $this->addSql('CREATE TABLE `tc_board_skills` (
  755.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  756.                         `board_id` int(11) NOT NULL,
  757.                         `skill_id` int(11) NOT NULL,
  758.                         `assigned_by` int(11) NOT NULL,
  759.                         `assigned_at` datetime NOT NULL,
  760.                         PRIMARY KEY (`id`),
  761.                         KEY `board_id` (`board_id`),
  762.                         KEY `skill_id` (`skill_id`),
  763.                         KEY `assigned_by` (`assigned_by`),
  764.                         CONSTRAINT `tc_board_skills_ibfk_1` FOREIGN KEY (`board_id`) REFERENCES `tc_board` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  765.                         CONSTRAINT `tc_board_skills_ibfk_2` FOREIGN KEY (`skill_id`) REFERENCES `tc_skills` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  766.                         CONSTRAINT `tc_board_skills_ibfk_3` FOREIGN KEY (`assigned_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  767.                        ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  768.         
  769.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_skill_ratings` (
  770.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  771.                         `company_id` int(11) NOT NULL,
  772.                         `rating_label` varchar(255) NOT NULL,
  773.                         `color_code` varchar(255) NOT NULL,
  774.                         `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  775.                         `created_by` int(11) NOT NULL,
  776.                         `created_at` datetime NOT NULL,
  777.                         `updated_by` int(11) DEFAULT NULL,
  778.                         `updated_at` datetime DEFAULT NULL,
  779.                         `deleted_by` int(11) DEFAULT NULL,
  780.                         `deleted_at` datetime DEFAULT NULL,
  781.                         PRIMARY KEY (`id`),
  782.                         KEY `company_id` (`company_id`),
  783.                         KEY `created_by` (`created_by`),
  784.                         KEY `updated_by` (`updated_by`),
  785.                         KEY `deleted_by` (`deleted_by`),
  786.                         CONSTRAINT `tc_skill_ratings_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  787.                         CONSTRAINT `tc_skill_ratings_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  788.                         CONSTRAINT `tc_skill_ratings_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  789.                         CONSTRAINT `tc_skill_ratings_ibfk_4` FOREIGN KEY (`deleted_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  790.                       ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  791.         
  792.         
  793.         $this->addSql('CREATE TABLE IF NOT EXISTS `tc_user_activity_log` (
  794.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  795.                         `company_id` int(11) NOT NULL,
  796.                         `user_id` int(11) NOT NULL,
  797.                         `action` varchar(255) NOT NULL,
  798.                         `from_data` mediumtext NOT NULL,
  799.                         `to_data` mediumtext NOT NULL,
  800.                         `done_at` datetime NOT NULL,
  801.                         `done_by` int(11) NOT NULL,
  802.                         PRIMARY KEY (`id`),
  803.                         KEY `company_id` (`company_id`),
  804.                         KEY `user_id` (`user_id`),
  805.                         KEY `done_by` (`done_by`),
  806.                         CONSTRAINT `tc_user_activity_log_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  807.                         CONSTRAINT `tc_user_activity_log_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  808.                         CONSTRAINT `tc_user_activity_log_ibfk_3` FOREIGN KEY (`done_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  809.                       ) ENGINE=InnoDB AUTO_INCREMENT=420 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  810.         
  811.         $this->addSql('CREATE TABLE `tc_user_skills` (
  812.                         `id` int(11) NOT NULL AUTO_INCREMENT,
  813.                         `user_id` int(11) NOT NULL,
  814.                         `skill_id` int(11) NOT NULL,
  815.                         `rating_id` int(11) DEFAULT NULL,
  816.                         `assigned_by` int(11) NOT NULL,
  817.                         `assigned_at` datetime NOT NULL,
  818.                         PRIMARY KEY (`id`),
  819.                         KEY `user_id` (`user_id`),
  820.                         KEY `skill_id` (`skill_id`),
  821.                         KEY `assigned_by` (`assigned_by`),
  822.                         KEY `rating_id` (`rating_id`),
  823.                         CONSTRAINT `tc_user_skills_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  824.                         CONSTRAINT `tc_user_skills_ibfk_2` FOREIGN KEY (`skill_id`) REFERENCES `tc_skills` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  825.                         CONSTRAINT `tc_user_skills_ibfk_3` FOREIGN KEY (`assigned_by`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  826.                         CONSTRAINT `tc_user_skills_ibfk_4` FOREIGN KEY (`rating_id`) REFERENCES `tc_skill_ratings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  827.                        ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;');
  829.     }
  831.     public function down(Schema $schema): void
  832.     {
  833.         // Do not change this order
  834.         $this->addSql('DROP TABLE IF EXISTS `tc_user_activity_log`;');
  835.         $this->addSql('DROP TABLE IF EXISTS `tc_card_activity_log`;');
  836.         $this->addSql('DROP TABLE IF EXISTS `invite_user`;');
  837.         $this->addSql('DROP TABLE IF EXISTS `tc_form_selected_fields`;');
  838.         
  839.         $this->addSql('DROP TABLE IF EXISTS `tc_report_generation_form_fields`;');
  840.         $this->addSql('DROP TABLE IF EXISTS `tc_report_generation`;');
  841.         
  842.         $this->addSql('DROP TABLE IF EXISTS `tc_form_rule_builder`;');
  843.         $this->addSql('DROP TABLE IF EXISTS `tc_custom_form_file_upload_values`;');
  844.         $this->addSql('DROP TABLE IF EXISTS `tc_custom_form_multi_option_values`;');
  845.         $this->addSql('DROP TABLE IF EXISTS `tc_custom_form_user_field_values`;');
  846.         $this->addSql('DROP TABLE IF EXISTS `tc_form_field_options`;');
  847.         $this->addSql('DROP TABLE IF EXISTS `tc_form_field_users`;');
  848.         $this->addSql('DROP TABLE IF EXISTS `tc_form_field`;');
  849.         $this->addSql('DROP TABLE IF EXISTS `tc_form_section`;');
  851.          
  852.         $this->addSql('DROP TABLE IF EXISTS `tc_card_comments`;');
  853.         $this->addSql('DROP TABLE IF EXISTS `tc_card_timer_session`;');
  854.         $this->addSql('DROP TABLE IF EXISTS `tc_card_track_position`;');
  855.     
  856.         $this->addSql('DROP TABLE IF EXISTS `tc_board_cards`;');
  857.         $this->addSql('DROP TABLE IF EXISTS `tc_board_columns`;');
  858.         $this->addSql('DROP TABLE IF EXISTS `tc_board_forms`;');
  859.         $this->addSql('DROP TABLE IF EXISTS `tc_board_rows`;');
  860.         $this->addSql('DROP TABLE IF EXISTS `tc_board_settings`;');
  861.         $this->addSql('DROP TABLE IF EXISTS `tc_board_skills`;');
  862.         $this->addSql('DROP TABLE IF EXISTS `tc_board_user`;');
  863.         $this->addSql('DROP TABLE IF EXISTS `tc_board`;');
  864.         
  865.         $this->addSql('DROP TABLE IF EXISTS `tc_forms`;');
  866.         $this->addSql('DROP TABLE IF EXISTS `tc_customer_feedback`;');
  867.         $this->addSql('DROP TABLE IF EXISTS `tc_imports`;');
  868.         $this->addSql('DROP TABLE IF EXISTS `tc_saved_filter`;');
  869.         $this->addSql('DROP TABLE IF EXISTS `tc_user_skills`;');
  870.         $this->addSql('DROP TABLE IF EXISTS `tc_skill_ratings`;');
  871.         $this->addSql('DROP TABLE IF EXISTS `tc_skills`;');
  872.         $this->addSql('DROP TABLE IF EXISTS `tc_theme`;');
  874.     }
  875. }