-
Notifications
You must be signed in to change notification settings - Fork 1
/
example_data.sql
91 lines (82 loc) · 14.6 KB
/
example_data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
-- phpMyAdmin SQL Dump
-- version 4.4.13.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 27, 2017 at 04:24 PM
-- Server version: 5.6.31-0ubuntu0.15.10.1
-- PHP Version: 5.6.11-1ubuntu3.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
/*!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 utf8mb4 */;
--
-- Database: `solsearch`
--
--
-- Dumping data for table `ads`
--
INSERT INTO `ads` VALUES
(84, 'offer', 'A French licenced widgets latest model!', 'Ad diam gemino ludus nulla quia quidne. Abdo exerci facilisi incassum lucidus metuo minim populus singularis venio. Abico dolor ideo melior suscipere suscipit ut vel veniam vicis.Feugiat jugis loquor natu typicus venio vulpes. Dolor nulla quis. Abigo ad dignissim humo pagus pneum scisco virtus voco. Euismod ex illum iustum letalis suscipit typicus vereor vulpes. Caecus iusto nulla probo vulpes. Feugiat illum letalis mauris metuo natu proprius quidne volutpat. Acsi ad ille lucidus oppeto probo quadrum scisco. Lenis macto magna nulla os quidem roto secundum.', 'care, admin', 1, 1, 1, 4, 'b10dd046-3e16-401f-8c23-9585f7d254ac', 1498509093, 'ad/291', 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0N@', 'sites/default/files/smallads/offer/generateImage_5X77Qm.png', ''),
(85, 'offer', 'A very nice gelatinous ', 'Abico ea lenis wisi. Commoveo facilisi in praesent sit tation valetudo vicis vulputate ymo. Abico elit natu obruo ratis scisco vindico. Bene commodo diam paulatim. Diam et humo lenis lucidus neque occuro os patria vereor. Et immitto pala. Adipiscing caecus dolore esca et eu lenis refoveo vereor.Causa feugiat minim oppeto pagus proprius quidne voco. Brevitas ille turpis. Olim sino vindico. Aliquam dolor persto. Decet iaceo illum jumentum neque nibh nutus ut. Genitus sit tum. Comis eu genitus huic illum ullamcorper vulputate. Abbas aliquam conventio ille jugis proprius similis sit valde. Causa conventio defui dolor erat in inhibeo meus pneum.', 'admin, test category', 0, 0, 1, 4, '77791de2-ce80-4d10-abfc-4130ac7ca115', 1498509094, 'ad/295', 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0€I@', 'sites/default/files/smallads/offer/generateImage_6z9KhJ.jpg', ''),
(86, 'offer', 'Jewish unwanted ladder in need of repair.', 'Abico capto causa commoveo macto melior plaga proprius tamen. Gemino neque nutus similis. Antehabeo conventio dolor erat eu hendrerit nutus obruo sed vulpes. Praemitto ratis valde. Elit lucidus nibh qui usitas. Consectetuer cui duis illum jumentum praemitto te valetudo wisi. Capto dignissim et ideo illum imputo letalis paulatim praesent.Autem metuo meus pertineo probo qui voco. Euismod fere paratus ratis. Fere humo ratis utrum. Aliquip autem conventio damnum gilvus obruo rusticus saepius suscipit velit. Aliquip aptent causa exputo iusto magna mos. Consectetuer eligo nisl. Bene decet facilisi inhibeo lenis pagus paulatim probo quidne typicus. Huic neo te. Augue damnum immitto lenis loquor meus tamen vulputate.', 'test category, care', 0, 0, 0, 4, 'e7f9f2a0-eb85-4d54-b260-0ff52bd7a029', 1498509094, 'ad/296', 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0N@', 'sites/default/files/smallads/offer/generateImage_haUgbN.jpg', ''),
(87, 'want', 'Hand-crafted stress-tested antique ', 'Aptent luctus quia. Aliquam fere jugis similis. Commodo consectetuer quae quidem. Luptatum pertineo probo wisi. Hos meus neque odio volutpat. Aliquam augue gemino patria probo quia singularis zelus. Erat odio os pagus quidem sagaciter tum turpis voco. Iriure modo natu. Esse nostrud sagaciter valde. Cogo eum feugiat incassum premo quidne roto tum vereor ymo.Aliquip cui decet eum modo obruo occuro tum vindico. Abico aliquip vero. Esca fere gilvus patria turpis. Decet dolore quidne veniam. Augue cogo eligo gilvus meus neo paratus quibus scisco. Abluo augue quidem sagaciter scisco verto.', 'care', 1, 1, 1, 4, 'd39b953c-1c43-4b9e-a1d2-2baede246530', 1498509093, 'ad/287', 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0N@', '', ''),
(88, 'offer', 'A nearly expired gelatinous movie star', 'Bene dolore refero. Acsi iusto meus minim sagaciter tation. Abluo enim fere hos nostrud praemitto refoveo si vulputate. Adipiscing hos metuo olim oppeto quadrum tincidunt vicis. Blandit eligo et paratus praesent verto. Incassum modo persto. Feugiat inhibeo minim. In olim quibus refoveo te tincidunt verto zelus. Eros macto mauris natu quis rusticus sino vindico.\r\rCogo diam distineo gilvus hendrerit lucidus metuo paratus singularis tum. Antehabeo conventio nutus. Elit facilisi inhibeo lenis refero suscipit torqueo. Comis esca interdico nimis odio singularis turpis. Appellatio gilvus lenis nibh premo. Amet dolore melior olim populus tamen vero verto. At caecus lenis nisl sit valetudo.\r\r', 'admin', 0, 0, 0, 4, 'a843bffd-6f92-42a0-ac12-035b4c85efae', 1498509093, 'ad/288', 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð?\0\0\0\0\0€I@', 'sites/default/files/smallads/offer/generateImage_i3vpla.jpeg', ''),
(136, 'offer', 'dog walking', '', '188', 1, 1, 1, 3, 'af21e431-86f7-4c1f-8e44-0c287954a382', 1529921282, 'node/537', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/cute-puppy-dog-wallpapers.jpg', ''),
(137, 'offer', 'Van/Minibus/Lorry driver', '', '181', 1, 1, 1, 3, 'dc954e12-23af-49e9-83e9-3b7241531ac0', 1529921282, 'node/555', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(138, 'offer', 'essai de focntionnement, je veux apprendre', '', '179,180', 1, 1, 1, 3, 'e10350fa-eb90-4907-94a8-14f443b523b1', 1529921282, 'node/559', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(139, 'offer', 'Good bicycle ', '', '186', 1, 1, 1, 3, '6cf18e22-0c10-45c3-bfcc-ef9b3cb2e8f0', 1529921282, 'node/561', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/deception%20political.jpg', ''),
(140, 'offer', 'Dog walk', '', '185', 1, 1, 1, 3, '9927b3bb-a198-45b9-9f15-19e3c6ea6d14', 1529921282, 'node/566', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(141, 'offer', 'Bed linen', '', '185', 1, 1, 1, 3, 'af7ae0c4-a045-4050-8e56-e387a15b27ab', 1529921282, 'node/571', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(142, 'offer', 'Tiling', '', '185', 1, 1, 1, 3, '94a1170a-e128-46ad-875e-9e57fdd4c6be', 1529921282, 'node/573', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(143, 'offer', 'Exchange Black & Decker drill for a jigsaw', '', '181', 1, 1, 1, 3, 'a12beac7-259d-4c4a-b6cd-1145b94d940e', 1529921282, 'node/574', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(144, 'offer', 'nuts', '', '179,196,180', 1, 1, 1, 3, '2157e759-87c7-4ca8-9a95-84e3a38f4da2', 1529921282, 'node/575', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(145, 'offer', 'TAKEN: an electric bike', '', '186', 1, 1, 1, 3, 'baf49b82-a9ab-4a24-922a-0a93288f807d', 1529921282, 'node/585', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(146, 'offer', 'Astornomy 101 Book', '', '181', 1, 1, 1, 3, '4a6602a9-16c8-4576-9f9d-07713feff270', 1529921282, 'node/587', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(147, 'offer', 'Student Massage Therapist', '', '187,190', 1, 1, 1, 3, '25cc68ff-b0b2-40a7-8544-45d13750b025', 1529921282, 'node/591', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(148, 'offer', '5 dozen ears of corn', '', '202', 1, 1, 1, 3, 'ce3c3e36-f7a8-4a24-b3ce-63377e367f5a', 1529921282, 'node/595', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(149, 'offer', 'second hand clothing ', '', '189', 1, 1, 1, 3, '6b7207f0-2d42-4fb1-87bd-95a7c7adf702', 1529921282, 'node/612', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(150, 'offer', 'Paintings', '', '182', 1, 1, 1, 3, '70713f70-e264-4c11-9942-ec789cd97fa4', 1529921282, 'node/624', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(151, 'offer', 'not hartichiock', '', '202,180', 1, 1, 1, 3, '9498a4f3-da85-45de-9f76-0a200cdcaa13', 1529921282, 'node/689', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(152, 'offer', 'An Image', '', '182', 1, 1, 1, 3, '596ce03f-735e-4016-b255-3fde1345e7a1', 1502575200, 'node/735', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/paperinika.png', ''),
(153, 'offer', 'Sistema atoregante 6 plantas', '', '204,190', 1, 1, 1, 3, '7734445b-f46d-448a-ab7b-8153c1ac6902', 1503093600, 'node/736', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(154, 'offer', 'Clases de frances', '', '183', 1, 1, 1, 3, '1b5a551f-a7b4-433e-8897-fe6239c7c922', 1503093600, 'node/737', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(155, 'offer', 'Sistema de producción atónoma', '', '204', 1, 1, 1, 3, '0c4bac63-6138-44b3-80eb-f1bbb159fc5e', 1503093600, 'node/739', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(156, 'offer', 'Redaccion de proyectos', '', '182', 1, 1, 1, 3, '776c366d-18a0-47ef-ab1c-3a329f699dad', 1503093600, 'node/740', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(157, 'offer', 'Investigacion cientifica: historia', '', '182', 1, 1, 1, 3, 'd7aaefcf-cf7b-456f-9395-aa6a8612bca6', 1503093600, 'node/742', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(158, 'offer', 'Investigacion cientifica: Sociologia', '', '182', 1, 1, 1, 3, '168be289-540b-4eb2-9c03-d361cfe0febd', 1503093600, 'node/743', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(159, 'offer', 'Diseño de huertas', '', '190', 1, 1, 1, 3, '5b1bbaaa-3423-4560-830f-0915e439d910', 1503093600, 'node/744', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(160, 'offer', 'Gestion de proyectos', '', '182', 1, 1, 1, 3, 'de2f6d68-f1c2-48ad-a848-54ae3dbac28a', 1503093600, 'node/745', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(161, 'offer', 'Talleres de fabricación de abonos', '', '185', 1, 1, 1, 3, 'f2ec100e-69e8-4718-b3fe-75a7913a64a8', 1503093600, 'node/747', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(162, 'offer', 'Clases de frances', '', '183', 1, 1, 1, 3, '523c8700-3aad-49ec-9dd2-0af1f7190ab3', 1503093600, 'node/748', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(163, 'offer', 'Talleres de capacitación comunicación efectiva de marca', '', '183,182', 1, 1, 1, 3, '60d59259-7a18-417d-a773-9eebd592412b', 1503698400, 'node/751', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/flyers1.jpg', ''),
(164, 'offer', 'Apoyo escolar ninos', '', '183', 1, 1, 1, 3, '0da8a495-d954-457b-9f6f-d24ad6c6e674', 1503093600, 'node/752', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(165, 'offer', 'Traducciones ', '', '183,190', 1, 1, 1, 3, '5d6f1ce2-3045-455d-8865-b9ba7d9485d1', 1503093600, 'node/757', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(166, 'offer', 'Diseño de Proyectos Colaborativos:', '', '182', 1, 1, 1, 3, '29244b4c-7e2c-4890-8500-5f98da47987e', 1503093600, 'node/759', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/DRAGON-DREAMING-LOGO.png', ''),
(167, 'offer', 'Entrenamiento fisico (atletismo)', '', '188', 1, 1, 1, 3, '8f057e3f-e5dd-4a46-a9de-609b4840cb6a', 1503093600, 'node/761', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(168, 'offer', 'Acompañamiento a diseño de soluciones desde la economÃÂa solidaria', '', '182', 1, 1, 1, 3, 'd964f2f7-35c3-4dbf-89c5-c547ad391bc7', 1503093600, 'node/764', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(169, 'offer', 'Masajes con final feliz', '', '187', 1, 1, 1, 3, 'bb4ea4cf-2eca-43fc-9102-db6ad9289712', 1503093600, 'node/766', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(170, 'offer', 'Clases de Tango', '', '182', 1, 1, 1, 3, '7bf97359-35a0-493b-b3e8-a71e3bd53673', 1503093600, 'node/769', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(171, 'offer', 'Granola Amapola', '', '209', 1, 1, 1, 3, 'c1e633a1-bbdc-47d4-8919-8e45947f6cbe', 1503093600, 'node/772', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/granola.jpg', ''),
(172, 'offer', 'Granola Amapola', '', '209', 1, 1, 1, 3, '4d709813-763d-44f3-902c-ac636c3c8d88', 1503093600, 'node/773', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/granola.jpg', ''),
(173, 'offer', 'productos de limpieza ecologicos', '', '185', 1, 1, 1, 3, '532fc24b-f91a-4707-a950-b30f72ea6a69', 1503093600, 'node/774', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/limpieza.jpg', ''),
(174, 'offer', 'carpenter service', '', '196,190', 1, 1, 1, 3, '3f5bed85-6e04-4043-a98d-9fc024e68384', 1505944800, 'node/775', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(175, 'offer', 'I have aLibrary', '', '204,189,180', 1, 1, 1, 3, '14d3bebf-9758-40f1-8491-e5e86b11109d', 1506549600, 'node/777', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(177, 'offer', 'a car', '', '187,187', 1, 1, 1, 3, '8bc47df5-2ba9-44d3-88b7-b63dc1aca46c', 1506549600, 'node/779', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/toys.jpeg', ''),
(178, 'want', 'test', '', '179', 1, 1, 1, 3, '682ea855-283c-4aef-b16e-7fff3721bf98', 1529921282, 'node/551', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(179, 'want', 'Techie help with html page building', '', '184', 1, 1, 1, 3, '0bc3a9c9-8595-4d98-b43c-e31604a18ab5', 1529921282, 'node/556', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(180, 'want', 'lawn mown', '', '181', 1, 1, 1, 3, '9741705e-e1f0-42f7-b851-5e3581d1cdf3', 1529921282, 'node/564', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(181, 'want', 'Speech 101', '', '181', 1, 1, 1, 3, '5c4b0fdd-6007-4dae-a92b-fa43a645fcc1', 1529921282, 'node/588', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(182, 'want', 'hkjhkjhj', '', '184', 1, 1, 1, 3, '2af314ef-5dee-4b58-95bc-702acec3bef3', 1529921282, 'node/592', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', '', ''),
(195, 'proposition', 'test', 'k,jjjojhiohiùhiùo', 'Bricolage', 1, 1, 1, 3, '48704c84-4a33-4cbc-a615-37e196253dd2', 1529964000, 'node/546', 2, '\0\0\0\0\0\0\0\0\0\0\0\0\0ð¿\0\0\0\0\0\0J@', 'http://hamlets7/sites/default/files/IMG_0243.JPG', 'en');
--
-- Dumping data for table `clients`
--
INSERT INTO `clients` VALUES
(1, 'matslats.net', 'admin', 'matslats'),
(2, 'hamlets7', 'hamlets7', 'hamlets7'),
(19, 'mycool.exit', 'my verycool exchange', 'Tlsuk6vz9EbD');
/*!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 */;