-- Script généré par WINDEV le 08/01/2022 12:52:50
-- Tables de l'analyse SCODELUX.wda
-- pour MySQL

-- Création de la table ABSENCE
CREATE TABLE `ABSENCE` (
    `IDABSENCE` BIGINT  NOT NULL  DEFAULT 0,
    `MATRICULE` BIGINT DEFAULT 0,
    `DATEOP` DATE ,
    `CODEMAT` SMALLINT DEFAULT 0,
    `SEMESTRE` TINYINT DEFAULT 0,
    `MOTIF` VARCHAR(100) ,
    `ABSENT` TINYINT DEFAULT 0,
    `RETARD` TINYINT DEFAULT 0,
    `HEURES` TIME ,
    `MOTIFVALALBLE` TINYINT DEFAULT 0,
    `guid` VARCHAR(50)  UNIQUE ,
    `guid_matri` VARCHAR(50) ,
    `SiTE` VARCHAR(15) ,
    `guid_mat` VARCHAR(50) ,
    `anneeacademique` VARCHAR(9) ,
    `PERIODE` VARCHAR(10) );
CREATE INDEX `WDIDX_ABSENCE_IDABSENCE` ON `ABSENCE` (`IDABSENCE`);
CREATE INDEX `WDIDX_ABSENCE_MATRICULE` ON `ABSENCE` (`MATRICULE`);
CREATE INDEX `WDIDX_ABSENCE_DATEOP` ON `ABSENCE` (`DATEOP`);
CREATE INDEX `WDIDX_ABSENCE_CODEMAT` ON `ABSENCE` (`CODEMAT`);

-- Création de la table AGENT
CREATE TABLE `AGENT` (
    `MATRICULE` BIGINT DEFAULT 0,
    `NOM` VARCHAR(30) ,
    `PRENOM` VARCHAR(30) ,
    `DATENAIS` DATE ,
    `LIEUNAIS` VARCHAR(30) ,
    `NATION` VARCHAR(30) ,
    `SEXE` INTEGER ,
    `SITMAT` INTEGER ,
    `PROVENANCE` VARCHAR(50) ,
    `CODEDEPT` VARCHAR(3) ,
    `POSITMILIT` VARCHAR(20) ,
    `NBENF` SMALLINT ,
    `DIPLOMEAC` VARCHAR(50) ,
    `DIPLOMEPRO` VARCHAR(50) ,
    `DATEDEP` DATE ,
    `DATEENT` DATE ,
    `DATEENTADM` DATE ,
    `DATEFONC` DATE ,
    `DATENOM` DATE ,
    `REFNOM` VARCHAR(50) ,
    `DATETITU` DATE ,
    `REFTITU` VARCHAR(50) ,
    `GRADE` VARCHAR(20) ,
    `INDICER` VARCHAR(10) ,
    `INDICEP` VARCHAR(10) ,
    `NOTE` VARCHAR(20) ,
    `POSTE` VARCHAR(30) ,
    `FONCTIONP` VARCHAR(50) ,
    `ADRPERS` VARCHAR(50) ,
    `ADRVAC` VARCHAR(40) ,
    `CONJOINT` VARCHAR(40) ,
    `LIEUCONJOINT` VARCHAR(40) ,
    `PREVENIR` VARCHAR(40) ,
    `ADRPREV` VARCHAR(40) ,
    `DATEDEBINT` DATE ,
    `DATEFININT` DATE ,
    `RAISONINT` VARCHAR(50) ,
    `DATERET` DATE ,
    `TYPEAGENT` VARCHAR(30) ,
    `SIGNEP` VARCHAR(4) ,
    `CODECLAS` VARCHAR(10) ,
    `FONCTIONS` VARCHAR(50) ,
    `CYCLES` TINYINT DEFAULT 0,
    `SELECT` TINYINT ,
    `TAUXHORAIRE` REAL DEFAULT 0.000000,
    `SALBASE` DOUBLE DEFAULT 0.000000,
    `PHOTO` LONGBLOB ,
    `NBHEURE` SMALLINT DEFAULT 0,
    `TAUXHS` REAL DEFAULT 0,
    `PriseEnchargeEtat` TINYINT DEFAULT 0,
    `CHAPITRE` VARCHAR(4) ,
    `TAUXHORAIRE2` REAL DEFAULT 0.000000,
    `NUMCNSS` VARCHAR(50) ,
    `Numeroprofil` INTEGER ,
    `LibelTypeAgent` VARCHAR(30) ,
    `NbHeuredu` INTEGER DEFAULT 0,
    `Enseignant` TINYINT DEFAULT 1,
    `CBanque` VARCHAR(50) ,
    `NCompteBanque` VARCHAR(50) ,
    `IFU` VARCHAR(13) ,
    `CompteAvance` VARCHAR(10) ,
    `ChapitreAvance` VARCHAR(4) ,
    `TelAgent` VARCHAR(15) ,
    `guid` VARCHAR(50)  UNIQUE ,
    `anneeacademique` VARCHAR(9) ,
    `SiTE` VARCHAR(15) );
CREATE INDEX `WDIDX_AGENT_MATRICULE` ON `AGENT` (`MATRICULE`);
CREATE INDEX `WDIDX_AGENT_NOM` ON `AGENT` (`NOM`);
CREATE INDEX `WDIDX_AGENT_SIGNEP` ON `AGENT` (`SIGNEP`);
CREATE INDEX `WDIDX_AGENT_CODECLAS` ON `AGENT` (`CODECLAS`);
CREATE INDEX `WDIDX_AGENT_Numeroprofil` ON `AGENT` (`Numeroprofil`);
CREATE INDEX `WDIDX_AGENT_LibelTypeAgent` ON `AGENT` (`LibelTypeAgent`);

