Delimiter //
/**
 *  Table for import of ACCOUNTS
 */
Drop Procedure if exists LOADER_CREATE_TABLE_CONTACTS_ACCOUNTS//

Create Procedure LOADER_CREATE_TABLE_CONTACTS_ACCOUNTS()
Begin

    Drop Table If Exists LOADER_CONTACTS_ACCOUNTS;
    Create Table LOADER_CONTACTS_ACCOUNTS (

        -- champs pour le traitements de l'import
        LOADER_STATUS_ID_LOADER_STATUS Int Not Null,
        ID_LOADER_CONTACTS_ACCOUNTS int(10) unsigned Not Null Auto_Increment,
		LOADER_CONTACTS_ID_LOADER_CONTACTS Int Unsigned Null,
		LOADER_ACCOUNTS_ID_LOADER_ACCOUNTS Int Unsigned Null,
        ACCOUNTS_ID_ACCOUNTS int(10) unsigned  Null ,
        ACCOUNTS_ID_ACCOUNTS_NEW int(10) unsigned  Null ,

        -- contraintes et indexes
        Primary Key (ID_LOADER_CONTACTS_ACCOUNTS)
        , Index (LOADER_STATUS_ID_LOADER_STATUS)
        , Index (ACCOUNTS_ID_ACCOUNTS)
        , Index (ACCOUNTS_ID_ACCOUNTS_NEW)
        , Index (LOADER_CONTACTS_ID_LOADER_CONTACTS)
        , Index (LOADER_ACCOUNTS_ID_LOADER_ACCOUNTS)

    ) ENGINE = InnoDB AUTO_INCREMENT = 0 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
End//
Delimiter ;
Call LOADER_CREATE_TABLE_CONTACTS_ACCOUNTS();