File manager

File manager - Edit - /home/wwwroot/camplus.hk/clst.camplus.hk/public_html/install/db/ap_deprecated.sql

Back
-- phpMyAdmin SQL Dump -- version 4.7.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Apr 02, 2018 at 06:12 PM -- Server version: 10.1.30-MariaDB -- PHP Version: 7.0.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 /; -- -- Database: `camplus2` -- -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_answers` -- CREATE TABLE `ap_deprecated_answers` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `submitted_by` int(11) NOT NULL, `is_overall_appraisal` int(11) NOT NULL, `is_unit` int(11) NOT NULL, `answer` mediumtext COLLATE utf8_unicode_ci NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_answer_has_grid` -- CREATE TABLE `ap_deprecated_answer_has_grid` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `submitted_by` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question_of_question_id` int(11) NOT NULL, `answer` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `remark` mediumtext COLLATE utf8_unicode_ci NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_answer_has_table` -- CREATE TABLE `ap_deprecated_answer_has_table` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `submitted_by` int(11) NOT NULL, `question_id` int(11) NOT NULL, `answer` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap` -- CREATE TABLE `ap_deprecated_overall_ap` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `template_id` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap_qtns` -- CREATE TABLE `ap_deprecated_overall_ap_qtns` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appraisal_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('SINGLE_LINE','MULTIPLE_LINE','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `self` tinyint(4) NOT NULL, `roles` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap_qtn_options` -- CREATE TABLE `ap_deprecated_overall_ap_qtn_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap_qtn_sub_qtns` -- CREATE TABLE `ap_deprecated_overall_ap_qtn_sub_qtns` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap_workflow` -- CREATE TABLE `ap_deprecated_overall_ap_workflow` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `cat_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `workflow` mediumtext COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_qtns` -- CREATE TABLE `ap_deprecated_qtns` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `template_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('SINGLE_LINE','MULTIPLE_LINE','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_qtn_options` -- CREATE TABLE `ap_deprecated_qtn_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_qtn_sub_qtns` -- CREATE TABLE `ap_deprecated_qtn_sub_qtns` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_roles` -- CREATE TABLE `ap_deprecated_roles` ( `id` int(11) NOT NULL, `role` text COLLATE utf8_unicode_ci NOT NULL, `is_approval_role` tinyint(1) NOT NULL, `academic_year_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_sections` -- CREATE TABLE `ap_deprecated_sections` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `academic_year_id` int(11) NOT NULL, `is_head_can_view` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_head_can_fill` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_member_can_view` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_member_can_fill` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `roles_can_view` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `roles_can_fill` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `from_date` date NOT NULL, `to_date` date NOT NULL, `template_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_sections_status` -- CREATE TABLE `ap_deprecated_sections_status` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_section_qtns` -- CREATE TABLE `ap_deprecated_section_qtns` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `section_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('','SINGLE_LINE','MULTIPLE_LINE','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `special_question` enum('','UNIT','OVERALL_APPRAISAL','USER_DATA') COLLATE utf8_unicode_ci NOT NULL, `type` enum('','SELF','HEAD') COLLATE utf8_unicode_ci NOT NULL, `overall_appraisal_user_id` int(11) NOT NULL, `rank` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_section_qtn_options` -- CREATE TABLE `ap_deprecated_section_qtn_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_section_qtn_sub_qtns` -- CREATE TABLE `ap_deprecated_section_qtn_sub_qtns` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_settings` -- CREATE TABLE `ap_deprecated_settings` ( `id` int(11) NOT NULL, `key` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_templates` -- CREATE TABLE `ap_deprecated_templates` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_units` -- CREATE TABLE `ap_deprecated_units` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` mediumtext COLLATE utf8_unicode_ci NOT NULL, `academic_year_id` int(11) NOT NULL, `category` int(11) NOT NULL, `template_id` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_ap_heads` -- CREATE TABLE `ap_deprecated_unit_ap_heads` ( `id` int(11) NOT NULL, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_categories` -- CREATE TABLE `ap_deprecated_unit_categories` ( `id` int(11) NOT NULL, `category` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_heads` -- CREATE TABLE `ap_deprecated_unit_heads` ( `id` int(11) NOT NULL, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_members` -- CREATE TABLE `ap_deprecated_unit_members` ( `id` int(11) NOT NULL, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_qtns` -- CREATE TABLE `ap_deprecated_unit_qtns` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `unit_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('SINGLE_LINE','MULTIPLE_LINE','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `self` tinyint(4) NOT NULL, `head` tinyint(4) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_qtn_options` -- CREATE TABLE `ap_deprecated_unit_qtn_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_qtn_sub_qtns` -- CREATE TABLE `ap_deprecated_unit_qtn_sub_qtns` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_users_roles` -- CREATE TABLE `ap_deprecated_users_roles` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `role_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_user_has_educations` -- CREATE TABLE `ap_deprecated_user_has_educations` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `qualification` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `certificate` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `major` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `minor` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `institute` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `award_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `ap_deprecated_answers` -- ALTER TABLE `ap_deprecated_answers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_answer_has_grid` -- ALTER TABLE `ap_deprecated_answer_has_grid` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_answer_has_table` -- ALTER TABLE `ap_deprecated_answer_has_table` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap` -- ALTER TABLE `ap_deprecated_overall_ap` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap_qtns` -- ALTER TABLE `ap_deprecated_overall_ap_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap_qtn_options` -- ALTER TABLE `ap_deprecated_overall_ap_qtn_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_overall_ap_qtn_sub_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap_workflow` -- ALTER TABLE `ap_deprecated_overall_ap_workflow` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_qtns` -- ALTER TABLE `ap_deprecated_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_qtn_options` -- ALTER TABLE `ap_deprecated_qtn_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_qtn_sub_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_roles` -- ALTER TABLE `ap_deprecated_roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_sections` -- ALTER TABLE `ap_deprecated_sections` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_sections_status` -- ALTER TABLE `ap_deprecated_sections_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_section_qtns` -- ALTER TABLE `ap_deprecated_section_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_section_qtn_options` -- ALTER TABLE `ap_deprecated_section_qtn_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_section_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_section_qtn_sub_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_settings` -- ALTER TABLE `ap_deprecated_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_templates` -- ALTER TABLE `ap_deprecated_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_units` -- ALTER TABLE `ap_deprecated_units` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_ap_heads` -- ALTER TABLE `ap_deprecated_unit_ap_heads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_categories` -- ALTER TABLE `ap_deprecated_unit_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_heads` -- ALTER TABLE `ap_deprecated_unit_heads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_members` -- ALTER TABLE `ap_deprecated_unit_members` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_qtns` -- ALTER TABLE `ap_deprecated_unit_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_qtn_options` -- ALTER TABLE `ap_deprecated_unit_qtn_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_unit_qtn_sub_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_users_roles` -- ALTER TABLE `ap_deprecated_users_roles` ADD PRIMARY KEY (`id`), ADD KEY `role_id_idx` (`role_id`), ADD KEY `user_id_idx` (`user_id`); -- -- Indexes for table `ap_deprecated_user_has_educations` -- ALTER TABLE `ap_deprecated_user_has_educations` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `ap_deprecated_answers` -- ALTER TABLE `ap_deprecated_answers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_answer_has_grid` -- ALTER TABLE `ap_deprecated_answer_has_grid` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_answer_has_table` -- ALTER TABLE `ap_deprecated_answer_has_table` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap` -- ALTER TABLE `ap_deprecated_overall_ap` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap_qtns` -- ALTER TABLE `ap_deprecated_overall_ap_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap_qtn_options` -- ALTER TABLE `ap_deprecated_overall_ap_qtn_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_overall_ap_qtn_sub_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap_workflow` -- ALTER TABLE `ap_deprecated_overall_ap_workflow` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_qtns` -- ALTER TABLE `ap_deprecated_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_qtn_options` -- ALTER TABLE `ap_deprecated_qtn_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_qtn_sub_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_roles` -- ALTER TABLE `ap_deprecated_roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_sections` -- ALTER TABLE `ap_deprecated_sections` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_sections_status` -- ALTER TABLE `ap_deprecated_sections_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_section_qtns` -- ALTER TABLE `ap_deprecated_section_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_section_qtn_options` -- ALTER TABLE `ap_deprecated_section_qtn_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_section_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_section_qtn_sub_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_settings` -- ALTER TABLE `ap_deprecated_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_templates` -- ALTER TABLE `ap_deprecated_templates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_units` -- ALTER TABLE `ap_deprecated_units` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_ap_heads` -- ALTER TABLE `ap_deprecated_unit_ap_heads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_categories` -- ALTER TABLE `ap_deprecated_unit_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_heads` -- ALTER TABLE `ap_deprecated_unit_heads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_members` -- ALTER TABLE `ap_deprecated_unit_members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_qtns` -- ALTER TABLE `ap_deprecated_unit_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_qtn_options` -- ALTER TABLE `ap_deprecated_unit_qtn_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_unit_qtn_sub_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_users_roles` -- ALTER TABLE `ap_deprecated_users_roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_user_has_educations` -- ALTER TABLE `ap_deprecated_user_has_educations` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;

| ver. 1.4 | Github | . | PHP 7.2.34 | Generation time: 0.53 | proxy | phpinfo | Settings