1. create table file_to_migrate (
2.        item_uuid VARCHAR2(100) not null,
3.        version number(10) not null,
4.        thread_id number(10),
5.        error_details VARCHAR2(1000),
6.        u_error_details VARCHAR2(1000),
7.        filepath      VARCHAR2(500) NOT NULL,
8.        enc_filepath  VARCHAR2(500) NULL,
9.        filesize NUMBER(38) default 0 NOT NULL,
10.        checksum VARCHAR2(1000),
11.        c_status number(1) default 0,
12.        status number(1) default 0, --0 for unmigrated, 1 for in progress, 2 for completed, -1 for error
13.        u_status number(1) default 0, --0 for unmigrated, 1 for in progress, 2 for completed, -1 for error
14.        src_collection_id VARCHAR2(100),
15.        collection_id VARCHAR2(100),
16.        school_reference number(1) default -1 -- -1 for dontcare, 0 for false, 1 for true
17. );