-- Création de la table ajour
CREATE TABLE `ajour` (
    `IDajour` BIGINT  PRIMARY KEY ,
    `ajour` TINYINT DEFAULT 0,
    `ajour_sms` TINYINT DEFAULT 0,
    `LOGIN` VARCHAR(50) ,
    `Site_code` VARCHAR(50) ,
    `notif_android` TINYINT DEFAULT 0,
    `notif_sms` TINYINT DEFAULT 0,
    `notif_email` TINYINT DEFAULT 0);
CREATE INDEX `WDIDX_ajour_LOGIN` ON `ajour` (`LOGIN`);
CREATE INDEX `WDIDX_ajour_Site_code` ON `ajour` (`Site_code`);

-- Création de la table ANOMALIE
CREATE TABLE `ANOMALIE` (
    `NOCLEUNIK` INTEGER  PRIMARY KEY ,
    `INT1` REAL ,
    `INT2` REAL ,
    `INT3` REAL ,
    `INT4` REAL ,
    `MI` REAL ,
    `DEV1` REAL ,
    `DEV2` REAL ,
    `DEV3` REAL ,
    `MS` REAL ,
    `COEF` REAL ,
    `SEMESTRE` TINYINT DEFAULT 0,
    `MATRICULE` BIGINT ,
    `CODECLAS` VARCHAR(10) ,
    `CODEMAT` SMALLINT ,
    `CODEUSER` VARCHAR(15) ,
    `RANG` SMALLINT ,
    `FILLER_T` VARCHAR(20) ,
    `FILLER_E` BIGINT ,
    `TEST` REAL DEFAULT 0.000000,
    `MS1` REAL DEFAULT 0.000000);
CREATE INDEX `WDIDX_ANOMALIE_MATRICULE` ON `ANOMALIE` (`MATRICULE`);
CREATE INDEX `WDIDX_ANOMALIE_CODECLAS` ON `ANOMALIE` (`CODECLAS`);
CREATE INDEX `WDIDX_ANOMALIE_CODEMAT` ON `ANOMALIE` (`CODEMAT`);
CREATE INDEX `WDIDX_ANOMALIE_SEMMATMATR` ON `ANOMALIE` (`SEMESTRE`,`CODEMAT`,`MATRICULE`);
CREATE INDEX `WDIDX_ANOMALIE_SEMMATR` ON `ANOMALIE` (`SEMESTRE`,`MATRICULE`);

-- Création de la table ARRIERES
CREATE TABLE `ARRIERES` (
    `NUMERO` INTEGER ,
    `MATRICULE` BIGINT ,
    `DATEOP` DATE ,
    `MONTANT` INTEGER ,
    `EDITE` TINYINT ,
    `NUMRECU` INTEGER ,
    `SIGNATURE` VARCHAR(20) ,
    `MODEPAIE` SMALLINT DEFAULT 0,
    `VALIDE` TINYINT DEFAULT 0,
    `ANSCOL` VARCHAR(9) ,
    `VERROUILLE` TINYINT DEFAULT 0,
    `TYPEENSEIG` INTEGER DEFAULT 0,
    `guid` VARCHAR(50)  UNIQUE ,
    `guid_matri` VARCHAR(50) ,
    `SiTE` VARCHAR(15) ,
    `idarriere` BIGINT DEFAULT 0,
    `anneeacademique` VARCHAR(9) );
CREATE INDEX `WDIDX_ARRIERES_NUMERO` ON `ARRIERES` (`NUMERO`);
CREATE INDEX `WDIDX_ARRIERES_MATRICULE` ON `ARRIERES` (`MATRICULE`);
CREATE INDEX `WDIDX_ARRIERES_DATEOP` ON `ARRIERES` (`DATEOP`);
CREATE INDEX `WDIDX_ARRIERES_NUMRECU` ON `ARRIERES` (`NUMRECU`);
CREATE INDEX `WDIDX_ARRIERES_guid_matri` ON `ARRIERES` (`guid_matri`);
CREATE INDEX `WDIDX_ARRIERES_idarriere` ON `ARRIERES` (`idarriere`);

-- Création de la table autref
CREATE TABLE `autref` (
    `IDAUTREF` INTEGER DEFAULT 0,
    `LibelleFrais` VARCHAR(30) ,
    `NCOMPTE` VARCHAR(10) ,
    `reccurent` TINYINT ,
    `CodeSITE` VARCHAR(15) ,
    `CHAPITRE` VARCHAR(4) );
CREATE INDEX `WDIDX_autref_IDAUTREF` ON `autref` (`IDAUTREF`);
CREATE INDEX `WDIDX_autref_LibelleFrais` ON `autref` (`LibelleFrais`);
CREATE INDEX `WDIDX_autref_NCOMPTE` ON `autref` (`NCOMPTE`);

