#
# Table structure for table `gen_citation`
#

CREATE TABLE gen_citation (
  factkey varchar(6) NOT NULL default '0',
  srckey varchar(6) default NULL,
  source text,
  KEY factkey (factkey)
)

#
# Table structure for table `gen_facts`
#

CREATE TABLE gen_facts (
  indfamkey varchar(5) NOT NULL default '',
  type tinytext NOT NULL,
  date tinytext NOT NULL,
  place tinytext NOT NULL,
  factkey varchar(6) NOT NULL default '',
  KEY factype (indfamkey,type(3))
)

#
# Table structure for table `gen_family`
#

CREATE TABLE gen_family (
  famkey varchar(5) NOT NULL default '',
  spouse1 varchar(5) NOT NULL default '',
  spouse2 varchar(5) NOT NULL default '',
  endstatus tinytext NOT NULL,
  notekey varchar(6) NOT NULL default '',
  PRIMARY KEY  (famkey),
  KEY spouse1 (spouse1),
  KEY spouse2 (spouse2)
) 

#
# Table structure for table `gen_images`
#

CREATE TABLE gen_images (
  id int(11) NOT NULL auto_increment,
  indfamkey varchar(5) NOT NULL default '',
  filename tinytext NOT NULL,
  title tinytext,
  caption text,
  pbase_link tinytext,
  sort_order int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY indfamkey (indfamkey)
) 

#
# Table structure for table `gen_indiv`
#

CREATE TABLE gen_indiv (
  indkey varchar(5) NOT NULL default '',
  title tinytext NOT NULL,
  surname tinytext NOT NULL,
  givenname tinytext NOT NULL,
  aka tinytext NOT NULL,
  sex tinytext NOT NULL,
  notekey varchar(6) NOT NULL default '',
  PRIMARY KEY  (indkey),
  KEY sname (surname(5)),
  KEY gname (givenname(5))
) 

#
# Table structure for table `gen_notes`
#

CREATE TABLE gen_notes (
  notekey varchar(6) NOT NULL default '',
  text text NOT NULL,
  PRIMARY KEY  (notekey)
) 

#
# Table structure for table `gen_relation`
#

CREATE TABLE gen_relation (
  indkey varchar(5) NOT NULL default '',
  famkey varchar(5) NOT NULL default '',
  KEY indkey (indkey),
  KEY famkey (famkey)
) 

#
# Table structure for table `gen_source`
#

CREATE TABLE gen_source (
  srckey varchar(6) NOT NULL default '',
  text text NOT NULL,
  notekey varchar(7) default NULL,
  PRIMARY KEY  (srckey)
)