· 11 years ago · May 12, 2015, 09:16 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: May 12, 2015 at 09:18 PM
7-- Server version: 5.6.21
8-- PHP Version: 5.5.19
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `btc`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `administrators`
27--
28
29CREATE TABLE IF NOT EXISTS `administrators` (
30`id` int(11) NOT NULL,
31 `group_id` int(3) NOT NULL,
32 `admin` tinyint(1) NOT NULL DEFAULT '0',
33 `name` varchar(64) NOT NULL,
34 `password` varchar(64) NOT NULL,
35 `email` varchar(64) NOT NULL,
36 `status` tinyint(1) NOT NULL DEFAULT '0',
37 `verify` varchar(255) DEFAULT NULL,
38 `last_login` datetime DEFAULT NULL,
39 `created` datetime NOT NULL,
40 `updated` datetime NOT NULL,
41 `created_by` int(11) DEFAULT NULL,
42 `updated_by` int(11) DEFAULT NULL,
43 `instance_id` int(11) DEFAULT NULL,
44 `dealer` int(11) DEFAULT NULL
45) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
46
47--
48-- Dumping data for table `administrators`
49--
50
51INSERT INTO `administrators` (`id`, `group_id`, `admin`, `name`, `password`, `email`, `status`, `verify`, `last_login`, `created`, `updated`, `created_by`, `updated_by`, `instance_id`, `dealer`) VALUES
52(12, 1, 0, 'Admin', '$2a$10$x1lplQzEzLcj5LrWm6KE7epXEM0EBcfjZXY6vNlGo42JIJNr6bJrq', 'admin@admin.com', 1, '535a7305-d164-4c90-aeb5-520a1293b51b', '2015-05-12 15:48:15', '2014-04-25 16:36:53', '2014-04-25 16:47:11', 5, 12, NULL, NULL);
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `cake_sessions`
58--
59
60CREATE TABLE IF NOT EXISTS `cake_sessions` (
61 `id` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
62 `data` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
63 `expires` int(11) NOT NULL
64) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
65
66--
67-- Dumping data for table `cake_sessions`
68--
69
70INSERT INTO `cake_sessions` (`id`, `data`, `expires`) VALUES
71('508d2c591e85a9466e65e35dd8ddc11e', 'Config|a:3:{s:9:"userAgent";s:32:"d7d1f4f64f6095f67c69825a4efe6f98";s:4:"time";i:1366562265;s:9:"countdown";i:10;}', 1366547865),
72('596c3c618301fb768958f593709a192b', 'Config|a:3:{s:9:"userAgent";s:32:"d7d1f4f64f6095f67c69825a4efe6f98";s:4:"time";i:1365706014;s:9:"countdown";i:10;}', 1365691614),
73('5a58534f2b853cb177911b09904c8346', 'Config|a:3:{s:9:"userAgent";s:32:"d7d1f4f64f6095f67c69825a4efe6f98";s:4:"time";i:1365971821;s:9:"countdown";i:10;}Message|a:1:{s:4:"auth";a:3:{s:7:"message";s:47:"You are not authorized to access that location.";s:7:"element";s:7:"default";s:6:"params";a:0:{}}}Auth|a:1:{s:4:"User";a:8:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"2";s:4:"name";s:11:"Trkić Amer";s:5:"email";s:16:"trkich@gmail.com";s:6:"status";b:1;s:6:"verify";s:36:"512e890f-0d54-4c93-838c-147db0765237";s:7:"created";s:19:"2013-02-04 21:16:01";s:7:"updated";s:19:"2013-04-11 19:09:52";}}', 1365957421),
74('5e0b0364676bb9910e0f41598feda7c8', 'Config|a:3:{s:9:"userAgent";s:32:"d7d1f4f64f6095f67c69825a4efe6f98";s:4:"time";i:1365726031;s:9:"countdown";i:10;}Message|a:1:{s:4:"auth";a:3:{s:7:"message";s:47:"You are not authorized to access that location.";s:7:"element";s:7:"default";s:6:"params";a:0:{}}}Auth|a:1:{s:4:"User";a:8:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"2";s:4:"name";s:11:"Trkić Amer";s:5:"email";s:16:"trkich@gmail.com";s:6:"status";b:1;s:6:"verify";s:36:"512e890f-0d54-4c93-838c-147db0765237";s:7:"created";s:19:"2013-02-04 21:16:01";s:7:"updated";s:19:"2013-04-11 19:09:52";}}', 1365711631),
75('b24701d29a631c12fe6b8af2b24b7a66', 'Config|a:3:{s:9:"userAgent";s:32:"d7d1f4f64f6095f67c69825a4efe6f98";s:4:"time";i:1365773295;s:9:"countdown";i:10;}Message|a:1:{s:4:"auth";a:3:{s:7:"message";s:47:"You are not authorized to access that location.";s:7:"element";s:7:"default";s:6:"params";a:0:{}}}Auth|a:1:{s:4:"User";a:8:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"2";s:4:"name";s:11:"Trkić Amer";s:5:"email";s:16:"trkich@gmail.com";s:6:"status";b:1;s:6:"verify";s:36:"512e890f-0d54-4c93-838c-147db0765237";s:7:"created";s:19:"2013-02-04 21:16:01";s:7:"updated";s:19:"2013-04-11 19:09:52";}}', 1365758896),
76('d9a2a86fe309d2b8fe0615791ae4e5bd', 'Config|a:3:{s:9:"userAgent";s:32:"d7d1f4f64f6095f67c69825a4efe6f98";s:4:"time";i:1365717910;s:9:"countdown";i:10;}Message|a:1:{s:4:"auth";a:3:{s:7:"message";s:47:"You are not authorized to access that location.";s:7:"element";s:7:"default";s:6:"params";a:0:{}}}Auth|a:1:{s:4:"User";a:8:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"2";s:4:"name";s:11:"Trkić Amer";s:5:"email";s:16:"trkich@gmail.com";s:6:"status";b:1;s:6:"verify";s:36:"512e890f-0d54-4c93-838c-147db0765237";s:7:"created";s:19:"2013-02-04 21:16:01";s:7:"updated";s:19:"2013-02-27 22:30:39";}}', 1365703510);
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `clients`
82--
83
84CREATE TABLE IF NOT EXISTS `clients` (
85`id` int(11) NOT NULL,
86 `first_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
87 `last_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
88 `password` varchar(64) NOT NULL,
89 `email` varchar(64) NOT NULL,
90 `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
91 `city` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
92 `zip` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
93 `telephone` varchar(100) NOT NULL,
94 `status` tinyint(1) NOT NULL DEFAULT '0',
95 `verify` varchar(255) DEFAULT NULL,
96 `last_login` datetime DEFAULT NULL,
97 `created` datetime NOT NULL,
98 `updated` datetime NOT NULL,
99 `created_by` int(11) DEFAULT NULL,
100 `updated_by` int(11) DEFAULT NULL,
101 `registration_type` varchar(32) DEFAULT NULL,
102 `register_country` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
103 `register_country_code` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
104 `register_city` varchar(64) DEFAULT NULL,
105 `register_longitude` varchar(32) DEFAULT NULL,
106 `register_latitude` varchar(32) DEFAULT NULL,
107 `fb_id` varchar(128) DEFAULT NULL,
108 `forget_pass` varchar(255) DEFAULT NULL
109) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
110
111--
112-- Dumping data for table `clients`
113--
114
115INSERT INTO `clients` (`id`, `first_name`, `last_name`, `password`, `email`, `address`, `city`, `zip`, `telephone`, `status`, `verify`, `last_login`, `created`, `updated`, `created_by`, `updated_by`, `registration_type`, `register_country`, `register_country_code`, `register_city`, `register_longitude`, `register_latitude`, `fb_id`, `forget_pass`) VALUES
116(1, 'Astronom', 'Monsrom', '', 'astronom@fmail.ocm', 'adresa', 'grad', '83999393', '062 222 222', 1, '1', NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
117
118-- --------------------------------------------------------
119
120--
121-- Table structure for table `faqs`
122--
123
124CREATE TABLE IF NOT EXISTS `faqs` (
125`id` int(11) NOT NULL,
126 `question` text COLLATE utf8_bin NOT NULL,
127 `answer` text COLLATE utf8_bin NOT NULL,
128 `status` tinyint(1) NOT NULL,
129 `created` datetime NOT NULL,
130 `modified` datetime NOT NULL
131) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
132
133--
134-- Dumping data for table `faqs`
135--
136
137INSERT INTO `faqs` (`id`, `question`, `answer`, `status`, `created`, `modified`) VALUES
138(3, 'Å ta bre ima', '<p>ništa edit</p>\r\n', 1, '2015-05-05 00:38:33', '2015-05-05 00:39:32'),
139(5, 'Zašto bih plaćao RTV pristojbu?', 'RTV pristojba nije naknada za gledanje programa, nego - kako propisuje Zakon o HRT-u - naknada vlasnika radijskoga i/ili televizijskog prijamnika. Ako imate radijski ili televizijski prijamnik, Zakon vas obvezuje da solidarno sa svim drugim vlasnicima prijamnika sudjelujete u financiranju hrvatskoga javnog RTV servisa, to jest Hrvatske radiotelevizije, kao opće društvene potrebe. Primjerice, ceste su isto tako opća društvena potreba: svaki vlasnik registriranog automobila solidarno kod registracije plaća Naknadu za ceste, bez obzira na to koliko se tim cestama vozi. Ni porezna stopa ne određuje se prema tome koliko tko treba neku državnu službu koja se financira iz poreza. Razlika između poreza i RTV pristojbe jest u tome da se RTV pristojba plaća direktno HRT-u: to je jedan od elemenata osiguranja financijske neovisnosti javnog RTV servisa, iz koje tek onda može slijediti i svaka druga neovisnost - nužna za ispunjavanje obveza koje javni servis ima prema javnosti.', 0, '2015-05-05 22:14:30', '2015-05-07 16:50:42');
140
141-- --------------------------------------------------------
142
143--
144-- Table structure for table `groups`
145--
146
147CREATE TABLE IF NOT EXISTS `groups` (
148`id` int(11) NOT NULL,
149 `name` varchar(100) CHARACTER SET utf8 NOT NULL,
150 `created` datetime DEFAULT NULL,
151 `modified` datetime DEFAULT NULL
152) ENGINE=InnoDB DEFAULT CHARSET=latin1;
153
154-- --------------------------------------------------------
155
156--
157-- Table structure for table `images`
158--
159
160CREATE TABLE IF NOT EXISTS `images` (
161`id` int(8) NOT NULL,
162 `product_id` int(8) NOT NULL,
163 `user_id` int(8) NOT NULL,
164 `client_id` int(11) NOT NULL,
165 `field` varchar(30) NOT NULL,
166 `type` varchar(30) NOT NULL,
167 `set` int(5) NOT NULL DEFAULT '0',
168 `url` varchar(255) NOT NULL,
169 `title` varchar(255) NOT NULL,
170 `width` int(5) NOT NULL,
171 `height` int(5) NOT NULL,
172 `order` int(5) NOT NULL DEFAULT '0'
173) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
174
175--
176-- Dumping data for table `images`
177--
178
179INSERT INTO `images` (`id`, `product_id`, `user_id`, `client_id`, `field`, `type`, `set`, `url`, `title`, `width`, `height`, `order`) VALUES
180(1, 0, 14, 0, '', 'image/jpeg', 0, '', '', 0, 0, 0),
181(2, 0, 15, 0, '', 'image/jpeg', 0, '', '', 0, 0, 0),
182(3, 0, 16, 0, '', 'image/jpeg', 0, '', '', 0, 0, 0),
183(4, 0, 17, 0, '', 'image/jpeg', 0, '', '', 0, 0, 0),
184(5, 30, 18, 0, 'user_id', 'original', 1, '/storage/users_logos/548ce5f4-6724-4ce7-9a83-0dc87f00001a-107285501491670997780268683713313n.jpg', '107285501491670997780268683713313n', 720, 960, 0),
185(6, 30, 18, 0, 'user_id', 'small', 1, '/storage/users_logos/thumbs/548ce5f4-6724-4ce7-9a83-0dc87f00001a-107285501491670997780268683713313n-small.jpg', '107285501491670997780268683713313n', 158, 101, 0),
186(7, 30, 18, 0, 'user_id', 'preview', 1, '/storage/users_logos/thumbs/548ce5f4-6724-4ce7-9a83-0dc87f00001a-107285501491670997780268683713313n-preview.jpg', '107285501491670997780268683713313n', 770, 409, 0),
187(8, 30, 19, 0, 'user_id', 'original', 1, '/storage/users_logos/548ce643-e544-4eb1-a403-0dc87f00001a-107285501491670997780268683713313n.jpg', '107285501491670997780268683713313n', 720, 960, 0),
188(9, 0, 19, 0, 'user_id', 'small', 1, '/storage/users_logos/thumbs/548ce643-e544-4eb1-a403-0dc87f00001a-107285501491670997780268683713313n-small.jpg', '107285501491670997780268683713313n', 158, 101, 0),
189(10, 0, 19, 0, 'user_id', 'preview', 1, '/storage/users_logos/thumbs/548ce643-e544-4eb1-a403-0dc87f00001a-107285501491670997780268683713313n-preview.jpg', '107285501491670997780268683713313n', 770, 409, 0),
190(14, 0, 21, 0, 'user_id', 'original', 1, '/storage/users_logos/548ea001-f95c-455f-b8b4-0b507f00001a-107285501491670997780268683713313n.jpg', '107285501491670997780268683713313n', 720, 960, 0),
191(15, 0, 21, 0, 'user_id', 'small', 1, '/storage/users_logos/thumbs/548ea001-f95c-455f-b8b4-0b507f00001a-107285501491670997780268683713313n-small.jpg', '107285501491670997780268683713313n', 158, 101, 0),
192(16, 0, 21, 0, 'user_id', 'preview', 1, '/storage/users_logos/thumbs/548ea001-f95c-455f-b8b4-0b507f00001a-107285501491670997780268683713313n-preview.jpg', '107285501491670997780268683713313n', 770, 409, 0),
193(20, 0, 22, 0, 'user_id', 'original', 1, '/storage/users_logos/54b46769-b2f8-4343-be04-16ec7f00001a-IMG4710.JPG', 'IMG4710', 1280, 960, 0),
194(21, 0, 22, 0, 'user_id', 'small', 1, '/storage/users_logos/thumbs/54b46769-b2f8-4343-be04-16ec7f00001a-IMG4710-small.JPG', 'IMG4710', 158, 101, 0),
195(22, 0, 22, 0, 'user_id', 'preview', 1, '/storage/users_logos/thumbs/54b46769-b2f8-4343-be04-16ec7f00001a-IMG4710-preview.JPG', 'IMG4710', 770, 409, 0);
196
197-- --------------------------------------------------------
198
199--
200-- Table structure for table `memberships`
201--
202
203CREATE TABLE IF NOT EXISTS `memberships` (
204`id` int(11) NOT NULL,
205 `user_id` int(11) NOT NULL,
206 `pricing_id` int(11) NOT NULL,
207 `start_date` date NOT NULL,
208 `end_date` date NOT NULL,
209 `payment_date` date DEFAULT NULL,
210 `price` float(9,3) DEFAULT NULL,
211 `created` datetime DEFAULT NULL,
212 `modified` datetime DEFAULT NULL
213) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
214
215--
216-- Dumping data for table `memberships`
217--
218
219INSERT INTO `memberships` (`id`, `user_id`, `pricing_id`, `start_date`, `end_date`, `payment_date`, `price`, `created`, `modified`) VALUES
220(3, 1, 1, '2015-05-06', '2015-05-29', '2015-05-07', 330.000, '2015-05-06 00:00:00', '2015-05-06 00:00:00'),
221(4, 5, 2, '2015-05-06', '2015-05-21', '2015-05-07', NULL, '2015-05-10 16:05:00', '2015-05-10 16:05:00');
222
223-- --------------------------------------------------------
224
225--
226-- Table structure for table `menus`
227--
228
229CREATE TABLE IF NOT EXISTS `menus` (
230`id` int(9) NOT NULL,
231 `parent_id` int(9) NOT NULL,
232 `lft` int(9) NOT NULL,
233 `rght` int(9) NOT NULL,
234 `url` varchar(100) NOT NULL,
235 `title` varchar(100) NOT NULL,
236 `status` tinyint(1) NOT NULL DEFAULT '0',
237 `type` varchar(100) DEFAULT NULL,
238 `show_on` varchar(50) NOT NULL DEFAULT 'main_menu',
239 `target` varchar(20) NOT NULL DEFAULT '_self',
240 `connection_id` int(9) NOT NULL
241) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
242
243--
244-- Dumping data for table `menus`
245--
246
247INSERT INTO `menus` (`id`, `parent_id`, `lft`, `rght`, `url`, `title`, `status`, `type`, `show_on`, `target`, `connection_id`) VALUES
248(1, 0, 1, 2, '/', 'Home', 1, 'custom', 'main_menu', '_self', 0),
249(2, 0, 5, 6, '/news', 'Novosti', 1, 'news', 'main_menu', '_self', 0),
250(4, 0, 7, 8, '/galleries', 'Galerija', 1, 'custom', 'main_menu', '_self', 0),
251(7, 0, 7, 8, '/abouts', 'O nama', 1, 'custom', 'main_menu', '_self', 1),
252(10, 0, 9, 10, '/contacts', 'Kontakt', 1, 'custom', 'main_menu', '_self', 0);
253
254-- --------------------------------------------------------
255
256--
257-- Table structure for table `metrics`
258--
259
260CREATE TABLE IF NOT EXISTS `metrics` (
261`id` int(11) NOT NULL,
262 `user_id` int(11) NOT NULL,
263 `kg` float DEFAULT NULL,
264 `struk` float DEFAULT NULL,
265 `nadkoljenica` float DEFAULT NULL,
266 `list` float DEFAULT NULL,
267 `nadlaktica` float DEFAULT NULL,
268 `iznad_struka` float DEFAULT NULL,
269 `masti` float DEFAULT NULL,
270 `date` date DEFAULT NULL,
271 `created` datetime NOT NULL,
272 `updated` datetime NOT NULL
273) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
274
275--
276-- Dumping data for table `metrics`
277--
278
279INSERT INTO `metrics` (`id`, `user_id`, `kg`, `struk`, `nadkoljenica`, `list`, `nadlaktica`, `iznad_struka`, `masti`, `date`, `created`, `updated`) VALUES
280(2, 1, 40, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00', '2015-05-05 22:56:43', '2015-05-05 23:04:28'),
281(3, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00', '2015-05-05 23:15:17', '2015-05-05 23:15:17'),
282(5, 5, 3, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-07', '2015-05-05 23:20:15', '2015-05-05 23:47:47'),
283(6, 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, '2015-05-22', '2015-05-05 23:20:49', '2015-05-05 23:23:27'),
284(7, 1, 33, NULL, NULL, NULL, NULL, NULL, NULL, '2015-05-05', '2015-05-05 23:46:52', '2015-05-05 23:46:52'),
285(8, 6, 347349, 324, 4324, -4324, 3, 32423, 4324, '2015-05-12', '2015-05-10 16:03:59', '2015-05-11 23:59:32'),
286(9, 5, 25, 25, 25, 18, 25, 25, 25, '2015-05-11', '2015-05-11 23:57:40', '2015-05-11 23:57:40');
287
288-- --------------------------------------------------------
289
290--
291-- Table structure for table `news`
292--
293
294CREATE TABLE IF NOT EXISTS `news` (
295`id` int(9) NOT NULL,
296 `slug` varchar(180) NOT NULL,
297 `title` varchar(170) NOT NULL,
298 `description` text NOT NULL,
299 `content` text NOT NULL,
300 `status` tinyint(1) NOT NULL,
301 `promoted` tinyint(1) DEFAULT '0',
302 `created` datetime NOT NULL,
303 `updated` datetime NOT NULL
304) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
305
306--
307-- Dumping data for table `news`
308--
309
310INSERT INTO `news` (`id`, `slug`, `title`, `description`, `content`, `status`, `promoted`, `created`, `updated`) VALUES
311(21, 'vijest-1', 'Vijest 1', 'description vijest 1 description vijest 1 description vijest 1 description vijest 1 description vijest 1 description vijest 1 description vijest 1 description vijest 1 description vijest 1 ', '<p>vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1vijest 1</p>\r\n', 1, 0, '2013-10-11 12:16:35', '2013-10-11 12:16:35'),
312(23, 'vijest-3', 'vijest 3', 'decritpion viejest 3decritpion viejest 3decritpion viejest 3decritpion viejest 3decritpion viejest 3decritpion viejest 3', '<p>contenct 3contenct 3contenct 3</p>\r\n\r\n<p>contenct 3</p>\r\n\r\n<p>contenct 3contenct 3contenct 3contenct 3contenct 3contenct 3</p>\r\n', 1, 0, '2013-10-11 12:17:44', '2013-10-11 12:17:44'),
313(24, 'vijest-4', 'Vijest 4', 'virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34virjest desc 34', '<p>dsdjsdjsdjsdsd</p>\r\n', 1, 0, '2013-10-11 12:18:26', '2013-10-11 12:44:40'),
314(25, 'bajramska-cestitka', 'Bajramska ÄŒestitka', 'Bajram Ĺ erif Mubarek Olsun', '<p>Povodom nastupajućeg muslimanskog praznika Kurban bajrama,<br />\r\nosoblje resotrana-pizzerie "BLITZ" Ĺľeli da ga provedete u zdravlju i veselju sa svojim najbliĹľim uz poruku "Bajram Šerif Mubarek Olsun".</p>\r\n', 1, 1, '2013-10-16 13:37:19', '2013-11-10 17:38:56'),
315(26, 'danas-je-dan-republike1', 'Danas je dan republike1', 'fdsfdsfds', '<p>fdsfsfds</p>\r\n', 1, 0, '2015-05-12 16:58:12', '2013-11-11 00:13:46'),
316(29, 'aaa', 'aaa', 'aaa', 'aa', 1, 0, '2015-05-12 15:49:21', '2015-05-12 16:01:18'),
317(30, 'testtt', 'testtt', 'test', 'test', 1, 1, '2015-05-12 16:03:01', '2015-05-12 16:12:25');
318
319-- --------------------------------------------------------
320
321--
322-- Table structure for table `newsletters`
323--
324
325CREATE TABLE IF NOT EXISTS `newsletters` (
326`id` int(11) NOT NULL,
327 `name` text NOT NULL,
328 `email` text NOT NULL,
329 `created` datetime NOT NULL,
330 `updated` datetime NOT NULL
331) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
332
333--
334-- Dumping data for table `newsletters`
335--
336
337INSERT INTO `newsletters` (`id`, `name`, `email`, `created`, `updated`) VALUES
338(2, 'test', 'test', '2015-05-07 00:00:00', '2015-05-20 00:00:00');
339
340-- --------------------------------------------------------
341
342--
343-- Table structure for table `news_categories`
344--
345
346CREATE TABLE IF NOT EXISTS `news_categories` (
347`id` int(5) NOT NULL,
348 `parent_id` int(5) NOT NULL,
349 `lft` int(5) NOT NULL,
350 `rght` int(5) NOT NULL,
351 `slug` varchar(100) NOT NULL,
352 `title` varchar(100) NOT NULL,
353 `products_count` int(8) NOT NULL,
354 `products_published` int(8) NOT NULL,
355 `status` tinyint(1) NOT NULL,
356 `menu` tinyint(1) NOT NULL DEFAULT '1',
357 `type` int(11) DEFAULT NULL
358) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
359
360--
361-- Dumping data for table `news_categories`
362--
363
364INSERT INTO `news_categories` (`id`, `parent_id`, `lft`, `rght`, `slug`, `title`, `products_count`, `products_published`, `status`, `menu`, `type`) VALUES
365(1, 0, 7, 8, 'mobiles', 'Mobiles', 0, 0, 1, 1, NULL),
366(2, 0, 1, 6, 'computers', 'Computers', 0, 0, 1, 1, NULL),
367(3, 0, 9, 10, 'parent_category', 'Parent category', 0, 0, 1, 1, NULL),
368(4, 2, 11, 12, 'apple', 'Apple', 0, 0, 1, 1, NULL),
369(5, 2, 4, 5, 'ibm', 'IBM', 0, 0, 1, 1, NULL),
370(6, 2, 2, 3, 'intel', 'Intel', 0, 0, 1, 1, NULL);
371
372-- --------------------------------------------------------
373
374--
375-- Table structure for table `news_images`
376--
377
378CREATE TABLE IF NOT EXISTS `news_images` (
379`id` int(8) NOT NULL,
380 `news_id` int(8) NOT NULL,
381 `field` varchar(30) NOT NULL,
382 `type` varchar(30) NOT NULL,
383 `set` int(5) NOT NULL DEFAULT '0',
384 `url` varchar(255) NOT NULL,
385 `title` varchar(255) NOT NULL,
386 `width` int(5) NOT NULL,
387 `height` int(5) NOT NULL,
388 `order` int(5) NOT NULL DEFAULT '0'
389) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
390
391--
392-- Dumping data for table `news_images`
393--
394
395INSERT INTO `news_images` (`id`, `news_id`, `field`, `type`, `set`, `url`, `title`, `width`, `height`, `order`) VALUES
396(1, 2, 'img', 'original', 1, '/storage/news/images/5152ec82-9a1c-49a9-8759-0406b0765237-100_0893.jpg', '100_0893', 800, 600, 0),
397(2, 2, 'img', 'big', 1, '/storage/news/images/thumbs/5152ec82-9a1c-49a9-8759-0406b0765237-100_0893-big.jpg', '100_0893', 600, 400, 0),
398(3, 2, 'img', 'small', 1, '/storage/news/images/thumbs/5152ec82-9a1c-49a9-8759-0406b0765237-100_0893-small.jpg', '100_0893', 60, 60, 0),
399(4, 3, 'img', 'original', 1, '/storage/news/images/5152ec9a-cc2c-4378-bb44-0682b0765237-P7281220.jpg', 'P7281220', 800, 600, 0),
400(5, 3, 'img', 'big', 1, '/storage/news/images/thumbs/5152ec9a-cc2c-4378-bb44-0682b0765237-P7281220-big.jpg', 'P7281220', 600, 400, 0),
401(6, 3, 'img', 'small', 1, '/storage/news/images/thumbs/5152ec9a-cc2c-4378-bb44-0682b0765237-P7281220-small.jpg', 'P7281220', 60, 60, 0),
402(19, 5, 'img', 'original', 1, '/storage/news/images/5152f14d-2838-467c-be5a-0771b0765237-100_0875.jpg', '100_0875', 800, 600, 0),
403(20, 5, 'img', 'big', 1, '/storage/news/images/thumbs/5152f14d-2838-467c-be5a-0771b0765237-100_0875-big.jpg', '100_0875', 691, 364, 0),
404(21, 5, 'img', 'small', 1, '/storage/news/images/thumbs/5152f14d-2838-467c-be5a-0771b0765237-100_0875-small.jpg', '100_0875', 60, 60, 0),
405(22, 9, 'img', 'original', 1, '/storage/news/images/5165a499-bc54-4aaf-b8fb-21ceb0765237-Screen Shot 2013-04-10 at 12.45.12 PM.jpg', 'Screen Shot 2013-04-10 at 12.45.12 PM', 1440, 900, 0),
406(23, 9, 'img', 'big', 1, '/storage/news/images/thumbs/5165a499-bc54-4aaf-b8fb-21ceb0765237-Screen Shot 2013-04-10 at 12.45.12 PM-big.jpg', 'Screen Shot 2013-04-10 at 12.45.12 PM', 691, 364, 0),
407(24, 9, 'img', 'small', 1, '/storage/news/images/thumbs/5165a499-bc54-4aaf-b8fb-21ceb0765237-Screen Shot 2013-04-10 at 12.45.12 PM-small.jpg', 'Screen Shot 2013-04-10 at 12.45.12 PM', 126, 139, 0),
408(28, 12, 'img', 'original', 1, '/storage/news/images/5165d469-7694-4c05-b243-2458b0765237-aaaa.jpg', 'aaaa', 960, 720, 0),
409(29, 12, 'img', 'big', 1, '/storage/news/images/thumbs/5165d469-7694-4c05-b243-2458b0765237-aaaa-big.jpg', 'aaaa', 691, 364, 0),
410(30, 12, 'img', 'small', 1, '/storage/news/images/thumbs/5165d469-7694-4c05-b243-2458b0765237-aaaa-small.jpg', 'aaaa', 126, 139, 0),
411(31, 11, 'img', 'original', 1, '/storage/news/images/5165d771-3278-41ff-8ff9-24d6b0765237-534951_354183881354086_1021178592_n.jpg', '534951_354183881354086_1021178592_n', 960, 720, 0),
412(32, 11, 'img', 'big', 1, '/storage/news/images/thumbs/5165d771-3278-41ff-8ff9-24d6b0765237-534951_354183881354086_1021178592_n-big.jpg', '534951_354183881354086_1021178592_n', 691, 364, 0),
413(33, 11, 'img', 'small', 1, '/storage/news/images/thumbs/5165d771-3278-41ff-8ff9-24d6b0765237-534951_354183881354086_1021178592_n-small.jpg', '534951_354183881354086_1021178592_n', 300, 133, 0),
414(34, 13, 'img', 'original', 1, '/storage/news/images/5167d3aa-e8c8-424a-8dd7-4767b0765237-IMG_0349.jpg', 'IMG_0349', 620, 465, 0),
415(35, 13, 'img', 'big', 1, '/storage/news/images/thumbs/5167d3aa-e8c8-424a-8dd7-4767b0765237-IMG_0349-big.jpg', 'IMG_0349', 548, 243, 0),
416(36, 13, 'img', 'small', 1, '/storage/news/images/thumbs/5167d3aa-e8c8-424a-8dd7-4767b0765237-IMG_0349-small.jpg', 'IMG_0349', 300, 133, 0),
417(37, 18, 'img', 'original', 1, '/storage/news/images/5257c94c-6e48-462c-bbca-1e607f000002-Chrysanthemum.jpg', 'Chrysanthemum', 1024, 768, 0),
418(38, 18, 'img', 'big', 1, '/storage/news/images/thumbs/5257c94c-6e48-462c-bbca-1e607f000002-Chrysanthemum-big.jpg', 'Chrysanthemum', 548, 243, 0),
419(39, 18, 'img', 'small', 1, '/storage/news/images/thumbs/5257c94c-6e48-462c-bbca-1e607f000002-Chrysanthemum-small.jpg', 'Chrysanthemum', 300, 133, 0),
420(40, 19, 'img', 'original', 1, '/storage/news/images/5257c9c2-d128-4a50-8516-1e607f000002-Desert.jpg', 'Desert', 1024, 768, 0),
421(41, 19, 'img', 'big', 1, '/storage/news/images/thumbs/5257c9c2-d128-4a50-8516-1e607f000002-Desert-big.jpg', 'Desert', 548, 243, 0),
422(42, 19, 'img', 'small', 1, '/storage/news/images/thumbs/5257c9c2-d128-4a50-8516-1e607f000002-Desert-small.jpg', 'Desert', 300, 133, 0),
423(43, 20, 'img', 'original', 1, '/storage/news/images/5257cc57-99e4-460c-ab4c-1e607f000002-Penguins.jpg', 'Penguins', 1024, 768, 0),
424(44, 20, 'img', 'big', 1, '/storage/news/images/thumbs/5257cc57-99e4-460c-ab4c-1e607f000002-Penguins-big.jpg', 'Penguins', 548, 243, 0),
425(45, 20, 'img', 'small', 1, '/storage/news/images/thumbs/5257cc57-99e4-460c-ab4c-1e607f000002-Penguins-small.jpg', 'Penguins', 300, 133, 0),
426(46, 21, 'img', 'original', 1, '/storage/news/images/5257d003-fd04-48a6-86bb-1e607f000002-Jellyfish.jpg', 'Jellyfish', 1024, 768, 0),
427(47, 21, 'img', 'big', 1, '/storage/news/images/thumbs/5257d003-fd04-48a6-86bb-1e607f000002-Jellyfish-big.jpg', 'Jellyfish', 548, 243, 0),
428(48, 21, 'img', 'small', 1, '/storage/news/images/thumbs/5257d003-fd04-48a6-86bb-1e607f000002-Jellyfish-small.jpg', 'Jellyfish', 300, 133, 0),
429(49, 22, 'img', 'original', 1, '/storage/news/images/5257d026-de18-4726-a529-1e607f000002-Koala.jpg', 'Koala', 1024, 768, 0),
430(50, 22, 'img', 'big', 1, '/storage/news/images/thumbs/5257d026-de18-4726-a529-1e607f000002-Koala-big.jpg', 'Koala', 548, 243, 0),
431(51, 22, 'img', 'small', 1, '/storage/news/images/thumbs/5257d026-de18-4726-a529-1e607f000002-Koala-small.jpg', 'Koala', 300, 133, 0),
432(52, 23, 'img', 'original', 1, '/storage/news/images/5257d048-4318-4732-a5b0-1e607f000002-Penguins.jpg', 'Penguins', 1024, 768, 0),
433(53, 23, 'img', 'big', 1, '/storage/news/images/thumbs/5257d048-4318-4732-a5b0-1e607f000002-Penguins-big.jpg', 'Penguins', 548, 243, 0),
434(54, 23, 'img', 'small', 1, '/storage/news/images/thumbs/5257d048-4318-4732-a5b0-1e607f000002-Penguins-small.jpg', 'Penguins', 300, 133, 0),
435(55, 24, 'img', 'original', 1, '/storage/news/images/5257d072-1194-4168-82fc-1e607f000002-Chrysanthemum.jpg', 'Chrysanthemum', 1024, 768, 0),
436(56, 24, 'img', 'big', 1, '/storage/news/images/thumbs/5257d072-1194-4168-82fc-1e607f000002-Chrysanthemum-big.jpg', 'Chrysanthemum', 548, 243, 0),
437(57, 24, 'img', 'small', 1, '/storage/news/images/thumbs/5257d072-1194-4168-82fc-1e607f000002-Chrysanthemum-small.jpg', 'Chrysanthemum', 300, 133, 0),
438(58, 25, 'img', 'original', 1, '/storage/news/images/525e7a6f-80ac-4190-95e5-09607f000002-CestitkaBajram.jpg', 'CestitkaBajram', 655, 393, 0),
439(59, 25, 'img', 'big', 1, '/storage/news/images/thumbs/525e7a6f-80ac-4190-95e5-09607f000002-CestitkaBajram-big.jpg', 'CestitkaBajram', 548, 243, 0),
440(60, 25, 'img', 'small', 1, '/storage/news/images/thumbs/525e7a6f-80ac-4190-95e5-09607f000002-CestitkaBajram-small.jpg', 'CestitkaBajram', 300, 133, 0),
441(61, 27, 'img', 'original', 1, '/storage/news/images/527fb9c6-2b44-46c4-9359-00d47f000002-Chrysanthemum.jpg', 'Chrysanthemum', 1024, 768, 0),
442(62, 27, 'img', 'big', 1, '/storage/news/images/thumbs/527fb9c6-2b44-46c4-9359-00d47f000002-Chrysanthemum-big.jpg', 'Chrysanthemum', 548, 243, 0),
443(63, 27, 'img', 'small', 1, '/storage/news/images/thumbs/527fb9c6-2b44-46c4-9359-00d47f000002-Chrysanthemum-small.jpg', 'Chrysanthemum', 300, 133, 0),
444(64, 26, 'img', 'original', 1, '/storage/news/images/5280132a-1670-443a-a1d9-18e87f000002-Chrysanthemum.jpg', 'Chrysanthemum', 1024, 768, 0),
445(65, 26, 'img', 'big', 1, '/storage/news/images/thumbs/5280132a-1670-443a-a1d9-18e87f000002-Chrysanthemum-big.jpg', 'Chrysanthemum', 548, 243, 0),
446(66, 26, 'img', 'small', 1, '/storage/news/images/thumbs/5280132a-1670-443a-a1d9-18e87f000002-Chrysanthemum-small.jpg', 'Chrysanthemum', 300, 133, 0),
447(67, 27, 'img', 'original', 2, '/storage/news/images/5281391a-2e54-4685-9019-06dc7f000002-Chrysanthemum.jpg', 'Chrysanthemum', 1024, 768, 1),
448(68, 27, 'img', 'big', 2, '/storage/news/images/thumbs/5281391a-2e54-4685-9019-06dc7f000002-Chrysanthemum-big.jpg', 'Chrysanthemum', 548, 243, 1),
449(69, 27, 'img', 'small', 2, '/storage/news/images/thumbs/5281391a-2e54-4685-9019-06dc7f000002-Chrysanthemum-small.jpg', 'Chrysanthemum', 300, 133, 1);
450
451-- --------------------------------------------------------
452
453--
454-- Table structure for table `pages`
455--
456
457CREATE TABLE IF NOT EXISTS `pages` (
458`id` int(9) NOT NULL,
459 `slug` varchar(80) NOT NULL,
460 `type` int(4) NOT NULL,
461 `title` varchar(70) NOT NULL,
462 `content` text NOT NULL,
463 `status` tinyint(1) NOT NULL,
464 `created` datetime NOT NULL,
465 `updated` datetime NOT NULL
466) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
467
468--
469-- Dumping data for table `pages`
470--
471
472INSERT INTO `pages` (`id`, `slug`, `type`, `title`, `content`, `status`, `created`, `updated`) VALUES
473(1, 'ma-proji-se', 0, 'Ma proji se', '<p>Nulla in lectus sit amet purus rutrum tempor sed nec felis. Pellentesque ornare lobortis volutpat. Pellentesque aliq<big><strong>uam laoreet nisi, dictum mattis magna sagittis eget. Etiam amet. Nulla in lectus sit amet purus rutrum tempor sed nec felis. Pellentesque ornare lobortis volutpat. Pellentesque aliquam laoreet nisi, dict</strong></big>um mattis magna sagittis eget. Etiam amet. Nulla in lectus sit amet purus rutrum tempor sed nec felis. Pellentesque ornare lobortis volutpat. Pellentesque aliquam laoreet nisi, dictum mattis magna sagittis eget. Etiam amet. Nulla in lectus sit amet purus rutrum tempor sed nec felis. Pellentesque ornare lobortis volutpat. Pellentesque aliquam laoreet nisi, dictum mattis magna sagittis eget. Etiam amet. Nulla in lectus sit amet purus rutrum tempor sed nec felis. Pellentesque ornare lobortis volutpat. Pellentesque aliquam laoreet nisi, dictum mattis magna sagittis eget. Etiam amet. Nulla in lectus sit amet purus rutrum tempor sed nec felis. Pellentesque ornare lobortis volutpat. Pellentesque aliquam laoreet nisi, dictum mattis magna sagittis eget. Etiam amet.</p>\r\n', 1, '2013-04-10 21:23:32', '2013-11-14 09:01:09'),
474(2, 'profi', 0, 'profi', '<p>hahaha ovo je zakon</p>\r\n', 1, '2013-10-16 16:54:47', '2013-10-16 16:54:47');
475
476-- --------------------------------------------------------
477
478--
479-- Table structure for table `pricings`
480--
481
482CREATE TABLE IF NOT EXISTS `pricings` (
483`id` int(11) NOT NULL,
484 `title` text COLLATE utf8_bin NOT NULL,
485 `description` text COLLATE utf8_bin,
486 `price` int(11) DEFAULT NULL,
487 `period` varchar(254) COLLATE utf8_bin DEFAULT NULL,
488 `created` datetime NOT NULL,
489 `updated` datetime NOT NULL
490) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
491
492--
493-- Dumping data for table `pricings`
494--
495
496INSERT INTO `pricings` (`id`, `title`, `description`, `price`, `period`, `created`, `updated`) VALUES
497(1, 'BotCamp spartak', '<p>22tat ed</p>\r\n', 25, '', '2015-05-07 00:00:00', '2015-05-06 17:08:05'),
498(2, 'treniranje mjesec', 'zjkjzcenieisi f', 59, '1 mjesec', '2015-05-10 15:47:31', '2015-05-10 15:47:31');
499
500-- --------------------------------------------------------
501
502--
503-- Table structure for table `programs`
504--
505
506CREATE TABLE IF NOT EXISTS `programs` (
507`id` int(11) NOT NULL,
508 `title` varchar(255) CHARACTER SET utf8 NOT NULL,
509 `slug` varchar(254) CHARACTER SET utf8 NOT NULL,
510 `description` varchar(255) CHARACTER SET utf8 NOT NULL,
511 `html` text,
512 `program_type_id` int(11) NOT NULL,
513 `duration` varchar(255) CHARACTER SET utf8 NOT NULL,
514 `price` int(11) NOT NULL,
515 `is_free` tinyint(1) DEFAULT '0',
516 `status` tinyint(1) DEFAULT '0',
517 `created` datetime NOT NULL,
518 `updated` datetime NOT NULL
519) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
520
521--
522-- Dumping data for table `programs`
523--
524
525INSERT INTO `programs` (`id`, `title`, `slug`, `description`, `html`, `program_type_id`, `duration`, `price`, `is_free`, `status`, `created`, `updated`) VALUES
526(2, 'test', 'test', 'test', '', 1, '4', 3, 1, 1, '2015-05-03 23:19:01', '2015-05-03 23:19:01'),
527(3, 'novi program', '', 'guljenje kilaze', '', 1, '4', 329, 1, 1, '2015-05-04 18:57:33', '2015-05-04 18:57:33'),
528(5, 'Qui ullam alias non rerum blanditiis sequi aut', '', 'Architecto assumenda quae lorem provident atque aliquip molestias ut sit', '', 1, 'Aut ad ipsum dolore iste cum in aut sapiente', 26, 0, 1, '2015-05-04 19:09:05', '2015-05-04 19:09:05'),
529(6, 'Dolores sequi accusantium dolor enim est ipsum quia sunt minus neque dolorem qui quia velit odio commodi', '', 'Exercitation veritatis aute non magnam tempor nulla eum praesentium natus ut voluptate enim dolore tempor deserunt dolores dolor odit', '', 1, 'Maxime voluptate et similique illum harum possimus ex do quod sint qui officia et ea incididunt sunt dolor quis', 29, 0, 0, '2015-05-04 19:58:53', '2015-05-04 20:10:59'),
530(7, 'Nemo corporis earum aliquip consequat Et in amet minus in ratione consectetur sed anim exercitation', '', 'Tenetur unde in consequatur voluptas a laborum Qui qui aut reprehenderit ullam optio dolore', '', 1, 'Obcaecati non rerum tempor veritatis expedita tempora laborum Ea sequi laboris eius et eum mollit soluta exercitation id commodi numquam', 68, 1, 0, '2015-05-04 20:12:14', '2015-05-04 20:12:23'),
531(8, 'radi', 'radi', 'Cumque minim numquam hic veritatis dolor ex porro enim', '', 1, 'Ea labore aliquid quis ut velit maxime animi tempore blanditiis voluptatem sunt molestias quia nisi id consectetur omnis', 55, 0, 1, '2015-05-04 20:27:16', '2015-05-04 20:28:26'),
532(9, 'test5', 'test5', 'Quidem id obcaecati ex nostrud in sed eligendi eaque nihil et tenetur autem minus suscipit hic nemo voluptatum quia est', '', 0, 'Eos voluptatem assumenda pariatur Omnis cumque possimus sed ratione non id id earum sint quo qui magni sit quia excepteur', 84, 0, 1, '2015-05-04 20:32:43', '2015-05-04 20:39:41'),
533(10, 'Est perspiciatis inventore eaque minim exercitation sit dignissimos sit amet sed quaerat laudantium velit minima', 'est-perspiciatis-inventore-eaque-minim-exercitation-sit-dignissimos-sit-amet-sed-quaerat-laudantium-velit-minima', 'Nisi do et in modi ab odit magni cupiditate nostrud aut aut deserunt', '', 0, 'Provident ex sit qui asperiores', 58, 1, 0, '2015-05-04 22:53:24', '2015-05-04 22:53:24'),
534(11, 'Officia qui fuga Ipsum ea autem lorem aliqua Dolor sunt', 'officia-qui-fuga-ipsum-ea-autem-lorem-aliqua-dolor-sunt', 'Cumque est eiusmod laborum dolore sit', '', 0, 'Voluptatibus facere ad dolorem earum ullamco', 1, 1, 1, '2015-05-04 22:55:08', '2015-05-04 22:59:48'),
535(12, 'Adipisicing rem quos error molestiae sed laborum minus iusto', 'adipisicing-rem-quos-error-molestiae-sed-laborum-minus-iusto', 'Sequi eos commodi mollit voluptas', '', 0, 'Voluptas atque nihil ipsam id', 46, 1, 1, '2015-05-04 23:00:05', '2015-05-06 22:40:38'),
536(14, 'Lagano bagamo', 'lagano-bagamo', 'TEST', '', 0, '25', 25, 0, 1, '2015-05-06 23:12:47', '2015-05-06 23:14:50'),
537(15, 'btc amp', 'btc-amp', 'ti u titit eneunuenfueufeu', 'dsd', 0, '21', 599, 0, 1, '2015-05-10 16:23:12', '2015-05-10 18:35:26');
538
539-- --------------------------------------------------------
540
541--
542-- Table structure for table `programtypes`
543--
544
545CREATE TABLE IF NOT EXISTS `programtypes` (
546`id` int(11) NOT NULL,
547 `title` varchar(254) CHARACTER SET utf8 NOT NULL
548) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
549
550--
551-- Dumping data for table `programtypes`
552--
553
554INSERT INTO `programtypes` (`id`, `title`) VALUES
555(1, 'test23');
556
557-- --------------------------------------------------------
558
559--
560-- Table structure for table `program_images`
561--
562
563CREATE TABLE IF NOT EXISTS `program_images` (
564`id` int(11) unsigned NOT NULL,
565 `program_id` int(11) NOT NULL,
566 `field` varchar(20) NOT NULL DEFAULT '',
567 `type` varchar(20) NOT NULL DEFAULT '',
568 `set` int(5) NOT NULL,
569 `url` varchar(255) NOT NULL DEFAULT '',
570 `title` varchar(255) NOT NULL DEFAULT '',
571 `width` int(5) NOT NULL,
572 `height` int(5) NOT NULL,
573 `order` int(5) NOT NULL
574) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
575
576--
577-- Dumping data for table `program_images`
578--
579
580INSERT INTO `program_images` (`id`, `program_id`, `field`, `type`, `set`, `url`, `title`, `width`, `height`, `order`) VALUES
581(1, 10, 'program_id', 'original', 1, '/storage/program/images/5547dc44-6474-4cc3-a361-26c87f00001d-14789404880149413081251292159362n.jpg', '14789404880149413081251292159362n', 851, 315, 0),
582(2, 10, 'program_id', 'big', 1, '/storage/program/images/thumbs/5547dc44-6474-4cc3-a361-26c87f00001d-14789404880149413081251292159362n-big.jpg', '14789404880149413081251292159362n', 800, 600, 0),
583(3, 10, 'program_id', 'small', 1, '/storage/program/images/thumbs/5547dc44-6474-4cc3-a361-26c87f00001d-14789404880149413081251292159362n-small.jpg', '14789404880149413081251292159362n', 370, 221, 0),
584(4, 10, 'program_id', 'smallp', 1, '/storage/program/images/thumbs/5547dc44-6474-4cc3-a361-26c87f00001d-14789404880149413081251292159362n-smallp.jpg', '14789404880149413081251292159362n', 195, 195, 0),
585(9, 11, 'program_id', 'original', 1, '/storage/program/images/5547ddc4-5068-4527-ab74-26c87f00001d-111248381593386997570449359213313353305614n.jpg', '111248381593386997570449359213313353305614n', 818, 540, 0),
586(10, 11, 'program_id', 'big', 1, '/storage/program/images/thumbs/5547ddc4-5068-4527-ab74-26c87f00001d-111248381593386997570449359213313353305614n-big.jpg', '111248381593386997570449359213313353305614n', 800, 600, 0),
587(11, 11, 'program_id', 'small', 1, '/storage/program/images/thumbs/5547ddc4-5068-4527-ab74-26c87f00001d-111248381593386997570449359213313353305614n-small.jpg', '111248381593386997570449359213313353305614n', 370, 221, 0),
588(12, 12, 'program_id', 'original', 1, '/storage/program/images/5547dddc-c4d0-41e2-8553-26c87f00001d-116715782013389892163483274223392061961n.jpg', '116715782013389892163483274223392061961n', 960, 905, 0),
589(13, 12, 'program_id', 'big', 1, '/storage/program/images/thumbs/5547dddc-c4d0-41e2-8553-26c87f00001d-116715782013389892163483274223392061961n-big.jpg', '116715782013389892163483274223392061961n', 800, 600, 0),
590(14, 12, 'program_id', 'small', 1, '/storage/program/images/thumbs/5547dddc-c4d0-41e2-8553-26c87f00001d-116715782013389892163483274223392061961n-small.jpg', '116715782013389892163483274223392061961n', 370, 221, 0),
591(15, 13, 'program_id', 'original', 1, '/storage/program/images/554a8123-00dc-47c2-965d-06607f000007-irontexture47.jpg', 'irontexture47', 1333, 836, 0),
592(16, 13, 'program_id', 'big', 1, '/storage/program/images/thumbs/554a8123-00dc-47c2-965d-06607f000007-irontexture47-big.jpg', 'irontexture47', 800, 600, 0),
593(17, 13, 'program_id', 'small', 1, '/storage/program/images/thumbs/554a8123-00dc-47c2-965d-06607f000007-irontexture47-small.jpg', 'irontexture47', 370, 221, 0),
594(18, 14, 'program_id', 'original', 1, '/storage/program/images/554a83cf-6694-4ff1-ac9f-06607f000007-WIN20141212161733.jpg', 'WIN20141212161733', 640, 480, 0),
595(19, 14, 'program_id', 'big', 1, '/storage/program/images/thumbs/554a83cf-6694-4ff1-ac9f-06607f000007-WIN20141212161733-big.jpg', 'WIN20141212161733', 800, 600, 0),
596(20, 14, 'program_id', 'small', 1, '/storage/program/images/thumbs/554a83cf-6694-4ff1-ac9f-06607f000007-WIN20141212161733-small.jpg', 'WIN20141212161733', 370, 221, 0),
597(21, 15, 'program_id', 'original', 1, '/storage/program/images/554f69d0-8b40-47cb-98bd-1ca87f00001d-tumblrmdd1rt12dN1rfamyso1500438x260.jpg', 'tumblrmdd1rt12dN1rfamyso1500438x260', 438, 260, 0),
598(22, 15, 'program_id', 'big', 1, '/storage/program/images/thumbs/554f69d0-8b40-47cb-98bd-1ca87f00001d-tumblrmdd1rt12dN1rfamyso1500438x260-big.jpg', 'tumblrmdd1rt12dN1rfamyso1500438x260', 800, 600, 0),
599(23, 15, 'program_id', 'small', 1, '/storage/program/images/thumbs/554f69d0-8b40-47cb-98bd-1ca87f00001d-tumblrmdd1rt12dN1rfamyso1500438x260-small.jpg', 'tumblrmdd1rt12dN1rfamyso1500438x260', 370, 221, 0);
600
601-- --------------------------------------------------------
602
603--
604-- Table structure for table `site_configs`
605--
606
607CREATE TABLE IF NOT EXISTS `site_configs` (
608`id` int(1) unsigned NOT NULL,
609 `title` varchar(255) NOT NULL DEFAULT '',
610 `description` text NOT NULL,
611 `keywords` varchar(255) DEFAULT NULL,
612 `copyright` varchar(255) DEFAULT NULL,
613 `email` varchar(64) NOT NULL DEFAULT '',
614 `company_name` varchar(255) DEFAULT NULL,
615 `address` varchar(255) DEFAULT NULL,
616 `city` varchar(255) DEFAULT NULL,
617 `zip` varchar(20) DEFAULT NULL,
618 `fax` varchar(255) DEFAULT NULL,
619 `phone` varchar(255) DEFAULT NULL,
620 `theme` varchar(255) NOT NULL DEFAULT 'Default',
621 `created` datetime NOT NULL,
622 `updated` datetime NOT NULL,
623 `analytics_code` text,
624 `country` varchar(255) DEFAULT NULL,
625 `custom_data` text,
626 `slogan` varchar(255) DEFAULT NULL,
627 `field19` varchar(255) DEFAULT 'By Dino Hadziahmetovic'
628) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
629
630--
631-- Dumping data for table `site_configs`
632--
633
634INSERT INTO `site_configs` (`id`, `title`, `description`, `keywords`, `copyright`, `email`, `company_name`, `address`, `city`, `zip`, `fax`, `phone`, `theme`, `created`, `updated`, `analytics_code`, `country`, `custom_data`, `slogan`, `field19`) VALUES
635(1, 'test', 'Dobrodosli u restoran-pizzeriu "Blitz", uzivajte.', 'blitz,resotran pizzeria blitz, pizzeria blitz, restoran blitz, restoran-pizzeria blitz, restaurant blitz', 'Restoran-Pizzeria "BLITZ"', 'info@blitz.ba', 'Restoran Pizzeria "BLITZ"', 'Odvode lamele 2. bb', 'Gornji Vakuf', '70240', '030 / 260 - 531', '030 / 260 - 530', 'Default', '2013-04-10 18:38:08', '2015-05-03 00:49:15', '', 'Bosna i Hercegovina', '<p>sadasdasd</p>\r\n', 'Dobrodosli u nas resotran, nadamo se da ce vam se svidjeti !', 'By Dino Hadziahmetovic'),
636(2, 'Džemal Gekić', 'Dobro došli ...', 'blitz,resotran pizzeria blitz, pizzeria blitz, restoran blitz, restoran-pizzeria blitz, restaurant blitz', 'Džemal Gekić BTC', 'info@btc.ba', 'Džemal Gekić BTC', 'Odvode lamele 2. bb', 'Gornji Vakuf', '70240', '99999999', '99999', 'Default', '2015-05-03 00:37:53', '2015-05-03 00:37:53', '', 'Bosna i Hercegovina', '<p>sadasdasd</p>\r\n', 'Dobrodosli u nas resotran, nadamo se da ce vam se svidjeti !', 'By Dino Hadziahmetovic'),
637(3, 'test', 'Dobrodosli u restoran-pizzeriu "Blitz", uzivajte.', 'blitz,resotran pizzeria blitz, pizzeria blitz, restoran blitz, restoran-pizzeria blitz, restaurant blitz', 'Restoran-Pizzeria "BLITZ"', 'info@blitz.ba', 'Restoran Pizzeria "BLITZ"', 'Odvode lamele 2. bb', 'Gornji Vakuf', '70240', '030 / 260 - 531', '030 / 260 - 530', 'Default', '2015-05-03 00:43:40', '2015-05-03 00:43:40', '', 'Bosna i Hercegovina', '<p>sadasdasd</p>\r\n', 'Dobrodosli u nas resotran, nadamo se da ce vam se svidjeti !', 'By Dino Hadziahmetovic'),
638(4, 'test', 'Dobrodosli u restoran-pizzeriu "Blitz", uzivajte.', 'blitz,resotran pizzeria blitz, pizzeria blitz, restoran blitz, restoran-pizzeria blitz, restaurant blitz', 'Restoran-Pizzeria "BLITZ"', 'info@blitz.ba', 'Restoran Pizzeria "BLITZ"', 'Odvode lamele 2. bb', 'Gornji Vakuf', '70240', '030 / 260 - 531', '030 / 260 - 530', 'Default', '2015-05-03 00:47:52', '2015-05-03 00:47:52', '', 'Bosna i Hercegovina', '<p>sadasdasd</p>\r\n', 'Dobrodosli u nas resotran, nadamo se da ce vam se svidjeti !', 'By Dino Hadziahmetovic');
639
640-- --------------------------------------------------------
641
642--
643-- Table structure for table `teams`
644--
645
646CREATE TABLE IF NOT EXISTS `teams` (
647`id` int(11) NOT NULL,
648 `name` text COLLATE utf8_bin NOT NULL,
649 `content` text COLLATE utf8_bin NOT NULL,
650 `created` datetime NOT NULL,
651 `modified` datetime NOT NULL
652) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
653
654--
655-- Dumping data for table `teams`
656--
657
658INSERT INTO `teams` (`id`, `name`, `content`, `created`, `modified`) VALUES
659(6, 'Džemal Gekić', 'Trener Džemo je je vlasnik i glavni trener BTC Fitness Boot Campa sa viÅ¡egodiÅ¡njim iskustvom.\r\n\r\nOvim poslom se želio baviti od svog djetinstva. Nakon zavrÅ¡enog fakulteta za Sport i tjelesni odgoj u Sarajevu, nekoliko godina provodi usavrÅ¡avajući se za razne vrste treninga. Osnivanjem BTC-a poÄinje ostvarivanje njegovog sna i priÄe o fitnessu kao zanimanju koje omogućava da viÅ¡estruko pomaže drugim ljudima u ostvarivanju njihovih ciljeva u segmentu zdravlja, tijela, samopouzdanja i mnogo drugih aspekata života.\r\n\r\nKreator je prvog programa na naÅ¡im prostorima pod nazivom â€Izazov 10. 000 kgâ€, autor je knjige â€VodiÄ za efikasno i trajno mrÅ¡anje†i iza sebe takoÄ‘er ima već 2 uspjeÅ¡no zavrÅ¡ene obuke za trenere pod nazivom Body Transformation Coach.\r\n\r\nPored posla trenera u klubu BTC Boot Camp, radi kao personalni trener, trener je muÅ¡ke grupe Spartanski Boot Camp, voditelj je online programa mrÅ¡anja, savjetnik za ishranu, kreator programa â€Izazov 8 kg za 6 sedmicaâ€.\r\n\r\nNjegovi ciljevi se uvijek svode na pomjeranje barijera i sopstvenih granica, kako u vlastitom životu tako i u životu njegovih klijenata koje konstantno podstiÄe da izdrže viÅ¡e i ostvare bolje rezultate.', '2015-05-05 23:37:45', '2015-05-07 16:10:42'),
660(7, 'ddfsfsf', 'fsdfs', '2015-05-10 15:45:29', '2015-05-10 15:45:29');
661
662-- --------------------------------------------------------
663
664--
665-- Table structure for table `team_images`
666--
667
668CREATE TABLE IF NOT EXISTS `team_images` (
669`id` int(11) unsigned NOT NULL,
670 `team_id` int(11) NOT NULL,
671 `field` varchar(20) NOT NULL DEFAULT '',
672 `type` varchar(20) NOT NULL DEFAULT '',
673 `set` int(5) NOT NULL,
674 `url` varchar(255) NOT NULL DEFAULT '',
675 `title` varchar(255) NOT NULL DEFAULT '',
676 `width` int(5) NOT NULL,
677 `height` int(5) NOT NULL,
678 `order` int(5) NOT NULL
679) ENGINE=InnoDB DEFAULT CHARSET=utf8;
680
681-- --------------------------------------------------------
682
683--
684-- Table structure for table `users`
685--
686
687CREATE TABLE IF NOT EXISTS `users` (
688`id` int(11) NOT NULL,
689 `membership_id` int(11) NOT NULL,
690 `group_id` int(11) NOT NULL,
691 `name` varchar(64) NOT NULL,
692 `lastname` varchar(255) DEFAULT NULL,
693 `address` varchar(254) DEFAULT NULL,
694 `kg` float DEFAULT NULL,
695 `visina` float DEFAULT NULL,
696 `cilj` varchar(254) DEFAULT NULL,
697 `city_id` int(11) NOT NULL,
698 `telephone` varchar(100) NOT NULL,
699 `password` varchar(64) NOT NULL,
700 `email` varchar(64) NOT NULL,
701 `status` tinyint(1) NOT NULL DEFAULT '0',
702 `checked` tinyint(1) NOT NULL,
703 `verify` varchar(255) DEFAULT NULL,
704 `last_login` datetime DEFAULT NULL,
705 `created` datetime NOT NULL,
706 `updated` datetime NOT NULL
707) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
708
709--
710-- Dumping data for table `users`
711--
712
713INSERT INTO `users` (`id`, `membership_id`, `group_id`, `name`, `lastname`, `address`, `kg`, `visina`, `cilj`, `city_id`, `telephone`, `password`, `email`, `status`, `checked`, `verify`, `last_login`, `created`, `updated`) VALUES
714(1, 0, 2, 'EL-Camino', 'Najbolja hrana u te..', 'ul. Dzemala Bijediać', 5, 5, '', 1, '993939393', '$2a$10$x1lplQzEzLcj5LrWm6KE7epXEM0EBcfjZXY6vNlGo42JIJNr6bJrq', 'user@user.com', 0, 0, '5484cb40-2230-4e97-b0f0-12d07f00001a', '2015-05-07 21:10:02', '2014-12-07 22:48:48', '2015-05-10 15:44:47'),
715(2, 0, 1, 'Elektroprivreda', NULL, 'dsfdsf', NULL, NULL, '', 3, 'dsfds', 'ffsf', 'fdsf', 0, 0, NULL, '2014-12-16 00:00:00', '2014-12-17 00:00:00', '2014-12-18 00:00:00'),
716(3, 0, 1, 'fsfdsdfsf', NULL, 'sdfsdf', NULL, NULL, '', 3, '333', '3ff', 'fff', 0, 0, '1', NULL, '2014-12-25 00:00:00', '2014-12-10 00:00:00'),
717(4, 0, 11, 'dd', NULL, 'fdsfdsf', NULL, NULL, '', 5, '22', '222', '222', 0, 0, '22', NULL, '2014-12-24 00:00:00', '2014-12-30 00:00:00'),
718(5, 0, 0, 'sodykisi', NULL, 'Velit reprehenderit molestiae exercitationem expedita aut quo', NULL, NULL, '', 4, '+659-42-2147075', '$2a$10$xxnM7oFVpdcmst3nEUpnmucghSIBal/h7yXinWzsOgexGEkhqurBG', 'jilyjaf@hotmail.com', 1, 0, '548b7bfc-8a00-4b6b-acd5-0dc87f00001a', NULL, '2014-12-13 00:36:28', '2014-12-13 00:36:28'),
719(6, 0, 0, 'syjuc', NULL, 'Excepteur quis id voluptatem consequatur Quis perferendis itaque excepturi exercitation', NULL, NULL, '', 3, '+847-48-4536633', '$2a$10$Q6aTXVarJPByoD5Ka7jPN.vWu/abl9nBtC7rolJVuVkZ12hgMbtVm', 'wenazenal@yahoo.com', 0, 0, '548b7ffe-70c8-49ad-9ca0-0dc87f00001a', NULL, '2014-12-13 00:53:34', '2014-12-13 00:53:34'),
720(7, 0, 0, 'Dino', NULL, 'dzemala bijedica', NULL, NULL, '', 5, '29299292', '$2a$10$rHs21/AsS/w4WrhvsEh6S.93UWhuFn0Fia64.OdMbt6PsCFlAidPe', 'dino320e@gmail.com', 1, 0, '548b82f6-8878-44e5-9794-0dc87f00001a', NULL, '2014-12-13 01:06:15', '2014-12-13 01:06:15'),
721(8, 0, 0, 'cozinewu', NULL, 'Temporibus possimus commodi sequi consequatur', NULL, NULL, '', 1, '+994-64-9009373', '$2a$10$KAAQ6rBW/J1wyMwKgdnUsuof3z5lryxhHELjX8Ir2oqkz.QjL7C.2', 'din3o320e@gmail.com', 1, 0, '548b8be2-282c-4db3-93cd-0dc87f00001a', NULL, '2014-12-13 01:44:18', '2014-12-13 01:44:18'),
722(9, 0, 0, 'jixicyc', NULL, 'Consectetur porro itaque fugit quibusdam modi praesentium architecto laborum saepe pariatur Aut dolores reiciendis', NULL, NULL, '', 1, '+433-88-2701164', '$2a$10$bBtvQSxvVH5zVL4NWT076eYccCk2yBBMuWeRRt1PT.Qsel3dIWQUq', 'pelywipemo@gmail.com', 1, 0, '548b8cb1-7834-4848-a268-0dc87f00001a', NULL, '2014-12-13 01:47:45', '2014-12-13 01:47:45'),
723(10, 0, 0, 'loxosu', NULL, 'Et blanditiis explicabo Eaque rerum cumque totam ab architecto quidem', NULL, NULL, '', 1, '+583-49-6251868', '$2a$10$vx2l25iReRbNA9RSr6SN9OVz8UQBm8J5NBmyONQtSX96p9oein53a', 'mujudu@yahoo.com', 0, 0, '548b8db1-d344-47c1-8817-0dc87f00001a', NULL, '2014-12-13 01:52:01', '2014-12-13 01:52:01'),
724(11, 0, 0, 'tajokeky', NULL, 'Vitae ullamco ut expedita irure repudiandae cupiditate aut consequatur veritatis non nisi natus molestiae officia eu ut architecto voluptate', NULL, NULL, '', 4, '+551-20-3109467', '$2a$10$yluSoP/PR.f48dphEl6NG.2j7DBZmq45XTnZWKW.69KQgT8BXf7y6', 'newo@hotmail.com', 1, 0, '548b8e9c-ff08-4c14-a32f-0dc87f00001a', NULL, '2014-12-13 01:55:56', '2014-12-13 01:55:56'),
725(12, 0, 0, 'rerakewu', NULL, 'Temporibus quo veritatis unde sit ullamco et laboris odit', NULL, NULL, '', 2, '+737-45-2918673', '$2a$10$0qHm84C.zt8OWYWrOZUf5.zuPVUXLKIMIp3NP4nVeowlFXWX4MH82', 'kufy@gmail.com', 1, 0, '548b8f27-0c9c-4a48-9cbb-0dc87f00001a', NULL, '2014-12-13 01:58:15', '2014-12-13 01:58:15'),
726(13, 0, 1, 'AStra doo', NULL, 'gorucica', NULL, NULL, '', 3, '2993399', '$2a$10$VpwthrfUABk9VGM/P3Hs5udi5eb.22fOfl8IFi5jXTnm4cpwtjIWW', 'omega@live.com', 1, 0, '548b905d-1448-4a0d-a0b6-0dc87f00001a', '2014-12-13 02:04:07', '2014-12-13 02:03:25', '2014-12-13 02:03:25'),
727(14, 0, 0, 'cotawuca', NULL, 'Elit labore ipsum voluptatem aut at et optio atque', NULL, NULL, '', 2, '+115-22-7496972', '$2a$10$5OguMzth2tfBkge4Q3ctVuqoaX63tGm/NmXVZ3Asz1ra1A7L9dprm', 'noxer@hotmail.com', 1, 0, '548c7f2c-8fdc-494e-97b9-0dc87f00001a', NULL, '2014-12-13 19:02:20', '2014-12-13 19:02:20'),
728(15, 0, 0, 'jigeb', NULL, 'Sed neque maiores laborum Reiciendis ut eaque', NULL, NULL, '', 2, '+264-60-6937720', '$2a$10$xTwPHnH4wsdAgCfQRq12f.owyanzXZQXb.HYEeB/cwIkAFfJGP9dy', 'sohev@hotmail.com', 1, 0, '548c80ca-ce84-410e-807a-0dc87f00001a', NULL, '2014-12-13 19:09:14', '2014-12-13 19:09:14'),
729(16, 0, 0, 'wufazav', NULL, 'Inventore eiusmod sunt nisi proident doloribus quia est atque sit placeat quisquam qui', -19, 3, '', 2, '+177-63-7637100', '$2a$10$.jt2c.2SIxKwJILVOVdR8uKJ7jtlwrAVkUIRK4uHb2jn21e9vOo.W', 'petal@hotmail.com', 1, 0, '548ccd3a-41c8-4c48-817a-0dc87f00001a', NULL, '2014-12-14 00:35:22', '2015-05-10 10:32:12'),
730(17, 0, 0, 'jysozaqak', NULL, 'In ipsa sint earum quam veniam maiores in non irure ut pariatur Consequatur Consequatur ut odit consequatur rerum rerum', NULL, NULL, '', 5, '+353-11-2609530', '$2a$10$DXCVA7e.bOUT0EEILSLmnuBabHJQneGeY2JpghNZ20lKtNChFGatq', 'zyqi@hotmail.com', 1, 0, '548cd499-1100-44a3-96d9-0dc87f00001a', NULL, '2014-12-14 01:06:50', '2014-12-14 01:06:50'),
731(18, 0, 0, 'japic', NULL, 'Quis nulla dolores maxime quasi deleniti inventore excepturi qui', NULL, NULL, '', 1, '+477-28-3107576', '$2a$10$zquDNhWI57l9de/6yh6Tz.EZ1BTDli12och1xdCa.4fIiiODAdnZa', 'kuqa@yahoo.com', 1, 0, '548ce5f3-b628-4ca3-8016-0dc87f00001a', NULL, '2014-12-14 02:20:51', '2014-12-14 02:20:51'),
732(19, 0, 0, 'rosuciqo', NULL, 'Sit perspiciatis provident totam qui iste at sint elit adipisicing anim qui odio laborum', NULL, NULL, '', 5, '+135-62-6519337', '$2a$10$OGjnOhdzmwPsh6tng3HmneBjpirUVNB/mssnSgP0wox.fH1DAAfOW', 'rusocyhuxe@gmail.com', 1, 0, '548ce643-cb38-4c65-be6c-0dc87f00001a', NULL, '2014-12-14 02:22:11', '2014-12-15 09:19:40'),
733(20, 0, 0, 'mofosuj', NULL, 'Qui sit dolorem qui et aliqua Voluptate', NULL, NULL, '', 6, '+229-60-3973249', '$2a$10$Pdb1sEvanzQHpjPZf28JDOXM.K4FhFlpv.2EjZ18bysBj7FGTA.2q', 'vonaze@gmail.com', 1, 0, '548e1746-3ed8-4e5d-bd21-0dc87f00001a', '2014-12-15 09:23:45', '2014-12-15 00:03:34', '2014-12-15 09:23:40'),
734(21, 0, 0, 'mykupitok', NULL, 'Et ex irure sunt et est laudantium culpa architecto quae mollitia minima ex', NULL, NULL, '', 3, '+238-31-1414151', '$2a$10$/dzXJaJe8BjuMD4jQ6UjqOn0fwfgf35fHV3G.tJUgGQDKq8eUu14K', 'godyrelodu@hotmail.com', 1, 0, '548e9fe4-7550-475d-9870-0b507f00001a', NULL, '2014-12-15 09:46:28', '2014-12-15 09:46:57'),
735(22, 0, 0, 'sudylyD', NULL, 'Consequatur blanditiis et possimus nisi fugiat pariatur Maxime duis error sed molestiae sunt est commodo culpa inventore', NULL, NULL, '', 1, '+242-18-1126376', '$2a$10$L1.3BJbaqwppdITc8s1WnuQWcqDvlW0lOTbUriIekLzBMkD0ZJBHW', 'cexoqomix@yahoo.com', 1, 0, '5490466a-d2a4-4b9e-857c-1aec7f00001a', NULL, '2014-12-16 15:49:14', '2015-01-13 01:31:37'),
736(23, 0, 2, 'sanihy', 'Sanders', '', 0, 0, '', 0, '', '', 'lywelyjob@yahoo.com', 1, 0, '554e5507-d318-4be3-82b3-1ca87f00001d', NULL, '2015-05-09 20:42:15', '2015-05-09 20:42:15'),
737(24, 0, 2, 'cylybapaku', 'Montgomery', '', 0, 0, '', 0, '', '', 'pifyg@hotmail.com', 1, 0, '554e5617-da10-4155-8ecc-1ca87f00001d', NULL, '2015-05-09 20:46:47', '2015-05-09 20:46:47'),
738(25, 0, 2, 'wumucom', 'Strickland', '', 0, 0, '', 0, '', '', 'tykamij@yahoo.com', 1, 0, '554e5635-4a28-4f7c-bacf-1ca87f00001d', NULL, '2015-05-09 20:47:17', '2015-05-09 20:47:17'),
739(26, 0, 2, 'test ime', 'test ime', '', 9, 399, '', 0, '', '', 'ime@test.com', 1, 0, '554f1487-2e68-4f02-b230-1ca87f00001d', '2015-05-10 10:20:09', '2015-05-10 10:19:19', '2015-05-10 10:19:19'),
740(27, 0, 2, 'jytyfiri', 'Stanley', 'test', 0, 0, '2', 0, '', '', 'vybo@yahoo.com', 1, 0, '554f1615-a15c-4224-a07b-1ca87f00001d', NULL, '2015-05-10 10:25:57', '2015-05-10 10:25:57'),
741(28, 0, 2, 'Dino', 'hadziahmeotivc', 'adjadjadjdj', 39, 2929, '1', 0, '933939', '', 'dino@test.com', 1, 0, '554f5e47-dc08-449a-a0f9-1ca87f00001d', '2015-05-10 16:35:10', '2015-05-10 15:33:59', '2015-05-10 15:43:00'),
742(30, 0, 2, 'qikoz', 'Booker', 'Ipsa id debitis dolor dolores qui quis nostrum sunt totam repudiandae', 0, 0, 'test23', 0, '', '', 'nycixot@gmail.com', 1, 0, '554f8ce0-a444-401f-852c-1ca87f00001d', NULL, '2015-05-10 18:52:48', '2015-05-10 18:52:48'),
743(31, 0, 2, 'gudyfy', 'Becker', 'Qui nostrud incididunt ea dolores nisi porro non nulla quia ut', 0, 0, 'test23', 0, '', '', 'vyniwawo@gmail.com', 1, 0, '554f9b1a-7d9c-49ce-bbbb-22047f00001d', NULL, '2015-05-10 19:53:30', '2015-05-10 19:53:30'),
744(32, 0, 2, 'rigikity', 'Briggs', 'Veniam aliquam est error inventore beatae necessitatibus cum recusandae Non qui', 0, 0, 'test23', 0, '', '', 'gokyjyxiv@gmail.com', 1, 0, '554f9b85-bdec-4845-98b5-22047f00001d', NULL, '2015-05-10 19:55:17', '2015-05-10 19:55:17'),
745(33, 0, 2, 'jemilu', 'Cardenas', 'Dolore saepe cupidatat Nam dolor esse laboriosam sed ipsam elit quia eaque est ab ad porro quis deserunt minus dolores', 0, 0, 'test23', 0, '', '', 'delopasep@hotmail.com', 1, 0, '554f9bb1-ecec-41e0-8c8a-22047f00001d', NULL, '2015-05-10 19:56:01', '2015-05-10 19:56:01'),
746(34, 0, 2, 'sojazosuby', 'Baird', 'Dignissimos necessitatibus sit rerum incidunt iure ea consequat Suscipit cupidatat quae adipisicing est', 0, 0, 'test23', 0, '', '', 'dubir@yahoo.com', 1, 0, '5550e7ad-b208-44a3-bbb2-179c7f00001d', NULL, '2015-05-11 19:32:29', '2015-05-11 19:32:29'),
747(35, 0, 2, 'wunecav', 'Hyde', 'Voluptate fugiat odio aute sed exercitationem corporis nihil vero aliquip perspiciatis dolor et blanditiis omnis exercitation', 4, 0, 'test23', 0, '', '', 'y4jwqtb@dispostable.com', 1, 0, '5550e90c-bea4-4559-bcbb-179c7f00001d', NULL, '2015-05-11 19:38:20', '2015-05-11 19:38:20'),
748(36, 0, 2, 'test', 'test', 'aajddj', 2929, 3939, 'test23', 0, '', '', 'ukwd7z1@dispostable.com', 1, 0, '5550e9f9-487c-4f74-85de-179c7f00001d', NULL, '2015-05-11 19:42:17', '2015-05-11 19:42:17'),
749(37, 0, 2, 'test', 'test', 'fdff', 39, 939, 'test23', 0, '', '', 'n2z3rya@dispostable.com', 1, 0, '5550ea38-3eb8-41fd-8254-179c7f00001d', NULL, '2015-05-11 19:43:20', '2015-05-11 19:43:20'),
750(38, 0, 2, 'test2', 'test3', 'dsf', 33, 33, 'test23', 0, '', '', 'stdk6ex@dispostable.com', 1, 0, '5550eb4f-b8d8-467b-9dd7-179c7f00001d', NULL, '2015-05-11 19:47:59', '2015-05-11 19:47:59'),
751(39, 0, 2, 'dani', 'didi', 'idsi', 93, 39, 'test23', 0, '', '', '3lxf0qi@dispostable.com', 0, 0, '5550f997-5840-48cc-87ac-179c7f00001d', NULL, '2015-05-11 20:48:56', '2015-05-11 20:48:56'),
752(40, 0, 2, 'dino', 'dino', 'ddd', 33, 33, 'test23', 0, '', '', 's2i7qhp@dispostable.com', 0, 0, '5550fdc8-dabc-4fed-bdb3-179c7f00001d', NULL, '2015-05-11 21:06:48', '2015-05-11 21:06:48'),
753(41, 0, 2, 'tana', 'djdj', 'djdj', 39, 93, 'test23', 0, '', '', 'qu2wd8z@dispostable.com', 0, 0, '5550feea-bb88-4f27-80c3-179c7f00001d', NULL, '2015-05-11 21:11:38', '2015-05-11 21:11:38'),
754(42, 0, 2, 'dino', 'dino', 'din', 39, 39, 'test23', 0, '', '', 'zu2ob6s@dispostable.com', 1, 1, '5551036e-bf5c-4a20-af88-179c7f00001d', '2015-05-11 21:35:24', '2015-05-11 21:30:54', '2015-05-11 21:32:51'),
755(43, 0, 2, 'asdas', 'sadas', 'sadsas', 0, 0, 'test23', 0, '', '', 'soaskodkas@gam.ba', 0, 0, '55512dac-c87c-4034-946d-0f947f000007', NULL, '2015-05-12 00:31:08', '2015-05-12 00:31:08');
756
757-- --------------------------------------------------------
758
759--
760-- Table structure for table `weeks`
761--
762
763CREATE TABLE IF NOT EXISTS `weeks` (
764`id` int(11) NOT NULL,
765 `title` varchar(254) NOT NULL,
766 `program_id` int(11) NOT NULL,
767 `monday` text CHARACTER SET utf8 NOT NULL,
768 `tuesday` text CHARACTER SET utf8 NOT NULL,
769 `wednesday` text CHARACTER SET utf8 NOT NULL,
770 `thursday` text CHARACTER SET utf8 NOT NULL,
771 `friday` text CHARACTER SET utf8 NOT NULL,
772 `saturday` text CHARACTER SET utf8 NOT NULL,
773 `sunday` text CHARACTER SET utf8 NOT NULL
774) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
775
776--
777-- Dumping data for table `weeks`
778--
779
780INSERT INTO `weeks` (`id`, `title`, `program_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`) VALUES
781(1, '', 0, 'Illum, aliquid reprehenderit dolores sed rerum non esse aspernatur quisquam officiis non totam molestiae alias et consequat. Quo irure nostrud incidunt, ipsum nesciunt, veritatis perspiciatis, sapiente corrupti.', 'Laborum. Assumenda omnis mollit eu ea soluta.', 'Dolorum ut quaerat quisquam dignissimos necessitatibus alias ullamco laboriosam, aut consequuntur non nisi quaerat sed consequatur porro quia rerum perspiciatis, repellendus. Natus.', 'Eum dolorem autem culpa est quod reprehenderit magna quaerat reiciendis qui voluptatum.', 'Sunt commodo natus autem dolor id ipsa, delectus, aliquam incididunt irure occaecat quibusdam aliquid quisquam obcaecati a dolores eum mollitia nulla consequat.', 'Unde in mollitia voluptatibus error placeat, aut amet, consequatur, beatae odit.', 'Nulla est quia.'),
782(2, '', 4, '<p>fdfdf</p>\r\n', '<p>fdfd</p>\r\n', '<p>fdfd</p>\r\n', '<p>fdfdf</p>\r\n', '<p>ffdfd</p>\r\n', '<p>fdfdf</p>\r\n', '<p>fdfdfdfd</p>\r\n'),
783(5, 'fdsfs', 5, '<p>fdsffsf</p>\r\n', '<p>fdsf</p>\r\n', '<p>fdsf</p>\r\n', '<p>fdsfsd</p>\r\n', '<p>fdsf</p>\r\n', '<p>fsfs</p>\r\n', '<p>ffsdfsf</p>\r\n'),
784(6, 'vcv', 7, '<p>vcxvxc</p>\r\n', '<p>vxvxcx</p>\r\n', '<p>vxcvcxv</p>\r\n', '<p>cxvxcvcx</p>\r\n', '<p>vxcvxcv</p>\r\n', '<p>xcvxcv</p>\r\n', ''),
785(7, '', 7, '<p>fdsfsdf</p>\r\n', '<p>sfsd</p>\r\n', '', '', '', '', ''),
786(8, 'Voluptates eos rem tempora ad aliquip non in enim enim eaque', 9, '<p>ccxcxycxcxycyxc</p>\r\n', '<p>cyxcxycyxcxyc</p>\r\n', '<p>cyxcxy</p>\r\n', '<p>cycyx</p>\r\n', '<p>cyxcyxcyxcxyc</p>\r\n', '<p>xcycyxc</p>\r\n', '<p>cyxcy</p>\r\n'),
787(9, 'dasda', 12, '<p>dsadas</p>\r\n', '<p>dsadas</p>\r\n', '<p>dasdas</p>\r\n', '<p>dasdas</p>\r\n', '<p>dasdas</p>\r\n', '<p>dsasda</p>\r\n', '<p>dasdasd</p>\r\n'),
788(10, 'Teretana', 14, '<p><strong><span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">Noge: ÄŒuÄaj</span></strong><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Presa </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Nožna ekstenzija </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Iskorak </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Dizanje na listove sa sipkom na ledjima </span></p>\r\n\r\n<table border="1" cellpadding="1" cellspacing="1" style="width: 100%;">\r\n <tbody>\r\n <tr>\r\n <td> </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td> </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n\r\n<p> </p>\r\n', '<p><span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">Ledja: -Vratilo (naprijed i iza) </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Mrtvo dizanje </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Veslanje u pretklonu </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Lat masina sa kopitom </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Veslanje sa kablovima </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Veslanje jednorucno sa bucicom </span></p>\r\n', '<p><span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;"><strong>Ramena</strong>: -Rameni potisak sa sipkom iza glave </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Rameni potisak sa sipkom ispred glave </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Rameni potisak bucicama </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Sleganje ramenima sa bucicama </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Letenje bucicama naprijed</span></p>\r\n', '<h1>PAUZA</h1>\r\n', '<p><span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;"><strong>Triceps</strong>: -Uski bench </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Dips </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Triceps ekstenzija sa sipkom sa cela </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;"><strong>Biceps</strong>: -Stojeci pregib sipkom </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-pregib bucicama </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Hammer pregib bucicama </span></p>\r\n', '<p><span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;"><strong>Triceps</strong>: -Uski bench </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Dips </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Triceps ekstenzija sa sipkom sa cela </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;"><strong>Biceps</strong>: -Stojeci pregib sipkom </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-pregib bucicama </span><br style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;" />\r\n<span style="color: rgb(85, 85, 85); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: normal;">-Hammer pregib bucicama </span></p>\r\n', '<h1>PAUZA</h1>\r\n'),
789(11, '1 sedmica', 15, '<p>8:00 - tot titi</p>\r\n\r\n<p>fdfdfjdj</p>\r\n\r\n<p>fjdjfjdfjdjfjdjfjjfdjfjdfj</p>\r\n', '<p>dsdsds</p>\r\n', '<p>dsdsd</p>\r\n', '<p>dsdsdsdsdsdds</p>\r\n', '<p>eweweeww</p>\r\n', '<p>ewewewewew</p>\r\n', '<p>ewewewewwewe</p>\r\n'),
790(12, 'Magni sunt voluptatibus qui maxime esse sint amet dolore', 15, '<p>fsfs</p>\r\n', '<p>dsf</p>\r\n', '<p>fdfdf</p>\r\n', '<p>fdfdf</p>\r\n', '<p>fdfdfdfdffdfdf</p>\r\n', '<p>fdfdfd</p>\r\n', '<p>fdfd</p>\r\n');
791
792--
793-- Indexes for dumped tables
794--
795
796--
797-- Indexes for table `administrators`
798--
799ALTER TABLE `administrators`
800 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`);
801
802--
803-- Indexes for table `cake_sessions`
804--
805ALTER TABLE `cake_sessions`
806 ADD PRIMARY KEY (`id`), ADD KEY `expires` (`expires`) USING BTREE;
807
808--
809-- Indexes for table `clients`
810--
811ALTER TABLE `clients`
812 ADD PRIMARY KEY (`id`), ADD KEY `status` (`status`), ADD KEY `password` (`password`);
813
814--
815-- Indexes for table `faqs`
816--
817ALTER TABLE `faqs`
818 ADD PRIMARY KEY (`id`);
819
820--
821-- Indexes for table `groups`
822--
823ALTER TABLE `groups`
824 ADD PRIMARY KEY (`id`);
825
826--
827-- Indexes for table `images`
828--
829ALTER TABLE `images`
830 ADD PRIMARY KEY (`id`), ADD KEY `article_id` (`product_id`), ADD KEY `page_id` (`user_id`), ADD KEY `field` (`field`), ADD KEY `type` (`type`), ADD KEY `set` (`set`), ADD KEY `order` (`order`);
831
832--
833-- Indexes for table `memberships`
834--
835ALTER TABLE `memberships`
836 ADD PRIMARY KEY (`id`), ADD KEY `price_id` (`pricing_id`), ADD KEY `user_id` (`user_id`);
837
838--
839-- Indexes for table `menus`
840--
841ALTER TABLE `menus`
842 ADD PRIMARY KEY (`id`), ADD KEY `parent_id` (`parent_id`), ADD KEY `status` (`status`), ADD KEY `show_on` (`show_on`), ADD KEY `lft` (`lft`), ADD KEY `rght` (`rght`);
843
844--
845-- Indexes for table `metrics`
846--
847ALTER TABLE `metrics`
848 ADD PRIMARY KEY (`id`);
849
850--
851-- Indexes for table `news`
852--
853ALTER TABLE `news`
854 ADD PRIMARY KEY (`id`), ADD KEY `slug` (`slug`), ADD KEY `status` (`status`), ADD KEY `created` (`created`);
855
856--
857-- Indexes for table `newsletters`
858--
859ALTER TABLE `newsletters`
860 ADD PRIMARY KEY (`id`);
861
862--
863-- Indexes for table `news_categories`
864--
865ALTER TABLE `news_categories`
866 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `ids` (`parent_id`,`lft`,`rght`);
867
868--
869-- Indexes for table `news_images`
870--
871ALTER TABLE `news_images`
872 ADD PRIMARY KEY (`id`), ADD KEY `news_id` (`news_id`), ADD KEY `field` (`field`), ADD KEY `type` (`type`), ADD KEY `set` (`set`);
873
874--
875-- Indexes for table `pages`
876--
877ALTER TABLE `pages`
878 ADD PRIMARY KEY (`id`), ADD KEY `slug` (`slug`);
879
880--
881-- Indexes for table `pricings`
882--
883ALTER TABLE `pricings`
884 ADD PRIMARY KEY (`id`);
885
886--
887-- Indexes for table `programs`
888--
889ALTER TABLE `programs`
890 ADD PRIMARY KEY (`id`);
891
892--
893-- Indexes for table `programtypes`
894--
895ALTER TABLE `programtypes`
896 ADD PRIMARY KEY (`id`);
897
898--
899-- Indexes for table `program_images`
900--
901ALTER TABLE `program_images`
902 ADD PRIMARY KEY (`id`), ADD KEY `product_id` (`program_id`), ADD KEY `field` (`field`), ADD KEY `type` (`type`), ADD KEY `set` (`set`);
903
904--
905-- Indexes for table `site_configs`
906--
907ALTER TABLE `site_configs`
908 ADD PRIMARY KEY (`id`);
909
910--
911-- Indexes for table `teams`
912--
913ALTER TABLE `teams`
914 ADD PRIMARY KEY (`id`);
915
916--
917-- Indexes for table `team_images`
918--
919ALTER TABLE `team_images`
920 ADD PRIMARY KEY (`id`), ADD KEY `product_id` (`team_id`), ADD KEY `field` (`field`), ADD KEY `type` (`type`), ADD KEY `set` (`set`);
921
922--
923-- Indexes for table `users`
924--
925ALTER TABLE `users`
926 ADD PRIMARY KEY (`id`), ADD KEY `group_id` (`group_id`), ADD KEY `status` (`status`), ADD KEY `password` (`password`), ADD KEY `group_id_2` (`group_id`);
927
928--
929-- Indexes for table `weeks`
930--
931ALTER TABLE `weeks`
932 ADD PRIMARY KEY (`id`);
933
934--
935-- AUTO_INCREMENT for dumped tables
936--
937
938--
939-- AUTO_INCREMENT for table `administrators`
940--
941ALTER TABLE `administrators`
942MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
943--
944-- AUTO_INCREMENT for table `clients`
945--
946ALTER TABLE `clients`
947MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
948--
949-- AUTO_INCREMENT for table `faqs`
950--
951ALTER TABLE `faqs`
952MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
953--
954-- AUTO_INCREMENT for table `groups`
955--
956ALTER TABLE `groups`
957MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
958--
959-- AUTO_INCREMENT for table `images`
960--
961ALTER TABLE `images`
962MODIFY `id` int(8) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
963--
964-- AUTO_INCREMENT for table `memberships`
965--
966ALTER TABLE `memberships`
967MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
968--
969-- AUTO_INCREMENT for table `menus`
970--
971ALTER TABLE `menus`
972MODIFY `id` int(9) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
973--
974-- AUTO_INCREMENT for table `metrics`
975--
976ALTER TABLE `metrics`
977MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
978--
979-- AUTO_INCREMENT for table `news`
980--
981ALTER TABLE `news`
982MODIFY `id` int(9) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;
983--
984-- AUTO_INCREMENT for table `newsletters`
985--
986ALTER TABLE `newsletters`
987MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
988--
989-- AUTO_INCREMENT for table `news_categories`
990--
991ALTER TABLE `news_categories`
992MODIFY `id` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
993--
994-- AUTO_INCREMENT for table `news_images`
995--
996ALTER TABLE `news_images`
997MODIFY `id` int(8) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=70;
998--
999-- AUTO_INCREMENT for table `pages`
1000--
1001ALTER TABLE `pages`
1002MODIFY `id` int(9) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
1003--
1004-- AUTO_INCREMENT for table `pricings`
1005--
1006ALTER TABLE `pricings`
1007MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
1008--
1009-- AUTO_INCREMENT for table `programs`
1010--
1011ALTER TABLE `programs`
1012MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
1013--
1014-- AUTO_INCREMENT for table `programtypes`
1015--
1016ALTER TABLE `programtypes`
1017MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
1018--
1019-- AUTO_INCREMENT for table `program_images`
1020--
1021ALTER TABLE `program_images`
1022MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=24;
1023--
1024-- AUTO_INCREMENT for table `site_configs`
1025--
1026ALTER TABLE `site_configs`
1027MODIFY `id` int(1) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
1028--
1029-- AUTO_INCREMENT for table `teams`
1030--
1031ALTER TABLE `teams`
1032MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
1033--
1034-- AUTO_INCREMENT for table `team_images`
1035--
1036ALTER TABLE `team_images`
1037MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
1038--
1039-- AUTO_INCREMENT for table `users`
1040--
1041ALTER TABLE `users`
1042MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=44;
1043--
1044-- AUTO_INCREMENT for table `weeks`
1045--
1046ALTER TABLE `weeks`
1047MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
1048--
1049-- Constraints for dumped tables
1050--
1051
1052--
1053-- Constraints for table `memberships`
1054--
1055ALTER TABLE `memberships`
1056ADD CONSTRAINT `memberships_fk1` FOREIGN KEY (`pricing_id`) REFERENCES `pricings` (`id`),
1057ADD CONSTRAINT `memberships_fk2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
1058
1059/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1060/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1061/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;