media_files table

upgrade-00.sql

/* Not creating a fk between spl_number and ct.num
   as we may use pg_logical to replicate this table
   to the PG DB on www. If we don't it will be trivial
   to add one later.
   Also not adding a unique key between md5 as there are
   about 2,100 duplicates at the moment.
*/
create table media_files(
    spl_number varchar(9)  not null,
    pathpart   varchar(64) not null,
    md5        varchar(32) not null,
    dimensions varchar(11) not null,
    mtime      int  not null,
    unique(spl_number, pathpart)
);