[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[PATCH] Modified localtime fields to default current_timestamp.
[Thread Prev] | [Thread Next]
- Subject: [PATCH] Modified localtime fields to default current_timestamp.
- From: Ian Jones <ianj@xxxxxxxxxxxxx>
- Date: Sun, 16 Apr 2023 19:44:28 -0400
- To: codeforce@xxxxxxxxxx
- Cc: Ian Jones <ianj@xxxxxxxxxxxxx>
--- 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
Re: [PATCH] Modified localtime fields to default current_timestamp. | ircnow support <support@xxxxxxxxxxx> |