summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRafael Bodill <rafi@sortex.co.il>2014-09-19 15:06:47 +0200
committerRafael Bodill <rafi@sortex.co.il>2014-09-19 15:06:47 +0200
commit5170adf992ba84fcced8bc271e603d1440f29509 (patch)
tree057f51eb9a4842b32d8bfeb79ce420052f71ba6a
parentb8fa66e0d874bc5aa6ee719f6067b5365661833a (diff)
apikeys.created should be timestamp with default now()
-rw-r--r--application/migrations/009_add_apikeys.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/application/migrations/009_add_apikeys.php b/application/migrations/009_add_apikeys.php
index bdc4dd07d..8f2882e49 100644
--- a/application/migrations/009_add_apikeys.php
+++ b/application/migrations/009_add_apikeys.php
@@ -10,7 +10,7 @@ class Migration_Add_apikeys extends CI_Migration {
CREATE TABLE "apikeys" (
"key" varchar(64) NOT NULL,
"user" integer NOT NULL,
- "created" integer NOT NULL,
+ "created" timestamp WITH TIME ZONE NOT NULL DEFAULT NOW(),
"comment" varchar(255) NOT NULL,
PRIMARY KEY ("key")
);