|
|
| Line 2: |
Line 2: |
| | Split into subpages, and combine in the Policy page links. | | Split into subpages, and combine in the Policy page links. |
| | ==MySQL Account== | | ==MySQL Account== |
| − | ===Creation===
| |
| − | Databases are created for projects on an as-needed basis. To request, send email to [mailto:ece-webmaster@ncsu.edu ece-webmaster@ncsu.edu]. You will need to include:
| |
| − | <ol>
| |
| − | <li>Name of the project.</li>
| |
| − | <li>Names and Unity IDs of project participants.</li>
| |
| − | <li>Names and Unity IDs of those who will have access to the database (if different from 3.)</li>
| |
| − | <li>How project relates to ECE.</li>
| |
| − | </ol>
| |
| − |
| |
| − | ===Format===
| |
| − | All databases are assigned three username/password combinations with the following attributes:
| |
| − |
| |
| − | <database name>-rd : SELECT<br />
| |
| − | Use in code when page will be used only to retrieve information from database.<br />
| |
| − | <database name>-wrt : SELECT, INSERT, UPDATE, DELETE<br />
| |
| − | Use in code when page will be used to make changes to database.<br />
| |
| − | <database name>-adm : SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP<br />
| |
| − | Use only for logging into PHPMyAdmin to set-up database structure. NEVER USE IN CODE.
| |
| − | ===Deactivation===
| |
| − | Administrative (-adm) accounts are deactivated upon completion of the project. Read (-rd) and write (-wrt) accounts may remain active as long as the completed project requires.
| |
Revision as of 16:36, 21 June 2006
WolfTech Accounts and Policies
Split into subpages, and combine in the Policy page links.
MySQL Account