-- Création de la table caisseSco
CREATE TABLE `caisse` (
    `IDCAISSE` INTEGER DEFAULT 0,
    `dateouverture` DATE ,
    `heureouverture` TIME ,
    `datefermeture` DATE ,
    `heurefermeture` TIME ,
    `montantouverture` BIGINT ,
    `montantfermeture` BIGINT ,
    `montantbanque` BIGINT ,
    `soldecaisse` BIGINT ,
    `statutcaisse` VARCHAR(10) ,
    `mtarriere` INTEGER ,
    `mtarriereextra` INTEGER ,
    `mtscolarite` INTEGER ,
    `mtautres` INTEGER ,
    `SiTE` VARCHAR(15) ,
    `MFRAIS1` INTEGER DEFAULT 0,
    `MFRAIS2` INTEGER DEFAULT 0,
    `MFRAIS3` INTEGER DEFAULT 0,
    `MFRAIS4` INTEGER DEFAULT 0,
    `MAUTREF1` INTEGER DEFAULT 0,
    `MAUTREF2` INTEGER DEFAULT 0,
    `MAUTREF3` INTEGER DEFAULT 0,
    `MAUTREF4` INTEGER DEFAULT 0,
    `MAUTREF5` INTEGER DEFAULT 0,
    `MAUTREF6` INTEGER DEFAULT 0,
    `MAUTREF7` INTEGER DEFAULT 0,
    `MAUTREF8` INTEGER DEFAULT 0,
    `MAUTREF9` INTEGER DEFAULT 0,
    `MAUTREF10` INTEGER DEFAULT 0,
    `LAUTREF1` VARCHAR(50) ,
    `LAUTREF2` VARCHAR(50) ,
    `LAUTREF3` VARCHAR(50) ,
    `LAUTREF4` VARCHAR(50) ,
    `LAUTREF5` VARCHAR(50) ,
    `LAUTREF6` VARCHAR(50) ,
    `LAUTREF7` VARCHAR(50) ,
    `LAUTREF8` VARCHAR(50) ,
    `LAUTREF9` VARCHAR(50) ,
    `LAUTREF10` VARCHAR(50) ,
    `EFFECTIF` SMALLINT DEFAULT 0,
    `MPREVUSCO` INTEGER ,
    `MPREVUF1` INTEGER DEFAULT 0,
    `MPREVUF2` INTEGER DEFAULT 0,
    `MPREVUF3` INTEGER DEFAULT 0,
    `MPREVUF4` INTEGER DEFAULT 0,
    `MPREVUAR` INTEGER DEFAULT 0,
    `MPERCUSCO` INTEGER DEFAULT 0,
    `MPERCUF1` INTEGER DEFAULT 0,
    `MPERCUF2` INTEGER DEFAULT 0,
    `MPERCUF3` INTEGER DEFAULT 0,
    `MPERCUF4` INTEGER DEFAULT 0,
    `MPERCUAR` INTEGER DEFAULT 0,
    `ANneeScolaire` VARCHAR(9) ,
    `SIGNATURE` VARCHAR(20) ,
    `MPERCUAREXTRA` INTEGER ,
    `CodeSITE` VARCHAR(15) );
CREATE INDEX `WDIDX_caisseSco_IDCAISSE` ON `caisse` (`IDCAISSE`);

-- Création de la table CLASSES
CREATE TABLE `CLASSES` (
    `CODECLAS` VARCHAR(10) ,
    `CYCLE` VARCHAR(1) ,
    `CODEPROMO` VARCHAR(4) ,
    `TYPEENSEIG` INTEGER DEFAULT 0,
    `SERIE` VARCHAR(10) ,
    `APAYER` INTEGER DEFAULT 0,
    `FRAIS1` INTEGER DEFAULT 0,
    `FRAIS2` INTEGER DEFAULT 0,
    `FRAIS3` INTEGER DEFAULT 0,
    `FRAIS4` INTEGER DEFAULT 0,
    `MFORTE` REAL DEFAULT 0.000000,
    `MFAIBLE` REAL DEFAULT 0.000000,
    `MCLASSE` REAL DEFAULT 0.000000,
    `EFFECTIF` SMALLINT DEFAULT 1,
    `FILLER_E` BIGINT DEFAULT 0,
    `FILLER_T` VARCHAR(20) ,
    `LIBELCLAS` VARCHAR(15) ,
    `DPREMIER` DATE ,
    `MPREMIER` REAL DEFAULT 0,
    `DATEDEB` DATE ,
    `PERIODICITE` INTEGER DEFAULT 0,
    `DUREE` INTEGER DEFAULT 0,
    `APAYER2` INTEGER DEFAULT 0,
    `FRAIS1_A` INTEGER DEFAULT 0,
    `FRAIS2_A` INTEGER DEFAULT 0,
    `FRAIS3_A` INTEGER DEFAULT 0,
    `FRAIS4_A` INTEGER DEFAULT 0,
    `VOLANTE` TINYINT DEFAULT 0,
    `CODESALLE` VARCHAR(10) ,
    `MFIXE1` TINYINT DEFAULT 0,
    `MFIXE2` TINYINT DEFAULT 0,
    `MFIXE3` TINYINT DEFAULT 0,
    `TYPECLASSE` TINYINT DEFAULT 1,
    `CODECLASSEPARENT` VARCHAR(10) ,
    `EFFECTIFACTIF` INTEGER DEFAULT 0,
    `TYPEECHEANCIER` SMALLINT DEFAULT 1,
    `SIGNATURE` VARCHAR(20) ,
    `MFoRTE1` REAL DEFAULT 0,
    `MFoRTE2` REAL DEFAULT 0,
    `MFoRTE3` REAL DEFAULT 0,
    `MFoRTE4` REAL DEFAULT 0,
    `MFaIBLE1` REAL DEFAULT 0,
    `MFaIBLE2` REAL DEFAULT 0,
    `MFaIBLE3` REAL DEFAULT 0,
    `MFaIBLE4` REAL DEFAULT 0,
    `MCLASSE1` REAL DEFAULT 0,
    `MCLASSE2` REAL DEFAULT 0,
    `MCLASSE3` REAL DEFAULT 0,
    `MCLASSE4` REAL DEFAULT 0,
    `TAUXHORAIRE` REAL DEFAULT 0,
    `NumeroEB` VARCHAR(2) ,
    `MPREMIER2` REAL DEFAULT 0,
    `CodeFiliere` VARCHAR(10) ,
    `Annee_Etude` INTEGER DEFAULT 0,
    `Examen` VARCHAR(30) ,
    `TypeCours` VARCHAR(4) ,
    `PRIORITE` SMALLINT DEFAULT 0,
    `SystemeNotes` SMALLINT DEFAULT 1,
    `STATUT` VARCHAR(50) ,
    `Niveau` TINYINT DEFAULT 0,
    `SiTE` VARCHAR(15) ,
    `guid` VARCHAR(50)  UNIQUE ,
    `anneeacademique` VARCHAR(9) );
