

INSERT INTO db (
      host, db, user,
         Select_priv, Insert_priv, Update_priv, Delete_priv,
         Create_priv, Drop_priv )
      VALUES (
      'localhost',
      'schoolboard',
      'schoolboard',
      'Y', 'Y', 'Y', 'Y',
      'Y', 'Y'
        );
        
FLUSH PRIVILEGES;

CREATE DATABASE schoolboard;


#
# Table structure for table 'demo_board'
#


CREATE TABLE school_board (
  userid varchar(25) binary DEFAULT '' NOT NULL,
  msg_id mediumint(10) DEFAULT '0' NOT NULL,
  msg_subject varchar(200) DEFAULT '' NOT NULL,
  msg_body text NOT NULL,
  msg_hit mediumint(10) DEFAULT '0' NOT NULL,
  msg_date datetime,
  attach varchar(30) DEFAULT '' NOT NULL,
  msg_date_expire datetime,
  PRIMARY KEY (msg_id),
  KEY userid (userid)
);
