SQL

This SQL will need to be installed before you run the script otherwise errors will

This SQL is provided with the script but is displayed below in the event you have misplaced the SQL File.

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


CREATE TABLE `sg_props` (
  `id` int(11) NOT NULL,
  `job_type` varchar(255) DEFAULT NULL,
  `prop_id` varchar(255) DEFAULT NULL,
  `prop_hash` varchar(255) DEFAULT NULL,
  `coords` varchar(255) DEFAULT NULL,
  `rotation` varchar(255) DEFAULT NULL,
  `added_by` varchar(255) DEFAULT NULL,
  `prop_heading` varchar(255) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `sg_props`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `sg_props`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;