CREATE INDEX `WDIDX_CLASSES_CODECLAS` ON `CLASSES` (`CODECLAS`);
CREATE INDEX `WDIDX_CLASSES_CODEPROMO` ON `CLASSES` (`CODEPROMO`);
CREATE INDEX `WDIDX_CLASSES_SERIE` ON `CLASSES` (`SERIE`);
CREATE INDEX `WDIDX_CLASSES_CODESALLE` ON `CLASSES` (`CODESALLE`);
CREATE INDEX `WDIDX_CLASSES_TYPECLASSE` ON `CLASSES` (`TYPECLASSE`);
CREATE INDEX `WDIDX_CLASSES_CodeFiliere` ON `CLASSES` (`CodeFiliere`);
CREATE INDEX `WDIDX_CLASSES_TypeCours` ON `CLASSES` (`TypeCours`);
CREATE INDEX `WDIDX_CLASSES_PRIORITE` ON `CLASSES` (`PRIORITE`);

-- Création de la table classes_af
CREATE TABLE `classes_af` (
    `IDCLAASES_AF` INTEGER DEFAULT 0,
    `CODECLAS` VARCHAR(10) ,
    `IDAUTREF` BIGINT ,
    `MONTANT` INTEGER ,
    `MONTANTANCIEN` INTEGER ,
    `reccurent` TINYINT ,
    `CodeSITE` VARCHAR(15) ,
    `guid_classe` VARCHAR(50) );
CREATE INDEX `WDIDX_classes_af_IDCLAASES_AF` ON `classes_af` (`IDCLAASES_AF`);
CREATE INDEX `WDIDX_classes_af_CODECLAS` ON `classes_af` (`CODECLAS`);
CREATE INDEX `WDIDX_classes_af_IDAUTREF` ON `classes_af` (`IDAUTREF`);

-- Création de la table COURS
CREATE TABLE `COURS` (
    `JOUR` TINYINT DEFAULT 0,
    `HEURE` VARCHAR(4) ,
    `CODECLAS` VARCHAR(10) ,
    `CODEMAT` SMALLINT DEFAULT 0,
    `MATRICULE` BIGINT DEFAULT 0,
    `CODESALLE` VARCHAR(10) DEFAULT 'NON',
    `libre` TINYINT DEFAULT 1,
    `Typeenreg` VARCHAR(50) ,
    `guid` VARCHAR(50)  UNIQUE ,
    `guid_classe` VARCHAR(50) ,
    `SiTE` VARCHAR(15) ,
    `guid_mat` VARCHAR(50) ,
    `guid_agent` VARCHAR(50) ,
    `idcours` BIGINT DEFAULT 0,
    `anneeacademique` VARCHAR(9) );
CREATE INDEX `WDIDX_COURS_CODECLAS` ON `COURS` (`CODECLAS`);
CREATE INDEX `WDIDX_COURS_CODEMAT` ON `COURS` (`CODEMAT`);
CREATE INDEX `WDIDX_COURS_MATRICULE` ON `COURS` (`MATRICULE`);
CREATE INDEX `WDIDX_COURS_CODESALLE` ON `COURS` (`CODESALLE`);
CREATE INDEX `WDIDX_COURS_libre` ON `COURS` (`libre`);

-- Création de la table ECHEANCE
CREATE TABLE `ECHEANCE` (
    `NUMERO` INTEGER ,
    `DATEOP` DATE ,
    `APAYER` INTEGER ,
    `MATRICULE` BIGINT DEFAULT 0,
    `ARRIERE` INTEGER DEFAULT 0,
    `guid` VARCHAR(50)  UNIQUE ,
    `guid_matri` VARCHAR(50) ,
    `SiTE` VARCHAR(15) ,
    `idecheance` BIGINT DEFAULT 0,
    `anneeacademique` VARCHAR(9) );
CREATE INDEX `WDIDX_ECHEANCE_MATRICULE` ON `ECHEANCE` (`MATRICULE`);
CREATE INDEX `WDIDX_ECHEANCE_guid_matri` ON `ECHEANCE` (`guid_matri`);
CREATE INDEX `WDIDX_ECHEANCE_idecheance` ON `ECHEANCE` (`idecheance`);

-- Création de la table echeances_af
CREATE TABLE `echeances_af` (
    `IDECHEANCES_AF` INTEGER DEFAULT 0,
    `dateECH` DATE ,
    `montECH` INTEGER ,
    `CODECLAS` VARCHAR(10) ,
    `IDAUTREF` BIGINT ,
    `IDCLAASES_AF` BIGINT ,
    `NUMERO` INTEGER ,
    `montECH2` INTEGER ,
    `CodeSITE` VARCHAR(15) ,
    `guid_classe` VARCHAR(50) );
CREATE INDEX `WDIDX_echeances_af_IDECHEANCES_AF` ON `echeances_af` (`IDECHEANCES_AF`);
CREATE INDEX `WDIDX_echeances_af_CODECLAS` ON `echeances_af` (`CODECLAS`);
CREATE INDEX `WDIDX_echeances_af_IDAUTREF` ON `echeances_af` (`IDAUTREF`);
CREATE INDEX `WDIDX_echeances_af_IDCLAASES_AF` ON `echeances_af` (`IDCLAASES_AF`);
CREATE INDEX `WDIDX_echeances_af_NUMERO` ON `echeances_af` (`NUMERO`);

