CREATE TABLE demo_board_m (
	userid varchar(25) binary NOT NULL,
   msg_id mediumint(10) NOT NULL,
   msg_subject varchar(200) NOT NULL,
   msg_body text NOT NULL,
   msg_date datetime,
   PRIMARY KEY (msg_id),
   KEY userid (userid)
);

CREATE TABLE demo_board_t (
   msg_id mediumint(10) NOT NULL,
   table_id mediumint(10) NOT NULL,
   thread_id mediumint(10) NOT NULL,
   thread_depth mediumint(10) NOT NULL,
   thread_info varchar(200) NOT NULL,
   msg_hit mediumint(10) NOT NULL,
   PRIMARY KEY (msg_id),
   KEY table_id (table_id),
   KEY thread_id (thread_id),
   KEY thread_info (thread_info)
);