File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/assets/global/scripts/911347/install.tar
Back
config/config.php 0000775 00000032014 15060011660 0007767 0 ustar 00 <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); function __autoload($classname) { if (strpos($classname, 'CI_') !== 0) { $file = APPPATH . 'libraries/' . $classname . '.php'; if (file_exists($file) && is_file($file)) { @include_once($file); } } } /* |-------------------------------------------------------------------------- | Base Site URL |-------------------------------------------------------------------------- | | URL to your CodeIgniter root. Typically this will be your base URL, | WITH a trailing slash: | | http://example.com/ | | If this is not set then CodeIgniter will guess the protocol, domain and | path to your installation. | */ //$config['base_url'] = ''; $config['base_url'] = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == "on") ? "https" : "http"); $config['base_url'] .= "://".$_SERVER['HTTP_HOST']; $config['base_url'] .= str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']); /* |-------------------------------------------------------------------------- | Index File |-------------------------------------------------------------------------- | | Typically this will be your index.php file, unless you've renamed it to | something else. If you are using mod_rewrite to remove the page set this | variable so that it is blank. | */ $config['index_page'] = ''; /* |-------------------------------------------------------------------------- | URI PROTOCOL |-------------------------------------------------------------------------- | | This item determines which server global should be used to retrieve the | URI string. The default setting of 'AUTO' works for most servers. | If your links do not seem to work, try one of the other delicious flavors: | | 'AUTO' Default - auto detects | 'PATH_INFO' Uses the PATH_INFO | 'QUERY_STRING' Uses the QUERY_STRING | 'REQUEST_URI' Uses the REQUEST_URI | 'ORIG_PATH_INFO' Uses the ORIG_PATH_INFO | */ $config['uri_protocol'] = 'AUTO'; /* |-------------------------------------------------------------------------- | URL suffix |-------------------------------------------------------------------------- | | This option allows you to add a suffix to all URLs generated by CodeIgniter. | For more information please see the employee guide: | | http://codeigniter.com/user_guide/general/urls.html */ $config['url_suffix'] = ''; /* |-------------------------------------------------------------------------- | Default Language |-------------------------------------------------------------------------- | | This determines which set of language files should be used. Make sure | there is an available translation if you intend to use something other | than english. | */ $config['language'] = 'english'; /* |-------------------------------------------------------------------------- | Default Character Set |-------------------------------------------------------------------------- | | This determines which character set is used by default in various methods | that require a character set to be provided. | */ $config['charset'] = 'UTF-8'; /* |-------------------------------------------------------------------------- | Enable/Disable System Hooks |-------------------------------------------------------------------------- | | If you would like to use the 'hooks' feature you must enable it by | setting this variable to TRUE (boolean). See the employee guide for details. | */ $config['enable_hooks'] = FALSE; /* |-------------------------------------------------------------------------- | Class Extension Prefix |-------------------------------------------------------------------------- | | This item allows you to set the filename/classname prefix when extending | native libraries. For more information please see the employee guide: | | http://codeigniter.com/user_guide/general/core_classes.html | http://codeigniter.com/user_guide/general/creating_libraries.html | */ $config['subclass_prefix'] = 'MY_'; /* |-------------------------------------------------------------------------- | Allowed URL Characters |-------------------------------------------------------------------------- | | This lets you specify with a regular expression which characters are permitted | within your URLs. When someone tries to submit a URL with disallowed | characters they will get a warning message. | | As a security measure you are STRONGLY encouraged to restrict URLs to | as few characters as possible. By default only these are allowed: a-z 0-9~%.:_- | | Leave blank to allow all characters -- but only if you are insane. | | DO NOT CHANGE THIS UNLESS YOU FULLY UNDERSTAND THE REPERCUSSIONS!! | */ $config['permitted_uri_chars'] = 'a-z 0-9~%.:_\-'; /* |-------------------------------------------------------------------------- | Enable Query Strings |-------------------------------------------------------------------------- | | By default CodeIgniter uses search-engine friendly segment based URLs: | example.com/who/what/where/ | | By default CodeIgniter enables access to the $_GET array. If for some | reason you would like to disable it, set 'allow_get_array' to FALSE. | | You can optionally enable standard query string based URLs: | example.com?who=me&what=something&where=here | | Options are: TRUE or FALSE (boolean) | | The other items let you set the query string 'words' that will | invoke your controllers and its functions: | example.com/index.php?c=controller&m=function | | Please note that some of the helpers won't work as expected when | this feature is enabled, since CodeIgniter is designed primarily to | use segment based URLs. | */ $config['allow_get_array'] = FALSE; $config['enable_query_strings'] = FALSE; $config['controller_trigger'] = 'c'; $config['function_trigger'] = 'm'; $config['directory_trigger'] = 'd'; // experimental not currently in use /* |-------------------------------------------------------------------------- | Error Logging Threshold |-------------------------------------------------------------------------- | | If you have enabled error logging, you can set an error threshold to | determine what gets logged. Threshold options are: | You can enable error logging by setting a threshold over zero. The | threshold determines what gets logged. Threshold options are: | | 0 = Disables logging, Error logging TURNED OFF | 1 = Error Messages (including PHP errors) | 2 = Debug Messages | 3 = Informational Messages | 4 = All Messages | | For a live site you'll usually only enable Errors (1) to be logged otherwise | your log files will fill up very fast. | */ $config['log_threshold'] = 0; /* |-------------------------------------------------------------------------- | Error Logging Directory Path |-------------------------------------------------------------------------- | | Leave this BLANK unless you would like to set something other than the default | application/logs/ folder. Use a full server path with trailing slash. | */ $config['log_path'] = ''; /* |-------------------------------------------------------------------------- | Date Format for Logs |-------------------------------------------------------------------------- | | Each item that is logged has an associated date. You can use PHP date | codes to set your own date formatting | */ $config['log_date_format'] = 'Y-m-d H:i:s'; /* |-------------------------------------------------------------------------- | Cache Directory Path |-------------------------------------------------------------------------- | | Leave this BLANK unless you would like to set something other than the default | system/cache/ folder. Use a full server path with trailing slash. | */ $config['cache_path'] = ''; /* |-------------------------------------------------------------------------- | Encryption Key |-------------------------------------------------------------------------- | | If you use the Encryption class or the Session class you | MUST set an encryption key. See the employee guide for info. | */ $config['encryption_key'] = 'I6PnEPbQNLslYMj7ChKxDJ2yenuHLkXn'; /* |-------------------------------------------------------------------------- | Session Variables |-------------------------------------------------------------------------- | | 'sess_cookie_name' = the name you want for the cookie | 'sess_expiration' = the number of SECONDS you want the session to last. | by default sessions last 7200 seconds (two hours). Set to zero for no expiration. | 'sess_expire_on_close' = Whether to cause the session to expire automatically | when the browser window is closed | 'sess_encrypt_cookie' = Whether to encrypt the cookie | 'sess_use_database' = Whether to save the session data to a database | 'sess_table_name' = The name of the session database table | 'sess_match_ip' = Whether to match the employee's IP address when reading the session data | 'sess_match_useragent' = Whether to match the User Agent when reading the session data | 'sess_time_to_update' = how many seconds between CI refreshing Session Information | */ $config['sess_cookie_name'] = 'ci_session'; $config['sess_expiration'] = 7200; $config['sess_expire_on_close'] = FALSE; $config['sess_encrypt_cookie'] = FALSE; $config['sess_use_database'] = TRUE; $config['sess_table_name'] = 'ci_sessions'; $config['sess_match_ip'] = FALSE; $config['sess_match_useragent'] = TRUE; $config['sess_time_to_update'] = 7200; /* |-------------------------------------------------------------------------- | Cookie Related Variables |-------------------------------------------------------------------------- | | 'cookie_prefix' = Set a prefix if you need to avoid collisions | 'cookie_domain' = Set to .your-domain.com for site-wide cookies | 'cookie_path' = Typically will be a forward slash | 'cookie_secure' = Cookies will only be set if a secure HTTPS connection exists. | */ $config['cookie_prefix'] = ""; $config['cookie_domain'] = ""; $config['cookie_path'] = "/"; $config['cookie_secure'] = FALSE; /* |-------------------------------------------------------------------------- | Global XSS Filtering |-------------------------------------------------------------------------- | | Determines whether the XSS filter is always active when GET, POST or | COOKIE data is encountered | */ $config['global_xss_filtering'] = TRUE; /* |-------------------------------------------------------------------------- | Cross Site Request Forgery |-------------------------------------------------------------------------- | Enables a CSRF cookie token to be set. When set to TRUE, token will be | checked on a submitted form. If you are accepting employee data, it is strongly | recommended CSRF protection be enabled. | | 'csrf_token_name' = The token name | 'csrf_cookie_name' = The cookie name | 'csrf_expire' = The number in seconds the token should expire. */ $config['csrf_protection'] = FALSE; $config['csrf_token_name'] = 'csrf_test_name'; $config['csrf_cookie_name'] = 'csrf_cookie_name'; $config['csrf_expire'] = 7200; /* |-------------------------------------------------------------------------- | Output Compression |-------------------------------------------------------------------------- | | Enables Gzip output compression for faster page loads. When enabled, | the output class will test whether your server supports Gzip. | Even if it does, however, not all browsers support compression | so enable only if you are reasonably sure your visitors can handle it. | | VERY IMPORTANT: If you are getting a blank page when compression is enabled it | means you are prematurely outputting something to your browser. It could | even be a line of whitespace at the end of one of your scripts. For | compression to work, nothing can be sent before the output buffer is called | by the output class. Do not 'echo' any values with compression enabled. | */ $config['compress_output'] = TRUE; /* |-------------------------------------------------------------------------- | Master Time Reference |-------------------------------------------------------------------------- | | Options are 'local' or 'gmt'. This pref tells the system whether to use | your server's local time as the master 'now' reference, or convert it to | GMT. See the 'date helper' page of the employee guide for information | regarding date handling. | */ $config['time_reference'] = 'local'; /* |-------------------------------------------------------------------------- | Rewrite PHP Short Tags |-------------------------------------------------------------------------- | | If your PHP installation does not have short tag support enabled CI | can rewrite the tags on-the-fly, enabling you to utilize that syntax | in your view files. Options are TRUE or FALSE (boolean) | */ $config['rewrite_short_tags'] = FALSE; /* |-------------------------------------------------------------------------- | Reverse Proxy IPs |-------------------------------------------------------------------------- | | If your server is behind a reverse proxy, you must whitelist the proxy IP | addresses from which CodeIgniter should trust the HTTP_X_FORWARDED_FOR | header in order to properly identify the visitor's IP address. | Comma-delimited, e.g. '10.0.1.200,10.0.1.201' | */ $config['proxy_ips'] = ''; /* End of file config.php */ /* Location: ./application/config/config.php */ config/database.php 0000775 00000001156 15060011660 0010271 0 ustar 00 <?php defined('BASEPATH') OR exit('No direct script access allowed'); $active_group = 'default'; $query_builder = TRUE; $db['default'] = array( 'dsn' => '', 'hostname' => '%HOSTNAME%', 'username' => '%USERNAME%', 'password' => '%PASSWORD%', 'database' => '%DATABASE%', 'dbdriver' => 'mysqli', 'dbprefix' => '', 'pconnect' => FALSE, 'db_debug' => (ENVIRONMENT !== 'production'), 'cache_on' => FALSE, 'cachedir' => '', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(), 'save_queries' => TRUE ); db/ap_deprecated.sql 0000775 00000056273 15060011660 0010447 0 ustar 00 -- phpMyAdmin SQL Dump -- version 4.7.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Apr 02, 2018 at 06:12 PM -- Server version: 10.1.30-MariaDB -- PHP Version: 7.0.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `camplus2` -- -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_answers` -- CREATE TABLE `ap_deprecated_answers` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `submitted_by` int(11) NOT NULL, `is_overall_appraisal` int(11) NOT NULL, `is_unit` int(11) NOT NULL, `answer` mediumtext COLLATE utf8_unicode_ci NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_answer_has_grid` -- CREATE TABLE `ap_deprecated_answer_has_grid` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `submitted_by` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question_of_question_id` int(11) NOT NULL, `answer` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `remark` mediumtext COLLATE utf8_unicode_ci NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_answer_has_table` -- CREATE TABLE `ap_deprecated_answer_has_table` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `submitted_by` int(11) NOT NULL, `question_id` int(11) NOT NULL, `answer` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap` -- CREATE TABLE `ap_deprecated_overall_ap` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `template_id` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap_qtns` -- CREATE TABLE `ap_deprecated_overall_ap_qtns` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appraisal_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('SINGLE_LINE','MULTIPLE_LINE','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `self` tinyint(4) NOT NULL, `roles` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap_qtn_options` -- CREATE TABLE `ap_deprecated_overall_ap_qtn_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap_qtn_sub_qtns` -- CREATE TABLE `ap_deprecated_overall_ap_qtn_sub_qtns` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_overall_ap_workflow` -- CREATE TABLE `ap_deprecated_overall_ap_workflow` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `cat_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `workflow` mediumtext COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_qtns` -- CREATE TABLE `ap_deprecated_qtns` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `template_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('SINGLE_LINE','MULTIPLE_LINE','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_qtn_options` -- CREATE TABLE `ap_deprecated_qtn_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_qtn_sub_qtns` -- CREATE TABLE `ap_deprecated_qtn_sub_qtns` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_roles` -- CREATE TABLE `ap_deprecated_roles` ( `id` int(11) NOT NULL, `role` text COLLATE utf8_unicode_ci NOT NULL, `is_approval_role` tinyint(1) NOT NULL, `academic_year_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_sections` -- CREATE TABLE `ap_deprecated_sections` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `academic_year_id` int(11) NOT NULL, `is_head_can_view` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_head_can_fill` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_member_can_view` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_member_can_fill` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `roles_can_view` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `roles_can_fill` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `from_date` date NOT NULL, `to_date` date NOT NULL, `template_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_sections_status` -- CREATE TABLE `ap_deprecated_sections_status` ( `id` int(11) NOT NULL, `academic_year_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_section_qtns` -- CREATE TABLE `ap_deprecated_section_qtns` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `section_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('','SINGLE_LINE','MULTIPLE_LINE','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `special_question` enum('','UNIT','OVERALL_APPRAISAL','USER_DATA') COLLATE utf8_unicode_ci NOT NULL, `type` enum('','SELF','HEAD') COLLATE utf8_unicode_ci NOT NULL, `overall_appraisal_user_id` int(11) NOT NULL, `rank` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_section_qtn_options` -- CREATE TABLE `ap_deprecated_section_qtn_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_section_qtn_sub_qtns` -- CREATE TABLE `ap_deprecated_section_qtn_sub_qtns` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_settings` -- CREATE TABLE `ap_deprecated_settings` ( `id` int(11) NOT NULL, `key` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_templates` -- CREATE TABLE `ap_deprecated_templates` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_units` -- CREATE TABLE `ap_deprecated_units` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` mediumtext COLLATE utf8_unicode_ci NOT NULL, `academic_year_id` int(11) NOT NULL, `category` int(11) NOT NULL, `template_id` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_ap_heads` -- CREATE TABLE `ap_deprecated_unit_ap_heads` ( `id` int(11) NOT NULL, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_categories` -- CREATE TABLE `ap_deprecated_unit_categories` ( `id` int(11) NOT NULL, `category` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_heads` -- CREATE TABLE `ap_deprecated_unit_heads` ( `id` int(11) NOT NULL, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_members` -- CREATE TABLE `ap_deprecated_unit_members` ( `id` int(11) NOT NULL, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_qtns` -- CREATE TABLE `ap_deprecated_unit_qtns` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `unit_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('SINGLE_LINE','MULTIPLE_LINE','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `self` tinyint(4) NOT NULL, `head` tinyint(4) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_qtn_options` -- CREATE TABLE `ap_deprecated_unit_qtn_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_unit_qtn_sub_qtns` -- CREATE TABLE `ap_deprecated_unit_qtn_sub_qtns` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_users_roles` -- CREATE TABLE `ap_deprecated_users_roles` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `role_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_deprecated_user_has_educations` -- CREATE TABLE `ap_deprecated_user_has_educations` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `qualification` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `certificate` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `major` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `minor` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `institute` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `award_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `ap_deprecated_answers` -- ALTER TABLE `ap_deprecated_answers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_answer_has_grid` -- ALTER TABLE `ap_deprecated_answer_has_grid` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_answer_has_table` -- ALTER TABLE `ap_deprecated_answer_has_table` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap` -- ALTER TABLE `ap_deprecated_overall_ap` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap_qtns` -- ALTER TABLE `ap_deprecated_overall_ap_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap_qtn_options` -- ALTER TABLE `ap_deprecated_overall_ap_qtn_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_overall_ap_qtn_sub_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_overall_ap_workflow` -- ALTER TABLE `ap_deprecated_overall_ap_workflow` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_qtns` -- ALTER TABLE `ap_deprecated_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_qtn_options` -- ALTER TABLE `ap_deprecated_qtn_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_qtn_sub_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_roles` -- ALTER TABLE `ap_deprecated_roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_sections` -- ALTER TABLE `ap_deprecated_sections` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_sections_status` -- ALTER TABLE `ap_deprecated_sections_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_section_qtns` -- ALTER TABLE `ap_deprecated_section_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_section_qtn_options` -- ALTER TABLE `ap_deprecated_section_qtn_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_section_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_section_qtn_sub_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_settings` -- ALTER TABLE `ap_deprecated_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_templates` -- ALTER TABLE `ap_deprecated_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_units` -- ALTER TABLE `ap_deprecated_units` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_ap_heads` -- ALTER TABLE `ap_deprecated_unit_ap_heads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_categories` -- ALTER TABLE `ap_deprecated_unit_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_heads` -- ALTER TABLE `ap_deprecated_unit_heads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_members` -- ALTER TABLE `ap_deprecated_unit_members` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_qtns` -- ALTER TABLE `ap_deprecated_unit_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_qtn_options` -- ALTER TABLE `ap_deprecated_unit_qtn_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_unit_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_unit_qtn_sub_qtns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_deprecated_users_roles` -- ALTER TABLE `ap_deprecated_users_roles` ADD PRIMARY KEY (`id`), ADD KEY `role_id_idx` (`role_id`), ADD KEY `user_id_idx` (`user_id`); -- -- Indexes for table `ap_deprecated_user_has_educations` -- ALTER TABLE `ap_deprecated_user_has_educations` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `ap_deprecated_answers` -- ALTER TABLE `ap_deprecated_answers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_answer_has_grid` -- ALTER TABLE `ap_deprecated_answer_has_grid` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_answer_has_table` -- ALTER TABLE `ap_deprecated_answer_has_table` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap` -- ALTER TABLE `ap_deprecated_overall_ap` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap_qtns` -- ALTER TABLE `ap_deprecated_overall_ap_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap_qtn_options` -- ALTER TABLE `ap_deprecated_overall_ap_qtn_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_overall_ap_qtn_sub_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_overall_ap_workflow` -- ALTER TABLE `ap_deprecated_overall_ap_workflow` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_qtns` -- ALTER TABLE `ap_deprecated_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_qtn_options` -- ALTER TABLE `ap_deprecated_qtn_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_qtn_sub_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_roles` -- ALTER TABLE `ap_deprecated_roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_sections` -- ALTER TABLE `ap_deprecated_sections` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_sections_status` -- ALTER TABLE `ap_deprecated_sections_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_section_qtns` -- ALTER TABLE `ap_deprecated_section_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_section_qtn_options` -- ALTER TABLE `ap_deprecated_section_qtn_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_section_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_section_qtn_sub_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_settings` -- ALTER TABLE `ap_deprecated_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_templates` -- ALTER TABLE `ap_deprecated_templates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_units` -- ALTER TABLE `ap_deprecated_units` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_ap_heads` -- ALTER TABLE `ap_deprecated_unit_ap_heads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_categories` -- ALTER TABLE `ap_deprecated_unit_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_heads` -- ALTER TABLE `ap_deprecated_unit_heads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_members` -- ALTER TABLE `ap_deprecated_unit_members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_qtns` -- ALTER TABLE `ap_deprecated_unit_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_qtn_options` -- ALTER TABLE `ap_deprecated_unit_qtn_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_unit_qtn_sub_qtns` -- ALTER TABLE `ap_deprecated_unit_qtn_sub_qtns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_users_roles` -- ALTER TABLE `ap_deprecated_users_roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_deprecated_user_has_educations` -- ALTER TABLE `ap_deprecated_user_has_educations` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; db/install.sql 0000775 00000311261 15060011660 0007324 0 ustar 00 -- phpMyAdmin SQL Dump -- version 4.7.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Apr 02, 2018 at 06:17 PM -- Server version: 10.1.30-MariaDB -- PHP Version: 7.0.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `camplus2` -- -- -------------------------------------------------------- -- -- Table structure for table `academic_years` -- CREATE TABLE `academic_years` ( `id` int(11) NOT NULL, `year_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `year_start` date NOT NULL, `year_end` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ac_devices` -- CREATE TABLE `ac_devices` ( `id` int(11) NOT NULL, `devID` int(11) NOT NULL, `venue_id` int(11) NOT NULL, `state` int(11) NOT NULL, `lastUpdate` datetime NOT NULL, `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `receiver` int(11) NOT NULL, `ip` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ac_receiver` -- CREATE TABLE `ac_receiver` ( `id` int(11) NOT NULL, `dev_id` text NOT NULL, `ip` text NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `max_cardRecordID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `ac_record` -- CREATE TABLE `ac_record` ( `id` int(11) NOT NULL, `cardRecordID` int(11) NOT NULL, `card` text NOT NULL, `uid` int(11) NOT NULL, `username` text NOT NULL, `cardTime` datetime NOT NULL, `cardResult` int(11) NOT NULL, `devID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `ac_whitelist` -- CREATE TABLE `ac_whitelist` ( `id` int(11) NOT NULL, `card` int(11) NOT NULL, `dev_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `ap_answer` -- CREATE TABLE `ap_answer` ( `id` int(11) NOT NULL, `ff_id` int(11) NOT NULL, `a_key` text COLLATE utf8_unicode_ci NOT NULL, `answer` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_filled_form` -- CREATE TABLE `ap_filled_form` ( `id` int(11) NOT NULL, `form` int(11) NOT NULL, `appraiser` int(11) NOT NULL, `appraisee` int(11) NOT NULL, `unit` int(11) NOT NULL, `answer` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form` -- CREATE TABLE `ap_form` ( `id` int(11) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form_sections` -- CREATE TABLE `ap_form_sections` ( `id` int(11) NOT NULL, `ap_form` int(11) NOT NULL, `type` enum('u2d','d2u','peer','self') COLLATE utf8_unicode_ci NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `start` date NOT NULL, `end` date NOT NULL, `description` longtext COLLATE utf8_unicode_ci NOT NULL, `form` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form_section_unit` -- CREATE TABLE `ap_form_section_unit` ( `id` int(11) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `section` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form_section_unit_user` -- CREATE TABLE `ap_form_section_unit_user` ( `id` int(11) NOT NULL, `unit_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `type` enum('HEAD','MEMBER','RELATED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ap_form_section_user` -- CREATE TABLE `ap_form_section_user` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `status` enum('SUBMITTED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `at_attendance_report` -- CREATE TABLE `at_attendance_report` ( `id` int(11) NOT NULL, `date` date NOT NULL, `direction` enum('IN','OUT') COLLATE utf8_unicode_ci NOT NULL, `uid` int(11) NOT NULL, `status` enum('NORMAL','LATE','EARLY','ABSENT') COLLATE utf8_unicode_ci NOT NULL, `remarks` text COLLATE utf8_unicode_ci NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updatedby` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `at_attendance_rule_dates` -- CREATE TABLE `at_attendance_rule_dates` ( `id` int(11) NOT NULL, `arp_id` int(11) NOT NULL, `day` varchar(12) NOT NULL, `da_id` int(11) NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_attendance_rule_period` -- CREATE TABLE `at_attendance_rule_period` ( `id` int(11) NOT NULL, `rule_name` varchar(256) NOT NULL, `effective_from` date NOT NULL, `effective_to` date NOT NULL, `public_holiday` tinyint(4) NOT NULL DEFAULT '0', `school_holiday` tinyint(4) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_daily_attendance` -- CREATE TABLE `at_daily_attendance` ( `id` int(11) NOT NULL, `rule_name` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_daily_attendance_timeset` -- CREATE TABLE `at_daily_attendance_timeset` ( `id` int(11) NOT NULL, `da_id` int(11) NOT NULL, `time_in` time NOT NULL, `check_in` tinyint(1) NOT NULL, `time_out` time NOT NULL, `check_out` tinyint(1) NOT NULL, `working_days` double(4,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_record` -- CREATE TABLE `at_record` ( `id` int(11) NOT NULL, `card` int(11) NOT NULL, `cr_id` text COLLATE utf8_unicode_ci, `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `at_special_attendance` -- CREATE TABLE `at_special_attendance` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `sat_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_special_attendance_timeset` -- CREATE TABLE `at_special_attendance_timeset` ( `id` int(11) NOT NULL, `sa_id` int(11) NOT NULL, `time_in` time NOT NULL, `check_in` tinyint(1) NOT NULL, `time_out` time NOT NULL, `check_out` tinyint(1) NOT NULL, `working_days` double(4,2) NOT NULL, `dates` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `at_user_card` -- CREATE TABLE `at_user_card` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `card` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `at_user_time_rule_set` -- CREATE TABLE `at_user_time_rule_set` ( `id` int(11) NOT NULL, `arp_id` int(11) NOT NULL, `every_day` varchar(12) NOT NULL, `da_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `calendar_type` -- CREATE TABLE `calendar_type` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `color` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_default` tinyint(4) NOT NULL, `urgent_booking_warning` int(11) NOT NULL, `need_approval` tinyint(4) NOT NULL, `hide_event` tinyint(1) NOT NULL, `approver_user_id` char(255) COLLATE utf8_unicode_ci DEFAULT NULL, `circular_required` tinyint(4) NOT NULL, `display_only` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `calendar_type_has_forms` -- CREATE TABLE `calendar_type_has_forms` ( `id` int(11) NOT NULL, `calendar_type_id` int(11) NOT NULL, `form_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `circulars` -- CREATE TABLE `circulars` ( `id` int(11) NOT NULL, `circular_number` int(10) NOT NULL, `event_id` int(11) NOT NULL, `event_series` int(11) NOT NULL, `circular_templates` int(11) NOT NULL, `section_id` int(11) NOT NULL, `teacher_in_charge` int(11) NOT NULL, `circular_body` text COLLATE utf8_unicode_ci NOT NULL, `distribute_date` date NOT NULL, `status` enum('APPROVED','REJECTED','RELEASED','SUBMITTED','DRAFT','PENDING') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `circular_templates` -- CREATE TABLE `circular_templates` ( `id` int(11) NOT NULL, `circular_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `circular_body` text COLLATE utf8_unicode_ci NOT NULL, `files` text COLLATE utf8_unicode_ci NOT NULL, `is_enabled` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `doorEventLog` -- CREATE TABLE `doorEventLog` ( `cardReaderID` bigint(20) NOT NULL, `event_type` text COLLATE utf8_unicode_ci NOT NULL, `event_data` text COLLATE utf8_unicode_ci NOT NULL, `event_id` int(11) NOT NULL, `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `eb_facilities` -- CREATE TABLE `eb_facilities` ( `id` int(11) NOT NULL, `facility_id` int(11) NOT NULL, `is_enabled` tinyint(4) NOT NULL, `need_approval` tinyint(4) NOT NULL, `approver_user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `eb_settings` -- CREATE TABLE `eb_settings` ( `id` int(11) NOT NULL, `key` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `val` text CHARACTER SET utf8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `eb_time_slots` -- CREATE TABLE `eb_time_slots` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `time_from` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `time_to` varchar(55) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `eb_venues` -- CREATE TABLE `eb_venues` ( `id` int(11) NOT NULL, `venue_id` int(11) NOT NULL, `is_enabled` tinyint(4) NOT NULL, `need_approval` tinyint(4) NOT NULL, `approver_user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(11) NOT NULL, `event_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `calendar_type_id` int(11) NOT NULL, `event_type_id` int(11) NOT NULL, `teacher_in_charge` int(11) NOT NULL, `remark` mediumtext COLLATE utf8_unicode_ci NOT NULL, `serializeData` mediumtext COLLATE utf8_unicode_ci NOT NULL, `status` enum('DRAFT','PENDING','PUBLISHED','REJECTED','WITHDRAW','APPROVED') COLLATE utf8_unicode_ci NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_forms_history` -- CREATE TABLE `event_forms_history` ( `id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `from_status` enum('PENDING','APPROVED','REJECTED','SUBMITTED','RELEASED','WITHDRAW') COLLATE utf8_unicode_ci NOT NULL, `to_status` enum('PENDING','APPROVED','REJECTED','SUBMITTED','RELEASED','WITHDRAW') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_has_files` -- CREATE TABLE `event_has_files` ( `id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_has_forms` -- CREATE TABLE `event_has_forms` ( `id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `status` enum('PENDING','APPROVED','REJECTED','SUBMITTED','RELEASED','WITHDRAW','DRAFT') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_has_sections` -- CREATE TABLE `event_has_sections` ( `id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `startDate` date NOT NULL, `from_time` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `to_time` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `section_group` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_section_has_facilities` -- CREATE TABLE `event_section_has_facilities` ( `id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `facility_id` int(11) NOT NULL, `status` enum('PENDING','APPROVED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_section_has_participants` -- CREATE TABLE `event_section_has_participants` ( `id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `participant_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `other` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_section_has_venues` -- CREATE TABLE `event_section_has_venues` ( `id` int(11) NOT NULL, `section_id` int(11) NOT NULL, `venue_id` int(11) NOT NULL, `other` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` enum('PENDING','PENDING0','PENDING1','PENDING2','PENDING3','APPROVED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_types` -- CREATE TABLE `event_types` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `facilities` -- CREATE TABLE `facilities` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `quantity` int(11) NOT NULL, `remarks` mediumtext COLLATE utf8_unicode_ci NOT NULL, `order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form` -- CREATE TABLE `form` ( `id` int(11) NOT NULL, `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `structure` text COLLATE utf8_unicode_ci NOT NULL, `version` varchar(256) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `forms` -- CREATE TABLE `forms` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `need_approval` tinyint(4) NOT NULL, `approver` char(255) COLLATE utf8_unicode_ci DEFAULT NULL, `is_enabled` tinyint(4) NOT NULL, `deadline` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_answers` -- CREATE TABLE `form_answers` ( `id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `answer` mediumtext COLLATE utf8_unicode_ci NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_answer_has_grid` -- CREATE TABLE `form_answer_has_grid` ( `id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question_of_question_id` int(11) NOT NULL, `answer` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `remark` mediumtext COLLATE utf8_unicode_ci NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_answer_has_table` -- CREATE TABLE `form_answer_has_table` ( `id` int(11) NOT NULL, `form_id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `answer` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `is_submitted` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_has_questions` -- CREATE TABLE `form_has_questions` ( `id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `form_id` int(11) NOT NULL, `placeholder` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `question_type` enum('LABEL','SINGLE_LINE','MULTIPLE_LINE','SUGGESTED','RADIO_BUTTON','CHECKBOX','DROPDOWN','DATETIME','DATE','TIME','GRID','TABLE','NUMBER','ATTACHMENT') COLLATE utf8_unicode_ci NOT NULL, `grid_count` int(11) NOT NULL, `grid_table_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `rank` int(11) NOT NULL, `added_on` datetime NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `color` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `font_size` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_question_has_options` -- CREATE TABLE `form_question_has_options` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `option` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_question_has_questions` -- CREATE TABLE `form_question_has_questions` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `question` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `is_remark` int(11) NOT NULL, `remark_checkpoint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_na` int(11) NOT NULL, `options` int(11) NOT NULL, `rank` int(11) NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `form_question_has_token` -- CREATE TABLE `form_question_has_token` ( `id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `token` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `id` int(11) NOT NULL, `name` text NOT NULL, `parent` int(11) DEFAULT NULL, `enabled` tinyint(1) NOT NULL, `weight` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `holiday` -- CREATE TABLE `holiday` ( `id` int(11) NOT NULL, `title` text COLLATE utf8_unicode_ci NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `type` enum('public','school','other') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ls_approval_group` -- CREATE TABLE `ls_approval_group` ( `id` int(11) NOT NULL, `title` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_approval_group_level` -- CREATE TABLE `ls_approval_group_level` ( `id` int(11) NOT NULL, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `level` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_approval_group_user` -- CREATE TABLE `ls_approval_group_user` ( `id` int(11) NOT NULL, `ag_id` int(11) NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_approval_record` -- CREATE TABLE `ls_approval_record` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `la_id` int(11) NOT NULL, `reason` varchar(256) NOT NULL, `status` enum('N','A','R') NOT NULL, `level_id` int(11) NOT NULL, `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_class_substitution` -- CREATE TABLE `ls_class_substitution` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `lesson` int(11) NOT NULL, `marks` int(11) NOT NULL, `status` enum('Pending','Confirmed','Cancelled') NOT NULL, `date` date NOT NULL, `cycle_day` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_entitlement` -- CREATE TABLE `ls_entitlement` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `ay_id` int(11) NOT NULL, `paid_leave` int(11) NOT NULL, `paid_maternity_leave` int(11) NOT NULL, `unpaid_maternity_leave` int(11) NOT NULL, `paternity_leave` int(11) NOT NULL, `special_leave` int(11) NOT NULL, `special_tuberculosis_leave` int(11) NOT NULL, `sepcial_event_leave` int(11) NOT NULL, `annual_leave` float NOT NULL, `carry_forward` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ls_it_weight` -- CREATE TABLE `ls_it_weight` ( `id` int(11) NOT NULL, `lt_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `weight` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_leave_application` -- CREATE TABLE `ls_leave_application` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `lt_id` int(11) NOT NULL, `dates` text NOT NULL, `half_day` tinyint(1) NOT NULL, `from_time` time NOT NULL, `to_time` time NOT NULL, `reason` varchar(256) NOT NULL, `status` enum('P','A','R','D','C') NOT NULL DEFAULT 'P', `gid` int(11) NOT NULL, `st_hire` int(11) NOT NULL, `leave_proof` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ls_leave_type` -- CREATE TABLE `ls_leave_type` ( `id` int(11) NOT NULL, `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `type` enum('PSL','MTL','PTL','SL','STL','SEL','AL','PL','NPL','NPML','CL') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NPL', `color` text COLLATE utf8_unicode_ci NOT NULL, `approval` tinyint(1) NOT NULL, `cpd` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ls_user_marks` -- CREATE TABLE `ls_user_marks` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `marks` int(11) NOT NULL, `type` enum('Class','Duty') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `msg_messages` -- CREATE TABLE `msg_messages` ( `id` int(11) NOT NULL, `thread_id` int(11) NOT NULL, `body` text NOT NULL, `priority` int(2) NOT NULL DEFAULT '0', `sender_id` int(11) NOT NULL, `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `msg_participants` -- CREATE TABLE `msg_participants` ( `user_id` int(11) NOT NULL, `thread_id` int(11) NOT NULL, `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `msg_status` -- CREATE TABLE `msg_status` ( `message_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `status` int(2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `msg_threads` -- CREATE TABLE `msg_threads` ( `id` int(11) NOT NULL, `subject` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `notification` -- CREATE TABLE `notification` ( `id` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `uid` int(11) NOT NULL, `msg` text COLLATE utf8_unicode_ci NOT NULL, `link` text COLLATE utf8_unicode_ci NOT NULL, `type` int(11) NOT NULL, `modules` enum('CORE','PR','AP','EB','TD','TB','AT','LS','OT','MIS') COLLATE utf8_unicode_ci NOT NULL, `read` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ot_approval_record` -- CREATE TABLE `ot_approval_record` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `ot_id` int(11) NOT NULL, `reason` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `status` enum('N','A','R') COLLATE utf8_unicode_ci NOT NULL, `level_id` int(11) NOT NULL, `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ot_overtime` -- CREATE TABLE `ot_overtime` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `date` date NOT NULL, `from_time` time NOT NULL, `to_time` time NOT NULL, `remarks` varchar(256) NOT NULL, `status` enum('P','R','A','D') NOT NULL DEFAULT 'P', `gid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `participants` -- CREATE TABLE `participants` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `is_enabled` tinyint(4) NOT NULL, `order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `participants_has_groups` -- CREATE TABLE `participants_has_groups` ( `id` int(11) NOT NULL, `participant_id` int(11) NOT NULL, `group_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `participant_group` -- CREATE TABLE `participant_group` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` int(11) NOT NULL, `permission_title` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `permission_key` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, `module` enum('CORE','PR','AP','EB','TD','TB','AT','LS','OT','MIS','APa','WF') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `permission_title`, `permission_key`, `module`) VALUES (1, 'Add User', 'ADD_USER', 'CORE'), (2, 'View All User', 'VIEW_ALL_USER', 'CORE'), (3, 'Edit All User', 'EDIT_ALL_USER', 'CORE'), (4, 'Delete All User', 'DELETE_ALL_USER', 'CORE'), (5, 'Block All User', 'BLOCK_ALL_USER', 'CORE'), (6, 'Assign User Role', 'ASSIGN_USER_ROLE', 'CORE'), (7, 'Manage User Data', 'MANAGE_USER_DATA', 'CORE'), (8, 'Manage User Group', 'MANAGE_USER_GROUP', 'CORE'), (9, 'Manage User Role', 'MANAGE_USER_ROLE', 'CORE'), (10, 'Manage User Permission', 'MANAGE_USER_PERMISSION', 'CORE'), (11, 'Add Permission', 'ADD_PERMISSION', 'CORE'), (12, 'Edit Permission', 'EDIT_PERMISSION', 'CORE'), (13, 'Manage Module', 'MANAGE_MODULE', 'CORE'), (14, 'Manage Site Setting', 'MANAGE_SITE_SETTING', 'CORE'), (15, 'Manage PR Policy', 'MANAGE_PR_POLICY', 'PR'), (16, 'Manage Financial Year', 'MANAGE_FINANCIAL_YEAR', 'PR'), (17, 'Manage Budget Group', 'MANAGE_BUDGET_GROUP', 'PR'), (18, 'Manage Budget Category', 'MANAGE_BUDGET_CATEGORY', 'PR'), (19, 'Apply My Budget Item (for my own departments)', 'APPLY_MY_BI', 'PR'), (20, 'Edit My Budget Item', 'EDIT_MY_BI', 'PR'), (21, 'Delete My Budget Item', 'DELETE_MY_BI', 'PR'), (22, 'Submit My Budget Item', 'SUBMIT_MY_BI', 'PR'), (23, 'Approve Budget Item', 'APPROVE_BI', 'PR'), (24, 'Add Budget Item (for all departments)', 'ADD_BI', 'PR'), (25, 'View All Budget Item', 'VIEW_ALL_BI', 'PR'), (26, 'Edit All Budget Item', 'EDIT_ALL_BI', 'PR'), (27, 'Delete All Budget Item', 'DELETE_ALL_BI', 'PR'), (28, 'Apply My Purchase Request', 'APPLY_MY_PR', 'PR'), (29, 'Edit My Purchase Request', 'EDIT_MY_PR', 'PR'), (30, 'Submit My Purchase Request', 'SUBMIT_MY_PR', 'PR'), (31, 'Cancel My Purchase Request', 'CANCEL_MY_PR', 'PR'), (32, 'Amend My Purchase Request', 'AMEND_MY_PR', 'PR'), (33, 'Delete My Purchase Request', 'DELETE_MY_PR', 'PR'), (34, 'Approve All Purchase Request (for non-head)', 'APPROVE_ALL_PR', 'PR'), (35, 'Complete All Purchase Request', 'COMPLETE_ALL_PR', 'PR'), (36, 'View All Purchase Request', 'VIEW_ALL_PR', 'PR'), (37, 'View BG Purchase Request', 'VIEW_BG_PR', 'PR'), (38, 'Edit All Purchase Request', 'EDIT_ALL_PR', 'PR'), (39, 'Delete All Purchase Request', 'DELETE_ALL_PR', 'PR'), (40, 'View All Budget Report', 'VIEW_ALL_BUDGET_REPORT', 'PR'), (41, 'View BG Budget Report', 'VIEW_BG_BUDGET_REPORT', 'PR'), (42, 'Input Voucher Number', 'INPUT_PR_VOUCHER_NO', 'PR'), (43, 'Manage PR Email Template', 'MANAGE_PR_EMAIL_TEMPLATE', 'PR'), (44, 'View All Tender', 'VIEW_ALL_TENDER', 'TD'), (45, 'Add Tender', 'ADD_TENDER', 'TD'), (46, 'Edit My Tender', 'EDIT_MY_TENDER', 'TD'), (47, 'Edit All Tender', 'EDIT_ALL_TENDER', 'TD'), (48, 'Delete All Tender', 'DELETE_ALL_TENDER', 'TD'), (49, 'Approve Urgent Tender', 'APPROVE_URGENT_TENDER', 'TD'), (50, 'Assign COI User', 'ASSIGN_COI_USER', 'TD'), (51, 'Manage Tender Setting', 'MANAGE_TENDER_SETTING', 'TD'), (52, 'Manage Tender Template', 'MANAGE_TENDER_TEMPLATE', 'TD'), (53, 'View My COI Record', 'VIEW_MY_COI_RECORD', 'TD'), (54, 'View All COI Record', 'VIEW_ALL_COI_RECORD', 'TD'), (55, 'Submit Tender', 'SUBMIT_TENDER', 'TD'), (56, 'Check Timetable', 'CHECK_TIMETABLE', 'TB'), (57, 'Manage Subject', 'MANAGE_SUBJECT', 'TB'), (58, 'Manage Class/Group', 'MANAGE_CLASS_GROUP', 'TB'), (59, 'Manage Subject Arrangement', 'MANAGE_SUB_ARG', 'TB'), (60, 'Manage Timetable', 'MANAGE_TIMETABLE', 'TB'), (61, 'View Attendance Report', 'VIEW_ATTENDANCE_REPORT', 'AT'), (62, 'Confirm Attendance Record', 'CONFIRM_ATTENDANCE_RECORD', 'AT'), (63, 'Manage Card Reader', 'MANAGE_CARD_READER', 'AT'), (64, 'Manage User Card', 'MANAGE_USER_CARD', 'AT'), (65, 'Manage Daily Time Rule', 'MANAGE_DTIME_RULE', 'AT'), (66, 'Assign Daily Time Rule', 'ASSIGN_DTIME_RULE', 'AT'), (67, 'Manage Special Time Rule', 'MANAGE_STIME_RULE', 'AT'), (68, 'Manage Supplier', 'MANAGE_SUPPLIER', 'MIS'), (69, 'View All Supplier', 'VIEW_ALL_SUPPLIER', 'MIS'), (71, 'Manage Venue', 'MANAGE_VENUE', 'MIS'), (72, 'Manage Facility', 'MANAGE_FACILITY', 'MIS'), (73, 'Manage Academic Year', 'MANAGE_ACADEMIC_YEAR', 'MIS'), (74, 'Manage Timeslot', 'MANAGE_TIMESLOT', 'MIS'), (75, 'Manage Holiday', 'MANAGE_HOLIDAY', 'MIS'), (80, 'Apply Overtime', 'APPLY_OVERTIME', 'OT'), (81, 'View All Overtime', 'VIEW_ALL_OVERTIME', 'OT'), (82, 'Edit All Overtime', 'EDIT_ALL_OVERTIME', 'OT'), (83, 'Delete All Overtime', 'DELETE_ALL_OVERTIME', 'OT'), (86, 'Apply Leave', 'APPLY_LEAVE', 'LS'), (87, 'Approve Leave', 'APPROVE_LEAVE', 'LS'), (88, 'View All Leave', 'VIEW_ALL_LEAVE', 'LS'), (89, 'Edit All Leave', 'EDIT_ALL_LEAVE', 'LS'), (90, 'Delete All Leave', 'DELETE_ALL_LEAVE', 'LS'), (91, 'Arrange Sub', 'ARRANGE_SUB', 'LS'), (92, 'View My Sub', 'VIEW_MY_SUB', 'LS'), (93, 'View All Sub', 'VIEW_ALL_SUB', 'LS'), (94, 'View Leave/Sub Report', 'VIEW_LEAVE_SUB_REPORT', 'LS'), (95, 'Manage Leave Type', 'MANAGE_LEAVE_TYPE', 'LS'), (96, 'Manage Approval Group', 'MANAGE_APPROVAL_GROUP', 'LS'), (97, 'Manage Leave Entitlement', 'MANAGE_ENTITLEMENT', 'LS'), (98, 'Manage Appraisal Setting', 'MANAGE_AP_SETTING', 'AP'), (99, 'Manage Appraisal Template', 'MANAGE_AP_TEMPLATE', 'AP'), (100, 'Manage Appraisal Level', 'MANAGE_AP_LEVEL', 'AP'), (101, 'Manage Appraisal Unit', 'MANAGE_AP_UNIT', 'AP'), (102, 'Manage Overall Appraisal', 'MANAGE_OA', 'AP'), (103, 'Manage Overall Appraisal Workflow', 'MANAGE_OA_WORKFLOW', 'AP'), (104, 'Manage Appraisal Email Template', 'MANAGE_AP_EMAIL_TEMPLATE', 'AP'), (105, 'Do My Appraisal', 'DO_MY_APPRAISAL', 'AP'), (106, 'View My Appraisal Report', 'VIEW_MY_APPRAISAL', 'AP'), (107, 'View all Appraisal Report', 'VIEW_ALL_APPRAISAL', 'AP'), (108, 'Delete Appraisal Data', 'DELETE_AP_DATA', 'AP'), (109, 'View Appraisal Report', 'VIEW_AP_REPORT', 'AP'), (110, 'Manage Appraisal Form', 'MANAGE_AP_FORM', 'AP'), (111, 'View All Attendance Report', 'VIEW_ALL_AT_REPORT', 'AT'), (112, 'View Group Attendance Report', 'VIEW_GROUP_AT_REPORT', 'AT'), (113, 'View My Attendance Report', 'VIEW_MY_AT_REPORT', 'AT'), (114, 'Approve Overtime', 'APPROVE_OVERTIME', 'OT'), (116, 'Manage Form Builder', 'MANAGE_FORM_BUILDER', 'MIS'), (117, 'Apply Form', 'APPLY_FORM', 'WF'), (118, 'View All Form', 'VIEW_ALL_FORM', 'WF'), (119, 'Access Form Approval', 'ACCESS_FORM_APPROVAL', 'WF'), (120, 'Manage Workflow Builder', 'MANAGE_WF_BUILDER', 'WF'); -- -------------------------------------------------------- -- -- Table structure for table `pr_approval_status` -- CREATE TABLE `pr_approval_status` ( `id` int(11) NOT NULL, `pr_id` int(11) DEFAULT NULL, `status` enum('pending','approved','rejected','cancelled','completed','draft') CHARACTER SET utf8 DEFAULT NULL, `approval_role_id` int(11) DEFAULT NULL, `updated_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_category` -- CREATE TABLE `pr_budget_category` ( `id` int(11) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `financial_year_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_group` -- CREATE TABLE `pr_budget_group` ( `id` int(11) NOT NULL, `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `financial_year_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_group_users` -- CREATE TABLE `pr_budget_group_users` ( `id` int(11) NOT NULL, `bg_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `role` enum('HEAD','MEMBER') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_items` -- CREATE TABLE `pr_budget_items` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `bg_id` int(11) NOT NULL, `budget_allowance` decimal(10,2) NOT NULL, `budget_amount` decimal(10,2) NOT NULL, `quantity` int(11) NOT NULL, `budget_pool_key_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `status` enum('PENDING','APPROVED','REJECTED','REVISED','SUBMITTED') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_items_history` -- CREATE TABLE `pr_budget_items_history` ( `id` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `bi_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `details` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_item_category` -- CREATE TABLE `pr_budget_item_category` ( `id` int(11) NOT NULL, `budget_item` int(11) NOT NULL, `budget_category` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_pool_keys` -- CREATE TABLE `pr_budget_pool_keys` ( `id` int(11) NOT NULL, `pool_key` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `total_budget_amount` decimal(10,2) NOT NULL, `bg_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_budget_return` -- CREATE TABLE `pr_budget_return` ( `id` int(11) NOT NULL, `bi_id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `amount` decimal(10,2) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_financial_years` -- CREATE TABLE `pr_financial_years` ( `id` int(11) NOT NULL, `year_start` date NOT NULL, `year_end` date NOT NULL, `financial_year_label` varchar(12) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_from_tender` -- CREATE TABLE `pr_from_tender` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `tender_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_has_reference_supplier` -- CREATE TABLE `pr_has_reference_supplier` ( `id` int(11) NOT NULL, `supplier_id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `file_ext` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `pic_id` int(11) NOT NULL, `price` decimal(10,0) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_has_sub_items` -- CREATE TABLE `pr_has_sub_items` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `quantity` int(11) NOT NULL, `unit_price` decimal(10,0) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_payment_record` -- CREATE TABLE `pr_payment_record` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `date` date NOT NULL, `amount` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_purchase_approval_history` -- CREATE TABLE `pr_purchase_approval_history` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `status` enum('draft','pending','approved','rejected','completed','cancelled') COLLATE utf8_unicode_ci NOT NULL, `updated_on` datetime NOT NULL, `status_updated_by` int(11) NOT NULL, `is_approve_action` int(11) NOT NULL, `reject_reason` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_purchase_budget_items` -- CREATE TABLE `pr_purchase_budget_items` ( `id` int(11) NOT NULL, `pr_id` int(11) DEFAULT NULL, `bg_bi_id` int(11) DEFAULT NULL, `request_amount` decimal(10,2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_settings` -- CREATE TABLE `pr_settings` ( `id` int(11) NOT NULL, `key` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `val` text CHARACTER SET utf8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_settings_approval_role` -- CREATE TABLE `pr_settings_approval_role` ( `id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `weight` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_settings_approval_workflow` -- CREATE TABLE `pr_settings_approval_workflow` ( `id` int(11) NOT NULL, `settings_price_range_id` int(11) DEFAULT NULL, `role_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pr_settings_price_range` -- CREATE TABLE `pr_settings_price_range` ( `id` int(11) NOT NULL, `start_range` decimal(10,2) DEFAULT NULL, `end_range` decimal(10,2) DEFAULT NULL, `quotation_file_required` tinyint(1) DEFAULT NULL, `number_of_suppliers` tinyint(4) DEFAULT NULL, `ref_quotation_file_required` tinyint(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; -- -------------------------------------------------------- -- -- Table structure for table `pr_student_payment` -- CREATE TABLE `pr_student_payment` ( `id` int(11) NOT NULL, `pr_id` int(11) NOT NULL, `number_of_students` int(11) NOT NULL, `payment_per_student` decimal(10,0) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `purchase_request` -- CREATE TABLE `purchase_request` ( `id` int(11) NOT NULL, `pr_reference_number_prefix` varchar(120) COLLATE utf8_unicode_ci NOT NULL, `pr_reference_number_count` int(11) NOT NULL, `item_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `require_date` date NOT NULL, `delivery_date` date NOT NULL, `usage` text COLLATE utf8_unicode_ci, `is_applicant_other` tinyint(1) DEFAULT NULL, `applicant_id` int(11) DEFAULT NULL, `submitted_by` int(11) DEFAULT NULL, `reason_for_multiple_items` text COLLATE utf8_unicode_ci, `total_request_amount` decimal(10,2) DEFAULT NULL, `payment_from_students` decimal(10,2) DEFAULT NULL, `chosen_supplier_id` int(11) DEFAULT NULL, `chosen_price` decimal(10,2) DEFAULT NULL, `chosen_supplier_quotation_file_ext` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `is_sole_supplier` tinyint(1) DEFAULT NULL, `is_tender_payment` tinyint(1) DEFAULT NULL, `other_reasons_cannot_provide_ref_sup` tinyint(1) DEFAULT NULL, `reason_no_reference_supplier` text COLLATE utf8_unicode_ci, `reason_no_lower_price` text COLLATE utf8_unicode_ci, `remarks` text COLLATE utf8_unicode_ci, `payment_method` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `cheque_payable_to` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `status` enum('draft','pending') COLLATE utf8_unicode_ci DEFAULT NULL, `amend_count` int(11) NOT NULL, `voucher_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `copy_of` int(11) NOT NULL, `serializeData` mediumtext COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` int(11) NOT NULL, `role` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `is_approval_role` int(11) NOT NULL, `system_role` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='All roles available for the system'; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `role`, `is_approval_role`, `system_role`) VALUES (2, 'Staff', 0, 0), (3, 'Principal', 0, 0), (4, 'Teacher', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `roles_permission` -- CREATE TABLE `roles_permission` ( `id` int(11) NOT NULL, `role_id` int(11) DEFAULT NULL, `permission_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='<double-click to overwrite multiple objects>'; -- -- Dumping data for table `roles_permission` -- INSERT INTO `roles_permission` (`id`, `role_id`, `permission_id`) VALUES (56, 2, 15), (57, 2, 16), (58, 2, 17), (59, 2, 18), (60, 2, 19), (61, 2, 20), (62, 2, 21), (63, 2, 22), (64, 3, 23), (65, 2, 23), (66, 2, 24), (67, 2, 25), (68, 2, 26), (69, 2, 27), (70, 2, 28), (71, 2, 29), (72, 2, 30), (73, 2, 31), (74, 2, 32), (75, 2, 33), (76, 3, 34), (77, 2, 34), (78, 2, 35), (79, 2, 36), (80, 2, 37), (81, 2, 38), (82, 2, 39), (83, 2, 40), (84, 2, 41), (85, 2, 42), (86, 2, 43), (87, 3, 117), (88, 2, 117), (89, 4, 117), (90, 3, 118), (91, 2, 118), (92, 3, 119), (93, 4, 119); -- -------------------------------------------------------- -- -- Table structure for table `site_settings` -- CREATE TABLE `site_settings` ( `id` int(11) NOT NULL, `setting` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(512) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `site_settings` -- INSERT INTO `site_settings` (`id`, `setting`, `value`) VALUES (1, 'site_name', 'Camplus Admin'), (2, 'school_name', 'Demo School'), (3, 'school_logo_ext', 'png'), (4, 'modules', 'a:1:{s:7:\"modules\";a:19:{i:0;s:10:\"attendance\";i:1;s:9:\"appraisal\";i:2;s:7:\"holiday\";i:3;s:4:\"form\";i:4;s:6:\"tender\";i:5;s:13:\"event_booking\";i:6;s:8:\"facility\";i:7;s:8:\"supplier\";i:8;s:8:\"workflow\";i:9;s:8:\"timeslot\";i:10;s:14:\"access_control\";i:11;s:5:\"venue\";i:12;s:10:\"appraisala\";i:13;s:13:\"academic_year\";i:14;s:8:\"overtime\";i:15;s:9:\"timetable\";i:16;s:16:\"purchase_request\";i:17;s:9:\"leave_sub\";i:18;s:4:\"core\";}}'), (5, 'google-client-id', ''), (6, 'google-client-secret', ''), (7, 'google-redirect', ''), (8, 'api_user', ''), (9, 'api_password', 'e10adc3949ba59abbe56e057f20f883e'), (10, 'api_url', ''), (11, 'default_front_page', 'workflow/Workflow_form/listing'); -- -------------------------------------------------------- -- -- Table structure for table `suppliers` -- CREATE TABLE `suppliers` ( `id` int(11) NOT NULL, `supplier` varchar(100) CHARACTER SET utf8 DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `supplier_alias` -- CREATE TABLE `supplier_alias` ( `id` int(11) NOT NULL, `host_id` int(11) NOT NULL, `alias_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `supplier_pic` -- CREATE TABLE `supplier_pic` ( `id` int(11) NOT NULL, `supplier_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `tel` int(15) DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tb_class` -- CREATE TABLE `tb_class` ( `id` int(11) NOT NULL, `title` text COLLATE utf8_unicode_ci NOT NULL, `venue_id` int(11) NOT NULL, `ac_year_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tb_class_user` -- CREATE TABLE `tb_class_user` ( `id` int(11) NOT NULL, `class_id` int(11) NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tb_subjects` -- CREATE TABLE `tb_subjects` ( `id` int(11) NOT NULL, `name_chi` text COLLATE utf8_unicode_ci NOT NULL, `name_eng` text COLLATE utf8_unicode_ci NOT NULL, `shortname_chi` text COLLATE utf8_unicode_ci NOT NULL, `shortname_eng` text COLLATE utf8_unicode_ci NOT NULL, `venue_id` int(11) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tb_tea_class_sub` -- CREATE TABLE `tb_tea_class_sub` ( `id` int(11) NOT NULL, `ay_id` int(11) NOT NULL, `sub_id` int(11) NOT NULL, `class_id` int(11) NOT NULL, `uid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tb_timetable` -- CREATE TABLE `tb_timetable` ( `id` int(11) NOT NULL, `ay_id` int(11) NOT NULL, `cycle_day` int(11) NOT NULL, `ts_id` int(11) NOT NULL, `ap_name` text CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tb_timetable_teacher` -- CREATE TABLE `tb_timetable_teacher` ( `id` int(11) NOT NULL, `tb_id` int(11) NOT NULL, `teaclasub_id` int(11) NOT NULL, `slot_id` int(11) NOT NULL, `day` int(11) NOT NULL, `uid` int(11) NOT NULL, `venue_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_code_pattern` -- CREATE TABLE `td_code_pattern` ( `id` int(11) NOT NULL, `pattern` varchar(20) NOT NULL, `next_code_no` int(11) NOT NULL, `min_quotation` int(11) NOT NULL, `prefix` varchar(2) NOT NULL, `due_date` int(11) NOT NULL, `urgent_days` int(11) NOT NULL, `status` enum('A','D') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_comparison` -- CREATE TABLE `td_comparison` ( `id` int(11) NOT NULL, `sid` int(11) NOT NULL, `item_id` int(11) NOT NULL, `content` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_comparison_items` -- CREATE TABLE `td_comparison_items` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `item_name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_content_list` -- CREATE TABLE `td_content_list` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `content` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_content_parts` -- CREATE TABLE `td_content_parts` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `status` tinyint(1) NOT NULL, `order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_forms` -- CREATE TABLE `td_forms` ( `id` int(11) NOT NULL, `title` varchar(20) NOT NULL, `serialized_data` longtext NOT NULL, `signature` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `td_form_questions` -- CREATE TABLE `td_form_questions` ( `id` int(11) NOT NULL, `t_form_id` int(11) NOT NULL, `question` varchar(100) NOT NULL, `color` varchar(50) NOT NULL, `detail` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_groupcoi_users` -- CREATE TABLE `td_groupcoi_users` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `next_count` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_group_coi` -- CREATE TABLE `td_group_coi` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_group_coi_user_count` -- CREATE TABLE `td_group_coi_user_count` ( `id` int(11) NOT NULL, `gid` int(11) NOT NULL, `uid` int(11) NOT NULL, `next_count` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_log` -- CREATE TABLE `td_log` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `tid` int(11) NOT NULL, `status` enum('P','A','R') NOT NULL, `reason` varchar(256) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_open_tender` -- CREATE TABLE `td_open_tender` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `sid` int(11) NOT NULL, `replay_status` enum('Offer','No Offer','Received Late','No Replay') NOT NULL, `price` double(11,3) NOT NULL, `mark` int(11) NOT NULL, `remark` int(11) NOT NULL, `file` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_suppliers` -- CREATE TABLE `td_suppliers` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `sid` int(11) NOT NULL, `chosen` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_templates` -- CREATE TABLE `td_templates` ( `id` int(11) NOT NULL, `cid` int(11) NOT NULL, `title` varchar(50) NOT NULL, `content` text NOT NULL, `status` tinyint(1) NOT NULL, `type` enum('','COI') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_tenders` -- CREATE TABLE `td_tenders` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `title` varchar(20) NOT NULL, `code_pattern_id` int(11) NOT NULL, `tender_code` varchar(50) NOT NULL, `posting_date` date NOT NULL, `due_date` date NOT NULL, `person` varchar(50) NOT NULL, `budget` bigint(20) NOT NULL, `urgent_reason` varchar(50) NOT NULL, `status` set('APPROVED','REJECTED','PENDING','DRAFT') NOT NULL DEFAULT 'DRAFT', `coi_status` enum('DRAFT','SUBMITTED') NOT NULL, `open_tender_status` enum('DRAFT','SUBMITTED') NOT NULL, `comparison_status` enum('DRAFT','SUBMITTED') NOT NULL, `approval_uid` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `attachment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `serialized_data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ref_no` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_tender_coi_history` -- CREATE TABLE `td_tender_coi_history` ( `id` int(11) NOT NULL, `tid` int(11) NOT NULL, `sid` int(11) NOT NULL, `uid` int(11) NOT NULL, `remarks` varchar(50) NOT NULL, `status` tinyint(1) NOT NULL, `time` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `td_user_coi` -- CREATE TABLE `td_user_coi` ( `id` int(11) NOT NULL, `sid` int(11) NOT NULL, `uid` int(11) NOT NULL, `conflict` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `timeslot_sets` -- CREATE TABLE `timeslot_sets` ( `id` int(11) NOT NULL, `title` mediumtext NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `time_slots` -- CREATE TABLE `time_slots` ( `id` int(11) NOT NULL, `lesson_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `time_from` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `time_to` varchar(55) COLLATE utf8_unicode_ci NOT NULL, `mark` int(11) NOT NULL, `type` enum('Class','Duty') COLLATE utf8_unicode_ci NOT NULL, `sets` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `name_chinese` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `name_english` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `created_on` datetime NOT NULL, `type` enum('Teaching Staff','Laboratory Technicians','Specialist Staff','Non-teaching Staff') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Teaching Staff', `service_commencement_date` date NOT NULL, `contract_date` date NOT NULL, `rank` text COLLATE utf8_unicode_ci NOT NULL, `teaching_exp` int(11) NOT NULL, `pay_day` date NOT NULL, `model_scale` enum('MPS','MOD') COLLATE utf8_unicode_ci NOT NULL, `pay_grade` int(11) NOT NULL, `grant_source` enum('RAG','SG') COLLATE utf8_unicode_ci NOT NULL, `last_logged_in` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `status` enum('ACTIVE','BLOCKED') COLLATE utf8_unicode_ci NOT NULL, `front_page` text COLLATE utf8_unicode_ci NOT NULL, `oauth_provider` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `oauth_uid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `gender` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `locale` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `picture_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `profile_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `modified` datetime NOT NULL, `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `title` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `email`, `name_chinese`, `name_english`, `password`, `created_on`, `type`, `service_commencement_date`, `contract_date`, `rank`, `teaching_exp`, `pay_day`, `model_scale`, `pay_grade`, `grant_source`, `last_logged_in`, `status`, `front_page`, `oauth_provider`, `oauth_uid`, `gender`, `locale`, `picture_url`, `profile_url`, `modified`, `first_name`, `last_name`, `title`) VALUES (1, 'admin', 'info@camplus.hk', 'System', 'Admin', 'e10adc3949ba59abbe56e057f20f883e', '2016-08-26 00:00:00', 'Teaching Staff', '2014-05-09', '0000-00-00', '', 0, '0000-00-00', 'MPS', 1, '', '', 'ACTIVE', 'purchase_request/my_purchase_requests', 'google', '', 'male', 'zh-TW', '', '', '2018-01-02 05:57:00', '', '', ''), (2, 'user1', 'user1@demo.com', '用戶1', 'User 1', 'e10adc3949ba59abbe56e057f20f883e', '2018-03-22 22:28:01', 'Teaching Staff', '0000-00-00', '0000-00-00', '', 0, '0000-00-00', 'MPS', 0, 'RAG', '', 'ACTIVE', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', ''), (3, 'user2', 'user2@demo.com', '用戶2', 'User 2', 'fe01ce2a7fbac8fafaed7c982a04e229', '2018-03-22 22:31:41', 'Teaching Staff', '0000-00-00', '0000-00-00', '', 0, '0000-00-00', 'MPS', 0, 'RAG', '', 'ACTIVE', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', ''), (4, 'principal', 'principal@demo.com', '校長', 'Principal', 'e10adc3949ba59abbe56e057f20f883e', '2018-03-22 22:32:04', 'Teaching Staff', '0000-00-00', '0000-00-00', '', 0, '0000-00-00', 'MPS', 0, 'RAG', '', 'ACTIVE', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', ''), (5, 'user3', 'user3@demo.com', '用戶3', 'User 3', 'e10adc3949ba59abbe56e057f20f883e', '2018-03-22 22:33:04', 'Teaching Staff', '0000-00-00', '0000-00-00', '', 0, '0000-00-00', 'MPS', 0, 'RAG', '', 'ACTIVE', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `users_cpd` -- CREATE TABLE `users_cpd` ( `id` int(11) NOT NULL, `dates` text COLLATE utf8_unicode_ci NOT NULL, `time` text COLLATE utf8_unicode_ci NOT NULL, `venue` text COLLATE utf8_unicode_ci NOT NULL, `organizer` text COLLATE utf8_unicode_ci NOT NULL, `domain` text COLLATE utf8_unicode_ci NOT NULL, `details` longtext COLLATE utf8_unicode_ci NOT NULL, `hours` float NOT NULL, `uid` int(11) NOT NULL, `la_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users_group` -- CREATE TABLE `users_group` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `group_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `users_roles` -- CREATE TABLE `users_roles` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `role_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `users_roles` -- INSERT INTO `users_roles` (`id`, `user_id`, `role_id`) VALUES (5, 2, 2), (6, 2, 4), (7, 3, 2), (8, 3, 4), (9, 5, 2), (10, 5, 4), (11, 1, 2), (12, 1, 4), (13, 4, 3); -- -------------------------------------------------------- -- -- Table structure for table `venues` -- CREATE TABLE `venues` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `venuegroup` int(11) NOT NULL, `remarks` mediumtext COLLATE utf8_unicode_ci NOT NULL, `order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `venue_group` -- CREATE TABLE `venue_group` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_filled_form` -- CREATE TABLE `wf_filled_form` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `fid` int(11) NOT NULL, `unit` text COLLATE utf8_unicode_ci NOT NULL, `workflow` text COLLATE utf8_unicode_ci NOT NULL, `urgent_reason` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `apply_date` date NOT NULL, `status` text COLLATE utf8_unicode_ci NOT NULL, `last_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_form_answers` -- CREATE TABLE `wf_form_answers` ( `id` int(11) NOT NULL, `ff_id` int(11) NOT NULL, `q_domain` longtext COLLATE utf8_unicode_ci NOT NULL, `answer` longtext COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_form_status` -- CREATE TABLE `wf_form_status` ( `id` int(11) NOT NULL, `ff_id` int(11) NOT NULL, `uid` int(11) NOT NULL, `action` enum('Pending','Agree','Disagree','Cancel') COLLATE utf8_unicode_ci NOT NULL, `level` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_form_workflow` -- CREATE TABLE `wf_form_workflow` ( `id` int(11) NOT NULL, `fid` int(11) NOT NULL, `wid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wf_workflow` -- CREATE TABLE `wf_workflow` ( `id` int(11) NOT NULL, `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `urgent_days` int(11) NOT NULL, `workflow` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `academic_years` -- ALTER TABLE `academic_years` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ac_devices` -- ALTER TABLE `ac_devices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ac_receiver` -- ALTER TABLE `ac_receiver` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ac_record` -- ALTER TABLE `ac_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ac_whitelist` -- ALTER TABLE `ac_whitelist` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_answer` -- ALTER TABLE `ap_answer` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `ap_filled_form` -- ALTER TABLE `ap_filled_form` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_form` -- ALTER TABLE `ap_form` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_form_sections` -- ALTER TABLE `ap_form_sections` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `ap_form_section_unit` -- ALTER TABLE `ap_form_section_unit` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_form_section_unit_user` -- ALTER TABLE `ap_form_section_unit_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ap_form_section_user` -- ALTER TABLE `ap_form_section_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_attendance_report` -- ALTER TABLE `at_attendance_report` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_attendance_rule_dates` -- ALTER TABLE `at_attendance_rule_dates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_attendance_rule_period` -- ALTER TABLE `at_attendance_rule_period` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_daily_attendance` -- ALTER TABLE `at_daily_attendance` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_daily_attendance_timeset` -- ALTER TABLE `at_daily_attendance_timeset` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_record` -- ALTER TABLE `at_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_special_attendance` -- ALTER TABLE `at_special_attendance` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_special_attendance_timeset` -- ALTER TABLE `at_special_attendance_timeset` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_user_card` -- ALTER TABLE `at_user_card` ADD PRIMARY KEY (`id`); -- -- Indexes for table `at_user_time_rule_set` -- ALTER TABLE `at_user_time_rule_set` ADD PRIMARY KEY (`id`); -- -- Indexes for table `calendar_type` -- ALTER TABLE `calendar_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `calendar_type_has_forms` -- ALTER TABLE `calendar_type_has_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `circulars` -- ALTER TABLE `circulars` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `circular_templates` -- ALTER TABLE `circular_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `doorEventLog` -- ALTER TABLE `doorEventLog` ADD PRIMARY KEY (`event_id`), ADD KEY `cardReaderID` (`cardReaderID`); -- -- Indexes for table `eb_facilities` -- ALTER TABLE `eb_facilities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `eb_settings` -- ALTER TABLE `eb_settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `SETTING_KEY_UNIQUE` (`key`); -- -- Indexes for table `eb_time_slots` -- ALTER TABLE `eb_time_slots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `eb_venues` -- ALTER TABLE `eb_venues` ADD PRIMARY KEY (`id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`), ADD KEY `status` (`status`), ADD KEY `calendar_type_id` (`calendar_type_id`); -- -- Indexes for table `event_forms_history` -- ALTER TABLE `event_forms_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `event_has_files` -- ALTER TABLE `event_has_files` ADD PRIMARY KEY (`id`); -- -- Indexes for table `event_has_forms` -- ALTER TABLE `event_has_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `event_has_sections` -- ALTER TABLE `event_has_sections` ADD PRIMARY KEY (`id`), ADD KEY `event_id` (`event_id`), ADD KEY `startDate` (`startDate`), ADD KEY `from_time` (`from_time`), ADD KEY `to_time` (`to_time`); -- -- Indexes for table `event_section_has_facilities` -- ALTER TABLE `event_section_has_facilities` ADD PRIMARY KEY (`id`), ADD KEY `section_id` (`section_id`); -- -- Indexes for table `event_section_has_participants` -- ALTER TABLE `event_section_has_participants` ADD PRIMARY KEY (`id`), ADD KEY `section_id` (`section_id`); -- -- Indexes for table `event_section_has_venues` -- ALTER TABLE `event_section_has_venues` ADD PRIMARY KEY (`id`), ADD KEY `section_id` (`section_id`), ADD KEY `venue_id` (`venue_id`); -- -- Indexes for table `event_types` -- ALTER TABLE `event_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `facilities` -- ALTER TABLE `facilities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form` -- ALTER TABLE `form` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `forms` -- ALTER TABLE `forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_answers` -- ALTER TABLE `form_answers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_answer_has_grid` -- ALTER TABLE `form_answer_has_grid` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_answer_has_table` -- ALTER TABLE `form_answer_has_table` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_has_questions` -- ALTER TABLE `form_has_questions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_question_has_options` -- ALTER TABLE `form_question_has_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_question_has_questions` -- ALTER TABLE `form_question_has_questions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `form_question_has_token` -- ALTER TABLE `form_question_has_token` ADD PRIMARY KEY (`id`); -- -- Indexes for table `groups` -- ALTER TABLE `groups` ADD PRIMARY KEY (`id`); -- -- Indexes for table `holiday` -- ALTER TABLE `holiday` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_approval_group` -- ALTER TABLE `ls_approval_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_approval_group_level` -- ALTER TABLE `ls_approval_group_level` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_approval_group_user` -- ALTER TABLE `ls_approval_group_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_approval_record` -- ALTER TABLE `ls_approval_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_class_substitution` -- ALTER TABLE `ls_class_substitution` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_entitlement` -- ALTER TABLE `ls_entitlement` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_it_weight` -- ALTER TABLE `ls_it_weight` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_leave_application` -- ALTER TABLE `ls_leave_application` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_leave_type` -- ALTER TABLE `ls_leave_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ls_user_marks` -- ALTER TABLE `ls_user_marks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `msg_messages` -- ALTER TABLE `msg_messages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `msg_participants` -- ALTER TABLE `msg_participants` ADD PRIMARY KEY (`user_id`,`thread_id`); -- -- Indexes for table `msg_status` -- ALTER TABLE `msg_status` ADD PRIMARY KEY (`message_id`,`user_id`); -- -- Indexes for table `msg_threads` -- ALTER TABLE `msg_threads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notification` -- ALTER TABLE `notification` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ot_approval_record` -- ALTER TABLE `ot_approval_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ot_overtime` -- ALTER TABLE `ot_overtime` ADD PRIMARY KEY (`id`); -- -- Indexes for table `participants` -- ALTER TABLE `participants` ADD PRIMARY KEY (`id`); -- -- Indexes for table `participants_has_groups` -- ALTER TABLE `participants_has_groups` ADD PRIMARY KEY (`id`); -- -- Indexes for table `participant_group` -- ALTER TABLE `participant_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permission_title_UNIQUE` (`permission_title`), ADD UNIQUE KEY `permission_key_UNIQUE` (`permission_key`); -- -- Indexes for table `pr_approval_status` -- ALTER TABLE `pr_approval_status` ADD PRIMARY KEY (`id`), ADD KEY `purchase_request_id_idx` (`pr_id`), ADD KEY `waiting_for_approval_by_idx` (`approval_role_id`); -- -- Indexes for table `pr_budget_category` -- ALTER TABLE `pr_budget_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_group` -- ALTER TABLE `pr_budget_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_group_users` -- ALTER TABLE `pr_budget_group_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_items` -- ALTER TABLE `pr_budget_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_items_history` -- ALTER TABLE `pr_budget_items_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_item_category` -- ALTER TABLE `pr_budget_item_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_pool_keys` -- ALTER TABLE `pr_budget_pool_keys` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_budget_return` -- ALTER TABLE `pr_budget_return` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_financial_years` -- ALTER TABLE `pr_financial_years` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_from_tender` -- ALTER TABLE `pr_from_tender` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_has_reference_supplier` -- ALTER TABLE `pr_has_reference_supplier` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_has_sub_items` -- ALTER TABLE `pr_has_sub_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_payment_record` -- ALTER TABLE `pr_payment_record` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pr_purchase_approval_history` -- ALTER TABLE `pr_purchase_approval_history` ADD PRIMARY KEY (`id`), ADD KEY `purchase_request_id` (`pr_id`), ADD KEY `status` (`status`), ADD KEY `is_approve_action` (`is_approve_action`), ADD KEY `updated_on` (`updated_on`); -- -- Indexes for table `pr_purchase_budget_items` -- ALTER TABLE `pr_purchase_budget_items` ADD PRIMARY KEY (`id`), ADD KEY `budget_item_id_idx` (`bg_bi_id`), ADD KEY `purchase_request_id_idx` (`pr_id`); -- -- Indexes for table `pr_settings` -- ALTER TABLE `pr_settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `SETTING_KEY_UNIQUE` (`key`); -- -- Indexes for table `pr_settings_approval_role` -- ALTER TABLE `pr_settings_approval_role` ADD PRIMARY KEY (`id`), ADD KEY `role_id` (`role_id`); -- -- Indexes for table `pr_settings_approval_workflow` -- ALTER TABLE `pr_settings_approval_workflow` ADD PRIMARY KEY (`id`), ADD KEY `price_range_id_idx` (`settings_price_range_id`), ADD KEY `role_id_idx` (`role_id`); -- -- Indexes for table `pr_settings_price_range` -- ALTER TABLE `pr_settings_price_range` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `start_range_UNIQUE` (`start_range`), ADD UNIQUE KEY `end_range_UNIQUE` (`end_range`); -- -- Indexes for table `pr_student_payment` -- ALTER TABLE `pr_student_payment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchase_request` -- ALTER TABLE `purchase_request` ADD PRIMARY KEY (`id`), ADD KEY `applicant_id_idx` (`applicant_id`), ADD KEY `submited_by_idx` (`submitted_by`), ADD KEY `chosen_supplier_id_idx` (`chosen_supplier_id`), ADD KEY `item_name` (`item_name`), ADD KEY `item_name_2` (`item_name`), ADD KEY `applicant_id` (`applicant_id`), ADD KEY `submitted_by` (`submitted_by`), ADD KEY `chosen_price` (`chosen_price`), ADD KEY `voucher_number` (`voucher_number`), ADD KEY `status` (`status`), ADD KEY `payment_method` (`payment_method`), ADD KEY `chosen_price_2` (`chosen_price`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD KEY `role` (`role`); -- -- Indexes for table `roles_permission` -- ALTER TABLE `roles_permission` ADD PRIMARY KEY (`id`), ADD KEY `role_id_idx` (`role_id`), ADD KEY `permission_id_idx` (`permission_id`); -- -- Indexes for table `site_settings` -- ALTER TABLE `site_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `suppliers` -- ALTER TABLE `suppliers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `supplier` (`supplier`); -- -- Indexes for table `supplier_alias` -- ALTER TABLE `supplier_alias` ADD PRIMARY KEY (`id`); -- -- Indexes for table `supplier_pic` -- ALTER TABLE `supplier_pic` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_class` -- ALTER TABLE `tb_class` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_class_user` -- ALTER TABLE `tb_class_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_subjects` -- ALTER TABLE `tb_subjects` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_tea_class_sub` -- ALTER TABLE `tb_tea_class_sub` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_timetable` -- ALTER TABLE `tb_timetable` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_timetable_teacher` -- ALTER TABLE `tb_timetable_teacher` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_code_pattern` -- ALTER TABLE `td_code_pattern` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_comparison` -- ALTER TABLE `td_comparison` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_comparison_items` -- ALTER TABLE `td_comparison_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_content_list` -- ALTER TABLE `td_content_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_content_parts` -- ALTER TABLE `td_content_parts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_forms` -- ALTER TABLE `td_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_form_questions` -- ALTER TABLE `td_form_questions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_groupcoi_users` -- ALTER TABLE `td_groupcoi_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_group_coi` -- ALTER TABLE `td_group_coi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_group_coi_user_count` -- ALTER TABLE `td_group_coi_user_count` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_log` -- ALTER TABLE `td_log` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_open_tender` -- ALTER TABLE `td_open_tender` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_suppliers` -- ALTER TABLE `td_suppliers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_templates` -- ALTER TABLE `td_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_tenders` -- ALTER TABLE `td_tenders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_tender_coi_history` -- ALTER TABLE `td_tender_coi_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `td_user_coi` -- ALTER TABLE `td_user_coi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `timeslot_sets` -- ALTER TABLE `timeslot_sets` ADD PRIMARY KEY (`id`); -- -- Indexes for table `time_slots` -- ALTER TABLE `time_slots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users_cpd` -- ALTER TABLE `users_cpd` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users_group` -- ALTER TABLE `users_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users_roles` -- ALTER TABLE `users_roles` ADD PRIMARY KEY (`id`), ADD KEY `role_id_idx` (`role_id`), ADD KEY `user_id_idx` (`user_id`); -- -- Indexes for table `venues` -- ALTER TABLE `venues` ADD PRIMARY KEY (`id`); -- -- Indexes for table `venue_group` -- ALTER TABLE `venue_group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wf_filled_form` -- ALTER TABLE `wf_filled_form` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wf_form_answers` -- ALTER TABLE `wf_form_answers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wf_form_status` -- ALTER TABLE `wf_form_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wf_form_workflow` -- ALTER TABLE `wf_form_workflow` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wf_workflow` -- ALTER TABLE `wf_workflow` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `academic_years` -- ALTER TABLE `academic_years` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ac_devices` -- ALTER TABLE `ac_devices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ac_receiver` -- ALTER TABLE `ac_receiver` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ac_record` -- ALTER TABLE `ac_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ac_whitelist` -- ALTER TABLE `ac_whitelist` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_answer` -- ALTER TABLE `ap_answer` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_filled_form` -- ALTER TABLE `ap_filled_form` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form` -- ALTER TABLE `ap_form` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form_sections` -- ALTER TABLE `ap_form_sections` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form_section_unit` -- ALTER TABLE `ap_form_section_unit` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form_section_unit_user` -- ALTER TABLE `ap_form_section_unit_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ap_form_section_user` -- ALTER TABLE `ap_form_section_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_attendance_report` -- ALTER TABLE `at_attendance_report` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_attendance_rule_dates` -- ALTER TABLE `at_attendance_rule_dates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_attendance_rule_period` -- ALTER TABLE `at_attendance_rule_period` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_daily_attendance` -- ALTER TABLE `at_daily_attendance` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_daily_attendance_timeset` -- ALTER TABLE `at_daily_attendance_timeset` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_record` -- ALTER TABLE `at_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_special_attendance` -- ALTER TABLE `at_special_attendance` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_special_attendance_timeset` -- ALTER TABLE `at_special_attendance_timeset` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_user_card` -- ALTER TABLE `at_user_card` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `at_user_time_rule_set` -- ALTER TABLE `at_user_time_rule_set` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `calendar_type` -- ALTER TABLE `calendar_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `calendar_type_has_forms` -- ALTER TABLE `calendar_type_has_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `circulars` -- ALTER TABLE `circulars` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `circular_templates` -- ALTER TABLE `circular_templates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `doorEventLog` -- ALTER TABLE `doorEventLog` MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `eb_facilities` -- ALTER TABLE `eb_facilities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `eb_settings` -- ALTER TABLE `eb_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `eb_time_slots` -- ALTER TABLE `eb_time_slots` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `eb_venues` -- ALTER TABLE `eb_venues` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_forms_history` -- ALTER TABLE `event_forms_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_has_files` -- ALTER TABLE `event_has_files` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_has_forms` -- ALTER TABLE `event_has_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_has_sections` -- ALTER TABLE `event_has_sections` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_section_has_facilities` -- ALTER TABLE `event_section_has_facilities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_section_has_participants` -- ALTER TABLE `event_section_has_participants` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_section_has_venues` -- ALTER TABLE `event_section_has_venues` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_types` -- ALTER TABLE `event_types` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `facilities` -- ALTER TABLE `facilities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form` -- ALTER TABLE `form` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `forms` -- ALTER TABLE `forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_answers` -- ALTER TABLE `form_answers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_answer_has_grid` -- ALTER TABLE `form_answer_has_grid` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_answer_has_table` -- ALTER TABLE `form_answer_has_table` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_has_questions` -- ALTER TABLE `form_has_questions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_question_has_options` -- ALTER TABLE `form_question_has_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_question_has_questions` -- ALTER TABLE `form_question_has_questions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `form_question_has_token` -- ALTER TABLE `form_question_has_token` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `groups` -- ALTER TABLE `groups` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `holiday` -- ALTER TABLE `holiday` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_approval_group` -- ALTER TABLE `ls_approval_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_approval_group_level` -- ALTER TABLE `ls_approval_group_level` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_approval_group_user` -- ALTER TABLE `ls_approval_group_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_approval_record` -- ALTER TABLE `ls_approval_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_class_substitution` -- ALTER TABLE `ls_class_substitution` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_entitlement` -- ALTER TABLE `ls_entitlement` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_it_weight` -- ALTER TABLE `ls_it_weight` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_leave_application` -- ALTER TABLE `ls_leave_application` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_leave_type` -- ALTER TABLE `ls_leave_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ls_user_marks` -- ALTER TABLE `ls_user_marks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `msg_messages` -- ALTER TABLE `msg_messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `msg_threads` -- ALTER TABLE `msg_threads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notification` -- ALTER TABLE `notification` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ot_approval_record` -- ALTER TABLE `ot_approval_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ot_overtime` -- ALTER TABLE `ot_overtime` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `participants` -- ALTER TABLE `participants` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `participants_has_groups` -- ALTER TABLE `participants_has_groups` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `participant_group` -- ALTER TABLE `participant_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121; -- -- AUTO_INCREMENT for table `pr_approval_status` -- ALTER TABLE `pr_approval_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_category` -- ALTER TABLE `pr_budget_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_group` -- ALTER TABLE `pr_budget_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_group_users` -- ALTER TABLE `pr_budget_group_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_items` -- ALTER TABLE `pr_budget_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_items_history` -- ALTER TABLE `pr_budget_items_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_item_category` -- ALTER TABLE `pr_budget_item_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_pool_keys` -- ALTER TABLE `pr_budget_pool_keys` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_budget_return` -- ALTER TABLE `pr_budget_return` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_financial_years` -- ALTER TABLE `pr_financial_years` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_from_tender` -- ALTER TABLE `pr_from_tender` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_has_reference_supplier` -- ALTER TABLE `pr_has_reference_supplier` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_has_sub_items` -- ALTER TABLE `pr_has_sub_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_payment_record` -- ALTER TABLE `pr_payment_record` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_purchase_approval_history` -- ALTER TABLE `pr_purchase_approval_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_purchase_budget_items` -- ALTER TABLE `pr_purchase_budget_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_settings` -- ALTER TABLE `pr_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_settings_approval_role` -- ALTER TABLE `pr_settings_approval_role` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_settings_approval_workflow` -- ALTER TABLE `pr_settings_approval_workflow` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_settings_price_range` -- ALTER TABLE `pr_settings_price_range` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pr_student_payment` -- ALTER TABLE `pr_student_payment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `purchase_request` -- ALTER TABLE `purchase_request` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `roles_permission` -- ALTER TABLE `roles_permission` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94; -- -- AUTO_INCREMENT for table `site_settings` -- ALTER TABLE `site_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `suppliers` -- ALTER TABLE `suppliers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supplier_alias` -- ALTER TABLE `supplier_alias` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supplier_pic` -- ALTER TABLE `supplier_pic` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_class` -- ALTER TABLE `tb_class` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_class_user` -- ALTER TABLE `tb_class_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_subjects` -- ALTER TABLE `tb_subjects` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_tea_class_sub` -- ALTER TABLE `tb_tea_class_sub` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_timetable` -- ALTER TABLE `tb_timetable` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_timetable_teacher` -- ALTER TABLE `tb_timetable_teacher` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_code_pattern` -- ALTER TABLE `td_code_pattern` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_comparison` -- ALTER TABLE `td_comparison` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_comparison_items` -- ALTER TABLE `td_comparison_items` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_content_list` -- ALTER TABLE `td_content_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_content_parts` -- ALTER TABLE `td_content_parts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_forms` -- ALTER TABLE `td_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_form_questions` -- ALTER TABLE `td_form_questions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_groupcoi_users` -- ALTER TABLE `td_groupcoi_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_group_coi` -- ALTER TABLE `td_group_coi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_group_coi_user_count` -- ALTER TABLE `td_group_coi_user_count` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_log` -- ALTER TABLE `td_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_open_tender` -- ALTER TABLE `td_open_tender` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_suppliers` -- ALTER TABLE `td_suppliers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_templates` -- ALTER TABLE `td_templates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_tenders` -- ALTER TABLE `td_tenders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_tender_coi_history` -- ALTER TABLE `td_tender_coi_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `td_user_coi` -- ALTER TABLE `td_user_coi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `timeslot_sets` -- ALTER TABLE `timeslot_sets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `time_slots` -- ALTER TABLE `time_slots` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `users_cpd` -- ALTER TABLE `users_cpd` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users_group` -- ALTER TABLE `users_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users_roles` -- ALTER TABLE `users_roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `venues` -- ALTER TABLE `venues` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `venue_group` -- ALTER TABLE `venue_group` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_filled_form` -- ALTER TABLE `wf_filled_form` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_form_answers` -- ALTER TABLE `wf_form_answers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_form_status` -- ALTER TABLE `wf_form_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_form_workflow` -- ALTER TABLE `wf_form_workflow` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wf_workflow` -- ALTER TABLE `wf_workflow` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; includes/Core_class.php 0000775 00000002341 15060011660 0011140 0 ustar 00 <?php class Core { // Function to validate the post data function validate_post($data) { /* Validating the hostname, the database name and the username. The password is optional. */ return !empty($data['hostname']) && !empty($data['username']) && !empty($data['database']); } // Function to show an error function show_message($type,$message) { return $message; } // Function to write the config file function write_config($data) { // Config path $template_path = 'config/database.php'; $output_path = '../application/config/database.php'; // Open the file $database_file = file_get_contents($template_path); $new = str_replace("%HOSTNAME%",$data['hostname'],$database_file); $new = str_replace("%USERNAME%",$data['username'],$new); $new = str_replace("%PASSWORD%",$data['password'],$new); $new = str_replace("%DATABASE%",$data['database'],$new); // Write the new database.php file $handle = fopen($output_path,'w+'); // Chmod the file, in case the user forgot @chmod($output_path,0777); // Verify file permissions if(is_writable($output_path)) { // Write the file if(fwrite($handle,$new)) { return true; } else { return false; } } else { return false; } } } includes/Database_class.php 0000775 00000002501 15060011660 0011752 0 ustar 00 <?php class Database { // Function to the database and tables and fill them with the default data function create_database($data) { // Connect to the database $mysqli = new mysqli($data['hostname'],$data['username'],$data['password'],''); // Check for errors if(mysqli_connect_errno()) return false; // Create the prepared statement $mysqli->query("CREATE DATABASE IF NOT EXISTS ".$data['database']); // Close the connection $mysqli->close(); return true; } // Function to create the tables and fill them with the default data function create_tables($data) { // Connect to the database $mysqli = new mysqli($data['hostname'],$data['username'],$data['password'],$data['database']); // Check for errors if(mysqli_connect_errno()) return false; // Open the default SQL file $query = file_get_contents('db/install.sql'); // Execute a multi query if ($mysqli->multi_query($query)) { do { /* store first result set */ if ($result = $mysqli->store_result()) { while ($row = $result->fetch_row()) { //printf("%s\n", $row[0]); } $result->free(); } /* print divider */ if ($mysqli->more_results()) { //printf("-----------------\n"); } } while ($mysqli->next_result()); } // Close the connection $mysqli->close(); return true; } } success.php 0000775 00000004475 15060011660 0006737 0 ustar 00 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Install | Successfully</title> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css"> <style type="text/css"> .error { background: #ffd1d1; border: 1px solid #ff5858; padding: 4px; } </style> </head> <body style="background:#2C3E50"> <div class="container" style="margin-top:50px "> <div class="row"> <div class="col-md-6 col-md-offset-3"> <div class="panel panel-default"> <div class="panel-heading"> <strong class="">Camplus Admin System</strong> </div> <div class="panel-body"> <div class="alert alert-success" role="alert"> Well done! You Successfully Installed Camplus Admin System. </div> <div class="well well-lg"> <h4><strong>Admin panel Login Details</strong></h4> <hr/> <p>Please keep bellow login details to login Camplus Admin System.</p> <p><strong>Login:</strong>admin</p> <p><strong>Password:</strong> admin</p> <?php $redir = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == "on") ? "https" : "http"); $redir .= "://".$_SERVER['HTTP_HOST']; $redir .= str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']); $redir = str_replace('install/','',$redir); ?> <a href="<?php echo $redir .'login' ?>" class="btn btn-success">Goto Login Page</a> </div> <p class="error"> For your own security. Please <strong>Delete</strong> or rename <strong>Install</strong> folder </p> </div> <div class="panel-footer">© Proedge Limited </div> </div> </div> </div> </div> </body> </html> index.php 0000755 00000012525 15060011660 0006367 0 ustar 00 <?php error_reporting(E_ALL); //Setting this to E_ALL showed that that cause of not redirecting were few blank lines added in some php files. $db_config_path = '../application/config/database.php'; // Only load the classes in case the user submitted the form if($_POST) { // Load the classes and create the new objects require_once('includes/Core_class.php'); require_once('includes/Database_class.php'); $core = new Core(); $database = new Database(); // Validate the post data if($core->validate_post($_POST) == true) { // First create the database, then create tables, then write config file if($database->create_database($_POST) == false) { $message = $core->show_message('error',"The database could not be created, please verify your settings."); } else if ($database->create_tables($_POST) == false) { $message = $core->show_message('error',"The database tables could not be created, please verify your settings."); } else if ($core->write_config($_POST) == false) { $message = $core->show_message('error',"The database configuration file could not be written, please chmod application/config/database.php file to 777"); } // If no errors, redirect to registration page if(!isset($message)) { $redir = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == "on") ? "https" : "http"); $redir .= "://".$_SERVER['HTTP_HOST']; $redir .= str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']); $redir = str_replace('install/','',$redir); header( 'Location:'.$redir.'core/create_user') ; } } else { $message = $core->show_message('error','Not all fields have been filled in correctly. The host, username, password, and database name are required.'); } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Install | Camplus Admin System</title> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css"> <style type="text/css"> .error { background: #ffd1d1; border: 1px solid #ff5858; padding: 4px; } </style> </head> <body style="background:#2C3E50"> <div class="container" style="margin-top:50px "> <div class="row"> <div class="col-md-6 col-md-offset-3"> <div class="panel panel-default"> <div class="panel-heading"> <strong class="">Camplus Admin System Installation</strong> </div> <div class="panel-body"> <?php if(is_writable($db_config_path)){?> <?php if(isset($message)) {echo '<p class="error">' . $message . '</p>';}?> <h4>Database Seetings</h4> <hr/> <form class="form-horizontal" id="install_form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <div class="form-group"> <label for="inputEmail3" class="col-sm-4 control-label">Hostname</label> <div class="col-sm-8"> <input class="form-control" type="text" id="hostname" value="localhost" class="input_text" name="hostname"> </div> </div> <div class="form-group"> <label for="inputPassword3" class="col-sm-4 control-label">Database Username</label> <div class="col-sm-8"> <input class="form-control" type="text" id="username" class="input_text" name="username"> </div> </div> <div class="form-group"> <label for="inputPassword3" class="col-sm-4 control-label">Database Password</label> <div class="col-sm-8"> <input class="form-control" type="password" id="password" class="input_text" name="password"> </div> </div> <div class="form-group"> <label for="inputPassword3" class="col-sm-4 control-label">Database Name</label> <div class="col-sm-8"> <input class="form-control" type="text" id="database" class="input_text" name="database"> </div> </div> <div class="form-group last"> <div class="col-sm-offset-4 col-sm-8"> <button type="submit" class="btn btn-success btn-sm" id="submit">Install</button> <button type="reset" class="btn btn-default btn-sm">Reset</button> </div> </div> </form> <?php } else { ?> <p class="error">Please make the application/config/database.php file writable. <strong>Example</strong>:<br /><br /><code>chmod 777 application/config/database.php</code></p> <?php } ?> </div> <div class="panel-footer">© Proedge Limtied </div> </div> </div> </div> </div> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 0.18 |
proxy
|
phpinfo
|
Settings