Differences

This shows you the differences between two versions of the page.

--- en:nel_mysql [2016/12/20 13:48] – created Domperss
+++ en:nel_mysql [2021/12/03 18:19] (current) – external edit 127.0.0.1
@@ Line 5: / Line 5: @@
 <WRAP center round todo 60%>
-In progress ; It is long and tiring to fill, not to mention the play of riddle. Do not hesitate to complete!
+This document is in progress!! It's a tiring job finding out(and filling out) all the information.
+Do not hesitate to help for faster completion!!
 </WRAP>
@@ Line 37: / Line 38: @@
 In this table the fields UId, DomainId and ShardId should be foreign keys, but they are not defined as well
 </WRAP>
+  * PermissionId: Permission ID number
+  * UId: User(reference to //User/UId//)
+  * DomainId: Domain on which it is valid(reference to //domain/domain_id//)
+  * ShardId: Shard on which it is valid(reference to //shard/shard_id//).
+  * AccessPrivilege: conditions of the shard, user must have right conditions to be able to access the shard. \\
- * PermissionId: Permission ID number
+It's 19 characters maximum, which corresponds to the value: "OPEN, DEV, RESTRICTED".
- * UId: User(reference to //User/UId//)
+Value for a normal user: "OPEN". This is a set of three values: `AccessPrivilege` set ('OPEN', 'DEV', 'RESTRICTED') NOT NULL DEFAULT 'OPEN'
- * DomainId: Domain on which it is valid(reference to //domain/domain_id//)
- * ShardId: Shard on which it is valid(reference to //shard/shard_id//).
- * AccessPrivilege: conditions in which the shard must be for the user to access it. 19 characters maximum, which corresponds to the value: "OPEN, DEV, RESTRICTED". Value for a normal user: "OPEN". This is a set of three values: `AccessPrivilege` set ('OPEN', 'DEV', 'RESTRICTED') NOT NULL DEFAULT 'OPEN'