


DROP TABLE IF EXISTS `esque_princeps`;
CREATE TABLE `esque_princeps` (
  `numero_ligne` smallint(6) NOT NULL default '0',
  `derive` varchar(100) character set latin1 collate latin1_bin NOT NULL default '',
  `cat_derive` varchar(10) character set latin1 collate latin1_bin default NULL,
  `sens_derive` varchar(100) character set latin1 collate latin1_bin default NULL,
  `variantes_derive` varchar(255) character set latin1 collate latin1_bin default NULL,
  `base` varchar(100) character set latin1 collate latin1_bin default NULL,
  `cat_base` varchar(10) character set latin1 collate latin1_bin default NULL,
  `sens_base` varchar(100) character set latin1 collate latin1_bin default NULL,
  `commentaire_base` blob,
  `mode_formation` varchar(100) character set latin1 collate latin1_bin default NULL,
  `reference_dans_dictionnaire` varchar(50) character set latin1 collate latin1_bin default NULL,
  `reference` varchar(255) character set latin1 collate latin1_bin default NULL,
  `contexte` blob,
  `auteur` varchar(100) character set latin1 collate latin1_bin default NULL,
  `reference_complement` varchar(255) character set latin1 collate latin1_bin default NULL,
  `jour` tinyint(4) default '0',
  `mois` tinyint(4) default '0',
  `annee` smallint(6) default '0',
  `annee_complement` varchar(100) character set latin1 collate latin1_bin default NULL,
  `origine` varchar(100) character set latin1 collate latin1_bin default NULL,
  PRIMARY KEY  (`numero_ligne`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


