#
# Table structure for table 'contact'
#

CREATE TABLE contact (
  cod int(10) unsigned NOT NULL auto_increment,
  name varchar(30) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  sex varchar(6) NOT NULL default 'male',
  type int(10) unsigned NOT NULL default '0',
  obs text NOT NULL,
  active enum('Y','N') NOT NULL default 'N',
  os enum('linux','windows','unix') NOT NULL default 'linux',
  birthday date NOT NULL default '0000-00-00',
  value TINYINT UNSIGNED,
  PRIMARY KEY  (cod),
  UNIQUE KEY email (email)
) TYPE=MyISAM;


#
# Dumping data for table 'contact'
#
INSERT INTO contact VALUES("1","Paulo ASSIS","paulo@coral.srv.br","male","7","Creator of the wonderfull phpDBform script.","N","windows","1973-01-25",10);
INSERT INTO contact VALUES("2","Eric KASTLER","free.sites@surlewoueb.com","male","2","French froggy. Has translated phpDBform in French and made the french mirror site at http://phpdbform.surlewoueb.com","N","linux","0000-00-00",10);
INSERT INTO contact VALUES("3","Marcin Chojnowski","martii@obgyn.edu.pl","male","2","Has translated phpDBform in Polish and added support for charset","N","linux","0000-00-00",10);
INSERT INTO contact VALUES("4","Roberto Rosario","skeletor@iname.com","male","2","Implemented a couple of cool features for phpdbform. Support for combo boxes with fixed list and listing 2 or more fields in the select form.","N","linux","0000-00-00",10);
INSERT INTO contact VALUES("5","Tom Vander Aa","Tom.VanderAa@esat.kuleuven.ac.be","male","2","Added support for PostgreSQL database in phpdbform. Now phpdbform works with two databases!","N","linux","0000-00-00",10);
INSERT INTO contact VALUES("6","Other person","nobody@nowhere.com.xx","male","4","I don\'t know... This is a test. Perhaps it can be you in the next release ;-)","Y","linux","0000-00-00",10);

#
# Table structure for table 'type'
#

CREATE TABLE type (
  cod int(11) NOT NULL auto_increment,
  type varchar(20) NOT NULL default '',
  business tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (cod)
) TYPE=MyISAM;

#
# Dumping data for table 'type'
#
INSERT INTO type VALUES("1","Personal","0");
INSERT INTO type VALUES("2","Business","1");
INSERT INTO type VALUES("3","School","0");
INSERT INTO type VALUES("4","Eventos","0");
INSERT INTO type VALUES("5","Home","0");
INSERT INTO type VALUES("6","Casa","0");
INSERT INTO type VALUES("7","Escola","1");