Index: SQL/mysql/schema_13_down.sql
===================================================================
--- SQL/mysql/schema_13_down.sql	(revision 0)
+++ SQL/mysql/schema_13_down.sql	(revision 0)
@@ -0,0 +1,4 @@
+
+DROP TABLE IF EXISTS videos;
+
+DROP TABLE IF EXISTS images;
Index: SQL/mysql/schema_15_down.sql
===================================================================
--- SQL/mysql/schema_15_down.sql	(revision 0)
+++ SQL/mysql/schema_15_down.sql	(revision 0)
@@ -0,0 +1 @@
+-- empty placeholder to skip schema versions defined in 7.7/trunk
\ No newline at end of file
Index: SQL/mysql/schema_17_down.sql
===================================================================
Index: SQL/mysql/schema_14_up.sql
===================================================================
--- SQL/mysql/schema_14_up.sql	(revision 0)
+++ SQL/mysql/schema_14_up.sql	(revision 0)
@@ -0,0 +1,8 @@
+
+ALTER TABLE tracks ADD added_time int(10) unsigned default NULL;
+
+ALTER TABLE tracks ADD updated_time int(10) unsigned default NULL;
+
+ALTER TABLE images ADD updated_time int(10) unsigned default NULL;
+
+ALTER TABLE videos ADD updated_time int(10) unsigned default NULL;
Index: SQL/mysql/schema_16_up.sql
===================================================================
--- SQL/mysql/schema_16_up.sql	(revision 0)
+++ SQL/mysql/schema_16_up.sql	(revision 0)
@@ -0,0 +1 @@
+-- No change needed for MySQL
Index: SQL/mysql/schema_18_up.sql
===================================================================
--- SQL/mysql/schema_18_up.sql	(revision 0)
+++ SQL/mysql/schema_18_up.sql	(revision 0)
@@ -0,0 +1,3 @@
+ALTER TABLE tracks ADD dlna_profile varchar(32);
+ALTER TABLE tracks ADD hash char(8);
+CREATE INDEX trackHashIndex ON tracks (hash);
Index: SQL/mysql/schema_14_down.sql
===================================================================
--- SQL/mysql/schema_14_down.sql	(revision 0)
+++ SQL/mysql/schema_14_down.sql	(revision 0)
@@ -0,0 +1 @@
+-- empty placeholder to skip schema versions defined in 7.7/trunk
\ No newline at end of file
Index: SQL/mysql/schema_16_down.sql
===================================================================
Index: SQL/mysql/schema_18_down.sql
===================================================================
Index: SQL/mysql/schema_13_up.sql
===================================================================
--- SQL/mysql/schema_13_up.sql	(revision 0)
+++ SQL/mysql/schema_13_up.sql	(revision 0)
@@ -0,0 +1,46 @@
+
+DROP TABLE IF EXISTS videos;
+CREATE TABLE videos (
+  id int(10) unsigned NOT NULL auto_increment,
+  hash char(8) NOT NULL,
+  url text NOT NULL,
+  title blob,
+  titlesort text,
+  titlesearch text,
+  video_codec varchar(128),
+  audio_codec varchar(128),
+  mime_type varchar(32),
+  dlna_profile varchar(32),
+  width int(10) unsigned,
+  height int(10) unsigned,
+  mtime int(10) unsigned,
+  added_time int(10) unsigned,
+  filesize int(10) unsigned,
+  secs float unsigned,
+  bitrate float unsigned,
+  channels tinyint(1) unsigned,
+  PRIMARY KEY (id)
+) TYPE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+CREATE INDEX videoURLIndex ON videos (url(255));
+CREATE INDEX videoHashIndex ON videos (hash);
+
+DROP TABLE IF EXISTS images;
+CREATE TABLE images (
+  id int(10) unsigned NOT NULL auto_increment,
+  hash char(8) NOT NULL,
+  url text NOT NULL,
+  title blob,
+  titlesort text,
+  titlesearch text,
+  image_codec varchar(128),
+  mime_type varchar(32),
+  dlna_profile varchar(32),
+  width int(10) unsigned,
+  height int(10) unsigned,
+  mtime int(10) unsigned,
+  added_time int(10) unsigned,
+  filesize int(10) unsigned,
+  PRIMARY KEY (id)
+) TYPE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+CREATE INDEX imageURLIndex ON images (url(255));
+CREATE INDEX imageHashIndex ON images (hash);
Index: SQL/mysql/schema_15_up.sql
===================================================================
--- SQL/mysql/schema_15_up.sql	(revision 0)
+++ SQL/mysql/schema_15_up.sql	(revision 0)
@@ -0,0 +1,10 @@
+
+-- to be set to EXIF DateTimeOriginal or similar
+ALTER TABLE images ADD original_time int(10) unsigned NOT NULL DEFAULT 0;
+CREATE INDEX imageDateTimeOriginal ON images (original_time);
+
+ALTER TABLE images ADD orientation int(10) NOT NULL DEFAULT 0;
+
+ALTER TABLE images ADD album blob default NULL;
+
+ALTER TABLE videos ADD album blob default NULL;
Index: SQL/mysql/schema_17_up.sql
===================================================================
--- SQL/mysql/schema_17_up.sql	(revision 0)
+++ SQL/mysql/schema_17_up.sql	(revision 0)
@@ -0,0 +1 @@
+-- No change needed for MySQL