CREATE TABLE SCHOOLCERTIFICATES 
(
  NIF VARCHAR2(10 BYTE) 
, NAME VARCHAR2(50 BYTE) 
, SURNAME VARCHAR2(50 BYTE) 
, COURSE VARCHAR2(100 BYTE) 
, STARTDATE DATE 
, ENDDATE DATE 
) 
LOGGING 
TABLESPACE "USERS" 
PCTFREE 10 
INITRANS 1 
STORAGE 
( 
  INITIAL 65536 
  MINEXTENTS 1 
  MAXEXTENTS 2147483645 
  BUFFER_POOL DEFAULT 
);

CREATE TABLE REGISTRY 
(
  CLASS VARCHAR2(50 BYTE) 
, REQUEST CLOB 
, RESPONSE CLOB 
, USERID VARCHAR2(20 BYTE) 
, TIMESTAMP DATE 
, SERVER VARCHAR2(40 BYTE) 
, REMOTEADDR VARCHAR2(40 BYTE) 
, ID VARCHAR2(20 BYTE) NOT NULL 
, CONSTRAINT REGISTRY_PK PRIMARY KEY 
  (
    ID 
  )
  ENABLE 
) 
LOGGING 
TABLESPACE "USERS" 
PCTFREE 10 
INITRANS 1 
STORAGE 
( 
  INITIAL 65536 
  MINEXTENTS 1 
  MAXEXTENTS 2147483645 
  BUFFER_POOL DEFAULT 
) 
LOB (REQUEST) STORE AS SYS_LOB0000013756C00002$$ 
( 
  ENABLE STORAGE IN ROW 
  CHUNK 8192 
  RETENTION 
  NOCACHE 
  LOGGING 
  STORAGE 
  ( 
    INITIAL 65536 
    MINEXTENTS 1 
    MAXEXTENTS 2147483645 
    BUFFER_POOL DEFAULT 
  )  
) 	
LOB (RESPONSE) STORE AS SYS_LOB0000013756C00003$$ 
( 
  ENABLE STORAGE IN ROW 
  CHUNK 8192 
  RETENTION 
  NOCACHE 
  LOGGING 
  STORAGE 
  ( 
    INITIAL 65536 
    MINEXTENTS 1 
    MAXEXTENTS 2147483645 
    BUFFER_POOL DEFAULT 
  )  
);

CREATE SEQUENCE REG_SEQ INCREMENT BY 1 MAXVALUE 999999999999999999999999999 MINVALUE 1 CACHE 20;