diff options
author | Andrew Dolgov <[email protected]> | 2015-06-17 19:46:52 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2015-06-17 19:46:52 +0300 |
commit | 61c9ce6ae7dcaeb659b1a3017ce9027e0045451c (patch) | |
tree | c2e6b9a31263cc16cb15e49ca86c383d0219a0a7 | |
parent | d62a5e0cb267a05ebf8c5a645fe49a4a574c80b0 (diff) |
bayes: remote unused content field for references schema
-rw-r--r-- | plugins/af_sort_bayes/init.php | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/plugins/af_sort_bayes/init.php b/plugins/af_sort_bayes/init.php index bf8a1e593..5daaca6dc 100644 --- a/plugins/af_sort_bayes/init.php +++ b/plugins/af_sort_bayes/init.php @@ -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 '', |