This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on May 23rd, 2013  |  syntax: None  |  size: 6.21 KB  |  views: 29  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  2. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  3. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  4. /*Table structure for table `WC_ip` */
  5.  
  6. DROP TABLE IF EXISTS `WC_ip`;
  7.  
  8. CREATE TABLE `WC_ip` (
  9.   `id` int(11) NOT NULL AUTO_INCREMENT,
  10.  
  11. etc etc .. =)
  12.  
  13.   `activity_date` date DEFAULT NULL,
  14.   UNIQUE KEY `userid_game_installAge` (`userid`,`game`,`install_age`),
  15.   PRIMARY KEY (`id`)
  16. ) ENGINE=MyISAM AUTO_INCREMENT=45750081 DEFAULT CHARSET=latin1;
  17.  
  18. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  19. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  20. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  21.  
  22. INSERT INTO `bi_user_daily` VALUES (1,1512489,'WC','1','GR','100001229652633','asfdasdf','http://www.facebook.com/asfdasdfasdffgdf','notif','gghgf','Secondary Paid Direct','2012-01-02',0,0,0.00,0,0,0,0,194,0,0,1325491229,'Google Chrome','16.0.912.63','windows','GR','178.146.208.153',0,1325491253,24,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'incomplete',91,2,1914,2,1,3.23,0,NULL,NULL,NULL,NULL,0,'2012-01-03','2012-01-03 07:06:57','2012-01-02'),
  23.  
  24. (2,1512490,'WC','1','TW','453','asdf','http://www.facebook.com/profile.php?id=blachdfhjdfkh','dfdsfg','','Primary Paid','2012-01-02',0,0,0.00,0,0,0,0,394,0,0,1325491233,'Google Chrome','16.0.912.63','windows','TW','114.41.159.234',0,1325491258,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'complete',120,2,2302,2,1,6.57,0,NULL,NULL,NULL,NULL,0,'2012-01-03','2012-01-03 07:06:57','2012-01-02'),
  25.  
  26. (3,1512491,'WC','1','','1590571243','','','notif','asfd','Secondary Paid Direct','2012-01-02',0,0,0.00,0,0,0,0,0,0,0,34535,'Mozilla Firefox','9.0.1','windows','-','10.54.48.31',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0.00,0,NULL,NULL,NULL,NULL,0,'2012-01-03','2012-01-03 07:06:57','2012-01-02')
  27.  
  28. CREATE TABLE `bi_user_daily` (
  29.   `id` int(11) NOT NULL AUTO_INCREMENT,
  30.   `userid` bigint(20) DEFAULT NULL,
  31.   `game` varchar(45) DEFAULT NULL,
  32.   `main.install_today` varchar(45) DEFAULT NULL,
  33.   `main.country` text,
  34.   `main.fbid` varchar(50) DEFAULT NULL,
  35.   `main.photo` text,
  36.   `main.main.url` text,
  37.   `main.fromstr` varchar(50) DEFAULT NULL,
  38.   `main.sourcestr` varchar(50) DEFAULT NULL,
  39.   `main.user_type` varchar(50) DEFAULT NULL,
  40.   `main.install_date_pst` date DEFAULT NULL,
  41.   `main.install_hour_pst` int(11) DEFAULT NULL,
  42.   `main.revenue_primary` int(11) DEFAULT NULL,
  43.   `main.revenue_secondary` decimal(10,2) DEFAULT NULL,
  44.   `main.trans_primary` int(11) DEFAULT NULL,
  45.   `main.trans_secondary` int(11) DEFAULT NULL,
  46.   `main.direct_installs_generated` int(11) DEFAULT NULL,
  47.   `main.indirect_installs_generated` int(11) DEFAULT NULL,
  48.   `main.timeplayed_total` int(11) DEFAULT NULL,
  49.   `main.gift_sent_total` int(11) DEFAULT NULL,
  50.   `main.monetized` int(11) DEFAULT NULL,
  51.   `install.usercreate_time` int(11) DEFAULT NULL,
  52.   `install.browser` varchar(75) DEFAULT NULL,
  53.   `install.browser_version` varchar(50) DEFAULT NULL,
  54.   `install.os` varchar(50) DEFAULT NULL,
  55.   `install.ip_address_country` varchar(50) DEFAULT NULL,
  56.   `install.ip_address` varchar(50) DEFAULT NULL,
  57.   `install.noload` int(11) DEFAULT NULL,
  58.   `install.f.reate_time` int(11) DEFAULT NULL,
  59.   `install.load_duration` int(11) DEFAULT NULL,
  60.   `l.f.time_saved` int(11) DEFAULT NULL,
  61.   `l.f.playerLevel` int(11) DEFAULT NULL,
  62.   `l.f.daysSinceInstall` int(11) DEFAULT NULL,
  63.   `l.f.resource1` int(11) DEFAULT NULL,
  64.   `l.f.resource2` int(11) DEFAULT NULL,
  65.   `l.f.resource3` int(11) DEFAULT NULL,
  66.   `l.f.resource4` int(11) DEFAULT NULL,
  67.   `l.f.f.epairTime` int(11) DEFAULT NULL,
  68.   `l.f.dockRepairTime` int(11) DEFAULT NULL,
  69.   `l.f.fleetRepairTime` int(11) DEFAULT NULL,
  70.   `l.f.maxResearchTime` int(11) DEFAULT NULL,
  71.   `l.f.shipBuildTime` int(11) DEFAULT NULL,
  72.   `l.f.buildingUpgradeTime` int(11) DEFAULT NULL,
  73.   `l.f.numf.Uncovered` int(11) DEFAULT NULL,
  74.   `l.f.attackablef.Uncovered` int(11) DEFAULT NULL,
  75.   `l.f.numTerrainsUncovered` int(11) DEFAULT NULL,
  76.   `l.f.numFleets` int(11) DEFAULT NULL,
  77.   `l.f.battlesWon` int(11) DEFAULT NULL,
  78.   `l.f.battlesTotal` int(11) DEFAULT NULL,
  79.   `l.f.numf.ttacks` int(11) DEFAULT NULL,
  80.   `l.f.numf.efends` int(11) DEFAULT NULL,
  81.   `l.f.totalResourcesCombat` int(11) DEFAULT NULL,
  82.   `l.f.totalResourcesProduced` int(11) DEFAULT NULL,
  83.   `l.f.bubbleTimeLeft` int(11) DEFAULT NULL,
  84.   `l.f.FBCSpend` int(11) DEFAULT NULL,
  85.   `l.f.numFriends` int(11) DEFAULT NULL,
  86.   `l.f.numInstallsGenerated` int(11) DEFAULT NULL,
  87.   `l.f.numGiftsRecd` int(11) DEFAULT NULL,
  88.   `l.f.numChatMessagesSent` int(11) DEFAULT NULL,
  89.   `l.f.numMissionsCompleted` int(11) DEFAULT NULL,
  90.   `l.f.numAdvancedResearched` int(11) DEFAULT NULL,
  91.   `l.f.numWeaponsResearched` int(11) DEFAULT NULL,
  92.   `l.f.numArmorsResearched` int(11) DEFAULT NULL,
  93.   `l.f.numHullsResearched` int(11) DEFAULT NULL,
  94.   `l.summary.tutorial_status` varchar(50) DEFAULT NULL,
  95.   `l.summary.tutorial_stage` int(11) DEFAULT NULL,
  96.   `l.summary.user_level` int(11) DEFAULT NULL,
  97.   `l.summary.f.points` int(11) DEFAULT NULL,
  98.   `l.summary.f.loads` int(11) DEFAULT NULL,
  99.   `key_metrics.logged_in` int(11) DEFAULT NULL,
  100.   `key_metrics.timeplayed` decimal(10,2) DEFAULT NULL,
  101.   `key_metrics.revenue` int(11) DEFAULT NULL,
  102.   `virality.secondary_direct_install` int(11) DEFAULT NULL,
  103.   `virality.secondary_indirect_install` int(11) DEFAULT NULL,
  104.   `monetization.secondary_direct_revenue` decimal(10,2) DEFAULT NULL,
  105.   `monetization.secondary_indirect_revenue` decimal(10,2) DEFAULT NULL,
  106.   `install_age` int(11) DEFAULT NULL,
  107.   `record_created_date` date DEFAULT NULL,
  108.   `record_created_datetime` datetime DEFAULT NULL,
  109.   `activity_date` date DEFAULT NULL,
  110.   PRIMARY KEY (`id`),
  111.   UNIQUE KEY `userid_game_installAge` (`userid`,`game`,`install_age`)
  112. ) ENGINE=MyISAM AUTO_INCREMENT=45634650 DEFAULT CHARSET=latin1;
  113.        
  114. mysqldump -u username -p -h <db-host> --opt <db-name> -d --single-transaction | sed 's/ AUTO_INCREMENT=[0-9]*b//' > <filename>.sql
  115.        
  116. ALTER TABLE table2 AUTO_INCREMENT = 1;
clone this paste RAW Paste Data