Data Types Back | Forward | Home

'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

    << Last Section ( Relational Operators ) Data Types Next Section ( Column Types ) >>

    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;