• XSS.stack #1 – первый литературный журнал от юзеров форума

SQL Database Instagram [50M Dump]

its is split sql file. it is text so open as you do with text files.
guesing all files need to be put together for full dump file

SQL:
-- Dumping structure for table influentia.abonne2
CREATE TABLE IF NOT EXISTS `abonne2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `idInsta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nom` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nbFollowers` int(11) DEFAULT NULL,
  `nbFollowings` int(11) DEFAULT NULL,
  `nbPosts` int(11) DEFAULT NULL,
  `biography` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `lastUpdate` int(11) DEFAULT NULL,
  `pro` int(11) DEFAULT NULL,
  `private` int(11) DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `langue` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `genre` int(11) DEFAULT NULL,
  `scriptGenrePasse` int(11) DEFAULT NULL,
  `localisation` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `identifiant` bigint(20) DEFAULT NULL,
  `usedScript4` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `grande_ville_id` int(11) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_A71E7E9AB96C1A39` (`idInsta`),
  KEY `IDX_A71E7E9A12469DE2` (`category_id`),
  KEY `IDX_A71E7E9AAFDEF94D` (`grande_ville_id`),
  CONSTRAINT `FK_A71E7E9A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK_A71E7E9AAFDEF94D` FOREIGN KEY (`grande_ville_id`) REFERENCES `grande_ville` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=340637866 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 
Последнее редактирование:
its is split sql file. it is text so open as you do with text files.
guesing all files need to be put together for full dump file

SQL:
-- Dumping structure for table influentia.abonne2
CREATE TABLE IF NOT EXISTS `abonne2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `idInsta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nom` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nbFollowers` int(11) DEFAULT NULL,
  `nbFollowings` int(11) DEFAULT NULL,
  `nbPosts` int(11) DEFAULT NULL,
  `biography` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `lastUpdate` int(11) DEFAULT NULL,
  `pro` int(11) DEFAULT NULL,
  `private` int(11) DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `langue` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `genre` int(11) DEFAULT NULL,
  `scriptGenrePasse` int(11) DEFAULT NULL,
  `localisation` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `identifiant` bigint(20) DEFAULT NULL,
  `usedScript4` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `grande_ville_id` int(11) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_A71E7E9AB96C1A39` (`idInsta`),
  KEY `IDX_A71E7E9A12469DE2` (`category_id`),
  KEY `IDX_A71E7E9AAFDEF94D` (`grande_ville_id`),
  CONSTRAINT `FK_A71E7E9A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK_A71E7E9AAFDEF94D` FOREIGN KEY (`grande_ville_id`) REFERENCES `grande_ville` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=340637866 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
How to collect the base in one base that would look readable ? We're willing to pay you for it.

What year is this database?
 


Напишите ответ...
  • Вставить:
Прикрепить файлы
Верх