--
-- Host: localhost    Database: sliderm_rguzz
-- ------------------------------------------------------


--
-- Table structure for table `koken_albums`
--

CREATE TABLE `koken_albums` (
  `id` int(9) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `summary` varchar(255) default NULL,
  `description` text,
  `listed` tinyint(1) NOT NULL default '0',
  `level` int(11) NOT NULL default '1',
  `left_id` int(11) NOT NULL,
  `right_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  `featured` tinyint(1) NOT NULL default '0',
  `featured_on` int(10) default NULL,
  `featured_order` int(11) default NULL,
  `total_count` int(11) NOT NULL default '0',
  `video_count` int(11) NOT NULL default '0',
  `created_on` int(10) NOT NULL,
  `modified_on` int(10) NOT NULL,
  `album_type` tinyint(1) NOT NULL default '0',
  `tags` text,
  `internal_id` char(32) NOT NULL,
  `slug` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`),
  KEY `level` (`level`),
  KEY `left_id` (`left_id`),
  KEY `right_id` (`right_id`),
  KEY `total_count` (`total_count`),
  KEY `video_count` (`video_count`),
  KEY `created_on` (`created_on`),
  KEY `modified_on` (`modified_on`),
  KEY `album_type` (`album_type`),
  KEY `internal_id` (`internal_id`),
  KEY `featured_featured_order` (`featured`,`featured_order`),
  KEY `slug` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_albums`
--

INSERT INTO `koken_albums` VALUES (1,'Posters','','Poster Illustrations',1,1,3,4,0,1,1368126485,1,6,0,1368126213,1370283269,0,NULL,'540cde3fad740be791f8c92fc9f83b89','posters'),(2,'Drawings',NULL,NULL,0,1,1,2,1,0,NULL,NULL,0,0,1368127546,1372467236,0,NULL,'6c43828e7865c1821f35855cfbdb1fa2','drawings'),(3,'Photography','',NULL,1,1,1,2,0,0,NULL,NULL,3,0,1368127740,1370456544,0,NULL,'da0f7ecf91250191aab7491160796d90','photos'),(8,'Objects',NULL,NULL,0,1,1,2,0,0,NULL,NULL,1,0,1370456576,1372467236,0,NULL,'6e7719a3a8733a92d71f287f853c0fcb','objects'),(4,'Blk n Wht','',NULL,1,1,5,6,0,0,NULL,NULL,6,0,1368195902,1370283910,0,NULL,'b06fa5dadd3657f2f0f8793f812e49f0','blk-n-wht'),(7,'Nima',NULL,NULL,1,1,11,12,0,0,NULL,NULL,4,0,1370456502,1370456527,0,NULL,'4e0ebe32bbb585d0de4b53bf32180b8b','nima'),(5,'Retro',NULL,NULL,1,1,7,8,0,0,NULL,NULL,1,0,1369940857,1370283293,0,NULL,'4133158d747ad661115765b00550ffdd','retro'),(6,'Illustrations',NULL,NULL,1,1,9,10,0,0,NULL,NULL,1,0,1369940919,1370283299,0,NULL,'f5ffbb7617c71683bc6cb0714bb8c6fe','illustrations'),(9,'3D',NULL,NULL,1,1,13,14,0,0,NULL,NULL,1,0,1372467250,1372467270,0,NULL,'bfaa52fb573d3b8eb92df98fb4906169','3d');

--
-- Table structure for table `koken_applications`
--

CREATE TABLE `koken_applications` (
  `id` int(9) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `nonce` varchar(32) default NULL,
  `token` varchar(32) default NULL,
  `role` varchar(10) default 'read',
  `name` varchar(255) default NULL,
  `created_on` int(11) NOT NULL,
  `single_use` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`),
  KEY `nonce` (`nonce`),
  KEY `token` (`token`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_applications`
--


--
-- Table structure for table `koken_categories`
--

CREATE TABLE `koken_categories` (
  `id` int(9) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `album_count` int(11) NOT NULL default '0',
  `text_count` int(11) NOT NULL default '0',
  `content_count` int(11) NOT NULL default '0',
  `slug` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `album_count` (`album_count`),
  KEY `content_count` (`content_count`),
  KEY `text_count` (`text_count`),
  KEY `slug` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_categories`
--

INSERT INTO `koken_categories` VALUES (1,'Illustrations',1,0,0,'illustrations'),(2,'Posters',1,0,6,'posters'),(3,'Drawings',1,0,1,'drawings'),(4,'Photography',1,0,2,'photography'),(5,'Blk n Wht',0,0,0,'blk-n-wht');

--
-- Table structure for table `koken_content`
--

CREATE TABLE `koken_content` (
  `id` int(9) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `filename` varchar(255) default NULL,
  `caption` text,
  `visibility` tinyint(1) NOT NULL default '0',
  `max_download` tinyint(1) NOT NULL default '0',
  `license` char(3) NOT NULL default 'all',
  `deleted` tinyint(1) NOT NULL default '0',
  `featured` tinyint(1) NOT NULL default '0',
  `featured_order` int(11) default NULL,
  `favorite_order` int(11) default NULL,
  `favorite` tinyint(1) NOT NULL default '0',
  `favorited_on` int(10) default NULL,
  `featured_on` int(10) default NULL,
  `uploaded_on` int(10) NOT NULL,
  `captured_on` int(10) NOT NULL,
  `modified_on` int(10) NOT NULL,
  `file_modified_on` int(10) NOT NULL,
  `focal_point` varchar(255) default NULL,
  `filesize` int(11) NOT NULL,
  `width` int(11) default NULL,
  `height` int(11) default NULL,
  `aspect_ratio` decimal(5,3) default NULL,
  `duration` int(11) default NULL,
  `tags` text,
  `file_type` tinyint(1) NOT NULL default '0',
  `lg_preview` varchar(255) default NULL,
  `internal_id` char(32) NOT NULL,
  `iptc` text,
  `exif` text,
  `exif_make` varchar(255) default NULL,
  `exif_model` varchar(255) default NULL,
  `exif_iso` int(11) default NULL,
  `exif_camera_serial` int(11) default NULL,
  `exif_camera_lens` varchar(255) default NULL,
  `slug` varchar(255) NOT NULL,
  `old_slug` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `filename` (`filename`),
  KEY `title` (`title`),
  KEY `deleted` (`deleted`),
  KEY `uploaded_on` (`uploaded_on`),
  KEY `captured_on` (`captured_on`),
  KEY `modified_on` (`modified_on`),
  KEY `filesize` (`filesize`),
  KEY `file_type` (`file_type`),
  KEY `exif_make` (`exif_make`),
  KEY `exif_model` (`exif_model`),
  KEY `width` (`width`),
  KEY `height` (`height`),
  KEY `aspect_ratio` (`aspect_ratio`),
  KEY `featured_featured_order` (`featured`,`featured_order`),
  KEY `favorite_favorite_order` (`favorite`,`favorite_order`),
  KEY `slug` (`slug`),
  KEY `old_slug` (`old_slug`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_content`
--

INSERT INTO `koken_content` VALUES (42,NULL,'shink.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370456397,1370456397,1370456397,1370456397,NULL,110843,490,610,'0.803',NULL,NULL,0,NULL,'ac3911e99ee6e1bb3a22737b98882fe1',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:9:\"shink.jpg\";s:12:\"FileDateTime\";i:1370456397;s:8:\"FileSize\";i:110843;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"490\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:490;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'shink',''),(41,NULL,'7amuni.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370456395,1370456395,1370456395,1370456395,NULL,76866,710,460,'1.543',NULL,NULL,0,NULL,'020a952d0b0d2fce7d898aa20c888729',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:10:\"7amuni.jpg\";s:12:\"FileDateTime\";i:1370456395;s:8:\"FileSize\";i:76866;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"710\" height=\"460\"\";s:6:\"Height\";i:460;s:5:\"Width\";i:710;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'7amuni',''),(30,NULL,'church.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283857,1370283857,1370283857,1370283857,NULL,48324,410,543,'0.755',NULL,NULL,0,NULL,'2e5020fa431bd0343f3e31c7def8fbf2',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:10:\"church.jpg\";s:12:\"FileDateTime\";i:1370283857;s:8:\"FileSize\";i:48324;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"543\"\";s:6:\"Height\";i:543;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'church',''),(29,NULL,'midentidad.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283247,1370283247,1370283247,1370283247,NULL,74173,410,610,'0.672',NULL,NULL,0,NULL,'702d31e27ac1bed180488d1ca9ce40d2',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:14:\"midentidad.jpg\";s:12:\"FileDateTime\";i:1370283247;s:8:\"FileSize\";i:74173;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'midentidad',''),(28,NULL,'Maya.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283245,1370283245,1370283245,1370283245,NULL,62788,410,610,'0.672',NULL,NULL,0,NULL,'3aee174c21d64d2e1de45cc2bcd2e385',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:8:\"Maya.jpg\";s:12:\"FileDateTime\";i:1370283245;s:8:\"FileSize\";i:62788;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'maya',''),(27,NULL,'kim.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283242,1370283242,1370283242,1370283242,NULL,78036,410,610,'0.672',NULL,NULL,0,NULL,'007033b8bdd8179ecb0a74deffe808f7',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:7:\"kim.jpg\";s:12:\"FileDateTime\";i:1370283242;s:8:\"FileSize\";i:78036;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'kim',''),(26,NULL,'ElChela.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283240,1370283240,1370283240,1370283240,NULL,66021,410,610,'0.672',NULL,NULL,0,NULL,'af74c55b300458ac3422aeb82a5b8ef3',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:11:\"ElChela.jpg\";s:12:\"FileDateTime\";i:1370283240;s:8:\"FileSize\";i:66021;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'elchela',''),(40,NULL,'pelon.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370456394,1370456394,1370456394,1370456394,NULL,147442,710,410,'1.732',NULL,NULL,0,NULL,'5759a75a10be317ca55c59be33070074',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:9:\"pelon.jpg\";s:12:\"FileDateTime\";i:1370456394;s:8:\"FileSize\";i:147442;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"710\" height=\"410\"\";s:6:\"Height\";i:410;s:5:\"Width\";i:710;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'pelon',''),(39,NULL,'kim-karen.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370456391,1370456391,1370456391,1370456391,NULL,130310,610,410,'1.488',NULL,NULL,0,NULL,'1e581f661d9dc870b9f0280068b868dd',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:13:\"kim-karen.jpg\";s:12:\"FileDateTime\";i:1370456391;s:8:\"FileSize\";i:130310;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"610\" height=\"410\"\";s:6:\"Height\";i:410;s:5:\"Width\";i:610;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'kim-karen',''),(38,NULL,'karenbl.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370456389,1370456389,1370456389,1370456389,NULL,143351,510,510,'1.000',NULL,NULL,0,NULL,'193f1fe4206f6ec4740b53f1e13cc3a4',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:11:\"karenbl.jpg\";s:12:\"FileDateTime\";i:1370456389;s:8:\"FileSize\";i:143351;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"510\" height=\"510\"\";s:6:\"Height\";i:510;s:5:\"Width\";i:510;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'karenbl',''),(37,NULL,'karen.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370456387,1370456387,1370456387,1370456386,NULL,112150,460,610,'0.754',NULL,NULL,0,NULL,'efa1ddf7489c6880930c5149ac3cf168',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:9:\"karen.jpg\";s:12:\"FileDateTime\";i:1370456386;s:8:\"FileSize\";i:112150;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"460\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:460;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'karen',''),(36,NULL,'tothedoor.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283874,1370283874,1370283874,1370283874,NULL,50700,410,543,'0.755',NULL,NULL,0,NULL,'3f6134c47b0698595521b0e8dc462d20',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:13:\"tothedoor.jpg\";s:12:\"FileDateTime\";i:1370283874;s:8:\"FileSize\";i:50700;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"543\"\";s:6:\"Height\";i:543;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'tothedoor',''),(35,NULL,'saturday-sales.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283871,1370283871,1370283871,1370283871,NULL,82951,410,543,'0.755',NULL,NULL,0,NULL,'900d6e9108ac1a2643b485797d9b7be0',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:18:\"saturday-sales.jpg\";s:12:\"FileDateTime\";i:1370283871;s:8:\"FileSize\";i:82951;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"543\"\";s:6:\"Height\";i:543;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'saturday-sales',''),(34,NULL,'Pasillo.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283868,1370283868,1370283868,1370283868,NULL,89365,410,543,'0.755',NULL,NULL,0,NULL,'1834bd1db9eac258894e170a4e787244',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:11:\"Pasillo.jpg\";s:12:\"FileDateTime\";i:1370283868;s:8:\"FileSize\";i:89365;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"543\"\";s:6:\"Height\";i:543;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'pasillo',''),(24,NULL,'Canche.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283235,1370283235,1370283235,1370283235,NULL,107210,410,610,'0.672',NULL,NULL,0,NULL,'0a9bf9b6ec0851975ed2b2da8351bfc3',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:10:\"Canche.jpg\";s:12:\"FileDateTime\";i:1370283235;s:8:\"FileSize\";i:107210;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'canche',''),(25,NULL,'QueMango.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283237,1370283237,1370283237,1370283237,NULL,64622,410,610,'0.672',NULL,NULL,0,NULL,'dc26c62f9eb26f713288ec632fb8cfe7',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:12:\"QueMango.jpg\";s:12:\"FileDateTime\";i:1370283237;s:8:\"FileSize\";i:64622;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'quemango',''),(32,NULL,'fountain.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283863,1370283863,1370283863,1370283863,NULL,83189,410,543,'0.755',NULL,NULL,0,NULL,'7ff5ddfb26d0f23a67b70f47ed4c414f',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:12:\"fountain.jpg\";s:12:\"FileDateTime\";i:1370283863;s:8:\"FileSize\";i:83189;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"543\"\";s:6:\"Height\";i:543;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'fountain',''),(33,NULL,'inditas.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283865,1370283865,1370283865,1370283865,NULL,60432,410,543,'0.755',NULL,NULL,0,NULL,'2f9e48ab557e97a9442d5e8e6288f49b',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:11:\"inditas.jpg\";s:12:\"FileDateTime\";i:1370283865;s:8:\"FileSize\";i:60432;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"543\"\";s:6:\"Height\";i:543;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'inditas',''),(31,NULL,'Door.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283860,1370283860,1370283860,1370283860,NULL,81306,410,543,'0.755',NULL,NULL,0,NULL,'0efc3fc2a472e5f9f858a45094304b9e',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:8:\"Door.jpg\";s:12:\"FileDateTime\";i:1370283860;s:8:\"FileSize\";i:81306;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"410\" height=\"543\"\";s:6:\"Height\";i:543;s:5:\"Width\";i:410;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'door',''),(23,NULL,'yose.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283232,1370283232,1370283232,1370283232,NULL,95854,610,610,'1.000',NULL,NULL,0,NULL,'f10a2f39e0f2cf085cd295aa4622df0b',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:8:\"yose.jpg\";s:12:\"FileDateTime\";i:1370283232;s:8:\"FileSize\";i:95854;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"610\" height=\"610\"\";s:6:\"Height\";i:610;s:5:\"Width\";i:610;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'yose',''),(22,NULL,'keepout.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1370283229,1370283229,1370283229,1370283229,NULL,99097,610,410,'1.488',NULL,NULL,0,NULL,'2bd778f998463722c8dd80d8531545c8',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:11:\"keepout.jpg\";s:12:\"FileDateTime\";i:1370283229;s:8:\"FileSize\";i:99097;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"610\" height=\"410\"\";s:6:\"Height\";i:410;s:5:\"Width\";i:610;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'keepout',''),(43,NULL,'Elephant.jpg',NULL,0,0,'all',1,0,NULL,NULL,0,NULL,NULL,1372467144,1372467144,1372467163,1372467144,NULL,102699,900,600,'1.500',NULL,NULL,0,NULL,'a607fc29d14b9c24b6687d855d489aac',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:12:\"Elephant.jpg\";s:12:\"FileDateTime\";i:1372467144;s:8:\"FileSize\";i:102699;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"900\" height=\"600\"\";s:6:\"Height\";i:600;s:5:\"Width\";i:900;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'elephant',''),(44,NULL,'Elephant.jpg',NULL,0,0,'all',0,0,NULL,NULL,0,NULL,NULL,1372467146,1372467146,1372467146,1372467146,NULL,102699,900,600,'1.500',NULL,NULL,0,NULL,'2c3cfe92f53732103a3d04ac0c3f1dce',NULL,'a:3:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:12:\"Elephant.jpg\";s:12:\"FileDateTime\";i:1372467146;s:8:\"FileSize\";i:102699;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:11:\"IFD0, APP12\";}s:8:\"COMPUTED\";a:5:{s:4:\"html\";s:24:\"width=\"900\" height=\"600\"\";s:6:\"Height\";i:600;s:5:\"Width\";i:900;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:0;}s:5:\"APP12\";a:2:{s:7:\"Company\";s:5:\"Ducky\";s:4:\"Info\";s:1:\"\";}}',NULL,NULL,NULL,NULL,NULL,'elephant-1','');

--
-- Table structure for table `koken_drafts`
--

CREATE TABLE `koken_drafts` (
  `id` int(9) NOT NULL auto_increment,
  `path` varchar(255) default NULL,
  `live_data` text,
  `data` text,
  `current` tinyint(1) NOT NULL default '0',
  `draft` tinyint(1) NOT NULL default '0',
  `created_on` int(10) NOT NULL,
  `modified_on` int(10) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `path` (`path`),
  KEY `current` (`current`),
  KEY `draft` (`draft`),
  KEY `created_on` (`created_on`),
  KEY `modified_on` (`modified_on`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_drafts`
--

INSERT INTO `koken_drafts` VALUES (1,'elementary','{\"navigation\":{\"items\":[{\"label\":\"Home\",\"path\":\"\\/home\",\"front\":true},{\"label\":\"Albums\",\"path\":\"\\/albums\",\"front\":false},{\"label\":\"Content\",\"path\":\"\\/content\",\"front\":false},{\"label\":\"Essays\",\"path\":\"\\/essays\",\"front\":false}],\"groups\":[{\"key\":\"footer\",\"label\":\"Footer\",\"items\":[{\"label\":\"Home\",\"path\":\"\\/home\"},{\"label\":\"Albums\",\"path\":\"\\/albums\"}]}]}}','{\"navigation\":{\"items\":[{\"label\":\"Home\",\"path\":\"\\/home\",\"front\":true},{\"label\":\"Albums\",\"path\":\"\\/albums\",\"front\":false},{\"label\":\"Illustrations\",\"path\":\"\\/content\",\"front\":false},{\"label\":\"Photography\",\"path\":\"\\/content\\/\",\"front\":false},{\"label\":\"Drawings\",\"path\":\"\\/content\\/\",\"front\":false},{\"label\":\"Essays\",\"path\":\"\\/essays\",\"front\":false}],\"groups\":[{\"key\":\"footer\",\"label\":\"Footer\",\"items\":[{\"label\":\"Home\",\"path\":\"\\/home\"},{\"label\":\"Albums\",\"path\":\"\\/albums\"}],\"items_nested\":[{\"label\":\"Home\",\"path\":\"\\/home\"},{\"label\":\"Albums\",\"path\":\"\\/albums\"}]}],\"items_nested\":[{\"label\":\"Home\",\"path\":\"\\/home\",\"front\":true},{\"label\":\"Albums\",\"path\":\"\\/albums\",\"front\":false},{\"label\":\"Illustrations\",\"path\":\"\\/content\",\"front\":false},{\"label\":\"Essays\",\"path\":\"\\/essays\",\"front\":false},{\"label\":\"Photography\",\"path\":\"\\/content\\/\",\"front\":false},{\"label\":\"Drawings\",\"path\":\"\\/content\\/\",\"front\":false}]},\"settings\":{\"__style\":\"white\"},\"custom_css\":\"\",\"routes\":{\"\\/content\\/:id\\/in_album\\/:album_id(?P<lightbox>\\/lightbox)?\\/\":{\"template\":\"redirect:content\"}}}',0,0,1368049340,1368129075),(2,'observatory','{\"navigation\":{\"items\":[{\"front\":true,\"auto\":\"albums\",\"path\":\"\\/albums\\/\",\"label\":\"Albums\"},{\"auto\":\"essays\",\"path\":\"\\/essays\\/\",\"label\":\"Essays\"},{\"auto\":\"album\",\"id\":3,\"path\":\"\\/albums\\/3\\/\",\"label\":\"Photography\"},{\"auto\":\"album\",\"id\":1,\"path\":\"\\/albums\\/1\\/\",\"label\":\"Posters\"},{\"auto\":\"album\",\"id\":4,\"path\":\"\\/albums\\/4\\/\",\"label\":\"Blk n Wht\"}],\"groups\":[],\"items_nested\":[{\"front\":true,\"auto\":\"albums\",\"path\":\"\\/albums\\/\",\"label\":\"Albums\"},{\"auto\":\"essays\",\"path\":\"\\/essays\\/\",\"label\":\"Essays\"},{\"auto\":\"album\",\"id\":3,\"path\":\"\\/albums\\/3\\/\",\"label\":\"Photography\"},{\"auto\":\"album\",\"id\":1,\"path\":\"\\/albums\\/1\\/\",\"label\":\"Posters\"},{\"auto\":\"album\",\"id\":4,\"path\":\"\\/albums\\/4\\/\",\"label\":\"Blk n Wht\"}]},\"custom_css\":\"body {\\n    background: #131415;\\n    font-family:\\\"Open Sans\\\", Helvetica, Arial, sans-serif;\\n    margin: 5px 0;\\n}\\n    \\nheader {\\n    margin-bottom: 10px;\\n    opacity: 0.8;\\n}\\n\\nheader:hover {\\n    opacity: 1;\\n}\\n\\nnav {\\n    font-family: \\\"Open Sans Condensed\\\", Helvetica, Arial, sans-serif;\\n    margin-bottom: 10px;\\n}\\n\\nnav a.k-nav-current {\\n    color: #3c3e41;\\n}\\n\\nnav a {\\n    font-size: 21px;\\n    color: #fff;\\n}\\n\\nnav a:hover {\\ncolor: #708e95;\\n}\\n\\na:visited {\\ncolor: #fff;\\n}\\n\\nh2 {\\n    color: #4b5b5b;\\n}\\n\\nh4 {\\n    color: #4b5b5b;\\n    font-family: \\\"Open Sans Condensed\\\", Helvetica, Arial, sans-serif;\\n    font-weight: normal;\\n}\\n\\ndiv.item {\\n    background-color: #fff;\\n    padding-bottom: 5px;\\n}\\n\\ndiv.item img {\\n    margin-bottom: 0px;\\n}\\n\\ndiv.item h4 {\\n    font-size: 18px;\\n    margin-bottom: 5px;\\n}\\n\\ndiv.wrap h2 {\\n    font-size: 16px;\\n    font-family: \\\"Open Sans Condensed\\\", Helvetica, Arial, sans-serif;\\n    font-weight: normal;\\n}\\n\\ndiv.content-row h3{\\n    font-size: 21px;\\n    font-family: \\\"Open Sans Condensed\\\", Helvetica, Arial, sans-serif;\\n    font-weight: normal;\\n    color: #4b5b5b;\\n}\\n\\ndiv.item {\\n    opacity: 0.8;\\n}\\n\\ndiv.item:hover {\\n    opacity: 1;\\n}\\nimg.custom_logo {\\n    -webkit-transform: scale(1);\\n}\\n\",\"routes\":{\"\\/content\\/:id\\/in_album\\/:album_id(?P<lightbox>\\/lightbox)?\\/\":{\"template\":\"redirect:content\"},\"\\/sets\\/\":{\"template\":\"redirect:soft:albums\"}},\"settings\":{\"social_bttns_show_two\":false,\"site_title_size\":\"21\",\"site_title_type\":\"image\",\"social_bttns_show_one\":false,\"site_title_img_url\":\"http:\\/\\/www.artguz.com\\/kimages\\/me.png\"}}','{\"navigation\":{\"items\":[{\"front\":true,\"auto\":\"albums\",\"path\":\"\\/albums\\/\",\"label\":\"Albums\"},{\"auto\":\"essays\",\"path\":\"\\/essays\\/\",\"label\":\"Essays\"},{\"auto\":\"album\",\"id\":3,\"path\":\"\\/albums\\/3\\/\",\"label\":\"Photography\"},{\"auto\":\"album\",\"id\":1,\"path\":\"\\/albums\\/1\\/\",\"label\":\"Posters\"},{\"auto\":\"album\",\"id\":4,\"path\":\"\\/albums\\/4\\/\",\"label\":\"Blk n Wht\"}],\"groups\":[],\"items_nested\":[{\"front\":true,\"auto\":\"albums\",\"path\":\"\\/albums\\/\",\"label\":\"Albums\"},{\"auto\":\"essays\",\"path\":\"\\/essays\\/\",\"label\":\"Essays\"},{\"auto\":\"album\",\"id\":3,\"path\":\"\\/albums\\/3\\/\",\"label\":\"Photography\"},{\"auto\":\"album\",\"id\":1,\"path\":\"\\/albums\\/1\\/\",\"label\":\"Posters\"},{\"auto\":\"album\",\"id\":4,\"path\":\"\\/albums\\/4\\/\",\"label\":\"Blk n Wht\"}]},\"custom_css\":\"body {\\n    background: #131415;\\n    font-family:\\\"Open Sans\\\", Helvetica, Arial, sans-serif;\\n    margin: 5px 0;\\n}\\n    \\nheader {\\n    margin-bottom: 10px;\\n    opacity: 0.8;\\n}\\n\\nheader:hover {\\n    opacity: 1;\\n}\\n\\nnav {\\n    font-family: \\\"Open Sans Condensed\\\", Helvetica, Arial, sans-serif;\\n    margin-bottom: 10px;\\n}\\n\\nnav a.k-nav-current {\\n    color: #3c3e41;\\n}\\n\\nnav a {\\n    font-size: 21px;\\n    color: #fff;\\n}\\n\\nnav a:hover {\\ncolor: #708e95;\\n}\\n\\na:visited {\\ncolor: #fff;\\n}\\n\\nh2 {\\n    color: #4b5b5b;\\n}\\n\\nh4 {\\n    color: #4b5b5b;\\n    font-family: \\\"Open Sans Condensed\\\", Helvetica, Arial, sans-serif;\\n    font-weight: normal;\\n}\\n\\ndiv.item {\\n    background-color: #fff;\\n    padding-bottom: 5px;\\n}\\n\\ndiv.item img {\\n    margin-bottom: 0px;\\n}\\n\\ndiv.item h4 {\\n    font-size: 18px;\\n    margin-bottom: 5px;\\n}\\n\\ndiv.wrap h2 {\\n    font-size: 16px;\\n    font-family: \\\"Open Sans Condensed\\\", Helvetica, Arial, sans-serif;\\n    font-weight: normal;\\n}\\n\\ndiv.content-row h3{\\n    font-size: 21px;\\n    font-family: \\\"Open Sans Condensed\\\", Helvetica, Arial, sans-serif;\\n    font-weight: normal;\\n    color: #4b5b5b;\\n}\\n\\ndiv.item {\\n    opacity: 0.8;\\n}\\n\\ndiv.item:hover {\\n    opacity: 1;\\n}\\nimg.custom_logo {\\n    -webkit-transform: scale(1);\\n}\\n\",\"routes\":{\"\\/content\\/:id\\/in_album\\/:album_id(?P<lightbox>\\/lightbox)?\\/\":{\"template\":\"redirect:content\"},\"\\/sets\\/\":{\"template\":\"redirect:soft:albums\"}},\"settings\":{\"social_bttns_show_two\":false,\"site_title_size\":\"21\",\"site_title_type\":\"image\",\"social_bttns_show_one\":false,\"site_title_img_url\":\"http:\\/\\/www.artguz.com\\/kimages\\/me.png\"}}',1,1,1368121733,1370459241),(3,'regale','{\"navigation\":{\"items\":[{\"label\":\"Home\",\"front\":true,\"path\":\"\\/content\\/\",\"auto\":\"contents\"},{\"auto\":\"albums\"},{\"auto\":\"essays\"},{\"auto\":\"album\",\"id\":3,\"path\":\"\\/albums\\/3\\/\",\"label\":\"Photography\"},{\"auto\":\"album\",\"id\":1,\"path\":\"\\/albums\\/1\\/\",\"label\":\"Posters\"},{\"auto\":\"album\",\"id\":4,\"path\":\"\\/albums\\/4\\/\",\"label\":\"Blk n Wht\"}],\"groups\":[{\"key\":\"footer\",\"label\":\"Footer\",\"items\":[{\"label\":\"Home\",\"front\":true,\"path\":\"\\/content\\/\",\"auto\":\"contents\"},{\"auto\":\"albums\"},{\"auto\":\"essays\"}]}]}}','{\"navigation\":{\"items\":[{\"label\":\"Home\",\"front\":true,\"path\":\"\\/content\\/\",\"auto\":\"contents\"},{\"auto\":\"albums\"},{\"auto\":\"essays\"},{\"auto\":\"album\",\"id\":3,\"path\":\"\\/albums\\/3\\/\",\"label\":\"Photography\"},{\"auto\":\"album\",\"id\":1,\"path\":\"\\/albums\\/1\\/\",\"label\":\"Posters\"},{\"auto\":\"album\",\"id\":4,\"path\":\"\\/albums\\/4\\/\",\"label\":\"Blk n Wht\"}],\"groups\":[{\"key\":\"footer\",\"label\":\"Footer\",\"items\":[{\"label\":\"Home\",\"front\":true,\"path\":\"\\/content\\/\",\"auto\":\"contents\"},{\"auto\":\"albums\"},{\"auto\":\"essays\"}]}]}}',0,0,1368638894,1368639011);

--
-- Table structure for table `koken_history`
--

CREATE TABLE `koken_history` (
  `id` int(9) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `message` text,
  `created_on` int(10) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`),
  KEY `created_on` (`created_on`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_history`
--

INSERT INTO `koken_history` VALUES (1,1,'s:14:\"system:install\";',1368049340);

--
-- Table structure for table `koken_join_albums_categories`
--

CREATE TABLE `koken_join_albums_categories` (
  `id` int(9) NOT NULL auto_increment,
  `album_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `album_id` (`album_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_join_albums_categories`
--

INSERT INTO `koken_join_albums_categories` VALUES (1,1,1),(2,1,2),(3,3,4),(4,2,3);

--
-- Table structure for table `koken_join_albums_content`
--

CREATE TABLE `koken_join_albums_content` (
  `id` int(9) NOT NULL auto_increment,
  `album_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `order` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `album_id` (`album_id`),
  KEY `content_id` (`content_id`),
  KEY `order` (`order`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_join_albums_content`
--

INSERT INTO `koken_join_albums_content` VALUES (28,1,29,4),(29,5,23,1),(30,6,22,1),(41,7,39,3),(42,7,40,4),(43,3,41,3),(27,1,28,2),(26,1,27,3),(38,3,34,2),(40,7,38,2),(37,3,31,1),(35,4,35,5),(39,7,37,1),(33,4,33,3),(24,1,25,1),(32,4,32,2),(31,4,30,1),(36,4,36,6),(25,1,26,5),(23,1,24,6),(44,8,42,1),(45,9,44,1);

--
-- Table structure for table `koken_join_albums_covers`
--

CREATE TABLE `koken_join_albums_covers` (
  `id` int(9) NOT NULL auto_increment,
  `album_id` int(11) NOT NULL,
  `cover_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `album_id` (`album_id`),
  KEY `cover_id` (`cover_id`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_join_albums_covers`
--

INSERT INTO `koken_join_albums_covers` VALUES (58,7,39),(57,7,37),(40,6,22),(39,5,23),(42,1,26),(60,3,34),(46,4,32),(61,3,41),(47,4,33),(45,4,30),(43,1,25),(41,1,24),(59,7,38),(62,3,31),(56,8,42),(63,9,44);

--
-- Table structure for table `koken_join_albums_text`
--

CREATE TABLE `koken_join_albums_text` (
  `id` int(9) NOT NULL auto_increment,
  `album_id` int(11) NOT NULL,
  `text_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `album_id` (`album_id`),
  KEY `text_id` (`text_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_join_albums_text`
--

INSERT INTO `koken_join_albums_text` VALUES (1,3,1);

--
-- Table structure for table `koken_join_categories_content`
--

CREATE TABLE `koken_join_categories_content` (
  `id` int(9) NOT NULL auto_increment,
  `content_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `content_id` (`content_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_join_categories_content`
--


--
-- Table structure for table `koken_join_categories_text`
--

CREATE TABLE `koken_join_categories_text` (
  `id` int(9) NOT NULL auto_increment,
  `text_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `text_id` (`text_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_join_categories_text`
--


--
-- Table structure for table `koken_plugins`
--

CREATE TABLE `koken_plugins` (
  `id` int(9) NOT NULL auto_increment,
  `path` varchar(255) default NULL,
  `setup` tinyint(1) NOT NULL default '1',
  `data` longtext,
  PRIMARY KEY  (`id`),
  KEY `path` (`path`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_plugins`
--

INSERT INTO `koken_plugins` VALUES (1,'koken-font-loader',1,'a:4:{s:7:\"typekit\";s:0:\"\";s:6:\"google\";s:55:\"Open Sans(300,400,600,700),Open Sans Condensed(300,700)\";s:8:\"fontdeck\";s:0:\"\";s:8:\"fontscom\";s:0:\"\";}');

--
-- Table structure for table `koken_settings`
--

CREATE TABLE `koken_settings` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `value` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_settings`
--

INSERT INTO `koken_settings` VALUES (1,'site_timezone','America/Guatemala'),(2,'console_show_notifications','yes'),(3,'console_enable_keyboard_shortcuts','yes'),(4,'uploading_default_license','all'),(5,'uploading_default_visibility','public'),(6,'uploading_default_max_download_size','none'),(7,'site_title','Byron Guzman'),(8,'site_tagline','Your site tagline'),(9,'site_copyright','© Byron Guzman'),(10,'site_description',''),(11,'site_keywords','photography, Byron Guzman,illustration,design'),(12,'site_date_format','F j, Y'),(13,'site_time_format','g:i a'),(14,'site_privacy','public'),(15,'site_hidpi','true'),(16,'site_url','/'),(17,'uuid','1247a2d8d0025b5c59b4090e4b2a8616'),(18,'retain_image_metadata','false'),(19,'image_use_defaults','true'),(20,'image_tiny_quality','80'),(21,'image_small_quality','80'),(22,'image_medium_quality','85'),(23,'image_medium_large_quality','85'),(24,'image_large_quality','85'),(25,'image_xlarge_quality','90'),(26,'image_huge_quality','90'),(27,'image_tiny_sharpening','0.6'),(28,'image_small_sharpening','0.5'),(29,'image_medium_sharpening','0.5'),(30,'image_medium_large_sharpening','0.5'),(31,'image_large_sharpening','0.5'),(32,'image_xlarge_sharpening','0.2'),(33,'image_huge_sharpening','0'),(34,'use_default_labels_links','false');

--
-- Table structure for table `koken_tags`
--

CREATE TABLE `koken_tags` (
  `id` varchar(100) NOT NULL default '',
  `count` int(11) NOT NULL,
  `album_count` int(11) NOT NULL default '0',
  `text_count` int(11) NOT NULL default '0',
  `content_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `count` (`count`),
  KEY `album_count` (`album_count`),
  KEY `text_count` (`text_count`),
  KEY `content_count` (`content_count`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_tags`
--


--
-- Table structure for table `koken_text`
--

CREATE TABLE `koken_text` (
  `id` int(9) NOT NULL auto_increment,
  `title` text,
  `content` longtext,
  `excerpt` varchar(255) default NULL,
  `published` tinyint(1) NOT NULL default '0',
  `page_type` int(1) NOT NULL default '0',
  `published_on` int(10) default NULL,
  `created_on` int(10) NOT NULL,
  `modified_on` int(10) NOT NULL,
  `tags` text,
  `internal_id` char(32) NOT NULL,
  `slug` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `published` (`published`),
  KEY `created_on` (`created_on`),
  KEY `modified_on` (`modified_on`),
  KEY `published_on` (`published_on`),
  KEY `page_type` (`page_type`),
  KEY `internal_id` (`internal_id`),
  KEY `slug` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_text`
--

INSERT INTO `koken_text` VALUES (1,'My Page','<p class=\"\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.<br></p>\n',NULL,1,1,1368128347,1368128347,1368128470,NULL,'c693e80bdf8d33c825e81b8192dca8b4','my-page'),(2,'Essay 1','<p class=\"\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.<br></p>[koken_photo label=\"7a-Ave.jpg\" id=\"9\" media_type=\"image\"]\n','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor…',0,0,NULL,1368128618,1368128996,NULL,'40e9fe4957aa4c24ab3b7257aa2c31b1','essay-1');

--
-- Table structure for table `koken_trash`
--

CREATE TABLE `koken_trash` (
  `id` varchar(255) NOT NULL default '',
  `data` text,
  `created_on` int(10) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `created_on` (`created_on`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_trash`
--

INSERT INTO `koken_trash` VALUES ('content-43','a:38:{s:2:\"id\";d:43;s:5:\"title\";N;s:8:\"filename\";s:12:\"Elephant.jpg\";s:7:\"caption\";N;s:10:\"visibility\";a:2:{s:3:\"raw\";s:6:\"public\";s:5:\"clean\";s:6:\"Public\";}s:12:\"max_download\";a:2:{s:3:\"raw\";s:4:\"none\";s:5:\"clean\";s:4:\"None\";}s:7:\"license\";a:2:{s:3:\"raw\";s:3:\"all\";s:5:\"clean\";s:22:\"© All rights reserved\";}s:8:\"featured\";b:0;s:8:\"favorite\";b:0;s:11:\"uploaded_on\";a:2:{s:8:\"datetime\";s:18:\"2013/06/29 0:52:24\";s:9:\"timestamp\";i:1372467144;}s:11:\"captured_on\";a:2:{s:8:\"datetime\";s:18:\"2013/06/29 0:52:24\";s:9:\"timestamp\";i:1372467144;}s:11:\"modified_on\";a:2:{s:8:\"datetime\";s:18:\"2013/06/29 0:52:24\";s:9:\"timestamp\";i:1372467144;}s:16:\"file_modified_on\";a:2:{s:8:\"datetime\";s:18:\"2013/06/29 0:52:24\";s:9:\"timestamp\";i:1372467144;}s:11:\"focal_point\";a:2:{s:1:\"x\";i:50;s:1:\"y\";i:50;}s:8:\"filesize\";d:102699;s:5:\"width\";d:900;s:6:\"height\";d:600;s:12:\"aspect_ratio\";d:1.5;s:4:\"tags\";a:0:{}s:9:\"file_type\";s:5:\"image\";s:10:\"lg_preview\";N;s:11:\"internal_id\";s:32:\"a607fc29d14b9c24b6687d855d489aac\";s:4:\"iptc\";a:0:{}s:4:\"exif\";a:0:{}s:4:\"slug\";s:8:\"elephant\";s:8:\"original\";a:4:{s:3:\"url\";s:60:\"http://artguz.com/koken/storage/originals/a6/07/Elephant.jpg\";s:12:\"relative_url\";s:43:\"/koken/storage/originals/a6/07/Elephant.jpg\";s:5:\"width\";i:900;s:6:\"height\";i:600;}s:9:\"__koken__\";s:7:\"content\";s:9:\"mime_type\";s:10:\"image/jpeg\";s:10:\"cache_path\";a:2:{s:6:\"prefix\";s:61:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant\";s:9:\"extension\";s:14:\"jpg?1372467144\";}s:7:\"presets\";a:7:{s:4:\"tiny\";a:5:{s:3:\"url\";s:81:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,tiny.jpg?1372467144\";s:9:\"hidpi_url\";s:84:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,tiny.2x.jpg?1372467144\";s:5:\"width\";i:60;s:6:\"height\";i:40;s:7:\"cropped\";a:4:{s:3:\"url\";s:86:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,tiny.crop.jpg?1372467144\";s:9:\"hidpi_url\";s:89:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,tiny.crop.2x.jpg?1372467144\";s:5:\"width\";i:60;s:6:\"height\";i:60;}}s:5:\"small\";a:5:{s:3:\"url\";s:82:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,small.jpg?1372467144\";s:9:\"hidpi_url\";s:85:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,small.2x.jpg?1372467144\";s:5:\"width\";i:100;s:6:\"height\";i:67;s:7:\"cropped\";a:4:{s:3:\"url\";s:87:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,small.crop.jpg?1372467144\";s:9:\"hidpi_url\";s:90:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,small.crop.2x.jpg?1372467144\";s:5:\"width\";i:100;s:6:\"height\";i:100;}}s:6:\"medium\";a:5:{s:3:\"url\";s:83:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,medium.jpg?1372467144\";s:9:\"hidpi_url\";s:86:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,medium.2x.jpg?1372467144\";s:5:\"width\";i:480;s:6:\"height\";i:320;s:7:\"cropped\";a:4:{s:3:\"url\";s:88:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,medium.crop.jpg?1372467144\";s:9:\"hidpi_url\";s:91:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,medium.crop.2x.jpg?1372467144\";s:5:\"width\";i:480;s:6:\"height\";i:480;}}s:12:\"medium_large\";a:5:{s:3:\"url\";s:89:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,medium_large.jpg?1372467144\";s:9:\"hidpi_url\";s:92:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,medium_large.2x.jpg?1372467144\";s:5:\"width\";i:800;s:6:\"height\";i:533;s:7:\"cropped\";a:4:{s:3:\"url\";s:94:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,medium_large.crop.jpg?1372467144\";s:9:\"hidpi_url\";s:97:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,medium_large.crop.2x.jpg?1372467144\";s:5:\"width\";i:800;s:6:\"height\";i:800;}}s:5:\"large\";a:5:{s:3:\"url\";s:82:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,large.jpg?1372467144\";s:9:\"hidpi_url\";s:85:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,large.2x.jpg?1372467144\";s:5:\"width\";i:900;s:6:\"height\";i:600;s:7:\"cropped\";a:4:{s:3:\"url\";s:87:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,large.crop.jpg?1372467144\";s:9:\"hidpi_url\";s:90:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,large.crop.2x.jpg?1372467144\";s:5:\"width\";i:1024;s:6:\"height\";i:1024;}}s:6:\"xlarge\";a:5:{s:3:\"url\";s:83:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,xlarge.jpg?1372467144\";s:9:\"hidpi_url\";s:86:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,xlarge.2x.jpg?1372467144\";s:5:\"width\";i:900;s:6:\"height\";i:600;s:7:\"cropped\";a:4:{s:3:\"url\";s:88:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,xlarge.crop.jpg?1372467144\";s:9:\"hidpi_url\";s:91:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,xlarge.crop.2x.jpg?1372467144\";s:5:\"width\";i:1600;s:6:\"height\";i:1600;}}s:4:\"huge\";a:5:{s:3:\"url\";s:81:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,huge.jpg?1372467144\";s:9:\"hidpi_url\";s:84:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,huge.2x.jpg?1372467144\";s:5:\"width\";i:900;s:6:\"height\";i:600;s:7:\"cropped\";a:4:{s:3:\"url\";s:86:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,huge.crop.jpg?1372467144\";s:9:\"hidpi_url\";s:89:\"http://artguz.com/koken/storage/cache/images/000/043/Elephant,huge.crop.2x.jpg?1372467144\";s:5:\"width\";i:2048;s:6:\"height\";i:2048;}}}s:11:\"iptc_fields\";a:0:{}s:11:\"exif_fields\";a:0:{}s:11:\"geolocation\";b:0;s:10:\"categories\";a:0:{}s:4:\"date\";R:20;s:3:\"url\";s:29:\"http://artguz.com/content/43/\";s:11:\"__koken_url\";s:12:\"/content/43/\";s:13:\"canonical_url\";s:29:\"http://artguz.com/content/43/\";}',1372467163),('album-2','a:24:{s:2:\"id\";d:2;s:5:\"title\";s:8:\"Drawings\";s:7:\"summary\";N;s:11:\"description\";N;s:6:\"listed\";b:0;s:5:\"level\";d:1;s:7:\"left_id\";d:1;s:8:\"right_id\";d:2;s:8:\"featured\";b:0;s:14:\"featured_order\";N;s:10:\"created_on\";a:2:{s:8:\"datetime\";s:19:\"2013/05/09 19:25:46\";s:9:\"timestamp\";i:1368127546;}s:11:\"modified_on\";a:2:{s:8:\"datetime\";s:19:\"2013/06/03 18:12:59\";s:9:\"timestamp\";i:1370283179;}s:10:\"album_type\";s:8:\"standard\";s:4:\"tags\";a:0:{}s:11:\"internal_id\";s:32:\"6c43828e7865c1821f35855cfbdb1fa2\";s:4:\"slug\";s:8:\"drawings\";s:9:\"__koken__\";s:5:\"album\";s:6:\"counts\";a:3:{s:5:\"total\";i:0;s:6:\"videos\";i:0;s:6:\"images\";i:0;}s:10:\"categories\";a:1:{i:0;a:5:{s:2:\"id\";d:3;s:5:\"title\";s:8:\"Drawings\";s:4:\"slug\";s:8:\"drawings\";s:6:\"counts\";a:3:{s:7:\"content\";i:1;s:6:\"albums\";i:1;s:6:\"essays\";i:0;}s:9:\"__koken__\";s:15:\"category_albums\";}}s:6:\"topics\";a:0:{}s:6:\"covers\";a:0:{}s:4:\"date\";R:12;s:6:\"parent\";b:0;s:11:\"__koken_url\";s:41:\"/albums/6c43828e7865c1821f35855cfbdb1fa2/\";}',1372467236);

--
-- Table structure for table `koken_urls`
--

CREATE TABLE `koken_urls` (
  `id` int(9) NOT NULL auto_increment,
  `data` text NOT NULL,
  `created_on` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_urls`
--

INSERT INTO `koken_urls` VALUES (1,'a:9:{i:0;a:2:{s:4:\"type\";s:7:\"content\";s:4:\"data\";a:5:{s:8:\"singular\";s:7:\"Content\";s:6:\"plural\";s:7:\"Content\";s:5:\"order\";s:16:\"captured_on DESC\";s:11:\"album_order\";s:10:\"manual ASC\";s:3:\"url\";s:2:\"id\";}}i:1;a:2:{s:4:\"type\";s:8:\"favorite\";s:4:\"data\";a:3:{s:8:\"singular\";s:8:\"Favorite\";s:6:\"plural\";s:9:\"Favorites\";s:5:\"order\";s:10:\"manual ASC\";}}i:2;a:2:{s:4:\"type\";s:5:\"album\";s:4:\"data\";a:4:{s:8:\"singular\";s:5:\"Album\";s:6:\"plural\";s:6:\"Albums\";s:5:\"order\";s:10:\"manual asc\";s:3:\"url\";s:2:\"id\";}}i:3;a:2:{s:4:\"type\";s:3:\"set\";s:4:\"data\";a:2:{s:8:\"singular\";s:3:\"Set\";s:6:\"plural\";s:4:\"Sets\";}}i:4;a:2:{s:4:\"type\";s:5:\"essay\";s:4:\"data\";a:4:{s:8:\"singular\";s:5:\"Essay\";s:6:\"plural\";s:6:\"Essays\";s:5:\"order\";s:17:\"published_on DESC\";s:3:\"url\";s:2:\"id\";}}i:5;a:2:{s:4:\"type\";s:4:\"page\";s:4:\"data\";a:3:{s:8:\"singular\";s:4:\"Page\";s:6:\"plural\";s:5:\"Pages\";s:3:\"url\";s:2:\"id\";}}i:6;a:2:{s:4:\"type\";s:3:\"tag\";s:4:\"data\";a:2:{s:8:\"singular\";s:3:\"Tag\";s:6:\"plural\";s:4:\"Tags\";}}i:7;a:2:{s:4:\"type\";s:8:\"category\";s:4:\"data\";a:2:{s:8:\"singular\";s:8:\"Category\";s:6:\"plural\";s:10:\"Categories\";}}i:8;a:2:{s:4:\"type\";s:7:\"archive\";s:4:\"data\";a:2:{s:8:\"singular\";s:7:\"Archive\";s:6:\"plural\";s:8:\"Archives\";}}}',1368119990);

--
-- Table structure for table `koken_users`
--

CREATE TABLE `koken_users` (
  `id` int(9) NOT NULL auto_increment,
  `password` varchar(60) default NULL,
  `email` varchar(255) default NULL,
  `created_on` int(10) NOT NULL,
  `modified_on` int(10) NOT NULL,
  `first_name` varchar(255) default NULL,
  `last_name` varchar(255) default NULL,
  `public_first_name` varchar(255) default NULL,
  `public_last_name` varchar(255) default NULL,
  `public_display` varchar(255) default 'both',
  `public_email` varchar(255) default NULL,
  `twitter` varchar(255) default NULL,
  `facebook` varchar(255) default NULL,
  `internal_id` char(32) NOT NULL,
  `google` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `password` (`password`),
  KEY `email` (`email`),
  KEY `internal_id` (`internal_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `koken_users`
--

INSERT INTO `koken_users` VALUES (1,'$P$B0uUwt46SUE.YVzO5VfD10BAuU2olq.','guzman.byron@gmail.com',1368049340,1368285336,'Byron','Guzman','Byron','Guzman','both','guzman.byron@gmail.com',NULL,NULL,'4ae0d54d5731858d2b110c24c67eb8cf','');


