commit 94bf7a714ccd949f7c0f778f52c844bff1583d5c
from: jrmu <jrmu@ircnow.org>
via: Izzy Blacklock <izzyb@planetofnix.com>
date: Sat Jul 15 22:01:03 2023 UTC

Auto generate ISO dates, patch thanks to xfnw and IanJ

commit - 78870362ed9059e465207465ce56c4b6c1aa9f14
commit + 94bf7a714ccd949f7c0f778f52c844bff1583d5c
blob - 1b71f51716513895246584983f3f511ae6d299a2
blob + d12207032804071768ac0dd95ce20073505207f9
--- table.sql
+++ table.sql
@@ -7,7 +7,8 @@ CREATE TABLE bnc (
   username VARCHAR(32),
   email VARCHAR(100),
   password VARCHAR(100),
-  localtime VARCHAR(100),
+  localtime INTEGER DEFAULT (unixepoch()),
+  datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
   captcha INTEGER
 );
 CREATE TABLE shell (
@@ -19,7 +20,8 @@ CREATE TABLE shell (
   username VARCHAR(32),
   email VARCHAR(100),
   password VARCHAR(100),
-  localtime VARCHAR(100),
+  localtime INTEGER DEFAULT (unixepoch()),
+  datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
   captcha INTEGER
 );
 CREATE TABLE mail (
@@ -31,7 +33,8 @@ CREATE TABLE mail (
   username VARCHAR(32),
   email VARCHAR(100),
   password VARCHAR(100),
-  localtime VARCHAR(100),
+  localtime INTEGER DEFAULT (unixepoch()),
+  datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
   captcha INTEGER
 );
 CREATE TABLE www (
@@ -73,7 +76,8 @@ CREATE TABLE irc (
   identified INTEGER,
   ctcpversion VARCHAR(100),
   ctcptime VARCHAR(100),
-  localtime VARCHAR(100),
+  localtime INTEGER DEFAULT (unixepoch()),
+  datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
   oper INTEGER,
   idle INTEGER,
   ssl INTEGER,