/* continue_if_error  */
CREATE TABLE RETROACTIVATION
(
id Integer NOT NULL,
isa Timestamp NOT NULL,
CONSTRAINT PK_RETROACTIVATION PRIMARY KEY (id)
);
/* continue_if_error  */
CREATE GENERATOR RETROACTIVATION;
SET GENERATOR RETROACTIVATION TO 1;

/* continue_if_error  */
CREATE TABLE RETROACTIVATION_PASSAGE
(
  ID Integer NOT NULL,
  MONTANT Numeric(10,2),
  INDIVIDU Integer,
  PORTE_MONNAIE Integer, 
  RESERVATION Integer,
  PASSAGE Integer,  
  QUOTIENT_FAMILIAL Integer,    
  R_MONTANT Numeric(10,2),
  R_MONTANT_TICKET Numeric(10,2),
  R_QUOTIENT_FAMILIAL Integer,    
  CONSTRAINT PK_RETROACTIVATION_PASSAGE PRIMARY KEY (ID)
);
/* continue_if_error  */
CREATE INDEX idx_RETROACTIVATION_INDIVIDU ON RETROACTIVATION_PASSAGE (INDIVIDU);

/* continue_if_error  */
CREATE TABLE RETROACTIVATION_PASSAGE_TEMP
(
  ID Integer NOT NULL,
  MONTANT Numeric(10,2),
  INDIVIDU Integer,
  PORTE_MONNAIE Integer, 
  RESERVATION Integer,
  PASSAGE Integer,  
  QUOTIENT_FAMILIAL Integer,    
  R_MONTANT Numeric(10,2),
  R_MONTANT_TICKET Numeric(10,2),
  R_QUOTIENT_FAMILIAL Integer,    
  CONSTRAINT PK_RETROACTIVATION_PASSAGE_TEMP PRIMARY KEY (ID)
);
/* continue_if_error  */
CREATE INDEX idx_RETROACTIVATION_TEMP_INDIV ON RETROACTIVATION_PASSAGE_TEMP (INDIVIDU);

/* continue_if_error  */
CREATE TABLE RETROACTIVATION_PASSAGE_LOG
(
  GEN_RETROACTIVATION_ID Integer NOT NULL,
  ID Integer NOT NULL,
  MONTANT Numeric(10,2),
  INDIVIDU Integer,
  PORTE_MONNAIE Integer, 
  RESERVATION Integer,
  PASSAGE Integer,  
  QUOTIENT_FAMILIAL Integer,    
  R_MONTANT Numeric(10,2),
  R_MONTANT_TICKET Numeric(10,2),
  R_QUOTIENT_FAMILIAL Integer
);
--------------------------------


