diff options
Diffstat (limited to 'inc/db.php')
-rw-r--r-- | inc/db.php | 6 |
1 files changed, 2 insertions, 4 deletions
@@ -10,15 +10,13 @@ | |||
10 | 10 | ||
11 | class db { | 11 | class db { |
12 | var $handle; | 12 | var $handle; |
13 | function __construct($path) | 13 | function __construct($path) { |
14 | { | ||
15 | $this->handle = new PDO($path); | 14 | $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->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)'); |
17 | $this->handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | 16 | $this->handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
18 | } | 17 | } |
19 | 18 | ||
20 | public function getHandle() | 19 | public function getHandle() { |
21 | { | ||
22 | return $this->handle; | 20 | return $this->handle; |
23 | } | 21 | } |
24 | } \ No newline at end of file | 22 | } \ No newline at end of file |