This file is indexed.

/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
);