blob: 5fa498b150e82f54161e7c6758cc6b85f4fd25bb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
CREATE TABLE plugin_manager (
id serial NOT NULL,
user_id integer NOT NULL
REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
conf text NOT NULL,
value text,
type text,
PRIMARY KEY (id)
);
CREATE INDEX ix_plugin_manager_user_id ON users (user_id);
CREATE TABLE IF NOT EXISTS "system" (
name varchar(64) NOT NULL PRIMARY KEY,
value text
);
INSERT INTO "system" (name, value) VALUES ('myrc_plugin_manager', 'initial');
|