Re: [PATCH] Modified localtime fields to default current_timestamp.

[jrmu <jrmu@xxxxxxxxxx>]

I would apply this but would this cause compatibility issues with older
botnow installations? I suspect it would not, since the table should
only get created once. If it already exists, the old schema should
remain intact. But if you can confirm, that would be best.

-- 
jrmu
IRCNow (https://ircnow.org)

On Sun, Apr 16, 2023 at 07:44:28PM -0400, Ian Jones wrote:
> ---
>  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
> 
>

Attachment: signature.asc
Description: PGP signature