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/11/26 20:10] – Addition of 'maintainer' and 'admin' fields, and changing field-type of 'quota' to integer. 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 ==== | ||
- | The database format is mySQL. | + | The database format is mySQL. |
+ | |||
+ | The method used to connect to the database from PHP is the mySQLi Extension, included by default with PHP and compatible with databases created with mySQL v4.1 and later (current stable version: v5.1). | ||
+ | |||
+ | == Constants == | ||
+ | The values of these constants | ||
+ | ^ Constant Description | ||
+ | | mySQL Server Address | | ||
+ | | Database Name | | ||
+ | | Database Username | MYSQL_USERNAME | ||
+ | | Database Password | MYSQL_PASSWORD | ||
==== 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. | ||
+ | * **tblMaintainedUsers** - This table lists the maintainers and their assigned users. Only checked if the // | ||
+ | * **tblMaintainedGroups** - This table lists the maintainers and their assigned groups. Only checked if the // | ||
Line 29: | Line 39: | ||
| | | | ||
| | | | ||
- | | email | varchar | + | | email | varchar |
- | | quota | integer | + | | quota | integer |
- | | | + | | |
- | | | + | | |
- | | expirationDate | integer | + | | lastLogin | integer |
+ | | expirationDate | integer | ||
| | | | ||
- | | | + | | admin | |
- | | | + | | maintainer |
- | | admin | | + | |
- | | maintainer | | + | == tblGroups == |
- | | maintain | + | ^ Field Name ^ |
- | | mngUsers | + | | |
+ | | | ||
+ | |||
+ | == tblMaintainedUsers == | ||
+ | ^ Field Name ^ | ||
+ | | maintainer | ||
+ | | username | ||
+ | == tblMaintainedGroups == | ||
+ | ^ Field Name ^ | ||
+ | | | ||
+ | | groupname | varchar | ||
==== Reference ==== | ==== Reference ==== |
development/mysql.1353957008.txt.gz · Last modified: 2016/03/07 22:55 (external edit)