schema-oracle.sql

/* Si vous voulez utiliser Instadia!! */
CREATE
  TABLE INSTADIA
  (
    ID            NUMBER (*,0) NOT NULL ,
    USER_ID       NUMBER (*,0) ,
    RUBRIQUE      VARCHAR2 (80 CHAR) NOT NULL ,
    SOUS_RUBRIQUE VARCHAR2 (80 CHAR) ,
    HORODATAGE    DATE NOT NULL ,
    CONTENU       VARCHAR2 (3000 CHAR) NOT NULL
  )
  LOGGING ;
ALTER TABLE INSTADIA ADD CONSTRAINT INSTADIA_PK PRIMARY KEY ( id ) ;

ALTER TABLE INSTADIA ADD CONSTRAINT INSTADIA_USER_FK FOREIGN KEY ( USER_ID )
REFERENCES "USER" ( ID ) ON DELETE SET NULL NOT DEFERRABLE ;

CREATE SEQUENCE INSTADIA_ID_SEQ;