Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

32 lines (27 sloc) 0.929 kb
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;
Jump to Line
Something went wrong with that request. Please try again.