File manager - Edit - /home/wwwroot/camplus.hk/ocaademo.camplus.hk/public_html_20170929/mahana.sql
Back
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; CREATE TABLE `msg_messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `thread_id` int(11) NOT NULL, `body` text NOT NULL, `priority` int(2) NOT NULL DEFAULT '0', `sender_id` int(11) NOT NULL, `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `msg_participants` ( `user_id` int(11) NOT NULL, `thread_id` int(11) NOT NULL, `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`user_id`,`thread_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `msg_status` ( `message_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `status` int(2) NOT NULL, PRIMARY KEY (`message_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `msg_threads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `subject` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 1.49 |
proxy
|
phpinfo
|
Settings