]> git.wh0rd.org - tt-rss.git/commitdiff
bayes: remote unused content field for references schema
authorAndrew Dolgov <noreply@fakecake.org>
Wed, 17 Jun 2015 16:46:52 +0000 (19:46 +0300)
committerAndrew Dolgov <noreply@fakecake.org>
Wed, 17 Jun 2015 16:46:52 +0000 (19:46 +0300)
plugins/af_sort_bayes/init.php

index bf8a1e5939fe2da682eaad303d09d99cd4c644db..5daaca6dc7e9a33788a9a6793eac76e763b2a6d6 100644 (file)
@@ -154,8 +154,7 @@ class Af_Sort_Bayes extends Plugin {
                                category_id INTEGER NOT NULL,
                                FOREIGN KEY (category_id) REFERENCES ${prefix}_categories(id) ON DELETE CASCADE,
                                owner_uid INTEGER NOT NULL,
-                               FOREIGN KEY (owner_uid) REFERENCES ttrss_users(id) ON DELETE CASCADE,
-                               content text NOT NULL) ENGINE=InnoDB");
+                               FOREIGN KEY (owner_uid) REFERENCES ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB");
 
                        $this->dbh->query("CREATE TABLE IF NOT EXISTS ${prefix}_wordfreqs (
                                word varchar(100) NOT NULL DEFAULT '',
@@ -178,8 +177,7 @@ class Af_Sort_Bayes extends Plugin {
                                id SERIAL NOT NULL PRIMARY KEY,
                                document_id VARCHAR(255) NOT NULL,
                                category_id INTEGER NOT NULL REFERENCES ${prefix}_categories(id) ON DELETE CASCADE,
-                               owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE,
-                               content text NOT NULL)");
+                               owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE)");
 
                        $this->dbh->query("CREATE TABLE IF NOT EXISTS ${prefix}_wordfreqs (
                                word varchar(100) NOT NULL DEFAULT '',