


DROP TABLE IF EXISTS `occurrences`;
CREATE TABLE `occurrences` (
  `numero_vers` int(11) NOT NULL default '1',
  `personnage` varchar(100) character set latin1 collate latin1_bin NOT NULL default '',
  `numero_tirade` int(11) NOT NULL default '0',
  `numero_phrase` int(11) NOT NULL default '0',
  `occ_car` varchar(100) character set latin1 collate latin1_bin NOT NULL default '',
  `occ_phon` varchar(100) character set latin1 collate latin1_bin NOT NULL default '',
  `cat` varchar(100) character set latin1 collate latin1_bin default NULL,
  `type_liaison` char(2) NOT NULL default 'ss',
  `liaison` varchar(5) character set latin1 collate latin1_bin default NULL,
  `debut_car` int(11) NOT NULL default '0',
  `fin_car` int(11) NOT NULL default '0',
  `debut_phon` int(11) NOT NULL default '0',
  `fin_phon` int(11) NOT NULL default '0',
  `debut_syl` decimal(4,1) NOT NULL default '0.0',
  `fin_syl` decimal(4,1) NOT NULL default '0.0',
  `syllabe_accentuee` int(11) NOT NULL default '0',
  `numero_ligne` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`numero_ligne`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `positions`;
CREATE TABLE `positions` (
  `numero_vers` int(11) NOT NULL default '1',
  `position` int(11) NOT NULL default '1',
  `syll` varchar(15) character set latin1 collate latin1_bin NOT NULL default '',
  `voy` varchar(5) character set latin1 collate latin1_bin NOT NULL default '',
  `cat` varchar(30) character set latin1 collate latin1_bin NOT NULL default '',
  `accent` int(11) NOT NULL default '0',
  `fin_mot` int(11) NOT NULL default '0',
  `numero_ligne` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`numero_ligne`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `vers`;
CREATE TABLE `vers` (
  `acte` varchar(5) character set latin1 collate latin1_bin NOT NULL default '',
  `scene` varchar(5) character set latin1 collate latin1_bin NOT NULL default '',
  `numero_vers` int(11) NOT NULL default '1',
  `personnage_s` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `partage_en` int(11) NOT NULL default '1',
  `vers` varchar(200) character set latin1 collate latin1_bin NOT NULL default '',
  `vers_phonetique` varchar(250) character set latin1 collate latin1_bin NOT NULL default '',
  PRIMARY KEY  (`numero_vers`),
  UNIQUE KEY `vers_ndx` (`vers`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


