--
-- Table structure for table `pub_pd`
--

DROP TABLE IF EXISTS `pub_pd`;
CREATE TABLE `pub_pd` (
  -- internal page id
  `pd_id` int(8) NOT NULL default '0',
  -- original data of personendaten template
  `pd_article` varchar(255) NOT NULL default '',
  `pd_name` varchar(255) NOT NULL default '',
  `pd_alternative` varchar(255) NOT NULL default '',
  `pd_description` varchar(255) NOT NULL default '',
  `pd_born` varchar(255) NOT NULL default '',
  `pd_born_in` varchar(255) NOT NULL default '',
  `pd_died` varchar(255) NOT NULL default '',
  `pd_died_in` varchar(255) NOT NULL default '',
  -- original data of pnd template (first 9 characters)
  `pd_pnd` varchar(9) NOT NULL default '',
  -- checked pnd number 
  `pnd_nr` varchar(9) NOT NULL default '',
  `pnd_date` date default NULL,
  -- disambiguation of given and surname 
  `n_given` varchar(255) NOT NULL default '',
  `n_surname` varchar(255) NOT NULL default '',
  -- place of birth wikipedia article if specified
  `b_place` varchar(255) NOT NULL default '',
  -- place of death wikipedia article if specified
  `d_place` varchar(255) NOT NULL default '',
  -- day, month, year, decade, century of birth if known
  `b_day` tinyint(4) default NULL,
  `b_month` tinyint(4) default NULL,
  `b_year` smallint(6) default NULL,
  `b_decade` smallint(6) NOT NULL default '0',
  `b_century` tinyint(4) default NULL,
  -- two years if date of birth is known to be in a time span
  `b_year1` smallint(6) default NULL,
  `b_year2` smallint(6) default NULL,
  -- note (indication of uncertainty etc.)
  `b_note` varchar(255) NOT NULL default '',
  -- day, month, year, decade, century of dead if known
  `d_day` tinyint(4) default NULL,
  `d_month` tinyint(4) default NULL,
  `d_year` smallint(6) default NULL,
  `d_decade` smallint(6) NOT NULL default '0',
  `d_century` tinyint(4) default NULL,
  -- two years if date of dead is known to be in a time span
  `d_year1` smallint(6) default NULL,
  `d_year2` smallint(6) default NULL,
  -- note (indication of uncertainty etc.)
  `d_note` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`pd_id`),
);

-- Bulk insert like this:
-- LOAD DATA LOCAL INFILE '$full.tab' INTO TABLE pub_pd;