Maintenance update for automake and PHP.

[gnucomo.git] / src / database / create.sql

diff --git a/src/database/create.sql b/src/database/create.sql
index 5d6cab9..e89b7ed 100644 (file)
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -246,6 +246,8 @@ CREATE TABLE log_abuse
         source     inet
 );
 
+CREATE INDEX log_ab_src ON log_abuse (source, objectid);
+CREATE UNIQUE INDEX log_ab_log ON log_abuse (logid);
 --
 --
 
@@ -857,6 +859,8 @@ GRANT UPDATE ON notification_notificationid_seq TO GROUP daemon;
 GRANT SELECT ON notification_notificationid_seq TO GROUP daemon;
 GRANT INSERT ON property TO GROUP daemon;
 GRANT UPDATE ON property TO GROUP daemon;
+GRANT INSERT ON property TO GROUP admin;
+GRANT UPDATE ON property TO GROUP admin;
 GRANT INSERT ON history TO GROUP daemon;
 GRANT INSERT ON parameter_class TO GROUP admin;
 GRANT UPDATE ON parameter_class TO GROUP admin;