--- /dev/null
+create table Agenda_EventAgenda (
+ evtId LONG not null primary key,
+ companyId LONG,
+ startEvt DATE null,
+ endEvt DATE null,
+ calId LONG,
+ title VARCHAR(100) null,
+ location VARCHAR(150) null,
+ notes VARCHAR(400) null,
+ url VARCHAR(2048) null,
+ isAllDay BOOLEAN,
+ isVisible BOOLEAN,
+ remind VARCHAR(75) null,
+ creatorId LONG,
+ repeatEvtId LONG,
+ repeatEvtRRule VARCHAR(75) null,
+ modifiedDate DATE null,
+ uid VARCHAR(150) null
+);
+
+create table Agenda_Ressource (
+ idRessource LONG not null primary key,
+ idcreator LONG,
+ name VARCHAR(75) null,
+ description VARCHAR(1000) null,
+ ressourceType INTEGER,
+ scope INTEGER,
+ color VARCHAR(75) null,
+ etabId LONG,
+ kind INTEGER,
+ forcePubli BOOLEAN,
+ cdtUserId LONG,
+ ressource BOOLEAN,
+ ecriture BOOLEAN,
+ filtreCours INTEGER,
+ classe LONG,
+ matiere VARCHAR(75) null,
+ onlyMyClass BOOLEAN
+);
+
+create table Agenda_RessourceRole (
+ idRessourceRole LONG not null primary key,
+ idRessource LONG,
+ idRole LONG
+);
+
+create table Agenda_RessourceUser (
+ idRessourceUser LONG not null primary key,
+ idRessource LONG,
+ idUser LONG,
+ redacteur BOOLEAN,
+ visible BOOLEAN,
+ shared BOOLEAN
+);
\ No newline at end of file