aboutsummaryrefslogtreecommitdiffhomepage
path: root/inc/db.php
diff options
context:
space:
mode:
Diffstat (limited to 'inc/db.php')
-rw-r--r--inc/db.php7
1 files changed, 5 insertions, 2 deletions
diff --git a/inc/db.php b/inc/db.php
index 705fc0c4..a1674ea7 100644
--- a/inc/db.php
+++ b/inc/db.php
@@ -10,12 +10,15 @@
10 10
11class db { 11class db {
12 var $handle; 12 var $handle;
13 function __construct($path) { 13 function __construct($path)
14 {
14 $this->handle = new PDO($path); 15 $this->handle = new PDO($path);
16 $this->handle->exec('CREATE TABLE IF NOT EXISTS "entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE , "title" VARCHAR, "url" VARCHAR UNIQUE , "is_read" INTEGER DEFAULT 0, "is_fav" INTEGER DEFAULT 0, "content" BLOB)');
15 $this->handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 17 $this->handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 } 18 }
17 19
18 public function getHandle() { 20 public function getHandle()
21 {
19 return $this->handle; 22 return $this->handle;
20 } 23 }
21} \ No newline at end of file 24} \ No newline at end of file