-- Création de la table ELEVE
CREATE TABLE `ELEVE` (
    `MATRICULE` BIGINT DEFAULT 0,
    `NOM` VARCHAR(30) ,
    `PRENOM` VARCHAR(30) ,
    `DATENAIS` DATE ,
    `LIEUNAIS` VARCHAR(30) ,
    `CODEDEPT` VARCHAR(3) ,
    `DATEINS` DATE ,
    `ADRPERS` VARCHAR(50) ,
    `ADRPAR` VARCHAR(50) ,
    `SEXE` INTEGER DEFAULT 0,
    `SERIE` VARCHAR(10) ,
    `STATUT` TINYINT DEFAULT 0,
    `APTE` INTEGER DEFAULT 0,
    `CODECLAS` VARCHAR(10) ,
    `ANCCLASSE` VARCHAR(10) ,
    `APAYER` INTEGER DEFAULT 0,
    `FRAIS1` INTEGER DEFAULT 0,
    `FRAIS2` INTEGER DEFAULT 0,
    `FRAIS3` INTEGER DEFAULT 0,
    `FRAIS4` INTEGER DEFAULT 0,
    `DATESCO` DATE ,
    `EXONERER` INTEGER DEFAULT 0,
    `NUMCARTE` VARCHAR(20) ,
    `SELCARTE` SMALLINT DEFAULT 0,
    `DATESOR` DATE ,
    `CLASSESOR` VARCHAR(10) ,
    `NOMPERE` VARCHAR(50) ,
    `NOMMERE` VARCHAR(50) ,
    `ETABORIG` VARCHAR(20) ,
    `numordre` SMALLINT DEFAULT 0,
    `DUPLICATA` TINYINT DEFAULT 0,
    `FILLER_E` BIGINT DEFAULT 0,
    `FILLER_T` VARCHAR(20) ,
    `MAN` REAL DEFAULT 0.000000,
    `RANGA` TINYINT DEFAULT 0,
    `AUTRE_RENS` VARCHAR(50) ,
    `Reduction` REAL DEFAULT 0.000000,
    `PHOTO` LONGBLOB ,
    `PCLASSE` VARCHAR(10) ,
    `MarquerP` SMALLINT DEFAULT 0,
    `STATUTG` SMALLINT DEFAULT 0,
    `ARRIERE` INTEGER DEFAULT 0,
    `TEL` VARCHAR(20) ,
    `CALCULERMOY` TINYINT DEFAULT 0,
    `NeVers` TINYINT DEFAULT 0,
    `SIGNATURE` VARCHAR(20) ,
    `NATIONALITE` VARCHAR(20) ,
    `MATRICULEX` VARCHAR(12) ,
    `TYPEENSEIG` INTEGER DEFAULT 0,
    `TYPECLASSE` TINYINT DEFAULT 0,
    `MATRICULEORIGINE` INTEGER DEFAULT 0,
    `ABANDON` TINYINT DEFAULT 0,
    `COMMUNE` VARCHAR(30) ,
    `CODEWEB` VARCHAR(12) ,
    `EB_ANONYMAT` INTEGER DEFAULT 0,
    `MS1` REAL DEFAULT -1,
    `MS2` REAL DEFAULT -1,
    `MS3` REAL DEFAULT -1,
    `RANG1` SMALLINT DEFAULT 0,
    `RANG2` SMALLINT DEFAULT 0,
    `RANG3` SMALLINT DEFAULT 0,
    `MBILANL1` REAL DEFAULT 0,
    `MBILANL2` REAL DEFAULT 0,
    `MBILANL3` REAL DEFAULT 0,
    `MBILANS1` REAL DEFAULT 0,
    `MBILANS2` REAL DEFAULT 0,
    `MBILANS3` REAL DEFAULT 0,
    `MBILANA1` REAL DEFAULT 0,
    `MBILANA2` REAL DEFAULT 0,
    `MBILANA3` REAL DEFAULT 0,
    `NoteConduite1` REAL DEFAULT 0,
    `NoteConduite2` REAL DEFAULT 0,
    `NoteConduite3` REAL DEFAULT 0,
    `MoyMatFond1` REAL DEFAULT 0,
    `MoyMatFond2` REAL DEFAULT 0,
    `MoyMatFond3` REAL DEFAULT 0,
    `TotalGene1` REAL DEFAULT 0,
    `TotalGene2` REAL DEFAULT 0,
    `TotalGene3` REAL DEFAULT 0,
    `TotalCoef1` REAL DEFAULT 0,
    `TotalCoef2` REAL DEFAULT 0,
    `TotalCoef3` REAL DEFAULT 0,
    `CODESECURITE` VARCHAR(12) ,
    `EcheancierPerso` TINYINT DEFAULT 0,
    `CodeReduction` INTEGER ,
    `TelEleve` VARCHAR(20) ,
    `ConfirmeTel` TINYINT DEFAULT 0,
    `LienPhoto` VARCHAR(255) ,
    `ARRIERE_INITIAL` INTEGER DEFAULT 0,
    `indicatif1` VARCHAR(4) ,
    `indicatif2` VARCHAR(4) ,
    `AnneeBac` INTEGER DEFAULT 0,
    `SerieBac` VARCHAR(4) DEFAULT '0',
    `ResultatFinAnnee` SMALLINT DEFAULT 0,
    `MS4` REAL DEFAULT -1,
    `MS5` REAL DEFAULT -1,
    `MS6` REAL DEFAULT -1,
    `MS7` REAL DEFAULT -1,
    `MS8` REAL DEFAULT -1,
    `MS9` REAL DEFAULT -1,
    `MS10` REAL DEFAULT -1,
    `MS11` REAL DEFAULT -1,
    `MS12` REAL DEFAULT -1,
    `RANG4` SMALLINT DEFAULT 0,
    `RANG5` SMALLINT DEFAULT 0,
    `RANG6` SMALLINT DEFAULT 0,
    `RANG7` SMALLINT DEFAULT 0,
    `RANG8` SMALLINT DEFAULT 0,
    `RANG9` SMALLINT DEFAULT 0,
    `RANG10` SMALLINT DEFAULT 0,
    `RANG11` SMALLINT DEFAULT 0,
    `RANG12` SMALLINT DEFAULT 0,
    `SiTE` VARCHAR(15) ,
    `app1` VARCHAR(100) ,
    `app2` VARCHAR(100) ,
    `app3` VARCHAR(100) ,
    `appan` VARCHAR(100) ,
    `guid_matri` VARCHAR(50)  NOT NULL  UNIQUE ,
    `guid_classe` VARCHAR(50) ,
    `guid_red` VARCHAR(50) ,
    `anneeacademique` VARCHAR(9) ,
    `email_parent` VARCHAR(100) ,
    `statutnotes` TINYINT DEFAULT 0,
    `statutfinances` TINYINT DEFAULT 0,
    `statutdiscipline` TINYINT DEFAULT 0,
    `statutemploi` TINYINT DEFAULT 0);
