syscrusher/genealogy/obit_original.mysql

DROP TABLE IF EXISTS obit_original;

CREATE TABLE obit_original (
  record_number int(11) NOT NULL auto_increment,
  last_name varchar(35) NOT NULL default '',
  first_name varchar(20) NOT NULL default '',
  middle_name varchar(20) default NULL,
  maiden_name varchar(25) default NULL,
  title varchar(10) default NULL,
  birthplace varchar(50) default NULL,
  age int(11) default NULL,
  birth_date date default NULL,
  death_date date default NULL,
  father varchar(35) default NULL,
  mother varchar(35) default NULL,
  other_parent_1 varchar(35) default NULL,
  other_parent_2 varchar(35) default NULL,
  mother_maiden varchar(20) default NULL,
  spouse_1 varchar(35) default NULL,
  spouse_2 varchar(35) default NULL,
  spouse_3 varchar(35) default NULL,
  spouse_4 varchar(35) default NULL,
  spouse_5 varchar(35) default NULL,
  burial_site varchar(50) default NULL,
  obit_date date NOT NULL default '0000-00-00',
  obit_source varchar(50) default NULL,
  other_sources varchar(100) default NULL,
  notes varchar(100) default NULL,
  age_notes varchar(50) default NULL,
  PRIMARY KEY (record_number),
  UNIQUE KEY last_name(last_name,first_name,record_number),
  UNIQUE KEY obit_date(obit_date,record_number)
) TYPE=MyISAM;
1	DROP TABLE IF EXISTS obit_original;
2
3	CREATE TABLE obit_original (
4	record_number int(11) NOT NULL auto_increment,
5	last_name varchar(35) NOT NULL default '',
6	first_name varchar(20) NOT NULL default '',
7	middle_name varchar(20) default NULL,
8	maiden_name varchar(25) default NULL,
9	title varchar(10) default NULL,
10	birthplace varchar(50) default NULL,
11	age int(11) default NULL,
12	birth_date date default NULL,
13	death_date date default NULL,
14	father varchar(35) default NULL,
15	mother varchar(35) default NULL,
16	other_parent_1 varchar(35) default NULL,
17	other_parent_2 varchar(35) default NULL,
18	mother_maiden varchar(20) default NULL,
19	spouse_1 varchar(35) default NULL,
20	spouse_2 varchar(35) default NULL,
21	spouse_3 varchar(35) default NULL,
22	spouse_4 varchar(35) default NULL,
23	spouse_5 varchar(35) default NULL,
24	burial_site varchar(50) default NULL,
25	obit_date date NOT NULL default '0000-00-00',
26	obit_source varchar(50) default NULL,
27	other_sources varchar(100) default NULL,
28	notes varchar(100) default NULL,
29	age_notes varchar(50) default NULL,
30	PRIMARY KEY (record_number),
31	UNIQUE KEY last_name(last_name,first_name,record_number),
32	UNIQUE KEY obit_date(obit_date,record_number)
33	) TYPE=MyISAM;