examples

Example

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

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 '',]]
)

Example

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