CREATE TABLE T_COMPTABILITE_CPT
(CPT_ID                 INTEGER        NOT NULL PRIMARY KEY,
 CPT_LIBELLE_ECRITURE   VARCHAR(32)    NOT NULL,
 CPT_DATE               DATE           NOT NULL DEFAULT CURRENT_DATE,
 CPT_DEBIT_US           MONNAIE_DOLLAR  NOT NULL DEFAULT 0 
                                       CHECK VALUE >=0,
 CPT_DEBIT_UE           MONNAIE_EURO   NOT NULL DEFAULT 0 
                                       CHECK VALUE >=0,
 CPT_CREDIT_US          MONNAIE_DOLLAR  NOT NULL DEFAULT 0 
                                       CHECK VALUE >=0,
 CPT_CREDIT_UE          MONNAIE_EURO   NOT NULL DEFAULT 0 
                                       CHECK VALUE >=0,
 CPT_COURS_DOLLAR_EURO  FLOAT) ;
