development:mysql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
development:mysql [2012/12/17 19:23] – add multiple tables s0600204 | development:mysql [2017/05/07 11:09] (current) – Lars Knickrehm | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== | + | ====== |
- | This page is dedicated to the development | + | This page is dedicated to the documentation |
- | For the moment, the technical details of how to connect oneye to the database are not important. What's currently being discussed is how data should be stored within | + | Any suggestions, concerns, problems or other should be brought to light on the forums, specifically [[http:// |
- | * What tables are required, and what they should be called | + | |
- | * What fields are required inside | + | |
- | * What the fields should be named | + | |
- | * What format | + | |
- | * What length the fields should be | + | |
- | Please note that modifications should only be made to this page __after__ they' | + | ==== The Codebase ==== |
+ | |||
+ | As with all current development | ||
==== The Database ==== | ==== The Database ==== | ||
Line 16: | Line 13: | ||
The database format is mySQL. | The database format is mySQL. | ||
- | The proposed | + | The method |
== Constants == | == Constants == | ||
Line 29: | Line 26: | ||
==== The Tables ==== | ==== The Tables ==== | ||
- | List of suggested | + | List of currently implementated |
* **tblUser** - Main table that contains user data. | * **tblUser** - Main table that contains user data. | ||
* **tblGroups** - Table listing which users belong to which groups. Always checked. | * **tblGroups** - Table listing which users belong to which groups. Always checked. | ||
Line 42: | Line 39: | ||
| | | | ||
| | | | ||
- | | email | varchar | + | | email | varchar |
- | | quota | integer | + | | quota | integer |
- | | | + | | |
- | | | + | | |
- | | lastLogin | integer | + | | lastLogin | integer |
| expirationDate | integer | | expirationDate | integer | ||
| | | | ||
Line 66: | Line 63: | ||
| | | | ||
| groupname | varchar | | groupname | varchar | ||
- | |||
==== Reference ==== | ==== Reference ==== |
development/mysql.1355768600.txt.gz · Last modified: 2016/03/07 22:55 (external edit)