304f8a289d06b331d80f667e251f4a86.png PSM Database (Intégral)

# Vers BL Prov.   Qualif. Module S.Module Description Con. Rep. Dev. Ticket
39 		1.1.6
11600039
PSMDB-116-039
New Nouv. TechnicalShape - 2 2 "author" int attribute (FK) ARS - ARS -
40 		1.1.6
11600040
PSMDB-116-040
New Nouv. User - 2 2 "safeusername" varchar(25) attrubute ARS - ARS -
41 		1.1.6
11600041
PSMDB-116-041
New Nouv. Ship - 2 2 "smallernametext" boolean attribute ARS - ARS -
35 		1.1.5
11500035
PSMDB-115-035
New Nouv. Achievement - 2 2 "groupname" varchar(60) attribute ARS - ARS -
36 		1.1.5
11500036
PSMDB-115-036
New Nouv. Achievement - 2 2 "triggervalue" integer attribute ARS - ARS -
37 		1.1.5
11500037
PSMDB-115-037
New Nouv. Achievement - 2 2 "tokenvalue" integer attribute ARS - ARS -
38 		1.1.5
11500038
PSMDB-115-038
New Nouv. Achievement - 2 2 "grouporder" integer attribute ARS - ARS -
26 		1.1.4
11400026
PSMDB-114-026
New Nouv. Treasure - 2 2 "defaultlore" varchar(1000) attribute ARS - ARS -
27 		1.1.4
11400027
PSMDB-114-027
New Nouv. Treasure - 2 2 "lorelocale" varchar(50) attribute ARS - ARS -
28 		1.1.4
11400028
PSMDB-114-028
New Nouv. CacheValuesGeneric - 2 2 New entity "CacheValuesGeneric" ARS - ARS -
29 		1.1.4
11400029
PSMDB-114-029
New Nouv. CacheValuesGeneric - 2 2 "discordservername" varchar(127) attribute ARS - ARS -
30 		1.1.4
11400030
PSMDB-114-030
New Nouv. CacheValuesGeneric - 2 2 "discordservericon" varchar(254) attribute ARS - ARS -
31 		1.1.4
11400031
PSMDB-114-031
New Nouv. CacheValuesGeneric - 2 2 "discordmembercount" integer attribute ARS - ARS -
32 		1.1.4
11400032
PSMDB-114-032
New Nouv. CacheValuesGeneric - 2 2 "discordcacheexpiration" datetime attribute ARS - ARS -
33 		1.1.4
11400033
PSMDB-114-033
New Nouv. CacheValuesGeneric - 2 2 "maintenance" boolean attribute ARS - ARS -
34 		1.1.4
11400034
PSMDB-114-034
New Nouv. CacheValuesGeneric - 2 2 "maintenancetext" varchar(1000) attribute ARS - ARS -
1 		1.1.3
11300001
PSMDB-113-001
New Nouv. User - 2 2 "isachievementlistpublic" boolean attribute ARS - ARS -
2 		1.1.3
11300002
PSMDB-113-002
New Nouv. Keyword - 2 2 "slugname" varchar(80) attribute ARS - ARS -
1 		1.1.2
11200001
PSMDB-112-001
New Nouv. Expansion - 2 1 "colorhextextname" varchar(6) attribute ARS - ARS -
2 		1.1.2
11200002
PSMDB-112-002
New Nouv. Expansion - 2 1 "colorhextextnlore" varchar(6) attribute ARS - ARS -
3 		1.1.2
11200003
PSMDB-112-003
New Nouv. Expansion - 2 1 "colorhextextnability" varchar(6) attribute ARS - ARS -
1 		1.1.1
11100001
PSMDB-111-001
New Nouv. Expansion - 2 2 "colorhex" varchar(6) attribute ARS - ARS -
2 		1.1.1
11100002
PSMDB-111-002
New Nouv. Expansion - 2 2 "ispublic" boolean attribute ARS - ARS -
3 		1.1.1
11100003
PSMDB-111-003
New Nouv. Expansion - 2 2 "slugname" varchar(80) attribute ARS - ARS -
4 		1.1.1
11100004
PSMDB-111-004
New Nouv. Expansion - 2 2 "description" varchar(1500) attribute ARS - ARS -
1 		1.0.4
10400001
PSMDB-104-001
New Nouv. Blog - 2 2 "image" int attribute FK ARS Dev ARS -
2 		1.0.4
10400002
PSMDB-104-002
New Nouv. Image - 2 2 New entity Image ARS Dev ARS -
3 		1.0.4
10400003
PSMDB-104-003
New Nouv. Image - 2 2 "id" AI attribute PK ARS Dev ARS -
4 		1.0.4
10400004
PSMDB-104-004
New Nouv. Image - 2 2 "name" varchar(255) attribute ARS Dev ARS -
5 		1.0.4
10400005
PSMDB-104-005
New Nouv. Image - 2 2 "datecrea" datetime attribute ARS Dev ARS -
6 		1.0.4
10400006
PSMDB-104-006
New Nouv. Image - 2 2 "datemodif" datetime attribute ARS Dev ARS -
1 		1.1.0
11000001
PSMDB-110-001
New Nouv. TechnicalShape - 2 2 New Entity : technicalshape ARS Dev ARS -
2 		1.1.0
11000002
PSMDB-110-002
New Nouv. TechnicalShape - 2 2 "id" AI attribute ARS Dev ARS -
3 		1.1.0
11000003
PSMDB-110-003
New Nouv. TechnicalShape - 2 2 "name" varchar(63) attribute ARS Dev ARS -
4 		1.1.0
11000004
PSMDB-110-004
New Nouv. TechnicalShape - 2 2 "masts" int attribute ARS Dev ARS -
5 		1.1.0
11000005
PSMDB-110-005
New Nouv. TechnicalShape - 2 2 "fromwizkids" boolean attribute ARS Dev ARS -
6 		1.1.0
11000006
PSMDB-110-006
New Nouv. TechnicalShape - 2 2 "custom" boolean attribute ARS Dev ARS -
7 		1.1.0
11000007
PSMDB-110-007
New Nouv. TechnicalShape - 2 2 "datecrea" datetime attribute ARS Dev ARS -
8 		1.1.0
11000008
PSMDB-110-008
New Nouv. TechnicalShape - 2 2 "datemodif" datatime attribute ARS Dev ARS -
9 		1.1.0
11000009
PSMDB-110-009
New Nouv. Ship - 2 2 "idtechnicalshape" int attribute FK ARS Dev ARS -
10 		1.1.0
11000010
PSMDB-110-010
New Nouv. Ship_Keyword - 2 2 "ship_id" int attribute PK FK ARS Dev ARS -
11 		1.1.0
11000011
PSMDB-110-011
New Nouv. Ship_Keyword - 2 2 "keyword_id" int attribute PK FK ARS Dev ARS -
12 		1.1.0
11000012
PSMDB-110-012
New Nouv. Keyword kw_category 2 2 New Entity : kw_category ARS Dev ARS -
13 		1.1.0
11000013
PSMDB-110-013
New Nouv. Keyword kw_target 2 2 New Entity : kw_target ARS Dev ARS -
14 		1.1.0
11000014
PSMDB-110-014
New Nouv. Keyword kw_category 2 2 "id" int attribute PK ARS Dev ARS -
15 		1.1.0
11000015
PSMDB-110-015
New Nouv. Keyword kw_category 2 2 "name" varchar(255) attribute ARS Dev ARS -
16 		1.1.0
11000016
PSMDB-110-016
New Nouv. Keyword kw_category 2 2 "datecrea" datetime attribute ARS Dev ARS -
17 		1.1.0
11000017
PSMDB-110-017
New Nouv. Keyword kw_category 2 2 "datemodif" datetime attribute ARS Dev ARS -
18 		1.1.0
11000018
PSMDB-110-018
New Nouv. Keyword kw_category 2 2 "iconfa" varchar(50) attribute ARS Dev ARS -
19 		1.1.0
11000019
PSMDB-110-019
New Nouv. Keyword kw_target 2 2 "id" int attribute PK ARS Dev ARS -
20 		1.1.0
11000020
PSMDB-110-020
New Nouv. Keyword kw_target 2 2 "name" varchar(50) attribute ARS Dev ARS -
21 		1.1.0
11000021
PSMDB-110-021
New Nouv. Keyword kw_target 2 2 "datecrea" datetime attribute ARS Dev ARS -
22 		1.1.0
11000022
PSMDB-110-022
New Nouv. Keyword kw_target 2 2 "datemodif" datetime attribute ARS Dev ARS -
23 		1.1.0
11000023
PSMDB-110-023
New Nouv. Keyword - 2 2 "idkeywordtype" int attribute FK ARS Dev ARS -
24 		1.1.0
11000024
PSMDB-110-024
New Nouv. Keyword - 2 2 "idkeywordtarget" int attribute FK ARS Dev ARS -
25 		1.1.0
11000025
PSMDB-110-025
New Nouv. Keyword - 2 2 "fromwizkids" boolean attribute ARS Dev ARS -
1 		1.0.3
10300001
PSMDB-103-001
New Nouv. Rating - 2 2 New table 'Rating' ARS Dev ARS -
2 		1.0.3
10300002
PSMDB-103-002
New Nouv. Rating - 2 2 "idship" Ship attribute ARS Dev ARS -
3 		1.0.3
10300003
PSMDB-103-003
New Nouv. Rating - 2 2 "idcrew" Crew attribute ARS Dev ARS -
4 		1.0.3
10300004
PSMDB-103-004
New Nouv. Rating - 2 2 "idtreasure" Treasure attribute ARS Dev ARS -
5 		1.0.3
10300005
PSMDB-103-005
New Nouv. Rating - 2 2 "datecrea" datetime attribute ARS Dev ARS -
6 		1.0.3
10300006
PSMDB-103-006
New Nouv. Rating - 2 2 "datemodif" datetime attribute ARS Dev ARS -
7 		1.0.3
10300007
PSMDB-103-007
New Nouv. Rating - 2 2 "iduser" User attribute ARS Dev ARS -
8 		1.0.3
10300008
PSMDB-103-008
New Nouv. Rating - 2 2 "scoremain" tinyint attribute ARS Dev ARS -
9 		1.0.3
10300009
PSMDB-103-009
New Nouv. Rating - 2 2 "reviewcontent" varchar(1000) attribute ARS Dev ARS -
10 		1.0.3
10300010
PSMDB-103-010
New Nouv. Rating - 2 2 "scoregoldrunner" tinyint attribute ARS Dev ARS -
11 		1.0.3
10300011
PSMDB-103-011
New Nouv. Rating - 2 2 "scoregunship" tinyint attribute ARS Dev ARS -
12 		1.0.3
10300012
PSMDB-103-012
New Nouv. Rating - 2 2 "scoreart" tinyint attribute ARS Dev ARS -
13 		1.0.3
10300013
PSMDB-103-013
New Nouv. Rating - 2 2 "title" varchar(50) attribute ARS Dev ARS -
14 		1.0.3
10300014
PSMDB-103-014
New Nouv. Rating - 2 2 "ispublished" boolean atribute ARS Dev ARS -
15 		1.0.3
10300015
PSMDB-103-015
New Corr. Ship - 2 2 Fix flavor text of SCS039 https://discord.com/channels/468973063325876234/858531716431740938/976601927972454450 ARS Dev ARS -
1 		1.0.2
10200001
PSMDB-102-001
New Corr. Other - 2 1 Fix stuff according to this https://pirateswithben.com/wp-content/uploads/2018/05/The-Pirate-Code-FAQ-Dec-2016.pdf ARS Dev ARS -
2 		1.0.2
10200002
PSMDB-102-002
New Corr. Ship - 2 1 "Carcharadon" spelled wrong, should be "Carcharodon" - Dev ARS -
1 		1.0.1
10100001
PSMDB-101-001
New Suppr. Other - 2 2 CollectionCrew entity ARS Dev ARS -
2 		1.0.1
10100002
PSMDB-101-002
New Suppr. Other - 2 2 CollectionShip entity ARS Dev ARS -
3 		1.0.1
10100003
PSMDB-101-003
New Suppr. Other - 2 2 ShipLink entity ARS Dev ARS -
4 		1.0.1
10100004
PSMDB-101-004
New Suppr. Other - 2 2 CrewLink entity ARS Dev ARS -
5 		1.0.1
10100005
PSMDB-101-005
New Suppr. Other - 2 2 CrewKey entity ARS Dev ARS -
6 		1.0.1
10100006
PSMDB-101-006
New Suppr. Other - 2 2 ShipKey entity ARS Dev ARS -
7 		1.0.1
10100007
PSMDB-101-007
New Nouv. Crew - 2 2 Crew entity ARS Dev ARS -
8 		1.0.1
10100008
PSMDB-101-008
New Nouv. Treasure - 2 2 Treasure entity ARS Dev ARS -
9 		1.0.1
10100009
PSMDB-101-009
New Corr. Expansion - 2 2 "name" now only contains the full name ARS Dev ARS -
10 		1.0.1
10100010
PSMDB-101-010
New Nouv. Expansion - 2 2 "nameimg" varchar(50) attribute ARS Dev ARS -
11 		1.0.1
10100011
PSMDB-101-011
New Nouv. Expansion - 2 2 "datecrea" datetime attribute ARS Dev ARS -
12 		1.0.1
10100012
PSMDB-101-012
New Nouv. Expansion - 2 2 "datemodif" datetime attribute ARS Dev ARS -
13 		1.0.1
10100013
PSMDB-101-013
New Nouv. Expansion - 2 2 "shortWizkids" attribute. Stores the abbreviation officially used by wizkids. ARS Dev ARS -
14 		1.0.1
10100014
PSMDB-101-014
New Nouv. Expansion - 2 2 "shortcommunity" attribute. Stores optional alternative abbreviation when there are more than one popular abbreviation for an expansion. ARS Dev ARS -
15 		1.0.1
10100015
PSMDB-101-015
New Corr. Faction - 2 2 All attributes are now in lowercase ARS Dev ARS -
16 		1.0.1
10100016
PSMDB-101-016
New Corr. Expansion - 2 2 Renamed "idExtension", now known as "id" ARS Dev ARS -
17 		1.0.1
10100017
PSMDB-101-017
New Corr. Faction - 2 2 Renamed "idFaction", now known as "id" ARS Dev ARS -
18 		1.0.1
10100018
PSMDB-101-018
New Corr. Faction - 2 2 "nameimg" now accepts up to 20 char (from 10) ARS Dev ARS -
19 		1.0.1
10100019
PSMDB-101-019
New Corr. User - 2 2 Renamed "account", now known as "app_user" ARS Dev ARS -
20 		1.0.1
10100020
PSMDB-101-020
New Corr. User - 2 2 Renamed "realFirstName", now known as "firstname" ARS Dev ARS -
21 		1.0.1
10100021
PSMDB-101-021
New Corr. User - 2 2 Renamed "realLastName", now known as "lastname" ARS Dev ARS -
22 		1.0.1
10100022
PSMDB-101-022
New Corr. User - 2 2 All attributes are now in lowercase ARS Dev ARS -
23 		1.0.1
10100023
PSMDB-101-023
New Corr. User - 2 2 Renamed "passHash", now known as "password" ARS Dev ARS -
24 		1.0.1
10100024
PSMDB-101-024
New Corr. User - 2 2 Renamed "passHashPrevious", now known as "passwordprevious" ARS Dev ARS -
25 		1.0.1
10100025
PSMDB-101-025
New Corr. User - 2 2 Renamed "mail", now known as "email" ARS Dev ARS -
26 		1.0.1
10100026
PSMDB-101-026
New Nouv. User - 2 2 "iswantlistpublic" boolean attribute ARS Dev ARS -
27 		1.0.1
10100027
PSMDB-101-027
New Nouv. User - 2 2 "istradelistpublic" boolean attribute ARS Dev ARS -
28 		1.0.1
10100028
PSMDB-101-028
New Nouv. User - 2 2 "isaccountdetails" boolean attribute ARS Dev ARS -
29 		1.0.1
10100029
PSMDB-101-029
New Nouv. User - 2 2 "ispersonalcollectionpublic" boolean attribute ARS Dev ARS -
30 		1.0.1
10100030
PSMDB-101-030
New Nouv. User - 2 2 "canlogin" boolean attribute ARS Dev ARS -
31 		1.0.1
10100031
PSMDB-101-031
New Nouv. User - 2 2 "isgeoworld" int attribute (foreign key from geoworld) ARS Dev ARS -
32 		1.0.1
10100032
PSMDB-101-032
New Nouv. User - 2 2 "default_avatar" varchat(255) attribute ARS Dev ARS -
33 		1.0.1
10100033
PSMDB-101-033
New Nouv. User - 2 2 "avatar" varchar(128) attribute ARS Dev ARS -
34 		1.0.1
10100034
PSMDB-101-034
New Nouv. User - 2 2 "personnalwebsite" varchar(256) attribute ARS Dev ARS -
35 		1.0.1
10100035
PSMDB-101-035
New Nouv. User - 2 2 "discord" varchar(32) attribute ARS Dev ARS -
36 		1.0.1
10100036
PSMDB-101-036
New Nouv. User - 2 2 "facebook" varchar(254) attribute ARS Dev ARS -
37 		1.0.1
10100037
PSMDB-101-037
New Nouv. User - 2 2 "etsy" varchar(254) attribute ARS Dev ARS -
38 		1.0.1
10100038
PSMDB-101-038
New Nouv. User - 2 2 "boardgamegeek" varchar(254) attribute ARS Dev ARS -
39 		1.0.1
10100039
PSMDB-101-039
New Nouv. User - 2 2 "issubbedtonewsletter" boolean attribute ARS Dev ARS -
40 		1.0.1
10100040
PSMDB-101-040
New Nouv. User - 2 2 "birthdate" datetime attribute ARS Dev ARS -
41 		1.0.1
10100041
PSMDB-101-041
New Corr. Rarity - 2 2 All attributes are now in lowercase ARS Dev ARS -
42 		1.0.1
10100042
PSMDB-101-042
New Corr. Rarity - 2 2 "datecrea" datetime attribute ARS Dev ARS -
43 		1.0.1
10100043
PSMDB-101-043
New Nouv. Rarity - 2 2 "datemodif" datetime attribute ARS Dev ARS -
44 		1.0.1
10100044
PSMDB-101-044
New Corr. Rarity - 2 2 Renamed "idRarity". Now known as "id". ARS Dev ARS -
45 		1.0.1
10100045
PSMDB-101-045
New Corr. Ship - 2 2 All attributes are now in lowercase. ARS Dev ARS -
46 		1.0.1
10100046
PSMDB-101-046
New Corr. User - 2 2 "idtype" int attribute. Foreign key from Type ARS Dev ARS -
47 		1.0.1
10100047
PSMDB-101-047
New Corr. Ship - 2 2 "cannons" now accepts up to 50 char (from 30) ARS Dev ARS -
48 		1.0.1
10100048
PSMDB-101-048
New Nouv. Type - 2 2 Type entity ARS Dev ARS -
49 		1.0.1
10100049
PSMDB-101-049
New Nouv. Ship - 2 2 "temporarylinktxt" varchar(100) attribute ARS Dev ARS -
50 		1.0.1
10100050
PSMDB-101-050
New Nouv. Crew - 2 2 "coinvalues" varchar(50) attribute ARS Dev ARS -
51 		1.0.1
10100051
PSMDB-101-051
New Nouv. Faction - 2 2 "defaultname" varchar(50) attribute ARS Dev ARS -
52 		1.0.1
10100052
PSMDB-101-052
New Nouv. Report - 2 2 Report entity ARS Dev ARS -
53 		1.0.1
10100053
PSMDB-101-053
New Nouv. Report - 2 2 "title" varchar(255) attribute ARS Dev ARS -
54 		1.0.1
10100054
PSMDB-101-054
New Nouv. Report - 2 2 "descuser" varchar(2047) attribute ARS Dev ARS -
55 		1.0.1
10100055
PSMDB-101-055
New Nouv. Report - 2 2 "descdev" varchar(2047) attribute ARS Dev ARS -
56 		1.0.1
10100056
PSMDB-101-056
New Nouv. Report - 2 2 "issolved" boolean attribute ARS Dev ARS -
57 		1.0.1
10100057
PSMDB-101-057
New Nouv. User - 2 2 "isadmin" boolean attribute ARS Dev ARS -
58 		1.0.1
10100058
PSMDB-101-058
New Nouv. Report - 2 2 "genericlocation" varchar(255) attribute ARS Dev ARS -