[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[PATCH] Modified localtime fields to default current_timestamp.


---
 table.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/table.sql b/table.sql
index 1b71f51..d9fb362 100644
--- a/table.sql
+++ b/table.sql
@@ -7,7 +7,7 @@ CREATE TABLE bnc (
   username VARCHAR(32),
   email VARCHAR(100),
   password VARCHAR(100),
-  localtime VARCHAR(100),
+  localtime default current_timestamp,
   captcha INTEGER
 );
 CREATE TABLE shell (
@@ -19,7 +19,7 @@ CREATE TABLE shell (
   username VARCHAR(32),
   email VARCHAR(100),
   password VARCHAR(100),
-  localtime VARCHAR(100),
+  localtime default current_timestamp,
   captcha INTEGER
 );
 CREATE TABLE mail (
@@ -31,7 +31,7 @@ CREATE TABLE mail (
   username VARCHAR(32),
   email VARCHAR(100),
   password VARCHAR(100),
-  localtime VARCHAR(100),
+  localtime default current_timestamp,
   captcha INTEGER
 );
 CREATE TABLE www (
@@ -73,7 +73,7 @@ CREATE TABLE irc (
   identified INTEGER,
   ctcpversion VARCHAR(100),
   ctcptime VARCHAR(100),
-  localtime VARCHAR(100),
+  localtime default current_timestamp,
   oper INTEGER,
   idle INTEGER,
   ssl INTEGER,
-- 
2.37.3


Follow-Ups:
Re: [PATCH] Modified localtime fields to default current_timestamp.ircnow support <support@xxxxxxxxxxx>