# MySQL dump 6.0
#
# Host: localhost    Database: lucid_calendar
#--------------------------------------------------------
# Server version	3.22.25

#
# Table structure for table 'calendar_administrators'
#
CREATE TABLE calendar_administrators (
  admin_id int(11) DEFAULT '0' NOT NULL auto_increment,
  admin_name tinytext NOT NULL,
  admin_email tinytext NOT NULL,
  admin_phone tinytext,
  admin_fax tinytext,
  admin_address tinytext,
  admin_city tinytext,
  admin_state char(2),
  admin_zip varchar(10),
  PRIMARY KEY (admin_id)
);

#
# Table structure for table 'calendar_messages'
#
CREATE TABLE calendar_messages (
  msg_id int(11) DEFAULT '0' NOT NULL auto_increment,
  msg_month int(2) DEFAULT '0' NOT NULL,
  msg_day int(2) DEFAULT '0' NOT NULL,
  msg_year int(4) DEFAULT '0' NOT NULL,
  msg_title tinytext NOT NULL,
  msg_text text NOT NULL,
  msg_poster_id int(11) DEFAULT '0' NOT NULL,
  msg_recurring tinytext,
  msg_active int(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (msg_id)
);

#
# Table structure for table 'calendar_posts'
#
CREATE TABLE calendar_posts (
  post_id int(11) DEFAULT '0' NOT NULL auto_increment,
  poster_id int(11) DEFAULT '0' NOT NULL,
  date_posted date DEFAULT '0000-00-00' NOT NULL,
  PRIMARY KEY (post_id)
);