Database: Difference between revisions

From Multi Theft Auto: Wiki
Jump to navigation Jump to search
(Fixed typo)
mNo edit summary
 
(3 intermediate revisions by 3 users not shown)
Line 2: Line 2:
==Files==
==Files==
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, 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, all the executeSQL* scripting functions work with this file.
*'''registry.db:''' this is the main database file, the scripting function [[executeSQLQuery]] work with this file.


==Functions==
==Functions==
{{SQL_functions}}
{{SQL_functions}}
[[Category:Scripting Concepts]]

Latest revision as of 10:54, 13 July 2024

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