/usr/share/ratbox-services/lib/schema-sqlite.sql is in ratbox-services-sqlite 1.2.4-1ubuntu1.
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 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 | /* $Id: schema-sqlite.txt 23894 2007-05-01 17:24:07Z leeh $ */
CREATE TABLE nicks (
nickname TEXT,
username TEXT,
reg_time INTEGER,
last_time INTEGER,
flags INTEGER,
PRIMARY KEY(nickname)
);
CREATE TABLE users (
id INTEGER PRIMARY KEY,
username TEXT,
password TEXT,
email TEXT,
suspender TEXT,
suspend_reason TEXT,
suspend_time INTEGER DEFAULT '0',
reg_time INTEGER,
last_time INTEGER,
flags INTEGER,
verify_token TEXT,
language TEXT DEFAULT ''
);
CREATE UNIQUE INDEX users_username_unique ON users (username);
CREATE TABLE users_resetpass (
username TEXT,
token TEXT,
time INTEGER,
PRIMARY KEY(username)
);
CREATE TABLE users_resetemail (
username TEXT,
token TEXT,
email TEXT DEFAULT NULL,
time INTEGER,
PRIMARY KEY(username)
);
CREATE TABLE users_sync (
id INTEGER PRIMARY KEY,
hook TEXT,
data TEXT
);
CREATE TABLE channels (
chname TEXT,
topic TEXT,
url TEXT,
createmodes TEXT,
enforcemodes TEXT,
tsinfo INTEGER,
reg_time INTEGER,
last_time INTEGER,
flags INTEGER,
suspender TEXT,
suspend_reason TEXT,
suspend_time INTEGER DEFAULT '0',
PRIMARY KEY(chname)
);
CREATE TABLE channels_dropowner (
chname TEXT,
token TEXT,
time INTEGER,
PRIMARY KEY(chname)
);
CREATE TABLE members (
chname TEXT,
username TEXT,
lastmod TEXT,
level INTEGER,
flags INTEGER,
suspend INTEGER,
FOREIGN KEY(chname) REFERENCES channels (chname) MATCH FULL,
FOREIGN KEY(username) REFERENCES users (username) MATCH FULL
);
CREATE TABLE bans (
chname TEXT,
mask TEXT,
reason TEXT,
username TEXT,
level INTEGER,
hold INTEGER,
FOREIGN KEY(chname) REFERENCES channels (chname) MATCH FULL
);
CREATE TABLE operbot (
chname TEXT,
tsinfo INTEGER,
oper TEXT
);
CREATE TABLE operserv (
chname TEXT,
tsinfo INTEGER,
oper TEXT
);
CREATE TABLE jupes (
servername TEXT,
reason TEXT
);
CREATE TABLE operbans (
type TEXT,
mask TEXT,
reason TEXT,
operreason TEXT,
hold INTEGER,
create_time INTEGER,
oper TEXT,
remove INTEGER,
flags INTEGER
);
CREATE TABLE operbans_regexp (
id INTEGER PRIMARY KEY,
regex VARCHAR(255) NOT NULL,
reason TEXT NOT NULL,
hold INTEGER,
create_time INTEGER,
oper TEXT
);
CREATE TABLE operbans_regexp_neg (
id INTEGER PRIMARY KEY,
parent_id INTEGER NOT NULL,
regex TEXT NOT NULL,
oper TEXT NOT NULL
);
CREATE TABLE global_welcome (
id INTEGER,
text TEXT,
PRIMARY KEY(id)
);
CREATE TABLE email_banned_domain (
domain TEXT,
PRIMARY KEY(domain)
);
CREATE TABLE ignore_hosts (
hostname TEXT NOT NULL,
oper TEXT NOT NULL,
reason TEXT NOT NULL,
PRIMARY KEY(hostname)
);
CREATE TABLE memos (
id INTEGER PRIMARY KEY,
user_id INTEGER NOT NULL,
source_id INTEGER NOT NULL,
source TEXT NOT NULL,
timestamp INTEGER DEFAULT '0',
flags INTEGER,
text TEXT
);
|