CREATE INDEX `WDIDX_ELEVE_MATRICULE` ON `ELEVE` (`MATRICULE`);
CREATE INDEX `WDIDX_ELEVE_NOM` ON `ELEVE` (`NOM`);
CREATE INDEX `WDIDX_ELEVE_PRENOM` ON `ELEVE` (`PRENOM`);
CREATE INDEX `WDIDX_ELEVE_CODEDEPT` ON `ELEVE` (`CODEDEPT`);
CREATE INDEX `WDIDX_ELEVE_CODECLAS` ON `ELEVE` (`CODECLAS`);
CREATE INDEX `WDIDX_ELEVE_ANCCLASSE` ON `ELEVE` (`ANCCLASSE`);
CREATE INDEX `WDIDX_ELEVE_SELCARTE` ON `ELEVE` (`SELCARTE`);
CREATE INDEX `WDIDX_ELEVE_FILLER_T` ON `ELEVE` (`FILLER_T`);
CREATE INDEX `WDIDX_ELEVE_MATRICULEX` ON `ELEVE` (`MATRICULEX`);
CREATE INDEX `WDIDX_ELEVE_TYPEENSEIG` ON `ELEVE` (`TYPEENSEIG`);
CREATE INDEX `WDIDX_ELEVE_TYPECLASSE` ON `ELEVE` (`TYPECLASSE`);
CREATE INDEX `WDIDX_ELEVE_CODEWEB` ON `ELEVE` (`CODEWEB`);
CREATE INDEX `WDIDX_ELEVE_CODESECURITE` ON `ELEVE` (`CODESECURITE`);
CREATE INDEX `WDIDX_ELEVE_CodeReduction` ON `ELEVE` (`CodeReduction`);

-- Création de la table eleve_af
CREATE TABLE `eleve_af` (
    `MATRICULE` BIGINT ,
    `montantAF` INTEGER ,
    `IDAUTREF` BIGINT ,
    `reductionAF` INTEGER ,
    `CodeSITE` VARCHAR(15) ,
    `guid_matri` VARCHAR(50) );
CREATE INDEX `WDIDX_eleve_af_MATRICULE` ON `eleve_af` (`MATRICULE`);
CREATE INDEX `WDIDX_eleve_af_IDAUTREF` ON `eleve_af` (`IDAUTREF`);
CREATE INDEX `WDIDX_eleve_af_guid_matri` ON `eleve_af` (`guid_matri`);

-- Création de la table FAUTES
CREATE TABLE `FAUTES` (
    `IDFAUTES` INTEGER  NOT NULL  DEFAULT 0,
    `MATRICULE` BIGINT ,
    `DATEOP` DATE ,
    `FAUTE` LONGTEXT ,
    `SANCTION` LONGTEXT ,
    `NBHEURE` REAL DEFAULT 0,
    `SEMESTRE` TINYINT DEFAULT 0,
    `COLLECTIVE` TINYINT DEFAULT 0,
    `idTFautes` INTEGER DEFAULT 0,
    `IDABSENCE` INTEGER DEFAULT 0,
    `guid` VARCHAR(50)  UNIQUE ,
    `guid_matri` VARCHAR(50) ,
    `SiTE` VARCHAR(15) ,
    `guid_abs` VARCHAR(50) ,
    `anneeacademique` VARCHAR(9) );
CREATE INDEX `WDIDX_FAUTES_IDFAUTES` ON `FAUTES` (`IDFAUTES`);
CREATE INDEX `WDIDX_FAUTES_MATRICULE` ON `FAUTES` (`MATRICULE`);
CREATE INDEX `WDIDX_FAUTES_DATEOP` ON `FAUTES` (`DATEOP`);
CREATE INDEX `WDIDX_FAUTES_idTFautes` ON `FAUTES` (`idTFautes`);
CREATE INDEX `WDIDX_FAUTES_guid_matri` ON `FAUTES` (`guid_matri`);

-- Création de la table MATIERES
CREATE TABLE `MATIERES` (
    `CODEMAT` SMALLINT DEFAULT 0,
    `LIBELMAT` VARCHAR(30) ,
    `COULEUR` BIGINT DEFAULT 0,
    `NOMCOURT` VARCHAR(4) ,
    `TYPEMAT` TINYINT DEFAULT 3,
    `PLAGEINTERDITE` VARCHAR(50) ,
    `COULEURECRIT` INTEGER DEFAULT 0,
    `ANSCOL` VARCHAR(9) ,
    `CODEMAT_LIGNE` VARCHAR(50) ,
    `guid` VARCHAR(50)  UNIQUE ,
    `SiTE` VARCHAR(15) );
CREATE INDEX `WDIDX_MATIERES_CODEMAT` ON `MATIERES` (`CODEMAT`);
CREATE INDEX `WDIDX_MATIERES_NOMCOURT` ON `MATIERES` (`NOMCOURT`);

-- Création de la table ModifyStatus
CREATE TABLE `ModifyStatus` (
    `IDModifyStatus` INTEGER DEFAULT 0,
    `guid_matri` VARCHAR(50)  UNIQUE ,
    `statutnotes` TINYINT DEFAULT 0,
    `statutfinances` TINYINT DEFAULT 0,
    `statutemploi` TINYINT DEFAULT 0,
    `statutdiscipline` TINYINT DEFAULT 0,
    `CodeSITE` VARCHAR(15) ,
    `guid_classe` VARCHAR(50) );
