workaround against ttrss_enclosures mysql data being wrong (nukes the enclosures...

diff --git a/sanity_check.php b/sanity_check.php
index 51dc1b5f8f006d2835c2c0d940bf740ff0f8f1be..ab4e29b3aa21647a2be4f57bebb3c6d90363c9a6 100644 (file)
--- a/sanity_check.php
+++ b/sanity_check.php
@@ -2,7 +2,7 @@
        require_once "functions.php";
 
        define('EXPECTED_CONFIG_VERSION', 18);
-       define('SCHEMA_VERSION', 55);
+       define('SCHEMA_VERSION', 56);
 
        if (!file_exists("config.php")) {
                print "<b>Fatal Error</b>: You forgot to copy 

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index abeb30eca178bd7161ba85f6aa72a1ecb305a0f3..ba9e8d431b71bf7d9e2d0d76515fd0043f118ee3 100644 (file)
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -225,7 +225,7 @@ create table ttrss_tags (id integer primary key auto_increment,
 
 create table ttrss_version (schema_version int not null) TYPE=InnoDB;
 
-insert into ttrss_version values (55);
+insert into ttrss_version values (56);
 
 create table ttrss_enclosures (id serial not null primary key,
        content_url text not null,

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 57d2e95d173403621e4c3ebec8a4017e44f18a5d..830b8da6a6e5727b7b6c95650cc863d6687238cb 100644 (file)
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -201,7 +201,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid);
 
 create table ttrss_version (schema_version int not null);
 
-insert into ttrss_version values (55);
+insert into ttrss_version values (56);
 
 create table ttrss_enclosures (id serial not null primary key,
        content_url text not null,

diff --git a/schema/versions/mysql/56.sql b/schema/versions/mysql/56.sql
new file mode 100644 (file)
index 0000000..af2fb82
--- /dev/null
+++ b/schema/versions/mysql/56.sql
@@ -0,0 +1,16 @@
+begin;
+
+drop table ttrss_enclosures;
+
+create table ttrss_enclosures (id serial not null primary key,
+       content_url text not null,
+       content_type varchar(250) not null,
+       post_id integer not null,
+       title text not null,
+       duration text not null,
+       index (post_id),
+       foreign key (post_id) references ttrss_entries(id) ON DELETE cascade) TYPE=InnoDB;
+
+update ttrss_version set schema_version = 56;
+
+commit;

diff --git a/schema/versions/pgsql/56.sql b/schema/versions/pgsql/56.sql
new file mode 100644 (file)
index 0000000..d6d57f0
--- /dev/null
+++ b/schema/versions/pgsql/56.sql
@@ -0,0 +1,5 @@
+begin;
+
+update ttrss_version set schema_version = 56;
+
+commit;