'Language Reference'
Logical Operators
Relational Operators
Data Types
Column Types
Primary Keys
Functions
Where Clauses
LIKE Clauses
Limit Clauses
OrderBy Clauses
Notes
User Functions
Database Functions
Data Manipulation Functions
Table Functions
Error Handling Functions
|
When a column is created or altered, a column type can be given. One of the column types is 'type'.
'type' can be any one of the following.
Name |
Description |
'string' |
Contains one line of text, which can contain anything |
'text' |
Multiple lines of text, which can contain anything |
'int' |
An integer ranging within the limit provided by the user |
'bool' |
A boolean TRUE or FALSE |
'enum' |
A list of possible values a field can have. An 'enum' column must be provided with
'enum_values', which is an array in the format of array([$possibleValue]...). The default
value is always the trailing value. If the value doesn't match any one of the enum_val's, then
it will be replaced with the default value. |
'date' |
A 10 digit integer representing the UNIX timestamp of when the record was created |
Note- The default data type is 'string'
User-Contributed Comments for: Data Types |
|
No comments found; |
|