SQL

CREATE TABLE `origen_radio` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`citizenid` VARCHAR(200) NOT NULL COLLATE 'utf8mb4_general_ci',
	`categories` LONGTEXT NOT NULL COLLATE 'latin1_swedish_ci',
	PRIMARY KEY (`citizenid`) USING BTREE,
	INDEX `id` (`id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=9
;

CREATE TABLE `origen_radio_freqs` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`owner` VARCHAR(200) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',
	`category` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'latin1_swedish_ci',
	`freqs` LONGTEXT NOT NULL COLLATE 'latin1_swedish_ci',
	PRIMARY KEY (`id`) USING BTREE,
  	UNIQUE KEY `owner` (`owner`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=8
;

CREATE TABLE IF NOT EXISTS `origen_metadata` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;