/*
+-----------------------+
| 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