Blame
Date:
Sun Oct 8 22:28:02 2023 UTC
Message:
Now prevents creating accounts that exist in database with a password
001
2021-12-17
jrmu
CREATE TABLE bnc (
002
2021-12-17
jrmu
id INTEGER PRIMARY KEY,
003
2021-12-17
jrmu
hashid VARCHAR(100),
004
2021-12-17
jrmu
ircid INTEGER,
005
2021-12-17
jrmu
wwwid INTEGER,
006
2021-12-17
jrmu
smtpid INTEGER,
007
2021-12-17
jrmu
username VARCHAR(32),
008
2021-12-17
jrmu
email VARCHAR(100),
009
2021-12-17
jrmu
password VARCHAR(100),
010
2023-06-22
jrmu
localtime INTEGER DEFAULT (unixepoch()),
011
2023-06-22
jrmu
datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
012
2021-12-17
jrmu
captcha INTEGER
013
2021-12-17
jrmu
);
014
2021-12-17
jrmu
CREATE TABLE shell (
015
2021-12-17
jrmu
id INTEGER PRIMARY KEY,
016
2021-12-17
jrmu
hashid VARCHAR(100),
017
2021-12-17
jrmu
ircid INTEGER,
018
2021-12-17
jrmu
wwwid INTEGER,
019
2021-12-17
jrmu
smtpid INTEGER,
020
2021-12-17
jrmu
username VARCHAR(32),
021
2021-12-17
jrmu
email VARCHAR(100),
022
2021-12-17
jrmu
password VARCHAR(100),
023
2023-06-22
jrmu
localtime INTEGER DEFAULT (unixepoch()),
024
2023-06-22
jrmu
datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
025
2021-12-17
jrmu
captcha INTEGER
026
2021-12-17
jrmu
);
027
2023-03-05
jrmu
CREATE TABLE mail (
028
2023-03-05
jrmu
id INTEGER PRIMARY KEY,
029
2023-03-05
jrmu
hashid VARCHAR(100),
030
2023-03-05
jrmu
ircid INTEGER,
031
2023-03-05
jrmu
wwwid INTEGER,
032
2023-03-05
jrmu
smtpid INTEGER,
033
2023-03-05
jrmu
username VARCHAR(32),
034
2023-03-05
jrmu
email VARCHAR(100),
035
2023-03-05
jrmu
password VARCHAR(100),
036
2023-06-22
jrmu
localtime INTEGER DEFAULT (unixepoch()),
037
2023-06-22
jrmu
datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
038
2023-03-05
jrmu
captcha INTEGER
039
2023-03-05
jrmu
);
040
2023-07-29
jrmu
CREATE TABLE vpn (
041
2023-07-29
jrmu
id INTEGER PRIMARY KEY,
042
2023-07-29
jrmu
hashid VARCHAR(100),
043
2023-07-29
jrmu
ircid INTEGER,
044
2023-07-29
jrmu
wwwid INTEGER,
045
2023-07-29
jrmu
smtpid INTEGER,
046
2023-07-29
jrmu
username VARCHAR(32),
047
2023-07-29
jrmu
email VARCHAR(100),
048
2023-07-29
jrmu
password VARCHAR(100),
049
2023-07-29
jrmu
localtime INTEGER DEFAULT (unixepoch()),
050
2023-07-29
jrmu
datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
051
2023-07-29
jrmu
captcha INTEGER
052
2023-07-29
jrmu
);
053
2021-12-17
jrmu
CREATE TABLE www (
054
2021-12-17
jrmu
id INTEGER PRIMARY KEY,
055
2021-12-17
jrmu
hashid VARCHAR(100),
056
2021-12-17
jrmu
hashirc VARCHAR(100),
057
2021-12-17
jrmu
hashbnc VARCHAR(100),
058
2021-12-17
jrmu
hashshell VARCHAR(100),
059
2021-12-17
jrmu
hashsmtp VARCHAR(100),
060
2021-12-17
jrmu
cookie VARCHAR(1024),
061
2021-12-17
jrmu
passphrase VARCHAR(100),
062
2021-12-17
jrmu
remoteaddr VARCHAR(50),
063
2021-12-17
jrmu
httpxforwarded VARCHAR(100),
064
2021-12-17
jrmu
time VARCHAR(100),
065
2021-12-17
jrmu
useragent VARCHAR(200),
066
2021-12-17
jrmu
upgradeinsecure INTEGER,
067
2021-12-17
jrmu
host VARCHAR(100),
068
2021-12-17
jrmu
dnt INTEGER,
069
2021-12-17
jrmu
connection VARCHAR(100),
070
2021-12-17
jrmu
cachecontrol VARCHAR(100),
071
2021-12-17
jrmu
acceptlanguage VARCHAR(100),
072
2021-12-17
jrmu
acceptencoding VARCHAR(100),
073
2021-12-17
jrmu
accept VARCHAR(200),
074
2021-12-17
jrmu
jstime VARCHAR(100),
075
2021-12-17
jrmu
timezoneoffset VARCHAR(100),
076
2021-12-17
jrmu
timezone VARCHAR(100),
077
2021-12-17
jrmu
screenwidth INTEGER,
078
2021-12-17
jrmu
screenheight INTEGER,
079
2021-12-17
jrmu
colordepth INTEGER
080
2021-12-17
jrmu
);
081
2021-12-17
jrmu
CREATE TABLE irc (
082
2021-12-17
jrmu
id INTEGER PRIMARY KEY,
083
2021-12-17
jrmu
hashid VARCHAR(100),
084
2021-12-17
jrmu
hostmask VARCHAR(100),
085
2021-12-17
jrmu
nick VARCHAR(32),
086
2021-12-17
jrmu
realname VARCHAR(100),
087
2021-12-17
jrmu
ip VARCHAR(50),
088
2021-12-17
jrmu
server VARCHAR(100),
089
2021-12-17
jrmu
identified INTEGER,
090
2021-12-17
jrmu
ctcpversion VARCHAR(100),
091
2021-12-17
jrmu
ctcptime VARCHAR(100),
092
2023-06-22
jrmu
localtime INTEGER DEFAULT (unixepoch()),
093
2023-06-22
jrmu
datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
094
2021-12-17
jrmu
oper INTEGER,
095
2021-12-17
jrmu
idle INTEGER,
096
2021-12-17
jrmu
ssl INTEGER,
097
2021-12-17
jrmu
epochtime INTEGER,
098
2021-12-17
jrmu
chans VARCHAR(200),
099
2021-12-17
jrmu
date VARCHAR(100)
100
2021-12-17
jrmu
);
101
2021-12-17
jrmu
CREATE TABLE smtp (
102
2021-12-17
jrmu
id INTEGER PRIMARY KEY,
103
2021-12-17
jrmu
hashid VARCHAR(100),
104
2021-12-17
jrmu
sentfrom VARCHAR(100),
105
2021-12-17
jrmu
returnpath VARCHAR(100),
106
2021-12-17
jrmu
deliveredto VARCHAR(100),
107
2021-12-17
jrmu
received VARCHAR(1000),
108
2021-12-17
jrmu
dkim VARCHAR(1000),
109
2021-12-17
jrmu
date VARCHAR(100),
110
2021-12-17
jrmu
other VARCHAR(5000),
111
2021-12-17
jrmu
content VARCHAR(100),
112
2021-12-17
jrmu
mime VARCHAR(100),
113
2021-12-17
jrmu
subject VARCHAR(100)
114
2021-12-17
jrmu
);
IRCNow