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

[jrmu <jrmu@xxxxxxxxxx>]

Greetings,

That's interesting, can you send me the botnow_db_fixer.pl again? I may
have misplaced it. I'll download it and check it out.

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

On Sat, May 06, 2023 at 08:05:52AM +0100, Ian Jones wrote:
> Hi jrmu,
> 
> This isn't to be applied but for any new installations it will create
> the tables correctly.
> 
> The tool I wrote previously (botnow_db_fixer.pl) will correct the table 
> schema of an existing installation.
> 
> Regards,
> 
> Ian
> 
> On Fri, May 05, 2023 at 11:34:32PM -0700, jrmu wrote:
> > 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