Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/matomo-org/matomo.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
path: root/tests/resources/piwik-1.13-dump.sql
diff options
context:
space:
mode:
authordiosmosis <benakamoorthi@fastmail.fm>2013-10-09 02:44:17 +0400
committerdiosmosis <benakamoorthi@fastmail.fm>2013-10-09 02:44:50 +0400
commit1b35ed51bf599201522c0650300b79c4f4e54cd7 (patch)
tree2f275d341f0e0c4ed71a87997b76af3c86eb17e6 /tests/resources/piwik-1.13-dump.sql
parent20cdfcf27f824fcdf8795ff39ea05dc597768b03 (diff)
Add new integration test case that makes sure piwik works w/ 1.13 data.
Notes: - Allow integration tests to compare processed files against expected files of other tests. - Allow integration tests to modify apiNotToCall.
Diffstat (limited to 'tests/resources/piwik-1.13-dump.sql')
-rw-r--r--tests/resources/piwik-1.13-dump.sql813
1 files changed, 813 insertions, 0 deletions
diff --git a/tests/resources/piwik-1.13-dump.sql b/tests/resources/piwik-1.13-dump.sql
new file mode 100644
index 0000000000..b2d6d83ede
--- /dev/null
+++ b/tests/resources/piwik-1.13-dump.sql
@@ -0,0 +1,813 @@
+-- MySQL dump 10.13 Distrib 5.5.32, for debian-linux-gnu (i686)
+--
+-- Host: localhost Database: piwik_tests
+-- ------------------------------------------------------
+-- Server version 5.5.32-0ubuntu0.12.04.1
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Current Database: `piwik_tests`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `piwik_tests` /*!40100 DEFAULT CHARACTER SET utf8 */;
+
+USE `piwik_tests`;
+
+--
+-- Table structure for table `piwiktests_access`
+--
+
+DROP TABLE IF EXISTS `piwiktests_access`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_access` (
+ `login` varchar(100) NOT NULL,
+ `idsite` int(10) unsigned NOT NULL,
+ `access` varchar(10) DEFAULT NULL,
+ PRIMARY KEY (`login`,`idsite`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_access`
+--
+
+LOCK TABLES `piwiktests_access` WRITE;
+/*!40000 ALTER TABLE `piwiktests_access` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_access` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_archive_blob_2010_03`
+--
+
+DROP TABLE IF EXISTS `piwiktests_archive_blob_2010_03`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_archive_blob_2010_03` (
+ `idarchive` int(10) unsigned NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `idsite` int(10) unsigned DEFAULT NULL,
+ `date1` date DEFAULT NULL,
+ `date2` date DEFAULT NULL,
+ `period` tinyint(3) unsigned DEFAULT NULL,
+ `ts_archived` datetime DEFAULT NULL,
+ `value` mediumblob,
+ PRIMARY KEY (`idarchive`,`name`),
+ KEY `index_period_archived` (`period`,`ts_archived`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_archive_blob_2010_03`
+--
+
+LOCK TABLES `piwiktests_archive_blob_2010_03` WRITE;
+/*!40000 ALTER TABLE `piwiktests_archive_blob_2010_03` DISABLE KEYS */;
+INSERT INTO `piwiktests_archive_blob_2010_03` VALUES (1,'Actions_actions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xn0E]yx.Q[AF&EH**ĿNB!;wh&3>O5ٛjԗz6lY\"ஶMT(~ -\\T8D4T\Zv[@HjP0!@s,lOom8!F!\0?^m\nl!9ALufl?iLS $W k^`!/nκd@;V5ƶ]wEFCZ-*TCU4eNTCJ\\g+SDQt%5\rjϩ%* \0E<(:ʌ~ޒզ\\Mh;VD{2fĂ7G#儫zm5;'),(1,'Actions_actions_26',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x]A0 e\0c{DB.& !ݦC~o}c8YTt@hoŎ|沩cih[^h>~FȼhAn$Aʇro) ĵ|E() &B\0jD㰍@*=I (u4{\ry@X'),(1,'Actions_actions_url',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xK0ɻm.nⳊ}d6bkK۱4Gf] !_NQJۜ|&{WQuM ={V\'i,Klm[sw&W4)BudK&_ezdNlQq͉\\ <\"} B+)v}>Cbb)Zu;\'a lhѕ38\'8X1P@Cz.wx5{5 %!$L}HjT;Oղn a8ANcw\n}XF3H8Lzq \Z_{U>c|i23`s>^a:W? Oik;n\rXZ'),(1,'Actions_actions_url_30',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x]OO0 ſq?¾r\'ohDVi}w \'9~/yʖ/0^4{wx `˜8(M2zt=H\Z!vZ©5]@<TX׽A<c\ZMJy -\Zkjs5l԰5ToS%gbmݷS1|s[O$rM/k'),(1,'Actions_downloads',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xE\n0eJ;{VS*R$E <rDxw4OOW&8QĂ .AI6؂7qW9s(.3{.2%'),(1,'Actions_downloads_28',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xuNA0޵5ӫg5,@cJn+z0;2$F>@AG3[cm}]s $@t%P=#n\nt)A±l²/:|\ZG@$*F)Joߡj wgM[+ J\" #KV'),(1,'Actions_outlink',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x9 @=ZEDYq%AB`b|\Z\'2sW.ϾKWU\\\0%M|Ϙ4Cp\\64ݼW|dQlt,4!t1T\Zl\nwϲYD3݄t vc'),(1,'Actions_outlink_27',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xM0De{r lK\r\rD`Kq(M=f5O+P\r\">@oAG3g^.EvjvJ!l]+@yATJ^ (cMl]IACA(x}0c\\ѼM7ε?;'),(1,'Actions_outlink_29',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x]MA0޵@Řճ\ZNCXSJ!V\Z;;3ٝad5\\zMeg.MUUm=).\0]H1ȣ !.V a}][CJ# ǐEzJ!;[Zw/R\" G'),(1,'Actions_sitesearch',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xK2δ5\0\Z'),(1,'CustomVariables_valueByName',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xK2δ5\0\Z'),(1,'DevicesDetection_brands',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;R΀{ZCdž c <R@7tgxϓ%nsҮ^Ă (wT \0WZW[wޔOֈIٮ5__/'),(1,'DevicesDetection_browsers',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;R+b\\:DwlylG\nw=>U6yij>tAoe^\"h\\jWF}MilBvu-U09'),(1,'DevicesDetection_browserVersions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;IhZWP^!\"C:Dwbq,H\r`Π{{W2e\Z? ГXv]EHƒB_8 ]VުլAu\\`1'),(1,'DevicesDetection_models',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;R΀{ZCdž c <R@7tgxϓ%nsҮ^Ă (wT \0WZW[wޔOֈIٮ5__/'),(1,'DevicesDetection_os',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;R+3l \"\"1R(\rP\0wa,dtj\'޶\r(ʼDU/t +G~lzSڢv?5 }]8k5_m0'),(1,'DevicesDetection_osVersions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;RҴ\\!$U.tԡH;1d8~ ,R@Wȇ=|.s\\ۺ V\n=_ @Q%opyb+ma(dwgUqUjA ep.y0|1'),(1,'DevicesDetection_types',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E; s;2-CHZ!ʿc ǏcG\nya&?e2}vCj\'9u`i n\0WF koyS5\"}9k\rXK/#'),(1,'Goal_1_days_until_conv',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xԱ\n1 w 8;MU]8Np8|w..B,%6BI&lh롞q{̓.pRU{7 tLz&Cg V\\6q E}0F6`ag0ez\ruehKMkJGḧ́yIIMGe(zEiW]\0d'),(1,'Goal_1_visits_until_conv',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x= 1 p 4tgq?8\\\\ YKxLƮ}{븩z2nO`.TszLPq_yɯ$gIlk1<\r0(`E\n,` K6XƬ\ra:^Xd42h)Yd19gQ$Y~ԖSe\" 9ZD7R'),(1,'Goal_2_days_until_conv',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xԱ\n1 w 8;MU]8Np8|w..B,%6BI&lh롞q{̓.pRU{7 tLz&Cg V\\6q E}0F6`ag0ez\ruehKMkJGḧ́yIIMGe(zEiW]\0d'),(1,'Goal_2_visits_until_conv',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x= 1 p 4tgq?8\\\\ YK\Zx(LƮ}{븩z2nO`.TSM S=]&(wBҸ/KjLxʶ `6XxY\"FmI%,cV`S`\rcz,2 H  4ɔkf,d19gH\0Y[NZ,ʯ \'R'),(1,'Goal_days_until_conv',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x= 1 p 4͵w8Tq(8pߍ%CKH BI&lh롞q{̓NpR۫w7 tL&XMH)O\"C\r} F63%L}ـzހGZ:HZSBE5fB\"GHzbz4iW.^.'),(1,'Goal_visits_until_conv',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x= @ p \\mngq/Wq(*8&dpKY[\"/#r`s:Lt/\\pR9|W41LuNPfyB2r+k*;^$/@r`E\nmI\r1+P\ZlZl5\"CmCg I^h>creQY\\ȩEIF6~`Hkx'),(1,'Provider_hostnameExt',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;R΀{ZCdž c <R@7tgxϓ%nsҮ^Ă (wT \0WZW[wޔOֈIٮ5__/'),(1,'Referers_keywordByCampaign',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xK2δ5\0\Z'),(1,'Referers_keywordBySearchEngine',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x]? @ ?م:SIa\n}w{8$<~y`qnAW7Owү޵gcFO͸hנQa$Ѐ~GLQ[ fcSf 7[5i5cqA2lm,g ?@'),(1,'Referers_keywordBySearchEngine_33',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-\n@ E%{Z7[*⾤u(] N,rO8$W\")\Z>Ag1#W.ϙb \\3ۃ>\"}OwX괕]o {Ŧl!h9-?22e'),(1,'Referers_searchEngineByKeyword',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x]\n@ %wu\\= JWC2d2@cq Ղ.nv(I? \n_\rĂ:UEۀFHрix.Z=pؔ\ZvG\ZCS6;q &Q;\'?B'),(1,'Referers_searchEngineByKeyword_35',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-@DM8Z \" +0ܿ;o2A(wugW2yJp&4 ]ZZ\'^Ѐ@p*į5ۊyg2^n61)'),(1,'Referers_type',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x;0 Kv:^Vf@rCD$*u߉C2;;`v(B.݆G>rp-<,g;\n+(uС(UM=^YI;WNKT8>0B\01_@$5%≅~\rFO4+ux$'),(1,'Referers_urlByWebsite',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xMO 0 ſKqKUȶ\nōvk//T(+aCps{gCѶyBZ#.YKQ:;+bv˱\'`GdRU\'UW&*ÿ6Pa{Gud-x^ <DJ'),(1,'Referers_urlByWebsite_38',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-NM0 +fwv1^<1I*[X)wIr%d|*O񎍢 8.k@(u]LK`\nRL{ijIl:5hТ>|Q}h[^l1!/-k*U% s !qWg1]h~oD'),(1,'UserCountry_city',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x}1@ Kwz(\ZN0\\$q\nû6ׯUr7[ë=GڍC{2$\n\n.\r#ɄD.tJ*13θp.֣tĸYtcKޖ7́GHn'),(1,'UserCountry_country',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x}\n@ %wm\\=\n\n=}w7a6ae&\n) 3]Q?zӦk$0!=t\'QWpfצID7I\0r|!)T ΐrr>ZNu8lےѧٱ5_`tIH'),(1,'UserCountry_region',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x}1@ Kwz(\ZN0\\$q\nû6ׯUr7[ë=GڍC{2$\n\n.\r#ɄD.tJ*13θp.֣tĸYtcKޖ7́GHn'),(1,'UserSettings_browser',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;IhZWP^!\"C:Dwbq,H\r`Π{{W2e\Z? ГXv]EHƒB_8 ]VުլAu\\`1'),(1,'UserSettings_browserType',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E{%ʣkШ@%(ޘf8},?an~Mv -Ă z6 ge݈=LL][J[T\n1׃S1'),(1,'UserSettings_configuration',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-\n@ E%{aff+]jAw%. ](T&:&\'q o8OyY 饅Ă ZVYi&VCsױw4uK3!S(Ru0jS7 ב7;o3'),(1,'UserSettings_language',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-\n@ E%{3oUjM,N\'xp\'-l=+LqV\r ]۴EH#z- +G~ؾEv5[#]]8k>8+~G0'),(1,'UserSettings_os',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;R+3l \"\"1R(\rP\0wa,dtj\'޶\r(ʼDU/t +G~lzSڢv?5 }]8k5_m0'),(1,'UserSettings_plugin',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xj1w{aUH2:nl4ٺ;ŋ00L1!!4ςD3CAz\" H@ ;Fb.58An\nEh³Vp[uL뵧}F;:QVЦDn3sT@_i^A BLs朔@- ?mҞ[ k0ŔMKL$fgD!t\\Z[>'),(1,'UserSettings_resolution',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 E;RI^!ʅZHQ2?9 t{|M\'.sZ{\'U =_$W\rtvx#L6z%(?ᵏlU\\SO-utȥ~h?:|91'),(1,'UserSettings_wideScreen',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x-0 ߥw6d࿫g5;)aqJ&-ۯ P+ t [x\rgrc *_gtm@)_@yy\0SZ脣YU\\Q]\ZR֯FC2:'),(1,'VisitorInterest_daysSinceLastVisit',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xԱj1 wtXٗ[)tKK)]x0=Rn8UҥKAP-F#W,[P}C=z򹂐l\nW$0ch(Nӡo}JXn҅t4ȦCno@`FH>Xh\rX X&6``#l\r;$#R,Gḧ́y$I֏QMGhDS$lZG9xo\07\''),(1,'VisitorInterest_pageGap',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x= 0rxG?.8{ICPC7p-%y%&%NKc*< &vzb1q*/@H3۸K^3S\Z^JrFh0:C\' 0 ,`ւ0 hV2|[Z>JC>'),(1,'VisitorInterest_timeGap',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x\n0 \0 x,$mmM<щÄl^{)!<xΌ2!5ý<\'`SخيaH}8g@C1d&)F%r-&1qlΑ \ZCaZ xLӢ^Ve@Wuʀ5`]̴*)\06 jPBAٽECkwHW'),(1,'VisitorInterest_visitsByVisitCount',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xԱ\n1 w 8ڻK7qVwP<pPp8|w..B,hU($(mv9q:v|NPx~&~B҄g^ lYS,`l>X|ɀ%,c6`7`6`,/dt4SBh͜1Q$Y\0`=ʤ \rl=\ZEȁ4HJ8'),(1,'VisitTime_localTime',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','xj0EE}@wl1nS\'˒~&[R$LS%a[u8F>^O~v9݃} a<ڳ4yXivYYjYfav~TwVZ[dn嫗i;N5JG]?S,R H\r\0E\0\"\0R\"\r\0R\"\0\"P3,p!.ႍ)₝)キ)䂽))I\\</ati\r\ra?< '),(1,'VisitTime_serverTime',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41','x=k0E叧s[B4D\r\ZkٯilYz:ñJKV|otJ۴)1uŤղ<)|ꆴ?.fJgMlNy e򨉥t;+uu\0v/ZKǬM6`Ʋi^J%,,,EʂUN\"O o992^m.RM@.R U\\TsZR\"uZ.b:2_1d&A68(\n\' \'049ȎC`[!s59Ȟυ)a]06at!P**'),(3,'Referers_keywordByCampaign',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42','xK2δ5\0\Z'),(3,'Referers_keywordBySearchEngine',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42','x]0 DHuB+z^!ʅJDDPU&M\n١ ]>Iz-L<.$\n\n]\'рaGLQ[ fcsf\n7[5y5FcqIb\'ؚYQA'),(3,'Referers_keywordBySearchEngine_132',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42','x-\n@ E%{Z7[*⾤u(] N,rO8$W\")\Z>Ag1#W.ϙb \\3ۃ>\"}OwX괕]o {Ŧl!h9-?22e'),(3,'Referers_searchEngineByKeyword',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42','x]A 0 Kn\\=͂łbFk]<$<D1;T|@g7G\\e<\'F#@Un@^Z,*5߲6SSUWcthӭN\ZGN7BB'),(3,'Referers_searchEngineByKeyword_134',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42','x-@DM8Z \" +0ܿ;o2A(wugW2yJp&4 ]ZZ\'^Ѐ@p*į5ۊyg2^n61)'),(3,'Referers_type',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42','x]N10 w:̀{BH uw4Y:}>ݝ,pXM}gC0B`4I^nv7&w +\\Tޖ};oiũzsuZλ}QMCވfdˁQ=l'),(3,'Referers_urlByWebsite',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42','xK2δ5\0\Z'),(5,'Actions_actions',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xN0ExF~\0J jR*T߱7M#\ZGW\Zx>zz|iV0V0P86fx/r.eJ,\Z~\\lS[,40]}mȁDg5z1gd:΃Ms@\0֏d7 &AI2\'8$A\r\nlrmQR]Bg!Oa=AHwLLXWd]3r:`ώ+\ZFuUdV}B{YH]=DQ<l*#|1\0FReu#S\Zf]\nTVc!٠2bWMBSu O#jo6:'),(5,'Actions_actions_1097',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x]N0 ~˺Yz\']M@B Pq1j,*:IPlO>s^٩kn^h>x9FQq^V\\$BJrk) \r!`(\nklV!8$&TfT88dhOoX'),(5,'Actions_actions_url',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x_O0[!\\c|YN4eB+舑%ܿwˈgl}U<׳r}PЮ13~EMjs&2BoHv\nZ1F\"N d]\0!(Γ{+\n[mEq7rGl:\'}G\0Ѳ-~p @pbK?0k{#?(kPJBJ*UB.UYdMfgrx;3A \nP8zs\r\ZoiZ_0K>4]G9-mSp 7['),(5,'Actions_actions_url_1130',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x]On K0n;Um[-Q\"BMU@`{~~ ]i lHm}$^=l?}/Ge:)4^h;QqV&[WĂT98By_W$Ed`S\\Zȍ.X\0R\\XcL\raҏYOav?\Z 5Oyk'),(5,'Actions_downloads',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xE\n0DeJh٫g^R$Ri\"!.f70#j1)iSלOW&8IĂ V֮AI.O؂qW9/b(5Y\\(,|\02'),(5,'Actions_downloads_1163',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xuNA0޵5ӫg5,@cJn <&; `OP[ s[dfk_ܾ .I3rH6Y K WK6Oa_#m Pv\"Ҧ@};=A]7m%$(}S$aK'),(5,'Actions_outlink',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x@ E{ɔvZ\'E0!1wa7!M!G R*-s=ܥ*i>@Hcn E> v^\ZP\n}NHBFq4 꾳Ypڭmg\r/d'),(5,'Actions_outlink_1196',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xEN@ q28+3 `RD_;w;fO{Le]CUb̝# ~JɋC\n&6P(M\"//d֠ʕE>1hAc[h>.  ?l'),(5,'Actions_outlink_1197',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x]MA0޵@Řճ\ZNCXSJ!&vvf30j$bϞ\\8.}۲{R]\0b5.+C*|l@rяF&%2B8k5EFz7@k׭7T5J#yG'),(5,'Actions_sitesearch',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'CustomVariables_valueByName',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'DevicesDetection_brands',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-@ %;Rs?8+3TJÉZ޽ tlrS4F`ń^$?W6ӜHT pPq7:6Y)(.jr{/'),(5,'DevicesDetection_browsers',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-@ %;Rs?8+W)t8qC+u8ݻ@϶,\'Q|YW}ГDQtbhH\"NmQ^fGۧ̿(*)Y0j'),(5,'DevicesDetection_browserVersions',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-0CvP/i# ^]CD$\"u\\ó-V8F.#\Z\ZOѻNioȋ =H?WmAI9,a$nq\':,ht۔W*Yk1@'),(5,'DevicesDetection_models',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-@ %;Rs?8+3TJÉZ޽ tlrS4F`ń^$?W6ӜHT pPq7:6Y)(.jr{/'),(5,'DevicesDetection_os',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-@ %;Rs?8+3T *\'Nb(Rӽ; tlq93\0\Z\Z_Q?z)y1\r(4\'.t$a6zc/Otm`֣mS_Q\\r{0'),(5,'DevicesDetection_osVersions',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-\n@De{!{18Z!FSȿ)0(rD%W \ZY?z1Mm^ ГDQ犮\r(8%$Fgּ1;6%\Z>e[EE651'),(5,'DevicesDetection_types',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-;@ KvJ8+3EJÉ@p:|eيQ\0q_}1DQtZ6z, :6Y)(.\n&v|/T'),(5,'Goals_ItemsCategory',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goals_ItemsCategory_Cart',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goals_ItemsName',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goals_ItemsName_Cart',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goals_ItemsSku',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goals_ItemsSku_Cart',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goal_-1_days_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goal_-1_visits_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goal_0_days_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goal_0_visits_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Goal_1_days_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xԱ\n1 w 8;MU]8Np8|w..B,%6BI&lh롞q{̓.pRU{7 tLz&Cg V\\6q E}0F6`ag0ez\ruehKMkJGḧ́yIIMGe(zEiW]\0d'),(5,'Goal_1_visits_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x= 1 p 4tgq?8\\\\ YKxLƮ}{븩z2nO`.TszLPq_yɯ$gIlk1<\r0(`E\n,` K6XƬ\ra:^Xd42h)Yd19gQ$Y~ԖSe\" 9ZD7R'),(5,'Goal_2_days_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xԱ\n1 w 8;MU]8Np8|w..B,%6BI&lh롞q{̓.pRU{7 tLz&Cg V\\6q E}0F6`ag0ez\ruehKMkJGḧ́yIIMGe(zEiW]\0d'),(5,'Goal_2_visits_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x= 1 p 4tgq?8\\\\ YK\Zx(LƮ}{븩z2nO`.TSM S=]&(wBҸ/KjLxʶ `6XxY\"FmI%,cV`S`\rcz,2 H  4ɔkf,d19gH\0Y[NZ,ʯ \'R'),(5,'Goal_days_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x= 1 p 4͵w8Tq(8pߍ%CKH BI&lh롞q{̓NpR۫w7 tL&XMH)O\"C\r} F63%L}ـzހGZ:HZSBE5fB\"GHzbz4iW.^.'),(5,'Goal_visits_until_conv',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x= @ p \\mngq/Wq(*8&dpKY[\"/#r`s:Lt/\\pR9|W41LuNPfyB2r+k*;^$/@r`E\nmI\r1+P\ZlZl5\"CmCg I^h>creQY\\ȩEIF6~`Hkx'),(5,'Provider_hostnameExt',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-@ %;Rs?8+3TJÉZ޽ tlrS4F`ń^$?W6ӜHT pPq7:6Y)(.jr{/'),(5,'Referers_keywordByCampaign',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xK2δ5\0\Z'),(5,'Referers_keywordBySearchEngine',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x]\n@oVр+\"]bfaoXPlAwԏtcуDQouW)nAD2DqT]n#|[ICWr[i5\rP[xdP(M,\' _&Ao'),(5,'Referers_keywordBySearchEngine_1294',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-M 0Dޅ~^=Qzfk2Z$E\'=謳>|*c9R,X;k{PX\nz}]\'V%^mq϶Wljv 8\rRsa2'),(5,'Referers_searchEngineByKeyword',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x]\n0DeB7^=Qz(w4^<, 3U,\rlgh֫v^3`ԓ(ʵ\"hnIjywu 2߭ҭ$,v9DXԤuN )K>JO\rQB'),(5,'Referers_searchEngineByKeyword_1327',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-\n@DlbζF*l4R﹋W{˰ 3f}_0\'ЋDܶ Hft~ߑNiJ^y E*1yX 1Z'),(5,'Referers_type',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x? 0ſKv}YUĽ\\C0`Cw7\n8]xȏa0;\0jnrn#CwO\n(ˋAE+(u2-5ʦC-:ԥRZEu2zYCZRI#$PI`7SRPz<W8x'),(5,'Referers_urlByWebsite',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xMN\n@ ܕfMU{IW\nU쿛V0 L\"dhT\\I>r.6@H[ Be a HJT3ܴ\'@E8(*^\'1ipq\rM;n\\ Q6S:dqv-nf D'),(5,'Referers_urlByWebsite_1392',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x%MM0 +dwv1^<1I*[X)w{}mP$!W`79OsFl5adarXB#cZSؒb\"`z\rdYi7ACQ>q1!e.`+ˬb^E| !i1QmD'),(5,'UserCountry_city',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x}N@ HuVf@JÉJ ԡ\'镕gbQ\\-:CqX\'{I(]נQa$PH\"Žp2TѸ6pبqE[9X\n\\뼺6ޔ f>/%H'),(5,'UserCountry_country',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x}N\n0 ܅ݦKUtB lnΫhˋ5PgŽ qi;/v!!2xM\r^qPr֡Rk` [o4];NXS*uVY(79Y;4,Iy'),(5,'UserCountry_region',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x}N@ HuVf@JÉJ ԡ\'镕gbQ\\-:CqX\'{I(]נQa$PH\"Žp2TѸ6pبqE[9X\n\\뼺6ޔ f>/%H'),(5,'UserSettings_browser',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-0CvP/i# ^]CD$\"u\\ó-V8F.#\Z\ZOѻNioȋ =H?WmAI9,a$nq\':,ht۔W*Yk1@'),(5,'UserSettings_browserType',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-\n0Bi~[;tC2{iOBR8J 0WKi5DQ犾\r(#ɞ?~\0wPq7:ֱY[SER.d*1'),(5,'UserSettings_configuration',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-\n@e{!{s\ZD.l4a B#ffYC(ރgз^t</FzНDQ犐\Z40N$zm W}|H\"Fiympج۔WYҚߏ8/\03'),(5,'UserSettings_language',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-\n@ %w\'W*⽤ZaqAh}wI93\05~c{%0bBwE+zoPqJ$=L6j7@g6k=\Z6eEQ!??I1߱/tt0'),(5,'UserSettings_os',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-@ %;Rs?8+3T *\'Nb(Rӽ; tlq93\0\Z\Z_Q?z)y1\r(4\'.t$a6zc/Otm`֣mS_Q\\r{0'),(5,'UserSettings_plugin',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xj1w{aUH2:nl4ٺ;ŋ00L1!!4ςD3CAz\" H@ ;Fb.58An\nEh³Vp[uL뵧}F;:QVЦDn3sT@_i^A BLs朔@- ?mҞ[ k0ŔMKL$fgD!t\\Z[>'),(5,'UserSettings_resolution',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-\n0DeB6m8zVe=Zn73 3`|]Ӗ^IV˔Ѓ(4g)A^}PYVs-*~2D`PjcU?p _gd1'),(5,'UserSettings_wideScreen',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x-0 D;RҴ\\Vf@rCDR!ʿcCww>9\ngtk|GM4i%0Bw\n?t6$Ø(,4DQ+ޱ۔WA\\-|q2k'),(5,'VisitorInterest_daysSinceLastVisit',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xԱj1 wtXٗ[)tKK)]x0=Rn8UҥKAP-F#W,[P}C=z򹂐l\nW$0ch(Nӡo}JXn҅t4ȦCno@`FH>Xh\rX X&6``#l\r;$#R,Gḧ́y$I֏QMGhDS$lZG9xo\07\''),(5,'VisitorInterest_pageGap',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x= 0rxG?.8{ICPC7p-%y%&%NKc*< &vzb1q*/@H3۸K^3S\Z^JrFh0:C\' 0 ,`ւ0 hV2|[Z>JC>'),(5,'VisitorInterest_timeGap',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x\n0 \0 x,$mmM<щÄl^{)!<xΌ2!5ý<\'`SخيaH}8g@C1d&)F%r-&1qlΑ \ZCaZ xLӢ^Ve@Wuʀ5`]̴*)\06 jPBAٽECkwHW'),(5,'VisitorInterest_visitsByVisitCount',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xԱ\n1 w 8ڻK7qVwP<pPp8|w..B,hU($(mv9q:v|NPx~&~B҄g^ lYS,`l>X|ɀ%,c6`7`6`,/dt4SBh͜1Q$Y\0`=ʤ \rl=\ZEȁ4HJ8'),(5,'VisitTime_localTime',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','xj0E}@O,{ݦNBH+L )rpG)]L\"ŰBm1??&s/m<=k~rz9mߥw7g׳u\Zͭ|YݼBiՕ\ZK󇥒^J X*1kmO~L;a랱2<LW0S0:)L=4\0LfJ\0\03\0S&iD|V2assattau\nu%.ڢP{b큶h 8 :@|'),(5,'VisitTime_serverTime',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44','x=k0E叧sB4D\rZ+Y\nqiilYz>ñsTM<ŷc /a?wQ#̫A<(l.;5S\' yFFFz\'VstpiݥA[u=yӲ<r5j[[- VYG6AlKrbK&3SC`%0 \Z2SG`jL=ɑSGf\Z L= w|;VP\njdC1TA9R`lO!tMvRV +0.l_ Cۅ) ȓ/\'.'),(32,'Actions_actions',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xMo0 JvJ#&(Q(DЄKn`\"%rױU8ģA&_FH_lOVoj<~U/=hBBhrhCZ\n\'H:ٔJn.\0ٴ\Z&Sd\\u\'k|ꥂnPh#pɥo@\"Ip\"~R:w(t8D@D ^ƴSal+#E[d팜O\0سc%njȬ,7Ȉɺir2e(u\\vB=upӐE<,:)8FȀTrdNg5Qy.T⪩Dh6`6-'),(32,'Actions_actions_2200',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x]N0 ~˺Yz\']M@B Pq1j,*:IPlO>s^٩kn^h>x9FQq^V\\$BJrk) \r!`(\nklV!8$&TfT88dhOoX'),(32,'Actions_actions_url',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xO0w׃91tB\0˶,ߥƺFY#wP.\'. \'^u9TzS\"V7[jvmo;ЮWhLP`~0J\r9~\"f%A8Ϣ\0kت1زj\nlʺȂ|{?];s\\c\0Ď!31siȧKV*.kgjU7iօp!đ n;荢>36)l^@8ʝ7koۮj=\0#~`a[ 4a\0m\'p8@ Gig* y|['),(32,'Actions_actions_url_2209',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x]On K0n;Um[-Q\"BMU@`{~~ ]i lHm}$^=l?}/Ge:)4^h;QqV&[WĂT98By_W$Ed`S\\Zȍ.X\0R\\XcL\raҏYOav?\Z 5Oyk'),(32,'Actions_downloads',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xE\n0eJwYE TZHȻE \r()\nt S;}E֧~u: i,FW kMIFlAÍ$|5K6TTH%Y6 ̜%\02'),(32,'Actions_downloads_2218',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xuNA0޵5ӫg5,@cJn <&; `OP[ s[dfk_ܾ .I3rH6Y K WK6Oa_#m Pv\"Ҧ@};=A]7m%$(}S$aK'),(32,'Actions_outlink',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x\n@Eez>\r3ڇY1A&\\yp5QoNf2u灯\\ڪ8]Ʀ(q\r=c\Z rYY ;yI= *_2F{RA. ξ RjGnAqYp2I Fҁd'),(32,'Actions_outlink_2227',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xEN@ q28+3 `RD_;w;fO{Le]CUb̝# ~JɋC\n&6P(M\"//d֠ʕE>1hAc[h>.  ?l'),(32,'Actions_outlink_2228',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x]MA0޵@Řճ\ZNCXSJ!&vvf30j$bϞ\\8.}۲{R]\0b5.+C*|l@rяF&%2B8k5EFz7@k׭7T5J#yG'),(32,'Actions_sitesearch',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'CustomVariables_valueByName',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'DevicesDetection_brands',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-@ %;Rs?8+3TJÉZ޽ tlrS4F`ń^$?W6ӜHT pPq7:6Y)(.jr{/'),(32,'DevicesDetection_browsers',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-@ %;Rs?8+W)t8qC+u8ݻ@϶,\'Q|YW}ГDQtbhH\"NmQ^fGۧ̿(*)Y0j'),(32,'DevicesDetection_browserVersions',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-0CvP/i# ^]CD$\"u\\ó-V8F.#\Z\ZOѻNioȋ =H?WmAI9,a$nq\':,ht۔W*Yk1@'),(32,'DevicesDetection_models',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-@ %;Rs?8+3TJÉZ޽ tlrS4F`ń^$?W6ӜHT pPq7:6Y)(.jr{/'),(32,'DevicesDetection_os',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-@ %;Rs?8+3T *\'Nb(Rӽ; tlq93\0\Z\Z_Q?z)y1\r(4\'.t$a6zc/Otm`֣mS_Q\\r{0'),(32,'DevicesDetection_osVersions',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-\n@De{!{18Z!FSȿ)0(rD%W \ZY?z1Mm^ ГDQ犮\r(8%$Fgּ1;6%\Z>e[EE651'),(32,'DevicesDetection_types',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-;@ KvJ8+3EJÉ@p:|eيQ\0q_}1DQtZ6z, :6Y)(.\n&v|/T'),(32,'Goals_ItemsCategory',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goals_ItemsCategory_Cart',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goals_ItemsName',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goals_ItemsName_Cart',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goals_ItemsSku',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goals_ItemsSku_Cart',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goal_-1_days_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goal_-1_visits_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goal_0_days_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goal_0_visits_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Goal_1_days_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xԱ\n1 w 8;MU]8Np8|w..B,%6BI&lh롞q{̓.pRU{7 tLz&Cg V\\6q E}0F6`ag0ez\ruehKMkJGḧ́yIIMGe(zEiW]\0d'),(32,'Goal_1_visits_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x= 1 p 4tgq?8\\\\ YKxLƮ}{븩z2nO`.TszLPq_yɯ$gIlk1<\r0(`E\n,` K6XƬ\ra:^Xd42h)Yd19gQ$Y~ԖSe\" 9ZD7R'),(32,'Goal_2_days_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xԱ\n1 w 8;MU]8Np8|w..B,%6BI&lh롞q{̓.pRU{7 tLz&Cg V\\6q E}0F6`ag0ez\ruehKMkJGḧ́yIIMGe(zEiW]\0d'),(32,'Goal_2_visits_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x= 1 p 4tgq?8\\\\ YK\Zx(LƮ}{븩z2nO`.TSM S=]&(wBҸ/KjLxʶ `6XxY\"FmI%,cV`S`\rcz,2 H  4ɔkf,d19gH\0Y[NZ,ʯ \'R'),(32,'Goal_days_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x= 1 p 4͵w8Tq(8pߍ%CKH BI&lh롞q{̓NpR۫w7 tL&XMH)O\"C\r} F63%L}ـzހGZ:HZSBE5fB\"GHzbz4iW.^.'),(32,'Goal_visits_until_conv',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x= @ p \\mngq/Wq(*8&dpKY[\"/#r`s:Lt/\\pR9|W41LuNPfyB2r+k*;^$/@r`E\nmI\r1+P\ZlZl5\"CmCg I^h>creQY\\ȩEIF6~`Hkx'),(32,'Provider_hostnameExt',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-@ %;Rs?8+3TJÉZ޽ tlrS4F`ń^$?W6ӜHT pPq7:6Y)(.jr{/'),(32,'Referers_keywordByCampaign',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xK2δ5\0\Z'),(32,'Referers_keywordBySearchEngine',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x]\n@ f\"6Va)\"ޟ0߰\n͡3]I?za\Z$\n\nb\\&ƉdAkw$&ly[KsڊIǒesGS|m,/Ak'),(32,'Referers_keywordBySearchEngine_2253',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-M 0Dޅ~^=Qzfk2Z$E\'=謳>|*c9R,X;k{PX\nz}]\'V%^mq϶Wljv 8\rRsa2'),(32,'Referers_searchEngineByKeyword',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x]\n@ D%wImi\'W*⽤ZpXvx 3Cp :ݻl8tL`,S0\Zʵn\"h~I\'4u4:HnnP-b翩MN K~]Ԓֽ/xB'),(32,'Referers_searchEngineByKeyword_2262',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-\n@DlbζF*l4R﹋W{˰ 3f}_0\'ЋDܶ Hft~ߑNiJ^y E*1yX 1Z'),(32,'Referers_type',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x? 0ſKv}YUĽ\\C0`Cw7\n8]xȏa0;\0jnrn#CwO\n(ˋAE+(u2-5ʦC-:ԥRZEu2zYCZRI#$PI`7SRPz<W8x'),(32,'Referers_urlByWebsite',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xMN\n@ ܕfճx/ib\n=w\n&!I m\n>vGdm]V F`2˅tM0`g`ۻ (PQ*ZESuW\r<ShLscJ2×2ClBvɱC>q\0D'),(32,'Referers_urlByWebsite_2279',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x%MM0 +dwv1^<1I*[X)w{}mP$!W`79OsFl5adarXB#cZSؒb\"`z\rdYi7ACQ>q1!e.`+ˬb^E| !i1QmD'),(32,'UserCountry_city',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x}N@ HuVf@JÉJ ԡ\'镕gbQ\\-:CqX\'{I(]נQa$PH\"Žp2TѸ6pبqE[9X\n\\뼺6ޔ f>/%H'),(32,'UserCountry_country',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x}N\n0 ܅ݦKUtB lnΫhˋ5PgŽ qi;/v!!2xM\r^qPr֡Rk` [o4];NXS*uVY(79Y;4,Iy'),(32,'UserCountry_region',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x}N@ HuVf@JÉJ ԡ\'镕gbQ\\-:CqX\'{I(]נQa$PH\"Žp2TѸ6pبqE[9X\n\\뼺6ޔ f>/%H'),(32,'UserSettings_browser',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-0CvP/i# ^]CD$\"u\\ó-V8F.#\Z\ZOѻNioȋ =H?WmAI9,a$nq\':,ht۔W*Yk1@'),(32,'UserSettings_browserType',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-\n0Bi~[;tC2{iOBR8J 0WKi5DQ犾\r(#ɞ?~\0wPq7:ֱY[SER.d*1'),(32,'UserSettings_configuration',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-\n@e{!{s\ZD.l4a B#ffYC(ރgз^t</FzНDQ犐\Z40N$zm W}|H\"Fiympج۔WYҚߏ8/\03'),(32,'UserSettings_language',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-\n@ %w\'W*⽤ZaqAh}wI93\05~c{%0bBwE+zoPqJ$=L6j7@g6k=\Z6eEQ!??I1߱/tt0'),(32,'UserSettings_os',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-@ %;Rs?8+3T *\'Nb(Rӽ; tlq93\0\Z\Z_Q?z)y1\r(4\'.t$a6zc/Otm`֣mS_Q\\r{0'),(32,'UserSettings_plugin',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xj1w{aUH2:nl4ٺ;ŋ00L1!!4ςD3CAz\" H@ ;Fb.58An\nEh³Vp[uL뵧}F;:QVЦDn3sT@_i^A BLs朔@- ?mҞ[ k0ŔMKL$fgD!t\\Z[>'),(32,'UserSettings_resolution',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-\n0DeB6m8zVe=Zn73 3`|]Ӗ^IV˔Ѓ(4g)A^}PYVs-*~2D`PjcU?p _gd1'),(32,'UserSettings_wideScreen',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x-0 D;RҴ\\Vf@rCDR!ʿcCww>9\ngtk|GM4i%0Bw\n?t6$Ø(,4DQ+ޱ۔WA\\-|q2k'),(32,'VisitorInterest_daysSinceLastVisit',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xԱj1 wtXٗ[)tKK)]x0=Rn8UҥKAP-F#W,[P}C=z򹂐l\nW$0ch(Nӡo}JXn҅t4ȦCno@`FH>Xh\rX X&6``#l\r;$#R,Gḧ́y$I֏QMGhDS$lZG9xo\07\''),(32,'VisitorInterest_pageGap',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x= 0rxG?.8{ICPC7p-%y%&%NKc*< &vzb1q*/@H3۸K^3S\Z^JrFh0:C\' 0 ,`ւ0 hV2|[Z>JC>'),(32,'VisitorInterest_timeGap',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x\n0 \0 x,$mmM<щÄl^{)!<xΌ2!5ý<\'`SخيaH}8g@C1d&)F%r-&1qlΑ \ZCaZ xLӢ^Ve@Wuʀ5`]̴*)\06 jPBAٽECkwHW'),(32,'VisitorInterest_visitsByVisitCount',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xԱ\n1 w 8ڻK7qVwP<pPp8|w..B,hU($(mv9q:v|NPx~&~B҄g^ lYS,`l>X|ɀ%,c6`7`6`,/dt4SBh͜1Q$Y\0`=ʤ \rl=\ZEȁ4HJ8'),(32,'VisitTime_localTime',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','xj0E}@O,{ݦNBH+L )rpG)]L\"ŰBm1??&s/m<=k~rz9mߥw7g׳u\Zͭ|YݼBiՕ\ZK󇥒^J X*1kmO~L;a랱2<LW0S0:)L=4\0LfJ\0\03\0S&iD|V2assattau\nu%.ڢP{b큶h 8 :@|'),(32,'VisitTime_serverTime',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46','x=k0E叧sB4D\rZ+Y\nqiilYz>ñsTM<ŷc /a?wQ#̫A<(l.;5S\' yFFFz\'VstpiݥA[u=yӲ<r5j[[- VYG6AlKrbK&3SC`%0 \Z2SG`jL=ɑSGf\Z L= w|;VP\njdC1TA9R`lO!tMvRV +0.l_ Cۅ) ȓ/\'.');
+/*!40000 ALTER TABLE `piwiktests_archive_blob_2010_03` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_archive_blob_2010_04`
+--
+
+DROP TABLE IF EXISTS `piwiktests_archive_blob_2010_04`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_archive_blob_2010_04` (
+ `idarchive` int(10) unsigned NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `idsite` int(10) unsigned DEFAULT NULL,
+ `date1` date DEFAULT NULL,
+ `date2` date DEFAULT NULL,
+ `period` tinyint(3) unsigned DEFAULT NULL,
+ `ts_archived` datetime DEFAULT NULL,
+ `value` mediumblob,
+ PRIMARY KEY (`idarchive`,`name`),
+ KEY `index_period_archived` (`period`,`ts_archived`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_archive_blob_2010_04`
+--
+
+LOCK TABLES `piwiktests_archive_blob_2010_04` WRITE;
+/*!40000 ALTER TABLE `piwiktests_archive_blob_2010_04` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_archive_blob_2010_04` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_archive_numeric_2010_03`
+--
+
+DROP TABLE IF EXISTS `piwiktests_archive_numeric_2010_03`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_archive_numeric_2010_03` (
+ `idarchive` int(10) unsigned NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `idsite` int(10) unsigned DEFAULT NULL,
+ `date1` date DEFAULT NULL,
+ `date2` date DEFAULT NULL,
+ `period` tinyint(3) unsigned DEFAULT NULL,
+ `ts_archived` datetime DEFAULT NULL,
+ `value` double DEFAULT NULL,
+ PRIMARY KEY (`idarchive`,`name`),
+ KEY `index_idsite_dates_period` (`idsite`,`date1`,`date2`,`period`,`ts_archived`),
+ KEY `index_period_archived` (`period`,`ts_archived`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_archive_numeric_2010_03`
+--
+
+LOCK TABLES `piwiktests_archive_numeric_2010_03` WRITE;
+/*!40000 ALTER TABLE `piwiktests_archive_numeric_2010_03` DISABLE KEYS */;
+INSERT INTO `piwiktests_archive_numeric_2010_03` VALUES (1,'Actions_nb_downloads',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Actions_nb_hits_with_time_generation',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',4),(1,'Actions_nb_outlinks',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',3),(1,'Actions_nb_pageviews',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',4),(1,'Actions_nb_uniq_downloads',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Actions_nb_uniq_outlinks',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',2),(1,'Actions_nb_uniq_pageviews',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',4),(1,'Actions_sum_time_generation',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',0.62),(1,'bounce_count',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'bounce_count_returning',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'done',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Goal_1_conversion_rate',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',50),(1,'Goal_1_nb_conversions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Goal_1_nb_visits_converted',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Goal_1_revenue',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',42),(1,'Goal_2_conversion_rate',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',50),(1,'Goal_2_nb_conversions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Goal_2_nb_visits_converted',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Goal_2_revenue',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Goal_conversion_rate',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',100),(1,'Goal_nb_conversions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',2),(1,'Goal_nb_visits_converted',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',2),(1,'Goal_revenue',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',43),(1,'max_actions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',7),(1,'max_actions_returning',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'nb_actions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',8),(1,'nb_actions_returning',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'nb_uniq_visitors',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'nb_uniq_visitors_returning',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'nb_visits',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',2),(1,'nb_visits_converted',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',2),(1,'nb_visits_converted_returning',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'nb_visits_returning',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Referers_distinctKeywords',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Referers_distinctSearchEngines',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Referers_distinctWebsites',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'Referers_distinctWebsitesUrls',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(1,'sum_visit_length',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1621),(1,'UserCountry_distinctCountries',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:41',1),(2,'done',1,'2010-03-05','2010-03-05',1,'2013-10-08 21:55:42',1),(3,'done986ba94bab425ed6e45ffd3f8dc6572d.Referers',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(3,'Referers_distinctKeywords',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(3,'Referers_distinctSearchEngines',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(4,'bounce_count',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(4,'done986ba94bab425ed6e45ffd3f8dc6572d.VisitsSummary',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(4,'max_actions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(4,'nb_actions',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(4,'nb_uniq_visitors',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(4,'nb_visits',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(4,'nb_visits_converted',1,'2010-03-06','2010-03-06',1,'2013-10-08 21:55:42',1),(5,'Actions_nb_downloads',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Actions_nb_hits_with_time_generation',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',4),(5,'Actions_nb_outlinks',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',3),(5,'Actions_nb_pageviews',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',4),(5,'Actions_nb_uniq_downloads',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Actions_nb_uniq_outlinks',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',2),(5,'Actions_nb_uniq_pageviews',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',4),(5,'Actions_sum_time_generation',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',0.62),(5,'bounce_count',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'bounce_count_returning',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'done',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Goal_1_conversion_rate',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',50),(5,'Goal_1_nb_conversions',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Goal_1_nb_visits_converted',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Goal_1_revenue',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',42),(5,'Goal_2_conversion_rate',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',50),(5,'Goal_2_nb_conversions',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Goal_2_nb_visits_converted',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Goal_2_revenue',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Goal_conversion_rate',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',100),(5,'Goal_nb_conversions',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',2),(5,'Goal_nb_visits_converted',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',2),(5,'Goal_revenue',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',43),(5,'max_actions',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',7),(5,'max_actions_returning',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'nb_actions',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',8),(5,'nb_actions_returning',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'nb_uniq_visitors',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'nb_visits',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',2),(5,'nb_visits_converted',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',2),(5,'nb_visits_converted_returning',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'nb_visits_returning',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Referers_distinctKeywords',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Referers_distinctSearchEngines',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Referers_distinctWebsites',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'Referers_distinctWebsitesUrls',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(5,'sum_visit_length',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1621),(5,'UserCountry_distinctCountries',1,'2010-03-01','2010-03-31',3,'2013-10-08 21:55:44',1),(6,'done',1,'2010-03-04','2010-03-04',1,'2013-10-08 21:55:43',1),(7,'done',1,'2010-03-07','2010-03-07',1,'2013-10-08 21:55:43',1),(8,'done',1,'2010-03-08','2010-03-08',1,'2013-10-08 21:55:43',1),(9,'done',1,'2010-03-09','2010-03-09',1,'2013-10-08 21:55:43',1),(10,'done',1,'2010-03-10','2010-03-10',1,'2013-10-08 21:55:43',1),(11,'done',1,'2010-03-11','2010-03-11',1,'2013-10-08 21:55:43',1),(12,'done',1,'2010-03-12','2010-03-12',1,'2013-10-08 21:55:43',1),(13,'done',1,'2010-03-13','2010-03-13',1,'2013-10-08 21:55:43',1),(14,'done',1,'2010-03-14','2010-03-14',1,'2013-10-08 21:55:43',1),(15,'done',1,'2010-03-15','2010-03-15',1,'2013-10-08 21:55:43',1),(16,'done',1,'2010-03-16','2010-03-16',1,'2013-10-08 21:55:43',1),(17,'done',1,'2010-03-17','2010-03-17',1,'2013-10-08 21:55:43',1),(18,'done',1,'2010-03-18','2010-03-18',1,'2013-10-08 21:55:43',1),(19,'done',1,'2010-03-19','2010-03-19',1,'2013-10-08 21:55:43',1),(20,'done',1,'2010-03-20','2010-03-20',1,'2013-10-08 21:55:43',1),(21,'done',1,'2010-03-21','2010-03-21',1,'2013-10-08 21:55:43',1),(22,'done',1,'2010-03-22','2010-03-22',1,'2013-10-08 21:55:43',1),(23,'done',1,'2010-03-23','2010-03-23',1,'2013-10-08 21:55:43',1),(24,'done',1,'2010-03-24','2010-03-24',1,'2013-10-08 21:55:43',1),(25,'done',1,'2010-03-25','2010-03-25',1,'2013-10-08 21:55:43',1),(26,'done',1,'2010-03-26','2010-03-26',1,'2013-10-08 21:55:43',1),(27,'done',1,'2010-03-27','2010-03-27',1,'2013-10-08 21:55:44',1),(28,'done',1,'2010-03-28','2010-03-28',1,'2013-10-08 21:55:44',1),(29,'done',1,'2010-03-29','2010-03-29',1,'2013-10-08 21:55:44',1),(30,'done',1,'2010-03-30','2010-03-30',1,'2013-10-08 21:55:44',1),(31,'done',1,'2010-03-31','2010-03-31',1,'2013-10-08 21:55:44',1),(32,'Actions_nb_downloads',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Actions_nb_hits_with_time_generation',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',4),(32,'Actions_nb_outlinks',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',3),(32,'Actions_nb_pageviews',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',4),(32,'Actions_nb_uniq_downloads',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Actions_nb_uniq_outlinks',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',2),(32,'Actions_nb_uniq_pageviews',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',4),(32,'Actions_sum_time_generation',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',0.62),(32,'bounce_count',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'bounce_count_returning',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'done',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Goal_1_conversion_rate',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',50),(32,'Goal_1_nb_conversions',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Goal_1_nb_visits_converted',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Goal_1_revenue',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',42),(32,'Goal_2_conversion_rate',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',50),(32,'Goal_2_nb_conversions',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Goal_2_nb_visits_converted',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Goal_2_revenue',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Goal_conversion_rate',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',100),(32,'Goal_nb_conversions',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',2),(32,'Goal_nb_visits_converted',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',2),(32,'Goal_revenue',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',43),(32,'max_actions',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',7),(32,'max_actions_returning',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'nb_actions',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',8),(32,'nb_actions_returning',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'nb_uniq_visitors',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'nb_visits',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',2),(32,'nb_visits_converted',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',2),(32,'nb_visits_converted_returning',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'nb_visits_returning',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Referers_distinctKeywords',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Referers_distinctSearchEngines',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Referers_distinctWebsites',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'Referers_distinctWebsitesUrls',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1),(32,'sum_visit_length',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1621),(32,'UserCountry_distinctCountries',1,'2010-03-01','2010-03-07',2,'2013-10-08 21:55:46',1);
+/*!40000 ALTER TABLE `piwiktests_archive_numeric_2010_03` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_archive_numeric_2010_04`
+--
+
+DROP TABLE IF EXISTS `piwiktests_archive_numeric_2010_04`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_archive_numeric_2010_04` (
+ `idarchive` int(10) unsigned NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `idsite` int(10) unsigned DEFAULT NULL,
+ `date1` date DEFAULT NULL,
+ `date2` date DEFAULT NULL,
+ `period` tinyint(3) unsigned DEFAULT NULL,
+ `ts_archived` datetime DEFAULT NULL,
+ `value` double DEFAULT NULL,
+ PRIMARY KEY (`idarchive`,`name`),
+ KEY `index_idsite_dates_period` (`idsite`,`date1`,`date2`,`period`,`ts_archived`),
+ KEY `index_period_archived` (`period`,`ts_archived`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_archive_numeric_2010_04`
+--
+
+LOCK TABLES `piwiktests_archive_numeric_2010_04` WRITE;
+/*!40000 ALTER TABLE `piwiktests_archive_numeric_2010_04` DISABLE KEYS */;
+INSERT INTO `piwiktests_archive_numeric_2010_04` VALUES (1,'done',1,'2010-04-01','2010-04-30',3,'2013-10-08 21:55:45',1),(2,'done',1,'2010-04-01','2010-04-01',1,'2013-10-08 21:55:45',1),(3,'done',1,'2010-04-02','2010-04-02',1,'2013-10-08 21:55:45',1),(4,'done',1,'2010-04-03','2010-04-03',1,'2013-10-08 21:55:45',1),(5,'done',1,'2010-04-04','2010-04-04',1,'2013-10-08 21:55:45',1),(6,'done',1,'2010-04-05','2010-04-05',1,'2013-10-08 21:55:45',1),(7,'done',1,'2010-04-06','2010-04-06',1,'2013-10-08 21:55:45',1),(8,'done',1,'2010-04-07','2010-04-07',1,'2013-10-08 21:55:45',1),(9,'done',1,'2010-04-08','2010-04-08',1,'2013-10-08 21:55:45',1),(10,'done',1,'2010-04-09','2010-04-09',1,'2013-10-08 21:55:45',1),(11,'done',1,'2010-04-10','2010-04-10',1,'2013-10-08 21:55:45',1),(12,'done',1,'2010-04-11','2010-04-11',1,'2013-10-08 21:55:45',1),(13,'done',1,'2010-04-12','2010-04-12',1,'2013-10-08 21:55:45',1),(14,'done',1,'2010-04-13','2010-04-13',1,'2013-10-08 21:55:45',1),(15,'done',1,'2010-04-14','2010-04-14',1,'2013-10-08 21:55:45',1),(16,'done',1,'2010-04-15','2010-04-15',1,'2013-10-08 21:55:45',1),(17,'done',1,'2010-04-16','2010-04-16',1,'2013-10-08 21:55:45',1),(18,'done',1,'2010-04-17','2010-04-17',1,'2013-10-08 21:55:45',1),(19,'done',1,'2010-04-18','2010-04-18',1,'2013-10-08 21:55:45',1),(20,'done',1,'2010-04-19','2010-04-19',1,'2013-10-08 21:55:45',1),(21,'done',1,'2010-04-20','2010-04-20',1,'2013-10-08 21:55:45',1),(22,'done',1,'2010-04-21','2010-04-21',1,'2013-10-08 21:55:45',1),(23,'done',1,'2010-04-22','2010-04-22',1,'2013-10-08 21:55:45',1),(24,'done',1,'2010-04-23','2010-04-23',1,'2013-10-08 21:55:45',1),(25,'done',1,'2010-04-24','2010-04-24',1,'2013-10-08 21:55:45',1),(26,'done',1,'2010-04-25','2010-04-25',1,'2013-10-08 21:55:45',1),(27,'done',1,'2010-04-26','2010-04-26',1,'2013-10-08 21:55:45',1),(28,'done',1,'2010-04-27','2010-04-27',1,'2013-10-08 21:55:45',1),(29,'done',1,'2010-04-28','2010-04-28',1,'2013-10-08 21:55:45',1),(30,'done',1,'2010-04-29','2010-04-29',1,'2013-10-08 21:55:45',1),(31,'done',1,'2010-04-30','2010-04-30',1,'2013-10-08 21:55:45',1);
+/*!40000 ALTER TABLE `piwiktests_archive_numeric_2010_04` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_goal`
+--
+
+DROP TABLE IF EXISTS `piwiktests_goal`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_goal` (
+ `idsite` int(11) NOT NULL,
+ `idgoal` int(11) NOT NULL,
+ `name` varchar(50) NOT NULL,
+ `match_attribute` varchar(20) NOT NULL,
+ `pattern` varchar(255) NOT NULL,
+ `pattern_type` varchar(10) NOT NULL,
+ `case_sensitive` tinyint(4) NOT NULL,
+ `allow_multiple` tinyint(4) NOT NULL,
+ `revenue` float NOT NULL,
+ `deleted` tinyint(4) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`idsite`,`idgoal`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_goal`
+--
+
+LOCK TABLES `piwiktests_goal` WRITE;
+/*!40000 ALTER TABLE `piwiktests_goal` DISABLE KEYS */;
+INSERT INTO `piwiktests_goal` VALUES (1,1,'triggered js','manually','','',0,0,0,0),(1,2,'matching purchase.htm','url','(.*)store\\/purchase\\.(.*)','regex',0,0,1,0);
+/*!40000 ALTER TABLE `piwiktests_goal` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_log_action`
+--
+
+DROP TABLE IF EXISTS `piwiktests_log_action`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_log_action` (
+ `idaction` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `name` text,
+ `hash` int(10) unsigned NOT NULL,
+ `type` tinyint(3) unsigned DEFAULT NULL,
+ `url_prefix` tinyint(2) DEFAULT NULL,
+ PRIMARY KEY (`idaction`),
+ KEY `index_type_hash` (`type`,`hash`)
+) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_log_action`
+--
+
+LOCK TABLES `piwiktests_log_action` WRITE;
+/*!40000 ALTER TABLE `piwiktests_log_action` DISABLE KEYS */;
+INSERT INTO `piwiktests_log_action` VALUES (1,'incredible title!',1144878801,4,NULL),(2,'example.org/index.htm?parameter=Should display',2166859444,1,0),(3,'Second page view - should be registered as URL',2682029514,4,NULL),(4,'example.org/',1864320163,1,0),(5,'http://dev.piwik.org/svn',2559417213,2,NULL),(6,'http://piwik.org/path/again/latest.zip',28974788,3,NULL),(7,'http://outlinks.org/other_outlink',3160118093,2,NULL),(8,'Looking at homepage (again)...',3922357482,4,NULL),(9,'example.org/index.htm',1534659805,1,0),(10,'Checkout/Purchasing...',2307476306,4,NULL),(11,'example.org/store/purchase.htm',795443427,1,0);
+/*!40000 ALTER TABLE `piwiktests_log_action` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_log_conversion`
+--
+
+DROP TABLE IF EXISTS `piwiktests_log_conversion`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_log_conversion` (
+ `idvisit` int(10) unsigned NOT NULL,
+ `idsite` int(10) unsigned NOT NULL,
+ `idvisitor` binary(8) NOT NULL,
+ `server_time` datetime NOT NULL,
+ `idaction_url` int(11) DEFAULT NULL,
+ `idlink_va` int(11) DEFAULT NULL,
+ `referer_visit_server_date` date DEFAULT NULL,
+ `referer_type` int(10) unsigned DEFAULT NULL,
+ `referer_name` varchar(70) DEFAULT NULL,
+ `referer_keyword` varchar(255) DEFAULT NULL,
+ `visitor_returning` tinyint(1) NOT NULL,
+ `visitor_count_visits` smallint(5) unsigned NOT NULL,
+ `visitor_days_since_first` smallint(5) unsigned NOT NULL,
+ `visitor_days_since_order` smallint(5) unsigned NOT NULL,
+ `location_country` char(3) NOT NULL,
+ `location_region` char(2) DEFAULT NULL,
+ `location_city` varchar(255) DEFAULT NULL,
+ `location_latitude` float(10,6) DEFAULT NULL,
+ `location_longitude` float(10,6) DEFAULT NULL,
+ `url` text NOT NULL,
+ `idgoal` int(10) NOT NULL,
+ `buster` int(10) unsigned NOT NULL,
+ `idorder` varchar(100) DEFAULT NULL,
+ `items` smallint(5) unsigned DEFAULT NULL,
+ `revenue` float DEFAULT NULL,
+ `revenue_subtotal` float DEFAULT NULL,
+ `revenue_tax` float DEFAULT NULL,
+ `revenue_shipping` float DEFAULT NULL,
+ `revenue_discount` float DEFAULT NULL,
+ `custom_var_k1` varchar(200) DEFAULT NULL,
+ `custom_var_v1` varchar(200) DEFAULT NULL,
+ `custom_var_k2` varchar(200) DEFAULT NULL,
+ `custom_var_v2` varchar(200) DEFAULT NULL,
+ `custom_var_k3` varchar(200) DEFAULT NULL,
+ `custom_var_v3` varchar(200) DEFAULT NULL,
+ `custom_var_k4` varchar(200) DEFAULT NULL,
+ `custom_var_v4` varchar(200) DEFAULT NULL,
+ `custom_var_k5` varchar(200) DEFAULT NULL,
+ `custom_var_v5` varchar(200) DEFAULT NULL,
+ PRIMARY KEY (`idvisit`,`idgoal`,`buster`),
+ UNIQUE KEY `unique_idsite_idorder` (`idsite`,`idorder`),
+ KEY `index_idsite_datetime` (`idsite`,`server_time`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_log_conversion`
+--
+
+LOCK TABLES `piwiktests_log_conversion` WRITE;
+/*!40000 ALTER TABLE `piwiktests_log_conversion` DISABLE KEYS */;
+INSERT INTO `piwiktests_log_conversion` VALUES (1,1,'n5','2010-03-06 11:40:33',NULL,NULL,'2010-03-06',3,'referer.com','',0,1,0,0,'fr',NULL,NULL,NULL,NULL,'http://example.org/',1,0,NULL,NULL,42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'n5','2010-03-06 12:22:33',11,8,'2010-03-06',2,'Yahoo!','purchase',1,2,0,0,'fr',NULL,NULL,NULL,NULL,'http://example.org/store/purchase.htm',2,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+/*!40000 ALTER TABLE `piwiktests_log_conversion` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_log_conversion_item`
+--
+
+DROP TABLE IF EXISTS `piwiktests_log_conversion_item`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_log_conversion_item` (
+ `idsite` int(10) unsigned NOT NULL,
+ `idvisitor` binary(8) NOT NULL,
+ `server_time` datetime NOT NULL,
+ `idvisit` int(10) unsigned NOT NULL,
+ `idorder` varchar(100) NOT NULL,
+ `idaction_sku` int(10) unsigned NOT NULL,
+ `idaction_name` int(10) unsigned NOT NULL,
+ `idaction_category` int(10) unsigned NOT NULL,
+ `idaction_category2` int(10) unsigned NOT NULL,
+ `idaction_category3` int(10) unsigned NOT NULL,
+ `idaction_category4` int(10) unsigned NOT NULL,
+ `idaction_category5` int(10) unsigned NOT NULL,
+ `price` float NOT NULL,
+ `quantity` int(10) unsigned NOT NULL,
+ `deleted` tinyint(1) unsigned NOT NULL,
+ PRIMARY KEY (`idvisit`,`idorder`,`idaction_sku`),
+ KEY `index_idsite_servertime` (`idsite`,`server_time`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_log_conversion_item`
+--
+
+LOCK TABLES `piwiktests_log_conversion_item` WRITE;
+/*!40000 ALTER TABLE `piwiktests_log_conversion_item` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_log_conversion_item` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_log_link_visit_action`
+--
+
+DROP TABLE IF EXISTS `piwiktests_log_link_visit_action`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_log_link_visit_action` (
+ `idlink_va` int(11) unsigned NOT NULL AUTO_INCREMENT,
+ `idsite` int(10) unsigned NOT NULL,
+ `idvisitor` binary(8) NOT NULL,
+ `server_time` datetime NOT NULL,
+ `idvisit` int(10) unsigned NOT NULL,
+ `idaction_url` int(10) unsigned DEFAULT NULL,
+ `idaction_url_ref` int(10) unsigned DEFAULT '0',
+ `idaction_name` int(10) unsigned DEFAULT NULL,
+ `idaction_name_ref` int(10) unsigned NOT NULL,
+ `time_spent_ref_action` int(10) unsigned NOT NULL,
+ `custom_var_k1` varchar(200) DEFAULT NULL,
+ `custom_var_v1` varchar(200) DEFAULT NULL,
+ `custom_var_k2` varchar(200) DEFAULT NULL,
+ `custom_var_v2` varchar(200) DEFAULT NULL,
+ `custom_var_k3` varchar(200) DEFAULT NULL,
+ `custom_var_v3` varchar(200) DEFAULT NULL,
+ `custom_var_k4` varchar(200) DEFAULT NULL,
+ `custom_var_v4` varchar(200) DEFAULT NULL,
+ `custom_var_k5` varchar(200) DEFAULT NULL,
+ `custom_var_v5` varchar(200) DEFAULT NULL,
+ `custom_float` float DEFAULT NULL,
+ PRIMARY KEY (`idlink_va`),
+ KEY `index_idvisit` (`idvisit`),
+ KEY `index_idsite_servertime` (`idsite`,`server_time`)
+) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_log_link_visit_action`
+--
+
+LOCK TABLES `piwiktests_log_link_visit_action` WRITE;
+/*!40000 ALTER TABLE `piwiktests_log_link_visit_action` DISABLE KEYS */;
+INSERT INTO `piwiktests_log_link_visit_action` VALUES (1,1,'n5','2010-03-06 11:22:33',1,2,0,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,234),(2,1,'n5','2010-03-06 11:25:33',1,4,2,3,1,180,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,224),(3,1,'n5','2010-03-06 11:28:33',1,5,4,NULL,3,180,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,'n5','2010-03-06 11:34:33',1,6,5,NULL,3,360,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,'n5','2010-03-06 11:35:45',1,7,6,NULL,3,72,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,'n5','2010-03-06 11:37:33',1,5,7,NULL,3,108,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,1,'n5','2010-03-06 11:49:33',1,9,5,8,3,180,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,23),(8,1,'n5','2010-03-06 12:22:33',2,11,0,10,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,134);
+/*!40000 ALTER TABLE `piwiktests_log_link_visit_action` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_log_profiling`
+--
+
+DROP TABLE IF EXISTS `piwiktests_log_profiling`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_log_profiling` (
+ `query` text NOT NULL,
+ `count` int(10) unsigned DEFAULT NULL,
+ `sum_time_ms` float DEFAULT NULL,
+ UNIQUE KEY `query` (`query`(100))
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_log_profiling`
+--
+
+LOCK TABLES `piwiktests_log_profiling` WRITE;
+/*!40000 ALTER TABLE `piwiktests_log_profiling` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_log_profiling` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_log_visit`
+--
+
+DROP TABLE IF EXISTS `piwiktests_log_visit`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_log_visit` (
+ `idvisit` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `idsite` int(10) unsigned NOT NULL,
+ `idvisitor` binary(8) NOT NULL,
+ `visitor_localtime` time NOT NULL,
+ `visitor_returning` tinyint(1) NOT NULL,
+ `visitor_count_visits` smallint(5) unsigned NOT NULL,
+ `visitor_days_since_last` smallint(5) unsigned NOT NULL,
+ `visitor_days_since_order` smallint(5) unsigned NOT NULL,
+ `visitor_days_since_first` smallint(5) unsigned NOT NULL,
+ `visit_first_action_time` datetime NOT NULL,
+ `visit_last_action_time` datetime NOT NULL,
+ `visit_exit_idaction_url` int(11) unsigned DEFAULT '0',
+ `visit_exit_idaction_name` int(11) unsigned NOT NULL,
+ `visit_entry_idaction_url` int(11) unsigned NOT NULL,
+ `visit_entry_idaction_name` int(11) unsigned NOT NULL,
+ `visit_total_actions` smallint(5) unsigned NOT NULL,
+ `visit_total_searches` smallint(5) unsigned NOT NULL,
+ `visit_total_time` smallint(5) unsigned NOT NULL,
+ `visit_goal_converted` tinyint(1) NOT NULL,
+ `visit_goal_buyer` tinyint(1) NOT NULL,
+ `referer_type` tinyint(1) unsigned DEFAULT NULL,
+ `referer_name` varchar(70) DEFAULT NULL,
+ `referer_url` text NOT NULL,
+ `referer_keyword` varchar(255) DEFAULT NULL,
+ `config_id` binary(8) NOT NULL,
+ `config_os` char(3) NOT NULL,
+ `config_os_version` varchar(10) DEFAULT NULL,
+ `config_browser_name` varchar(10) NOT NULL,
+ `config_browser_version` varchar(20) NOT NULL,
+ `config_device_type` tinyint(10) DEFAULT NULL,
+ `config_device_brand` varchar(100) DEFAULT NULL,
+ `config_device_model` varchar(100) DEFAULT NULL,
+ `config_resolution` varchar(9) NOT NULL,
+ `config_pdf` tinyint(1) NOT NULL,
+ `config_flash` tinyint(1) NOT NULL,
+ `config_java` tinyint(1) NOT NULL,
+ `config_director` tinyint(1) NOT NULL,
+ `config_quicktime` tinyint(1) NOT NULL,
+ `config_realplayer` tinyint(1) NOT NULL,
+ `config_windowsmedia` tinyint(1) NOT NULL,
+ `config_gears` tinyint(1) NOT NULL,
+ `config_silverlight` tinyint(1) NOT NULL,
+ `config_cookie` tinyint(1) NOT NULL,
+ `location_ip` varbinary(16) NOT NULL,
+ `location_browser_lang` varchar(20) NOT NULL,
+ `location_country` char(3) NOT NULL,
+ `location_region` char(2) DEFAULT NULL,
+ `location_city` varchar(255) DEFAULT NULL,
+ `location_latitude` float(10,6) DEFAULT NULL,
+ `location_longitude` float(10,6) DEFAULT NULL,
+ `custom_var_k1` varchar(200) DEFAULT NULL,
+ `custom_var_v1` varchar(200) DEFAULT NULL,
+ `custom_var_k2` varchar(200) DEFAULT NULL,
+ `custom_var_v2` varchar(200) DEFAULT NULL,
+ `custom_var_k3` varchar(200) DEFAULT NULL,
+ `custom_var_v3` varchar(200) DEFAULT NULL,
+ `custom_var_k4` varchar(200) DEFAULT NULL,
+ `custom_var_v4` varchar(200) DEFAULT NULL,
+ `custom_var_k5` varchar(200) DEFAULT NULL,
+ `custom_var_v5` varchar(200) DEFAULT NULL,
+ PRIMARY KEY (`idvisit`),
+ KEY `index_idsite_config_datetime` (`idsite`,`config_id`,`visit_last_action_time`),
+ KEY `index_idsite_datetime` (`idsite`,`visit_last_action_time`),
+ KEY `index_idsite_idvisitor` (`idsite`,`idvisitor`)
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_log_visit`
+--
+
+LOCK TABLES `piwiktests_log_visit` WRITE;
+/*!40000 ALTER TABLE `piwiktests_log_visit` DISABLE KEYS */;
+INSERT INTO `piwiktests_log_visit` VALUES (1,1,'n5','12:34:06',0,1,0,0,0,'2010-03-06 11:22:33','2010-03-06 11:49:33',9,8,2,1,7,0,1621,1,0,3,'referer.com','http://referer.com/page.htm?param=valuewith some spaces','','|hQC^','WXP','XP','FF','3.6',0,NULL,NULL,'1024x768',0,1,1,0,0,0,0,0,0,1,'','fr','fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'n5','12:34:06',1,2,0,0,0,'2010-03-06 12:22:33','2010-03-06 12:22:33',11,10,11,10,1,0,0,1,0,2,'Yahoo!','http://search.yahoo.com/search?p=purchase','purchase','|hQC^','WXP','XP','FF','3.6',0,NULL,NULL,'1024x768',0,1,1,0,0,0,0,0,0,1,'','fr','fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+/*!40000 ALTER TABLE `piwiktests_log_visit` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_logger_api_call`
+--
+
+DROP TABLE IF EXISTS `piwiktests_logger_api_call`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_logger_api_call` (
+ `idlogger_api_call` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `class_name` varchar(255) DEFAULT NULL,
+ `method_name` varchar(255) DEFAULT NULL,
+ `parameter_names_default_values` text,
+ `parameter_values` text,
+ `execution_time` float DEFAULT NULL,
+ `caller_ip` varbinary(16) NOT NULL,
+ `timestamp` timestamp NULL DEFAULT NULL,
+ `returned_value` text,
+ PRIMARY KEY (`idlogger_api_call`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_logger_api_call`
+--
+
+LOCK TABLES `piwiktests_logger_api_call` WRITE;
+/*!40000 ALTER TABLE `piwiktests_logger_api_call` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_logger_api_call` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_logger_error`
+--
+
+DROP TABLE IF EXISTS `piwiktests_logger_error`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_logger_error` (
+ `idlogger_error` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `timestamp` timestamp NULL DEFAULT NULL,
+ `message` text,
+ `errno` int(10) unsigned DEFAULT NULL,
+ `errline` int(10) unsigned DEFAULT NULL,
+ `errfile` varchar(255) DEFAULT NULL,
+ `backtrace` text,
+ PRIMARY KEY (`idlogger_error`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_logger_error`
+--
+
+LOCK TABLES `piwiktests_logger_error` WRITE;
+/*!40000 ALTER TABLE `piwiktests_logger_error` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_logger_error` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_logger_exception`
+--
+
+DROP TABLE IF EXISTS `piwiktests_logger_exception`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_logger_exception` (
+ `idlogger_exception` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `timestamp` timestamp NULL DEFAULT NULL,
+ `message` text,
+ `errno` int(10) unsigned DEFAULT NULL,
+ `errline` int(10) unsigned DEFAULT NULL,
+ `errfile` varchar(255) DEFAULT NULL,
+ `backtrace` text,
+ PRIMARY KEY (`idlogger_exception`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_logger_exception`
+--
+
+LOCK TABLES `piwiktests_logger_exception` WRITE;
+/*!40000 ALTER TABLE `piwiktests_logger_exception` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_logger_exception` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_logger_message`
+--
+
+DROP TABLE IF EXISTS `piwiktests_logger_message`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_logger_message` (
+ `idlogger_message` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `timestamp` timestamp NULL DEFAULT NULL,
+ `message` text,
+ PRIMARY KEY (`idlogger_message`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_logger_message`
+--
+
+LOCK TABLES `piwiktests_logger_message` WRITE;
+/*!40000 ALTER TABLE `piwiktests_logger_message` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_logger_message` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_option`
+--
+
+DROP TABLE IF EXISTS `piwiktests_option`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_option` (
+ `option_name` varchar(255) NOT NULL,
+ `option_value` longtext NOT NULL,
+ `autoload` tinyint(4) NOT NULL DEFAULT '1',
+ PRIMARY KEY (`option_name`),
+ KEY `autoload` (`autoload`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_option`
+--
+
+LOCK TABLES `piwiktests_option` WRITE;
+/*!40000 ALTER TABLE `piwiktests_option` DISABLE KEYS */;
+INSERT INTO `piwiktests_option` VALUES ('lastPurge_piwiktests_archive_blob_2010_03','1381269344',0),('lastPurge_piwiktests_archive_blob_2010_04','1381269345',0),('MobileMessaging_DelegatedManagement','false',0),('SitesManager_EnableSiteSpecificUserAgentExclude','',0);
+/*!40000 ALTER TABLE `piwiktests_option` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_report`
+--
+
+DROP TABLE IF EXISTS `piwiktests_report`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_report` (
+ `idreport` int(11) NOT NULL AUTO_INCREMENT,
+ `idsite` int(11) NOT NULL,
+ `login` varchar(100) NOT NULL,
+ `description` varchar(255) NOT NULL,
+ `idsegment` int(11) DEFAULT NULL,
+ `period` varchar(10) NOT NULL,
+ `hour` tinyint(4) NOT NULL DEFAULT '0',
+ `type` varchar(10) NOT NULL,
+ `format` varchar(10) NOT NULL,
+ `reports` text NOT NULL,
+ `parameters` text,
+ `ts_created` timestamp NULL DEFAULT NULL,
+ `ts_last_sent` timestamp NULL DEFAULT NULL,
+ `deleted` tinyint(4) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`idreport`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_report`
+--
+
+LOCK TABLES `piwiktests_report` WRITE;
+/*!40000 ALTER TABLE `piwiktests_report` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_report` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_segment`
+--
+
+DROP TABLE IF EXISTS `piwiktests_segment`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_segment` (
+ `idsegment` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) NOT NULL,
+ `definition` text NOT NULL,
+ `login` varchar(100) NOT NULL,
+ `enable_all_users` tinyint(4) NOT NULL DEFAULT '0',
+ `enable_only_idsite` int(11) DEFAULT NULL,
+ `auto_archive` tinyint(4) NOT NULL DEFAULT '0',
+ `ts_created` timestamp NULL DEFAULT NULL,
+ `ts_last_edit` timestamp NULL DEFAULT NULL,
+ `deleted` tinyint(4) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`idsegment`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_segment`
+--
+
+LOCK TABLES `piwiktests_segment` WRITE;
+/*!40000 ALTER TABLE `piwiktests_segment` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_segment` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_session`
+--
+
+DROP TABLE IF EXISTS `piwiktests_session`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_session` (
+ `id` char(32) NOT NULL,
+ `modified` int(11) DEFAULT NULL,
+ `lifetime` int(11) DEFAULT NULL,
+ `data` text,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_session`
+--
+
+LOCK TABLES `piwiktests_session` WRITE;
+/*!40000 ALTER TABLE `piwiktests_session` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_session` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_site`
+--
+
+DROP TABLE IF EXISTS `piwiktests_site`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_site` (
+ `idsite` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `name` varchar(90) NOT NULL,
+ `main_url` varchar(255) NOT NULL,
+ `ts_created` timestamp NULL DEFAULT NULL,
+ `ecommerce` tinyint(4) DEFAULT '0',
+ `sitesearch` tinyint(4) DEFAULT '1',
+ `sitesearch_keyword_parameters` text NOT NULL,
+ `sitesearch_category_parameters` text NOT NULL,
+ `timezone` varchar(50) NOT NULL,
+ `currency` char(3) NOT NULL,
+ `excluded_ips` text NOT NULL,
+ `excluded_parameters` text NOT NULL,
+ `excluded_user_agents` text NOT NULL,
+ `group` varchar(250) NOT NULL,
+ `keep_url_fragment` tinyint(4) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`idsite`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_site`
+--
+
+LOCK TABLES `piwiktests_site` WRITE;
+/*!40000 ALTER TABLE `piwiktests_site` DISABLE KEYS */;
+INSERT INTO `piwiktests_site` VALUES (1,'new name','http://site.com','2010-03-05 16:22:33',0,0,'','','UTC','USD','','excluded_parameter,anotherParameter','mozilla','',0);
+/*!40000 ALTER TABLE `piwiktests_site` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_site_url`
+--
+
+DROP TABLE IF EXISTS `piwiktests_site_url`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_site_url` (
+ `idsite` int(10) unsigned NOT NULL,
+ `url` varchar(255) NOT NULL,
+ PRIMARY KEY (`idsite`,`url`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_site_url`
+--
+
+LOCK TABLES `piwiktests_site_url` WRITE;
+/*!40000 ALTER TABLE `piwiktests_site_url` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_site_url` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `piwiktests_user`
+--
+
+DROP TABLE IF EXISTS `piwiktests_user`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `piwiktests_user` (
+ `login` varchar(100) NOT NULL,
+ `password` char(32) NOT NULL,
+ `alias` varchar(45) NOT NULL,
+ `email` varchar(100) NOT NULL,
+ `token_auth` char(32) NOT NULL,
+ `date_registered` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`login`),
+ UNIQUE KEY `uniq_keytoken` (`token_auth`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `piwiktests_user`
+--
+
+LOCK TABLES `piwiktests_user` WRITE;
+/*!40000 ALTER TABLE `piwiktests_user` DISABLE KEYS */;
+/*!40000 ALTER TABLE `piwiktests_user` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2013-10-08 18:00:28
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-09 09:36:06 +0300