diff options
Diffstat (limited to 'inc/poche/Database.class.php')
-rwxr-xr-x | inc/poche/Database.class.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/inc/poche/Database.class.php b/inc/poche/Database.class.php index a80eea97..d1044a6e 100755 --- a/inc/poche/Database.class.php +++ b/inc/poche/Database.class.php | |||
@@ -77,7 +77,7 @@ class Database { | |||
77 | } | 77 | } |
78 | else { | 78 | else { |
79 | $sql = ' | 79 | $sql = ' |
80 | CREATE TABLE tags ( | 80 | CREATE TABLE IF NOT EXISTS tags ( |
81 | id bigserial primary key, | 81 | id bigserial primary key, |
82 | value varchar(255) NOT NULL | 82 | value varchar(255) NOT NULL |
83 | ); | 83 | ); |
@@ -110,7 +110,7 @@ class Database { | |||
110 | } | 110 | } |
111 | else { | 111 | else { |
112 | $sql = ' | 112 | $sql = ' |
113 | CREATE TABLE tags_entries ( | 113 | CREATE TABLE IF NOT EXISTS tags_entries ( |
114 | id bigserial primary key, | 114 | id bigserial primary key, |
115 | entry_id integer NOT NULL, | 115 | entry_id integer NOT NULL, |
116 | tag_id integer NOT NULL | 116 | tag_id integer NOT NULL |
@@ -407,7 +407,7 @@ class Database { | |||
407 | public function getLastId($column = '') { | 407 | public function getLastId($column = '') { |
408 | return $this->getHandle()->lastInsertId($column); | 408 | return $this->getHandle()->lastInsertId($column); |
409 | } | 409 | } |
410 | 410 | ||
411 | public function search($term, $user_id, $limit = '') { | 411 | public function search($term, $user_id, $limit = '') { |
412 | $search = '%'.$term.'%'; | 412 | $search = '%'.$term.'%'; |
413 | $sql_action = "SELECT * FROM entries WHERE user_id=? AND (content LIKE ? OR title LIKE ? OR url LIKE ?) "; //searches in content, title and URL | 413 | $sql_action = "SELECT * FROM entries WHERE user_id=? AND (content LIKE ? OR title LIKE ? OR url LIKE ?) "; //searches in content, title and URL |