Delimiter //
/**
 *  Table for Entries with forced match state
 */
Drop Procedure if exists LOADER_CREATE_TABLE_ENTRIES_FORCED_MATCH_STATE//

Create Procedure LOADER_CREATE_TABLE_ENTRIES_FORCED_MATCH_STATE()
Begin

#     DROP TABLE IF EXISTS LOADER_ENTRIES_ENTRIES_FORCED_MATCH_STATE;
    DROP TABLE IF EXISTS LOADER_ENTRIES_FORCED_MATCH_STATE;

    CREATE TABLE IF NOT EXISTS LOADER_ENTRIES_FORCED_MATCH_STATE (

        -- champs pour le traitements de l'import
        LOADER_STATUS_ID_LOADER_STATUS Int Not Null
		, LOADER_ENTRIES_ID_LOADER_ENTRIES Int Unsigned Not Null
        , DF_MATCH_STAT_ID_DF_MATCH_STAT int(10) unsigned NOT NULL
        , Index (LOADER_STATUS_ID_LOADER_STATUS)
		, Index (LOADER_ENTRIES_ID_LOADER_ENTRIES)

    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=0;

End//
Delimiter ;
CALL LOADER_CREATE_TABLE_ENTRIES_FORCED_MATCH_STATE();