CREATE TABLE demo_board (
   userid varchar(25) binary NOT NULL,
   msg_id mediumint(10) NOT NULL,
   thread_id mediumint(10) NOT NULL,
   thread_depth mediumint(10) NOT NULL,
   thread_info varchar(200) NOT NULL,
   msg_subject varchar(200) NOT NULL,
   msg_body text NOT NULL,
   msg_hit mediumint(10) NOT NULL,
   msg_date datetime,
   PRIMARY KEY (msg_id),
   KEY userid (userid),
   KEY thread_id (thread_id),
   KEY thread_info (thread_info)
);

insert into master_table values ('demo_board',
  'PHP Discussion Demo Board','demo_users',