From 1f98656e561b20be795816c6de2a960dd63b248f Mon Sep 17 00:00:00 2001 From: Kavoos Bojnourdi Date: Sat, 29 Aug 2015 16:32:59 +0200 Subject: [PATCH] Sequence generation fixes --- .../java/com/edf/gde/entities/Attribute.java | 2 +- .../com/edf/gde/entities/AttributeGroup.java | 2 - .../src/java/com/edf/gde/entities/Chunk.java | 2 - .../java/com/edf/gde/entities/ChunkInfo.java | 4 - .../java/com/edf/gde/entities/GDEFile.java | 2 - .../src/java/com/edf/gde/entities/Group.java | 2 - .../com/edf/gde/entities/GroupPermission.java | 2 - .../java/com/edf/gde/entities/Profile.java | 2 - .../edf/gde/entities/ProfileAttribute.java | 2 - .../src/java/com/edf/gde/entities/Study.java | 2 - .../src/java/com/edf/gde/entities/User.java | 2 - .../java/com/edf/gde/entities/UserGroup.java | 2 - .../GDE-ejb/src/java/com/edf/gde/sql/init.sql | 74 ++++++++++--------- 13 files changed, 39 insertions(+), 61 deletions(-) diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Attribute.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Attribute.java index c2c0f32..4f63612 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Attribute.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Attribute.java @@ -45,7 +45,7 @@ public class Attribute implements Serializable { @Basic(optional = false) @NotNull @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) + @SequenceGenerator(name = "SEQ_GEN_SEQUENCE",allocationSize = 50, initialValue = 10000) @Column(name = "id") private long id; @Size(max = 255) diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/AttributeGroup.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/AttributeGroup.java index 39e0abb..b5fe16f 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/AttributeGroup.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/AttributeGroup.java @@ -20,7 +20,6 @@ import javax.persistence.Id; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; import javax.persistence.OneToMany; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.validation.constraints.NotNull; import javax.xml.bind.annotation.XmlRootElement; @@ -44,7 +43,6 @@ public class AttributeGroup implements Serializable { @Basic(optional = false) @NotNull @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) @Column(name = "id") private long id; @OneToMany(fetch = FetchType.LAZY, orphanRemoval = true, cascade = {CascadeType.ALL}, mappedBy = "attributeGroup") diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Chunk.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Chunk.java index 7f90a6d..e3e5c4b 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Chunk.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Chunk.java @@ -15,7 +15,6 @@ import javax.persistence.Id; import javax.persistence.Lob; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.validation.constraints.NotNull; import javax.validation.constraints.Size; @@ -45,7 +44,6 @@ public class Chunk implements Serializable { @Basic(optional = false) @NotNull @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) @Column(name = "id") private long id; @Column(name = "file_id", nullable = false) diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/ChunkInfo.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/ChunkInfo.java index a3bd1c8..817cbfc 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/ChunkInfo.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/ChunkInfo.java @@ -35,10 +35,6 @@ import javax.xml.bind.annotation.XmlRootElement; public class ChunkInfo implements Serializable { private static final long serialVersionUID = 1L; @Id - @Basic(optional = false) - @NotNull - @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) @Column(name = "id") private long id; @Column(name = "file_id", nullable = false) diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/GDEFile.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/GDEFile.java index 31348dc..cd3b0d2 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/GDEFile.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/GDEFile.java @@ -20,7 +20,6 @@ import javax.persistence.JoinColumn; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; import javax.persistence.OneToOne; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.persistence.Temporal; import javax.persistence.TemporalType; @@ -54,7 +53,6 @@ public class GDEFile implements Serializable { @NotNull @Column(name = "id") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) private long id; @Size(max = 255) @Column(name = "name") diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Group.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Group.java index 30b2811..d9c900e 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Group.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Group.java @@ -13,7 +13,6 @@ import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.validation.constraints.NotNull; import javax.validation.constraints.Size; @@ -35,7 +34,6 @@ public class Group { @NotNull @Column(name = "id") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) private Long id; @Size(max = 255) @Column(name = "groupName") diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/GroupPermission.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/GroupPermission.java index b6ea114..ad0f1b6 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/GroupPermission.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/GroupPermission.java @@ -10,7 +10,6 @@ import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.validation.constraints.NotNull; import org.eclipse.persistence.annotations.Cache; @@ -46,7 +45,6 @@ public class GroupPermission implements Serializable { @NotNull @Column(name = "id") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) private Long id; @Column(name = "groupId") long groupId; diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Profile.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Profile.java index 9e6d53f..95a39ca 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Profile.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Profile.java @@ -22,7 +22,6 @@ import javax.persistence.Id; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; import javax.persistence.OneToMany; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.validation.constraints.NotNull; import javax.validation.constraints.Size; @@ -47,7 +46,6 @@ public class Profile implements Serializable { @Basic(optional = false) @NotNull @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) @Column(name = "id") private Long id; @Size(max = 255) diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/ProfileAttribute.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/ProfileAttribute.java index f3c6002..9060533 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/ProfileAttribute.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/ProfileAttribute.java @@ -17,7 +17,6 @@ import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.validation.constraints.NotNull; import javax.validation.constraints.Size; @@ -42,7 +41,6 @@ public class ProfileAttribute implements Serializable { @Basic(optional = false) @NotNull @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) @Column(name = "id") private Long id; @Size(max = 255) diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Study.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Study.java index d48f9da..b196f35 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Study.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/Study.java @@ -22,7 +22,6 @@ import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; import javax.persistence.OneToMany; import javax.persistence.OneToOne; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.persistence.Temporal; import javax.persistence.TemporalType; @@ -53,7 +52,6 @@ public class Study implements Serializable { @NotNull @Column(name = "id") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) private long id; @Size(max = 255) @Column(name = "name") diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/User.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/User.java index 68264a2..4815e19 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/User.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/User.java @@ -13,7 +13,6 @@ import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.validation.constraints.NotNull; import javax.validation.constraints.Size; @@ -40,7 +39,6 @@ public class User implements Serializable { @NotNull @Column(name = "id") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) private Long id; @Size(max = 255) @Column(name = "userName") diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/UserGroup.java b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/UserGroup.java index 5ee7d92..0775973 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/UserGroup.java +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/entities/UserGroup.java @@ -13,7 +13,6 @@ import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; -import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.validation.constraints.NotNull; import org.eclipse.persistence.annotations.Cache; @@ -46,7 +45,6 @@ public class UserGroup implements Serializable { @NotNull @Column(name = "id") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_GEN_SEQUENCE") - @SequenceGenerator(name = "SEQ_GEN_SEQUENCE", allocationSize = 50, initialValue = 1000) private Long id; @Column(name = "userId") long userId; diff --git a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/sql/init.sql b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/sql/init.sql index ed444a1..a7e687f 100644 --- a/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/sql/init.sql +++ b/projects/GDE_App/GDE-ejb/src/java/com/edf/gde/sql/init.sql @@ -1,46 +1,48 @@ +drop sequence if exists INIT_VALUES_SEQ; +create sequence INIT_VALUES_SEQ START WITH 10; -- The 1000 first ids are reserved for initial data INSERT INTO users (id,username,userpassword) VALUES (1,'admin','edf123'); INSERT INTO group_ (id,groupname) VALUES (1,'admins'); -INSERT into usergroup(id,groupid,userid) VALUES (2,1,1); +INSERT into usergroup(id,groupid,userid) VALUES (1,1,1); /* User management permissions */ -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',1); -- Create user -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (4, 1, 'UserService',2); -- Delete user -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (5, 1, 'UserService',3); -- Add to group -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (6, 1, 'UserService',4); -- Remove from group -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (7, 1, 'UserService',5); -- Create group -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (8, 1, 'UserService',6); -- Delete group -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (9, 1, 'UserService',7); -- Find user -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (10, 1, 'UserService',8); -- Find group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'UserService',1); -- Create user +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'UserService',2); -- Delete user +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'UserService',3); -- Add to group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'UserService',4); -- Remove from group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'UserService',5); -- Create group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'UserService',6); -- Delete group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'UserService',7); -- Find user +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'UserService',8); -- Find group /* Studies permissions */ -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (11, 1, 'StudyService',1); -- Create study -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (12, 1, 'StudyService',2); -- Set study state -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (13, 1, 'StudyService',3); -- Read study -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (14, 1, 'StudyService',4); -- Delete study -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (15, 1, 'StudyService',5); -- List studies +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'StudyService',1); -- Create study +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'StudyService',2); -- Set study state +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'StudyService',3); -- Read study +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'StudyService',4); -- Delete study +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'StudyService',5); -- List studies /* Profiles services */ -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (16, 1, 'ProfilesService',1); -- Create profile -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (17, 1, 'ProfilesService',2); -- Delete profile -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (18, 1, 'ProfilesService',3); -- Read profile -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (19, 1, 'ProfilesService',4); -- Update profile -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (20, 1, 'ProfilesService',5); -- Create profile attribute -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (21, 1, 'ProfilesService',6); -- Delete profile attribute -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (22, 1, 'ProfilesService',7); -- Read profile attribute -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (23, 1, 'ProfilesService',8); -- Update profile attribute +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'ProfilesService',1); -- Create profile +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'ProfilesService',2); -- Delete profile +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'ProfilesService',3); -- Read profile +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'ProfilesService',4); -- Update profile +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'ProfilesService',5); -- Create profile attribute +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'ProfilesService',6); -- Delete profile attribute +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'ProfilesService',7); -- Read profile attribute +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'ProfilesService',8); -- Update profile attribute /* Attributes services */ -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (24, 1, 'AttributesService',1); -- Create attribute -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (25, 1, 'AttributesService',2); -- Delete attribute -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (26, 1, 'AttributesService',3); -- Read attribute -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (27, 1, 'AttributesService',4); -- Create attribute group -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (28, 1, 'AttributesService',5); -- Delete attribute group -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (29, 1, 'AttributesService',6); -- Update attribute group -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (30, 1, 'AttributesService',7); -- Read attribute group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'AttributesService',1); -- Create attribute +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'AttributesService',2); -- Delete attribute +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'AttributesService',3); -- Read attribute +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'AttributesService',4); -- Create attribute group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'AttributesService',5); -- Delete attribute group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'AttributesService',6); -- Update attribute group +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'AttributesService',7); -- Read attribute group /* File services */ -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (31, 1, 'FileService',1); -- -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (32, 1, 'FileService',2); -- -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (33, 1, 'FileService',3); -- -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (34, 1, 'FileService',4); -- -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (35, 1, 'FileService',5); -- -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (36, 1, 'FileService',6); -- -INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (37, 1, 'FileService',7); -- +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'FileService',1); -- +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'FileService',2); -- +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'FileService',3); -- +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'FileService',4); -- +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'FileService',5); -- +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'FileService',6); -- +INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (nextval('INIT_VALUES_SEQ'), 1, 'FileService',7); -- -- 2.39.2