/*
+-----------------------+
| Tables_in_softoccitan |
+-----------------------+
| defanglais            |
| defcatalan            |
| deffrancais           |
| defoccitan            |
| motanglais            |
| motcatalan            |
| motfrancais           |
| motoccitan            |
| r_infocontextuelle    |
| r_traduction          |
| reftypegrammatical    |
+-----------------------+
*/
CREATE TABLE `defanglais` (
  `idMotAnglais` int(11) NOT NULL,
  `definition` varchar(256) default '',
  PRIMARY KEY  (`idMotAnglais`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `defcatalan` (
  `idMotCatalan` int(11) NOT NULL,
  `definition` varchar(256) default '',
  PRIMARY KEY  (`idMotCatalan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `deffrancais` (
  `idMotFrancais` int(11) NOT NULL,
  `definition` varchar(256) default '',
  PRIMARY KEY  (`idMotFrancais`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `defoccitan` (
  `idMotOccitan` int(11) NOT NULL,
  `definition` varchar(256) default '',
  PRIMARY KEY  (`idMotOccitan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `motanglais` (
  `idMotAnglais` int(11) NOT NULL auto_increment,
  `mot` varchar(64) default NULL,
  `genre` char(1) default 'M',
  `nombre` char(1) default 'S',
  `idTypeGram` tinyint(4) default '0',
  `etat` tinyint(4) default '0',
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idMotAnglais`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `motcatalan` (
  `idMotCatalan` int(11) NOT NULL auto_increment,
  `mot` varchar(64) default NULL,
  `genre` char(1) default 'M',
  `nombre` char(1) default 'S',
  `idTypeGram` tinyint(4) default '0',
  `etat` tinyint(4) default '0',
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

  PRIMARY KEY  (`idMotCatalan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `motfrancais` (
  `idMotFrancais` int(11) NOT NULL auto_increment,
  `mot` varchar(64) default NULL,
  `genre` char(1) default 'M',
  `nombre` char(1) default 'S',
  `idTypeGram` tinyint(4) default '0',
  `etat` tinyint(4) default '0',
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

  PRIMARY KEY  (`idMotFrancais`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `motoccitan` (
  `idMotOccitan` int(11) NOT NULL auto_increment,
  `mot` varchar(64) default NULL,
  `genre` char(1) default 'M',
  `nombre` char(1) default 'S',
  `idTypeGram` tinyint(4) default '0',
  `etat` tinyint(4) default '0',
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idMotOccitan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `r_infocontextuelle` (
  `idMot` int(11) default NULL,
  `lang` char(5) default NULL,
  `infocontextuelle` varchar(256) default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `r_traduction` (
  `idMot1` int(11) default NULL,
  `lang1` char(5) default NULL,
  `idMot2` int(11) default NULL,
  `lang2` char(5) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g

CREATE TABLE `reftypegrammatical` (
  `idTypeGram` int(11) NOT NULL auto_increment,
  `libelle` varchar(64) default NULL,
  PRIMARY KEY  (`idTypeGram`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1\g