User Tools

Site Tools


development:mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
development:mysql [2012/12/17 19:23] – add multiple tables s0600204development:mysql [2017/05/07 11:09] (current) Lars Knickrehm
Line 1: Line 1:
-====== mySQL ======+====== MySQL ======
  
-This page is dedicated to the development of a standard way of encoding user data into a mySQL database.+This page is dedicated to the documentation of how we have encoded oneye user data into a mySQL database.
  
-For the momentthe 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 the databaseThis requires the following decisions: +Any suggestionsconcerns, problems or other should be brought to light on the forums, specifically [[http://forums.oneye-project.org/viewtopic.php?id=37|in this thread]]. (To those used to MediaWiki-type wikithink of the forum page linked as the discussion page for this wiki page).
-  * What tables are required, and what they should be called +
-  * What fields are required inside those tablesand +
-    * What the fields should be named +
-    * What format the fields should be (Number, String, etc.+
-    * What length the fields should be+
  
-Please note that modifications should only be made to this page __after__ they've been discussed in [[http://forums.oneye-project.org/viewtopic.php?id=37|this thread]] on the forumsAny concerns, problems or other should be brought to light therenot here. (To those used to MediaWiki-type wiki, think of the forum page linked as the discussion page for this wiki page).+==== The Codebase ==== 
 + 
 +As with all current development on oneye, the current code for the implementation is publicly accessible on GitHubSpecifically, here: https://github.com/s0600204/oneye/tree/userConfig
  
 ==== The Database ==== ==== The Database ====
Line 16: Line 13:
 The database format is mySQL. The database format is mySQL.
  
-The proposed method 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).+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 == == Constants ==
Line 29: Line 26:
 ==== The Tables ==== ==== The Tables ====
  
-List of suggested tables:+List of currently implementated tables:
   * **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:
 |       username |  varchar  |  32      |  No                    |                  Primary Key  | |       username |  varchar  |  32      |  No                    |                  Primary Key  |
 |       password |   char    |  32      |  No                    |                               | |       password |   char    |  32      |  No                    |                               |
-|          email |  varchar  |  64      |  Yes                    NULL           |               | +|          email |  varchar  |  64      |  Yes                                   |               | 
-|          quota |  integer  |          |  Yes                    NULL            Unsigned     +|          quota |  integer  |          |  Yes                    NULL            Unsigned, NULL = 'System Default'  
-|       fullname |  varchar  |  64      |  Yes                    NULL           |               | +|       fullname |  varchar  |  64      |  Yes                                   |               | 
-|     createDate |  integer  |          |  Yes                   |  NULL           |  Unsigned     | +|     createDate |  integer  |          |  Yes                   |  0              |  Unsigned     | 
-|      lastLogin |  integer  |          |  Yes                   |  NULL           |  Unsigned     |+|      lastLogin |  integer  |          |  Yes                   |  0              |  Unsigned     |
 | expirationDate |  integer  |          |  Yes                    0              |  Unsigned     | | expirationDate |  integer  |          |  Yes                    0              |  Unsigned     |
 |       disabled |   char    |  1        Yes                    0              |               | |       disabled |   char    |  1        Yes                    0              |               |
Line 66: Line 63:
 |   maintainer |  varchar  |    32    |  No                    |                  Primary Key  | |   maintainer |  varchar  |    32    |  No                    |                  Primary Key  |
 |    groupname |  varchar  |    32    |  No                    |                  Primary Key  | |    groupname |  varchar  |    32    |  No                    |                  Primary Key  |
- 
  
 ==== Reference ==== ==== Reference ====
development/mysql.1355768600.txt.gz · Last modified: 2016/03/07 22:55 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki