SQL

This SQL file must be inserted when setting up the script. Ensure that you use the appropriate database for your framework.

CREATE TABLE `origen_dealerships` (
  `id` mediumtext DEFAULT NULL,
  `label` mediumtext DEFAULT NULL,
  `markers` longtext DEFAULT NULL,
  `stocks` longtext DEFAULT NULL,
  `settings` longtext DEFAULT NULL,
  `createdat` datetime DEFAULT CURRENT_TIMESTAMP,
  `updatedat` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `origen_dealerships_financing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `playeridentifier` mediumtext DEFAULT NULL,
  `dealershipid` mediumtext DEFAULT NULL,
  `vehicle` mediumtext DEFAULT NULL,
  `plate` mediumtext DEFAULT NULL,
  `cuoteprice` int(11) DEFAULT NULL,
  `cuotes` int(11) DEFAULT NULL,
  `nextpaymentdate` datetime DEFAULT NULL,
  `status` mediumtext DEFAULT NULL,
  `delayed_payments` int(11) DEFAULT 0,
  `createdat` datetime DEFAULT CURRENT_TIMESTAMP,
  `updatedat` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;