Database Server

Streamlined utilities for managing database tables, triggers, and columns

JO Functions

jo.database.addColumn()

A function to create a column in a specific table if not exist

Syntax

jo.database.addColumn(tableName, name, definition)

Parameters

tableName : string

The name of the table

name : string

The name of the column

definition : string

The definition of the column

Return Value

Type : boolean

Return true if the column is created, false otherwise

Example

local isColumnAdded = jo.addColumn('table_name', 'column_name', 'INT NOT NULL DEFAULT "0" AFTER TABLE table_name')

---

jo.database.addTable()

A function to create a table if not exist

Syntax

jo.database.addTable(tableName, definition)

Parameters

tableName : string

The name of the table

definition : string

The definition of the table

Return Value

Type : boolean

Return true if the table is created, false otherwise

Example

local isTableCreated = jo.database.addTable(
  'your_table_name',
  [[id INT NOT NULL AUTO_INCREMENT,
  first_column VARCHAR(50) NOT NULL DEFAULT '',
  second_column VARCHAR(50) NOT NULL DEFAULT '',]]
)

---

jo.database.addTrigger()

A function to create a trigger if not exist

Syntax

jo.database.addTrigger(triggerName, definition)

Parameters

triggerName : string

The name of the trigger

definition : string

The definition of the trigger

Return Value

Type : boolean

Return true if the trigger is created, false otherwise

Example

local isTriggerCreated = jo.addTriggerDB(
  'the_name_of_the_trigger',
  "AFTER DELETE ON `table` FOR EACH ROW UPDATE `table2` SET column = 0 WHERE equiped_on = OLD.id"
)