File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/tools/backup.sql
Back
-- MySQL dump 10.16 Distrib 10.1.37-MariaDB, for Win32 (AMD64) -- -- Host: localhost Database: camplus -- ------------------------------------------------------ -- Server version 10.1.37-MariaDB /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `ac_cmd` -- DROP TABLE IF EXISTS `ac_cmd`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ac_cmd` ( `id` int(11) NOT NULL AUTO_INCREMENT, `devID` int(11) NOT NULL, `cmd` text COLLATE utf8_unicode_ci NOT NULL, `ttl` int(11) NOT NULL, `time` int(11) NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ac_cmd` -- LOCK TABLES `ac_cmd` WRITE; /*!40000 ALTER TABLE `ac_cmd` DISABLE KEYS */; /*!40000 ALTER TABLE `ac_cmd` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ac_devices` -- DROP TABLE IF EXISTS `ac_devices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ac_devices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ac_devices` -- LOCK TABLES `ac_devices` WRITE; /*!40000 ALTER TABLE `ac_devices` DISABLE KEYS */; /*!40000 ALTER TABLE `ac_devices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ac_receiver` -- DROP TABLE IF EXISTS `ac_receiver`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ac_receiver` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ac_receiver` -- LOCK TABLES `ac_receiver` WRITE; /*!40000 ALTER TABLE `ac_receiver` DISABLE KEYS */; /*!40000 ALTER TABLE `ac_receiver` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ac_record` -- DROP TABLE IF EXISTS `ac_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ac_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ac_record` -- LOCK TABLES `ac_record` WRITE; /*!40000 ALTER TABLE `ac_record` DISABLE KEYS */; /*!40000 ALTER TABLE `ac_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ac_whitelist` -- DROP TABLE IF EXISTS `ac_whitelist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ac_whitelist` ( `id` int(11) NOT NULL AUTO_INCREMENT, `card` int(11) NOT NULL, `dev_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ac_whitelist` -- LOCK TABLES `ac_whitelist` WRITE; /*!40000 ALTER TABLE `ac_whitelist` DISABLE KEYS */; /*!40000 ALTER TABLE `ac_whitelist` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `academic_years` -- DROP TABLE IF EXISTS `academic_years`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `academic_years` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `year_start` date NOT NULL, `year_end` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `academic_years` -- LOCK TABLES `academic_years` WRITE; /*!40000 ALTER TABLE `academic_years` DISABLE KEYS */; INSERT INTO `academic_years` VALUES (1,'2017-18','2017-09-01','2018-09-01'),(2,'2018-2019','2018-09-01','2019-08-31'),(3,'2019-2020','2019-02-01','2019-02-22'); /*!40000 ALTER TABLE `academic_years` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_answer` -- DROP TABLE IF EXISTS `ap_answer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_answer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ff_id` int(11) NOT NULL, `a_key` text COLLATE utf8_unicode_ci NOT NULL, `answer` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_answer` -- LOCK TABLES `ap_answer` WRITE; /*!40000 ALTER TABLE `ap_answer` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_answer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_deprecated_user_has_educations` -- DROP TABLE IF EXISTS `ap_deprecated_user_has_educations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_deprecated_user_has_educations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_deprecated_user_has_educations` -- LOCK TABLES `ap_deprecated_user_has_educations` WRITE; /*!40000 ALTER TABLE `ap_deprecated_user_has_educations` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_deprecated_user_has_educations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_filled_form` -- DROP TABLE IF EXISTS `ap_filled_form`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_filled_form` ( `id` int(11) NOT NULL AUTO_INCREMENT, `form` int(11) NOT NULL, `appraiser` int(11) NOT NULL, `appraisee` int(11) NOT NULL, `unit` int(11) NOT NULL, `answer` mediumtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_filled_form` -- LOCK TABLES `ap_filled_form` WRITE; /*!40000 ALTER TABLE `ap_filled_form` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_filled_form` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_form` -- DROP TABLE IF EXISTS `ap_form`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_form` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text COLLATE utf8_unicode_ci NOT NULL, `uid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_form` -- LOCK TABLES `ap_form` WRITE; /*!40000 ALTER TABLE `ap_form` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_form` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_form_section_unit` -- DROP TABLE IF EXISTS `ap_form_section_unit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_form_section_unit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text COLLATE utf8_unicode_ci NOT NULL, `section` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_form_section_unit` -- LOCK TABLES `ap_form_section_unit` WRITE; /*!40000 ALTER TABLE `ap_form_section_unit` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_form_section_unit` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_form_section_unit_user` -- DROP TABLE IF EXISTS `ap_form_section_unit_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_form_section_unit_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `type` enum('HEAD','MEMBER','RELATED') COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_form_section_unit_user` -- LOCK TABLES `ap_form_section_unit_user` WRITE; /*!40000 ALTER TABLE `ap_form_section_unit_user` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_form_section_unit_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_form_section_user` -- DROP TABLE IF EXISTS `ap_form_section_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_form_section_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `status` enum('SUBMITTED','RELEASED') COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_form_section_user` -- LOCK TABLES `ap_form_section_user` WRITE; /*!40000 ALTER TABLE `ap_form_section_user` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_form_section_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_form_sections` -- DROP TABLE IF EXISTS `ap_form_sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_form_sections` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, `sign` tinyint(4) NOT NULL DEFAULT '0', `weight` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_form_sections` -- LOCK TABLES `ap_form_sections` WRITE; /*!40000 ALTER TABLE `ap_form_sections` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_form_sections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_form_sign` -- DROP TABLE IF EXISTS `ap_form_sign`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_form_sign` ( `id` int(11) NOT NULL AUTO_INCREMENT, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `counter` int(11) NOT NULL, `signature` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_form_sign` -- LOCK TABLES `ap_form_sign` WRITE; /*!40000 ALTER TABLE `ap_form_sign` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_form_sign` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ap_oa` -- DROP TABLE IF EXISTS `ap_oa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ap_oa` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ap_form` int(11) NOT NULL, `appraisee` int(11) NOT NULL, `oa` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ap_oa` -- LOCK TABLES `ap_oa` WRITE; /*!40000 ALTER TABLE `ap_oa` DISABLE KEYS */; /*!40000 ALTER TABLE `ap_oa` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assets` -- DROP TABLE IF EXISTS `assets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assets` ( `id` int(10) NOT NULL AUTO_INCREMENT, `asset_tag` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `model` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `status` enum('ARCHIVED','ACTIVE') DEFAULT NULL, `serial` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `asset_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `purchase_date` date DEFAULT NULL, `supplier_id` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `quantity` smallint(10) DEFAULT NULL, `purchase_cost` int(10) DEFAULT NULL, `warranty` tinyint(3) DEFAULT NULL, `venue_id` varchar(10) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assets` -- LOCK TABLES `assets` WRITE; /*!40000 ALTER TABLE `assets` DISABLE KEYS */; INSERT INTO `assets` VALUES (5,'9781234567893','Macbook 2017','ACTIVE','66778899','Art macbook','2019-01-07','2',1,555,12,'1'),(6,'9781234567891','iPad','ACTIVE','1122344','iPad for Stem','2019-01-01','1',1,12000,12,'1'),(7,'9781234567892','iPad Pro 9.7','ARCHIVED','445566778','iPad for classroom','2019-02-02','7',1,22,34,'2'); /*!40000 ALTER TABLE `assets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_attendance_report` -- DROP TABLE IF EXISTS `at_attendance_report`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_attendance_report` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_attendance_report` -- LOCK TABLES `at_attendance_report` WRITE; /*!40000 ALTER TABLE `at_attendance_report` DISABLE KEYS */; /*!40000 ALTER TABLE `at_attendance_report` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_attendance_rule_dates` -- DROP TABLE IF EXISTS `at_attendance_rule_dates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_attendance_rule_dates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `arp_id` int(11) NOT NULL, `day` varchar(12) NOT NULL, `da_id` int(11) NOT NULL, `uid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_attendance_rule_dates` -- LOCK TABLES `at_attendance_rule_dates` WRITE; /*!40000 ALTER TABLE `at_attendance_rule_dates` DISABLE KEYS */; /*!40000 ALTER TABLE `at_attendance_rule_dates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_attendance_rule_period` -- DROP TABLE IF EXISTS `at_attendance_rule_period`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_attendance_rule_period` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_attendance_rule_period` -- LOCK TABLES `at_attendance_rule_period` WRITE; /*!40000 ALTER TABLE `at_attendance_rule_period` DISABLE KEYS */; /*!40000 ALTER TABLE `at_attendance_rule_period` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_daily_attendance` -- DROP TABLE IF EXISTS `at_daily_attendance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_daily_attendance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rule_name` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_daily_attendance` -- LOCK TABLES `at_daily_attendance` WRITE; /*!40000 ALTER TABLE `at_daily_attendance` DISABLE KEYS */; /*!40000 ALTER TABLE `at_daily_attendance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_daily_attendance_timeset` -- DROP TABLE IF EXISTS `at_daily_attendance_timeset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_daily_attendance_timeset` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_daily_attendance_timeset` -- LOCK TABLES `at_daily_attendance_timeset` WRITE; /*!40000 ALTER TABLE `at_daily_attendance_timeset` DISABLE KEYS */; /*!40000 ALTER TABLE `at_daily_attendance_timeset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_record` -- DROP TABLE IF EXISTS `at_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `card` int(11) NOT NULL, `cr_id` text COLLATE utf8_unicode_ci, `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_record` -- LOCK TABLES `at_record` WRITE; /*!40000 ALTER TABLE `at_record` DISABLE KEYS */; /*!40000 ALTER TABLE `at_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_special_attendance` -- DROP TABLE IF EXISTS `at_special_attendance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_special_attendance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `sat_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_special_attendance` -- LOCK TABLES `at_special_attendance` WRITE; /*!40000 ALTER TABLE `at_special_attendance` DISABLE KEYS */; /*!40000 ALTER TABLE `at_special_attendance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_special_attendance_timeset` -- DROP TABLE IF EXISTS `at_special_attendance_timeset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_special_attendance_timeset` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_special_attendance_timeset` -- LOCK TABLES `at_special_attendance_timeset` WRITE; /*!40000 ALTER TABLE `at_special_attendance_timeset` DISABLE KEYS */; /*!40000 ALTER TABLE `at_special_attendance_timeset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_user_card` -- DROP TABLE IF EXISTS `at_user_card`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_user_card` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `card` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_user_card` -- LOCK TABLES `at_user_card` WRITE; /*!40000 ALTER TABLE `at_user_card` DISABLE KEYS */; /*!40000 ALTER TABLE `at_user_card` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `at_user_time_rule_set` -- DROP TABLE IF EXISTS `at_user_time_rule_set`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `at_user_time_rule_set` ( `id` int(11) NOT NULL AUTO_INCREMENT, `arp_id` int(11) NOT NULL, `every_day` varchar(12) NOT NULL, `da_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `at_user_time_rule_set` -- LOCK TABLES `at_user_time_rule_set` WRITE; /*!40000 ALTER TABLE `at_user_time_rule_set` DISABLE KEYS */; /*!40000 ALTER TABLE `at_user_time_rule_set` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ay_terms` -- DROP TABLE IF EXISTS `ay_terms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ay_terms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ay_id` int(11) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `code` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ay_terms` -- LOCK TABLES `ay_terms` WRITE; /*!40000 ALTER TABLE `ay_terms` DISABLE KEYS */; INSERT INTO `ay_terms` VALUES (1,2,'1718 Final','1718_final'),(2,2,'1819 Final','1819_final'); /*!40000 ALTER TABLE `ay_terms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calendar_type` -- DROP TABLE IF EXISTS `calendar_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calendar_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calendar_type` -- LOCK TABLES `calendar_type` WRITE; /*!40000 ALTER TABLE `calendar_type` DISABLE KEYS */; /*!40000 ALTER TABLE `calendar_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calendar_type_has_forms` -- DROP TABLE IF EXISTS `calendar_type_has_forms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calendar_type_has_forms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `calendar_type_id` int(11) NOT NULL, `form_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calendar_type_has_forms` -- LOCK TABLES `calendar_type_has_forms` WRITE; /*!40000 ALTER TABLE `calendar_type_has_forms` DISABLE KEYS */; /*!40000 ALTER TABLE `calendar_type_has_forms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `circular_templates` -- DROP TABLE IF EXISTS `circular_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `circular_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `circular_templates` -- LOCK TABLES `circular_templates` WRITE; /*!40000 ALTER TABLE `circular_templates` DISABLE KEYS */; /*!40000 ALTER TABLE `circular_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `circulars` -- DROP TABLE IF EXISTS `circulars`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `circulars` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `circulars` -- LOCK TABLES `circulars` WRITE; /*!40000 ALTER TABLE `circulars` DISABLE KEYS */; /*!40000 ALTER TABLE `circulars` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dooreventlog` -- DROP TABLE IF EXISTS `dooreventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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 AUTO_INCREMENT, `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`event_id`), KEY `cardReaderID` (`cardReaderID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dooreventlog` -- LOCK TABLES `dooreventlog` WRITE; /*!40000 ALTER TABLE `dooreventlog` DISABLE KEYS */; /*!40000 ALTER TABLE `dooreventlog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `eb_facilities` -- DROP TABLE IF EXISTS `eb_facilities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `eb_facilities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `eb_facilities` -- LOCK TABLES `eb_facilities` WRITE; /*!40000 ALTER TABLE `eb_facilities` DISABLE KEYS */; INSERT INTO `eb_facilities` VALUES (1,1,1,1,2); /*!40000 ALTER TABLE `eb_facilities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `eb_settings` -- DROP TABLE IF EXISTS `eb_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `eb_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `val` text CHARACTER SET utf8, PRIMARY KEY (`id`), UNIQUE KEY `SETTING_KEY_UNIQUE` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `eb_settings` -- LOCK TABLES `eb_settings` WRITE; /*!40000 ALTER TABLE `eb_settings` DISABLE KEYS */; INSERT INTO `eb_settings` VALUES (1,'grey_out_past_events','s:1:\"0\";'),(2,'facility','s:1:\"1\";'),(3,'venue','s:1:\"1\";'),(4,'participant','s:1:\"1\";'),(5,'form','s:1:\"1\";'),(6,'circular','s:1:\"1\";'),(7,'apply_for_others','s:1:\"1\";'),(8,'check_conflict_for_draft_events','s:1:\"0\";'),(9,'show_draft_on_calendar','s:1:\"0\";'),(10,'week_start','s:6:\"Sunday\";'),(11,'date_format','s:0:\"\";'); /*!40000 ALTER TABLE `eb_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `eb_time_slots` -- DROP TABLE IF EXISTS `eb_time_slots`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `eb_time_slots` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `eb_time_slots` -- LOCK TABLES `eb_time_slots` WRITE; /*!40000 ALTER TABLE `eb_time_slots` DISABLE KEYS */; /*!40000 ALTER TABLE `eb_time_slots` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `eb_venues` -- DROP TABLE IF EXISTS `eb_venues`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `eb_venues` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `eb_venues` -- LOCK TABLES `eb_venues` WRITE; /*!40000 ALTER TABLE `eb_venues` DISABLE KEYS */; INSERT INTO `eb_venues` VALUES (1,1,1,0,0),(2,2,1,0,0); /*!40000 ALTER TABLE `eb_venues` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_forms_history` -- DROP TABLE IF EXISTS `event_forms_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_forms_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_forms_history` -- LOCK TABLES `event_forms_history` WRITE; /*!40000 ALTER TABLE `event_forms_history` DISABLE KEYS */; /*!40000 ALTER TABLE `event_forms_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_has_files` -- DROP TABLE IF EXISTS `event_has_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_has_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `event_id` int(11) NOT NULL, `file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_has_files` -- LOCK TABLES `event_has_files` WRITE; /*!40000 ALTER TABLE `event_has_files` DISABLE KEYS */; /*!40000 ALTER TABLE `event_has_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_has_forms` -- DROP TABLE IF EXISTS `event_has_forms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_has_forms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_has_forms` -- LOCK TABLES `event_has_forms` WRITE; /*!40000 ALTER TABLE `event_has_forms` DISABLE KEYS */; /*!40000 ALTER TABLE `event_has_forms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_has_sections` -- DROP TABLE IF EXISTS `event_has_sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_has_sections` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), KEY `event_id` (`event_id`), KEY `startDate` (`startDate`), KEY `from_time` (`from_time`), KEY `to_time` (`to_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_has_sections` -- LOCK TABLES `event_has_sections` WRITE; /*!40000 ALTER TABLE `event_has_sections` DISABLE KEYS */; /*!40000 ALTER TABLE `event_has_sections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_section_has_facilities` -- DROP TABLE IF EXISTS `event_section_has_facilities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_section_has_facilities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `section_id` int(11) NOT NULL, `facility_id` int(11) NOT NULL, `status` enum('PENDING','APPROVED') COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `section_id` (`section_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_section_has_facilities` -- LOCK TABLES `event_section_has_facilities` WRITE; /*!40000 ALTER TABLE `event_section_has_facilities` DISABLE KEYS */; /*!40000 ALTER TABLE `event_section_has_facilities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_section_has_participants` -- DROP TABLE IF EXISTS `event_section_has_participants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_section_has_participants` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), KEY `section_id` (`section_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_section_has_participants` -- LOCK TABLES `event_section_has_participants` WRITE; /*!40000 ALTER TABLE `event_section_has_participants` DISABLE KEYS */; /*!40000 ALTER TABLE `event_section_has_participants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_section_has_venues` -- DROP TABLE IF EXISTS `event_section_has_venues`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_section_has_venues` ( `id` int(11) NOT NULL AUTO_INCREMENT, `section_id` int(11) NOT NULL, `venue_id` int(11) NOT NULL, `other` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` enum('PENDING','REJECTED','APPROVED') COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `section_id` (`section_id`), KEY `venue_id` (`venue_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_section_has_venues` -- LOCK TABLES `event_section_has_venues` WRITE; /*!40000 ALTER TABLE `event_section_has_venues` DISABLE KEYS */; /*!40000 ALTER TABLE `event_section_has_venues` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_types` -- DROP TABLE IF EXISTS `event_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_types` -- LOCK TABLES `event_types` WRITE; /*!40000 ALTER TABLE `event_types` DISABLE KEYS */; /*!40000 ALTER TABLE `event_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `events` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), KEY `status` (`status`), KEY `calendar_type_id` (`calendar_type_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `events` -- LOCK TABLES `events` WRITE; /*!40000 ALTER TABLE `events` DISABLE KEYS */; INSERT INTO `events` VALUES (1,'Demo Events',1,0,1,'','a:13:{s:11:\"event_title\";s:11:\"Demo Events\";s:16:\"calendar_type_id\";s:1:\"1\";s:17:\"teacher_in_charge\";s:5:\"admin\";s:6:\"status\";s:5:\"DRAFT\";s:8:\"samePage\";s:1:\"0\";s:9:\"startDate\";a:1:{i:1;s:8:\"9/3/2018\";}s:9:\"from_time\";a:1:{i:1;a:1:{i:1;s:5:\"19:40\";}}s:7:\"to_time\";a:1:{i:1;a:1:{i:1;s:5:\"20:40\";}}s:6:\"venues\";a:1:{i:1;a:1:{i:0;s:1:\"0\";}}s:10:\"venueOther\";a:1:{i:1;s:0:\"\";}s:12:\"participants\";a:1:{i:1;a:1:{i:0;s:3:\"0-0\";}}s:16:\"participantOther\";a:1:{i:1;s:0:\"\";}s:6:\"remark\";s:0:\"\";}','PUBLISHED','2018-03-25 19:37:19'),(2,'Testing 2',1,0,1,'','a:13:{s:11:\"event_title\";s:9:\"Testing 2\";s:16:\"calendar_type_id\";s:1:\"1\";s:17:\"teacher_in_charge\";s:5:\"admin\";s:6:\"status\";s:5:\"DRAFT\";s:8:\"samePage\";s:1:\"0\";s:9:\"startDate\";a:1:{i:1;s:54:\"1/3/2018,2/3/2018,5/3/2018,8/3/2018,22/3/2018,5/4/2018\";}s:9:\"from_time\";a:1:{i:1;a:1:{i:1;s:5:\"19:15\";}}s:7:\"to_time\";a:1:{i:1;a:1:{i:1;s:5:\"20:15\";}}s:6:\"venues\";a:1:{i:1;a:1:{i:0;s:1:\"0\";}}s:10:\"venueOther\";a:1:{i:1;s:0:\"\";}s:12:\"participants\";a:1:{i:1;a:1:{i:0;s:3:\"0-0\";}}s:16:\"participantOther\";a:1:{i:1;s:0:\"\";}s:6:\"remark\";s:0:\"\";}','PUBLISHED','2018-03-25 20:12:55'),(3,'test for conflict',1,0,1,'','a:13:{s:8:\"event_id\";s:1:\"3\";s:11:\"event_title\";s:17:\"test for conflict\";s:16:\"calendar_type_id\";s:1:\"1\";s:17:\"teacher_in_charge\";s:5:\"admin\";s:6:\"status\";s:5:\"DRAFT\";s:8:\"samePage\";s:1:\"0\";s:9:\"startDate\";a:1:{i:1;s:9:\"21/4/2018\";}s:9:\"from_time\";a:1:{i:1;a:1:{i:1;s:4:\"1:45\";}}s:7:\"to_time\";a:1:{i:1;a:1:{i:1;s:4:\"2:45\";}}s:6:\"venues\";a:1:{i:1;a:1:{i:0;s:1:\"1\";}}s:10:\"venueOther\";a:1:{i:1;s:0:\"\";}s:16:\"participantOther\";a:1:{i:1;s:0:\"\";}s:6:\"remark\";s:0:\"\";}','PUBLISHED','2018-04-02 02:30:43'),(4,'test for conflict 2',1,0,1,'','a:13:{s:8:\"event_id\";s:1:\"4\";s:11:\"event_title\";s:19:\"test for conflict 2\";s:16:\"calendar_type_id\";s:1:\"1\";s:17:\"teacher_in_charge\";s:5:\"admin\";s:6:\"status\";s:5:\"DRAFT\";s:8:\"samePage\";s:1:\"0\";s:9:\"startDate\";a:1:{i:1;s:9:\"21/4/2018\";}s:9:\"from_time\";a:1:{i:1;a:1:{i:1;s:4:\"2:45\";}}s:7:\"to_time\";a:1:{i:1;a:1:{i:1;s:4:\"3:20\";}}s:6:\"venues\";a:1:{i:1;a:1:{i:0;s:1:\"1\";}}s:10:\"venueOther\";a:1:{i:1;s:0:\"\";}s:16:\"participantOther\";a:1:{i:1;s:0:\"\";}s:6:\"remark\";s:0:\"\";}','PUBLISHED','2018-04-02 02:31:07'),(5,'test',1,0,2,'','a:13:{s:8:\"event_id\";s:1:\"5\";s:11:\"event_title\";s:4:\"test\";s:16:\"calendar_type_id\";s:1:\"1\";s:17:\"teacher_in_charge\";s:5:\"user1\";s:6:\"status\";s:5:\"DRAFT\";s:8:\"samePage\";s:1:\"0\";s:9:\"startDate\";a:1:{i:1;s:8:\"1/6/2018\";}s:9:\"from_time\";a:1:{i:1;a:1:{i:1;s:5:\"20:35\";}}s:7:\"to_time\";a:1:{i:1;a:1:{i:1;s:5:\"22:35\";}}s:6:\"venues\";a:1:{i:1;a:1:{i:0;s:1:\"2\";}}s:10:\"venueOther\";a:1:{i:1;s:0:\"\";}s:16:\"participantOther\";a:1:{i:1;s:0:\"\";}s:6:\"remark\";s:0:\"\";}','PUBLISHED','2018-05-23 22:38:45'),(6,'tewt',1,0,1,'','a:12:{s:11:\"event_title\";s:4:\"tewt\";s:16:\"calendar_type_id\";s:1:\"1\";s:17:\"teacher_in_charge\";s:5:\"admin\";s:6:\"status\";s:5:\"DRAFT\";s:8:\"samePage\";s:1:\"0\";s:9:\"startDate\";a:1:{i:1;s:9:\"20/6/2018\";}s:9:\"from_time\";a:1:{i:1;a:1:{i:1;s:5:\"12:25\";}}s:7:\"to_time\";a:1:{i:1;a:1:{i:1;s:5:\"15:25\";}}s:6:\"venues\";a:1:{i:1;a:1:{i:0;s:1:\"1\";}}s:10:\"venueOther\";a:1:{i:1;s:0:\"\";}s:16:\"participantOther\";a:1:{i:1;s:0:\"\";}s:6:\"remark\";s:0:\"\";}','PUBLISHED','2018-06-23 12:25:46'),(7,'Meeting',1,0,1,'','a:12:{s:11:\"event_title\";s:7:\"Meeting\";s:16:\"calendar_type_id\";s:1:\"1\";s:17:\"teacher_in_charge\";s:5:\"admin\";s:6:\"status\";s:5:\"DRAFT\";s:8:\"samePage\";s:1:\"0\";s:9:\"startDate\";a:1:{i:1;s:128:\"29/10/2018,30/10/2018,31/10/2018,1/11/2018,6/11/2018,9/11/2018,13/11/2018,16/11/2018,20/11/2018,23/11/2018,27/11/2018,30/11/2018\";}s:9:\"from_time\";a:1:{i:1;a:1:{i:1;s:4:\"9:25\";}}s:7:\"to_time\";a:1:{i:1;a:1:{i:1;s:5:\"13:25\";}}s:6:\"venues\";a:1:{i:1;a:1:{i:0;s:1:\"1\";}}s:10:\"venueOther\";a:1:{i:1;s:0:\"\";}s:16:\"participantOther\";a:1:{i:1;s:0:\"\";}s:6:\"remark\";s:0:\"\";}','PUBLISHED','2018-11-05 13:22:49'); /*!40000 ALTER TABLE `events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `facilities` -- DROP TABLE IF EXISTS `facilities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `facilities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `facilities` -- LOCK TABLES `facilities` WRITE; /*!40000 ALTER TABLE `facilities` DISABLE KEYS */; INSERT INTO `facilities` VALUES (1,'iPAD',1,'',0); /*!40000 ALTER TABLE `facilities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `form` -- DROP TABLE IF EXISTS `form`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `form` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `form` -- LOCK TABLES `form` WRITE; /*!40000 ALTER TABLE `form` DISABLE KEYS */; /*!40000 ALTER TABLE `form` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `form_answer_has_grid` -- DROP TABLE IF EXISTS `form_answer_has_grid`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `form_answer_has_grid` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `form_answer_has_grid` -- LOCK TABLES `form_answer_has_grid` WRITE; /*!40000 ALTER TABLE `form_answer_has_grid` DISABLE KEYS */; /*!40000 ALTER TABLE `form_answer_has_grid` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `form_answer_has_table` -- DROP TABLE IF EXISTS `form_answer_has_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `form_answer_has_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `form_answer_has_table` -- LOCK TABLES `form_answer_has_table` WRITE; /*!40000 ALTER TABLE `form_answer_has_table` DISABLE KEYS */; /*!40000 ALTER TABLE `form_answer_has_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `form_answers` -- DROP TABLE IF EXISTS `form_answers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `form_answers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `form_answers` -- LOCK TABLES `form_answers` WRITE; /*!40000 ALTER TABLE `form_answers` DISABLE KEYS */; /*!40000 ALTER TABLE `form_answers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `form_has_questions` -- DROP TABLE IF EXISTS `form_has_questions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `form_has_questions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `form_has_questions` -- LOCK TABLES `form_has_questions` WRITE; /*!40000 ALTER TABLE `form_has_questions` DISABLE KEYS */; INSERT INTO `form_has_questions` VALUES (1,'Question',1,'Answer','SINGLE_LINE',0,'',1,'2018-04-02 15:34:08','','',0); /*!40000 ALTER TABLE `form_has_questions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `form_question_has_options` -- DROP TABLE IF EXISTS `form_question_has_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `form_question_has_options` ( `id` int(11) NOT NULL AUTO_INCREMENT, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `form_question_has_options` -- LOCK TABLES `form_question_has_options` WRITE; /*!40000 ALTER TABLE `form_question_has_options` DISABLE KEYS */; /*!40000 ALTER TABLE `form_question_has_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `form_question_has_questions` -- DROP TABLE IF EXISTS `form_question_has_questions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `form_question_has_questions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `form_question_has_questions` -- LOCK TABLES `form_question_has_questions` WRITE; /*!40000 ALTER TABLE `form_question_has_questions` DISABLE KEYS */; /*!40000 ALTER TABLE `form_question_has_questions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `form_question_has_token` -- DROP TABLE IF EXISTS `form_question_has_token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `form_question_has_token` ( `id` int(11) NOT NULL AUTO_INCREMENT, `question_id` int(11) NOT NULL, `token` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `form_question_has_token` -- LOCK TABLES `form_question_has_token` WRITE; /*!40000 ALTER TABLE `form_question_has_token` DISABLE KEYS */; INSERT INTO `form_question_has_token` VALUES (1,1,''); /*!40000 ALTER TABLE `form_question_has_token` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `forms` -- DROP TABLE IF EXISTS `forms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `forms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `forms` -- LOCK TABLES `forms` WRITE; /*!40000 ALTER TABLE `forms` DISABLE KEYS */; INSERT INTO `forms` VALUES (1,'Test form 1',0,NULL,0,2); /*!40000 ALTER TABLE `forms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `groups` -- DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `parent` int(11) DEFAULT NULL, `enabled` tinyint(1) NOT NULL, `weight` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `groups` -- LOCK TABLES `groups` WRITE; /*!40000 ALTER TABLE `groups` DISABLE KEYS */; /*!40000 ALTER TABLE `groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `holiday` -- DROP TABLE IF EXISTS `holiday`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `holiday` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `holiday` -- LOCK TABLES `holiday` WRITE; /*!40000 ALTER TABLE `holiday` DISABLE KEYS */; /*!40000 ALTER TABLE `holiday` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `iv_record` -- DROP TABLE IF EXISTS `iv_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `iv_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `asset_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `event` enum('CHECKOUT','AUDIT','CHANGE_VENUE') COLLATE utf8_unicode_ci NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `venue_id` int(11) NOT NULL, `quantity` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `iv_record` -- LOCK TABLES `iv_record` WRITE; /*!40000 ALTER TABLE `iv_record` DISABLE KEYS */; INSERT INTO `iv_record` VALUES (1,1,1,'AUDIT','2018-12-31 14:49:05',1,0),(17,3,1,'AUDIT','2019-01-07 12:21:24',1,1),(18,3,1,'CHECKOUT','2019-01-07 14:36:43',1,1),(19,4,1,'CHECKOUT','2019-01-07 14:36:43',2,1),(21,5,1,'AUDIT','2019-01-07 05:47:45',2,1),(29,5,1,'CHANGE_VENUE','2019-01-08 08:01:33',2,1),(30,6,1,'CHANGE_VENUE','2019-01-08 08:01:55',2,1),(31,6,1,'CHANGE_VENUE','2019-01-08 08:02:32',1,1),(32,6,1,'CHANGE_VENUE','2019-01-08 08:02:54',2,1),(33,7,1,'AUDIT','2019-01-08 08:25:38',2,1),(34,6,1,'CHECKOUT','2019-01-08 08:27:23',1,1),(35,7,1,'CHECKOUT','2019-01-08 08:27:23',2,1),(36,8,1,'CHECKOUT','2019-04-08 13:51:33',1,2); /*!40000 ALTER TABLE `iv_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `licenses` -- DROP TABLE IF EXISTS `licenses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `licenses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text COLLATE utf8_unicode_ci NOT NULL, `category_name` text COLLATE utf8_unicode_ci NOT NULL, `product_key` text COLLATE utf8_unicode_ci NOT NULL, `seats` int(11) NOT NULL, `company` text COLLATE utf8_unicode_ci NOT NULL, `manufacturer_id` int(11) NOT NULL, `licensed_to_name` text COLLATE utf8_unicode_ci NOT NULL, `licensed_to_email` text COLLATE utf8_unicode_ci NOT NULL, `reassignable` tinyint(4) NOT NULL, `supplier_id` int(11) NOT NULL, `order_number` text COLLATE utf8_unicode_ci NOT NULL, `purchase_cost` float NOT NULL, `purchase_date` date NOT NULL, `expiration_date` date NOT NULL, `termination_date` date NOT NULL, `purchase_order_number` text COLLATE utf8_unicode_ci NOT NULL, `depreciation` text COLLATE utf8_unicode_ci NOT NULL, `maintained` tinyint(4) NOT NULL, `notes` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `licenses` -- LOCK TABLES `licenses` WRITE; /*!40000 ALTER TABLE `licenses` DISABLE KEYS */; /*!40000 ALTER TABLE `licenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_approval_group` -- DROP TABLE IF EXISTS `ls_approval_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_approval_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_approval_group` -- LOCK TABLES `ls_approval_group` WRITE; /*!40000 ALTER TABLE `ls_approval_group` DISABLE KEYS */; INSERT INTO `ls_approval_group` VALUES (1,'users'); /*!40000 ALTER TABLE `ls_approval_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_approval_group_level` -- DROP TABLE IF EXISTS `ls_approval_group_level`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_approval_group_level` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `level` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_approval_group_level` -- LOCK TABLES `ls_approval_group_level` WRITE; /*!40000 ALTER TABLE `ls_approval_group_level` DISABLE KEYS */; INSERT INTO `ls_approval_group_level` VALUES (3,1,1,1),(4,1,4,2),(5,1,2,3); /*!40000 ALTER TABLE `ls_approval_group_level` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_approval_group_user` -- DROP TABLE IF EXISTS `ls_approval_group_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_approval_group_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ag_id` int(11) NOT NULL, `uid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_approval_group_user` -- LOCK TABLES `ls_approval_group_user` WRITE; /*!40000 ALTER TABLE `ls_approval_group_user` DISABLE KEYS */; INSERT INTO `ls_approval_group_user` VALUES (8,1,1),(9,1,2),(10,1,3),(11,1,5); /*!40000 ALTER TABLE `ls_approval_group_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_approval_record` -- DROP TABLE IF EXISTS `ls_approval_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_approval_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_approval_record` -- LOCK TABLES `ls_approval_record` WRITE; /*!40000 ALTER TABLE `ls_approval_record` DISABLE KEYS */; /*!40000 ALTER TABLE `ls_approval_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_class_substitution` -- DROP TABLE IF EXISTS `ls_class_substitution`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_class_substitution` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_class_substitution` -- LOCK TABLES `ls_class_substitution` WRITE; /*!40000 ALTER TABLE `ls_class_substitution` DISABLE KEYS */; /*!40000 ALTER TABLE `ls_class_substitution` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_entitlement` -- DROP TABLE IF EXISTS `ls_entitlement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_entitlement` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_entitlement` -- LOCK TABLES `ls_entitlement` WRITE; /*!40000 ALTER TABLE `ls_entitlement` DISABLE KEYS */; /*!40000 ALTER TABLE `ls_entitlement` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_it_weight` -- DROP TABLE IF EXISTS `ls_it_weight`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_it_weight` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lt_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `weight` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_it_weight` -- LOCK TABLES `ls_it_weight` WRITE; /*!40000 ALTER TABLE `ls_it_weight` DISABLE KEYS */; /*!40000 ALTER TABLE `ls_it_weight` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_leave_application` -- DROP TABLE IF EXISTS `ls_leave_application`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_leave_application` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_leave_application` -- LOCK TABLES `ls_leave_application` WRITE; /*!40000 ALTER TABLE `ls_leave_application` DISABLE KEYS */; /*!40000 ALTER TABLE `ls_leave_application` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_leave_type` -- DROP TABLE IF EXISTS `ls_leave_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_leave_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_leave_type` -- LOCK TABLES `ls_leave_type` WRITE; /*!40000 ALTER TABLE `ls_leave_type` DISABLE KEYS */; INSERT INTO `ls_leave_type` VALUES (1,'Sick Leave','PSL','#000000',1,1); /*!40000 ALTER TABLE `ls_leave_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ls_user_marks` -- DROP TABLE IF EXISTS `ls_user_marks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ls_user_marks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `marks` int(11) NOT NULL, `type` enum('Class','Duty') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ls_user_marks` -- LOCK TABLES `ls_user_marks` WRITE; /*!40000 ALTER TABLE `ls_user_marks` DISABLE KEYS */; /*!40000 ALTER TABLE `ls_user_marks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `manufacturers` -- DROP TABLE IF EXISTS `manufacturers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `manufacturers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `manufacturer` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `manufacturers` -- LOCK TABLES `manufacturers` WRITE; /*!40000 ALTER TABLE `manufacturers` DISABLE KEYS */; INSERT INTO `manufacturers` VALUES (1,'Apple'); /*!40000 ALTER TABLE `manufacturers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `msg_messages` -- DROP TABLE IF EXISTS `msg_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `msg_messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `msg_messages` -- LOCK TABLES `msg_messages` WRITE; /*!40000 ALTER TABLE `msg_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `msg_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `msg_participants` -- DROP TABLE IF EXISTS `msg_participants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `msg_participants` ( `user_id` int(11) NOT NULL, `thread_id` int(11) NOT NULL, `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`user_id`,`thread_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `msg_participants` -- LOCK TABLES `msg_participants` WRITE; /*!40000 ALTER TABLE `msg_participants` DISABLE KEYS */; /*!40000 ALTER TABLE `msg_participants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `msg_status` -- DROP TABLE IF EXISTS `msg_status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `msg_status` ( `message_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `status` int(2) NOT NULL, PRIMARY KEY (`message_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `msg_status` -- LOCK TABLES `msg_status` WRITE; /*!40000 ALTER TABLE `msg_status` DISABLE KEYS */; /*!40000 ALTER TABLE `msg_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `msg_threads` -- DROP TABLE IF EXISTS `msg_threads`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `msg_threads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `subject` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `msg_threads` -- LOCK TABLES `msg_threads` WRITE; /*!40000 ALTER TABLE `msg_threads` DISABLE KEYS */; /*!40000 ALTER TABLE `msg_threads` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notification` -- DROP TABLE IF EXISTS `notification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notification` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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','WF') COLLATE utf8_unicode_ci NOT NULL, `read` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notification` -- LOCK TABLES `notification` WRITE; /*!40000 ALTER TABLE `notification` DISABLE KEYS */; /*!40000 ALTER TABLE `notification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ot_approval_record` -- DROP TABLE IF EXISTS `ot_approval_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ot_approval_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ot_approval_record` -- LOCK TABLES `ot_approval_record` WRITE; /*!40000 ALTER TABLE `ot_approval_record` DISABLE KEYS */; /*!40000 ALTER TABLE `ot_approval_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ot_overtime` -- DROP TABLE IF EXISTS `ot_overtime`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ot_overtime` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ot_overtime` -- LOCK TABLES `ot_overtime` WRITE; /*!40000 ALTER TABLE `ot_overtime` DISABLE KEYS */; INSERT INTO `ot_overtime` VALUES (1,2,'2018-04-13','17:00:00','18:00:00',' test2','A',1),(2,1,'2018-04-05','12:05:00','13:05:00',' 1','R',1),(3,1,'2018-04-05','12:10:00','13:10:00',' test','A',1),(4,1,'2018-04-06','12:10:00','13:10:00',' ydry','R',1),(5,1,'2018-04-06','12:10:00','13:10:00',' te','R',1),(6,1,'2018-04-06','12:10:00','13:10:00',' yry','P',1),(7,1,'2018-08-15','20:25:00','20:25:00',' asd','P',1),(8,1,'2018-08-01','20:25:00','20:25:00',' qwe','P',1),(9,1,'2018-08-02','20:25:00','20:25:00',' qwe','P',1); /*!40000 ALTER TABLE `ot_overtime` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `participant_group` -- DROP TABLE IF EXISTS `participant_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `participant_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `participant_group` -- LOCK TABLES `participant_group` WRITE; /*!40000 ALTER TABLE `participant_group` DISABLE KEYS */; /*!40000 ALTER TABLE `participant_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `participants` -- DROP TABLE IF EXISTS `participants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `participants` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_enabled` tinyint(4) NOT NULL, `order` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `participants` -- LOCK TABLES `participants` WRITE; /*!40000 ALTER TABLE `participants` DISABLE KEYS */; /*!40000 ALTER TABLE `participants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `participants_has_groups` -- DROP TABLE IF EXISTS `participants_has_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `participants_has_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `participant_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `participants_has_groups` -- LOCK TABLES `participants_has_groups` WRITE; /*!40000 ALTER TABLE `participants_has_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `participants_has_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_approval_status` -- DROP TABLE IF EXISTS `pr_approval_status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_approval_status` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), KEY `purchase_request_id_idx` (`pr_id`), KEY `waiting_for_approval_by_idx` (`approval_role_id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_approval_status` -- LOCK TABLES `pr_approval_status` WRITE; /*!40000 ALTER TABLE `pr_approval_status` DISABLE KEYS */; INSERT INTO `pr_approval_status` VALUES (1,1,'draft',0,'2018-03-29 10:07:25'),(2,2,'completed',0,'2018-06-04 09:23:58'),(3,5,'approved',0,'2018-04-16 11:27:36'),(4,6,'approved',0,'2018-04-04 14:02:19'),(5,7,'approved',0,'2018-04-16 15:03:39'),(6,8,'approved',0,'2018-04-16 15:08:01'),(7,9,'approved',0,'2018-04-16 15:08:40'),(8,10,'approved',0,'2018-04-16 16:27:25'),(10,12,'pending',4,'2018-06-02 20:32:54'),(11,13,'draft',0,'2018-06-02 20:38:01'),(12,14,'pending',4,'2018-06-04 09:28:46'),(13,15,'draft',0,'2018-06-04 10:55:51'),(14,16,'pending',0,'2018-06-08 01:13:45'),(15,17,'draft',0,'2018-08-27 12:42:44'),(16,18,'draft',0,'2018-08-28 00:06:21'),(17,19,'draft',0,'2018-10-23 18:26:17'),(18,20,'pending',0,'2018-10-23 18:25:24'),(19,21,'draft',0,'2018-11-14 18:57:28'),(20,22,'pending',0,'2019-01-08 16:55:25'); /*!40000 ALTER TABLE `pr_approval_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_budget_category` -- DROP TABLE IF EXISTS `pr_budget_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_budget_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text COLLATE utf8_unicode_ci NOT NULL, `financial_year_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_budget_category` -- LOCK TABLES `pr_budget_category` WRITE; /*!40000 ALTER TABLE `pr_budget_category` DISABLE KEYS */; INSERT INTO `pr_budget_category` VALUES (1,'1',1),(2,'2',1); /*!40000 ALTER TABLE `pr_budget_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_budget_group` -- DROP TABLE IF EXISTS `pr_budget_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_budget_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `financial_year_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_budget_group` -- LOCK TABLES `pr_budget_group` WRITE; /*!40000 ALTER TABLE `pr_budget_group` DISABLE KEYS */; INSERT INTO `pr_budget_group` VALUES (1,'Chinese','',1),(2,'test','',2); /*!40000 ALTER TABLE `pr_budget_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_budget_group_users` -- DROP TABLE IF EXISTS `pr_budget_group_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_budget_group_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bg_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `role` enum('HEAD','MEMBER') COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_budget_group_users` -- LOCK TABLES `pr_budget_group_users` WRITE; /*!40000 ALTER TABLE `pr_budget_group_users` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_budget_group_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_budget_item_category` -- DROP TABLE IF EXISTS `pr_budget_item_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_budget_item_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `budget_item` int(11) NOT NULL, `budget_category` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_budget_item_category` -- LOCK TABLES `pr_budget_item_category` WRITE; /*!40000 ALTER TABLE `pr_budget_item_category` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_budget_item_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_budget_items` -- DROP TABLE IF EXISTS `pr_budget_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_budget_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_budget_items` -- LOCK TABLES `pr_budget_items` WRITE; /*!40000 ALTER TABLE `pr_budget_items` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_budget_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_budget_items_history` -- DROP TABLE IF EXISTS `pr_budget_items_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_budget_items_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_budget_items_history` -- LOCK TABLES `pr_budget_items_history` WRITE; /*!40000 ALTER TABLE `pr_budget_items_history` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_budget_items_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_budget_pool_keys` -- DROP TABLE IF EXISTS `pr_budget_pool_keys`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_budget_pool_keys` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pool_key` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `total_budget_amount` decimal(10,2) NOT NULL, `bg_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_budget_pool_keys` -- LOCK TABLES `pr_budget_pool_keys` WRITE; /*!40000 ALTER TABLE `pr_budget_pool_keys` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_budget_pool_keys` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_budget_return` -- DROP TABLE IF EXISTS `pr_budget_return`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_budget_return` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_budget_return` -- LOCK TABLES `pr_budget_return` WRITE; /*!40000 ALTER TABLE `pr_budget_return` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_budget_return` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_financial_years` -- DROP TABLE IF EXISTS `pr_financial_years`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_financial_years` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year_start` date NOT NULL, `year_end` date NOT NULL, `financial_year_label` varchar(12) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_financial_years` -- LOCK TABLES `pr_financial_years` WRITE; /*!40000 ALTER TABLE `pr_financial_years` DISABLE KEYS */; INSERT INTO `pr_financial_years` VALUES (1,'2018-03-01','2018-07-31','2018/1-8'),(2,'2018-08-01','2019-05-05','2018/9-12'); /*!40000 ALTER TABLE `pr_financial_years` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_from_tender` -- DROP TABLE IF EXISTS `pr_from_tender`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_from_tender` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pr_id` int(11) NOT NULL, `tender_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_from_tender` -- LOCK TABLES `pr_from_tender` WRITE; /*!40000 ALTER TABLE `pr_from_tender` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_from_tender` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_has_reference_supplier` -- DROP TABLE IF EXISTS `pr_has_reference_supplier`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_has_reference_supplier` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_has_reference_supplier` -- LOCK TABLES `pr_has_reference_supplier` WRITE; /*!40000 ALTER TABLE `pr_has_reference_supplier` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_has_reference_supplier` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_has_sub_items` -- DROP TABLE IF EXISTS `pr_has_sub_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_has_sub_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_has_sub_items` -- LOCK TABLES `pr_has_sub_items` WRITE; /*!40000 ALTER TABLE `pr_has_sub_items` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_has_sub_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_payment_record` -- DROP TABLE IF EXISTS `pr_payment_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_payment_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pr_id` int(11) NOT NULL, `date` date NOT NULL, `amount` float NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_payment_record` -- LOCK TABLES `pr_payment_record` WRITE; /*!40000 ALTER TABLE `pr_payment_record` DISABLE KEYS */; INSERT INTO `pr_payment_record` VALUES (1,2,'2018-07-04',2); /*!40000 ALTER TABLE `pr_payment_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_purchase_approval_history` -- DROP TABLE IF EXISTS `pr_purchase_approval_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_purchase_approval_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), KEY `purchase_request_id` (`pr_id`), KEY `status` (`status`), KEY `is_approve_action` (`is_approve_action`), KEY `updated_on` (`updated_on`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_purchase_approval_history` -- LOCK TABLES `pr_purchase_approval_history` WRITE; /*!40000 ALTER TABLE `pr_purchase_approval_history` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_purchase_approval_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_purchase_budget_items` -- DROP TABLE IF EXISTS `pr_purchase_budget_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_purchase_budget_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pr_id` int(11) DEFAULT NULL, `bg_bi_id` int(11) DEFAULT NULL, `request_amount` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `budget_item_id_idx` (`bg_bi_id`), KEY `purchase_request_id_idx` (`pr_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_purchase_budget_items` -- LOCK TABLES `pr_purchase_budget_items` WRITE; /*!40000 ALTER TABLE `pr_purchase_budget_items` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_purchase_budget_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_settings` -- DROP TABLE IF EXISTS `pr_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `val` text CHARACTER SET utf8, PRIMARY KEY (`id`), UNIQUE KEY `SETTING_KEY_UNIQUE` (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_settings` -- LOCK TABLES `pr_settings` WRITE; /*!40000 ALTER TABLE `pr_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_settings_approval_role` -- DROP TABLE IF EXISTS `pr_settings_approval_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_settings_approval_role` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role_id` int(11) NOT NULL, `weight` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `role_id` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_settings_approval_role` -- LOCK TABLES `pr_settings_approval_role` WRITE; /*!40000 ALTER TABLE `pr_settings_approval_role` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_settings_approval_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_settings_approval_workflow` -- DROP TABLE IF EXISTS `pr_settings_approval_workflow`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_settings_approval_workflow` ( `id` int(11) NOT NULL AUTO_INCREMENT, `settings_price_range_id` int(11) DEFAULT NULL, `role_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `price_range_id_idx` (`settings_price_range_id`), KEY `role_id_idx` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_settings_approval_workflow` -- LOCK TABLES `pr_settings_approval_workflow` WRITE; /*!40000 ALTER TABLE `pr_settings_approval_workflow` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_settings_approval_workflow` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_settings_price_range` -- DROP TABLE IF EXISTS `pr_settings_price_range`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_settings_price_range` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), UNIQUE KEY `start_range_UNIQUE` (`start_range`), UNIQUE KEY `end_range_UNIQUE` (`end_range`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_settings_price_range` -- LOCK TABLES `pr_settings_price_range` WRITE; /*!40000 ALTER TABLE `pr_settings_price_range` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_settings_price_range` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pr_student_payment` -- DROP TABLE IF EXISTS `pr_student_payment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pr_student_payment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pr_id` int(11) NOT NULL, `number_of_students` int(11) NOT NULL, `payment_per_student` decimal(10,0) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pr_student_payment` -- LOCK TABLES `pr_student_payment` WRITE; /*!40000 ALTER TABLE `pr_student_payment` DISABLE KEYS */; /*!40000 ALTER TABLE `pr_student_payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `purchase_request` -- DROP TABLE IF EXISTS `purchase_request`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `purchase_request` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), KEY `applicant_id_idx` (`applicant_id`), KEY `submited_by_idx` (`submitted_by`), KEY `chosen_supplier_id_idx` (`chosen_supplier_id`), KEY `item_name` (`item_name`), KEY `item_name_2` (`item_name`), KEY `applicant_id` (`applicant_id`), KEY `submitted_by` (`submitted_by`), KEY `chosen_price` (`chosen_price`), KEY `voucher_number` (`voucher_number`), KEY `status` (`status`), KEY `payment_method` (`payment_method`), KEY `chosen_price_2` (`chosen_price`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `purchase_request` -- LOCK TABLES `purchase_request` WRITE; /*!40000 ALTER TABLE `purchase_request` DISABLE KEYS */; /*!40000 ALTER TABLE `purchase_request` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_acl` -- DROP TABLE IF EXISTS `role_acl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role_acl` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role_id` int(11) NOT NULL, `permission` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_acl` -- LOCK TABLES `role_acl` WRITE; /*!40000 ALTER TABLE `role_acl` DISABLE KEYS */; INSERT INTO `role_acl` VALUES (1,2,'[\"ADD_USER\",\"VIEW_ALL_USER\",\"EDIT_ALL_USER\",\"DELETE_ALL_USER\",\"BLOCK_ALL_USER\",\"ASSIGN_USER_ROLE\",\"MANAGE_USER_DATA\",\"MANAGE_USER_GROUP\",\"MANAGE_USER_ROLE\",\"MANAGE_USER_PERMISSION\",\"APPLY_MY_BI\",\"EDIT_MY_BI\",\"DELETE_MY_BI\",\"SUBMIT_MY_BI\",\"APPROVE_BI\",\"ADD_BI\",\"APPLY_MY_PR\",\"EDIT_MY_PR\",\"SUBMIT_MY_PR\",\"CANCEL_MY_PR\",\"AMEND_MY_PR\",\"DELETE_MY_PR\",\"MANAGE_SUBJECT\",\"MANAGE_CLASS_GROUP\",\"MANAGE_SUB_ARG\",\"APPLY_OVERTIME\",\"APPLY_LEAVE\",\"APPROVE_LEAVE\",\"VIEW_LEAVE_SUB_REPORT\",\"APPLY_FORM\",\"ACCESS_FORM_APPROVAL\",\"VIEW_USER_GUIDE\",\"VIEW_MY_EVENTS\",\"VIEW_ALL_EVENTS\",\"ACCESS_AP\",\"FILL_AP_FORMA\",\"VIEW_MY_AP_REPORTA\",\"VIEW_MEMBER_AP_REPORTA\",\"RELEASE_AP_FORMA\",\"APPROVE_EVENTS\",\"ADD_EVENTS\",\"ADD_SUPPLIER\",\"MANAGE_STUDENTS\"]'),(2,3,'[\"APPROVE_BI\",\"APPROVE_ALL_PR\",\"VIEW_ALL_OVERTIME\",\"EDIT_ALL_OVERTIME\",\"DELETE_ALL_OVERTIME\",\"APPROVE_LEAVE\",\"VIEW_ALL_LEAVE\",\"EDIT_ALL_LEAVE\",\"DELETE_ALL_LEAVE\",\"MANAGE_LEAVE_TYPE\",\"MANAGE_APPROVAL_GROUP\",\"MANAGE_ENTITLEMENT\",\"ACCESS_FORM_APPROVAL\",\"VIEW_MY_EVENTS\",\"VIEW_ALL_EVENTS\",\"ACCESS_AP\",\"FILL_AP_FORMA\"]'),(3,4,'[\"VIEW_MY_EVENTS\",\"VIEW_ALL_EVENTS\",\"ACCESS_AP\",\"FILL_AP_FORMA\",\"VIEW_MY_AP_REPORTA\"]'); /*!40000 ALTER TABLE `role_acl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `is_approval_role` int(11) NOT NULL, `system_role` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `role` (`role`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='All roles available for the system'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (2,'Staff',0,0),(3,'Principal',0,0),(4,'Teacher',0,0),(5,'Supervisor',0,0); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `site_settings` -- DROP TABLE IF EXISTS `site_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `site_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `setting` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(1024) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `site_settings` -- LOCK TABLES `site_settings` WRITE; /*!40000 ALTER TABLE `site_settings` DISABLE KEYS */; INSERT INTO `site_settings` VALUES (1,'site_name','Inventory System'),(2,'school_name','香港教育大學賽馬會小學'),(3,'school_logo_ext','png'),(4,'modules','a:1:{s:7:\"modules\";a:6:{i:0;s:13:\"academic_year\";i:1;s:8:\"facility\";i:2;s:4:\"form\";i:3;s:9:\"inventory\";i:4;s:8:\"supplier\";i:5;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','inventory/listing'); /*!40000 ALTER TABLE `site_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_class` -- DROP TABLE IF EXISTS `student_class`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_class` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ay_id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `class_no` int(11) NOT NULL, `class_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_class` -- LOCK TABLES `student_class` WRITE; /*!40000 ALTER TABLE `student_class` DISABLE KEYS */; /*!40000 ALTER TABLE `student_class` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_group` -- DROP TABLE IF EXISTS `student_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ay_id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `subject_id` int(11) NOT NULL, `class_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_group` -- LOCK TABLES `student_group` WRITE; /*!40000 ALTER TABLE `student_group` DISABLE KEYS */; /*!40000 ALTER TABLE `student_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_predict` -- DROP TABLE IF EXISTS `student_predict`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_predict` ( `id` int(11) NOT NULL AUTO_INCREMENT, `student_id` int(11) NOT NULL, `term_id` int(11) NOT NULL, `subject_id` int(11) NOT NULL, `grade` varchar(3) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_predict` -- LOCK TABLES `student_predict` WRITE; /*!40000 ALTER TABLE `student_predict` DISABLE KEYS */; INSERT INTO `student_predict` VALUES (1,14,2,3,'B'); /*!40000 ALTER TABLE `student_predict` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_score` -- DROP TABLE IF EXISTS `student_score`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_score` ( `id` int(11) NOT NULL AUTO_INCREMENT, `student_id` int(11) NOT NULL, `term_id` int(11) NOT NULL, `subject_id` int(11) NOT NULL, `score` decimal(11,0) NOT NULL, `grade` varchar(3) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_score` -- LOCK TABLES `student_score` WRITE; /*!40000 ALTER TABLE `student_score` DISABLE KEYS */; INSERT INTO `student_score` VALUES (10,55,2,23,85,'A'); /*!40000 ALTER TABLE `student_score` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `students` -- DROP TABLE IF EXISTS `students`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `students` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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` timestamp NULL DEFAULT NULL, `last_logged_in` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `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` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `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, `registration_no` text COLLATE utf8_unicode_ci, `student_no` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `students` -- LOCK TABLES `students` WRITE; /*!40000 ALTER TABLE `students` DISABLE KEYS */; /*!40000 ALTER TABLE `students` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `supplier_alias` -- DROP TABLE IF EXISTS `supplier_alias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `supplier_alias` ( `id` int(11) NOT NULL AUTO_INCREMENT, `host_id` int(11) NOT NULL, `alias_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `supplier_alias` -- LOCK TABLES `supplier_alias` WRITE; /*!40000 ALTER TABLE `supplier_alias` DISABLE KEYS */; /*!40000 ALTER TABLE `supplier_alias` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `supplier_pic` -- DROP TABLE IF EXISTS `supplier_pic`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `supplier_pic` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `supplier_pic` -- LOCK TABLES `supplier_pic` WRITE; /*!40000 ALTER TABLE `supplier_pic` DISABLE KEYS */; /*!40000 ALTER TABLE `supplier_pic` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `suppliers` -- DROP TABLE IF EXISTS `suppliers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `suppliers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `supplier` varchar(100) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `supplier` (`supplier`) ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `suppliers` -- LOCK TABLES `suppliers` WRITE; /*!40000 ALTER TABLE `suppliers` DISABLE KEYS */; INSERT INTO `suppliers` VALUES (5,'Apple'),(7,'Banana'),(2,'Commercial Press'),(11,'CyberArts'),(1,'Proedge'); /*!40000 ALTER TABLE `suppliers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sv_filled_student_form` -- DROP TABLE IF EXISTS `sv_filled_student_form`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sv_filled_student_form` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `student_id` int(11) NOT NULL, `editing` tinyint(4) NOT NULL, `form_id` int(11) NOT NULL, `answer` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sv_filled_student_form` -- LOCK TABLES `sv_filled_student_form` WRITE; /*!40000 ALTER TABLE `sv_filled_student_form` DISABLE KEYS */; INSERT INTO `sv_filled_student_form` VALUES (1,1,'2019-02-02 06:26:08',14,1,1,'{\"A2\":{\"Row 1\":{\"Column 1\":\"1\"}},\"A3\":{\"Row 1\":{\"Column 1\":\"2\"}},\"B1\":{\"Row 1\":{\"Column 1\":\"1\"}},\"B2\":{\"Row 1\":{\"Column 1\":\"1\"}},\"B3\":{\"Row 1\":{\"Column 1\":\"1\"}},\"B4\":{\"Row 1\":{\"Column 1\":\"2\"}},\"學習態度\":{\"Row 1\":{\"Column 1\":\"2\"},\"Row 2\":{\"Column 1\":\"3\"},\"item1\":{\"Column 1\":\"3\"},\"item2\":{\"Column 1\":\"2\"},\"item3\":{\"Column 1\":\"2\"}}}'),(2,1,'2019-02-02 06:26:04',18,1,1,NULL),(3,1,'2019-02-25 14:49:29',842,0,1,NULL),(4,1,'2019-02-27 10:08:35',827,1,1,NULL),(5,1,'2019-02-25 14:49:39',766,0,1,NULL),(6,1,'2019-02-26 10:10:41',852,0,1,NULL),(7,1,'2019-03-22 05:22:49',792,1,1,NULL); /*!40000 ALTER TABLE `sv_filled_student_form` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sv_student_form` -- DROP TABLE IF EXISTS `sv_student_form`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sv_student_form` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ay_id` int(11) NOT NULL, `form_id` int(11) NOT NULL COMMENT 'f', `subject_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sv_student_form` -- LOCK TABLES `sv_student_form` WRITE; /*!40000 ALTER TABLE `sv_student_form` DISABLE KEYS */; INSERT INTO `sv_student_form` VALUES (1,2,30,3); /*!40000 ALTER TABLE `sv_student_form` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tb_class` -- DROP TABLE IF EXISTS `tb_class`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tb_class` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` text COLLATE utf8_unicode_ci NOT NULL, `venue_id` int(11) NOT NULL, `ac_year_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb_class` -- LOCK TABLES `tb_class` WRITE; /*!40000 ALTER TABLE `tb_class` DISABLE KEYS */; /*!40000 ALTER TABLE `tb_class` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tb_class_user` -- DROP TABLE IF EXISTS `tb_class_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tb_class_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `class_id` int(11) NOT NULL, `uid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb_class_user` -- LOCK TABLES `tb_class_user` WRITE; /*!40000 ALTER TABLE `tb_class_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tb_class_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tb_subjects` -- DROP TABLE IF EXISTS `tb_subjects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tb_subjects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb_subjects` -- LOCK TABLES `tb_subjects` WRITE; /*!40000 ALTER TABLE `tb_subjects` DISABLE KEYS */; /*!40000 ALTER TABLE `tb_subjects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tb_tea_class_sub` -- DROP TABLE IF EXISTS `tb_tea_class_sub`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tb_tea_class_sub` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ay_id` int(11) NOT NULL, `sub_id` int(11) NOT NULL, `class_id` int(11) NOT NULL, `uid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb_tea_class_sub` -- LOCK TABLES `tb_tea_class_sub` WRITE; /*!40000 ALTER TABLE `tb_tea_class_sub` DISABLE KEYS */; /*!40000 ALTER TABLE `tb_tea_class_sub` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tb_timetable` -- DROP TABLE IF EXISTS `tb_timetable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tb_timetable` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb_timetable` -- LOCK TABLES `tb_timetable` WRITE; /*!40000 ALTER TABLE `tb_timetable` DISABLE KEYS */; /*!40000 ALTER TABLE `tb_timetable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tb_timetable_teacher` -- DROP TABLE IF EXISTS `tb_timetable_teacher`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tb_timetable_teacher` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb_timetable_teacher` -- LOCK TABLES `tb_timetable_teacher` WRITE; /*!40000 ALTER TABLE `tb_timetable_teacher` DISABLE KEYS */; /*!40000 ALTER TABLE `tb_timetable_teacher` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_code_pattern` -- DROP TABLE IF EXISTS `td_code_pattern`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_code_pattern` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_code_pattern` -- LOCK TABLES `td_code_pattern` WRITE; /*!40000 ALTER TABLE `td_code_pattern` DISABLE KEYS */; /*!40000 ALTER TABLE `td_code_pattern` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_comparison` -- DROP TABLE IF EXISTS `td_comparison`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_comparison` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sid` int(11) NOT NULL, `item_id` int(11) NOT NULL, `content` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_comparison` -- LOCK TABLES `td_comparison` WRITE; /*!40000 ALTER TABLE `td_comparison` DISABLE KEYS */; /*!40000 ALTER TABLE `td_comparison` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_comparison_items` -- DROP TABLE IF EXISTS `td_comparison_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_comparison_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tid` int(11) NOT NULL, `item_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_comparison_items` -- LOCK TABLES `td_comparison_items` WRITE; /*!40000 ALTER TABLE `td_comparison_items` DISABLE KEYS */; /*!40000 ALTER TABLE `td_comparison_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_content_list` -- DROP TABLE IF EXISTS `td_content_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_content_list` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tid` int(11) NOT NULL, `content` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_content_list` -- LOCK TABLES `td_content_list` WRITE; /*!40000 ALTER TABLE `td_content_list` DISABLE KEYS */; /*!40000 ALTER TABLE `td_content_list` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_content_parts` -- DROP TABLE IF EXISTS `td_content_parts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_content_parts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `status` tinyint(1) NOT NULL, `order` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_content_parts` -- LOCK TABLES `td_content_parts` WRITE; /*!40000 ALTER TABLE `td_content_parts` DISABLE KEYS */; /*!40000 ALTER TABLE `td_content_parts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_form_questions` -- DROP TABLE IF EXISTS `td_form_questions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_form_questions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `t_form_id` int(11) NOT NULL, `question` varchar(100) NOT NULL, `color` varchar(50) NOT NULL, `detail` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_form_questions` -- LOCK TABLES `td_form_questions` WRITE; /*!40000 ALTER TABLE `td_form_questions` DISABLE KEYS */; /*!40000 ALTER TABLE `td_form_questions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_forms` -- DROP TABLE IF EXISTS `td_forms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_forms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(20) NOT NULL, `serialized_data` longtext NOT NULL, `signature` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_forms` -- LOCK TABLES `td_forms` WRITE; /*!40000 ALTER TABLE `td_forms` DISABLE KEYS */; /*!40000 ALTER TABLE `td_forms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_group_coi` -- DROP TABLE IF EXISTS `td_group_coi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_group_coi` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_group_coi` -- LOCK TABLES `td_group_coi` WRITE; /*!40000 ALTER TABLE `td_group_coi` DISABLE KEYS */; /*!40000 ALTER TABLE `td_group_coi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_group_coi_user_count` -- DROP TABLE IF EXISTS `td_group_coi_user_count`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_group_coi_user_count` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `next_count` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_group_coi_user_count` -- LOCK TABLES `td_group_coi_user_count` WRITE; /*!40000 ALTER TABLE `td_group_coi_user_count` DISABLE KEYS */; /*!40000 ALTER TABLE `td_group_coi_user_count` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_groupcoi_users` -- DROP TABLE IF EXISTS `td_groupcoi_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_groupcoi_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tid` int(11) NOT NULL, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `next_count` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_groupcoi_users` -- LOCK TABLES `td_groupcoi_users` WRITE; /*!40000 ALTER TABLE `td_groupcoi_users` DISABLE KEYS */; /*!40000 ALTER TABLE `td_groupcoi_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_log` -- DROP TABLE IF EXISTS `td_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `tid` int(11) NOT NULL, `status` enum('P','A','R') NOT NULL, `reason` varchar(256) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_log` -- LOCK TABLES `td_log` WRITE; /*!40000 ALTER TABLE `td_log` DISABLE KEYS */; /*!40000 ALTER TABLE `td_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_open_tender` -- DROP TABLE IF EXISTS `td_open_tender`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_open_tender` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_open_tender` -- LOCK TABLES `td_open_tender` WRITE; /*!40000 ALTER TABLE `td_open_tender` DISABLE KEYS */; /*!40000 ALTER TABLE `td_open_tender` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_suppliers` -- DROP TABLE IF EXISTS `td_suppliers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_suppliers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tid` int(11) NOT NULL, `sid` int(11) NOT NULL, `chosen` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_suppliers` -- LOCK TABLES `td_suppliers` WRITE; /*!40000 ALTER TABLE `td_suppliers` DISABLE KEYS */; /*!40000 ALTER TABLE `td_suppliers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_templates` -- DROP TABLE IF EXISTS `td_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_templates` -- LOCK TABLES `td_templates` WRITE; /*!40000 ALTER TABLE `td_templates` DISABLE KEYS */; /*!40000 ALTER TABLE `td_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_tender_coi_history` -- DROP TABLE IF EXISTS `td_tender_coi_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_tender_coi_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_tender_coi_history` -- LOCK TABLES `td_tender_coi_history` WRITE; /*!40000 ALTER TABLE `td_tender_coi_history` DISABLE KEYS */; /*!40000 ALTER TABLE `td_tender_coi_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_tenders` -- DROP TABLE IF EXISTS `td_tenders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_tenders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_tenders` -- LOCK TABLES `td_tenders` WRITE; /*!40000 ALTER TABLE `td_tenders` DISABLE KEYS */; /*!40000 ALTER TABLE `td_tenders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `td_user_coi` -- DROP TABLE IF EXISTS `td_user_coi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `td_user_coi` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sid` int(11) NOT NULL, `uid` int(11) NOT NULL, `conflict` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `td_user_coi` -- LOCK TABLES `td_user_coi` WRITE; /*!40000 ALTER TABLE `td_user_coi` DISABLE KEYS */; /*!40000 ALTER TABLE `td_user_coi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `time_slots` -- DROP TABLE IF EXISTS `time_slots`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `time_slots` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `time_slots` -- LOCK TABLES `time_slots` WRITE; /*!40000 ALTER TABLE `time_slots` DISABLE KEYS */; /*!40000 ALTER TABLE `time_slots` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `timeslot_sets` -- DROP TABLE IF EXISTS `timeslot_sets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `timeslot_sets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` mediumtext NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `timeslot_sets` -- LOCK TABLES `timeslot_sets` WRITE; /*!40000 ALTER TABLE `timeslot_sets` DISABLE KEYS */; /*!40000 ALTER TABLE `timeslot_sets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `updates` -- DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `updates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `remarks` text COLLATE utf8_unicode_ci NOT NULL, `ver` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `ack` tinyint(4) NOT NULL, `date` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `updates` -- LOCK TABLES `updates` WRITE; /*!40000 ALTER TABLE `updates` DISABLE KEYS */; INSERT INTO `updates` VALUES (1,'Update modules and role permission updated','1',0,'2018-04-02'),(2,'Update modules and role permission updated','2',0,'2018-04-02'),(3,'Update modules and role permission updated','3',0,'2018-04-02'),(4,'AC module cmd queue','3',0,'2018-05-23'); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_has_educations` -- DROP TABLE IF EXISTS `user_has_educations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_has_educations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_has_educations` -- LOCK TABLES `user_has_educations` WRITE; /*!40000 ALTER TABLE `user_has_educations` DISABLE KEYS */; /*!40000 ALTER TABLE `user_has_educations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'admin','clchan@cyberarts.com.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','','google','','male','zh-TW','','/files/user_picture/admin.JPG','2018-05-10 21:14:48','','',''); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users_cpd` -- DROP TABLE IF EXISTS `users_cpd`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users_cpd` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users_cpd` -- LOCK TABLES `users_cpd` WRITE; /*!40000 ALTER TABLE `users_cpd` DISABLE KEYS */; INSERT INTO `users_cpd` VALUES (1,'2017-09-03','test','test','test','','test',0,1,0),(2,'2018-11-12','test','test','test','','test',0,1,0),(3,'2017-09-03','test','test','test','','test',0,1,0),(4,'2018-11-12','test','test','test','','test',0,1,0),(5,'2017-09-03','test','test','test','','test',0,1,0),(6,'2018-11-12','test','test','test','','test',0,1,0),(7,'2017-09-03','test','test','test','','test',0,1,0),(8,'2018-11-12','test','test','test','','test',0,1,0),(9,'test','test','test','test','','test',1,98,0); /*!40000 ALTER TABLE `users_cpd` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users_group` -- DROP TABLE IF EXISTS `users_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users_group` -- LOCK TABLES `users_group` WRITE; /*!40000 ALTER TABLE `users_group` DISABLE KEYS */; INSERT INTO `users_group` VALUES (3,1,2),(4,2,2),(5,3,2),(6,4,2),(7,5,2),(8,2,3),(9,3,3),(10,5,3),(11,1,1),(12,2,1),(13,5,1); /*!40000 ALTER TABLE `users_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users_roles` -- DROP TABLE IF EXISTS `users_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users_roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `role_id_idx` (`role_id`), KEY `user_id_idx` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=403 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users_roles` -- LOCK TABLES `users_roles` WRITE; /*!40000 ALTER TABLE `users_roles` DISABLE KEYS */; INSERT INTO `users_roles` VALUES (205,1,2); /*!40000 ALTER TABLE `users_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `venue_group` -- DROP TABLE IF EXISTS `venue_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `venue_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `venue_group` -- LOCK TABLES `venue_group` WRITE; /*!40000 ALTER TABLE `venue_group` DISABLE KEYS */; INSERT INTO `venue_group` VALUES (1,'1/F'); /*!40000 ALTER TABLE `venue_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `venues` -- DROP TABLE IF EXISTS `venues`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `venues` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `venues` -- LOCK TABLES `venues` WRITE; /*!40000 ALTER TABLE `venues` DISABLE KEYS */; INSERT INTO `venues` VALUES (1,'101A',1,'',0),(2,'102A',1,'',0); /*!40000 ALTER TABLE `venues` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wf_filled_form` -- DROP TABLE IF EXISTS `wf_filled_form`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_filled_form` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, `ay_id` int(11) NOT NULL, `status` text COLLATE utf8_unicode_ci NOT NULL, `last_modified` datetime DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_filled_form` -- LOCK TABLES `wf_filled_form` WRITE; /*!40000 ALTER TABLE `wf_filled_form` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_filled_form` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wf_form_answers` -- DROP TABLE IF EXISTS `wf_form_answers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_form_answers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ff_id` int(11) NOT NULL, `q_domain` longtext COLLATE utf8_unicode_ci NOT NULL, `answer` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_form_answers` -- LOCK TABLES `wf_form_answers` WRITE; /*!40000 ALTER TABLE `wf_form_answers` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_form_answers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wf_form_status` -- DROP TABLE IF EXISTS `wf_form_status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_form_status` ( `id` int(11) NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_form_status` -- LOCK TABLES `wf_form_status` WRITE; /*!40000 ALTER TABLE `wf_form_status` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_form_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wf_form_workflow` -- DROP TABLE IF EXISTS `wf_form_workflow`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_form_workflow` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fid` int(11) NOT NULL, `wid` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_form_workflow` -- LOCK TABLES `wf_form_workflow` WRITE; /*!40000 ALTER TABLE `wf_form_workflow` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_form_workflow` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wf_workflow` -- DROP TABLE IF EXISTS `wf_workflow`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_workflow` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `urgent_days` int(11) NOT NULL, `workflow` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_workflow` -- LOCK TABLES `wf_workflow` WRITE; /*!40000 ALTER TABLE `wf_workflow` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_workflow` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2019-04-11 16:56:56
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 0.6 |
proxy
|
phpinfo
|
Settings