/*C99*/SET SCHEMA PUBLIC
DISCONNECT
/*C100*/SET SCHEMA PUBLIC
INSERT INTO OFGROUP VALUES('Test Group A','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.groupList','')
COMMIT
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.showInRoster'
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group A'
COMMIT
INSERT INTO OFGROUP VALUES('Test Group A','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.groupList','')
COMMIT
/*C101*/SET SCHEMA PUBLIC
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.showInRoster'
COMMIT
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group A'
COMMIT
DISCONNECT
/*C100*/DISCONNECT
/*C102*/SET SCHEMA PUBLIC
INSERT INTO OFGROUP VALUES('test','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('test','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('test','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('test','sharedRoster.groupList','')
COMMIT
/*C103*/SET SCHEMA PUBLIC
DELETE FROM OFGROUPPROP WHERE GROUPNAME='test' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='test' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='test' AND NAME='sharedRoster.showInRoster'
COMMIT
DELETE FROM OFGROUP WHERE GROUPNAME='test'
COMMIT
DISCONNECT
/*C102*/DISCONNECT
/*C104*/SET SCHEMA PUBLIC
INSERT INTO OFGROUP VALUES('Test Group A','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.groupList','')
COMMIT
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.showInRoster'
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.showInRoster','everybody')
COMMIT
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.displayName'
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.displayName','Users in group A')
COMMIT
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.groupList'
COMMIT
INSERT INTO OFGROUP VALUES('Test Group B','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group B','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group B','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group B','sharedRoster.groupList','')
COMMIT
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.showInRoster'
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group A'
COMMIT
/*C105*/SET SCHEMA PUBLIC
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group B' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group B' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group B' AND NAME='sharedRoster.showInRoster'
COMMIT
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group B'
COMMIT
DISCONNECT
/*C104*/DISCONNECT
/*C106*/SET SCHEMA PUBLIC
INSERT INTO OFGROUP VALUES('Test Group','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group','sharedRoster.groupList','')
COMMIT
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group'
INSERT INTO OFGROUP VALUES('Test Group','This is test group.')
COMMIT
INSERT INTO OFGROUPUSER VALUES('Test Group','john@example.org',0)
COMMIT
INSERT INTO OFGROUPUSER VALUES('Test Group','jack@example.org',0)
COMMIT
INSERT INTO OFGROUPUSER VALUES('Test Group','jane@example.org',1)
COMMIT
/*C107*/SET SCHEMA PUBLIC
DELETE FROM OFGROUPUSER WHERE GROUPNAME='Test Group' AND USERNAME='jack@example.org' AND ADMINISTRATOR=0
DELETE FROM OFGROUPUSER WHERE GROUPNAME='Test Group' AND USERNAME='jane@example.org' AND ADMINISTRATOR=1
DELETE FROM OFGROUPUSER WHERE GROUPNAME='Test Group' AND USERNAME='john@example.org' AND ADMINISTRATOR=0
COMMIT
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group' AND NAME='sharedRoster.showInRoster'
COMMIT
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group'
COMMIT
DISCONNECT
/*C106*/DISCONNECT
/*C108*/SET SCHEMA PUBLIC
INSERT INTO OFGROUP VALUES('Test Group','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group','sharedRoster.groupList','')
COMMIT
/*C109*/SET SCHEMA PUBLIC
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group' AND NAME='sharedRoster.showInRoster'
COMMIT
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group'
COMMIT
DISCONNECT
/*C108*/DISCONNECT
/*C110*/SET SCHEMA PUBLIC
INSERT INTO OFGROUP VALUES('Test Group A','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.groupList','')
COMMIT
/*C111*/SET SCHEMA PUBLIC
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.showInRoster'
COMMIT
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group A'
COMMIT
DISCONNECT
/*C110*/DISCONNECT
/*C113*/SET SCHEMA PUBLIC
DISCONNECT
/*C112*/SET SCHEMA PUBLIC
DISCONNECT
/*C115*/SET SCHEMA PUBLIC
DISCONNECT
/*C114*/SET SCHEMA PUBLIC
DISCONNECT
/*C116*/SET SCHEMA PUBLIC
INSERT INTO OFGROUP VALUES('Test Group A','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group A','sharedRoster.groupList','')
COMMIT
INSERT INTO OFGROUP VALUES('Test Group B','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group B','sharedRoster.showInRoster','nobody')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group B','sharedRoster.displayName','')
COMMIT
INSERT INTO OFGROUPPROP VALUES('Test Group B','sharedRoster.groupList','')
COMMIT
/*C117*/SET SCHEMA PUBLIC
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group A' AND NAME='sharedRoster.showInRoster'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group B' AND NAME='sharedRoster.displayName'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group B' AND NAME='sharedRoster.groupList'
DELETE FROM OFGROUPPROP WHERE GROUPNAME='Test Group B' AND NAME='sharedRoster.showInRoster'
COMMIT
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group A'
DELETE FROM OFGROUP WHERE GROUPNAME='Test Group B'
COMMIT
DISCONNECT
/*C116*/DISCONNECT