diff options
| author | Thomas Lange <code@nerdmind.de> | 2017-02-24 21:05:00 +0100 |
|---|---|---|
| committer | Thomas Lange <code@nerdmind.de> | 2017-02-24 21:05:00 +0100 |
| commit | b256462d3380000421da046c71115629e7a76e29 (patch) | |
| tree | e764eb3e7a04c39c6e8660482a6c4b9894ea00ef /Database.md | |
| parent | 8a09f7d09f14cab9ad1d813f92b11a2fa2fe3876 (diff) | |
| download | wiki-b256462d3380000421da046c71115629e7a76e29.tar.gz wiki-b256462d3380000421da046c71115629e7a76e29.tar.xz wiki-b256462d3380000421da046c71115629e7a76e29.zip | |
Initial commit.
Diffstat (limited to 'Database.md')
| -rw-r--r-- | Database.md | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/Database.md b/Database.md new file mode 100644 index 0000000..3b20dfb --- /dev/null +++ b/Database.md @@ -0,0 +1,37 @@ +# Documentation: Database structure + +## Table `page` [`InnoDB`] +In this table are all created page objects stored and will be removed if the admin deletes them. + +* Column `id`: Contains the unique primary ID to identify a page +* Column `time_insert`: Contains the time stamp (Format: `YYYY-MM-DD HH:II:SS`) when the page was created +* Column `time_update`: Contains the time stamp (Format: `YYYY-MM-DD HH:II:SS`) when the page was updated +* Column `user`: Contains the user ID of the user who created this page (`user.id`) +* Column `slug`: Contains the slug part of the pages absolute URL +* Column `name`: Contains the name of the page +* Column `body`: Contains the body of the page in the markdown format + +## Table `post` [`MyISAM`] +In this table are all created post objects stored and will be removed if the admin deletes them. +The table type is `MyISAM` because the fulltext search doesn't work with `InnoDB` in MySQL < `5.6`. + +* Column `id`: Contains the unique primary ID to identify a post +* Column `time_insert`: Contains the time stamp (Format: `YYYY-MM-DD HH:II:SS`) when the post was created +* Column `time_update`: Contains the time stamp (Format: `YYYY-MM-DD HH:II:SS`) when the post was updated +* Column `user`: Contains the user ID of the user who created this post (`user.id`) +* Column `slug`: Contains the slug part of the posts absolute URL +* Column `name`: Contains the name of the post +* Column `body`: Contains the body of the post in the markdown format + +## Table `user` [`InnoDB`] +In this table are all created user objects stored and will be removed if the admin deletes them. + +* Column `id`: Contains the unique primary ID to identify a user +* Column `time_insert`: Contains the time stamp (Format: `YYYY-MM-DD HH:II:SS`) when the user was created +* Column `time_update`: Contains the time stamp (Format: `YYYY-MM-DD HH:II:SS`) when the user was updated +* Column `slug`: Contains the slug part of the users absolute URL +* Column `username`: Contains the username of the user +* Column `password`: Contains the `bcrypt` hashed password of the user +* Column `fullname`: Contains the full name of the user +* Column `mailaddr`: Contains the contact email address of the user +* Column `body`: Contains the body of the user in the markdown format
\ No newline at end of file |