[sql] test
Viewer
- <?xml version="1.1" encoding="UTF-8" standalone="no"?>
- <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd">
- <changeSet author="dbellacicco (generated)" id="1618410496280-7">
- <createTable tableName="pco012_regles_derog">
- <COLUMN autoIncrement="true" name="IDF_REGLE_DEROG" TYPE="INT">
- <constraints primaryKey="true" UNIQUE="true"/>
- </column>
- <COLUMN name="EFFECTIF_MIN" TYPE="INT">
- <constraints NULLABLE="false"/>
- </column>
- <COLUMN name="EFFECTIF_MAX" TYPE="INT"/>
- <COLUMN name="CODE_CLASSE_OFFRES_RECMDE" TYPE="VARCHAR(20)">
- <constraints NULLABLE="false"/>
- </column>
- <COLUMN name="CODE_CLASSE_OFFRES_DEROG" TYPE="VARCHAR(20)">
- <constraints NULLABLE="false"/>
- </column>
- <COLUMN name="CODE_RESEAU" TYPE="VARCHAR(20)"/>
- <COLUMN name="DATCREAT" TYPE="date">
- <constraints NULLABLE="false"/>
- </column>
- <COLUMN defaultValue="USER" name="UPDTUSER" TYPE="VARCHAR(8)">
- <constraints NULLABLE="false"/>
- </column>
- <COLUMN defaultValueComputed="current_timestamp()" name="CONFLIT" TYPE="timestamp">
- <constraints NULLABLE="false"/>
- </column>
- </createTable>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-8">
- <createTable tableName="sample">
- <COLUMN autoIncrement="true" name="id" TYPE="BIGINT">
- <constraints primaryKey="true"/>
- </column>
- <COLUMN name="name" remarks="Nom du sample" TYPE="VARCHAR(255)"/>
- </createTable>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-9">
- <addColumn tableName="pco001_opportunite_coml">
- <COLUMN name="CODE_RESEAU" TYPE="CHAR(3 BYTE)"/>
- </addColumn>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-10">
- <addColumn tableName="pco001_opportunite_coml">
- <COLUMN name="IDCR_ERR_MAIL_SAISINES" TYPE="CHAR(1 BYTE)"/>
- </addColumn>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-11">
- <createIndex indexName="RPCO007PCO012_1" tableName="pco012_regles_derog">
- <COLUMN name="CODE_CLASSE_OFFRES_RECMDE"/>
- </createIndex>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-12">
- <createIndex indexName="RPCO007PCO012_2" tableName="pco012_regles_derog">
- <COLUMN name="CODE_CLASSE_OFFRES_DEROG"/>
- </createIndex>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-13">
- <addForeignKeyConstraint baseColumnNames="CODE_CLASSE_OFFRES_RECMDE" baseTableName="pco012_regles_derog" constraintName="RPCO007PCO012_1" DEFERRABLE="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CODE_CLASSE_OFFRES" referencedTableName="pco007_lv_classe_offres" validate="true"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-14">
- <addForeignKeyConstraint baseColumnNames="CODE_CLASSE_OFFRES_DEROG" baseTableName="pco012_regles_derog" constraintName="RPCO007PCO012_2" DEFERRABLE="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="CODE_CLASSE_OFFRES" referencedTableName="pco007_lv_classe_offres" validate="true"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-15">
- <dropForeignKeyConstraint baseTableName="pco003_etablissement_opport_coml" constraintName="RPCO002PCO003"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-16">
- <dropForeignKeyConstraint baseTableName="pco001_opportunite_coml" constraintName="RPCO010PCO001"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-17">
- <dropForeignKeyConstraint baseTableName="pco001_opportunite_coml" constraintName="RPCO011PCO001"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-18">
- <dropUniqueConstraint constraintName="XPCO003K0" tableName="pco003_etablissement_opport_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-19">
- <dropUniqueConstraint constraintName="XPCO010K0" tableName="pco010_lv_type_apporteur"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-20">
- <dropUniqueConstraint constraintName="XPCO011K0" tableName="pco011_lv_partenaire"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-21">
- <dropTable tableName="pco003_etablissement_opport_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-22">
- <dropTable tableName="pco010_lv_type_apporteur"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-23">
- <dropTable tableName="pco011_lv_partenaire"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-24">
- <dropColumn columnName="CODE_PARTENAIRE" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-25">
- <dropColumn columnName="CODE_TYPE_APPORTEUR" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-26">
- <dropColumn columnName="DATE_EFFET" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-27">
- <dropColumn columnName="IDCR_ERR_BC" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-28">
- <dropColumn columnName="IDCR_ERR_CRM_CREATION" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-29">
- <dropColumn columnName="IDCR_ERR_CRM_OPPORT" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-30">
- <dropColumn columnName="IDCR_PILOTE" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-31">
- <dropColumn columnName="NO_SIRET_APPORT" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-32">
- <dropColumn columnName="REFC_OPPTE_CRM" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-33">
- <dropColumn columnName="RESULT_CTRL_SAISIE" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-1">
- <setColumnRemarks columnName="CODE_DOMAINE_METIER" remarks="Valeurs Possibles : PR = PRevoyance SA = SAnté MX = Mixte (Santé & Prév
- oyance)" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-2">
- <setColumnRemarks columnName="CODE_DOMAINE_METIER" remarks="Valeurs Possibles : PR = PRevoyance SA = SAnté MX = Mixte (Santé & Prév
- oyance)" tableName="pco005_lv_domaine_metier"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-3">
- <setColumnRemarks columnName="CODE_STTT_OPPORT_COML" remarks="Valeurs possibles : INIT = "initialisée" (écran recherche du SIREN) CTR
- L = "contrôlée" (écran Contrôle de saisie)" tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-4">
- <setColumnRemarks columnName="CODE_STTT_OPPORT_COML" remarks="Valeurs possibles : INIT = "initialisée" (écran recherche du SIREN) CTR
- L = "contrôlée" (écran Contrôle de saisie)" tableName="pco006_lv_statut_opport_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-5">
- <setColumnRemarks columnName="IDCR_DEROG_CLASSE_OFFRES" remarks="Cet indicateur permet d indiquer s il y a dérogation ou non sur le choi
- x de la Classe des Offres.. Si valeur = 1 alors il y a une dérogation
- . Sinon (si NULL) pas de dérogation." tableName="pco001_opportunite_coml"/>
- </changeSet>
- <changeSet author="dbellacicco (generated)" id="1618410496280-6">
- <setColumnRemarks columnName="IDCR_ERR_MOCADI" remarks="Cet indicateur permet d indiquer s il y a présence ou non d une erreur
- lors de l appel du WS Mocadi. Si valeur = 1 alors présence d une erre
- ur lors de l appel" tableName="pco001_opportunite_coml"/>
- </changeSet>
- </databaseChangeLog>
Editor
You can edit this paste and save as new: