Mercurial > malikania

changeset 122:42d2367132df

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Docs: add more info about database accounts
author David Demelier <markand@malikania.fr>
date Fri, 22 Sep 2017 13:02:56 +0200
parents 48f7e7277ab6
children fa7466083ba2
files docs/specs/db/account.md docs/specs/db/character.md docs/specs/db/spell.md
diffstat 3 files changed, 20 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/docs/specs/db/account.md	Fri Sep 22 12:56:55 2017 +0200
+++ b/docs/specs/db/account.md	Fri Sep 22 13:02:56 2017 +0200
@@ -14,6 +14,16 @@
 | lastname      | string                    |
 | createdate    | date (default to now)     |
 
+## Fields
+
+  - **id**: unique id,
+  - **login**: unique login,
+  - **password**: hashed password,
+  - **email**: user email,
+  - **firstname**: optional first name,
+  - **lastname**: optional last name,
+  - **createdate**: account creation date.
+
 ## Associations
 
 ````nohighlight
--- a/docs/specs/db/character.md	Fri Sep 22 12:56:55 2017 +0200
+++ b/docs/specs/db/character.md	Fri Sep 22 13:02:56 2017 +0200
@@ -8,11 +8,17 @@
 |---------------|---------------------------|
 | id            | big integer (primary key) |
 | account_id    | big integer               |
+| nickname      | string unique not null    |
+| classname     | string not null           |
 | level         | short uint                |
 | hp            | short uint                |
 
+## Fields
+
   - **id**: unique idenfitier,
   - **account_id**: references account.id,
+  - **nickname**: account unique nickname,
+  - **classname**: account class name,
   - **level**: current character level,
   - **hp**: current heal points.
 
--- a/docs/specs/db/spell.md	Fri Sep 22 12:56:55 2017 +0200
+++ b/docs/specs/db/spell.md	Fri Sep 22 13:02:56 2017 +0200
@@ -8,10 +8,12 @@
 |---------------|---------------------------|
 | id            | big integer (primary key) |
 | character_id  | big integer               |
+| classname     | string not null           |
 | level         | short int                 |
-| name          | string                    |
+
+## Fields
 
   - **id**: unique idenfitier,
   - **character_id**: references character.id,
+  - **classname**: the class name to create,
   - **level**: spell level,
-  - **name**: name of spell, to instanciate in the game.