-- DBA create the database and give access permissions.
--
-- $Log: create.sql,v $
--- Revision 1.14 2003-07-09 07:14:59 arjen
+-- Revision 1.16 2003-08-16 14:29:02 arjen
+-- Fixed a few typos.
+--
+-- Revision 1.15 2003/08/05 07:43:24 arjen
+-- Added index to the history table.
+--
+-- Revision 1.14 2003/07/09 07:14:59 arjen
-- New database tables: notification_check, notification_check_buffer,
-- notification_check_line and object_statistics.
--
);
+CREATE INDEX history_pid_mod ON history(paramid, modified);
+
--
--
checkid BIGINT,
sortorder INTEGER,
last_logid BIGINT default 0,
- historicboundary INTERVAL default 0,
+ historicboundary INTERVAL default '0',
use_logid BOOLEAN default false,
sql_query TEXT
);
GRANT INSERT ON action_user TO GROUP ops, GROUP admin;
GRANT UPDATE ON notification TO GROUP ops, GROUP admin;
-GRANT INSERT ON object GROUP admin;
+GRANT INSERT ON object TO GROUP admin;
GRANT UPDATE ON object TO GROUP ops, GROUP admin;
-GRANT DELETE ON object GROUP admin;
+GRANT DELETE ON object TO GROUP admin;
GRANT UPDATE ON usr TO GROUP view, GROUP ops, GROUP admin;
GRANT INSERT ON usr TO GROUP admin;
GRANT DELETE ON usr TO GROUP admin;