SQL

SQL file for "Private Cameras"

Copy the following code and run the query in your phpMyAdmin/HeidiSQL/...:

CREATE TABLE IF NOT EXISTS `uniq_cameras` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
  `owner` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
  `data` LONGTEXT NULL DEFAULT '{}' COLLATE 'utf8mb3_general_ci',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `uniq_cameras_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cameraId` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
  `link` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
  `date` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Last updated