The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
Guest
Ngentod
By Guest on 10th March 2019 01:44:20 PM | Syntax: SQL | Views: 86



New paste | Download | Show/Hide line no. | Copy text to clipboard
  1. DROP TABLE IF EXISTS `tumblr_users`;
  2.  
  3. CREATE TABLE `tumblr_users` (
  4.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  5.   `tumblr_id` VARCHAR(64) DEFAULT NULL,
  6.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  7.   `full_name` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  8.   `description` VARCHAR(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  9.   `website` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  10.   `posts` INT(11) DEFAULT NULL,
  11.   `is_adult` INT(11) DEFAULT NULL,
  12.   `is_nsfw` INT(11) DEFAULT NULL,
  13.   `ask` INT(11) DEFAULT NULL,
  14.   `ask_anon` INT(11) DEFAULT NULL,
  15.   `profile_picture_url` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  16.   `added_date` datetime DEFAULT NULL,
  17.   `last_check_date` datetime DEFAULT NULL,
  18.   `owner_user_id` INT(11) DEFAULT NULL,
  19.   PRIMARY KEY (`id`),
  20.   UNIQUE KEY `tumblr_users_id_uindex` (`id`),
  21.   KEY `username` (`username`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  23.  
  24.  
  25. DROP TABLE IF EXISTS `tumblr_logs`;
  26.  
  27. CREATE TABLE `tumblr_logs` (
  28.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  29.   `tumblr_user_id` VARCHAR(64) DEFAULT NULL,
  30.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  31.   `posts` INT(11) DEFAULT NULL,
  32.   `date` datetime DEFAULT NULL,
  33.   PRIMARY KEY (`id`),
  34.   UNIQUE KEY `tumblr_logs_id_uindex` (`id`),
  35.   KEY `username` (`username`)
  36.  
  37. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  38.  
  39.  
  40. DROP TABLE IF EXISTS `favorites`;
  41.  
  42. CREATE TABLE `favorites` (
  43.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  44.   `user_id` INT(11) DEFAULT NULL,
  45.   `source` VARCHAR(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  46.   `source_user_id` INT(11) DEFAULT NULL,
  47.   PRIMARY KEY (`id`),
  48.   UNIQUE KEY `favorites_id_uindex` (`id`)
  49. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  50.  
  51.  
  52. # Dump OF TABLE instagram_logs
  53. # ------------------------------------------------------------
  54.  
  55. DROP TABLE IF EXISTS `instagram_logs`;
  56.  
  57. CREATE TABLE `instagram_logs` (
  58.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  59.   `instagram_user_id` INT(11) DEFAULT NULL,
  60.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  61.   `followers` INT(11) DEFAULT NULL,
  62.   `following` INT(11) DEFAULT NULL,
  63.   `uploads` INT(11) DEFAULT NULL,
  64.   `date` datetime DEFAULT NULL,
  65.   PRIMARY KEY (`id`),
  66.   UNIQUE KEY `instagram_logs_id_uindex` (`id`),
  67.   KEY `username` (`username`)
  68. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  69.  
  70.  
  71. # Dump OF TABLE instagram_users
  72. # ------------------------------------------------------------
  73.  
  74. DROP TABLE IF EXISTS `instagram_users`;
  75.  
  76. CREATE TABLE `instagram_users` (
  77.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  78.   `instagram_id` VARCHAR(64) DEFAULT NULL,
  79.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  80.   `full_name` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  81.   `description` VARCHAR(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  82.   `website` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  83.   `followers` INT(11) DEFAULT NULL,
  84.   `following` INT(11) DEFAULT NULL,
  85.   `uploads` INT(11) DEFAULT NULL,
  86.   `added_date` datetime DEFAULT NULL,
  87.   `last_check_date` datetime DEFAULT NULL,
  88.   `owner_user_id` INT(11) DEFAULT '0',
  89.   `profile_picture_url` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  90.   `is_private` INT(11) DEFAULT '0',
  91.   `is_verified` INT(11) DEFAULT '0',
  92.   PRIMARY KEY (`id`),
  93.   UNIQUE KEY `instagram_users_id_uindex` (`id`),
  94.   KEY `username` (`username`)
  95. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  96.  
  97.  
  98. # Dump OF TABLE pages
  99. # ------------------------------------------------------------
  100.  
  101. DROP TABLE IF EXISTS `pages`;
  102.  
  103. CREATE TABLE `pages` (
  104.   `page_id` INT(11) NOT NULL AUTO_INCREMENT,
  105.   `title` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL,
  106.   `url` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL,
  107.   `description` text COLLATE utf8_unicode_ci NOT NULL,
  108.   `position` INT(11) NOT NULL,
  109.   PRIMARY KEY (`page_id`)
  110. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  111.  
  112.  
  113. INSERT INTO `pages` (`page_id`, `title`, `url`, `description`, `position`)
  114. VALUES
  115.         (1,'Terms of Service','terms-of-service','<p>&nbsp;</p>\r\n<p>Your terms of service go here..</p>',0);
  116.  
  117.  
  118. # Dump OF TABLE payments
  119. # ------------------------------------------------------------
  120.  
  121. DROP TABLE IF EXISTS `payments`;
  122.  
  123. CREATE TABLE `payments` (
  124.   `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  125.   `user_id` INT(11) DEFAULT NULL,
  126.   `type` enum('PAYPAL','STRIPE') DEFAULT NULL,
  127.   `payment_id` VARCHAR(64) DEFAULT NULL,
  128.   `payer_id` VARCHAR(32) DEFAULT NULL,
  129.   `email` VARCHAR(256) DEFAULT NULL,
  130.   `name` VARCHAR(256) DEFAULT NULL,
  131.   `amount` FLOAT DEFAULT NULL,
  132.   `currency` VARCHAR(4) DEFAULT NULL,
  133.   `date` datetime DEFAULT NULL,
  134.   PRIMARY KEY (`id`)
  135. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  136.  
  137.  
  138.  
  139. # Dump OF TABLE settings
  140. # ------------------------------------------------------------
  141.  
  142. DROP TABLE IF EXISTS `settings`;
  143.  
  144. CREATE TABLE `settings` (
  145.   `id` INT(11) NOT NULL,
  146.   `title` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  147.   `logo` VARCHAR(40) COLLATE utf8_unicode_ci DEFAULT '',
  148.   `time_zone` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'America/New_York',
  149.   `meta_description` VARCHAR(1024) COLLATE utf8_unicode_ci NOT NULL,
  150.   `meta_keywords` VARCHAR(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  151.   `analytics_code` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL,
  152.   `email_confirmation` INT(11) NOT NULL DEFAULT '0',
  153.   `email_pro_due_date` INT(11) DEFAULT '0',
  154.   `recaptcha` INT(11) NOT NULL DEFAULT '1',
  155.   `public_key` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  156.   `private_key` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  157.   `facebook_login` INT(11) NOT NULL,
  158.   `facebook_app_id` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  159.   `facebook_app_secret` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  160.   `instagram_login` INT(11) NOT NULL DEFAULT '0',
  161.   `instagram_client_id` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  162.   `instagram_client_secret` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  163.   `smtp_host` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL,
  164.   `smtp_port` INT(11) NOT NULL,
  165.   `smtp_encryption` VARCHAR(16) COLLATE utf8_unicode_ci DEFAULT '0',
  166.   `smtp_auth` INT(11) DEFAULT '0',
  167.   `smtp_user` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL,
  168.   `smtp_pass` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL,
  169.   `smtp_from` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL,
  170.   `facebook` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  171.   `twitter` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  172.   `youtube` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  173.   `instagram` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  174.   `store_currency` VARCHAR(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'USD',
  175.   `store_paypal_client_id` VARCHAR(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  176.   `store_paypal_secret` VARCHAR(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  177.   `store_paypal_mode` enum('sandbox', 'live') DEFAULT 'live' NULL,
  178.   `store_stripe_publishable_key` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT '',
  179.   `store_stripe_secret_key` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT '',
  180.   `store_pro_price_month` FLOAT NOT NULL DEFAULT '4.99',
  181.   `store_pro_price_year` FLOAT NOT NULL DEFAULT '19.99',
  182.   `store_pro_features` text COLLATE utf8_unicode_ci,
  183.   `user_ad` VARCHAR(2560) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  184.   `index_ad` VARCHAR(2560) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  185.   `user_live_ad` VARCHAR(2560) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  186.   `account_sidebar_ad` VARCHAR(2560) COLLATE utf8_unicode_ci DEFAULT NULL,
  187.   `instagram_check_interval` INT(11) DEFAULT '1',
  188.   `instagram_minimum_followers` INT(11) DEFAULT '5',
  189.   `instagram_live_check_interval` INT(11) DEFAULT '5',
  190.   `twitter_check_interval` INT(11) DEFAULT '1',
  191.   `twitter_minimum_followers` INT(11) DEFAULT '5',
  192.   `twitter_live_check_interval` INT(11) DEFAULT '5',
  193.   `twitter_consumer_key` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  194.   `twitter_secret_key` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  195.   `twitter_oauth_token` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  196.   `twitter_oauth_token_secret` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  197.   `twitch_client_id` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  198.   `twitch_check_interval` INT(11) DEFAULT '1',
  199.   `twitch_minimum_followers` INT(11) DEFAULT '5',
  200.   `twitch_live_check_interval` INT(11) DEFAULT '5',
  201.   `youtube_api_key` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  202.   `youtube_check_interval` INT(11) DEFAULT '1',
  203.   `youtube_minimum_subscribers` INT(11) DEFAULT '5',
  204.   `youtube_live_check_interval` INT(11) DEFAULT '5',
  205.   `tumblr_consumer_key` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  206.   `tumblr_secret_key` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  207.   `tumblr_check_interval` INT(11) DEFAULT '1',
  208.   `cron_queries` INT(11) DEFAULT '1',
  209.   PRIMARY KEY (`id`)
  210. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  211.  
  212.  
  213. INSERT INTO `settings` (`id`, `title`, `store_pro_features`, `time_zone`, `meta_description`, `meta_keywords`, `analytics_code`, `email_confirmation`, `recaptcha`, `public_key`, `private_key`, `facebook_login`, `facebook_app_id`, `facebook_app_secret`, `smtp_host`, `smtp_port`, `smtp_encryption`, `smtp_auth`, `smtp_user`, `smtp_pass`, `smtp_from`, `facebook`, `twitter`, `youtube`, `instagram`, `store_currency`, `store_paypal_client_id`, `store_paypal_secret`, `store_stripe_publishable_key`, `store_stripe_secret_key`, `user_ad`, `index_ad`, `user_live_ad`, `account_sidebar_ad`, `instagram_check_interval`, `instagram_minimum_followers`, `instagram_live_check_interval`, `twitter_check_interval`, `twitter_minimum_followers`, `twitter_live_check_interval`, `twitter_consumer_key`, `twitter_secret_key`, `twitter_oauth_token`, `twitter_oauth_token_secret`, `twitch_client_id`, `twitch_check_interval`, `twitch_minimum_followers`, `twitch_live_check_interval`, `youtube_api_key`, `youtube_check_interval`, `youtube_minimum_subscribers`, `youtube_live_check_interval`)
  214. VALUES
  215.         (1,'phpStatistics.com', '{"store_pro_features_basic":false,"store_pro_features_detailed":true,"store_pro_features_projections":true,"store_pro_features_live":true}', 'America/New_York','','','',0,0,'','',0,'','','smtp.gmail.com',587,'tls',1,'','','','','','','','USD','','','','','','','','',1,5,5,1,5,5,'','','','','',1,5,5,'',1,5,5);
  216.  
  217.  
  218. # Dump OF TABLE twitch_logs
  219. # ------------------------------------------------------------
  220.  
  221. DROP TABLE IF EXISTS `twitch_logs`;
  222.  
  223. CREATE TABLE `twitch_logs` (
  224.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  225.   `twitch_user_id` VARCHAR(64) DEFAULT NULL,
  226.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  227.   `followers` INT(11) DEFAULT NULL,
  228.   `views` BIGINT(11) DEFAULT NULL,
  229.   `date` datetime DEFAULT NULL,
  230.   PRIMARY KEY (`id`),
  231.   UNIQUE KEY `twitch_logs_id_uindex` (`id`),
  232.   KEY `username` (`username`)
  233. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  234.  
  235.  
  236. # Dump OF TABLE twitch_users
  237. # ------------------------------------------------------------
  238.  
  239. DROP TABLE IF EXISTS `twitch_users`;
  240.  
  241. CREATE TABLE `twitch_users` (
  242.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  243.   `twitch_id` VARCHAR(64) DEFAULT NULL,
  244.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  245.   `full_name` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  246.   `description` VARCHAR(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  247.   `followers` INT(11) DEFAULT NULL,
  248.   `views` BIGINT(11) DEFAULT NULL,
  249.   `profile_picture_url` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  250.   `added_date` datetime DEFAULT NULL,
  251.   `last_check_date` datetime DEFAULT NULL,
  252.   `owner_user_id` INT(11) DEFAULT NULL,
  253.   PRIMARY KEY (`id`),
  254.   UNIQUE KEY `twitch_users_id_uindex` (`id`),
  255.   KEY `username` (`username`)
  256. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  257.  
  258.  
  259.  
  260.  
  261. # Dump OF TABLE twitter_logs
  262. # ------------------------------------------------------------
  263.  
  264. DROP TABLE IF EXISTS `twitter_logs`;
  265.  
  266. CREATE TABLE `twitter_logs` (
  267.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  268.   `twitter_user_id` INT(11) DEFAULT NULL,
  269.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  270.   `followers` INT(11) DEFAULT NULL,
  271.   `following` INT(11) DEFAULT NULL,
  272.   `tweets` INT(11) DEFAULT NULL,
  273.   `likes` INT(11) DEFAULT NULL,
  274.   `date` datetime DEFAULT NULL,
  275.   PRIMARY KEY (`id`),
  276.   UNIQUE KEY `twitter_logs_id_uindex` (`id`),
  277.   KEY `username` (`username`)
  278. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  279.  
  280.  
  281. # Dump OF TABLE twitter_users
  282. # ------------------------------------------------------------
  283.  
  284. DROP TABLE IF EXISTS `twitter_users`;
  285.  
  286. CREATE TABLE `twitter_users` (
  287.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  288.   `twitter_id` INT(11) DEFAULT NULL,
  289.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  290.   `full_name` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  291.   `description` VARCHAR(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  292.   `location` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  293.   `website` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  294.   `followers` INT(11) DEFAULT NULL,
  295.   `following` INT(11) DEFAULT NULL,
  296.   `tweets` INT(11) DEFAULT NULL,
  297.   `likes` INT(11) DEFAULT NULL,
  298.   `profile_picture_url` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  299.   `profile_banner_url` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  300.   `is_verified` INT(11) DEFAULT '0',
  301.   `is_protected` INT(11) DEFAULT '0',
  302.   `added_date` datetime DEFAULT NULL,
  303.   `last_check_date` datetime DEFAULT NULL,
  304.   `owner_user_id` INT(11) DEFAULT NULL,
  305.   PRIMARY KEY (`id`),
  306.   UNIQUE KEY `twitter_users_id_uindex` (`id`),
  307.   KEY `username` (`username`)
  308. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  309.  
  310.  
  311.  
  312.  
  313. # Dump OF TABLE users
  314. # ------------------------------------------------------------
  315.  
  316. DROP TABLE IF EXISTS `users`;
  317.  
  318. CREATE TABLE `users` (
  319.   `user_id` INT(11) NOT NULL AUTO_INCREMENT,
  320.   `username` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL,
  321.   `password` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL,
  322.   `email` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL,
  323.   `name` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL,
  324.   `facebook_id` BIGINT(20) DEFAULT NULL,
  325.   `instagram_id` BIGINT(20) DEFAULT NULL,
  326.   `token_code` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT '',
  327.   `email_activation_code` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT '',
  328.   `lost_password_code` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT '',
  329.   `type` INT(11) NOT NULL DEFAULT '0',
  330.   `active` INT(11) NOT NULL DEFAULT '0',
  331.   `date` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT '',
  332.   `last_activity` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT '',
  333.   `points` FLOAT NOT NULL DEFAULT '0',
  334.   `pro` INT(11) DEFAULT '0',
  335.   `pro_due_date` datetime DEFAULT NULL,
  336.   `pro_due_date_notified` INT(11) DEFAULT '0',
  337.   PRIMARY KEY (`user_id`)
  338. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  339.  
  340. INSERT INTO `users` (`user_id`, `username`, `password`, `email`, `name`, `facebook_id`, `email_activation_code`, `lost_password_code`, `type`, `active`, `date`, `last_activity`, `points`)
  341. VALUES
  342.         (1,'admin','$2y$10$uFNO0pQKEHSFcus1zSFlveiPCB3EvG9ZlES7XKgJFTAl5JbRGFCWy','mail@gmail.com','Admin',NULL,'','0',2,1,'','1515749050',100);
  343.  
  344.  
  345.  
  346. # Dump OF TABLE youtube_logs
  347. # ------------------------------------------------------------
  348.  
  349. DROP TABLE IF EXISTS `youtube_logs`;
  350.  
  351. CREATE TABLE `youtube_logs` (
  352.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  353.   `youtube_user_id` VARCHAR(64) DEFAULT NULL,
  354.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  355.   `subscribers` INT(11) DEFAULT NULL,
  356.   `views` BIGINT(11) DEFAULT NULL,
  357.   `videos` INT(11) DEFAULT NULL,
  358.   `date` datetime DEFAULT NULL,
  359.   PRIMARY KEY (`id`),
  360.   UNIQUE KEY `youtube_logs_id_uindex` (`id`),
  361.   KEY `username` (`username`)
  362. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  363.  
  364.  
  365.  
  366. # Dump OF TABLE youtube_users
  367. # ------------------------------------------------------------
  368.  
  369. DROP TABLE IF EXISTS `youtube_users`;
  370.  
  371. CREATE TABLE `youtube_users` (
  372.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  373.   `youtube_id` VARCHAR(64) DEFAULT NULL,
  374.   `username` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  375.   `title` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  376.   `description` VARCHAR(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
  377.   `profile_picture_url` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  378.   `subscribers` INT(11) DEFAULT NULL,
  379.   `views` BIGINT(11) DEFAULT NULL,
  380.   `videos` INT(11) DEFAULT NULL,
  381.   `owner_user_id` INT(11) DEFAULT '0',
  382.   `added_date` datetime DEFAULT NULL,
  383.   `last_check_date` datetime DEFAULT NULL,
  384.   PRIMARY KEY (`id`),
  385.   UNIQUE KEY `youtube_users_id_uindex` (`id`),
  386.   KEY `username` (`username`)
  387. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



  • Recent Pastes
  • Jutt
    6 hours 4 mins 8 secs ago
  • Deneme
    6 hours 20 mins 29 secs ago
  • Jxixx
    9 hours 56 mins 4 secs ago
  • Jxixx
    9 hours 56 mins 13 secs ago
  • Payments Proof
    18 hours 9 mins 28 secs ago