CREATE INDEX `WDIDX_ModifyStatus_IDModifyStatus` ON `ModifyStatus` (`IDModifyStatus`);

-- Création de la table motif
CREATE TABLE `motif` (
    `CodeMotif` INTEGER  UNIQUE  DEFAULT 0,
    `Motifdeces` VARCHAR(50) );

-- Création de la table NOTES
CREATE TABLE `NOTES` (
    `INT1` REAL DEFAULT 0.000000,
    `INT2` REAL DEFAULT 0.000000,
    `INT3` REAL DEFAULT 0.000000,
    `INT4` REAL DEFAULT 0.000000,
    `MI` REAL DEFAULT 0.000000,
    `DEV1` REAL DEFAULT 0.000000,
    `DEV2` REAL DEFAULT 0.000000,
    `DEV3` REAL DEFAULT 0.000000,
    `MS` REAL DEFAULT 0.000000,
    `COEF` REAL DEFAULT 0.000000,
    `SEMESTRE` TINYINT DEFAULT 0,
    `MATRICULE` BIGINT DEFAULT 0,
    `CODECLAS` VARCHAR(10) ,
    `CODEMAT` SMALLINT DEFAULT 0,
    `CODEUSER` VARCHAR(15) ,
    `RANG` SMALLINT DEFAULT 0,
    `FILLER_T` VARCHAR(20) ,
    `FILLER_E` BIGINT DEFAULT 0,
    `TEST` REAL DEFAULT 0.000000,
    `MS1` REAL DEFAULT 0.000000,
    `MODIFIER` TINYINT DEFAULT 0,
    `VERROUILLE` TINYINT DEFAULT 0,
    `DATECREE` DATE ,
    `DATEMODIF` DATE ,
    `ANSCOL` VARCHAR(9) ,
    `INT5` REAL DEFAULT 0,
    `INT6` REAL DEFAULT 0,
    `INT7` REAL DEFAULT 0,
    `INT8` REAL DEFAULT 0,
    `INT9` REAL DEFAULT 0,
    `INT10` REAL DEFAULT 0,
    `SystemeNotes` SMALLINT DEFAULT 1,
    `IDNOTES` BIGINT DEFAULT 0,
    `guid` VARCHAR(50)  UNIQUE ,
    `guid_matri` VARCHAR(50) ,
    `SiTE` VARCHAR(15) ,
    `guid_mat` VARCHAR(50) ,
    `guid_classe` VARCHAR(50) );
CREATE INDEX `WDIDX_NOTES_MATRICULE` ON `NOTES` (`MATRICULE`);
CREATE INDEX `WDIDX_NOTES_CODECLAS` ON `NOTES` (`CODECLAS`);
CREATE INDEX `WDIDX_NOTES_CODEMAT` ON `NOTES` (`CODEMAT`);
CREATE INDEX `WDIDX_NOTES_DATECREE` ON `NOTES` (`DATECREE`);
CREATE INDEX `WDIDX_NOTES_IDNOTES` ON `NOTES` (`IDNOTES`);

-- Création de la table paiement_af
CREATE TABLE `paiement_af` (
    `IDPAIEMENT_AF` INTEGER DEFAULT 0,
    `DATEPAIE` DATE ,
    `MONTANTPAIE` INTEGER ,
    `MATRICULE` BIGINT ,
    `IDAUTREF` BIGINT ,
    `IDCLAASES_AF` BIGINT ,
    `NUMRECU` BIGINT ,
    `EDITE` TINYINT ,
    `Tranche` TINYINT ,
    `RPAYE` BIGINT ,
    `ECHEANCETRANCHE` DATE ,
    `MODEPAIE` TINYINT ,
    `VALIDE` TINYINT ,
    `MOTIF` VARCHAR(100) ,
    `signature` VARCHAR(50) ,
    `CodeSITE` VARCHAR(15) ,
    `guid_matri` VARCHAR(50) );
CREATE INDEX `WDIDX_paiement_af_IDPAIEMENT_AF` ON `paiement_af` (`IDPAIEMENT_AF`);
CREATE INDEX `WDIDX_paiement_af_MATRICULE` ON `paiement_af` (`MATRICULE`);
CREATE INDEX `WDIDX_paiement_af_IDAUTREF` ON `paiement_af` (`IDAUTREF`);
CREATE INDEX `WDIDX_paiement_af_IDCLAASES_AF` ON `paiement_af` (`IDCLAASES_AF`);
CREATE INDEX `WDIDX_paiement_af_NUMRECU` ON `paiement_af` (`NUMRECU`);
CREATE INDEX `WDIDX_paiement_af_guid_matri` ON `paiement_af` (`guid_matri`);

-- Création de la table PROFCLAS
CREATE TABLE `PROFCLAS` (
    `CODECLAS` VARCHAR(10) ,
    `CODEMAT` SMALLINT DEFAULT 0,
    `MATRICULE` BIGINT DEFAULT 0,
    `TAUXHORAIRE` REAL DEFAULT 0.000000,
    `guid` VARCHAR(50)  UNIQUE ,
    `guid_classe` VARCHAR(50) ,
    `guid_mat` VARCHAR(50) ,
    `guid_agent` VARCHAR(50) ,
    `SiTE` VARCHAR(15) ,
    `anneeacademique` VARCHAR(9) ,
    `idprofclas` BIGINT DEFAULT 0);
CREATE INDEX `WDIDX_PROFCLAS_CODECLAS` ON `PROFCLAS` (`CODECLAS`);
CREATE INDEX `WDIDX_PROFCLAS_CODEMAT` ON `PROFCLAS` (`CODEMAT`);
CREATE INDEX `WDIDX_PROFCLAS_MATRICULE` ON `PROFCLAS` (`MATRICULE`);

