/usr/lib/gozerbot/main.db.sqlite3.dump is in gozerbot 0.99.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 | PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE user (
name VARCHAR(255) NOT NULL,
PRIMARY KEY (name)
);
CREATE TABLE perms (
name VARCHAR(255) NOT NULL,
perm VARCHAR(255) NOT NULL,
FOREIGN KEY(name) REFERENCES user (name)
);
INSERT INTO "perms" VALUES('owner','USER');
INSERT INTO "perms" VALUES('owner','OPER');
CREATE TABLE userhosts (
userhost VARCHAR(255) NOT NULL,
name VARCHAR(255) NOT NULL,
PRIMARY KEY (userhost),
FOREIGN KEY(name) REFERENCES user (name)
);
CREATE TABLE permits (
name VARCHAR(255) NOT NULL,
permit VARCHAR(255) NOT NULL,
FOREIGN KEY(name) REFERENCES user (name)
);
CREATE TABLE passwords (
name VARCHAR(255) NOT NULL,
passwd VARCHAR(255) NOT NULL,
PRIMARY KEY (name),
FOREIGN KEY(name) REFERENCES user (name)
);
CREATE TABLE statuses (
name VARCHAR(255) NOT NULL,
status VARCHAR(255) NOT NULL,
FOREIGN KEY(name) REFERENCES user (name)
);
CREATE TABLE email (
name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
"order" INTEGER NOT NULL,
FOREIGN KEY(name) REFERENCES user (name)
);
CREATE TABLE whokarma (
item VARCHAR(255) NOT NULL,
nick VARCHAR(255) NOT NULL,
updown VARCHAR(10) NOT NULL
);
CREATE TABLE karma (
item VARCHAR(255) NOT NULL,
value INTEGER NOT NULL,
PRIMARY KEY (item)
);
CREATE TABLE whykarma (
item VARCHAR(255) NOT NULL,
updown VARCHAR(10) NOT NULL,
why TEXT NOT NULL
);
CREATE TABLE quotes (
indx INTEGER NOT NULL,
quote TEXT NOT NULL,
userhost VARCHAR(255) NOT NULL,
createtime DATETIME NOT NULL,
nick VARCHAR(255) NOT NULL,
PRIMARY KEY (indx),
FOREIGN KEY(userhost) REFERENCES userhosts (userhost)
);
CREATE TABLE todo (
indx INTEGER NOT NULL,
name VARCHAR(255) NOT NULL,
time DATETIME,
duration INTEGER,
warnsec INTEGER,
descr TEXT NOT NULL,
priority INTEGER,
PRIMARY KEY (indx)
);
CREATE TABLE birthday (
name VARCHAR(255) NOT NULL,
birthday VARCHAR(255) NOT NULL,
PRIMARY KEY (name)
);
CREATE TABLE infoitems (
indx INTEGER NOT NULL,
item VARCHAR(255) NOT NULL,
description TEXT NOT NULL,
userhost VARCHAR(255) NOT NULL,
time DATETIME NOT NULL,
PRIMARY KEY (indx),
FOREIGN KEY(userhost) REFERENCES userhosts (userhost)
);
CREATE TABLE list (
indx INTEGER NOT NULL,
username VARCHAR(255) NOT NULL,
listname VARCHAR(255) NOT NULL,
item TEXT NOT NULL,
PRIMARY KEY (indx)
);
COMMIT;
|