1 DROP TABLE IF EXISTS adminlog;
2 DROP TYPE IF EXISTS "admin_log";
3 CREATE TYPE "admin_log" AS ENUM ('motionmasking', 'proxygranted', 'proxyrevoked', 'proxyrevokedall');
4 CREATE TABLE adminlog (id serial NOT NULL,
5 user_id INTEGER NOT NULL,
6 action admin_log NOT NULL,
8 action_user_id INTEGER NOT NULL,
9 actiontime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,