imgazyobuzi.sql

CREATE TABLE IF NOT EXISTS `500px` (
  `id` int(11) NOT NULL,
  `image5` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `cameran` (
  `id` varchar(32) NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `canon_image_gateway` (
  `id` varchar(30) NOT NULL,
  `image` tinytext NOT NULL,
  `original` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `cloudapp` (
  `id` varchar(20) NOT NULL,
  `remote` tinytext NOT NULL,
  `thumbnail` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `dailymotion` (
  `id` varchar(255) NOT NULL,
  `thumbnail_large` tinytext NOT NULL,
  `thumbnail_medium` tinytext NOT NULL,
  `thumbnail` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `deviantart` (
  `username` varchar(20) NOT NULL,
  `id` varchar(255) NOT NULL,
  `full` tinytext NOT NULL,
  `thumbnail` tinytext NOT NULL,
  `thumbnail150` tinytext NOT NULL,
  PRIMARY KEY (`username`,`id`)
);

CREATE TABLE IF NOT EXISTS `dropbox` (
  `shorten` varchar(10) NOT NULL,
  `expanded` tinytext NOT NULL,
  PRIMARY KEY (`shorten`)
);

CREATE TABLE IF NOT EXISTS `flickr` (
  `id` bigint(20) unsigned NOT NULL,
  `thumbnail` tinytext NOT NULL,
  `medium` tinytext NOT NULL,
  `original` tinytext NOT NULL,
  PRIMARY KEY (`id`)
) ;

CREATE TABLE IF NOT EXISTS `fxcamera` (
  `id` varchar(10) NOT NULL,
  `scaled` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `gochisophoto` (
  `id` varchar(40) NOT NULL,
  `prefix` tinytext NOT NULL,
  `postfix` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `hatena_fotolife` (
  `username` varchar(32) NOT NULL,
  `id` bigint(20) unsigned NOT NULL,
  `full` tinytext NOT NULL,
  `large` tinytext NOT NULL,
  `thumb` tinytext NOT NULL,
  PRIMARY KEY (`username`,`id`)
);

CREATE TABLE IF NOT EXISTS `imepic` (
  `date` int(10) unsigned NOT NULL,
  `id` int(10) unsigned NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`date`,`id`)
);

CREATE TABLE IF NOT EXISTS `meshimazu` (
  `id` int(10) unsigned NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `movapic` (
  `id` int(10) unsigned NOT NULL,
  `expanded` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `my365` (
  `username` varchar(30) NOT NULL,
  `id` int(10) unsigned NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`username`,`id`)
);

CREATE TABLE IF NOT EXISTS `niconico` (
  `id` varchar(15) NOT NULL,
  `thumbnail` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `onedrive` (
  `id` varchar(10) NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `owly` (
  `id` varchar(10) NOT NULL,
  `original` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `path` (
  `id` varchar(10) NOT NULL,
  `prefix` tinytext NOT NULL,
  `extension` varchar(5) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `photohito` (
  `id` int(10) unsigned NOT NULL,
  `prefix` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `photomemo` (
  `id` int(10) unsigned NOT NULL,
  `filename` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `photozou` (
  `id` int(10) unsigned NOT NULL,
  `image` tinytext NOT NULL,
  `original_image` tinytext NOT NULL,
  `thumbnail_image` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `piapro` (
  `id` varchar(10) NOT NULL,
  `prefix` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `pick` (
  `id` bigint(20) unsigned NOT NULL,
  `large_size` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `pick_shorten` (
  `shorten` varchar(10) NOT NULL,
  `username` tinytext NOT NULL,
  `id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`shorten`)
);

CREATE TABLE IF NOT EXISTS `pixiv` (
  `id` int(11) NOT NULL,
  `prefix` tinytext NOT NULL,
  `extension` varchar(5) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `skydrive` (
  `id` varchar(10) NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `streamzoo` (
  `id` int(11) NOT NULL,
  `thumb` tinytext NOT NULL,
  `content` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `tinami` (
  `cont_id` int(10) unsigned NOT NULL,
  `thumbnail` tinytext NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`cont_id`)
);

CREATE TABLE IF NOT EXISTS `tumblr` (
  `id` bigint(20) unsigned NOT NULL,
  `original` tinytext NOT NULL,
  `large` tinytext NOT NULL,
  `thumb` tinytext NOT NULL,
  `video` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `tumblr_shorten` (
  `shorten` varchar(15) NOT NULL,
  `hostname` tinytext NOT NULL,
  `id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`shorten`)
);

CREATE TABLE IF NOT EXISTS `tunabe` (
  `id` varchar(10) NOT NULL,
  `org` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `twitcasting` (
  `id` int(10) unsigned NOT NULL,
  `thumbnail` tinytext NOT NULL,
  `thumbnailsmall` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `twitter` (
  `id` bigint(20) unsigned NOT NULL,
  `media` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `ustream` (
  `channel` varchar(255) NOT NULL,
  `id` bigint(20) NOT NULL,
  `small` tinytext NOT NULL,
  `medium` tinytext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `channel` (`channel`)
);

CREATE TABLE IF NOT EXISTS `vimeo` (
  `id` int(10) unsigned NOT NULL,
  `small` tinytext NOT NULL,
  `large` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `vine` (
  `id` varchar(15) NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `yfrog` (
  `hash` varchar(15) NOT NULL,
  `image` tinytext NOT NULL,
  PRIMARY KEY (`hash`)
);