CREATE TABLE movies (code INTEGER PRIMARY KEY UNIQUE, 
title VARCHAR, 
original_title VARCHAR, 
year INTEGER, 
description VARCHAR, 
comment VARCHAR, 
duration INTEGER DEFAULT '0', 
imdb_code VARCHAR, 
date_add VARCHAR, 
date_update VARCHAR, 
date_last_show VARCHAR, 
in_collection INTEGER DEFAULT '0', 
media_type INTEGER, 
media_format INTEGER, 
rating INTEGER DEFAULT '0', 
video_standard INTEGER, 
screen_ratio INTEGER, 
resolution INTEGER, 
imdb_rating INTEGER, 
seen INTEGER DEFAULT '0', 
wanted INTEGER DEFAULT '0', 
for_sale INTEGER DEFAULT '0', 
filename INTEGER, 
mpaa INTEGER, 
mpaa_rating INTEGER, 
disc_nom INTEGER, 
salary INTEGER, 
custom1 INTEGER, 
custom2 INTEGER, 
custom3 INTEGER, 
custom4 INTEGER, 
checked INTEGER DEFAULT '0', 
date_seen INTEGER, 
filesize INTEGER, 
video_bitrate INTEGER, 
video_codec INTEGER, 
awards INTEGER, 
disc_label INTEGER, 
movie_number INTEGER, 
title_sort VARCHAR COLLATE UnicodeCollation, 
original_language VARCHAR, 
tomes_count INTEGER,
recording_period VARCHAR, 
label INTEGER,
user_field1 VARCHAR, 
user_filed2 VARCHAR);

CREATE INDEX ind_movies_title on movies (title);
CREATE INDEX ind_movies_filename ON movies (filename);
CREATE INDEX ind_movies_title_sort ON movies (title_sort);
CREATE INDEX ind_movies_in_collection on movies (in_collection);
CREATE INDEX ind_movies_in_collection_title on movies (in_collection, title);
CREATE INDEX ind_movies_in_collection_title_sort on movies (in_collection, title_sort);