File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/assets/global/scripts/911347/db.tar
Back
ap_deprecated.sql 0000775 00000056273 15060054561 0010071 0 ustar 00 -- 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 */; install.sql 0000775 00000311261 15060054561 0006746 0 ustar 00 -- phpMyAdmin SQL Dump -- version 4.7.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Apr 02, 2018 at 06:17 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 `academic_years` -- CREATE TABLE `academic_years` ( `id` int(11) NOT NULL, `year_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `year_start` date NOT NULL, `year_end` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ac_devices` -- CREATE TABLE `ac_devices` ( `id` int(11) NOT NULL, `devID` int(11) NOT NULL, `venue_id` int(11) NOT NULL, `state` int(11) NOT NULL, `lastUpdate` datetime NOT NULL, `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `receiver` int(11) NOT NULL, `ip` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ac_receiver` -- CREATE TABLE `ac_receiver` ( `id` int(11) NOT NULL, `dev_id` text NOT NULL, `ip` text NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `max_cardRecordID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `ac_record` -- CREATE TABLE `ac_record` ( `id` int(11) NOT NULL, `cardRecordID` int(11) NOT NULL, `card` text NOT NULL, `uid` int(11) NOT NULL, `username` text NOT NULL, `cardTime` datetime NOT NULL, `cardResult` int(11) NOT NULL, `devID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `ac_whitelist` -- CREATE TABLE `ac_whitelist` ( `id` int(11) NOT NULL, `card` int(11) NOT NULL, `dev_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `ap_answer` -- CREATE TABLE `ap_answer` ( `id` int(11) NOT NULL, `ff_id` int(11) NOT NULL, `a_key` text COLLATE utf8_unicode_ci NOT NULL, `answer` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_filled_form` -- CREATE TABLE `ap_filled_form` ( `id` int(11) NOT NULL, `form` int(11) NOT NULL, `appraiser` int(11) NOT NULL, `appraisee` int(11) NOT NULL, `unit` int(11) NOT NULL, `answer` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form` -- CREATE TABLE `ap_form` ( `id` int(11) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form_sections` -- CREATE TABLE `ap_form_sections` ( `id` int(11) NOT NULL, `ap_form` int(11) NOT NULL, `type` enum('u2d','d2u','peer','self') COLLATE utf8_unicode_ci NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `start` date NOT NULL, `end` date NOT NULL, `description` longtext COLLATE utf8_unicode_ci NOT NULL, `form` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form_section_unit` -- CREATE TABLE `ap_form_section_unit` ( `id` int(11) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `section` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form_section_unit_user` -- CREATE TABLE `ap_form_section_unit_user` ( `id` int(11) NOT NULL, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `type` enum('HEAD','MEMBER','RELATED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form_section_user` -- CREATE TABLE `ap_form_section_user` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `status` enum('SUBMITTED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `at_attendance_report` -- CREATE TABLE `at_attendance_report` ( `id` int(11) NOT NULL, `date` date NOT NULL, `direction` enum('IN','OUT') COLLATE utf8_unicode_ci NOT NULL, `uid` int(11) NOT NULL, `status` enum('NORMAL','LATE','EARLY','ABSENT') COLLATE utf8_unicode_ci NOT NULL, `remarks` text COLLATE utf8_unicode_ci NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updatedby` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `at_attendance_rule_dates` -- CREATE TABLE `at_attendance_rule_dates` ( `id` int(11) NOT NULL, `arp_id` int(11) NOT NULL, `day` varchar(12) NOT NULL, `da_id` int(11) NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_attendance_rule_period` -- CREATE TABLE `at_attendance_rule_period` ( `id` int(11) NOT NULL, `rule_name` varchar(256) NOT NULL, `effective_from` date NOT NULL, `effective_to` date NOT NULL, `public_holiday` tinyint(4) NOT NULL DEFAULT '0', `school_holiday` tinyint(4) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_daily_attendance` -- CREATE TABLE `at_daily_attendance` ( `id` int(11) NOT NULL, `rule_name` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_daily_attendance_timeset` -- CREATE TABLE `at_daily_attendance_timeset` ( `id` int(11) NOT NULL, `da_id` int(11) NOT NULL, `time_in` time NOT NULL, `check_in` tinyint(1) NOT NULL, `time_out` time NOT NULL, `check_out` tinyint(1) NOT NULL, `working_days` double(4,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_record` -- CREATE TABLE `at_record` ( `id` int(11) NOT NULL, `card` int(11) NOT NULL, `cr_id` text COLLATE utf8_unicode_ci, `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `at_special_attendance` -- CREATE TABLE `at_special_attendance` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `sat_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_special_attendance_timeset` -- CREATE TABLE `at_special_attendance_timeset` ( `id` int(11) NOT NULL, `sa_id` int(11) NOT NULL, `time_in` time NOT NULL, `check_in` tinyint(1) NOT NULL, `time_out` time NOT NULL, `check_out` tinyint(1) NOT NULL, `working_days` double(4,2) NOT NULL, `dates` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_user_card` -- CREATE TABLE `at_user_card` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `card` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `at_user_time_rule_set` -- CREATE TABLE `at_user_time_rule_set` ( `id` int(11) NOT NULL, `arp_id` int(11) NOT NULL, `every_day` varchar(12) NOT NULL, `da_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `calendar_type` -- CREATE TABLE `calendar_type` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `color` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_default` tinyint(4) NOT NULL, `urgent_booking_warning` int(11) NOT NULL, `need_approval` tinyint(4) NOT NULL, `hide_event` tinyint(1) NOT NULL, `approver_user_id` char(255) COLLATE utf8_unicode_ci DEFAULT NULL, `circular_required` tinyint(4) NOT NULL, `display_only` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `calendar_type_has_forms` -- CREATE TABLE `calendar_type_has_forms` ( `id` int(11) NOT NULL, `calendar_type_id` int(11) NOT NULL, `form_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `circulars` -- CREATE TABLE `circulars` ( `id` int(11) NOT NULL, `circular_number` int(10) NOT NULL, `event_id` int(11) NOT NULL, `event_series` int(11) NOT NULL, `circular_templates` int(11) NOT NULL, `section_id` int(11) NOT NULL, `teacher_in_charge` int(11) NOT NULL, `circular_body` text COLLATE utf8_unicode_ci NOT NULL, `distribute_date` date NOT NULL, `status` enum('APPROVED','REJECTED','RELEASED','SUBMITTED','DRAFT','PENDING') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `circular_templates` -- CREATE TABLE `circular_templates` ( `id` int(11) NOT NULL, `circular_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `circular_body` text COLLATE utf8_unicode_ci NOT NULL, `files` text COLLATE utf8_unicode_ci NOT NULL, `is_enabled` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `doorEventLog` -- CREATE TABLE `doorEventLog` ( `cardReaderID` bigint(20) NOT NULL, `event_type` text COLLATE utf8_unicode_ci NOT NULL, `event_data` text COLLATE utf8_unicode_ci NOT NULL, `event_id` int(11) NOT NULL, `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `eb_facilities` -- CREATE TABLE `eb_facilities` ( `id` int(11) NOT NULL, `facility_id` int(11) NOT NULL, `is_enabled` tinyint(4) NOT NULL, `need_approval` tinyint(4) NOT NULL, `approver_user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `eb_settings` -- CREATE TABLE `eb_settings` ( `id` int(11) NOT NULL, `key` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `val` text CHARACTER SET utf8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `eb_time_slots` -- CREATE TABLE `eb_time_slots` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `time_from` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `time_to` varchar(55) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `eb_venues` -- CREATE TABLE `eb_venues` ( `id` int(11) NOT NULL, `venue_id` int(11) NOT NULL, `is_enabled` tinyint(4) NOT NULL, `need_approval` tinyint(4) NOT NULL, `approver_user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(11) NOT NULL, `event_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `calendar_type_id` int(11) NOT NULL, `event_type_id` int(11) NOT NULL, `teacher_in_charge` int(11) NOT NULL, `remark` mediumtext COLLATE utf8_unicode_ci NOT NULL, `serializeData` mediumtext COLLATE utf8_unicode_ci NOT NULL, `status` enum('DRAFT','PENDING','PUBLISHED','REJECTED','WITHDRAW','APPROVED') COLLATE utf8_unicode_ci NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_forms_history` -- CREATE TABLE `event_forms_history` ( `id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `from_status` enum('PENDING','APPROVED','REJECTED','SUBMITTED','RELEASED','WITHDRAW') COLLATE utf8_unicode_ci NOT NULL, `to_status` enum('PENDING','APPROVED','REJECTED','SUBMITTED','RELEASED','WITHDRAW') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_has_files` -- CREATE TABLE `event_has_files` ( `id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_has_forms` -- CREATE TABLE `event_has_forms` ( `id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `status` enum('PENDING','APPROVED','REJECTED','SUBMITTED','RELEASED','WITHDRAW','DRAFT') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_has_sections` -- CREATE TABLE `event_has_sections` ( `id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `startDate` date NOT NULL, `from_time` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `to_time` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `section_group` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_section_has_facilities` -- CREATE TABLE `event_section_has_facilities` ( `id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `facility_id` int(11) NOT NULL, `status` enum('PENDING','APPROVED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_section_has_participants` -- CREATE TABLE `event_section_has_participants` ( `id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `participant_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `other` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_section_has_venues` -- CREATE TABLE `event_section_has_venues` ( `id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `venue_id` int(11) NOT NULL, `other` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` enum('PENDING','PENDING0','PENDING1','PENDING2','PENDING3','APPROVED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_types` -- CREATE TABLE `event_types` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `facilities` -- CREATE TABLE `facilities` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `quantity` int(11) NOT NULL, `remarks` mediumtext COLLATE utf8_unicode_ci NOT NULL, `order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form` -- CREATE TABLE `form` ( `id` int(11) NOT NULL, `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `structure` text COLLATE utf8_unicode_ci NOT NULL, `version` varchar(256) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `forms` -- CREATE TABLE `forms` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `need_approval` tinyint(4) NOT NULL, `approver` char(255) COLLATE utf8_unicode_ci DEFAULT NULL, `is_enabled` tinyint(4) NOT NULL, `deadline` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_answers` -- CREATE TABLE `form_answers` ( `id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `user_id` 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 `form_answer_has_grid` -- CREATE TABLE `form_answer_has_grid` ( `id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `user_id` 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, `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 `form_answer_has_table` -- CREATE TABLE `form_answer_has_table` ( `id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `answer` 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 `form_has_questions` -- CREATE TABLE `form_has_questions` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `form_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('LABEL','SINGLE_LINE','MULTIPLE_LINE','SUGGESTED','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','DATE','TIME','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, `description` text COLLATE utf8_unicode_ci NOT NULL, `color` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `font_size` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_question_has_options` -- CREATE TABLE `form_question_has_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 `form_question_has_questions` -- CREATE TABLE `form_question_has_questions` ( `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, `description` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_question_has_token` -- CREATE TABLE `form_question_has_token` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `token` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `id` int(11) NOT NULL, `name` text NOT NULL, `parent` int(11) DEFAULT NULL, `enabled` tinyint(1) NOT NULL, `weight` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `holiday` -- CREATE TABLE `holiday` ( `id` int(11) NOT NULL, `title` text COLLATE utf8_unicode_ci NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `type` enum('public','school','other') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ls_approval_group` -- CREATE TABLE `ls_approval_group` ( `id` int(11) NOT NULL, `title` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_approval_group_level` -- CREATE TABLE `ls_approval_group_level` ( `id` int(11) NOT NULL, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `level` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_approval_group_user` -- CREATE TABLE `ls_approval_group_user` ( `id` int(11) NOT NULL, `ag_id` int(11) NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_approval_record` -- CREATE TABLE `ls_approval_record` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `la_id` int(11) NOT NULL, `reason` varchar(256) NOT NULL, `status` enum('N','A','R') NOT NULL, `level_id` int(11) NOT NULL, `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_class_substitution` -- CREATE TABLE `ls_class_substitution` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `lesson` int(11) NOT NULL, `marks` int(11) NOT NULL, `status` enum('Pending','Confirmed','Cancelled') NOT NULL, `date` date NOT NULL, `cycle_day` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_entitlement` -- CREATE TABLE `ls_entitlement` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `ay_id` int(11) NOT NULL, `paid_leave` int(11) NOT NULL, `paid_maternity_leave` int(11) NOT NULL, `unpaid_maternity_leave` int(11) NOT NULL, `paternity_leave` int(11) NOT NULL, `special_leave` int(11) NOT NULL, `special_tuberculosis_leave` int(11) NOT NULL, `sepcial_event_leave` int(11) NOT NULL, `annual_leave` float NOT NULL, `carry_forward` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ls_it_weight` -- CREATE TABLE `ls_it_weight` ( `id` int(11) NOT NULL, `lt_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `weight` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_leave_application` -- CREATE TABLE `ls_leave_application` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `lt_id` int(11) NOT NULL, `dates` text NOT NULL, `half_day` tinyint(1) NOT NULL, `from_time` time NOT NULL, `to_time` time NOT NULL, `reason` varchar(256) NOT NULL, `status` enum('P','A','R','D','C') NOT NULL DEFAULT 'P', `gid` int(11) NOT NULL, `st_hire` int(11) NOT NULL, `leave_proof` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_leave_type` -- CREATE TABLE `ls_leave_type` ( `id` int(11) NOT NULL, `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `type` enum('PSL','MTL','PTL','SL','STL','SEL','AL','PL','NPL','NPML','CL') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NPL', `color` text COLLATE utf8_unicode_ci NOT NULL, `approval` tinyint(1) NOT NULL, `cpd` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ls_user_marks` -- CREATE TABLE `ls_user_marks` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `marks` int(11) NOT NULL, `type` enum('Class','Duty') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `msg_messages` -- CREATE TABLE `msg_messages` ( `id` int(11) NOT NULL, `thread_id` int(11) NOT NULL, `body` text NOT NULL, `priority` int(2) NOT NULL DEFAULT '0', `sender_id` int(11) NOT NULL, `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `msg_participants` -- CREATE TABLE `msg_participants` ( `user_id` int(11) NOT NULL, `thread_id` int(11) NOT NULL, `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `msg_status` -- CREATE TABLE `msg_status` ( `message_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `status` int(2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `msg_threads` -- CREATE TABLE `msg_threads` ( `id` int(11) NOT NULL, `subject` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `notification` -- CREATE TABLE `notification` ( `id` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `uid` int(11) NOT NULL, `msg` text COLLATE utf8_unicode_ci NOT NULL, `link` text COLLATE utf8_unicode_ci NOT NULL, `type` int(11) NOT NULL, `modules` enum('CORE','PR','AP','EB','TD','TB','AT','LS','OT','MIS') COLLATE utf8_unicode_ci NOT NULL, `read` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ot_approval_record` -- CREATE TABLE `ot_approval_record` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `ot_id` int(11) NOT NULL, `reason` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `status` enum('N','A','R') COLLATE utf8_unicode_ci NOT NULL, `level_id` int(11) NOT NULL, `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ot_overtime` -- CREATE TABLE `ot_overtime` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `date` date NOT NULL, `from_time` time NOT NULL, `to_time` time NOT NULL, `remarks` varchar(256) NOT NULL, `status` enum('P','R','A','D') NOT NULL DEFAULT 'P', `gid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `participants` -- CREATE TABLE `participants` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_enabled` tinyint(4) NOT NULL, `order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `participants_has_groups` -- CREATE TABLE `participants_has_groups` ( `id` int(11) NOT NULL, `participant_id` int(11) NOT NULL, `group_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `participant_group` -- CREATE TABLE `participant_group` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` int(11) NOT NULL, `permission_title` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `permission_key` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, `module` enum('CORE','PR','AP','EB','TD','TB','AT','LS','OT','MIS','APa','WF') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `permission_title`, `permission_key`, `module`) VALUES (1, 'Add User', 'ADD_USER', 'CORE'), (2, 'View All User', 'VIEW_ALL_USER', 'CORE'), (3, 'Edit All User', 'EDIT_ALL_USER', 'CORE'), (4, 'Delete All User', 'DELETE_ALL_USER', 'CORE'), (5, 'Block All User', 'BLOCK_ALL_USER', 'CORE'), (6, 'Assign User Role', 'ASSIGN_USER_ROLE', 'CORE'), (7, 'Manage User Data', 'MANAGE_USER_DATA', 'CORE'), (8, 'Manage User Group', 'MANAGE_USER_GROUP', 'CORE'), (9, 'Manage User Role', 'MANAGE_USER_ROLE', 'CORE'), (10, 'Manage User Permission', 'MANAGE_USER_PERMISSION', 'CORE'), (11, 'Add Permission', 'ADD_PERMISSION', 'CORE'), (12, 'Edit Permission', 'EDIT_PERMISSION', 'CORE'), (13, 'Manage Module', 'MANAGE_MODULE', 'CORE'), (14, 'Manage Site Setting', 'MANAGE_SITE_SETTING', 'CORE'), (15, 'Manage PR Policy', 'MANAGE_PR_POLICY', 'PR'), (16, 'Manage Financial Year', 'MANAGE_FINANCIAL_YEAR', 'PR'), (17, 'Manage Budget Group', 'MANAGE_BUDGET_GROUP', 'PR'), (18, 'Manage Budget Category', 'MANAGE_BUDGET_CATEGORY', 'PR'), (19, 'Apply My Budget Item (for my own departments)', 'APPLY_MY_BI', 'PR'), (20, 'Edit My Budget Item', 'EDIT_MY_BI', 'PR'), (21, 'Delete My Budget Item', 'DELETE_MY_BI', 'PR'), (22, 'Submit My Budget Item', 'SUBMIT_MY_BI', 'PR'), (23, 'Approve Budget Item', 'APPROVE_BI', 'PR'), (24, 'Add Budget Item (for all departments)', 'ADD_BI', 'PR'), (25, 'View All Budget Item', 'VIEW_ALL_BI', 'PR'), (26, 'Edit All Budget Item', 'EDIT_ALL_BI', 'PR'), (27, 'Delete All Budget Item', 'DELETE_ALL_BI', 'PR'), (28, 'Apply My Purchase Request', 'APPLY_MY_PR', 'PR'), (29, 'Edit My Purchase Request', 'EDIT_MY_PR', 'PR'), (30, 'Submit My Purchase Request', 'SUBMIT_MY_PR', 'PR'), (31, 'Cancel My Purchase Request', 'CANCEL_MY_PR', 'PR'), (32, 'Amend My Purchase Request', 'AMEND_MY_PR', 'PR'), (33, 'Delete My Purchase Request', 'DELETE_MY_PR', 'PR'), (34, 'Approve All Purchase Request (for non-head)', 'APPROVE_ALL_PR', 'PR'), (35, 'Complete All Purchase Request', 'COMPLETE_ALL_PR', 'PR'), (36, 'View All Purchase Request', 'VIEW_ALL_PR', 'PR'), (37, 'View BG Purchase Request', 'VIEW_BG_PR', 'PR'), (38, 'Edit All Purchase Request', 'EDIT_ALL_PR', 'PR'), (39, 'Delete All Purchase Request', 'DELETE_ALL_PR', 'PR'), (40, 'View All Budget Report', 'VIEW_ALL_BUDGET_REPORT', 'PR'), (41, 'View BG Budget Report', 'VIEW_BG_BUDGET_REPORT', 'PR'), (42, 'Input Voucher Number', 'INPUT_PR_VOUCHER_NO', 'PR'), (43, 'Manage PR Email Template', 'MANAGE_PR_EMAIL_TEMPLATE', 'PR'), (44, 'View All Tender', 'VIEW_ALL_TENDER', 'TD'), (45, 'Add Tender', 'ADD_TENDER', 'TD'), (46, 'Edit My Tender', 'EDIT_MY_TENDER', 'TD'), (47, 'Edit All Tender', 'EDIT_ALL_TENDER', 'TD'), (48, 'Delete All Tender', 'DELETE_ALL_TENDER', 'TD'), (49, 'Approve Urgent Tender', 'APPROVE_URGENT_TENDER', 'TD'), (50, 'Assign COI User', 'ASSIGN_COI_USER', 'TD'), (51, 'Manage Tender Setting', 'MANAGE_TENDER_SETTING', 'TD'), (52, 'Manage Tender Template', 'MANAGE_TENDER_TEMPLATE', 'TD'), (53, 'View My COI Record', 'VIEW_MY_COI_RECORD', 'TD'), (54, 'View All COI Record', 'VIEW_ALL_COI_RECORD', 'TD'), (55, 'Submit Tender', 'SUBMIT_TENDER', 'TD'), (56, 'Check Timetable', 'CHECK_TIMETABLE', 'TB'), (57, 'Manage Subject', 'MANAGE_SUBJECT', 'TB'), (58, 'Manage Class/Group', 'MANAGE_CLASS_GROUP', 'TB'), (59, 'Manage Subject Arrangement', 'MANAGE_SUB_ARG', 'TB'), (60, 'Manage Timetable', 'MANAGE_TIMETABLE', 'TB'), (61, 'View Attendance Report', 'VIEW_ATTENDANCE_REPORT', 'AT'), (62, 'Confirm Attendance Record', 'CONFIRM_ATTENDANCE_RECORD', 'AT'), (63, 'Manage Card Reader', 'MANAGE_CARD_READER', 'AT'), (64, 'Manage User Card', 'MANAGE_USER_CARD', 'AT'), (65, 'Manage Daily Time Rule', 'MANAGE_DTIME_RULE', 'AT'), (66, 'Assign Daily Time Rule', 'ASSIGN_DTIME_RULE', 'AT'), (67, 'Manage Special Time Rule', 'MANAGE_STIME_RULE', 'AT'), (68, 'Manage Supplier', 'MANAGE_SUPPLIER', 'MIS'), (69, 'View All Supplier', 'VIEW_ALL_SUPPLIER', 'MIS'), (71, 'Manage Venue', 'MANAGE_VENUE', 'MIS'), (72, 'Manage Facility', 'MANAGE_FACILITY', 'MIS'), (73, 'Manage Academic Year', 'MANAGE_ACADEMIC_YEAR', 'MIS'), (74, 'Manage Timeslot', 'MANAGE_TIMESLOT', 'MIS'), (75, 'Manage Holiday', 'MANAGE_HOLIDAY', 'MIS'), (80, 'Apply Overtime', 'APPLY_OVERTIME', 'OT'), (81, 'View All Overtime', 'VIEW_ALL_OVERTIME', 'OT'), (82, 'Edit All Overtime', 'EDIT_ALL_OVERTIME', 'OT'), (83, 'Delete All Overtime', 'DELETE_ALL_OVERTIME', 'OT'), (86, 'Apply Leave', 'APPLY_LEAVE', 'LS'), (87, 'Approve Leave', 'APPROVE_LEAVE', 'LS'), (88, 'View All Leave', 'VIEW_ALL_LEAVE', 'LS'), (89, 'Edit All Leave', 'EDIT_ALL_LEAVE', 'LS'), (90, 'Delete All Leave', 'DELETE_ALL_LEAVE', 'LS'), (91, 'Arrange Sub', 'ARRANGE_SUB', 'LS'), (92, 'View My Sub', 'VIEW_MY_SUB', 'LS'), (93, 'View All Sub', 'VIEW_ALL_SUB', 'LS'), (94, 'View Leave/Sub Report', 'VIEW_LEAVE_SUB_REPORT', 'LS'), (95, 'Manage Leave Type', 'MANAGE_LEAVE_TYPE', 'LS'), (96, 'Manage Approval Group', 'MANAGE_APPROVAL_GROUP', 'LS'), (97, 'Manage Leave Entitlement', 'MANAGE_ENTITLEMENT', 'LS'), (98, 'Manage Appraisal Setting', 'MANAGE_AP_SETTING', 'AP'), (99, 'Manage Appraisal Template', 'MANAGE_AP_TEMPLATE', 'AP'), (100, 'Manage Appraisal Level', 'MANAGE_AP_LEVEL', 'AP'), (101, 'Manage Appraisal Unit', 'MANAGE_AP_UNIT', 'AP'), (102, 'Manage Overall Appraisal', 'MANAGE_OA', 'AP'), (103, 'Manage Overall Appraisal Workflow', 'MANAGE_OA_WORKFLOW', 'AP'), (104, 'Manage Appraisal Email Template', 'MANAGE_AP_EMAIL_TEMPLATE', 'AP'), (105, 'Do My Appraisal', 'DO_MY_APPRAISAL', 'AP'), (106, 'View My Appraisal Report', 'VIEW_MY_APPRAISAL', 'AP'), (107, 'View all Appraisal Report', 'VIEW_ALL_APPRAISAL', 'AP'), (108, 'Delete Appraisal Data', 'DELETE_AP_DATA', 'AP'), (109, 'View Appraisal Report', 'VIEW_AP_REPORT', 'AP'), (110, 'Manage Appraisal Form', 'MANAGE_AP_FORM', 'AP'), (111, 'View All Attendance Report', 'VIEW_ALL_AT_REPORT', 'AT'), (112, 'View Group Attendance Report', 'VIEW_GROUP_AT_REPORT', 'AT'), (113, 'View My Attendance Report', 'VIEW_MY_AT_REPORT', 'AT'), (114, 'Approve Overtime', 'APPROVE_OVERTIME', 'OT'), (116, 'Manage Form Builder', 'MANAGE_FORM_BUILDER', 'MIS'), (117, 'Apply Form', 'APPLY_FORM', 'WF'), (118, 'View All Form', 'VIEW_ALL_FORM', 'WF'), (119, 'Access Form Approval', 'ACCESS_FORM_APPROVAL', 'WF'), (120, 'Manage Workflow Builder', 'MANAGE_WF_BUILDER', 'WF'); -- -------------------------------------------------------- -- -- Table structure for table `pr_approval_status` -- CREATE TABLE `pr_approval_status` ( `id` int(11) NOT NULL, `pr_id` int(11) DEFAULT NULL, `status` enum('pending','approved','rejected','cancelled','completed','draft') CHARACTER SET utf8 DEFAULT NULL, `approval_role_id` int(11) DEFAULT NULL, `updated_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_category` -- CREATE TABLE `pr_budget_category` ( `id` int(11) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `financial_year_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_group` -- CREATE TABLE `pr_budget_group` ( `id` int(11) NOT NULL, `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `financial_year_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_group_users` -- CREATE TABLE `pr_budget_group_users` ( `id` int(11) NOT NULL, `bg_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `role` enum('HEAD','MEMBER') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_items` -- CREATE TABLE `pr_budget_items` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `bg_id` int(11) NOT NULL, `budget_allowance` decimal(10,2) NOT NULL, `budget_amount` decimal(10,2) NOT NULL, `quantity` int(11) NOT NULL, `budget_pool_key_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `status` enum('PENDING','APPROVED','REJECTED','REVISED','SUBMITTED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_items_history` -- CREATE TABLE `pr_budget_items_history` ( `id` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `bi_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `details` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_item_category` -- CREATE TABLE `pr_budget_item_category` ( `id` int(11) NOT NULL, `budget_item` int(11) NOT NULL, `budget_category` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_pool_keys` -- CREATE TABLE `pr_budget_pool_keys` ( `id` int(11) NOT NULL, `pool_key` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `total_budget_amount` decimal(10,2) NOT NULL, `bg_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_return` -- CREATE TABLE `pr_budget_return` ( `id` int(11) NOT NULL, `bi_id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `amount` decimal(10,2) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_financial_years` -- CREATE TABLE `pr_financial_years` ( `id` int(11) NOT NULL, `year_start` date NOT NULL, `year_end` date NOT NULL, `financial_year_label` varchar(12) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_from_tender` -- CREATE TABLE `pr_from_tender` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `tender_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_has_reference_supplier` -- CREATE TABLE `pr_has_reference_supplier` ( `id` int(11) NOT NULL, `supplier_id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `file_ext` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `pic_id` int(11) NOT NULL, `price` decimal(10,0) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_has_sub_items` -- CREATE TABLE `pr_has_sub_items` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `quantity` int(11) NOT NULL, `unit_price` decimal(10,0) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_payment_record` -- CREATE TABLE `pr_payment_record` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `date` date NOT NULL, `amount` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_purchase_approval_history` -- CREATE TABLE `pr_purchase_approval_history` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `status` enum('draft','pending','approved','rejected','completed','cancelled') COLLATE utf8_unicode_ci NOT NULL, `updated_on` datetime NOT NULL, `status_updated_by` int(11) NOT NULL, `is_approve_action` int(11) NOT NULL, `reject_reason` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_purchase_budget_items` -- CREATE TABLE `pr_purchase_budget_items` ( `id` int(11) NOT NULL, `pr_id` int(11) DEFAULT NULL, `bg_bi_id` int(11) DEFAULT NULL, `request_amount` decimal(10,2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_settings` -- CREATE TABLE `pr_settings` ( `id` int(11) NOT NULL, `key` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `val` text CHARACTER SET utf8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_settings_approval_role` -- CREATE TABLE `pr_settings_approval_role` ( `id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `weight` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_settings_approval_workflow` -- CREATE TABLE `pr_settings_approval_workflow` ( `id` int(11) NOT NULL, `settings_price_range_id` int(11) DEFAULT NULL, `role_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_settings_price_range` -- CREATE TABLE `pr_settings_price_range` ( `id` int(11) NOT NULL, `start_range` decimal(10,2) DEFAULT NULL, `end_range` decimal(10,2) DEFAULT NULL, `quotation_file_required` tinyint(1) DEFAULT NULL, `number_of_suppliers` tinyint(4) DEFAULT NULL, `ref_quotation_file_required` tinyint(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; -- -------------------------------------------------------- -- -- Table structure for table `pr_student_payment` -- CREATE TABLE `pr_student_payment` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `number_of_students` int(11) NOT NULL, `payment_per_student` decimal(10,0) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `purchase_request` -- CREATE TABLE `purchase_request` ( `id` int(11) NOT NULL, `pr_reference_number_prefix` varchar(120) COLLATE utf8_unicode_ci NOT NULL, `pr_reference_number_count` int(11) NOT NULL, `item_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `require_date` date NOT NULL, `delivery_date` date NOT NULL, `usage` text COLLATE utf8_unicode_ci, `is_applicant_other` tinyint(1) DEFAULT NULL, `applicant_id` int(11) DEFAULT NULL, `submitted_by` int(11) DEFAULT NULL, `reason_for_multiple_items` text COLLATE utf8_unicode_ci, `total_request_amount` decimal(10,2) DEFAULT NULL, `payment_from_students` decimal(10,2) DEFAULT NULL, `chosen_supplier_id` int(11) DEFAULT NULL, `chosen_price` decimal(10,2) DEFAULT NULL, `chosen_supplier_quotation_file_ext` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `is_sole_supplier` tinyint(1) DEFAULT NULL, `is_tender_payment` tinyint(1) DEFAULT NULL, `other_reasons_cannot_provide_ref_sup` tinyint(1) DEFAULT NULL, `reason_no_reference_supplier` text COLLATE utf8_unicode_ci, `reason_no_lower_price` text COLLATE utf8_unicode_ci, `remarks` text COLLATE utf8_unicode_ci, `payment_method` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `cheque_payable_to` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `status` enum('draft','pending') COLLATE utf8_unicode_ci DEFAULT NULL, `amend_count` int(11) NOT NULL, `voucher_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `copy_of` int(11) NOT NULL, `serializeData` mediumtext COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` int(11) NOT NULL, `role` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `is_approval_role` int(11) NOT NULL, `system_role` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='All roles available for the system'; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `role`, `is_approval_role`, `system_role`) VALUES (2, 'Staff', 0, 0), (3, 'Principal', 0, 0), (4, 'Teacher', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `roles_permission` -- CREATE TABLE `roles_permission` ( `id` int(11) NOT NULL, `role_id` int(11) DEFAULT NULL, `permission_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; -- -- Dumping data for table `roles_permission` -- INSERT INTO `roles_permission` (`id`, `role_id`, `permission_id`) VALUES (56, 2, 15), (57, 2, 16), (58, 2, 17), (59, 2, 18), (60, 2, 19), (61, 2, 20), (62, 2, 21), (63, 2, 22), (64, 3, 23), (65, 2, 23), (66, 2, 24), (67, 2, 25), (68, 2, 26), (69, 2, 27), (70, 2, 28), (71, 2, 29), (72, 2, 30), (73, 2, 31), (74, 2, 32), (75, 2, 33), (76, 3, 34), (77, 2, 34), (78, 2, 35), (79, 2, 36), (80, 2, 37), (81, 2, 38), (82, 2, 39), (83, 2, 40), (84, 2, 41), (85, 2, 42), (86, 2, 43), (87, 3, 117), (88, 2, 117), (89, 4, 117), (90, 3, 118), (91, 2, 118), (92, 3, 119), (93, 4, 119); -- -------------------------------------------------------- -- -- Table structure for table `site_settings` -- CREATE TABLE `site_settings` ( `id` int(11) NOT NULL, `setting` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(512) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `site_settings` -- INSERT INTO `site_settings` (`id`, `setting`, `value`) VALUES (1, 'site_name', 'Camplus Admin'), (2, 'school_name', 'Demo School'), (3, 'school_logo_ext', 'png'), (4, 'modules', 'a:1:{s:7:\"modules\";a:19:{i:0;s:10:\"attendance\";i:1;s:9:\"appraisal\";i:2;s:7:\"holiday\";i:3;s:4:\"form\";i:4;s:6:\"tender\";i:5;s:13:\"event_booking\";i:6;s:8:\"facility\";i:7;s:8:\"supplier\";i:8;s:8:\"workflow\";i:9;s:8:\"timeslot\";i:10;s:14:\"access_control\";i:11;s:5:\"venue\";i:12;s:10:\"appraisala\";i:13;s:13:\"academic_year\";i:14;s:8:\"overtime\";i:15;s:9:\"timetable\";i:16;s:16:\"purchase_request\";i:17;s:9:\"leave_sub\";i:18;s:4:\"core\";}}'), (5, 'google-client-id', ''), (6, 'google-client-secret', ''), (7, 'google-redirect', ''), (8, 'api_user', ''), (9, 'api_password', 'e10adc3949ba59abbe56e057f20f883e'), (10, 'api_url', ''), (11, 'default_front_page', 'workflow/Workflow_form/listing'); -- -------------------------------------------------------- -- -- Table structure for table `suppliers` -- CREATE TABLE `suppliers` ( `id` int(11) NOT NULL, `supplier` varchar(100) CHARACTER SET utf8 DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `supplier_alias` -- CREATE TABLE `supplier_alias` ( `id` int(11) NOT NULL, `host_id` int(11) NOT NULL, `alias_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `supplier_pic` -- CREATE TABLE `supplier_pic` ( `id` int(11) NOT NULL, `supplier_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `tel` int(15) DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tb_class` -- CREATE TABLE `tb_class` ( `id` int(11) NOT NULL, `title` text COLLATE utf8_unicode_ci NOT NULL, `venue_id` int(11) NOT NULL, `ac_year_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tb_class_user` -- CREATE TABLE `tb_class_user` ( `id` int(11) NOT NULL, `class_id` int(11) NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tb_subjects` -- CREATE TABLE `tb_subjects` ( `id` int(11) NOT NULL, `name_chi` text COLLATE utf8_unicode_ci NOT NULL, `name_eng` text COLLATE utf8_unicode_ci NOT NULL, `shortname_chi` text COLLATE utf8_unicode_ci NOT NULL, `shortname_eng` text COLLATE utf8_unicode_ci NOT NULL, `venue_id` int(11) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tb_tea_class_sub` -- CREATE TABLE `tb_tea_class_sub` ( `id` int(11) NOT NULL, `ay_id` int(11) NOT NULL, `sub_id` int(11) NOT NULL, `class_id` int(11) NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tb_timetable` -- CREATE TABLE `tb_timetable` ( `id` int(11) NOT NULL, `ay_id` int(11) NOT NULL, `cycle_day` int(11) NOT NULL, `ts_id` int(11) NOT NULL, `ap_name` text CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tb_timetable_teacher` -- CREATE TABLE `tb_timetable_teacher` ( `id` int(11) NOT NULL, `tb_id` int(11) NOT NULL, `teaclasub_id` int(11) NOT NULL, `slot_id` int(11) NOT NULL, `day` int(11) NOT NULL, `uid` int(11) NOT NULL, `venue_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_code_pattern` -- CREATE TABLE `td_code_pattern` ( `id` int(11) NOT NULL, `pattern` varchar(20) NOT NULL, `next_code_no` int(11) NOT NULL, `min_quotation` int(11) NOT NULL, `prefix` varchar(2) NOT NULL, `due_date` int(11) NOT NULL, `urgent_days` int(11) NOT NULL, `status` enum('A','D') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_comparison` -- CREATE TABLE `td_comparison` ( `id` int(11) NOT NULL, `sid` int(11) NOT NULL, `item_id` int(11) NOT NULL, `content` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_comparison_items` -- CREATE TABLE `td_comparison_items` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `item_name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_content_list` -- CREATE TABLE `td_content_list` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `content` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_content_parts` -- CREATE TABLE `td_content_parts` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `status` tinyint(1) NOT NULL, `order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_forms` -- CREATE TABLE `td_forms` ( `id` int(11) NOT NULL, `title` varchar(20) NOT NULL, `serialized_data` longtext NOT NULL, `signature` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `td_form_questions` -- CREATE TABLE `td_form_questions` ( `id` int(11) NOT NULL, `t_form_id` int(11) NOT NULL, `question` varchar(100) NOT NULL, `color` varchar(50) NOT NULL, `detail` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_groupcoi_users` -- CREATE TABLE `td_groupcoi_users` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `next_count` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_group_coi` -- CREATE TABLE `td_group_coi` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_group_coi_user_count` -- CREATE TABLE `td_group_coi_user_count` ( `id` int(11) NOT NULL, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `next_count` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_log` -- CREATE TABLE `td_log` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `tid` int(11) NOT NULL, `status` enum('P','A','R') NOT NULL, `reason` varchar(256) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_open_tender` -- CREATE TABLE `td_open_tender` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `sid` int(11) NOT NULL, `replay_status` enum('Offer','No Offer','Received Late','No Replay') NOT NULL, `price` double(11,3) NOT NULL, `mark` int(11) NOT NULL, `remark` int(11) NOT NULL, `file` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_suppliers` -- CREATE TABLE `td_suppliers` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `sid` int(11) NOT NULL, `chosen` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_templates` -- CREATE TABLE `td_templates` ( `id` int(11) NOT NULL, `cid` int(11) NOT NULL, `title` varchar(50) NOT NULL, `content` text NOT NULL, `status` tinyint(1) NOT NULL, `type` enum('','COI') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_tenders` -- CREATE TABLE `td_tenders` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `title` varchar(20) NOT NULL, `code_pattern_id` int(11) NOT NULL, `tender_code` varchar(50) NOT NULL, `posting_date` date NOT NULL, `due_date` date NOT NULL, `person` varchar(50) NOT NULL, `budget` bigint(20) NOT NULL, `urgent_reason` varchar(50) NOT NULL, `status` set('APPROVED','REJECTED','PENDING','DRAFT') NOT NULL DEFAULT 'DRAFT', `coi_status` enum('DRAFT','SUBMITTED') NOT NULL, `open_tender_status` enum('DRAFT','SUBMITTED') NOT NULL, `comparison_status` enum('DRAFT','SUBMITTED') NOT NULL, `approval_uid` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `attachment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `serialized_data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ref_no` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_tender_coi_history` -- CREATE TABLE `td_tender_coi_history` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `sid` int(11) NOT NULL, `uid` int(11) NOT NULL, `remarks` varchar(50) NOT NULL, `status` tinyint(1) NOT NULL, `time` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_user_coi` -- CREATE TABLE `td_user_coi` ( `id` int(11) NOT NULL, `sid` int(11) NOT NULL, `uid` int(11) NOT NULL, `conflict` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `timeslot_sets` -- CREATE TABLE `timeslot_sets` ( `id` int(11) NOT NULL, `title` mediumtext NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `time_slots` -- CREATE TABLE `time_slots` ( `id` int(11) NOT NULL, `lesson_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `time_from` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `time_to` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `mark` int(11) NOT NULL, `type` enum('Class','Duty') COLLATE utf8_unicode_ci NOT NULL, `sets` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `name_chinese` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `name_english` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `created_on` datetime NOT NULL, `type` enum('Teaching Staff','Laboratory Technicians','Specialist Staff','Non-teaching Staff') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Teaching Staff', `service_commencement_date` date NOT NULL, `contract_date` date NOT NULL, `rank` text COLLATE utf8_unicode_ci NOT NULL, `teaching_exp` int(11) NOT NULL, `pay_day` date NOT NULL, `model_scale` enum('MPS','MOD') COLLATE utf8_unicode_ci NOT NULL, `pay_grade` int(11) NOT NULL, `grant_source` enum('RAG','SG') COLLATE utf8_unicode_ci NOT NULL, `last_logged_in` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `status` enum('ACTIVE','BLOCKED') COLLATE utf8_unicode_ci NOT NULL, `front_page` text COLLATE utf8_unicode_ci NOT NULL, `oauth_provider` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `oauth_uid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `gender` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `locale` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `picture_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `profile_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `modified` datetime NOT NULL, `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `title` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `email`, `name_chinese`, `name_english`, `password`, `created_on`, `type`, `service_commencement_date`, `contract_date`, `rank`, `teaching_exp`, `pay_day`, `model_scale`, `pay_grade`, `grant_source`, `last_logged_in`, `status`, `front_page`, `oauth_provider`, `oauth_uid`, `gender`, `locale`, `picture_url`, `profile_url`, `modified`, `first_name`, `last_name`, `title`) VALUES (1, 'admin', 'info@camplus.hk', 'System', 'Admin', 'e10adc3949ba59abbe56e057f20f883e', '2016-08-26 00:00:00', 'Teaching Staff', '2014-05-09', '0000-00-00', '', 0, '0000-00-00', 'MPS', 1, '', '', 'ACTIVE', 'purchase_request/my_purchase_requests', 'google', '', 'male', 'zh-TW', '', '', '2018-01-02 05:57:00', '', '', ''), (2, 'user1', 'user1@demo.com', '用戶1', 'User 1', 'e10adc3949ba59abbe56e057f20f883e', '2018-03-22 22:28:01', 'Teaching Staff', '0000-00-00', '0000-00-00', '', 0, '0000-00-00', 'MPS', 0, 'RAG', '', 'ACTIVE', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', ''), (3, 'user2', 'user2@demo.com', '用戶2', 'User 2', 'fe01ce2a7fbac8fafaed7c982a04e229', '2018-03-22 22:31:41', 'Teaching Staff', '0000-00-00', '0000-00-00', '', 0, '0000-00-00', 'MPS', 0, 'RAG', '', 'ACTIVE', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', ''), (4, 'principal', 'principal@demo.com', '校長', 'Principal', 'e10adc3949ba59abbe56e057f20f883e', '2018-03-22 22:32:04', 'Teaching Staff', '0000-00-00', '0000-00-00', '', 0, '0000-00-00', 'MPS', 0, 'RAG', '', 'ACTIVE', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', ''), (5, 'user3', 'user3@demo.com', '用戶3', 'User 3', 'e10adc3949ba59abbe56e057f20f883e', '2018-03-22 22:33:04', 'Teaching Staff', '0000-00-00', '0000-00-00', '', 0, '0000-00-00', 'MPS', 0, 'RAG', '', 'ACTIVE', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `users_cpd` -- CREATE TABLE `users_cpd` ( `id` int(11) NOT NULL, `dates` text COLLATE utf8_unicode_ci NOT NULL, `time` text COLLATE utf8_unicode_ci NOT NULL, `venue` text COLLATE utf8_unicode_ci NOT NULL, `organizer` text COLLATE utf8_unicode_ci NOT NULL, `domain` text COLLATE utf8_unicode_ci NOT NULL, `details` longtext COLLATE utf8_unicode_ci NOT NULL, `hours` float NOT NULL, `uid` int(11) NOT NULL, `la_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users_group` -- CREATE TABLE `users_group` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `group_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `users_roles` -- CREATE TABLE `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; -- -- Dumping data for table `users_roles` -- INSERT INTO `users_roles` (`id`, `user_id`, `role_id`) VALUES (5, 2, 2), (6, 2, 4), (7, 3, 2), (8, 3, 4), (9, 5, 2), (10, 5, 4), (11, 1, 2), (12, 1, 4), (13, 4, 3); -- -------------------------------------------------------- -- -- Table structure for table `venues` -- CREATE TABLE `venues` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `venuegroup` int(11) NOT NULL, `remarks` mediumtext COLLATE utf8_unicode_ci NOT NULL, `order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `venue_group` -- CREATE TABLE `venue_group` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_filled_form` -- CREATE TABLE `wf_filled_form` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `fid` int(11) NOT NULL, `unit` text COLLATE utf8_unicode_ci NOT NULL, `workflow` text COLLATE utf8_unicode_ci NOT NULL, `urgent_reason` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `apply_date` date NOT NULL, `status` text COLLATE utf8_unicode_ci NOT NULL, `last_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_form_answers` -- CREATE TABLE `wf_form_answers` ( `id` int(11) NOT NULL, `ff_id` int(11) NOT NULL, `q_domain` longtext COLLATE utf8_unicode_ci NOT NULL, `answer` longtext COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_form_status` -- CREATE TABLE `wf_form_status` ( `id` int(11) NOT NULL, `ff_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `action` enum('Pending','Agree','Disagree','Cancel') COLLATE utf8_unicode_ci NOT NULL, `level` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_form_workflow` -- CREATE TABLE `wf_form_workflow` ( `id` int(11) NOT NULL, `fid` int(11) NOT NULL, `wid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_workflow` -- CREATE TABLE `wf_workflow` ( `id` int(11) NOT NULL, `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `urgent_days` int(11) NOT NULL, `workflow` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `academic_years` -- ALTER TABLE `academic_years` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ac_devices` -- ALTER TABLE `ac_devices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ac_receiver` -- ALTER TABLE `ac_receiver` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ac_record` -- ALTER TABLE `ac_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ac_whitelist` -- ALTER TABLE `ac_whitelist` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_answer` -- ALTER TABLE `ap_answer` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `ap_filled_form` -- ALTER TABLE `ap_filled_form` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_form` -- ALTER TABLE `ap_form` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_form_sections` -- ALTER TABLE `ap_form_sections` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `ap_form_section_unit` -- ALTER TABLE `ap_form_section_unit` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_form_section_unit_user` -- ALTER TABLE `ap_form_section_unit_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_form_section_user` -- ALTER TABLE `ap_form_section_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_attendance_report` -- ALTER TABLE `at_attendance_report` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_attendance_rule_dates` -- ALTER TABLE `at_attendance_rule_dates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_attendance_rule_period` -- ALTER TABLE `at_attendance_rule_period` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_daily_attendance` -- ALTER TABLE `at_daily_attendance` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_daily_attendance_timeset` -- ALTER TABLE `at_daily_attendance_timeset` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_record` -- ALTER TABLE `at_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_special_attendance` -- ALTER TABLE `at_special_attendance` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_special_attendance_timeset` -- ALTER TABLE `at_special_attendance_timeset` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_user_card` -- ALTER TABLE `at_user_card` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_user_time_rule_set` -- ALTER TABLE `at_user_time_rule_set` ADD PRIMARY KEY (`id`); -- -- Indexes for table `calendar_type` -- ALTER TABLE `calendar_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `calendar_type_has_forms` -- ALTER TABLE `calendar_type_has_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `circulars` -- ALTER TABLE `circulars` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `circular_templates` -- ALTER TABLE `circular_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `doorEventLog` -- ALTER TABLE `doorEventLog` ADD PRIMARY KEY (`event_id`), ADD KEY `cardReaderID` (`cardReaderID`); -- -- Indexes for table `eb_facilities` -- ALTER TABLE `eb_facilities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `eb_settings` -- ALTER TABLE `eb_settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `SETTING_KEY_UNIQUE` (`key`); -- -- Indexes for table `eb_time_slots` -- ALTER TABLE `eb_time_slots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `eb_venues` -- ALTER TABLE `eb_venues` ADD PRIMARY KEY (`id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`), ADD KEY `status` (`status`), ADD KEY `calendar_type_id` (`calendar_type_id`); -- -- Indexes for table `event_forms_history` -- ALTER TABLE `event_forms_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `event_has_files` -- ALTER TABLE `event_has_files` ADD PRIMARY KEY (`id`); -- -- Indexes for table `event_has_forms` -- ALTER TABLE `event_has_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `event_has_sections` -- ALTER TABLE `event_has_sections` ADD PRIMARY KEY (`id`), ADD KEY `event_id` (`event_id`), ADD KEY `startDate` (`startDate`), ADD KEY `from_time` (`from_time`), ADD KEY `to_time` (`to_time`); -- -- Indexes for table `event_section_has_facilities` -- ALTER TABLE `event_section_has_facilities` ADD PRIMARY KEY (`id`), ADD KEY `section_id` (`section_id`); -- -- Indexes for table `event_section_has_participants` -- ALTER TABLE `event_section_has_participants` ADD PRIMARY KEY (`id`), ADD KEY `section_id` (`section_id`); -- -- Indexes for table `event_section_has_venues` -- ALTER TABLE `event_section_has_venues` ADD PRIMARY KEY (`id`), ADD KEY `section_id` (`section_id`), ADD KEY `venue_id` (`venue_id`); -- -- Indexes for table `event_types` -- ALTER TABLE `event_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `facilities` -- ALTER TABLE `facilities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form` -- ALTER TABLE `form` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `forms` -- ALTER TABLE `forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_answers` -- ALTER TABLE `form_answers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_answer_has_grid` -- ALTER TABLE `form_answer_has_grid` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_answer_has_table` -- ALTER TABLE `form_answer_has_table` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_has_questions` -- ALTER TABLE `form_has_questions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_question_has_options` -- ALTER TABLE `form_question_has_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_question_has_questions` -- ALTER TABLE `form_question_has_questions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_question_has_token` -- ALTER TABLE `form_question_has_token` ADD PRIMARY KEY (`id`); -- -- Indexes for table `groups` -- ALTER TABLE `groups` ADD PRIMARY KEY (`id`); -- -- Indexes for table `holiday` -- ALTER TABLE `holiday` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_approval_group` -- ALTER TABLE `ls_approval_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_approval_group_level` -- ALTER TABLE `ls_approval_group_level` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_approval_group_user` -- ALTER TABLE `ls_approval_group_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_approval_record` -- ALTER TABLE `ls_approval_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_class_substitution` -- ALTER TABLE `ls_class_substitution` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_entitlement` -- ALTER TABLE `ls_entitlement` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_it_weight` -- ALTER TABLE `ls_it_weight` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_leave_application` -- ALTER TABLE `ls_leave_application` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_leave_type` -- ALTER TABLE `ls_leave_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_user_marks` -- ALTER TABLE `ls_user_marks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `msg_messages` -- ALTER TABLE `msg_messages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `msg_participants` -- ALTER TABLE `msg_participants` ADD PRIMARY KEY (`user_id`,`thread_id`); -- -- Indexes for table `msg_status` -- ALTER TABLE `msg_status` ADD PRIMARY KEY (`message_id`,`user_id`); -- -- Indexes for table `msg_threads` -- ALTER TABLE `msg_threads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notification` -- ALTER TABLE `notification` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ot_approval_record` -- ALTER TABLE `ot_approval_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ot_overtime` -- ALTER TABLE `ot_overtime` ADD PRIMARY KEY (`id`); -- -- Indexes for table `participants` -- ALTER TABLE `participants` ADD PRIMARY KEY (`id`); -- -- Indexes for table `participants_has_groups` -- ALTER TABLE `participants_has_groups` ADD PRIMARY KEY (`id`); -- -- Indexes for table `participant_group` -- ALTER TABLE `participant_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permission_title_UNIQUE` (`permission_title`), ADD UNIQUE KEY `permission_key_UNIQUE` (`permission_key`); -- -- Indexes for table `pr_approval_status` -- ALTER TABLE `pr_approval_status` ADD PRIMARY KEY (`id`), ADD KEY `purchase_request_id_idx` (`pr_id`), ADD KEY `waiting_for_approval_by_idx` (`approval_role_id`); -- -- Indexes for table `pr_budget_category` -- ALTER TABLE `pr_budget_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_group` -- ALTER TABLE `pr_budget_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_group_users` -- ALTER TABLE `pr_budget_group_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_items` -- ALTER TABLE `pr_budget_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_items_history` -- ALTER TABLE `pr_budget_items_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_item_category` -- ALTER TABLE `pr_budget_item_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_pool_keys` -- ALTER TABLE `pr_budget_pool_keys` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_return` -- ALTER TABLE `pr_budget_return` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_financial_years` -- ALTER TABLE `pr_financial_years` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_from_tender` -- ALTER TABLE `pr_from_tender` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_has_reference_supplier` -- ALTER TABLE `pr_has_reference_supplier` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_has_sub_items` -- ALTER TABLE `pr_has_sub_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_payment_record` -- ALTER TABLE `pr_payment_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_purchase_approval_history` -- ALTER TABLE `pr_purchase_approval_history` ADD PRIMARY KEY (`id`), ADD KEY `purchase_request_id` (`pr_id`), ADD KEY `status` (`status`), ADD KEY `is_approve_action` (`is_approve_action`), ADD KEY `updated_on` (`updated_on`); -- -- Indexes for table `pr_purchase_budget_items` -- ALTER TABLE `pr_purchase_budget_items` ADD PRIMARY KEY (`id`), ADD KEY `budget_item_id_idx` (`bg_bi_id`), ADD KEY `purchase_request_id_idx` (`pr_id`); -- -- Indexes for table `pr_settings` -- ALTER TABLE `pr_settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `SETTING_KEY_UNIQUE` (`key`); -- -- Indexes for table `pr_settings_approval_role` -- ALTER TABLE `pr_settings_approval_role` ADD PRIMARY KEY (`id`), ADD KEY `role_id` (`role_id`); -- -- Indexes for table `pr_settings_approval_workflow` -- ALTER TABLE `pr_settings_approval_workflow` ADD PRIMARY KEY (`id`), ADD KEY `price_range_id_idx` (`settings_price_range_id`), ADD KEY `role_id_idx` (`role_id`); -- -- Indexes for table `pr_settings_price_range` -- ALTER TABLE `pr_settings_price_range` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `start_range_UNIQUE` (`start_range`), ADD UNIQUE KEY `end_range_UNIQUE` (`end_range`); -- -- Indexes for table `pr_student_payment` -- ALTER TABLE `pr_student_payment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchase_request` -- ALTER TABLE `purchase_request` ADD PRIMARY KEY (`id`), ADD KEY `applicant_id_idx` (`applicant_id`), ADD KEY `submited_by_idx` (`submitted_by`), ADD KEY `chosen_supplier_id_idx` (`chosen_supplier_id`), ADD KEY `item_name` (`item_name`), ADD KEY `item_name_2` (`item_name`), ADD KEY `applicant_id` (`applicant_id`), ADD KEY `submitted_by` (`submitted_by`), ADD KEY `chosen_price` (`chosen_price`), ADD KEY `voucher_number` (`voucher_number`), ADD KEY `status` (`status`), ADD KEY `payment_method` (`payment_method`), ADD KEY `chosen_price_2` (`chosen_price`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD KEY `role` (`role`); -- -- Indexes for table `roles_permission` -- ALTER TABLE `roles_permission` ADD PRIMARY KEY (`id`), ADD KEY `role_id_idx` (`role_id`), ADD KEY `permission_id_idx` (`permission_id`); -- -- Indexes for table `site_settings` -- ALTER TABLE `site_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `suppliers` -- ALTER TABLE `suppliers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `supplier` (`supplier`); -- -- Indexes for table `supplier_alias` -- ALTER TABLE `supplier_alias` ADD PRIMARY KEY (`id`); -- -- Indexes for table `supplier_pic` -- ALTER TABLE `supplier_pic` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_class` -- ALTER TABLE `tb_class` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_class_user` -- ALTER TABLE `tb_class_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_subjects` -- ALTER TABLE `tb_subjects` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_tea_class_sub` -- ALTER TABLE `tb_tea_class_sub` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_timetable` -- ALTER TABLE `tb_timetable` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_timetable_teacher` -- ALTER TABLE `tb_timetable_teacher` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_code_pattern` -- ALTER TABLE `td_code_pattern` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_comparison` -- ALTER TABLE `td_comparison` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_comparison_items` -- ALTER TABLE `td_comparison_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_content_list` -- ALTER TABLE `td_content_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_content_parts` -- ALTER TABLE `td_content_parts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_forms` -- ALTER TABLE `td_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_form_questions` -- ALTER TABLE `td_form_questions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_groupcoi_users` -- ALTER TABLE `td_groupcoi_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_group_coi` -- ALTER TABLE `td_group_coi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_group_coi_user_count` -- ALTER TABLE `td_group_coi_user_count` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_log` -- ALTER TABLE `td_log` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_open_tender` -- ALTER TABLE `td_open_tender` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_suppliers` -- ALTER TABLE `td_suppliers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_templates` -- ALTER TABLE `td_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_tenders` -- ALTER TABLE `td_tenders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_tender_coi_history` -- ALTER TABLE `td_tender_coi_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_user_coi` -- ALTER TABLE `td_user_coi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `timeslot_sets` -- ALTER TABLE `timeslot_sets` ADD PRIMARY KEY (`id`); -- -- Indexes for table `time_slots` -- ALTER TABLE `time_slots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users_cpd` -- ALTER TABLE `users_cpd` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users_group` -- ALTER TABLE `users_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users_roles` -- ALTER TABLE `users_roles` ADD PRIMARY KEY (`id`), ADD KEY `role_id_idx` (`role_id`), ADD KEY `user_id_idx` (`user_id`); -- -- Indexes for table `venues` -- ALTER TABLE `venues` ADD PRIMARY KEY (`id`); -- -- Indexes for table `venue_group` -- ALTER TABLE `venue_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wf_filled_form` -- ALTER TABLE `wf_filled_form` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wf_form_answers` -- ALTER TABLE `wf_form_answers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wf_form_status` -- ALTER TABLE `wf_form_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wf_form_workflow` -- ALTER TABLE `wf_form_workflow` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wf_workflow` -- ALTER TABLE `wf_workflow` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `academic_years` -- ALTER TABLE `academic_years` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ac_devices` -- ALTER TABLE `ac_devices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ac_receiver` -- ALTER TABLE `ac_receiver` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ac_record` -- ALTER TABLE `ac_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ac_whitelist` -- ALTER TABLE `ac_whitelist` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_answer` -- ALTER TABLE `ap_answer` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_filled_form` -- ALTER TABLE `ap_filled_form` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form` -- ALTER TABLE `ap_form` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form_sections` -- ALTER TABLE `ap_form_sections` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form_section_unit` -- ALTER TABLE `ap_form_section_unit` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form_section_unit_user` -- ALTER TABLE `ap_form_section_unit_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form_section_user` -- ALTER TABLE `ap_form_section_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_attendance_report` -- ALTER TABLE `at_attendance_report` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_attendance_rule_dates` -- ALTER TABLE `at_attendance_rule_dates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_attendance_rule_period` -- ALTER TABLE `at_attendance_rule_period` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_daily_attendance` -- ALTER TABLE `at_daily_attendance` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_daily_attendance_timeset` -- ALTER TABLE `at_daily_attendance_timeset` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_record` -- ALTER TABLE `at_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_special_attendance` -- ALTER TABLE `at_special_attendance` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_special_attendance_timeset` -- ALTER TABLE `at_special_attendance_timeset` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_user_card` -- ALTER TABLE `at_user_card` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_user_time_rule_set` -- ALTER TABLE `at_user_time_rule_set` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `calendar_type` -- ALTER TABLE `calendar_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `calendar_type_has_forms` -- ALTER TABLE `calendar_type_has_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `circulars` -- ALTER TABLE `circulars` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `circular_templates` -- ALTER TABLE `circular_templates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `doorEventLog` -- ALTER TABLE `doorEventLog` MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `eb_facilities` -- ALTER TABLE `eb_facilities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `eb_settings` -- ALTER TABLE `eb_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `eb_time_slots` -- ALTER TABLE `eb_time_slots` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `eb_venues` -- ALTER TABLE `eb_venues` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_forms_history` -- ALTER TABLE `event_forms_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_has_files` -- ALTER TABLE `event_has_files` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_has_forms` -- ALTER TABLE `event_has_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_has_sections` -- ALTER TABLE `event_has_sections` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_section_has_facilities` -- ALTER TABLE `event_section_has_facilities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_section_has_participants` -- ALTER TABLE `event_section_has_participants` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_section_has_venues` -- ALTER TABLE `event_section_has_venues` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_types` -- ALTER TABLE `event_types` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `facilities` -- ALTER TABLE `facilities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form` -- ALTER TABLE `form` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `forms` -- ALTER TABLE `forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_answers` -- ALTER TABLE `form_answers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_answer_has_grid` -- ALTER TABLE `form_answer_has_grid` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_answer_has_table` -- ALTER TABLE `form_answer_has_table` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_has_questions` -- ALTER TABLE `form_has_questions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_question_has_options` -- ALTER TABLE `form_question_has_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_question_has_questions` -- ALTER TABLE `form_question_has_questions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_question_has_token` -- ALTER TABLE `form_question_has_token` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `groups` -- ALTER TABLE `groups` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `holiday` -- ALTER TABLE `holiday` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_approval_group` -- ALTER TABLE `ls_approval_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_approval_group_level` -- ALTER TABLE `ls_approval_group_level` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_approval_group_user` -- ALTER TABLE `ls_approval_group_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_approval_record` -- ALTER TABLE `ls_approval_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_class_substitution` -- ALTER TABLE `ls_class_substitution` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_entitlement` -- ALTER TABLE `ls_entitlement` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_it_weight` -- ALTER TABLE `ls_it_weight` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_leave_application` -- ALTER TABLE `ls_leave_application` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_leave_type` -- ALTER TABLE `ls_leave_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_user_marks` -- ALTER TABLE `ls_user_marks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `msg_messages` -- ALTER TABLE `msg_messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `msg_threads` -- ALTER TABLE `msg_threads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notification` -- ALTER TABLE `notification` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ot_approval_record` -- ALTER TABLE `ot_approval_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ot_overtime` -- ALTER TABLE `ot_overtime` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `participants` -- ALTER TABLE `participants` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `participants_has_groups` -- ALTER TABLE `participants_has_groups` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `participant_group` -- ALTER TABLE `participant_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121; -- -- AUTO_INCREMENT for table `pr_approval_status` -- ALTER TABLE `pr_approval_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_category` -- ALTER TABLE `pr_budget_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_group` -- ALTER TABLE `pr_budget_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_group_users` -- ALTER TABLE `pr_budget_group_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_items` -- ALTER TABLE `pr_budget_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_items_history` -- ALTER TABLE `pr_budget_items_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_item_category` -- ALTER TABLE `pr_budget_item_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_pool_keys` -- ALTER TABLE `pr_budget_pool_keys` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_return` -- ALTER TABLE `pr_budget_return` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_financial_years` -- ALTER TABLE `pr_financial_years` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_from_tender` -- ALTER TABLE `pr_from_tender` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_has_reference_supplier` -- ALTER TABLE `pr_has_reference_supplier` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_has_sub_items` -- ALTER TABLE `pr_has_sub_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_payment_record` -- ALTER TABLE `pr_payment_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_purchase_approval_history` -- ALTER TABLE `pr_purchase_approval_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_purchase_budget_items` -- ALTER TABLE `pr_purchase_budget_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_settings` -- ALTER TABLE `pr_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_settings_approval_role` -- ALTER TABLE `pr_settings_approval_role` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_settings_approval_workflow` -- ALTER TABLE `pr_settings_approval_workflow` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_settings_price_range` -- ALTER TABLE `pr_settings_price_range` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_student_payment` -- ALTER TABLE `pr_student_payment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `purchase_request` -- ALTER TABLE `purchase_request` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `roles_permission` -- ALTER TABLE `roles_permission` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94; -- -- AUTO_INCREMENT for table `site_settings` -- ALTER TABLE `site_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `suppliers` -- ALTER TABLE `suppliers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supplier_alias` -- ALTER TABLE `supplier_alias` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supplier_pic` -- ALTER TABLE `supplier_pic` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_class` -- ALTER TABLE `tb_class` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_class_user` -- ALTER TABLE `tb_class_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_subjects` -- ALTER TABLE `tb_subjects` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_tea_class_sub` -- ALTER TABLE `tb_tea_class_sub` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_timetable` -- ALTER TABLE `tb_timetable` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_timetable_teacher` -- ALTER TABLE `tb_timetable_teacher` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_code_pattern` -- ALTER TABLE `td_code_pattern` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_comparison` -- ALTER TABLE `td_comparison` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_comparison_items` -- ALTER TABLE `td_comparison_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_content_list` -- ALTER TABLE `td_content_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_content_parts` -- ALTER TABLE `td_content_parts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_forms` -- ALTER TABLE `td_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_form_questions` -- ALTER TABLE `td_form_questions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_groupcoi_users` -- ALTER TABLE `td_groupcoi_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_group_coi` -- ALTER TABLE `td_group_coi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_group_coi_user_count` -- ALTER TABLE `td_group_coi_user_count` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_log` -- ALTER TABLE `td_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_open_tender` -- ALTER TABLE `td_open_tender` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_suppliers` -- ALTER TABLE `td_suppliers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_templates` -- ALTER TABLE `td_templates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_tenders` -- ALTER TABLE `td_tenders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_tender_coi_history` -- ALTER TABLE `td_tender_coi_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_user_coi` -- ALTER TABLE `td_user_coi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `timeslot_sets` -- ALTER TABLE `timeslot_sets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `time_slots` -- ALTER TABLE `time_slots` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `users_cpd` -- ALTER TABLE `users_cpd` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users_group` -- ALTER TABLE `users_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users_roles` -- ALTER TABLE `users_roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `venues` -- ALTER TABLE `venues` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `venue_group` -- ALTER TABLE `venue_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_filled_form` -- ALTER TABLE `wf_filled_form` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_form_answers` -- ALTER TABLE `wf_form_answers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_form_status` -- ALTER TABLE `wf_form_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_form_workflow` -- ALTER TABLE `wf_form_workflow` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_workflow` -- ALTER TABLE `wf_workflow` 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.15 |
proxy
|
phpinfo
|
Settings