* This is a batch dump file for MySQL. In the event of a complete database wipeout 
 * all the information contained herein can be automatically reinserted into the 
 * database with one command. 
 *
 * Simply copy this file into a directory on the server. From the shell command line type: 
 *
 * mysql -h host -u user -p dbname < thisfile.txt 
 *
 *  
 * You will then be prompted for your password, and then the entire contents of this 
 * file will be executed. 
 * This backup was generated on: Tuesday September 7 2010, 21:09:01
 * Note: This backup format has not been tested; however, it should be easy to manually 
 * modify this file to correct mistakes. 
 * The Address Book 1.04 
 *


DROP TABLE IF EXISTS additionaldata;
DROP TABLE IF EXISTS address;
DROP TABLE IF EXISTS contact;
DROP TABLE IF EXISTS email;
DROP TABLE IF EXISTS grouplist;
DROP TABLE IF EXISTS groups;
DROP TABLE IF EXISTS messaging;
DROP TABLE IF EXISTS options;
DROP TABLE IF EXISTS otherphone;
DROP TABLE IF EXISTS websites;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS scratchpad;
CREATE TABLE additionaldata (id INT(11) NOT NULL DEFAULT '0', type VARCHAR(20) DEFAULT NULL, value TEXT) TYPE=MyISAM;
CREATE TABLE address (refid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, id INT(11) NOT NULL DEFAULT '0', type VARCHAR(20) NOT NULL DEFAULT '', line1 VARCHAR(100) DEFAULT NULL, line2 VARCHAR(100) DEFAULT NULL, city VARCHAR(50) DEFAULT NULL, state VARCHAR(10) DEFAULT NULL, zip VARCHAR(20) DEFAULT NULL, country VARCHAR(3) DEFAULT NULL, phone1 VARCHAR(20) DEFAULT NULL, phone2 VARCHAR(20) DEFAULT NULL ) TYPE=MyISAM;
CREATE TABLE contact (id INT(11) NOT NULL AUTO_INCREMENT, firstname VARCHAR(40) NOT NULL DEFAULT '', lastname VARCHAR(80) NOT NULL DEFAULT '', middlename VARCHAR(40) DEFAULT NULL, primaryAddress INT(11) DEFAULT NULL, birthday DATE DEFAULT NULL, nickname VARCHAR(40) DEFAULT NULL, pictureURL VARCHAR(255) DEFAULT NULL, notes TEXT, lastUpdate DATETIME DEFAULT NULL, hidden INT(1) DEFAULT '0' NOT NULL, whoAdded VARCHAR(15), PRIMARY KEY (id)) TYPE=MyISAM;
CREATE TABLE email (id INT(11) NOT NULL DEFAULT '0', email VARCHAR(100) DEFAULT NULL, type VARCHAR(20) DEFAULT NULL) TYPE=MyISAM;
CREATE TABLE grouplist (groupid INT(11) NOT NULL DEFAULT '0', groupname VARCHAR(60) DEFAULT NULL, PRIMARY KEY (groupid)) TYPE=MyISAM;
CREATE TABLE groups (id INT(11) NOT NULL DEFAULT '0', groupid TINYINT(4) NOT NULL DEFAULT '0') TYPE=MyISAM;
CREATE TABLE messaging (id INT(11) NOT NULL DEFAULT '0', handle VARCHAR(30) DEFAULT NULL, type VARCHAR(20) DEFAULT NULL) TYPE=MyISAM;
CREATE TABLE options (bdayInterval INT(3) DEFAULT '21' NOT NULL, bdayDisplay INT(1) DEFAULT '1' NOT NULL, displayAsPopup INT(1) DEFAULT '0' NOT NULL, useMailScript INT(1) DEFAULT '1' NOT NULL, picAlwaysDisplay INT(1) DEFAULT '0' NOT NULL, picWidth INT(1) DEFAULT '140' NOT NULL, picHeight INT(1) DEFAULT '140' NOT NULL, picDupeMode INT(1) DEFAULT '1' NOT NULL, picAllowUpload INT(1) DEFAULT '1' NOT NULL, modifyTime VARCHAR(3) DEFAULT '0' NOT NULL, msgLogin TEXT NULL, msgWelcome VARCHAR(255) NULL, countryDefault CHAR(3) DEFAULT '0' NULL, allowUserReg INT(1) DEFAULT '0' NOT NULL, eMailAdmin int(1) NOT NULL default '0', requireLogin INT(1) DEFAULT '1' NOT NULL, language VARCHAR(25) NOT NULL, defaultLetter char(2) default NULL, limitEntries smallint(3) NOT NULL default '0') TYPE=MyISAM;
CREATE TABLE otherphone (id INT(11) NOT NULL DEFAULT '0', phone VARCHAR(20) DEFAULT NULL, type VARCHAR(20) DEFAULT NULL) TYPE=MyISAM;
CREATE TABLE websites (id INT(11) NOT NULL DEFAULT '0', webpageURL VARCHAR(255) DEFAULT NULL, webpageName VARCHAR(255) DEFAULT NULL) TYPE=MyISAM;
CREATE TABLE users (id INT(2) NOT NULL AUTO_INCREMENT, username VARCHAR(15) NOT NULL, usertype ENUM('admin','user','guest') NOT NULL DEFAULT 'user', password VARCHAR(32) NOT NULL DEFAULT '', email VARCHAR(50) NOT NULL, confirm_hash VARCHAR(50) NOT NULL, is_confirmed TINYINT(1) DEFAULT '0' NOT NULL, bdayInterval int(3) default NULL, bdayDisplay int(1) default NULL, displayAsPopup int(1) default NULL, useMailScript int(1) default NULL, language varchar(25) default NULL, defaultLetter char(2) default NULL, limitEntries smallint(3) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY username (username)) TYPE=MyISAM;
CREATE TABLE scratchpad (notes TEXT NOT NULL) TYPE=MyISAM;
INSERT INTO address VALUES(1,1,"","","","Syosset","NY",11791,0,"","");
INSERT INTO contact VALUES(1,"Jeff","Kuhn","Edward",1,"1975-05-16","","","","2005-10-19 21:23:51",0,"guest");
INSERT INTO email VALUES(1,"jeff@wilburstreet.com","");
INSERT INTO grouplist VALUES(0,"(all entries)");
INSERT INTO grouplist VALUES(1,"(ungrouped entries)");
INSERT INTO grouplist VALUES(2,"(hidden entries)");
INSERT INTO options VALUES(31,1,0,0,1,140,140,1,1,0,"<P>Please log in to access the Address Book.<br>
<b>The user
name and password to login are both \\\"user\\\" without 
the quotes.</b>","<B>welcome to the Wilburstreet.com Address Book!</B>","",0,0,0,"english","",0);
INSERT INTO websites VALUES(1,"http://www.wilburstreet.com","");
INSERT INTO users VALUES(1,"admin","admin","f7b97c1d329d24f67a123007befa65ae","jeff@wilburstreet.com","41c132ecd63aa1647055ee944d0b1b14",1,"","","","","","","");
INSERT INTO users VALUES(3,"user","user","ee11cbb19052e40b07aac0ca060c23ee","","",1,"","","","","","","");
INSERT INTO scratchpad VALUES("");