# sql for testing

CREATE TABLE user (
  user_id int(11) unsigned NOT NULL auto_increment,
  user_name varchar(255) default NULL,
  first_name varchar(255) default NULL,
  last_name varchar(255) default NULL,
  password varchar(255) default NULL,
  date_of_birth varchar(255) default NULL,
  occupation varchar(255) default NULL,
  is_active tinyint(4) NOT NULL default '0',
  last_visited_on datetime default NULL,
  created_on datetime default NULL,
  modified_on timestamp(14) NOT NULL,
  email varchar(75) default NULL,
  city varchar(75) default NULL,
  state varchar(75) default NULL,
  country varchar(255) default NULL,
  postal_code varchar(75) default NULL,
  phone_number varchar(75) default NULL,
  organization varchar(255) default NULL,
  address varchar(200) default NULL,
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;

CREATE TABLE page (
  page_id int(11) unsigned NOT NULL auto_increment,
  name varchar(255) default NULL,
  created_on datetime NOT NULL default '0000-00-00 00:00:00',
  modified_on timestamp(14) NOT NULL,
  filename varchar(255) NOT NULL default '',
  PRIMARY KEY  (page_id)
) TYPE=MyISAM;