-- Création de la table reduction
CREATE TABLE `reduction` (
    `CodeReduction` INTEGER ,
    `LibelleReduction` VARCHAR(50) ,
    `Reduction_scolarite` DOUBLE ,
    `Reduction_arriere` REAL ,
    `Reduction_frais1` REAL ,
    `Reduction_frais2` REAL ,
    `Reduction_frais3` REAL ,
    `Reduction_frais4` REAL ,
    `SIGNATURE` VARCHAR(20) ,
    `mode` SMALLINT ,
    `guid` VARCHAR(50)  UNIQUE ,
    `SiTE` VARCHAR(15) ,
    `anneeacademique` VARCHAR(9) ,
    `Reduction_fixe_sco` INTEGER ,
    `Reduction_fixe_frais1` INTEGER ,
    `Reduction_fixe_frais2` INTEGER ,
    `Reduction_fixe_frais3` INTEGER ,
    `Reduction_fixe_frais4` INTEGER ,
    `Reduction_fixe_arriere` INTEGER ,
    `typereduction` VARCHAR(1) DEFAULT 'P');
CREATE INDEX `WDIDX_reduction_CodeReduction` ON `reduction` (`CodeReduction`);

-- Création de la table SCOLARIT
CREATE TABLE `SCOLARIT` (
    `NUMERO` INTEGER ,
    `MATRICULE` BIGINT ,
    `DATEOP` DATE ,
    `MONTANT` INTEGER ,
    `AUTREF` INTEGER ,
    `EDITE` TINYINT ,
    `NUMRECU` INTEGER ,
    `SIGNATURE` VARCHAR(20) ,
    `FILLER_E` BIGINT ,
    `FILLER_T` VARCHAR(20) ,
    `MODEPAIE` SMALLINT DEFAULT 0,
    `VALIDE` TINYINT DEFAULT 1,
    `MODIFIABLE` VARCHAR(1) DEFAULT 'V',
    `DATESAISIE` DATE ,
    `ANSCOL` VARCHAR(9) ,
    `VERROUILLE` TINYINT DEFAULT 1,
    `MOTIF_SUPP` VARCHAR(50) ,
    `IdSCOLARITE` BIGINT DEFAULT 0,
    `guid` VARCHAR(50)  UNIQUE ,
    `guid_matri` VARCHAR(50) ,
    `SiTE` VARCHAR(15) );
CREATE INDEX `WDIDX_SCOLARIT_NUMERO` ON `SCOLARIT` (`NUMERO`);
CREATE INDEX `WDIDX_SCOLARIT_MATRICULE` ON `SCOLARIT` (`MATRICULE`);
CREATE INDEX `WDIDX_SCOLARIT_DATEOP` ON `SCOLARIT` (`DATEOP`);
CREATE INDEX `WDIDX_SCOLARIT_NUMRECU` ON `SCOLARIT` (`NUMRECU`);
CREATE INDEX `WDIDX_SCOLARIT_MODIFIABLE` ON `SCOLARIT` (`MODIFIABLE`);
CREATE INDEX `WDIDX_SCOLARIT_IdSCOLARITE` ON `SCOLARIT` (`IdSCOLARITE`);
CREATE INDEX `WDIDX_SCOLARIT_guid_matri` ON `SCOLARIT` (`guid_matri`);
CREATE INDEX `WDIDX_SCOLARIT_MATNUM` ON `SCOLARIT` (`MATRICULE`,`NUMERO`);
CREATE INDEX `WDIDX_SCOLARIT_MATDATE` ON `SCOLARIT` (`MATRICULE`,`DATEOP`);
CREATE INDEX `WDIDX_SCOLARIT_MATRECU` ON `SCOLARIT` (`MATRICULE`,`NUMRECU`);
CREATE INDEX `WDIDX_SCOLARIT_NUMEROAUTREF` ON `SCOLARIT` (`NUMERO`,`AUTREF`);

-- Création de la table scolaritAF
CREATE TABLE `scolaritAF` (
    `IDscolaritAF` INTEGER DEFAULT 0,
    `libelaf` VARCHAR(50) ,
    `montantp` INTEGER DEFAULT 0,
    `resteap` INTEGER DEFAULT 0,
    `MATRICULE` VARCHAR(50) DEFAULT '0',
    `guid_matri` VARCHAR(50) ,
    `SiTE` VARCHAR(15) );
CREATE INDEX `WDIDX_scolaritAF_IDscolaritAF` ON `scolaritAF` (`IDscolaritAF`);
CREATE INDEX `WDIDX_scolaritAF_MATRICULE` ON `scolaritAF` (`MATRICULE`);
CREATE INDEX `WDIDX_scolaritAF_guid_matri` ON `scolaritAF` (`guid_matri`);

-- Création de la table tfraisannexes
CREATE TABLE `tfraisannexes` (
    `AUTREF` INTEGER DEFAULT 0,
    `libelfrais` VARCHAR(50) ,
    `SiTE` VARCHAR(15) );
CREATE INDEX `WDIDX_tfraisannexes_AUTREF` ON `tfraisannexes` (`AUTREF`);

-- Création de la table TrimEnCours
CREATE TABLE `TrimEnCours` (
    `timestreencours` INTEGER DEFAULT 0,
    `TYPEAN` VARCHAR(5) DEFAULT '0',
    `CodeSITE` VARCHAR(15)  UNIQUE );
-- Contraintes d'intégrité
ALTER TABLE `SCOLARIT` ADD FOREIGN KEY (`guid_matri`) REFERENCES `ELEVE` (`guid_matri`);
ALTER TABLE `ECHEANCE` ADD FOREIGN KEY (`guid_matri`) REFERENCES `ELEVE` (`guid_matri`);
ALTER TABLE `FAUTES` ADD FOREIGN KEY (`guid_matri`) REFERENCES `ELEVE` (`guid_matri`);
ALTER TABLE `ARRIERES` ADD FOREIGN KEY (`guid_matri`) REFERENCES `ELEVE` (`guid_matri`);