From 5170adf992ba84fcced8bc271e603d1440f29509 Mon Sep 17 00:00:00 2001 From: Rafael Bodill Date: Fri, 19 Sep 2014 16:06:47 +0300 Subject: apikeys.created should be timestamp with default now() --- application/migrations/009_add_apikeys.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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") ); -- cgit v1.2.3-24-g4f1b