Database: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(updated old information containing executeSQL* functions which is deprecated) |
||
| Line 3: | Line 3: | ||
There are two main database files for storing data: | There are two main database files for storing data: | ||
*'''internal.db:''' this contains user account data (usernames, hashed passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions. | *'''internal.db:''' this contains user account data (usernames, hashed passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions. | ||
*'''registry.db:''' this is the main database file, | *'''registry.db:''' this is the main database file, the scripting function [[executeSQLQuery]] work with this file. | ||
==Functions== | ==Functions== | ||
{{SQL_functions}} | {{SQL_functions}} | ||
Revision as of 00:58, 4 July 2020
MTA uses a database system based on files. This system is sqlite, an embedded relational database management system.
Files
There are two main database files for storing data:
- internal.db: this contains user account data (usernames, hashed passwords and account data stored by using the setAccountData and getAccountData functions.
- registry.db: this is the main database file, the scripting function executeSQLQuery work with this file.
Functions