- #set defaultduein to 1 for support queue
- cat <<EOF | /usr/bin/psql -U postgres -d $RT3_DB_NAME
-UPDATE queues SET defaultduein = 1 WHERE name='support'
-EOF
-
- #alter acl for Everyone be able to create new tickets in support list
- #Everyone (groups.id == 3) on support (queues.id == 1 (based on order in initialdata))
- cat <<EOF | /usr/bin/psql -U postgres -d $RT3_DB_NAME
-INSERT INTO acl (principaltype,principalid,rightname,objecttype,objectid,delegatedby,delegatedfrom) VALUES ('Group',3,'CreateTicket','RT::Queue',1,0,0);
-INSERT INTO acl (principaltype,principalid,rightname,objecttype,objectid,delegatedby,delegatedfrom) VALUES ('Group',3,'ReplyToTicket','RT::Queue',1,0,0);
-EOF
- #Everyone (groups.id == 3) on monitor ( queues.id == 2 (based on order in initaldata))
- cat <<EOF | /usr/bin/psql -U postgres -d $RT3_DB_NAME
-INSERT INTO acl (principaltype,principalid,rightname,objecttype,objectid,delegatedby,delegatedfrom) VALUES ('Group',3,'CreateTicket','RT::Queue',2,0,0);
-INSERT INTO acl (principaltype,principalid,rightname,objecttype,objectid,delegatedby,delegatedfrom) VALUES ('Group',3,'ReplyToTicket','RT::Queue',2,0,0);
-EOF