-- --------------------------------------------------------------------------------
-- 
-- @version: als.sql Aug 18, 2015 13:10 gewa
-- @package Advanced Login System
-- @author wojoscripts.com.
-- @copyright 2011
-- 
-- --------------------------------------------------------------------------------
-- Host: localhost
-- Database: als
-- Time: Aug 18, 2015-13:10
-- MySQL version: 5.6.21
-- PHP version: 5.5.19
-- --------------------------------------------------------------------------------

#
# Database: `als`
#


-- --------------------------------------------------
# -- Table structure for table `category`
-- --------------------------------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `category_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `category`
-- --------------------------------------------------

INSERT INTO `category` (`category_id`, `name`, `last_update`) VALUES ('1', 'Monitor', '2015-06-23 12:42:52');
INSERT INTO `category` (`category_id`, `name`, `last_update`) VALUES ('2', 'Elektronski ključ', '2015-06-23 12:42:52');
INSERT INTO `category` (`category_id`, `name`, `last_update`) VALUES ('3', 'Ostalo', '2015-06-23 12:43:33');
INSERT INTO `category` (`category_id`, `name`, `last_update`) VALUES ('4', 'Monitor 15', '2015-06-23 13:35:55');


-- --------------------------------------------------
# -- Table structure for table `city`
-- --------------------------------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
  `city_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `city` varchar(50) NOT NULL COMMENT 'Region ili grad',
  `country_id` smallint(5) unsigned NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`city_id`),
  KEY `idx_fk_country_id` (`country_id`),
  CONSTRAINT `fk_city_country` FOREIGN KEY (`country_id`) REFERENCES `country` (`country_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `city`
-- --------------------------------------------------

INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('1', 'Beograd', '1', '2015-06-23 15:35:28');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('2', 'Novi Sad', '1', '2015-06-23 15:44:12');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('3', 'Stara Pazova', '1', '2015-06-23 15:45:24');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('4', 'Beograd', '2', '2015-06-25 17:44:23');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('7', 'Obrenovac', '1', '2015-07-20 15:43:09');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('8', 'Bački Jarak', '1', '2015-07-20 15:43:09');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('9', 'Bački Petrovac', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('10', 'Batajnica', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('11', 'Crvenka', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('12', 'Dobanovci', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('13', 'Inđija', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('14', 'Kać', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('15', 'Kovilj', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('16', 'Kula', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('17', 'N. Banovci', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('18', 'Nova Pazova', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('19', 'Novi Kneževac', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('20', 'Ruma', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('21', 'Senta', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('22', 'Sombor', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('23', 'Sr. Kamenica', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('24', 'Sr. Mitrovica', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('25', 'Temerin', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('26', 'Ub', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('27', 'Valjevo', '1', '2015-07-20 15:46:55');
INSERT INTO `city` (`city_id`, `city`, `country_id`, `last_update`) VALUES ('28', 'Vrbas', '1', '2015-07-20 15:46:55');


-- --------------------------------------------------
# -- Table structure for table `country`
-- --------------------------------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `country_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(50) NOT NULL COMMENT 'Drzava ili kompanija',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `country`
-- --------------------------------------------------

INSERT INTO `country` (`country_id`, `country`, `last_update`) VALUES ('1', 'Balkan Bet', '2015-06-25 16:11:23');
INSERT INTO `country` (`country_id`, `country`, `last_update`) VALUES ('2', 'PlanetWin365', '2015-06-25 16:18:37');


-- --------------------------------------------------
# -- Table structure for table `department`
-- --------------------------------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `department_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `staff_id` varchar(60) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`department_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `department`
-- --------------------------------------------------

INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('1', 'Servis BG', '14,13', '2015-08-11 17:55:50');
INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('2', 'Servis NS', '14', '2015-08-11 18:15:43');
INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('3', 'Servis SP', '', '2015-06-23 15:23:50');
INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('4', 'BG Game Ring', '', '2015-06-23 15:23:50');
INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('5', 'Servis', '', '2015-06-23 15:23:50');
INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('6', 'King Kong', '', '2015-06-23 15:23:50');
INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('7', 'SP Game Ring', '', '2015-06-23 15:23:50');
INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('8', 'NS Game Ring', '', '2015-06-23 15:23:50');
INSERT INTO `department` (`department_id`, `name`, `staff_id`, `last_update`) VALUES ('9', 'PW365 Game Ring', '', '2015-06-23 15:23:50');


-- --------------------------------------------------
# -- Table structure for table `email_templates`
-- --------------------------------------------------
DROP TABLE IF EXISTS `email_templates`;
CREATE TABLE `email_templates` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `help` text,
  `body` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `email_templates`
-- --------------------------------------------------

INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('1', 'Registration Email', 'Please verify your email', 'This template is used to send Registration Verification Email, when Configuration->Registration Verification is set to YES', '&lt;div align=&quot;center&quot;&gt;\n&lt;table cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; width=&quot;600&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;Welcome [NAME]! Thanks for registering.&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td valign=&quot;top&quot; style=&quot;text-align: left;&quot;&gt;Hello,&lt;br /&gt;\n            &lt;br /&gt;\n            You&#039;re now a member of [SITE_NAME].&lt;br /&gt;\n            &lt;br /&gt;\n            Here are your login details. Please keep them in a safe place:&lt;br /&gt;\n            &lt;br /&gt;\n            Username: &lt;strong&gt;[USERNAME]&lt;/strong&gt;&lt;br /&gt;\n            Password: &lt;strong&gt;[PASSWORD]&lt;/strong&gt;         &lt;hr /&gt;\n            The administrator of this site has requested all new accounts&lt;br /&gt;\n            to be activated by the users who created them thus your account&lt;br /&gt;\n            is currently inactive. To activate your account,&lt;br /&gt;\n            please visit the link below and enter the following:&lt;hr /&gt;\n            Token: &lt;strong&gt;[TOKEN]&lt;/strong&gt;&lt;br /&gt;\n            Email: &lt;strong&gt;[EMAIL]&lt;/strong&gt;         &lt;hr /&gt;\n            &lt;a href=&quot;[LINK]&quot;&gt;Click here to activate tour account&lt;/a&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;&lt;em&gt;Thanks,&lt;br /&gt;\n            [SITE_NAME] Team&lt;br /&gt;\n            &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('2', 'Forgot Password Email', 'Password Reset', 'This template is used for retrieving lost user password', '&lt;div align=&quot;center&quot;&gt;\n&lt;table width=&quot;600&quot; cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;New password reset from [SITE_NAME]!&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td valign=&quot;top&quot; style=&quot;text-align: left;&quot;&gt;Hello, &lt;strong&gt;[USERNAME]&lt;/strong&gt;&lt;br /&gt;\n            &lt;br /&gt;\n            It seems that you or someone requested a new password for you.&lt;br /&gt;\n            We have generated a new password, as requested:&lt;br /&gt;\n            &lt;br /&gt;\n            Your new password: &lt;strong&gt;[PASSWORD]&lt;/strong&gt;&lt;br /&gt;\n            &lt;br /&gt;\n            To use the new password you need to activate it. To do this click the link provided below and login with your new password.&lt;br /&gt;\n            &lt;a href=&quot;[LINK]&quot;&gt;[LINK]&lt;/a&gt;&lt;br /&gt;\n            &lt;br /&gt;\n            You can change your password after you sign in.&lt;hr /&gt;\n            Password requested from IP: [IP]&lt;/td&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;&lt;em&gt;Thanks,&lt;br /&gt;\n            [SITE_NAME] Team&lt;br /&gt;\n            &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('3', 'Welcome Mail From Admin', 'You have been registered', 'This template is used to send welcome email, when user is added by administrator', '&lt;div align=&quot;center&quot;&gt;\n&lt;table cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; width=&quot;600&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;Welcome [NAME]! You have been Registered.&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;Hello,&lt;br /&gt;\n            &lt;br /&gt;\n            You&#039;re now a member of [SITE_NAME].&lt;br /&gt;\n            &lt;br /&gt;\n            Here are your login details. Please keep them in a safe place:&lt;br /&gt;\n            &lt;br /&gt;\n            Username: &lt;strong&gt;[USERNAME]&lt;/strong&gt;&lt;br /&gt;\n            Password: &lt;strong&gt;[PASSWORD]&lt;/strong&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;&lt;em&gt;Thanks,&lt;br /&gt;\n            [SITE_NAME] Team&lt;br /&gt;\n            &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('4', 'Default Newsletter', 'Newsletter', 'This is a default newsletter template', '&lt;div align=&quot;center&quot;&gt;\n&lt;table width=&quot;600&quot; cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;Hello [NAME]!&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td valign=&quot;top&quot; style=&quot;text-align: left;&quot;&gt;You are receiving this email as a part of your newsletter subscription.         &lt;hr /&gt;\n            Here goes your newsletter content         &lt;hr /&gt;\n            &lt;/td&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;&lt;em&gt;Thanks,&lt;br /&gt;\n            [SITE_NAME] Team&lt;br /&gt;\n            &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;         &lt;hr /&gt;\n            &lt;span style=&quot;font-size: 11px;&quot;&gt;&lt;em&gt;To stop receiving future newsletters please login into your account         and uncheck newsletter subscription box.&lt;/em&gt;&lt;/span&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('7', 'Welcome Email', 'Welcome', 'This template is used to welcome newly registered user when Configuration-&gt;Registration Verification and Configuration-&gt;Auto Registration are both set to YES', '&lt;div align=&quot;center&quot;&gt;\n&lt;table width=&quot;600&quot; cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;Welcome [NAME]! Thanks for registering.&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;Hello,&lt;br /&gt;\n            &lt;br /&gt;\n            You&#039;re now a member of [SITE_NAME].&lt;br /&gt;\n            &lt;br /&gt;\n            Here are your login details. Please keep them in a safe place:&lt;br /&gt;\n            &lt;br /&gt;\n            Username: &lt;strong&gt;[USERNAME]&lt;/strong&gt;&lt;br /&gt;\n            Password: &lt;strong&gt;[PASSWORD]&lt;/strong&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;&lt;em&gt;Thanks,&lt;br /&gt;\n            [SITE_NAME] Team&lt;br /&gt;\n            &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('10', 'Contact Request', 'Contact Inquiry', 'This template is used to send default Contact Request Form', '&lt;div align=&quot;center&quot;&gt;\n&lt;table width=&quot;600&quot; cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;Hello Admin&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td valign=&quot;top&quot; style=&quot;text-align: left;&quot;&gt;You have a new contact request:         &lt;hr /&gt;\n            [MESSAGE]         &lt;hr /&gt;\n            From: &lt;strong&gt;[SENDER] - [NAME]&lt;/strong&gt;&lt;br /&gt;\n            Subject: &lt;strong&gt;[MAILSUBJECT]&lt;/strong&gt;&lt;br /&gt;\n            Senders IP: &lt;strong&gt;[IP]&lt;/strong&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('12', 'Single Email', 'Single User Email', 'This template is used to email single user', '&lt;div align=&quot;center&quot;&gt;\n  &lt;table width=&quot;600&quot; cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n      &lt;tr&gt;\n        &lt;th style=&quot;background-color:#ccc&quot;&gt;Hello [NAME]&lt;/th&gt;\n      &lt;/tr&gt;\n      &lt;tr&gt;\n        &lt;td valign=&quot;top&quot; style=&quot;text-align:left&quot;&gt;Your message goes here...&lt;/td&gt;\n      &lt;/tr&gt;\n      &lt;tr&gt;\n        &lt;td style=&quot;text-align:left&quot;&gt;&lt;em&gt;Thanks,&lt;br /&gt;\n          [SITE_NAME] Team&lt;br /&gt;\n          &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;&lt;/td&gt;\n      &lt;/tr&gt;\n    &lt;/tbody&gt;\n  &lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('13', 'Notify Admin', 'New User Registration', 'This template is used to notify admin of new registration when Configuration->Registration Notification is set to YES', '&lt;div align=&quot;center&quot;&gt;\n&lt;table cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; width=&quot;600&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;Hello Admin&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td valign=&quot;top&quot; style=&quot;text-align: left;&quot;&gt;You have a new user registration. You can login into your admin panel to view details:&lt;hr /&gt;\n            Username: &lt;strong&gt;[USERNAME]&lt;/strong&gt;&lt;br /&gt;\n            Name: &lt;strong&gt;[NAME]&lt;/strong&gt;&lt;br /&gt;\n            IP: &lt;strong&gt;[IP]&lt;/strong&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('14', 'Registration Pending', 'Registration Verification Pending', 'This template is used to send Registration Verification Email, when Configuration->Auto Registration is set to NO', '&lt;div align=&quot;center&quot;&gt;\n&lt;table cellspacing=&quot;5&quot; cellpadding=&quot;5&quot; border=&quot;0&quot; width=&quot;600&quot; style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;Welcome [NAME]! Thanks for registering.&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td valign=&quot;top&quot; style=&quot;text-align: left;&quot;&gt;Hello,&lt;br /&gt;\n            &lt;br /&gt;\n            You&#039;re now a member of [SITE_NAME].&lt;br /&gt;\n            &lt;br /&gt;\n            Here are your login details. Please keep them in a safe place:&lt;br /&gt;\n            &lt;br /&gt;\n            Username: &lt;strong&gt;[USERNAME]&lt;/strong&gt;&lt;br /&gt;\n            Password: &lt;strong&gt;[PASSWORD]&lt;/strong&gt;         &lt;hr /&gt;\n            The administrator of this site has requested all new accounts&lt;br /&gt;\n            to be activated by the users who created them thus your account&lt;br /&gt;\n            is currently pending verification process.&lt;/td&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;&lt;em&gt;Thanks,&lt;br /&gt;\n            [SITE_NAME] Team&lt;br /&gt;\n            &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');
INSERT INTO `email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES ('16', 'Account Activation', 'Your account have been activated', 'This template is used to notify user when manual account activation is completed', '&lt;div align=&quot;center&quot;&gt;\n&lt;table style=&quot;background: none repeat scroll 0% 0% rgb(244, 244, 244); border: 1px solid rgb(102, 102, 102);&quot; border=&quot;0&quot; cellpadding=&quot;5&quot; cellspacing=&quot;5&quot; width=&quot;600&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;th style=&quot;background-color: rgb(204, 204, 204);&quot;&gt;Hello, [NAME]! &lt;br&gt;&lt;/th&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n          &lt;td style=&quot;text-align: left;&quot; valign=&quot;top&quot;&gt;Hello,&lt;br&gt;\n            &lt;br&gt;\n            You&#039;re now a member of [SITE_NAME].&lt;br&gt;\n            &lt;br&gt;\n            Your account is now fully activated\n            , and you may login at \n            &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;\n            &lt;hr&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: left;&quot;&gt;&lt;em&gt;Thanks,&lt;br&gt;\n            [SITE_NAME] Team&lt;br&gt;\n            &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;&lt;/td&gt;\n        &lt;/tr&gt;\n    &lt;/tbody&gt;\n&lt;/table&gt;\n&lt;/div&gt;');


-- --------------------------------------------------
# -- Table structure for table `news`
-- --------------------------------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `body` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `author` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` date NOT NULL DEFAULT '0000-00-00',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `news`
-- --------------------------------------------------

INSERT INTO `news` (`id`, `title`, `body`, `author`, `created`, `active`) VALUES ('4', 'Vest 2', 'Druga vesy', 'admin', '2015-06-10', '1');
INSERT INTO `news` (`id`, `title`, `body`, `author`, `created`, `active`) VALUES ('5', 'Vest 3', '<p>Ovo je nova vest</p>', 'admin', '2015-07-03', '1');
INSERT INTO `news` (`id`, `title`, `body`, `author`, `created`, `active`) VALUES ('3', 'Vest 1', 'Novi sistem prijave kvara', 'admin', '2015-06-10', '0');


-- --------------------------------------------------
# -- Table structure for table `settings`
-- --------------------------------------------------
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `site_name` varchar(50) DEFAULT NULL,
  `site_email` varchar(40) DEFAULT NULL,
  `site_url` varchar(200) DEFAULT NULL,
  `reg_allowed` tinyint(1) NOT NULL DEFAULT '1',
  `user_limit` tinyint(1) NOT NULL DEFAULT '0',
  `reg_verify` tinyint(1) NOT NULL DEFAULT '0',
  `notify_admin` tinyint(1) NOT NULL DEFAULT '0',
  `auto_verify` tinyint(1) NOT NULL DEFAULT '0',
  `user_perpage` varchar(4) NOT NULL DEFAULT '10',
  `thumb_w` varchar(4) NOT NULL,
  `thumb_h` varchar(4) NOT NULL,
  `logo` varchar(50) DEFAULT NULL,
  `backup` varchar(60) DEFAULT NULL,
  `mailer` enum('PHP','SMTP') NOT NULL DEFAULT 'PHP',
  `smtp_host` varchar(100) DEFAULT NULL,
  `smtp_user` varchar(50) DEFAULT NULL,
  `smtp_pass` varchar(50) DEFAULT NULL,
  `smtp_port` varchar(6) DEFAULT NULL,
  `is_ssl` tinyint(1) NOT NULL DEFAULT '0',
  `version` varchar(5) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `settings`
-- --------------------------------------------------

INSERT INTO `settings` (`site_name`, `site_email`, `site_url`, `reg_allowed`, `user_limit`, `reg_verify`, `notify_admin`, `auto_verify`, `user_perpage`, `thumb_w`, `thumb_h`, `logo`, `backup`, `mailer`, `smtp_host`, `smtp_user`, `smtp_pass`, `smtp_port`, `is_ssl`, `version`) VALUES ('POOLTEAM', 'admin@poolteam.rs', 'http://localhost/als', '0', '0', '0', '0', '0', '10', '72', '72', 'logo.png', '11-Aug-2015_18-17-48.sql', 'PHP', '', '', '', '0', '0', '2.50');


-- --------------------------------------------------
# -- Table structure for table `slot`
-- --------------------------------------------------
DROP TABLE IF EXISTS `slot`;
CREATE TABLE `slot` (
  `slot_id` tinyint(3) unsigned NOT NULL,
  `name` varchar(25) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`slot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `slot`
-- --------------------------------------------------

INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('1', 'Game Ring', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('2', 'Mega Jack', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('3', 'Cobra', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('4', 'Super V+', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('5', 'King Kong', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('6', 'Multi Game', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('7', 'Rulet Alfastreet', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('8', 'Rulet GoldClub', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('9', 'Rulet Caribic', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('10', 'Ultimate', '2015-07-07 16:45:53');
INSERT INTO `slot` (`slot_id`, `name`, `last_update`) VALUES ('11', 'Game Star', '2015-07-07 16:45:53');


-- --------------------------------------------------
# -- Table structure for table `store`
-- --------------------------------------------------
DROP TABLE IF EXISTS `store`;
CREATE TABLE `store` (
  `store_id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `manager_staff_id` varchar(60) NOT NULL,
  `address_id` varchar(75) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `city_id` smallint(5) NOT NULL,
  PRIMARY KEY (`store_id`),
  KEY `idx_fk_address_id` (`address_id`)
) ENGINE=MyISAM AUTO_INCREMENT=258 DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `store`
-- --------------------------------------------------

INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('177', 'STARA PAZOVA Veliki', '126', 'Dositejeva 13', '2015-07-20 16:16:10', '3');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('176', 'STARA PAZOVA Šiš', '12,6', 'Ćirila i Metodija 16', '2015-07-20 16:16:10', '3');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('175', 'STARA PAZOVA Pijaca', '12', 'Branka Radičevića 11', '2015-07-20 16:16:10', '3');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('174', 'STARA PAZOVA Kafe', '12', 'Dositejeva 22', '2015-07-20 16:16:10', '3');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('173', 'STARA PAZOVA Aman', '12', 'Svetosavska 32', '2015-07-20 16:16:10', '3');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('172', 'SREMSKA MITROVICA III', '0', 'Ribarska obala 44', '2015-07-20 16:16:10', '24');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('171', 'SREMSKA MITROVICA II', '0', 'Kralja Petra I 80', '2015-07-20 16:23:17', '24');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('170', 'SREMSKA MITROVICA I', '0', 'Trg Sv. Stefana 11', '2015-07-20 16:23:23', '24');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('169', 'SREMSKA KAMENICA', '0', 'Trg Zmaj Jove 15', '2015-07-20 16:16:10', '23');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('168', 'SPENS', '0', 'Sutjeska 2', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('167', 'SOMBOR II', '0', 'Pariska 13', '2015-07-20 16:16:10', '22');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('166', 'SOMBOR I', '0', 'Vojvođanska 12', '2015-07-20 16:16:10', '22');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('165', 'SENTA', '0', 'Ađanska 5', '2015-07-20 16:16:10', '21');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('164', 'SAJAM', '0', 'Braće Popović 2', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('163', 'PETROVARADIN', '0', 'Preradovićeva 127', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('162', 'OBRENOVAC', '0', 'Karadjordjeva  10', '2015-07-20 16:16:10', '7');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('161', 'NOVOSADSKOG SAJMA', '0', 'Kosančić Ivana 1', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('160', 'NOVO NASELJE II', '0', 'Kneza Miloša 15', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('159', 'NOVO NASELJE I', '0', 'Bul. Jovana Dučića 21', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('158', 'NOVI KNEŽEVAC', '0', 'Kralja Petra I Karađorđevića 39', '2015-07-20 16:16:10', '17');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('157', 'NOVA PAZOVA Royal', '0', 'Kralja Petra I 4', '2015-07-20 16:16:10', '16');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('156', 'NOVA PAZOVA Pumpa', '0', 'Cara Dušana 101', '2015-07-20 16:16:10', '16');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('155', 'NOVA PAZOVA Aleksandar', '0', 'Kralja Petra I 49', '2015-07-20 16:16:10', '16');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('154', 'MODENA', '0', 'Modene 1 -3', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('153', 'LUTRIJA', '0', 'Bul. Oslobođenja 30', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('152', 'LIMAN', '0', 'Narodnog fronta 69', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('151', 'KULA', '0', 'Maršala Tita 95', '2015-07-20 16:16:10', '14');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('150', 'KOVILJ', '0', 'Laze Kostića 36', '2015-07-20 16:16:10', '13');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('149', 'KISACKA', '0', 'Kisačka 25 - 27', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('148', 'KAĆ', '0', 'Svetosavska 19', '2015-07-20 16:16:10', '12');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('147', 'INĐIJA Trzni Centar', '0', 'Trg Slobode 1/I lok.17', '2015-07-20 16:16:10', '11');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('146', 'INĐIJA Sunce', '0', 'Cara Dusana 35', '2015-07-20 16:16:10', '11');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('145', 'INĐIJA Pumpa', '0', 'Kralja Petra Prvog 88', '2015-07-20 16:16:10', '11');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('144', 'INĐIJA Jovana', '0', 'Jug Bogdana 7 - 9', '2015-07-20 16:16:10', '11');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('143', 'INĐIJA Centar', '0', 'Kralja Petra I 15 a', '2015-07-20 16:16:10', '11');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('142', 'HADZI RUVIMOVA', '0', 'Janka Čmelika 19', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('141', 'DOBANOVCI 2', '0', 'Maršala Tita 26', '2015-07-20 16:16:10', '10');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('140', 'DOBANOVCI 1', '0', 'Ugrinovačka 9 a', '2015-07-20 16:16:10', '10');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('139', 'CRVENKA', '0', 'Maršala Tita 121', '2015-07-20 16:16:10', '9');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('138', 'CARA DUSANA', '0', 'Cara Dušana 43', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('137', 'BULEVAR', '0', 'Bulevar Oslobodjenja 75', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('136', 'BATAJNICA Pruga', '0', 'Matrozova bb', '2015-07-20 16:16:10', '8');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('135', 'BATAJNICA Pijaca', '0', 'Stanka Tišme 1', '2015-07-20 16:16:10', '8');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('134', 'BATAJNICA Knez', '0', 'Braće Savić 2', '2015-07-20 16:16:10', '8');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('133', 'BATAJNICA Centar', '0', 'Jovana Brankovića 10', '2015-07-20 16:16:10', '8');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('132', 'BAČKI PETROVAC', '0', 'Kolarova 8', '2015-07-20 16:16:10', '7');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('131', 'BAČKI JARAK', '0', 'Novosadska 71', '2015-07-20 16:16:10', '6');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('130', 'ABC', '0', 'Rumenačka 19', '2015-07-20 16:15:39', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('178', 'TEMERIN', '0', 'Novosadska 379', '2015-07-20 16:16:10', '23');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('179', 'UB', '0', 'Kralja Petra I 60', '2015-07-20 16:16:10', '24');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('180', 'VALJEVO Gradac', '0', 'Knez Mihajlova 3', '2015-07-20 16:16:10', '25');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('181', 'VALJEVO Jadar', '0', 'Kneza Miloša 57', '2015-07-20 16:16:10', '25');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('182', 'VALJEVO Karadjordjeva', '0', 'Karađorđeva 84-86', '2015-07-20 16:16:10', '25');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('183', 'VALJEVO Novo Naselje', '0', 'Vladike Nikolaja 183', '2015-07-20 16:16:10', '25');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('184', 'VALJEVO Setaliste', '0', 'Kneza Miloša 36', '2015-07-20 16:16:10', '25');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('185', 'VALJEVO Vuka Karadzica', '0', 'Vuka Karađića 29', '2015-07-20 16:16:10', '25');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('186', 'VRBAS', '0', 'Maršala Tita 60', '2015-07-20 16:16:10', '26');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('187', '27.MART', '0', 'Majora Ilica 15', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('188', 'ALTINA I', '0', 'Ugrinovački put 18', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('189', 'ALTINA II', '0', 'Pavla Vujisica 66a', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('190', 'ARENA', '0', 'Bul. Arsenija Čarnojevića 95', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('191', 'B.PAROVIĆA', '0', 'Blagoja Parovića 23', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('192', 'BATAJNICA', '0', 'Majora Z. Radosavljevića 216A', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('193', 'BEŽANIJA I', '0', 'Ljubinke Bobić 26 B', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('194', 'BEŽANIJA II', '0', 'Vespučijeva 34', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('195', 'BLOK 70', '0', 'Jurija Gagarina 29 a', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('196', 'BULEVAR', '0', 'Bul. Kralja Aleksandra 119', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('197', 'DŽ. VAŠINGTONA', '0', 'Džordža Vašingtona 26', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('198', 'GLAVNA', '0', 'Glavna 40', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('199', 'KARABURMA', '0', 'Stevana Hristića 2', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('200', 'MILJAKOVAC', '0', 'Borska 41', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('201', 'MIRIJEVO', '0', 'Rableova 19', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('202', 'MUHAR', '0', 'Trg Branka Radičevića 5', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('203', 'N. BANOVCI', '0', 'Beogradska 89', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('204', 'NEHRUOVA', '0', 'Nehruova 63A', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('205', 'OGI', '0', 'Beograd, Despota Stefana 70', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('206', 'PIRAMIDA', '0', 'Jurija Gagarina 28', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('207', 'POŽEŠKA', '0', 'Požeška 67 A', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('208', 'PRIZRENSKA', '0', 'Prizrenska 2a', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('209', 'PRVOMAJSKA I', '0', 'Prvomajska 36 I', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('210', 'PRVOMAJSKA II', '0', 'Prvomajska 116', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('211', 'PRVOMAJSKA III', '0', 'Prvomajska 36 L', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('212', 'RAKOVICA', '0', 'Pilota Mihajla Petrovića 3', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('213', 'RUMA I', '0', 'Veljka Dugoševića 171-173', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('214', 'RUMA II', '0', '27. Oktobra 3 / lokal 1 - 1 a', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('215', 'RUMA III', '0', 'Glavna 153', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('216', 'RUZVELTOVA', '0', 'Ruzveltova 5', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('217', 'SALON D', '0', 'Aleksandra Dubčeka 20', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('218', 'SARAJEVSKA', '0', 'Sarajevska 11', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('219', 'SLAVIJA', '0', 'Bul. Oslobodjenja 6', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('220', 'ST. MERKATOR', '0', 'Palmira Toljatija 5', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('221', 'STUDENJAK', '0', 'Tošin Bunar 143 B', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('222', 'ŠIŠ', '0', 'Goce Delčeva 29', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('223', 'TERAZIJE', '0', 'Terazije 4', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('224', 'TROŠARINA', '0', 'Bul. Oslobođenja 341', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('225', 'UGRINOVAČKA I', '0', 'Ivićeva 2', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('226', 'UGRINOVAČKA II', '0', 'Ugrinovačka 143 b', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('227', 'USTANICKA', '0', 'Ustanička 242', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('228', 'V.ILICA', '0', 'Vojislava Ilića 41-43', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('229', 'V.STEPE I', '0', 'Vojvode Stepe 276', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('230', 'V.STEPE II', '0', 'Vojvode Stepe 140', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('231', 'VIDIKOVAC I', '0', 'Kneza Viseslava 31k', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('232', 'VIDIKOVAC II', '0', 'Pilota Mihajla Petrovića 63', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('233', 'YBC', '0', 'Bul. Mihaila Pupina 10d', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('234', 'ZARKOVO III', '0', 'Spasenovićeva 2', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('235', 'ZELENI VENAC', '0', 'Beograd, Zeleni Venac 2', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('236', 'Ž. STANICA', '0', 'Karađorđeva 87', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('237', 'ŽABAC', '0', 'Omladinskih Brigada 18', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('238', 'ŽARKOVO II', '0', 'Vodovodska 23', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('239', 'SAFARIKOVA', '0', 'Safarikova 21', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('240', 'CARA LAZARA', '0', 'Bulevar Cara Lazara 90', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('241', 'BULEVAR II', '0', 'Bulevar Oslobodjenja 46A', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('242', 'ŠIŠ II', '0', 'Goce Delčeva 27', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('243', 'ALTINA III', '0', 'Dobanovacki put 28G', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('244', 'ŽARKOVO IV', '0', 'Trgovacka 30A', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('245', 'BORČA I', '0', 'Ivana Milutinovića 57', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('246', 'BULEVAR II', '0', 'Bul. Kralja Aleksandra 156', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('247', 'BANJA VRUJCI', '0', 'Berkovac bb', '2015-07-20 16:16:10', '25');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('248', 'M.GORKOG', '0', 'Maksima Gorkog 2C', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('249', 'ALTINA IV', '0', 'Ugrinovacka 212', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('250', 'VALJEVO Cherry', '0', 'Vuka Karađića 37', '2015-07-20 16:16:10', '25');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('251', 'SIRENA', '0', 'Ćirila i Metodija 160', '2015-07-20 16:16:10', '3');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('252', 'ŽABALJ', '0', 'Nikole Tesle 41', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('253', 'BULEVAR III', '0', 'Bulevar Kralja Aleksandra 56', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('254', 'SREMSKI KARLOVCI', '0', 'Mitropolita Stratimirovića 20', '2015-07-20 16:16:10', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('255', 'B.JERKOVIĆ', '0', 'Braće Jerković 134', '2015-07-20 16:16:10', '1');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('256', 'KANJIŽA', '0', 'Glavna 30', '2015-07-20 16:21:33', '2');
INSERT INTO `store` (`store_id`, `name`, `manager_staff_id`, `address_id`, `last_update`, `city_id`) VALUES ('257', 'C.DUŠANA BG', '0', 'Cara Dušana 60', '2015-07-20 16:21:47', '1');


-- --------------------------------------------------
# -- Table structure for table `tickets`
-- --------------------------------------------------
DROP TABLE IF EXISTS `tickets`;
CREATE TABLE `tickets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `trackid` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `lokal` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `department` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `aparat` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `broj` int(3) unsigned DEFAULT NULL,
  `category` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `opis` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `vreme_close` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `man_note` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `vreme_open` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip` varchar(46) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `status` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `manager` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `serviser` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `time_worked` time NOT NULL DEFAULT '00:00:00',
  `arhiviran` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `tel_resen` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `ser_resio` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `ser_punoime` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `trackid` (`trackid`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------
# Dumping data for table `tickets`
-- --------------------------------------------------

INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('6', '0000-00-00 00:00:00', 'arena', 'Arena', '4', '11', '2', '1', 'sdasdasda', '2015-07-20 11:20:11', '', '2015-07-20 11:03:03', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('5', '0000-00-00 00:00:00', 'admin', 'Nenad', '8', '11', '1', '4', 'sdasdasda', '2015-07-20 11:20:20', '', '2015-07-17 16:08:17', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('4', '0000-00-00 00:00:00', 'admin', 'Nenad', '8', '11', '1', '1', 'sdasdasda', '2015-07-20 11:20:24', '', '2015-07-15 10:37:42', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('7', '0000-00-00 00:00:00', 'arena', 'Arena', '6', '11', '1', '2', 'Ovo je problem.', '2015-07-20 11:07:50', '', '2015-07-20 11:07:50', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('8', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '3', '1', '1234541321', '2015-07-20 11:28:07', '', '2015-07-20 11:13:06', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('9', '0000-00-00 00:00:00', 'admin', 'Nenad', '1', '9', '3', '4', 'Ne rade monitori', '2015-07-20 11:47:17', '', '2015-07-20 11:47:17', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('10', '0000-00-00 00:00:00', 'abc', 'ABC', '2', '2', '2', '4', 'Ne radi', '2015-07-20 16:34:24', '', '2015-07-20 16:34:24', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('11', '0000-00-00 00:00:00', 'arena', 'Arena', '6', '5', '2', '4', 'Kluc ne radi', '2015-07-27 10:16:39', '', '2015-07-27 10:16:39', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('12', '0000-00-00 00:00:00', 'admin', 'Nenad', '4', '1', '1', '1', '1231231', '2015-08-18 10:35:59', '', '2015-08-18 10:35:31', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('13', '0000-00-00 00:00:00', 'admin', 'Nenad', '4', '3', '1', '1', '123132123', '2015-08-18 10:36:16', '', '2015-08-18 10:36:16', '::1', '0', '5,4', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('14', '0000-00-00 00:00:00', 'arena', 'Arena', '6', '5', '2', '2', '12132123', '2015-08-18 11:07:32', '', '2015-08-18 10:49:18', '::1', '0', '', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('15', '0000-00-00 00:00:00', 'arena', 'Arena', '6', '1', '1', '2', '1213213', '2015-08-18 11:05:39', '', '2015-08-18 11:05:39', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('16', '0000-00-00 00:00:00', 'arena', 'Arena', '4', '3', '1', '1', '1213123', '2015-08-18 11:07:01', '', '2015-08-18 11:07:01', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('17', '0000-00-00 00:00:00', 'arena', 'Arena', '4', '1', '1', '1', '12313', '2015-08-18 11:16:42', '', '2015-08-18 11:16:42', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('18', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '1', '1231', '2015-08-18 11:19:41', '', '2015-08-18 11:19:41', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('19', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '2', '123132', '2015-08-18 11:26:04', '', '2015-08-18 11:26:04', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('20', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '4', '12313', '2015-08-18 11:30:11', '', '2015-08-18 11:30:11', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('21', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '1', '1', '131', '2015-08-18 11:35:57', '', '2015-08-18 11:35:57', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('22', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '1', '2', '1213', '2015-08-18 11:36:30', '', '2015-08-18 11:36:30', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('23', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '1', '1', '12313', '2015-08-18 11:37:18', '', '2015-08-18 11:37:18', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('24', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '2', '123132', '2015-08-18 11:56:23', '', '2015-08-18 11:56:23', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('25', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '1', '2', '1qweq', '2015-08-18 11:57:05', '', '2015-08-18 11:57:05', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('26', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '1', '2', '111', '2015-08-18 11:58:07', '', '2015-08-18 11:58:07', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('27', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '1', '1', 'asdas', '2015-08-18 11:58:34', '', '2015-08-18 11:58:34', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('28', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '2', '1231', '2015-08-18 12:01:22', '', '2015-08-18 12:01:22', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('29', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '1', '2', 'dasda', '2015-08-18 12:03:19', '', '2015-08-18 12:03:19', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('30', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '1', '121', '2015-08-18 12:04:17', '', '2015-08-18 12:04:17', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('31', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '2', 'dasda', '2015-08-18 12:05:42', '', '2015-08-18 12:05:42', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('32', '0000-00-00 00:00:00', 'arena', 'Arena', '4', '5', '1', '2', 'wqe', '2015-08-18 12:06:12', '', '2015-08-18 12:06:12', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('33', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '3', '1', '2', 'sadasd', '2015-08-18 12:06:54', '', '2015-08-18 12:06:54', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('34', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '1', '1231', '2015-08-18 12:13:00', '', '2015-08-18 12:13:00', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('35', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '1', 'asdasd', '2015-08-18 12:13:29', '', '2015-08-18 12:13:29', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('36', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '5', '1', '2', '1231232', '2015-08-18 12:14:21', '', '2015-08-18 12:14:21', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('37', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '1', '1', '1', 'sdsa', '2015-08-18 12:24:45', '', '2015-08-18 12:24:45', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('38', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '5', '1', '1', 'asdas', '2015-08-18 12:25:35', '', '2015-08-18 12:25:35', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('39', '0000-00-00 00:00:00', 'arena', 'Arena', '6', '11', '123', '1', '132132', '2015-08-18 12:28:06', '', '2015-08-18 12:28:06', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('40', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '5', '1', '4', 'sdasda', '2015-08-18 12:29:58', '', '2015-08-18 12:29:58', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('41', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '5', '1', '1', 'sdasd', '2015-08-18 12:32:08', '', '2015-08-18 12:32:08', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('42', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '5', '1', '1', 'asasd', '2015-08-18 12:33:54', '', '2015-08-18 12:33:54', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('43', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '5', '1', '1', 'sadasda', '2015-08-18 12:49:07', '', '2015-08-18 12:49:07', '::1', '0', '12,6', '', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('44', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '2', '1', '4', 'sdfsd', '2015-08-18 12:49:39', '', '2015-08-18 12:49:39', '::1', '0', '12,6', '14,13', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('45', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '6', '1', '1', 'asdasda', '2015-08-18 13:01:23', '', '2015-08-18 13:01:23', '::1', '0', '12,6', '14,13', '00:00:00', '0', '0', '0', '');
INSERT INTO `tickets` (`id`, `trackid`, `user_name`, `lokal`, `department`, `aparat`, `broj`, `category`, `opis`, `vreme_close`, `man_note`, `vreme_open`, `ip`, `status`, `manager`, `serviser`, `time_worked`, `arhiviran`, `tel_resen`, `ser_resio`, `ser_punoime`) VALUES ('46', '0000-00-00 00:00:00', 'arena', 'Arena', '1', '6', '1', '3', 'sadas', '2015-08-18 13:04:42', '', '2015-08-18 13:04:42', '::1', '0', '12,6', '14,13', '00:00:00', '0', '0', '0', '');


-- --------------------------------------------------
# -- Table structure for table `users`
-- --------------------------------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `password` varchar(32) DEFAULT NULL,
  `cookie_id` varchar(64) NOT NULL DEFAULT '0',
  `token` varchar(128) NOT NULL DEFAULT '0',
  `userlevel` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `email` varchar(50) DEFAULT NULL,
  `fname` varchar(50) DEFAULT NULL,
  `lname` varchar(50) DEFAULT NULL,
  `country` varchar(60) NOT NULL COMMENT 'Drzava ili kompanija countrz.country_id',
  `lokal` varchar(50) NOT NULL,
  `send_to` varchar(60) NOT NULL COMMENT 'kome salje mailove',
  `dept_to` varchar(60) NOT NULL COMMENT 'Kom odeljenju pripada',
  `ip` varchar(16) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastip` varchar(16) DEFAULT NULL,
  `notes` text,
  `newsletter` tinyint(1) NOT NULL DEFAULT '0',
  `active` enum('y','n','b','t') NOT NULL DEFAULT 'n',
  `e_send` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Kome se salje mail',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- --------------------------------------------------
# Dumping data for table `users`
-- --------------------------------------------------

INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('1', 'admin', '117e68d688a7db36bb80cdef77aaa114', '1', '1', '9', 'admin@poolteam.rs', 'Nenad', 'Aleksić', '1', '', '5,4', '', '', '2015-06-10 12:43:03', '2015-08-18 12:53:27', '::1', '', '0', 'y', '1');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('2', 'arena', 'b2f82119b6f4832b79e3aff76c3fd260', '1', '1', '1', 'arena@arena.rs', 'Arena', '', '1', '190', '12,6', '4,6,1', '', '2015-06-10 12:58:17', '2015-08-18 10:30:13', '::1', '', '0', 'y', '0');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('4', 'zeka', 'cc3e8f9bb2ff96477f144de49864c987', '0', '0', '9', 'zeke@poolteam.rs', 'Zeka', 'Dimitrijevic', '1', '', '', '', '', '2015-06-18 14:39:17', '2015-06-18 17:37:27', '::1', '', '1', 'y', '1');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('5', 'tanja', 'a395177309469ec81237bc6516db571f', '0', '0', '9', 'tanja@kokomo.com', 'Tatjana', 'Mrgic', '1', '', '', '', '', '2015-06-18 14:49:20', '2015-06-18 16:45:44', '::1', '', '1', 'y', '1');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('6', 'mika', '8b680e9d261c2067992f7fed8118801c', '0', '0', '3', 'mika@gmail.com', 'MIka', 'Manager', '1', '', '', '', '', '2015-06-18 16:49:47', '0000-00-00 00:00:00', '', '', '1', 'y', '1');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('8', 'vlada', '8b680e9d261c2067992f7fed8118801c', '0', '0', '3', 'mika@gmail.com', 'Vlada', 'Ogi', '2', '', '', '', '', '2015-06-18 16:49:47', '0000-00-00 00:00:00', '', '', '1', 'y', '1');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('7', 'PWarena', 'b2f82119b6f4832b79e3aff76c3fd260', '0', '0', '1', 'PWarena@arena.rs', 'Arena', 'BG', '2', '188', '8', '', '', '2015-06-10 12:58:17', '2015-06-22 18:42:32', '::1', '', '0', 'y', '1');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('11', 'abc', '0465974142cbd01f10f2713193a26167', '0', '0', '1', '', 'ABC', 'Novi Sad', '1', '130', '1,5,4', '8,2', '', '0000-00-00 00:00:00', '2015-07-20 16:33:19', '::1', '', '0', 'y', '0');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('12', 'goran', 'b6c15f35f1dc6e14d8345fba4b599145', '0', '0', '3', 'goran.mandic@gmail.com', 'Goran', 'Mandic', '1', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '0', 'y', '1');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('13', 'deki', '1c22b543331742f22a79fde3087a645d', '0', '0', '2', 'deki@poolteam.rs', 'Dejan', 'Majkic', '1', '', '', '6,1', '', '2015-06-10 18:10:26', '2015-07-02 11:21:28', '::1', '', '1', 'y', '1');
INSERT INTO `users` (`id`, `username`, `password`, `cookie_id`, `token`, `userlevel`, `email`, `fname`, `lname`, `country`, `lokal`, `send_to`, `dept_to`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `newsletter`, `active`, `e_send`) VALUES ('14', 'david', '1c22b543331742f22a79fde3087a645d', '0', '0', '2', 'david@poolteam.rs', 'David', 'Stefanovic', '1', '', '', '6,1', '', '2015-06-10 18:10:26', '2015-07-02 11:21:28', '::1', '', '1', 'y', '1');


