Ahfsaxmb

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : localhost
5Source Server Version : 50617
6Source Host           : localhost:3306
7Source Database       : mojspis
8
9Target Server Type    : MYSQL
10Target Server Version : 50617
11File Encoding         : 65001
12
13Date: 2014-12-12 14:59:56
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for acos
20-- ----------------------------
21DROP TABLE IF EXISTS `acos`;
22CREATE TABLE `acos` (
23`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
24`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
25PRIMARY KEY (`id`)
26)
27ENGINE=InnoDB
28DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
29AUTO_INCREMENT=70
30
31;
32
33-- ----------------------------
34-- Records of acos
35-- ----------------------------
36BEGIN;
37INSERT INTO `acos` VALUES ('1', 'suits_module'), ('2', 'my_suits_module'), ('3', 'suits_favorites_module'), ('4', 'suits_recents_module'), ('5', 'suits_client_lawsuits_module'), ('6', 'suits_employee_lawsuits_module'), ('7', 'suits_contact_lawsuits_module'), ('8', 'contacts_module'), ('9', 'contacts_favorites_module'), ('10', 'contacts_recents_module'), ('11', 'users_module'), ('12', 'roles_module'), ('13', 'suit_priorities_module'), ('14', 'suit_types_module'), ('15', 'client_statuses_module'), ('16', 'jurisdictions_module'), ('17', 'judges_module'), ('18', 'languages_module'), ('19', 'invoices_module'), ('20', 'billing_accounts_module'), ('21', 'billing_items_module'), ('22', 'report_tasks_module'), ('23', 'report_suits_module'), ('24', 'report_projects_module'), ('25', 'invoices_draft_module'), ('26', 'products_module'), ('27', 'projects_module'), ('28', 'currencies_module'), ('29', 'users_create'), ('30', 'users_read'), ('31', 'users_update'), ('32', 'users_delete'), ('33', 'suits_create'), ('34', 'suits_read'), ('35', 'suits_update'), ('36', 'suits_delete'), ('37', 'contacts_create'), ('38', 'contacts_read'), ('39', 'contacts_update'), ('40', 'contacts_delete'), ('41', 'suit_priorities_create'), ('42', 'suit_priorities_read'), ('43', 'suit_priorities_update'), ('44', 'suit_priorities_delete'), ('45', 'suit_types_create'), ('46', 'suit_types_read'), ('47', 'suit_types_update'), ('48', 'suit_types_delete'), ('49', 'roles_create'), ('50', 'roles_read'), ('51', 'roles_update'), ('52', 'roles_delete'), ('53', 'client_statuses_create'), ('54', 'client_statuses_read'), ('55', 'client_statuses_update'), ('56', 'client_statuses_delete'), ('57', 'jurisdictions_create'), ('58', 'jurisdictions_read'), ('59', 'jurisdictions_update'), ('60', 'jurisdictions_delete'), ('61', 'judges_create'), ('62', 'judges_read'), ('63', 'judges_update'), ('64', 'judges_delete'), ('65', 'languages_create'), ('66', 'languages_read'), ('67', 'languages_update'), ('68', 'languages_delete'), ('69', 'activities_read');
38COMMIT;
39
40-- ----------------------------
41-- Table structure for acos_aros
42-- ----------------------------
43DROP TABLE IF EXISTS `acos_aros`;
44CREATE TABLE `acos_aros` (
45`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
46`aro_id`  int(11) NOT NULL ,
47`aco_id`  int(11) NOT NULL ,
48`allowed`  int(1) NOT NULL ,
49PRIMARY KEY (`id`)
50)
51ENGINE=InnoDB
52DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
53AUTO_INCREMENT=208
54
55;
56
57-- ----------------------------
58-- Records of acos_aros
59-- ----------------------------
60BEGIN;
61INSERT INTO `acos_aros` VALUES ('1', '1', '1', '1'), ('2', '2', '1', '0'), ('3', '3', '1', '0'), ('4', '1', '2', '1'), ('5', '2', '2', '0'), ('6', '3', '2', '0'), ('7', '1', '3', '1'), ('8', '2', '3', '0'), ('9', '3', '3', '0'), ('10', '1', '4', '1'), ('11', '2', '4', '0'), ('12', '3', '4', '0'), ('13', '1', '5', '1'), ('14', '2', '5', '0'), ('15', '3', '5', '0'), ('16', '1', '6', '1'), ('17', '2', '6', '0'), ('18', '3', '6', '0'), ('19', '1', '7', '1'), ('20', '2', '7', '0'), ('21', '3', '7', '0'), ('22', '1', '8', '1'), ('23', '2', '8', '0'), ('24', '3', '8', '0'), ('25', '1', '9', '1'), ('26', '2', '9', '0'), ('27', '3', '9', '0'), ('28', '1', '10', '1'), ('29', '2', '10', '0'), ('30', '3', '10', '0'), ('31', '1', '11', '1'), ('32', '2', '11', '0'), ('33', '3', '11', '0'), ('34', '1', '12', '1'), ('35', '2', '12', '0'), ('36', '3', '12', '0'), ('37', '1', '13', '1'), ('38', '2', '13', '0'), ('39', '3', '13', '0'), ('40', '1', '14', '1'), ('41', '2', '14', '0'), ('42', '3', '14', '0'), ('43', '1', '15', '1'), ('44', '2', '15', '0'), ('45', '3', '15', '0'), ('46', '1', '16', '1'), ('47', '2', '16', '0'), ('48', '3', '16', '0'), ('49', '1', '17', '1'), ('50', '2', '17', '0'), ('51', '3', '17', '0'), ('52', '1', '18', '1'), ('53', '2', '18', '0'), ('54', '3', '18', '0'), ('55', '1', '19', '1'), ('56', '2', '19', '0'), ('57', '3', '19', '0'), ('58', '1', '20', '1'), ('59', '2', '20', '0'), ('60', '3', '20', '0'), ('61', '1', '21', '1'), ('62', '2', '21', '0'), ('63', '3', '21', '0'), ('64', '1', '22', '1'), ('65', '2', '22', '0'), ('66', '3', '22', '0'), ('67', '1', '23', '1'), ('68', '2', '23', '0'), ('69', '3', '23', '0'), ('70', '1', '24', '1'), ('71', '2', '24', '0'), ('72', '3', '24', '0'), ('73', '1', '25', '1'), ('74', '2', '25', '0'), ('75', '3', '25', '0'), ('76', '1', '26', '1'), ('77', '2', '26', '0'), ('78', '3', '26', '0'), ('79', '1', '27', '1'), ('80', '2', '27', '0'), ('81', '3', '27', '0'), ('82', '1', '28', '1'), ('83', '2', '28', '0'), ('84', '3', '28', '0'), ('85', '1', '29', '1'), ('86', '2', '29', '0'), ('87', '3', '29', '0'), ('88', '1', '30', '1'), ('89', '2', '30', '0'), ('90', '3', '30', '0'), ('91', '1', '31', '1'), ('92', '2', '31', '0'), ('93', '3', '31', '0'), ('94', '1', '32', '1'), ('95', '2', '32', '0'), ('96', '3', '32', '0'), ('97', '1', '33', '1'), ('98', '2', '33', '0'), ('99', '3', '33', '0'), ('100', '1', '34', '1');
62INSERT INTO `acos_aros` VALUES ('101', '2', '34', '0'), ('102', '3', '34', '0'), ('103', '1', '35', '1'), ('104', '2', '35', '0'), ('105', '3', '35', '0'), ('106', '1', '36', '1'), ('107', '2', '36', '0'), ('108', '3', '36', '0'), ('109', '1', '37', '1'), ('110', '2', '37', '0'), ('111', '3', '37', '0'), ('112', '1', '38', '1'), ('113', '2', '38', '0'), ('114', '3', '38', '0'), ('115', '1', '39', '1'), ('116', '2', '39', '0'), ('117', '3', '39', '0'), ('118', '1', '40', '1'), ('119', '2', '40', '0'), ('120', '3', '40', '0'), ('121', '1', '41', '1'), ('122', '2', '41', '0'), ('123', '3', '41', '0'), ('124', '1', '42', '1'), ('125', '2', '42', '0'), ('126', '3', '42', '0'), ('127', '1', '43', '1'), ('128', '2', '43', '0'), ('129', '3', '43', '0'), ('130', '1', '44', '1'), ('131', '2', '44', '0'), ('132', '3', '44', '0'), ('133', '1', '45', '1'), ('134', '2', '45', '0'), ('135', '3', '45', '0'), ('136', '1', '46', '1'), ('137', '2', '46', '0'), ('138', '3', '46', '0'), ('139', '1', '47', '1'), ('140', '2', '47', '0'), ('141', '3', '47', '0'), ('142', '1', '48', '1'), ('143', '2', '48', '0'), ('144', '3', '48', '0'), ('145', '1', '49', '1'), ('146', '2', '49', '0'), ('147', '3', '49', '0'), ('148', '1', '50', '1'), ('149', '2', '50', '0'), ('150', '3', '50', '0'), ('151', '1', '51', '1'), ('152', '2', '51', '0'), ('153', '3', '51', '0'), ('154', '1', '52', '1'), ('155', '2', '52', '0'), ('156', '3', '52', '0'), ('157', '1', '53', '1'), ('158', '2', '53', '0'), ('159', '3', '53', '0'), ('160', '1', '54', '1'), ('161', '2', '54', '0'), ('162', '3', '54', '0'), ('163', '1', '55', '1'), ('164', '2', '55', '0'), ('165', '3', '55', '0'), ('166', '1', '56', '1'), ('167', '2', '56', '0'), ('168', '3', '56', '0'), ('169', '1', '57', '1'), ('170', '2', '57', '0'), ('171', '3', '57', '0'), ('172', '1', '58', '1'), ('173', '2', '58', '0'), ('174', '3', '58', '0'), ('175', '1', '59', '1'), ('176', '2', '59', '0'), ('177', '3', '59', '0'), ('178', '1', '60', '1'), ('179', '2', '60', '0'), ('180', '3', '60', '0'), ('181', '1', '61', '1'), ('182', '2', '61', '0'), ('183', '3', '61', '0'), ('184', '1', '62', '1'), ('185', '2', '62', '0'), ('186', '3', '62', '0'), ('187', '1', '63', '1'), ('188', '2', '63', '0'), ('189', '3', '63', '0'), ('190', '1', '64', '1'), ('191', '2', '64', '0'), ('192', '3', '64', '0'), ('193', '1', '65', '1'), ('194', '2', '65', '0'), ('195', '3', '65', '0'), ('196', '1', '66', '1'), ('197', '2', '66', '0'), ('198', '3', '66', '0'), ('199', '1', '67', '1'), ('200', '2', '67', '0');
63INSERT INTO `acos_aros` VALUES ('201', '3', '67', '0'), ('202', '1', '68', '1'), ('203', '2', '68', '0'), ('204', '3', '68', '0'), ('205', '1', '69', '1'), ('206', '2', '69', '0'), ('207', '3', '69', '0');
64COMMIT;
65
66-- ----------------------------
67-- Table structure for activities
68-- ----------------------------
69DROP TABLE IF EXISTS `activities`;
70CREATE TABLE `activities` (
71`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
72`type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
73`start_time`  datetime NULL DEFAULT NULL ,
74`end_time`  datetime NULL DEFAULT NULL ,
75`subject`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
76`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
77`module`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
78`module_id`  int(11) NULL DEFAULT NULL ,
79`remainder`  float NULL DEFAULT NULL ,
80`leader_id`  int(11) NULL DEFAULT NULL ,
81`assistant_id`  int(11) NULL DEFAULT NULL ,
82`substitute_id`  int(11) NULL DEFAULT NULL ,
83`billable`  tinyint(1) NULL DEFAULT NULL ,
84`confirmed_by_id`  int(11) NULL DEFAULT NULL ,
85`private`  tinyint(1) NULL DEFAULT NULL ,
86`confirmed_duration`  float NULL DEFAULT NULL ,
87`billing_id`  int(11) NULL DEFAULT NULL ,
88`created`  datetime NULL DEFAULT NULL ,
89`modified`  datetime NULL DEFAULT NULL ,
90`priority`  int(2) NULL DEFAULT NULL ,
91`progress`  int(3) NULL DEFAULT NULL ,
92`status`  int(2) NULL DEFAULT NULL ,
93PRIMARY KEY (`id`)
94)
95ENGINE=InnoDB
96DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
97AUTO_INCREMENT=1
98
99;
100
101-- ----------------------------
102-- Records of activities
103-- ----------------------------
104BEGIN;
105COMMIT;
106
107-- ----------------------------
108-- Table structure for aros
109-- ----------------------------
110DROP TABLE IF EXISTS `aros`;
111CREATE TABLE `aros` (
112`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
113`alias`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
114PRIMARY KEY (`id`)
115)
116ENGINE=InnoDB
117DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
118AUTO_INCREMENT=4
119
120;
121
122-- ----------------------------
123-- Records of aros
124-- ----------------------------
125BEGIN;
126INSERT INTO `aros` VALUES ('1', 'Administrator'), ('2', 'User'), ('3', 'Guest');
127COMMIT;
128
129-- ----------------------------
130-- Table structure for billing_accounts
131-- ----------------------------
132DROP TABLE IF EXISTS `billing_accounts`;
133CREATE TABLE `billing_accounts` (
134`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
135`client_id`  int(11) NULL DEFAULT NULL ,
136`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
137`module`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
138`module_id`  int(11) NULL DEFAULT NULL ,
139`billing_method`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
140`flat_value`  decimal(10,2) NULL DEFAULT 0.00 ,
141`currency_id`  int(11) UNSIGNED NOT NULL ,
142`created`  datetime NULL DEFAULT NULL ,
143`modified`  datetime NULL DEFAULT NULL ,
144PRIMARY KEY (`id`)
145)
146ENGINE=InnoDB
147DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
148AUTO_INCREMENT=1
149
150;
151
152-- ----------------------------
153-- Records of billing_accounts
154-- ----------------------------
155BEGIN;
156COMMIT;
157
158-- ----------------------------
159-- Table structure for billing_items
160-- ----------------------------
161DROP TABLE IF EXISTS `billing_items`;
162CREATE TABLE `billing_items` (
163`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
164`ordinal_number`  int(5) NULL DEFAULT NULL ,
165`billing_account_id`  int(11) NULL DEFAULT NULL ,
166`date`  datetime NULL DEFAULT NULL ,
167`billing_item_category`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
168`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
169`time`  float NULL DEFAULT NULL ,
170`billable_time`  float NULL DEFAULT NULL ,
171`written_off_time`  float NULL DEFAULT NULL ,
172`quantity`  float NULL DEFAULT NULL ,
173`unit_price`  decimal(12,2) NULL DEFAULT NULL ,
174`price`  decimal(12,2) NULL DEFAULT NULL ,
175`user_id`  int(11) NULL DEFAULT NULL ,
176`billing_item_type`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
177`created_by`  int(11) NULL DEFAULT NULL ,
178`modified_by`  int(11) NULL DEFAULT NULL ,
179`created`  datetime NULL DEFAULT NULL ,
180`modified`  datetime NULL DEFAULT NULL ,
181`invoice_item_id`  int(11) NULL DEFAULT NULL ,
182`invoice_id`  int(11) NULL DEFAULT NULL ,
183PRIMARY KEY (`id`)
184)
185ENGINE=InnoDB
186DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
187AUTO_INCREMENT=1
188
189;
190
191-- ----------------------------
192-- Records of billing_items
193-- ----------------------------
194BEGIN;
195COMMIT;
196
197-- ----------------------------
198-- Table structure for billing_price_list_items
199-- ----------------------------
200DROP TABLE IF EXISTS `billing_price_list_items`;
201CREATE TABLE `billing_price_list_items` (
202`id`  int(11) NOT NULL AUTO_INCREMENT ,
203`billing_price_list_id`  int(11) UNSIGNED NULL DEFAULT NULL ,
204`user_id`  int(11) UNSIGNED NULL DEFAULT NULL ,
205`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
206`value`  decimal(10,2) NULL DEFAULT NULL ,
207PRIMARY KEY (`id`)
208)
209ENGINE=InnoDB
210DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
211AUTO_INCREMENT=1
212
213;
214
215-- ----------------------------
216-- Records of billing_price_list_items
217-- ----------------------------
218BEGIN;
219COMMIT;
220
221-- ----------------------------
222-- Table structure for billing_price_lists
223-- ----------------------------
224DROP TABLE IF EXISTS `billing_price_lists`;
225CREATE TABLE `billing_price_lists` (
226`id`  int(11) NOT NULL AUTO_INCREMENT ,
227`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
228`billing_account_id`  int(11) NULL DEFAULT NULL ,
229PRIMARY KEY (`id`)
230)
231ENGINE=InnoDB
232DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
233AUTO_INCREMENT=1
234
235;
236
237-- ----------------------------
238-- Records of billing_price_lists
239-- ----------------------------
240BEGIN;
241COMMIT;
242
243-- ----------------------------
244-- Table structure for client_statuses
245-- ----------------------------
246DROP TABLE IF EXISTS `client_statuses`;
247CREATE TABLE `client_statuses` (
248`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
249`name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
250`created`  datetime NOT NULL ,
251`modified`  datetime NOT NULL ,
252PRIMARY KEY (`id`)
253)
254ENGINE=InnoDB
255DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
256AUTO_INCREMENT=28
257
258;
259
260-- ----------------------------
261-- Records of client_statuses
262-- ----------------------------
263BEGIN;
264INSERT INTO `client_statuses` VALUES ('2', 'Dužnik', '0000-00-00 00:00:00', '2013-02-26 11:42:17'), ('4', 'Kupac', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('5', 'Nasljednik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('6', 'Okrivljenik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('7', 'Ostalo', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('8', 'Oštećenik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('9', 'Ovrhovoditelj', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('10', 'Ovršenik', '0000-00-00 00:00:00', '2013-07-01 07:47:42'), ('11', 'Predlagatelj', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('12', 'Predlagatelj osiguranja', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('13', 'Predlagatelj upisa', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('14', 'Prekršitelj', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('15', 'Prodavatelj', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('16', 'Protivnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('17', 'Protivnik osiguranja', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('18', 'Protivnik upisa', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('19', 'Stečajni dužnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('20', 'Stečajni vjerovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('21', 'Treća osoba', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('22', 'Tuženik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('23', 'Tužitelj', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('24', 'Umješač', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('25', 'Vjerovnik', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('26', 'Zainteresirana strana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('27', 'Zajmodavac', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
265COMMIT;
266
267-- ----------------------------
268-- Table structure for config
269-- ----------------------------
270DROP TABLE IF EXISTS `config`;
271CREATE TABLE `config` (
272`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
273`type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
274`owner_id`  int(11) NULL DEFAULT NULL ,
275`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
276`value`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
277`parameters`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
278`translate`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
279`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
280PRIMARY KEY (`id`)
281)
282ENGINE=InnoDB
283DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
284AUTO_INCREMENT=103
285
286;
287
288-- ----------------------------
289-- Records of config
290-- ----------------------------
291BEGIN;
292INSERT INTO `config` VALUES ('1', 'User', '1', 'Dashboard/FavoriteSuits', '1', 'dashboardFavoriteSuits', 'FavoriteSuits', null), ('2', 'User', '1', 'Dashboard/RecentSuits', '1', 'dashboardRecentSuits', 'RecentSuits', null), ('3', 'User', '1', 'Dashboard/MySuits', '1', 'dashboardMySuits', 'MySuits', null), ('4', 'User', '1', 'Dashboard/FavoriteContacts', '1', 'dashboardFavoriteContacts', 'FavoriteContacts', null), ('5', 'User', '1', 'Dashboard/RecentContacts', '1', 'dashboardRecentContacts', 'RecentContacts', null), ('6', 'User', '1', 'Dashboard/ActivitiesYesterday', '1', 'dashboardActivitiesYesterday', 'ActivitiesYesterday', null), ('7', 'User', '1', 'Dashboard/ActivitiesToday', '1', 'dashboardActivitiesToday', 'ActivitiesToday', null), ('8', 'User', '1', 'Dashboard/ActivitiesTomorrow', '1', 'dashboardActivitiesTomorrow', 'ActivitiesTomorrow', null), ('9', 'User', '1', 'Dashboard/NumberOfColumns', '4', null, 'NumberOfColumnsInDashboard', null), ('57', 'User', '2', 'Dashboard/FavoriteSuits', '1', 'dashboardFavoriteSuits', 'FavoriteSuits', null), ('58', 'User', '2', 'Dashboard/RecentSuits', '1', 'dashboardRecentSuits', 'RecentSuits', null), ('59', 'User', '2', 'Dashboard/MySuits', '1', 'dashboardMySuits', 'MySuits', null), ('60', 'User', '2', 'Dashboard/FavoriteContacts', '1', 'dashboardFavoriteContacts', 'FavoriteContacts', null), ('61', 'User', '2', 'Dashboard/RecentContacts', '1', 'dashboardRecentContacts', 'RecentContacts', null), ('62', 'User', '2', 'Dashboard/ActivitiesYesterday', '1', 'dashboardActivitiesYesterday', 'ActivitiesYesterday', null), ('63', 'User', '2', 'Dashboard/ActivitiesToday', '1', 'dashboardActivitiesToday', 'ActivitiesToday', null), ('64', 'User', '2', 'Dashboard/ActivitiesTomorrow', '1', 'dashboardActivitiesTomorrow', 'ActivitiesTomorrow', null), ('65', 'User', '2', 'Dashboard/NumberOfColumns', '4', null, 'NumberOfColumnsInDashboard', null), ('66', 'User', '3', 'Dashboard/FavoriteSuits', '1', 'dashboardFavoriteSuits', 'FavoriteSuits', null), ('67', 'User', '3', 'Dashboard/RecentSuits', '1', 'dashboardRecentSuits', 'RecentSuits', null), ('68', 'User', '3', 'Dashboard/MySuits', '1', 'dashboardMySuits', 'MySuits', null), ('69', 'User', '3', 'Dashboard/FavoriteContacts', '1', 'dashboardFavoriteContacts', 'FavoriteContacts', null), ('70', 'User', '3', 'Dashboard/RecentContacts', '1', 'dashboardRecentContacts', 'RecentContacts', null), ('71', 'User', '3', 'Dashboard/ActivitiesYesterday', '1', 'dashboardActivitiesYesterday', 'ActivitiesYesterday', null), ('72', 'User', '3', 'Dashboard/ActivitiesToday', '1', 'dashboardActivitiesToday', 'ActivitiesToday', null), ('73', 'User', '3', 'Dashboard/ActivitiesTomorrow', '1', 'dashboardActivitiesTomorrow', 'ActivitiesTomorrow', null), ('74', 'User', '3', 'Dashboard/NumberOfColumns', '4', null, 'NumberOfColumnsInDashboard', null), ('75', 'User', '4', 'Dashboard/FavoriteSuits', '1', 'dashboardFavoriteSuits', 'FavoriteSuits', null), ('76', 'User', '4', 'Dashboard/RecentSuits', '1', 'dashboardRecentSuits', 'RecentSuits', null), ('77', 'User', '4', 'Dashboard/MySuits', '1', 'dashboardMySuits', 'MySuits', null), ('78', 'User', '4', 'Dashboard/FavoriteContacts', '1', 'dashboardFavoriteContacts', 'FavoriteContacts', null), ('79', 'User', '4', 'Dashboard/RecentContacts', '1', 'dashboardRecentContacts', 'RecentContacts', null), ('80', 'User', '4', 'Dashboard/ActivitiesYesterday', '1', 'dashboardActivitiesYesterday', 'ActivitiesYesterday', null), ('81', 'User', '4', 'Dashboard/ActivitiesToday', '1', 'dashboardActivitiesToday', 'ActivitiesToday', null), ('82', 'User', '4', 'Dashboard/ActivitiesTomorrow', '1', 'dashboardActivitiesTomorrow', 'ActivitiesTomorrow', null), ('83', 'User', '4', 'Dashboard/NumberOfColumns', '4', null, 'NumberOfColumnsInDashboard', null), ('84', 'Company', '0', 'IBAN', 'HR1210010051863000160', null, null, null), ('85', 'User', '5', 'Dashboard/FavoriteSuits', '1', 'dashboardFavoriteSuits', 'FavoriteSuits', null), ('86', 'User', '5', 'Dashboard/RecentSuits', '1', 'dashboardRecentSuits', 'RecentSuits', null), ('87', 'User', '5', 'Dashboard/MySuits', '1', 'dashboardMySuits', 'MySuits', null), ('88', 'User', '5', 'Dashboard/FavoriteContacts', '1', 'dashboardFavoriteContacts', 'FavoriteContacts', null), ('89', 'User', '5', 'Dashboard/RecentContacts', '1', 'dashboardRecentContacts', 'RecentContacts', null), ('90', 'User', '5', 'Dashboard/ActivitiesYesterday', '1', 'dashboardActivitiesYesterday', 'ActivitiesYesterday', null), ('91', 'User', '5', 'Dashboard/ActivitiesToday', '1', 'dashboardActivitiesToday', 'ActivitiesToday', null), ('92', 'User', '5', 'Dashboard/ActivitiesTomorrow', '1', 'dashboardActivitiesTomorrow', 'ActivitiesTomorrow', null), ('93', 'User', '5', 'Dashboard/NumberOfColumns', '4', null, 'NumberOfColumnsInDashboard', null), ('94', 'User', '3', 'Dashboard/FavoriteSuits', '1', 'dashboardFavoriteSuits', 'FavoriteSuits', null), ('95', 'User', '3', 'Dashboard/RecentSuits', '1', 'dashboardRecentSuits', 'RecentSuits', null), ('96', 'User', '3', 'Dashboard/MySuits', '1', 'dashboardMySuits', 'MySuits', null), ('97', 'User', '3', 'Dashboard/FavoriteContacts', '1', 'dashboardFavoriteContacts', 'FavoriteContacts', null), ('98', 'User', '3', 'Dashboard/RecentContacts', '1', 'dashboardRecentContacts', 'RecentContacts', null), ('99', 'User', '3', 'Dashboard/ActivitiesYesterday', '1', 'dashboardActivitiesYesterday', 'ActivitiesYesterday', null), ('100', 'User', '3', 'Dashboard/ActivitiesToday', '1', 'dashboardActivitiesToday', 'ActivitiesToday', null), ('101', 'User', '3', 'Dashboard/ActivitiesTomorrow', '1', 'dashboardActivitiesTomorrow', 'ActivitiesTomorrow', null), ('102', 'User', '3', 'Dashboard/NumberOfColumns', '4', null, 'NumberOfColumnsInDashboard', null);
293COMMIT;
294
295-- ----------------------------
296-- Table structure for contacts
297-- ----------------------------
298DROP TABLE IF EXISTS `contacts`;
299CREATE TABLE `contacts` (
300`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
301`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
302`address`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
303`address2`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
304`city`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
305`zip`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
306`country`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
307`phone`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
308`phone2`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
309`mobile`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
310`mobile2`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
311`fax`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
312`email`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
313`email2`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
314`vat_number`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
315`footnote`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
316`created_by`  int(11) NULL DEFAULT NULL ,
317`modified_by`  int(11) NULL DEFAULT NULL ,
318`grp_client`  tinyint(4) NULL DEFAULT NULL ,
319`grp_counterparty`  tinyint(4) NULL DEFAULT NULL ,
320`grp_counterparty_lawyer`  tinyint(4) NULL DEFAULT NULL ,
321`grp_judge`  tinyint(4) NULL DEFAULT NULL ,
322`grp_guest`  tinyint(4) NULL DEFAULT NULL ,
323`grp_employee`  tinyint(4) NULL DEFAULT NULL ,
324`grp_administrator`  tinyint(4) NULL DEFAULT NULL ,
325`grp_jurisdiction`  tinyint(4) NULL DEFAULT NULL ,
326`grp_sys1`  tinyint(4) NULL DEFAULT NULL ,
327`grp_sys2`  tinyint(4) NULL DEFAULT NULL ,
328`grp_sys3`  tinyint(4) NULL DEFAULT NULL ,
329`status`  tinyint(4) NULL DEFAULT NULL ,
330`tags`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
331`created`  datetime NOT NULL ,
332`modified`  datetime NOT NULL ,
333`currency_id`  int(11) NULL DEFAULT 1 ,
334PRIMARY KEY (`id`)
335)
336ENGINE=InnoDB
337DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
338AUTO_INCREMENT=320
339
340;
341
342-- ----------------------------
343-- Records of contacts
344-- ----------------------------
345BEGIN;
346INSERT INTO `contacts` VALUES ('2', 'Vrhovni sud Republike Hrvatske', 'Trg Nikole Šubića Zrinskoga 3', '', 'Zagreb', '10000', 'Hrvatska', '+385 (1) 4862222', '+385 (1) 4810036', '', '', '+385 (1) 4810035', 'vsrh@vsrh.hr', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', 'kontakt', '0000-00-00 00:00:00', '2013-04-23 17:31:14', '1'), ('4', 'Županijski sud u Bjelovaru, Stalna služba u Virovitici', 'Ljudevita Gaja 3', null, 'Virovitica', '33000', 'Hrvatska', '+385 (33) 801 777', '+385  (33) 801 771', null, null, '+385 (33) 801 775', 'ured.predsjednika@zsvr.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('5', 'Županijski sud u Dubrovniku', 'Dr. Ante Starčevića 67', null, 'Dubrovnik', '20000', 'Hrvatska', '+385 (20) 357 677', '+385  (20) 448 111', null, null, '+385 (20) 357 699', 'ured.predsjednika@zsdu.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('6', 'Županijski sud u Karlovcu', 'Trg hrvatskih branitelja 1', null, 'Karlovac', '47000', 'Hrvatska', '+385 (47) 606 111', '+385  (47) 606 108', null, null, '+385 (47) 415 301', 'ured.predsjednika@zska.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('7', 'Županijski sud u Karlovcu, Stalna služba u Gospiću', 'Trg Alojzija Stepinca 3', null, 'Gospić', '53000', 'Hrvatska', '+385 (53) 572 856', '+385  (53) 572 038', null, null, '+385 (53) 574 138', 'zupanijski.sud.gospic@gs.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('8', 'Županijski sud u Osijeku', 'Europska avenija 7', null, 'Osijek', '31000', 'Hrvatska', '+385 (31) 228 400', '', null, null, '+385 (31) 211 523', 'zup-sud-osijek@os.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('9', 'Županijski sud u Puli', 'Kranjčevićeva 8', null, 'Pula', '52100', 'Hrvatska', '+385 (52) 377 700', '', null, null, '+385 (52) 211 761', 'ured-predsjednika@zspu.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('10', 'Županijski sud u Rijeci', 'Žrtava fašizma 7', null, 'Rijeka', '51000', 'Hrvatska', '+385 (51) 355 555', '', null, null, '+385 (51) 336 924', 'Ured.predsjednika@zsri.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('11', 'Županijski sud u Sisku', 'Trg Lj. Posavskog 5', '', 'Sisak', '44000', 'Hrvatska', '+385 (44) 522 522', '+385  (44) 811 740', null, null, '+385 (44) 811 755', 'ured.predsjednika@zssk.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '2013-03-23 21:32:55', '1'), ('12', 'Županijski sud u Slavonskom Brodu', 'Tome Skalice 2', null, 'Slavonski Brod', '35000', 'Hrvatska', '+385 (35) 405 100', '', null, null, '+385 (35) 405 110', 'zupanijski-sud@sb.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('13', 'Županijski sud u Slavonskom Brodu, Stalna služba u Požegi', 'Sv. Florijana 2', null, 'Požega', '34000', 'Hrvatska', '+385 (34) 290 400', '+385  (34) 290 444', null, null, '+385 (34) 271 085', 'zsp@po.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('14', 'Županijski sud u Splitu', 'Gundulićeva 29a', null, 'Split', '21000', 'Hrvatska', '+385 (21) 387 500', '+385  (21) 387 704', null, null, '+385 (21) 387 660', 'predsjednik@zsst.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('15', 'Županijski sud u Varaždinu', 'Stjepana Radića 81', null, 'Varaždin', '42000', 'Hrvatska', '+385 (22) 209 140', '', null, null, '+385 (22) 216 644', 'ured.predsjednika@zsvz.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('16', 'Županijski sud u Varaždinu, Stalna služba u Koprivnici', 'Braće Radića 2', null, 'Koprivnica', '48000', 'Hrvatska', '+385 (42) 401 888', '', null, null, '+385 (42) 313 120', 'stalna.sluzba@zskc.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('17', 'Županijski sud u Varždinu, Stalna služba u Čakovcu', 'Ruđera Boškovića 18', null, 'Čakovec', '40000', 'Hrvatska', '+385 (40) 390 664', '+385  (40) 390 662', null, null, '+385 (40) 390 663', 'zupanijski.sud.u.cakovcu@ck.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('18', 'Županijski sud u Velikoj Gorici', 'Hrvatske Državnosti 5', null, 'Velika Gorica', '10410', 'Hrvatska', '+385 (48) 240 430', '', null, null, '+385 (48) 621 765', 'zsvg@zsvg.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('19', 'Županijski sud u Vukovaru', 'Kneza Branimira 1', null, 'Vukovar', '32000', 'Hrvatska', '+385 (1) 6370 200', '', null, null, '+385 (1) 6370 211', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('20', 'Županijski sud u Zadru', 'Županijska 33', null, 'Zadar', '23000', 'Hrvatska', '+385 (32) 452 500', '+385  (32) 452 514', null, null, '+385 (42) 452 513', 'zupanijski-sud@zs-zadar.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('21', 'Županijski sud u Zagrebu', 'Borelli br.9', null, 'Zagreb', '10000', 'Hrvatska', '+385 (23) 203 600', '+385  (23) 203 611', null, null, '+385 (23) 211 280', 'glasnogovornik@zszg.pravosudje.hr ', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('22', 'Županijski sud u Zagrebu, Stalna služba u Zlataru', 'Trg N. Šubića Zrinjskog 5', null, 'Zlatar', '49250', 'Hrvatska', '+385 (1) 4801 111', '', null, null, '+385 (1) 4920 260', 'zupanijski.sud.zlatar@kr.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('23', 'Županijski sud u Šibeniku', 'Trg Slobode 14 a', null, 'Šibenik', '22000', 'Hrvatska', '+385 (49) 426 800', '+385  (49) 426 807', null, null, '+385 (49) 467 499', 'ured.predsjednika@zssi.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('24', 'Visoki upravni sud Republike Hrvatske', 'Frankopanska ulica 16', '', 'Zagreb', '10000', 'Hrvatska', '+385 (1) 4807800', '', '', '', '', '', '', '', '', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '', '0000-00-00 00:00:00', '2013-10-01 21:32:23', '1'), ('25', 'Upravni sud u Osijeku', 'Županijska 5', '', 'Osijek', '31000', 'Hrvatska', '+385 (31) 554 571', '', '', '', '+385 (31) 554 571', '', '', '', '', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '', '0000-00-00 00:00:00', '2014-03-08 17:55:55', '2'), ('26', 'Upravni sud u Rijeci', 'Barčićeva 3', '', 'Rijeka', '51000', 'Hrvatska', '+385 (51) 499600', '', '', '', '+385 (51) 499601', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '', '0000-00-00 00:00:00', '2013-08-20 17:34:50', '1'), ('27', 'Upravni sud u Splitu', 'Put Supavla 1', null, 'Split', '21000', 'Hrvatska', '+385 (21) 440771', '', null, null, '+385 (21) 440760', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('28', 'Upravni sud u Zagrebu', 'Avenija Dubrovnik 6 i 8, Zagreb', null, 'Zagreb', '10000', 'Hrvatska', '+385 (1) 6011320', '', null, null, '+385 (1) 6011300', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('29', 'Visoki trgovački sud Republike Hrvatske', 'Berislavićeva 11', null, 'Zagreb', '10000', 'Hrvatska', '+385 (1) 4896888', '', null, null, '+385 (1) 4872329', 'ured.predsjednika@vts.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('30', 'Trgovački sud u Bjelovaru', 'Šetalište dr. Ivše Lebovića 42', null, 'Bjelovar', '43000', 'Hrvatska', '+385 (1) 244471', '+385 (1) 244408', null, null, '+385 (1) 221574', 'ured.predsjednika@trgsud-bjelovar.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('31', 'Trgovački sud u Osijeku', 'Zagrebačka ulica br.2', null, 'Osijek', '31000', 'Hrvatska', '+385 (31) 207600', '+385 (31) 207606', null, null, '+385 (31) 207600', 'ured.predsjednika@tsos.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('32', 'Trgovački sud u Osijeku, Stalna služba u Slavonskom Brodu', 'Trg pobjede 13', null, 'Slavonski Brod', '35000', 'Hrvatska', '+385 (35) 217400', '+385 (35) 217409', null, null, '+385 (35) 410289', 'trgovacki-sud-sb@sb.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('33', 'Trgovački sud u Rijeci', 'Zadarska 1. i 3., Riva 18', null, 'Rijeka', '51000', 'Hrvatska', '+385 (51) 660200', '+385 (51) 660222', null, null, '+385 (51) 660260', 'tsr@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('34', 'Trgovački sud u Rijeci, Stalna služba u Pazinu', 'Dršćevka 1, p.p. 51', null, 'Pazin', '52000', 'Hrvatska', '+385 (52) 619900', '', null, null, '+385 (52) 619910', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('35', 'Trgovački sud u Splitu', 'Sukoišanska 6', null, 'Split', '21000', 'Hrvatska', '+385 (21) 393999', '+385  (21) 393301', null, null, '+385 (21) 481242', 'trgovacki-sud-st@st.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('36', 'Trgovački sud u Splitu, Stalna služba u Dubrovniku', 'Dr. A. Starčevića 23', null, 'Dubrovnik', '20000', 'Hrvatska', '+385 (20) 358460', '', null, null, '+385 (20) 357737', 'ured.predsjednika@tsdu.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('37', 'Trgovački sud u Varaždinu', 'Braće Radića 2', null, 'Varaždin', '42000', 'Hrvatska', '+385 (42) 401900', '+385  (42) 401950', null, null, '+385 (42) 214743', 'uredpredsjednika@tsvz.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('38', 'Trgovački sud u Zadru', 'Ulica Franje Tuđmana 35', null, 'Zadar', '23000', 'Hrvatska', '+385 (23) 292000', '', null, null, '+385 (23) 292055', 'uprava@tszd.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('39', 'Trgovački sud u Zadru, Stalna služba u Šibeniku', 'Stjepana Radića 81/II', null, 'Šibenik', '22000', 'Hrvatska', '+385 (22) 209333', '', null, null, '+385 (22) 209320', 'trgovacki.sud.u.sibeniku@st.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('40', 'Trgovački sud u Zagrebu', 'Amruševa 2/II', null, 'Zagreb', '10000', 'Hrvatska', '+385 (1) 4897222', '+385  (1) 4897273', null, null, '+385 (1) 4920871', 'tajnistvo@tszg.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('41', 'Trgovački sud u Zagrebu, Stalna služba u Karlovcu', 'Trg hrvatskih branitelja 1', null, 'Karlovac', '47000', 'Hrvatska', '+385 (47) 606149', '', null, null, '+385 (47) 415303', 'trgovacki.sud.karlovac@ka.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('42', 'Trgovački sud u Zagrebu, Stalna služba u Sisku', 'Ferde Hefelea bb', null, 'Sisak', '44000', 'Hrvatska', '+385 (44) 571780', '', null, null, '+385 (44) 571783', 'tsud@tssk.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('43', 'Općinski građanski sud u Zagrebu', 'Ulica grada Vukovara 84', '', 'Zagreb', '10000', 'Hrvatska', '+385 (1) 6126666', '+385 (1) 6114222', '', '', '+385 (1) 6126647', '', '', '', '', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '', '0000-00-00 00:00:00', '2013-08-26 15:54:08', '1'), ('44', 'Općinski kazneni sud u Zagrebu', 'Ilica 207 (Selska)', '', 'Zagreb', '10000', 'Hrvatska', '+385 (1) 3477222', '', '', '', '+385 (1) 3477202', '', '', '', '', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '', '0000-00-00 00:00:00', '2013-08-24 04:34:19', '1'), ('45', 'Općinski radni sud u Zagrebu', 'Ulica grada Vukovara 84', null, 'Zagreb', '10000', 'Hrvatska', '+385 (1) 6126 666', '', null, null, '+385 (1) 6126687', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('46', 'Općinski sud u Belom Manastiru', 'Kralja Tomislava 53', null, 'Beli Manastir', '31300', 'Hrvatska', '+385 (31) 701112', '', null, null, '+385 (31) 703703', 'opcinski.sud.beli.manastir@os.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('47', 'Općinski sud u Benkovcu', 'Stjepana Radića 10', null, 'Benkovac', '23420', 'Hrvatska', '+385 (23) 684900', '', null, null, '+385 (23) 684913', 'opcinski.sud.u.obrovcu@zd.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('48', 'Općinski sud u Benkovcu - Stalna služba u Obrovcu', 'Stjepana Radića 4', null, 'Obrovac', '23450', 'Hrvatska', '+385 (23) 689228', '+385 (23) 689227', null, null, '+385 (23) 689478', 'opcinski.sud.u.obrovcu@zd.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('49', 'Općinski sud u Bjelovaru', 'Josipa Jelačića 3', null, 'Bjelovar', '43000', 'Hrvatska', '+385 (43) 274111', '', null, null, '+385 (43) 274151', 'ured.predsjednika@osbj.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('50', 'Općinski sud u Bujama - Buie', 'Istarska 1', null, 'Buje', '52460', 'Hrvatska', '+385 (52) 725230', '+385 (52) 773604', null, null, '+385 (52) 773012', 'opcinski.sud.buje@email.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('51', 'Općinski sud u Crikvenici', 'Ulica Kralja Tomislava 85a', null, 'Crikvenica', '51260', 'Hrvatska', '+385 (51) 780444', '+385 (51) 78047', null, null, '+385 (51) 241520', 'opcinski.sud.u.crikvenici.uprava@email.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('52', 'Općinski sud u Crikvenici - Stalna služba u Senju', 'Potok 1', null, 'Senj', '53270', 'Hrvatska', '+385 (53) 881031', '+385 (53) 882756', null, null, '+385 (53) 881095', 'IvankaTomljanovic@oscr.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('53', 'Općinski sud u Čakovcu', 'Ruđera Boškovića 18', null, 'Čakovec', '40000', 'Hrvatska', '+385 (40) 390666', '', null, null, '+385 (40) 390686', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('54', 'Općinski sud u Čakovcu - Stalna služba u Prelogu', 'Glavna 29', null, 'Prelog', '40323', 'Hrvatska', '+385 (40) 648300', '', null, null, '+385 (40) 645205', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('55', 'Općinski sud u Daruvaru', 'Stjepana Radića 27', null, 'Daruvar', '43500', 'Hrvatska', '+385 (43) 331141', '+385 (43) 440620', null, null, '+385 (43) 440637', 'opcinski.sud.daruvar@bj.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('56', 'Općinski sud u Daruvaru - Stalna služba u Garešnici', 'Vladimira Nazora 22', null, 'Garešnica', '43280', 'Hrvatska', '+385 (43) 445300', '+385 (43) 531016', null, null, '+385 (43) 445307', 'opcinski.sud.u.garesnici@bj.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('57', 'Općinski sud u Daruvaru - Stalna služba u Grubišnom Polju', 'Kolodvorska 2', null, 'Grubišno Polje', '43290', 'Hrvatska', '+385 (43) 448 300', '', null, null, '+385 (43) 448 307', 'statistika.gpolje@email.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('58', 'Općinski sud u Daruvaru - Stalna služba u Pakracu', 'Trg Pape Ivana Pavla II 12', null, 'Pakrac', '34550', 'Hrvatska', '+385 (34) 511 100', '', null, null, '+385 (34) 511 106', 'opcinski.sud.pakrac@po.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('59', 'Općinski sud u Delnicama', 'Tina Ujevića 1', null, 'Delnice', '51300', 'Hrvatska', '+385 (51) 814 460', '', null, null, '+385 (51) 814 430', 'opcinski.sud.u.delnicama@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('60', 'Općinski sud u Delnicama - ZK odjel u Čabru', 'Narodnog oslobođenja 2', null, 'Čabar', '51306', 'Hrvatska', '+385 (51) 821 122', '', null, null, '+385 (51) 821 045', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('61', 'Općinski sud u Dubrovniku', 'Dr. Ante Starčevića 23', null, 'Dubrovnik', '20000', 'Hrvatska', '+385 (20) 448 100', '', null, null, '+385 (20) 448 100', 'opcinski-sud@du.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('62', 'Općinski sud u Đakovu', 'Trg dr.Franje Tuđmana 2', null, 'Đakovo', '31400', 'Hrvatska', '+385 (31) 840 120', '', null, null, '+385 (31) 840 125', 'opcinski.sud.u.djakovu@os.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('63', 'Općinski sud u Glini', 'Trg Josipa Bana Jelačića 5', null, 'Glina', '44400', 'Hrvatska', '+385 (44) 525 900', '+385 (44) 525 910', null, null, '+385 (44) 882 029', 'opcinski.sud.glina1@sk.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('64', 'Općinski sud u Glini - ZK odjel u Gvozdu', 'Trg Dr.Franje Tuđmana broj bb', null, 'Gvozd', '44410', 'Hrvatska', '+385 (44) 525 920', '+385 (44) 525 921', null, null, '+385 (44) 525 929', 'opcinski.sud.gvozd1@sk.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('65', 'Općinski sud u Gospiću', 'Trg Alojzija Stepinca 3', null, 'Gospić', '53000', 'Hrvatska', '+385 (53) 572 038', '', null, null, '+385 (53) 572 424', 'opcinski.sud@osgs.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('66', 'Općinski sud u Gospiću - ZK odjel u Donjem Lapcu', 'Trg Nikole Tesle 7a', null, 'Donji Lapac', '53250', 'Hrvatska', '+385 (53) 765 357', '', null, null, '+385 (53) 765 357', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('67', 'Općinski sud u Gospiću - ZK odjel u Gračacu', 'Nikole Tesle bb', null, 'Gračac', '23440', 'Hrvatska', '+385 (23) 775 027', '', null, null, '+385 (23) 773 259', 'opcinski-sud-gracac@sl.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('68', 'Općinski sud u Gospiću - ZK odjel u Korenici', 'Trg Svetog Jurja 5', null, 'Korenica', '53230', 'Hrvatska', '+385 (53) 776 637', '+385 (53) 776 634', null, null, '+385 (53) 776 637', 'opcinski.sud.u.korenici@gs.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('69', 'Općinski sud u Gospiću - ZK odjel u Otočcu', 'Bartola Kašića 7', null, 'Otočac', '53220', 'Hrvatska', '+385 (53) 771 036', '+385 (53) 773 132', null, null, '+385 (53) 771 036', 'opcinski.sud.u.otoccu@gs.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('70', 'Općinski sud u Hrvatskoj Kostajnici', 'Vladimira Nazora br. 10', null, 'Hrvatska Kostajnica', '44430', 'Hrvatska', '+385 (44) 527 960', '', null, null, '+385 (44) 527 980', 'popcsud-hk@sk.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('71', 'Općinski sud u Hrvatskoj Kostajnici - ZK odjel u Dvoru', 'Trg Bana J.Jelačića 14', null, 'Dvor', '44440', 'Hrvatska', '+385 (44) 525 080', '', null, null, '+385 (44) 525 091', 'opcinski.sud.u.dvoru@sk.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('72', 'Općinski sud u Imotskom', 'Ante Starčevića 23', null, 'Imotski', '21260', 'Hrvatska', '+385 (21) 671 140', '', null, null, '+385 (21) 841 803', 'opcinski.sud.imotski@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('73', 'Općinski sud u Ivanić-Gradu', 'Športska 2', null, 'Ivanić Grad', '10310', 'Hrvatska', '+385 (1) 2831 444', '', null, null, '+385 (1) 2831 455', 'opcinski.sud.u.ivanic.gradu@zg.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('74', 'Općinski sud u Ivanić-Gradu - Stalna služba u Čazmi', 'Trg Čazmanskog kaptola 20', null, 'Čazma', '43240', 'Hrvatska', '+385 (43) 771 011', '+385 (43) 771 026', null, null, '+385 (43) 711 011', 'opcinski.sud.u.cazmi2@bj.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('75', 'Općinski sud u Jastrebarskom', 'Braće Kazić 6', null, 'Jastrebarsko', '10450', 'Hrvatska', '+385 (1) 6274 111', '+385 (1) 6274 100', null, null, '+385 (1) 6274 127', 'opcinski-sud-jaska@zg.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('76', 'Općinski sud u Karlovcu', 'Trg hrvatskih branitelja 1', null, 'Karlovac', '47000', 'Hrvatska', '+385 (47) 606 111', '', null, null, '+385 (47) 415 310', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('77', 'Općinski sud u Karlovcu - ZK odjel u Dugoj Resi', '', null, 'Duga Resa', '47250', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('78', 'Općinski sud u Karlovcu - ZK odjel u Ozlju', 'Zrinskih i Frankopana 15', null, 'Ozalj', '47280', 'Hrvatska', '+385 (47) 731 163', '+385 (47) 732 007', null, null, '+385 (47) 732 007', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('79', 'Općinski sud u Karlovcu - ZK odjel u Slunju', 'Trg dr. Franje Tuđmana br. 14', null, 'Slunj', '47240', 'Hrvatska', '+385 (47) 819 232', '+385 (47) 819 233', null, null, '+385 (47) 777 170', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('80', 'Općinski sud u Karlovcu - ZK odjel u Vojniću', 'Trg Stjepana Radića bb', null, 'Vojnić', '47220', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('81', 'Općinski sud u Kninu', 'Dr. Franje Tuđmana 6', null, 'Knin', '22300', 'Hrvatska', '+385 (22) 431 300', '', null, null, '+385 (22) 431 333', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('82', 'Općinski sud u Koprivnici', 'Hrvatske državnosti 5', null, 'Koprivnica', '48000', 'Hrvatska', '+385 (48) 240 360', '', null, null, '+385 (48) 622 006', 'ured.predsjednika@oskc.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('83', 'Općinski sud u Koprivnici - Stalna služba u Đurđevcu', 'Đure Basaričeka 12', null, 'Đurđevac', '48350', 'Hrvatska', '+385 (48) 289 000', '', null, null, '+385 (48) 811 727', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('84', 'Općinski sud u Korčuli', 'Put Sv. Nikole bb', null, 'Korčula', '20260', 'Hrvatska', '+385 (20) 711 127', '', null, null, '+385 (20) 715 430', 'opcinski.sud@du.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('85', 'Općinski sud u Krapini', 'Trg dr. Mirka Dražena Grmeka 1', null, 'Krapina', '49000', 'Hrvatska', '+385 (49) 371624', '+385 (49) 371609', null, null, '+385 (49) 371037', 'ured.predsjednika@oskr.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('86', 'Općinski sud u Krapini - ZK odjel u Pregradi', 'Kostelgradska 1', null, 'Pregrada', '49218', 'Hrvatska', '+385 (49) 376 020', '', null, null, '+385 (49) 376 020', 'o.sud.pregrada@kr.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('87', 'Općinski sud u Križevcima', 'Ivana Zakmardija Dijankovečkog 1', null, 'Križevci', '48260', 'Hrvatska', '+385 (48) 279 220', '', null, null, '+385 (48) 279 243', 'oskz@hi.hinet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('88', 'Općinski sud u Krku', 'Bodulska BB', null, 'Krk', '51500', 'Hrvatska', '+385 (51) 222 905', '+385 (51) 222 915', null, null, '+385 (51) 221 123', 'opcinski.sud.krk@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('89', 'Općinski sud u Kutini', 'Hrvatskih branitelja 1', null, 'Kutina', '44320', 'Hrvatska', '+385 (44) 691 200', '', null, null, '+385 (44) 680 996', 'opcsudkt@yahoo.com', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('90', 'Općinski sud u Kutini - Stalna služba u Novskoj', 'Trg Dr.Franje Tuđmana 1', null, 'Novska', '44330', 'Hrvatska', '+385 (44) 691 250', '', null, null, '+385 (44) 691 251', 'opcinski.sud.novska1@sk.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('91', 'Općinski sud u Labinu', 'Giussepina Martinuzzi 2', null, 'Labin', '52220', 'Hrvatska', '+385 (52) 887 100', '', null, null, '+385 (52) 887 115', 'opcinski-sud-labin@pu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('92', 'Općinski sud u Makarskoj', 'Kralja Petra Krešimira IV broj 2', null, 'Makarska', '21300', 'Hrvatska', '+385 (21) 695 340', '', null, null, '+385 (21) 695 358', 'opcinski-sud-u.makarskoj@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('93', 'Općinski sud u Malom Lošinju', 'Riva Lošinjskih Kapetana 14', null, 'Mali Lošinj', '51550', 'Hrvatska', '+385 (51) 661 000', '', null, null, '+385 (51) 661 040', 'Opcinski.sud.u.malom.losinju@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('94', 'Općinski sud u Metkoviću', 'Don. Radovana Jerkovića 1', null, 'Metković', '20350', 'Hrvatska', '+385 (20) 684 900', '+385 (20) 684 917', null, null, '+385 (20) 681 940', 'ruzica.glavinic@osme.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('95', 'Općinski sud u Metkoviću - Stalna služba u Pločama', 'Vladimira Nazora 14', null, 'Ploče', '20340', 'Hrvatska', '+385 (20) 679 226', '+385 (20) 670 175', null, null, '+385 (20) 676 535', 'ruzica.glavinic@osme.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('96', 'Općinski sud u Našicama', 'Pejačevićev trg 14', null, 'Našice', '31500', 'Hrvatska', '+385 (31) 618 220', '+385 (31) 618 229', null, null, '+385 (31) 614 483', 'opcinski-sud-nasice@os.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('97', 'Općinski sud u Novoj Gradiški', 'Trg Kralja Tomislava 6', null, 'Nova Gradiška', '35400', 'Hrvatska', '+385 (35) 331 150', '', null, null, '+385 (35) 331 154', 'opcinski.sud.ng@sb.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('98', 'Općinski sud u Novom Zagrebu', 'u osnivanju', null, 'Novi Zagreb', '10020', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('99', 'Općinski sud u Ogulinu', 'Ulica Bernardina Frankopana 1', null, 'Ogulin', '47300', 'Hrvatska', '+385 (47) 819 140', '', null, null, '+385 (47) 522 059', 'ured.predsjednika@osog.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('100', 'Općinski sud u Ogulinu - ZK odjel u Vrbovskom', 'I.G. Kovačića 20 a', null, 'Vrbovsko', '51326', 'Hrvatska', '+385 (51) 875 251', '+385 (51) 875 439', null, null, '+385 (51) 875 251', 'opcinski-sud-vrbovsko@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('101', 'Općinski sud u Opatiji', 'Maršala Tita 4', null, 'Opatija', '51410', 'Hrvatska', '+385 (51) 741 040', '', null, null, '+385 (51) 701 263', 'ured.predsjednika@osop.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('102', 'Općinski sud u Osijeku', 'Europske avenije 7', null, 'Osijek', '31000', 'Hrvatska', '+385 (31) 228 400', '', null, null, '+385 (31) 202 419', 'ured.predsjednika@osos.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1');
347INSERT INTO `contacts` VALUES ('103', 'Općinski sud u Pagu', 'Mandrač 3', null, 'Pag', '23250', 'Hrvatska', '+385 (23) 600 880', '', null, null, '+385 (23) 600 888', 'opcinski.sud.u.pagu@zd.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('104', 'Općinski sud u Pagu - ZK odjel u Novalji', '', null, 'Novalja', '53291', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('105', 'Općinski sud u Pazinu', 'Franjevačke stube 2', null, 'Pazin', '52000', 'Hrvatska', '+385 (52) 619 100', '+385 (52) 625 030', null, null, '+385 (52) 619 107', 'opcinski-sud-pazin@pu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('106', 'Općinski sud u Pazinu - Stalna služba u Buzetu', 'Titov trg br.1', null, 'Buzet', '52420', 'Hrvatska', '+385 (52) 662 808', '', null, null, '+385 (52) 662 932', 'Sud-buzet-pisarnica@pu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('107', 'Općinski sud u Poreču - Parenzo', 'Turistička 2', null, 'Poreč', '52440', 'Hrvatska', '+385 (52) 429 200', '', null, null, '+385 (52) 451 330', 'opcinski-sud-porec@pu.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('108', 'Općinski sud u Požegi', 'Sv. Florijana 2', null, 'Požega', '34000', 'Hrvatska', '+385 (34) 290 500', '', null, null, '+385 (34) 290 516', 'ured.predsjednika@ospz.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('109', 'Općinski sud u Puli - Pola', 'Kranjčevićeva 8', null, 'Pula', '52100', 'Hrvatska', '+385 (52) 377 600', '+385 (52) 377 700', null, null, '+385 (52) 210 237', 'predsjednistvo@ospu.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('110', 'Općinski sud u Rabu', 'Bobotine 1', null, 'Rab', '51280', 'Hrvatska', '+385 (51) 724 061', '+385 (51) 724 561', null, null, '+385 (51) 724 561', 'sudrab@gmail.com', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('111', 'Općinski sud u Rijeci', 'Žrtava fašizma 7', null, 'Rijeka', '51000', 'Hrvatska', '+385 (51) 355 555', '', null, null, '+385 (51) 213 110', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('112', 'Općinski sud u Rovinju - Rovigno', 'Obala Pino Budicin 4', null, 'Rovinj', '52210', 'Hrvatska', '+385 (52) 813 374', '+385 (52) 813 522', null, null, '+385 (52) 811 030', 'opcinski-sud.rovinj@pu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('113', 'Općinski sud u Samoboru', 'Obrtnička 2', null, 'Samobor', '10430', 'Hrvatska', '+385 (1) 3335 050', '+385 (1) 3335 051', null, null, '+385 (1) 3335 055', 'sudskaupravasamobor@email.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('114', 'Općinski sud u Sesvetama', 'Zagrebačka 22', null, 'Sesvete', '10360', 'Hrvatska', '+385 (1) 2040 244', '+385 (1) 2040 233', null, null, '+385 (1) 2006 977', 'opcinski.sud.sesvete@hi.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('115', 'Općinski sud u Sesvetama - Stalna služba u Dugom Selu', 'Zagrebačka 22', null, 'Dugo Selo', '10370', 'Hrvatska', '+385 (1) 2781 230', '+385 (1) 2781 245', null, null, '+385 (1) 2753 439', 'os-dugo-selo@zg.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('116', 'Općinski sud u Sesvetama - Stalna služba u Svetom Ivanu Zelini', 'Vatrogasna 1', null, 'Sveti Ivan Zelina', '10380', 'Hrvatska', '+385 (1) 2040 777 ', '', null, null, '+385 (1) 2060 822', 'os-sv-ivan-zelina@zg.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('117', 'Općinski sud u Sinju', 'Petrovac 3', null, 'Sinj', '21230', 'Hrvatska', '+385 (21) 707 200', '', null, null, '+385 (21) 707 249', 'opcinski.sud.u.sinju1@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('118', 'Općinski sud u Sisku', 'Trg Ljudevita Posavskog 5, PP 46', null, 'Sisak', '44000', 'Hrvatska', '+385 (44) 525 700 ', '', null, null, '+385 (44) 522 923', 'ured.predsjednika@ossk.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('119', 'Općinski sud u Sisku - ZK odjel u Petrinji', 'Trg dr. Franje Tuđmana broj 12', null, 'Petrinja', '44250', 'Hrvatska', '+385 (44) 525 800', '+385 (44) 525 801', null, null, '+385 (44) 525 811', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('120', 'Općinski sud u Slatini', 'Trg Sv. Josipa 12', null, 'Slatina', '33520', 'Hrvatska', '+385 (33) 400 520', '', null, null, '+385 (33) 555 493', 'opcinski-sud-slatina@vt.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('121', 'Općinski sud u Slatini - Stalna služba u Orahovici', 'Trg pl. Mihalovića 3', null, 'Orahovica', '33515', 'Hrvatska', '+385 (33) 673 224', '+385 (33) 673 442', null, null, '+385 (33) 673 634', 'opcinski.sud.u.orahovici@vt.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('122', 'Općinski sud u Slavonskom Brodu', 'Trg pobjede 13', null, 'Slavonski Brod', '35000', 'Hrvatska', '+385 (35) 217 400', '', null, null, '+385 (35) 217 296', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('123', 'Općinski sud u Splitu', 'Ex vojarna Sv. Križ', null, 'Split', '21000', 'Hrvatska', '+385 (21) 755 700', '+385 (21) 755 706', null, null, '+385 (21) 755 762', 'opcinski.sud.u.splitu@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('124', 'Općinski sud u Splitu - Stalna služba u Kaštel Lukšiću', 'Obala kralja Tomislava 2', null, 'Kaštel Lukšić', '21215', 'Hrvatska', '+385 (21) 228 115', '', null, null, '+385 (21) 228 304', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('125', 'Općinski sud u Splitu - Stalna služba u Omišu', 'Trg kralja Tomislava 5', null, 'Omiš', '21310', 'Hrvatska', '+385 (21) 755 150', '+385 (21) 863 243', null, null, '+385 (21) 757 607', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('126', 'Općinski sud u Splitu - Stalna služba u Solinu', 'Kralja Zvonimira 75', null, 'Solin', '21210', 'Hrvatska', '+385 (21) 246 380', '+385 (21) 246 387', null, null, '+385 (21) 246 388', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('127', 'Općinski sud u Splitu - ZK odjel u Visu', '', null, 'Vis', '21480', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('128', 'Općinski sud u Starom Gradu', 'Nova riva 3', null, 'Stari Grad', '21460', 'Hrvatska', '+385 (21) 778 280', '', null, null, '+385 (21) 778 282', 'opcinski.sud.u.starom.gradu1@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('129', 'Općinski sud u Supetru', 'Hrvatskih Velikana 6', null, 'Supetar', '21400', 'Hrvatska', '+385 (21) 640 900', '', null, null, '+385 (21) 640 937', 'oss@oss.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('130', 'Općinski sud u Šibeniku', 'Stjepana Radića 81', null, 'Šibenik', '22000', 'Hrvatska', '+385 (22) 209 124', '+385 (22) 209 102', null, null, '+385 (22) 212 894', 'tajnik.suda@ossi.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('131', 'Općinski sud u Šibeniku - Stalna služba u Tisnom', 'Uska ulica 1', null, 'Tisno', '22240', 'Hrvatska', '+385 (22) 439 780', '', null, null, '+385 (22) 439 780', 'opcinski-sud-tisno@si.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('132', 'Općinski sud u Trogiru', 'Obala Bana Berislavića 1', null, 'Trogir', '21220', 'Hrvatska', '+385 (21) 798 340', '+385 (21) 798 341', null, null, '+385 (21) 798 350', 'ured.predsjednika@ostr.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('133', 'Općinski sud u Valpovu', 'Kralja Petra Krešimira IV br.3', null, 'Valpovo', '31550', 'Hrvatska', '+385 (31) 656 100', '+385 (31) 656 101', null, null, '+385 (31) 656 105', 'opcinski.sud.u.valpovu5@os.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('134', 'Općinski sud u Valpovu - Stalna služba u Donjem Miholjcu', 'Trg Ante Starčevića 25', null, 'Donji Miholjac', '31540', 'Hrvatska', '+385 (31) 634 010', '+385 (31) 631 434', null, null, '+385 (31) 634 020', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('135', 'Općinski sud u Varaždinu', 'Braće Radić 2', null, 'Varaždin', '42000', 'Hrvatska', '+385 (42) 401 888', '', null, null, '+385 (42) 312 563', 'ured.predsjednika@osvz.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('136', 'Općinski sud u Varaždinu - Stalna služba u Ivancu', 'Akademika Mirka Maleza 3', null, 'Ivanec', '42240', 'Hrvatska', '+385 (42) 770 720', '+385 (42) 770 723', null, null, '+385 (42) 782 111', 'ana.habek@osvz.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('137', 'Općinski sud u Varaždinu - ZK odjel u Ludbregu', 'I.Gundulića 3', null, 'Ludbreg', '42230', 'Hrvatska', '+385 (42) 810 322', '+385 (42) 810 333', null, null, '+385 (42) 810 220', 'opcinski.sud.ludgbreg@vz.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('138', 'Općinski sud u Varaždinu - ZK odjel u Novom Marofu', 'Zagorska 22', null, 'Novi Marof', '42220', 'Hrvatska', '+385 (42) 611 206', '+385 (42) 611 146', null, null, '+385 (42) 611 146', 'opcinski.sud.novimarof@vz.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('139', 'Općinski sud u Velikoj Gorici', 'Trg Kralja Tomislava 36', null, 'Velika Gorica', '10410', 'Hrvatska', '+385 (1) 6269 500', '', null, null, '+385 (1) 6269 595', 'opcinski.sud.u.velikoj.gorici@zg.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('140', 'Općinski sud u Vinkovcima', 'Trg bana Josipa Šokčevića 7', null, 'Vinkovci', '32100', 'Hrvatska', '+385 (32) 341 111', '+385 (32) 341 153', null, null, '+385 (32) 332 318', 'opcinski.sud.vinkovci@vu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('141', 'Općinski sud u Virovitici', 'Tomaša Masaryka 8', null, 'Virovitica', '33000', 'Hrvatska', '+385 (33) 840 900', '', null, null, '+385 (33) 840 930', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('142', 'Općinski sud u Virovitici - Stalna služba u Pitomači', 'Trg kralja Tomislava 18', null, 'Pitomača', '33405', 'Hrvatska', '+385 (33) 783 343', '', null, null, '+385 (33) 800 126', 'Opcinski.sud.pitomaca@vt.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('143', 'Općinski sud u Vrbovcu', 'Trg Petra Zrinskog 22', null, 'Vrbovec', '10340', 'Hrvatska', '+385 (1) 2791 128', '+385 (1) 2791 148', null, null, '+385 (1) 2791 422', 'opcinski.sud.u.vrbovcu@zg.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('144', 'Općinski sud u Vukovaru', 'Županijska 31', null, 'Vukovar', '32000', 'Hrvatska', '+385 (32) 451 600', '+385 (32) 451 602', null, null, '+385 (32) 451 645', 'ured.predsjednika@osvu.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('145', 'Općinski sud u Zaboku', 'Matije Gupca 22', null, 'Zabok', '49210', 'Hrvatska', '+385 (49) 221 468', '+385 (49) 226 580', null, null, '+385 (49) 221 436', 'os.zabok@gmail.com', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('146', 'Općinski sud u Zaboku - Stalna služba u Klanjcu', 'Trg mira 1', null, 'Klanjec', '49290', 'Hrvatska', '+385 (49) 588 150', '+385 (49) 588 157', null, null, '+385 (49) 588 166', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('147', 'Općinski sud u Zadru', 'Borelli br.9', null, 'Zadar', '23000', 'Hrvatska', '+385 (23) 309 942', '', null, null, '+385 (23) 213 196', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('148', 'Općinski sud u Zadru - Stalna služba u Biogradu na moru', 'Kneza Domagoja 1', null, 'Biograd na Moru', '23210', 'Hrvatska', '+385 (23) 383 400', '+385 (23) 384 072', null, null, '+385 (23) 383 420', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('149', 'Općinski sud u Zaprešiću', 'Trg žrtava fašizma 1', null, 'Zaprešić', '10290', 'Hrvatska', '+385 (1) 3350 555', '+385 (1) 3350 50', null, null, '+385 (1) 3350 546', 'opcinski.sud.u.zapresicu@zg.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('150', 'Općinski sud u Zlataru', 'Trg slobode 14a', null, 'Zlatar', '49250', 'Hrvatska', '+385 (49) 426 857', '+385 (49) 426 850', null, null, '+385 (49) 466 827', 'ured.predsjednika@oszl.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('151', 'Općinski sud u Županji', 'Veliki kraj 48', null, 'Županja', '32270', 'Hrvatska', '+385 (32) 830 530', '', null, null, '+385 (32) 830 555', 'ljiljana.galic@oszu.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('152', 'Visoki prekršajni sud RH', 'Ulica Augusta Šenoe 30', null, 'Zagreb', '10000', 'Hrvatska', '+385 (1) 4611292', '+385 (1) 4807510', null, null, '+385 (1) 4611 291', 'predsjednik@vpsrh.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('153', 'Prekršajni sud u Belom Manastiru', 'Svetog Martina 3', null, 'Beli Manastir', '31300', 'Hrvatska', '+385 (31) 701 522', '', null, null, '+385 (31) 700 514', 'predsjednik@psbm.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('154', 'Prekršajni sud u Bjelovaru', 'Ferde Rusana 10', null, 'Bjelovar', '43000', 'Hrvatska', '+385 (43) 247 340', '+385 (43) 247 346', null, null, '+385 (43) 247 357', 'psbj@psbj.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('155', 'Prekršajni sud u Blatu', 'Trg dr. Franje Tuđmana 1', null, 'Blato', '20225', 'Hrvatska', '+385 (20) 851 923', '', null, null, '+385 (20) 852 603', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('156', 'Prekršajni sud u Crikvenici', 'Ulica kralja Tomislava 114', null, 'Crikvenica', '51260', 'Hrvatska', '+385 (51) 241 282', '+385 (51) 784 766', null, null, '+385 (51) 784 766', 'prekrsajni-sud-crikvenica@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('157', 'Prekršajni sud u Čakovcu', 'Zrinsko-Frankopanska 9', null, 'Čakovec', '40000', 'Hrvatska', '+385 (40) 370 820', '', null, null, '+385 (40) 390 673', 'predsjednistvo@psck.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('158', 'Prekršajni sud u Daruvaru', 'Preradovićeva 9/1', null, 'Daruvar', '43500', 'Hrvatska', '+385 (43) 675 780', '+385 (43) 675 783', null, null, '+385 (43) 675 787', 'prekrsajni-sud-daruvar@bj.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('159', 'Prekršajni sud u Daruvaru - Stalna služba u Garešnici', 'Andrije Lustiga Dade 22', null, 'Garešnica', '43280', 'Hrvatska', '+385 (43) 531 528', '', null, null, '+385 (43) 445 363', 'prekrsajni.sud.u.garesnici@bj.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('160', 'Prekršajni sud u Daruvaru - Stalna služba u Grubišnom Polju', 'Trg bana Jelačića 1', null, 'Grubišno Polje', '43290', 'Hrvatska', '+385 (43) 485 222', '', null, null, '', 'prekrsajni-sud-u-g.polju@bj.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('161', 'Prekršajni sud u Daruvaru - Stalna služba u Pakracu', 'Trg Pape Ivana Pavla II kbr. 12', null, 'Pakrac', '34550', 'Hrvatska', '+385 (34) 511 130', '', null, null, '+385 (34) 511 130', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('162', 'Prekršajni sud u Delnicama', 'Supilova 43', null, 'Delnice', '51300', 'Hrvatska', '+385 (51) 812 514', '', null, null, '+385 (51) 812 514', 'prekrsajni.sud.u.delnicama@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('163', 'Prekršajni sud u Dubrovniku ', 'Dr. Ante Starčevića 23', null, 'Dubrovnik', '20000', 'Hrvatska', '+385 (20) 357 888', '+385 (20) 448 177', null, null, '+385 (20) 358 525', 'mirjana.lujak@psdu.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('164', 'Prekršajni sud u Đakovu', 'Vijenac kardinala Alojzija Stepi', null, 'Đakovo', '31400', 'Hrvatska', '+385 (31) 811 055', '+385 (31) 811 381', null, null, '+385 (31) 811 055', 'prekrsajni.sud.djakovo@os.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('165', 'Prekršajni sud u Gospiću', 'Trg Alojzija Stepinca 3', null, 'Gospić', '53000', 'Hrvatska', '+385 (53) 573 038', '+385 (53) 573 386', null, null, '+385 (53) 573 038', 'prekrsajni.sud.gospic@gs.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('166', 'Prekršajni sud u Gospiću - Stalna služba u Gračacu', 'Mile Budaka bb', null, 'Gračac', '23440', 'Hrvatska', '+385 (23) 773 057', '', null, null, '+385 (23) 773 057', 'prekrsajni-sud-gracac@zd.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('167', 'Prekršajni sud u Gospiću - Stalna služba u Korenici', 'Trg Svetog Jurja bb', null, 'Plitvička Jezera ', '53231', 'Hrvatska', '+385 (53) 776 771', '', null, null, '+385 (53) 776 771', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('168', 'Prekršajni sud u Gospiću - Stalna služba u Otočcu', 'Trg dr. Franje Tuđmana 5', null, 'Otočac', '53220', 'Hrvatska', '+385 (53) 746 021', '+385 (53) 746 018', null, null, '+385 (53) 746 021', 'prekrsajni.sud.otocac@gs.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('169', 'Prekršajni sud u Imotskom', 'Šetalište S. Radića 14', null, 'Imotski', '21260', 'Hrvatska', '+385 (21) 841 052', '+385 (21) 841 352', null, null, '+385 (21) 841 351', 'prekrsajni.sud.imotski1@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('170', 'Prekršajni sud u Ivanić Gradu', 'Moslavačka 13', null, 'Ivanić Grad', '10310', 'Hrvatska', '+385 (1) 2883 388', '+385 (1) 2881 674', null, null, '+385 (1) 2827 200', 'prekrsajni.sud.ivanic.grad@zg.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('171', 'Prekršajni sud u Ivanić Gradu - Stalna služba u Čazmi', 'Ul. Milana Novačića 13', null, 'Čazma', '43240', 'Hrvatska', '+385 (43) 771 430 ', '', null, null, '+385 (43) 771 430 ', 'prekrsajni.sud.u.cazmi@bj.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('172', 'Prekršajni sud u Karlovcu', 'Trg hrvatskih branitelja 1', null, 'Karlovac', '47000', 'Hrvatska', '+385 (47) 606 137', '+385 (47) 606 133', null, null, '+385 (47) 415 316', 'ured.predsjednika@pska.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('173', 'Prekršajni sud u Karlovcu - Stalna služba u Dugoj Resi', 'Trg Sv. Jurja 1', null, 'Duga Resa', '47250', 'Hrvatska', '+385 (47) 844 581', '', null, null, '+385 (47) 844 250', 'preksuddr@volja.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('174', 'Prekršajni sud u Karlovcu - Stalna služba u Jastrebarskom', 'Dr. Franje Tuđmana 47', null, 'Jastrebarsko', '10450', 'Hrvatska', '+385 (1) 6281 125 ', '', null, null, '+385 (1) 6281 125', 'prekrsajni.sud.u.jastrebarskom@zg.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('175', 'Prekršajni sud u Karlovcu - Stalna služba u Ogulinu', 'Bernandina Frankopana 11a', null, 'Ogulin', '47300', 'Hrvatska', '+385 (47) 522 577', '+385 (47) 537 470', null, null, '+385 (47) 522 577', 'prekrsajni.sud.ogulin@ka.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('176', 'Prekršajni sud u Karlovcu - Stalna služba u Slunju', 'Trg dr. F. Tuđmana 14', null, 'Slunj', '47240', 'Hrvatska', '+385 (47) 777321', '+385 (47) 77759', null, null, '+385 (47) 777 321', 'prekrsajni.sud-slunj@ka.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('177', 'Prekršajni sud u Kninu', 'Dr. Franje Tuđmana 6', null, 'Knin', '22300', 'Hrvatska', '+385 (22)  431 351', '+385 (22) 431 352', null, null, '+385 (22) 431 365', 'prekrsajni.sud.knin@si.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('178', 'Prekršajni sud u Koprivnici', 'Zrinski trg 1', null, 'Koprivnica', '48000', 'Hrvatska', '+385 (48) 622 104', '+385 (48) 210 430', null, null, '+385 (48) 622 104', 'pskc@pskc.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('179', 'Prekršajni sud u Koprivnici - Stalna služba u Đurđevcu', 'Trg Sv. Jurja 5', null, 'Đurđevac', '48350', 'Hrvatska', '+385 (48) 812 003', '+385 (48) 811 956', null, null, '+385 (48) 280011', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('180', 'Prekršajni sud u Korčuli', 'Šetalište Frana Kršinića 50', null, 'Korčula', '20260', 'Hrvatska', '+385 (20) 711 521 ', '', null, null, '+385 (20) 711 521 ', 'prekrsajni.sud.u.korculi@du.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('181', 'Prekršajni sud u Krapini', 'Dr. Mirka Dražena Grmeka 2', null, 'Krapina', '49000', 'Hrvatska', '+385 (49) 371 367', '', null, null, '+385 (49) 371 367', 'prekrsajni.sud.krapina@kr.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('182', 'Prekršajni sud u Krapini - Stalna služba u Pregradi', 'Pod Lenartom 1', null, 'Pregrada', '49218', 'Hrvatska', '+385 (49) 376 136', '+385 (49) 376 035', null, null, '+385 (49) 376 136', 'prekrsajni.sud.u.pregradi@kr.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('183', 'Prekršajni sud u Križevcima', 'Ivana Z. Dijankovečkog 18', null, 'Križevci', '48260', 'Hrvatska', '+385 (48) 681 439', '+385 (48) 681 458', null, null, '+385 (48) 711 198', 'prekrsajni.sud1@kc.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('184', 'Prekršajni sud u Krku', 'Trg bana Josipa Jelačića 5', null, 'Krk', '51500', 'Hrvatska', '+385 (51) 221 360', '+385 (51) 220 167', null, null, '+385 (51) 880 403', 'prekrsajni.sud.u.krku@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('185', 'Prekršajni sud u Kutini', 'Antuna Gustava Matoša 40', null, 'Kutina', '44320', 'Hrvatska', '+385 (44) 691 810', '+385 (44) 691 820', null, null, '+385 (44) 691 811', 'prekrsajni.sud.kutina@sk.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('186', 'Prekršajni sud u Kutini - Stalna služba u Novskoj', 'Staroselska 1', null, 'Novska', '44330', 'Hrvatska', '+385 (44) 608 845', '+385 (44) 608 846', null, null, '+385 (44) 600 239', 'prekrsajni.sud.u.novskoj@prekrsajni-sud.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('187', 'Prekršajni sud u Lastovu', 'Dolac 3', null, 'Lastovo', '20290', 'Hrvatska', '+385 (20) 801 232', '', null, null, '+385 (20) 801 232', 'prekrsajni.sud.u.lastovu@du.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('188', 'Prekršajni sud u Makarskoj', 'Kralja Petra Krešimira IV 2', null, 'Makarska', '21300', 'Hrvatska', '+385 (21) 695 534', '+385 (21) 695536 ', null, null, '+385 (21) 695536 ', 'psma@psma.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('189', 'Prekršajni sud u Malom Lošinju', 'Riva lošinjskih kapetana 14', null, 'Mali Lošinj', '51550', 'Hrvatska', '+385 (51) 661 050', '+385 (51) 661 052', null, null, '+385 (51) 661 057', 'psml@psml.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('190', 'Prekršajni sud u Metkoviću', 'ul. Ivana Gundulića 15', null, 'Metković', '20350', 'Hrvatska', '+385 (20) 681 087', '+385 (20) 681 172', null, null, '+385 (21) 690 047', 'prekrsajni.sud1@du.t-com.hr ', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('191', 'Prekršajni sud u Metkoviću - Stalna služba u Pločama', 'Vladimira Nazora 14', null, 'Ploče', '20340', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('192', 'Prekršajni sud u Metkoviću - Stalna služba u Vrgorcu', 'Tina Ujevića bb', null, 'Vrgorac', '21276', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('193', 'Prekršajni sud u Našicama', 'Vinogradska 6', null, 'Našice', '31500', 'Hrvatska', '+385 (31) 614 588', '', null, null, '+385 (31) 614 588', 'prekr.sud.nasice@hi.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('194', 'Prekršajni sud u Novalji', '', null, 'Novalja', '53291', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('195', 'Prekršajni sud u Novoj Gradiški', 'Ulica Slavonskih Graničara 15', null, 'Nova Gradiška', '35400', 'Hrvatska', '+385 (35) 362 516', '+385 (35) 365 442', null, null, '+385 (35) 362 516', 'prekrsajni.sud.nova.gradiska@sb.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('196', 'Prekršajni sud u Novom Zagrebu', '', null, 'Novi Zagreb', '10020', 'Hrvatska', '', '', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('197', 'Prekršajni sud u Opatiji', 'Maršala Tita 4/II', null, 'Opatija', '51410', 'Hrvatska', '+385 (51) 701 265', '+385 (51) 701 463', null, null, '+385 (51) 701 265', 'psop@psop.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('198', 'Prekršajni sud u Osijeku', 'Kralja Zvonimira 3', null, 'Osijek', '31000', 'Hrvatska', '+385 (31) 250 700', '', null, null, '+385 (31) 205 209', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('199', 'Prekršajni sud u Pagu', 'Splitska bb', null, 'Pag', '23250', 'Hrvatska', '+385 (23) 611 257', '', null, null, '+385 (23) 612 708', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('200', 'Prekršajni sud u Pazinu', 'Narodnog doma 1', '', 'Pazin', '52000', 'Hrvatska', '+385 (52) 624 452', '+385 (52) 624 722', '', '', '+385 (52) 624 452', 'prekrsajni.sud.u.pazinu1@pu.t-com.hr', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '', '0000-00-00 00:00:00', '2013-08-08 07:56:34', '1'), ('201', 'Prekršajni sud u Pazinu - Stalna služba u Buzetu', 'Titov trg 1', null, 'Buzet', '52420', 'Hrvatska', '+385 (52) 662 808', '', null, null, '+385 (52) 662 932', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('202', 'Prekršajni sud u Pazinu - Stalna služba u Labinu', 'Zelenice bb', null, 'Labin', '52220', 'Hrvatska', '+385 (52) 625 280', '', null, null, '+385 (52) 625 290', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1');
348INSERT INTO `contacts` VALUES ('203', 'Prekršajni sud u Poreču - Parenzo', 'Nikole Tesle 16', null, 'Poreč', '52440', 'Hrvatska', '+385 (52) 887 180', '', null, null, '+385 (52) 434 044', 'prekrsajni.sud.porec@pu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('204', 'Prekršajni sud u Požegi', 'Matije Gupca 6', null, 'Požega', '34000', 'Hrvatska', '+385 (34) 273 313', '+385 (34) 272 843', null, null, '+385 (34) 272 843', 'prekrsajni-sud-u-pozegi@po.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('205', 'Prekršajni sud u Puli - Pola', 'Sv. Teodora broj 2', null, 'Pula', '52100', 'Hrvatska', '+385 (52) 591 340', '', null, null, '+385 (52) 591 341', 'prekrsajni.sud.u.puli@pu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('206', 'Prekršajni sud u Rabu', 'Biskupska Draga 2/1', null, 'Rab', '51280', 'Hrvatska', '+385 (51) 724 641', '', null, null, '+385 (51) 724 641', 'prekrsajni.sud.rab@ri.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('207', 'Prekršajni sud u Rijeci', 'Užarska 3', null, 'Rijeka', '51000', 'Hrvatska', '+385 (51) 358 100', '+385 (51) 330 699', null, null, '+385 (51) 315 858', 'ured@psri.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('208', 'Prekršajni sud u Rovinju - Rovigno', 'Istarska bb', null, 'Rovinj', '52210', 'Hrvatska', '+385 (52) 811 344', '+385 (51) 811 069', null, null, '+385 (52) 811 344', 'prekrsajni.sud.u.rovinju@pu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('209', 'Prekršajni sud u Samoboru', 'Milana Langa 41', null, 'Samobor', '10430', 'Hrvatska', '+385 (1) 3367 807', '+385 (1) 3363 628', null, null, '+385 (1) 3367 807', 'prekrsaj.sud@pssam.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('210', 'Prekršajni sud u Senju', 'Potok 1', null, 'Senj', '53270', 'Hrvatska', '+385 (53) 881 023', '+385 (53) 884 244', null, null, '+385 (53) 884 381', 'prekrsajnisud.senj@gs.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('211', 'Prekršajni sud u Sesvetama', 'Trg Dragutina Domjanića 6/II', null, 'Sesvete', '10360', 'Hrvatska', '+385 (1) 2043 920', '+385 (1) 2043 929', null, null, '+385 (1) 2001 950', 'prekrsajni.sud.u.sesvetama@zg.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('212', 'Prekršajni sud u Sinju', 'Petrovac 3', null, 'Sinj', '21230', 'Hrvatska', '+385 (21) 707 200', '+385 (21) 707 208', null, null, '+385 (21) 707 252', 'prekrsajni.sud.sinj@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('213', 'Prekršajni sud u Sisku', 'Frede Hefelea bb', null, 'Sisak', '44000', 'Hrvatska', '+385 (44) 571 773', '+385 (44) 494 505', null, null, '+385 (44) 571 770', 'ured.predsjednika@pssk.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('214', 'Prekršajni sud u Sisku - Stalna služba u Glini', 'Trg bana Josipa Jelačića 5', null, 'Glina', '44400', 'Hrvatska', '+385 (44) 880 086', '+385 (44) 882 031', null, null, '+385 (44) 882 031', 'prekrsajni.sud.glina@sk.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('215', 'Prekršajni sud u Sisku - Stalna služba u Hrvatskoj Kostajnici', 'Vladimira Nazora 10', null, 'Hrvatska Kostajnica', '44430', 'Hrvatska', '+385 (44) 851 088', '', null, null, '+385 (44) 851 088', 'prekrsajni.sud1@optinet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('216', 'Prekršajni sud u Sisku - Stalna služba u Petrinji', 'Augusta Šenoe br. 4', null, 'Petrinja', '44250', 'Hrvatska', '+385 (44) 813 846', '+385 (44) 813 359', null, null, '+385 (44) 813 846', 'prekrsajni.sud2@optinet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('217', 'Prekršajni sud u Slavonskom Brodu', 'Trg pobjede 13', null, 'Slavonski Brod', '35000', 'Hrvatska', '+385 (35) 410 292', '+385 (35) 410 298', null, null, '+385 (35) 415 362', 'prekrsajni-sud-sb@sb.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('218', 'Prekršajni sud u Splitu', 'Domovinskog rata 4', null, 'Split', '21000', 'Hrvatska', '+385 (21) 323 800', '+385 (21) 323 808', null, null, '+385 (21) 360 771', 'psst@psst.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('219', 'Prekršajni sud u Splitu - Stalna služba u Kaštel Sućurcu', 'Braće Radić 1', null, 'Kaštela', '21212', 'Hrvatska', '+385 (21) 224 282', '', null, null, '+385 (21) 226 275', 'psst@psst.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('220', 'Prekršajni sud u Splitu - Stalna služba u Omišu', 'Trg kralja Tomislava 5', null, 'Omiš', '21310', 'Hrvatska', '+385 (21) 861 084', '', null, null, '+385 (21) 756 610', 'psst@psst.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('221', 'Prekršajni sud u Splitu - Stalna služba u Solinu', 'Kralja Zvonimira 81', null, 'Solin', '21210', 'Hrvatska', '+385 (21) 212 555', '', null, null, '+385 (21) 210 708', 'psst@psst.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('222', 'Prekršajni sud u Splitu - Stalna služba u Trogiru', 'Put Muline 1', null, 'Trogir', '21220', 'Hrvatska', '+385 (21) 798 450', '', null, null, '+385 (21) 798 460', 'psst@psst.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('223', 'Prekršajni sud u Starom Gradu (Hvar)', 'Fabrika 29', null, 'Hvar', '21450', 'Hrvatska', '+385 (21) 742 477', '', null, null, '+385 (21) 742 477', 'prekrsajni.sud.u.hvaru@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('224', 'Prekršajni sud u Supetru', 'Hrvatskih velikana 6', null, 'Supetar', '21400', 'Hrvatska', '+385 (21) 640 970', '+385 (21) 640 972', null, null, '+385 (21) 640 971', 'prekrsajni-sud-supetar@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('225', 'Prekršajni sud u Šibeniku', 'Petra Grubišića 3', null, 'Šibenik', '22000', 'Hrvatska', '+385 (22) 201 666', '', null, null, '+385 (22) 201 670', 'prekrsajni.sud.u.sibeniku@si.htnet.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('226', 'Prekršajni sud u Umagu - Umago', 'Trg slobode 7', null, 'Umag', '52470', 'Hrvatska', '+385 (52) 741 059', '+385 (52) 743 799', null, null, '+385 (52) 741 059', 'prekrsajni.sud.u.umagu@pu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('227', 'Prekršajni sud u Valpovu', 'Trg kralja Tomislava 11a', null, 'Valpovo', '31550', 'Hrvatska', '+385 (31) 651 565 ', '+385 (31) 651 566', null, null, '+385 (31) 651 565', 'prekrsajni.sud.valpovo@os.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('228', 'Prekršajni sud u Valpovu - Stalna služba u Donjem Miholjcu', 'Vukovarska 1', null, 'Donji Miholjac', '31540', 'Hrvatska', '+385 (31) 631 026', '', null, null, '+385 (31) 631 026', 'prekrsajni.sud.u.donjem.miholj@t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('229', 'Prekršajni sud u Varaždinu', 'Braće Radić 2', null, 'Varaždin', '42000', 'Hrvatska', '+385 (42) 401 888', '', null, null, '+385 (42) 210 832', 'prekrsajni.sud@vz.t.-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('230', 'Prekršajni sud u Varaždinu - Stalna služba u Ivancu', 'Đure Arnolda 11', null, 'Ivanec', '42240', 'Hrvatska', '+385 (42) 783 863', '', null, null, '+385 (42) 782 206', 'prekrsajni-sud-ivanec@vz.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('231', 'Prekršajni sud u Varaždinu - Stalna služba u Ludbregu', 'Trg Sv. Trojstva 14/II', null, 'Ludbreg', '42230', 'Hrvatska', '+385 (42) 810 966', '', null, null, '+385 (42) 332 877 ', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('232', 'Prekršajni sud u Varaždinu - Stalna služba u Novom Marofu', 'Trg hrvatske državnosti 1', null, 'Novi Marof', '42220', 'Hrvatska', '+385 (42) 205 390', '', null, null, '+385 (42) 205 391', 'prekrsajni.sud.u.novom.marofu@ck.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('233', 'Prekršajni sud u Velikoj Gorici', 'Trg kralja Tomislava 34', null, 'Velika Gorica', '10410', 'Hrvatska', '+385 (1) 6222 105', '+385 (1) 6231 422', null, null, '+385 (1) 6231 422', 'prekrsajni.sud.u.velikoj.gorici@t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('234', 'Prekršajni sud u Vinkovcima', 'Dr. Franje Tuđmana 2', null, 'Vinkovci', '32100', 'Hrvatska', '+385 (32) 332 217', '+385 (32) 337 784', null, null, '+385 (32) 332 217', 'preksajni.sud.vinkovci@vu.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('235', 'Prekršajni sud u Virovitici', 'Trg kralja Tomislava 6/1', null, 'Virovitica', '33000', 'Hrvatska', '+385 (33) 725 284', '+385 (33) 800 289', null, null, '', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('236', 'Prekršajni sud u Virovitici - Stalna služba u Orahovici', 'Stjepana Mlakara 3', null, 'Orahovica', '33515', 'Hrvatska', '+385 (33) 674 442', '', null, null, '+385 (33) 674 442', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('237', 'Prekršajni sud u Virovitici - Stalna služba u Pitomači', 'Trg kralj Tomislava 15', null, 'Pitomača', '33405', 'Hrvatska', '+385 (33) 783 766', '', null, null, '+385 (33) 783 766', 'prekrsajni-sud-pitomaca@vt.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('238', 'Prekršajni sud u Virovitici - Stalna služba u Slatini', 'Trg Svetog Josipa 10', null, 'Slatina', '33520', 'Hrvatska', '+385 (33) 553 386', '', null, null, '+385 (33) 553 386', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('239', 'Prekršajni sud u Visu', 'Trg 30. svibnja 1992', null, 'Vis', '21480', 'Hrvatska', '+385 (21) 711 500', '', null, null, '+385 (21) 711 500', 'prekrsajni.sud.vis@st.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('240', 'Prekršajni sud u Vrbovcu', 'Trg Petra Zrinskog 23', null, 'Vrbovec', '10340', 'Hrvatska', '+385 (1) 2791 529', '+385 (1) 2792 688', null, null, '+385 (1) 792 690', 'psvrb@psvrb.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('241', 'Prekršajni sud u Vrbovcu - Stalna služba u Sv. Ivan Zelini', 'Vatrogasna 1', null, 'Sveti Ivan Zelina', '10380', 'Hrvatska', '+385 (1) 2060 773', '', null, null, '+385 (1) 2020 577', 'sszelina@psvrb.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('242', 'Prekršajni sud u Vukovaru', 'Županijska 3', null, 'Vukovar', '32000', 'Hrvatska', '+385 (32) 454 026', '+385 (32) 454 029', null, null, '+385 (32) 454 028', 'Ured.predsjednika@psvu.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('243', 'Prekršajni sud u Zaboku', 'Matije Gupca 53', null, 'Zabok', '49210', 'Hrvatska', '+385 (49) 221 447', '+385 (49) 223 439', null, null, '+385 (49) 221 447', 'prekrsajni.sud.zabok@kr.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('244', 'Prekršajni sud u Zaboku - Stalna služba u Klanjcu', 'Trg mira 1', null, 'Klanjec', '49290', 'Hrvatska', '+385 (49) 550 090', '', null, null, '+385 (49) 550 090', 'prekrsajni.sud.u.klanjcu@kr.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('245', 'Prekršajni sud u Zadru', 'Dr. Franje Tuđmana 35', null, 'Zadar', '23000', 'Hrvatska', '+385 (23) 292 151', '+385 (23) 292 152', null, null, '+385 (23) 292 220', 'jadranka.nizic@pszd.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('246', 'Prekršajni sud u Zadru - Stalna služba u Benkovcu', 'Stjepana Radića 10', null, 'Benkovac', '23420', 'Hrvatska', '+385 (23) 681 067', '+385 (23) 681 140', null, null, '+385 (23) 681 067', 'prekrsajni.sud.u.benkovcu@zd.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('247', 'Prekršajni sud u Zadru - Stalna služba u Biogradu na moru', 'Put Solina 7', null, 'Biograd na Moru', '23210', 'Hrvatska', '+385 (23) 383 024', '', null, null, '+385 (23) 384 157', 'prekrsajni.sud.biograd@zd.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('248', 'Prekršajni sud u Zadru - Stalna služba u Obrovcu', 'Stjepana Radića bb', null, 'Obrovac', '23450', 'Hrvatska', '+385 (23) 689 141', '+385 (23) 689 867', null, null, '+385 (23) 689 867', 'prekrsajni.sud.obrovac@zd.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('249', 'Prekršajni sud u Zagrebu', 'Avenija Dubrovnik 8', null, 'Zagreb', '10000', 'Hrvatska', '+385 (1) 6560 999', '', null, null, '+385 (1) 6560 993', 'sudska.uprava@pszg.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('250', 'Prekršajni sud u Zaprešiću', 'Trg žrtava fašizma 1', '', 'Zaprešić', '10290', 'Hrvatska', '+385 (1) 3350 555', '+385 (1) 3350 532', '', '', '+385 (1) 3350 532', 'prekrsajni.sud.zapresic@zg.t-com.hr', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '', '0000-00-00 00:00:00', '2013-05-29 08:57:19', '1'), ('251', 'Prekršajni sud u Zlataru', 'Trg Slobode 14/ A', null, 'Zlatar', '49250', 'Hrvatska', '+385 (49) 462 840', '+385 (49) 462 843', null, null, '+385 (49) 466 135', 'prekrsajni.sud@pszl.pravosudje.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('252', 'Prekršajni sud u Zlataru - Stalna služba u Donjoj Stubici', 'Matenačka 3/I', null, 'Donja Stubica', '49240', 'Hrvatska', '+385 (49) 588 130', '+385 (49) 588 138', null, null, '', 'prekrsajni.sud.d.stubica@kr.t-com.hr', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('253', 'Prekršajni sud u Županji', 'J.J. Strossmayera 18', null, 'Županja', '32270', 'Hrvatska', '+385 (32) 831 221', '+385 (32) 826 371', null, null, '+385 (32) 826 375', '', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', null, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'), ('291', 'Ana Radić', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, null, '0', '0', '0', '0', null, '1', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-04-24 11:23:59', '1'), ('292', 'Sanja Tvrdić', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, null, '0', '0', '0', '0', null, '1', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-04-24 11:24:32', '1'), ('293', 'Sanja Bivša', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, null, '0', '0', '0', '0', null, '1', null, '0', null, null, null, '0', '', '0000-00-00 00:00:00', '2013-04-24 12:46:13', '1'), ('294', 'Optima telekom d.o.o.', 'Bani 75a', 'Buzin', 'Zagreb', '10000', '', '+385(1)5492699', '', '', '', '+385(1)5492019', 'info@optima-telekom.hr', '', '36004425025', '', null, null, '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-04-23 19:42:51', '1'), ('295', 'Pero Perić', 'Nepoznate junakinje bb', '', 'Zagreb', '10000', '', '+385(1)3755362', '', '', '', '', 'pero.peric@gmail.com', '', '', '', null, null, '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-04-23 19:45:20', '1'), ('296', 'Grad Zagreb', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, null, '0', '1', '0', '0', null, '0', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-04-23 19:47:58', '1'), ('297', 'Marta Perić', 'Av. Dubrovnik 142', '', 'Zagreb', '10000', '', '', '', '', '', '', '', '', '', '', null, null, '0', '1', '0', '0', null, '0', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-04-23 19:47:12', '1'), ('298', 'Pavo Pavić', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, null, '0', '0', '1', '0', null, '0', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-04-24 12:44:37', '1'), ('299', 'Mato Prpić', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, null, '0', '0', '1', '0', null, '0', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-04-24 12:44:20', '1'), ('300', 'Ivana Ivanović', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, null, '0', '0', '0', '0', null, '1', null, '0', null, null, null, '1', '', '2013-04-16 12:07:07', '2013-04-24 12:48:03', '1'), ('301', 'Hrvoje Horvat', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, null, '0', '0', '0', '0', null, '1', null, '0', null, null, null, '1', '', '2013-04-16 12:07:16', '2013-04-24 12:48:24', '1'), ('304', 'Ivana Čalić', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, '1', '0', '0', '0', '1', null, '0', null, '0', null, null, null, '1', 'Sanader', '2013-04-22 13:06:49', '2013-08-26 16:32:06', '1'), ('305', 'Ivan Turudić', '', '', 'Zagreb', '10000', '', '', '', '', '', '', '', '', '', '', null, '1', '0', '0', '0', '1', null, '0', null, '0', null, null, null, '1', '', '0000-00-00 00:00:00', '2013-12-27 07:28:36', '1'), ('307', 'INA - Industrija nafte d.d.', 'Avenija Većeslava Holjevca 10', 'P.P. 555', 'Zagreb', '10002', '', '+385(1)6450000', '0800 1112', '', '', '', 'ina-besplatni.telefon@ina.hr', '', '27759560625', '', null, null, '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:31:08', '2013-04-23 18:42:05', '1'), ('308', 'Hrvatski Telekom d.d. ', 'Savska cesta 32', '', 'Zagreb', '10000', 'Hrvatska', '', '', '', '', '', '', '', '81793146560', '', null, null, '0', '1', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:36:16', '2013-04-23 18:41:53', '1'), ('309', 'Hrvatska elektroprivreda d.d.', 'Ulica grada Vukovara 37', '', 'Zagreb', '10000', '', '+385(1)6322111', '', '', '', '+385(1)6170430', '', '', '28921978587', '', null, null, '0', '1', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:37:55', '2013-04-23 18:42:22', '1'), ('310', 'PLIVA HRVATSKA d.o.o.', 'Prilaz baruna Filipovića 25', '', 'Zagreb', '10000', '', '+ 385(1)3720000', '', '', '', '+ 385(1)3720111', 'info@pliva.hr', '', '44205501677', '', null, null, '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:41:11', '2013-04-23 18:41:39', '1'), ('311', 'VIPnet d.o.o.', 'Vrtni put 1', '', 'Zagreb', '10000', '', '091 7700', '', '', '', '', 'office@vipnet.hr', '', '29524210204', '', null, '1', '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:44:21', '2014-03-11 14:02:31', '2'), ('312', 'Konzum d.d.', 'Marijana Čavića 1a', '', 'Zagreb', '10000', '', '+385(1)2482100', '', '', '', '+385(1)2482165', 'konzum@konzum.hr', '', '29955634590', '', null, null, '0', '1', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:49:19', '2013-04-23 18:49:19', '1'), ('313', 'HŽ Infrastruktura d.o.o.', 'Antuna Mihanovića 12', '', 'Zagreb', '10000', '', '+385(1)3783019', '', '', '', '+385(1)4572131', 'infrastruktura.upiti@hzinfra.hr', '', '39901919995 ', '', null, null, '0', '1', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:51:47', '2013-04-23 18:52:12', '1'), ('314', 'Vindija d.d.', 'Međimurska 6', '', 'Varaždin', '42000', '', '+385(42)399999 ', '', '', '', '', 'promotion@vindija.hr', '', '44138062462', '', null, null, '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:54:32', '2013-04-23 18:54:44', '1'), ('315', 'Dukat d.d.', 'Marijana Čavića 9', '', 'Zagreb', '10000', '', '', '', '', '', '', '', '', '25457712630', '', null, null, '0', '1', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:55:48', '2013-04-23 18:55:48', '1'), ('316', 'Tvornica duhana Rovinj d.o.o.', 'Obala Vladimira Nazora 1', '', 'Rovinj', '52210', '', '+385(52)844000', '', '', '', '+385(52)844470', 'tdr@tdr.hr', '', '37014645007', '', null, null, '0', '1', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 18:59:18', '2013-04-23 18:59:18', '1'), ('317', 'AGRODUHAN d.o.o.', 'Nikole Šubića Zrinskog 30', '', 'Slatina', '33520', '', '+385(33)551422', '', '', '', '+385(33)552482', 'agroduhan@agroduhan.hr', '', '97446273531', '', null, null, '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 19:02:27', '2013-04-23 19:03:00', '1'), ('318', 'Iločki podrumi d.o.o.', 'Dr. Franje Tuđmana 72', '', 'Ilok', '32236', '', '+385(32)590003', '', '', '', '+385(32)590047', 'info@ilocki-podrumi.hr', '', '38793818363', '', null, null, '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2013-04-23 19:05:48', '2013-04-23 19:05:48', '1'), ('319', 'hfhtfhtf', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '1', '1', '0', '0', '0', null, '0', null, '0', null, null, null, '1', '', '2014-03-08 17:38:57', '2014-03-08 17:38:57', '1');
349COMMIT;
350
351-- ----------------------------
352-- Table structure for currencies
353-- ----------------------------
354DROP TABLE IF EXISTS `currencies`;
355CREATE TABLE `currencies` (
356`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
357`full_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
358`short_name`  varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
359PRIMARY KEY (`id`)
360)
361ENGINE=InnoDB
362DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
363AUTO_INCREMENT=6
364
365;
366
367-- ----------------------------
368-- Records of currencies
369-- ----------------------------
370BEGIN;
371INSERT INTO `currencies` VALUES ('1', 'Croatian Kuna', 'HRK'), ('2', 'Euro', 'EUR'), ('5', 'United States Dollar', 'USD');
372COMMIT;
373
374-- ----------------------------
375-- Table structure for documents
376-- ----------------------------
377DROP TABLE IF EXISTS `documents`;
378CREATE TABLE `documents` (
379`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
380`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
381`suit_id`  int(11) NULL DEFAULT NULL ,
382`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
383`tags`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
384`created`  datetime NULL DEFAULT NULL ,
385`modified`  datetime NULL DEFAULT NULL ,
386`created_by`  int(11) NULL DEFAULT NULL ,
387`modified_by`  int(11) NULL DEFAULT NULL ,
388PRIMARY KEY (`id`)
389)
390ENGINE=InnoDB
391DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
392AUTO_INCREMENT=1
393
394;
395
396-- ----------------------------
397-- Records of documents
398-- ----------------------------
399BEGIN;
400COMMIT;
401
402-- ----------------------------
403-- Table structure for exchange_rates
404-- ----------------------------
405DROP TABLE IF EXISTS `exchange_rates`;
406CREATE TABLE `exchange_rates` (
407`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
408`currency_id`  int(11) NULL DEFAULT NULL ,
409`value`  decimal(10,6) NULL DEFAULT NULL ,
410`start_date`  datetime NULL DEFAULT NULL ,
411PRIMARY KEY (`id`)
412)
413ENGINE=InnoDB
414DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
415AUTO_INCREMENT=5
416
417;
418
419-- ----------------------------
420-- Records of exchange_rates
421-- ----------------------------
422BEGIN;
423INSERT INTO `exchange_rates` VALUES ('1', '2', '7.654102', '2014-03-11 16:13:00'), ('3', '5', '5.470743', '2013-10-01 16:18:25'), ('4', '1', '1.000000', '0000-00-00 00:00:00');
424COMMIT;
425
426-- ----------------------------
427-- Table structure for favorites
428-- ----------------------------
429DROP TABLE IF EXISTS `favorites`;
430CREATE TABLE `favorites` (
431`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
432`foreign_key`  int(11) NULL DEFAULT NULL ,
433`module`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
434`user_id`  int(11) NULL DEFAULT NULL ,
435PRIMARY KEY (`id`)
436)
437ENGINE=InnoDB
438DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
439AUTO_INCREMENT=1
440
441;
442
443-- ----------------------------
444-- Records of favorites
445-- ----------------------------
446BEGIN;
447COMMIT;
448
449-- ----------------------------
450-- Table structure for invoice_items
451-- ----------------------------
452DROP TABLE IF EXISTS `invoice_items`;
453CREATE TABLE `invoice_items` (
454`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
455`invoice_id`  int(11) UNSIGNED NULL DEFAULT NULL ,
456`product_id`  int(11) UNSIGNED NULL DEFAULT NULL ,
457`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
458`amount`  float NULL DEFAULT 0 ,
459`unit`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
460`unit_price`  decimal(12,2) NULL DEFAULT NULL ,
461`discount_percentage`  float NULL DEFAULT 0 ,
462`discount`  decimal(12,2) NULL DEFAULT 0.00 ,
463`price_without_tax`  decimal(12,2) NULL DEFAULT NULL ,
464`tax_id`  int(11) NULL DEFAULT NULL ,
465`tax_price`  decimal(12,2) NULL DEFAULT NULL ,
466`price`  decimal(12,2) NULL DEFAULT NULL ,
467`invoiced`  tinyint(4) NULL DEFAULT NULL ,
468`from_billing_account`  tinyint(4) NULL DEFAULT 0 ,
469`created_by`  int(11) UNSIGNED NULL DEFAULT NULL ,
470`modified_by`  int(11) UNSIGNED NULL DEFAULT NULL ,
471`created`  datetime NULL DEFAULT NULL ,
472`modified`  datetime NULL DEFAULT NULL ,
473`billing_item_category`  varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
474`time`  float NULL DEFAULT 0 ,
475`billable_time`  float NULL DEFAULT 0 ,
476`written_off_time`  float NULL DEFAULT 0 ,
477`billing_item_type`  varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
478`unit_price_c`  decimal(10,2) NULL DEFAULT NULL ,
479`discount_c`  decimal(10,2) NULL DEFAULT NULL ,
480`price_without_tax_c`  decimal(10,2) NULL DEFAULT NULL ,
481`tax_price_c`  decimal(10,2) NULL DEFAULT NULL ,
482`price_c`  decimal(10,2) NULL DEFAULT NULL ,
483`currency_id`  int(11) UNSIGNED NULL DEFAULT NULL ,
484`exchange_rate`  decimal(12,7) NULL DEFAULT NULL ,
485`exchange_date`  date NULL DEFAULT NULL ,
486PRIMARY KEY (`id`)
487)
488ENGINE=InnoDB
489DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
490AUTO_INCREMENT=1
491
492;
493
494-- ----------------------------
495-- Records of invoice_items
496-- ----------------------------
497BEGIN;
498COMMIT;
499
500-- ----------------------------
501-- Table structure for invoices
502-- ----------------------------
503DROP TABLE IF EXISTS `invoices`;
504CREATE TABLE `invoices` (
505`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
506`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
507`client_id`  int(11) NULL DEFAULT NULL ,
508`invoice_date`  date NULL DEFAULT NULL ,
509`invoice_date_of_delivery`  date NULL DEFAULT NULL ,
510`invoice_due_date`  date NULL DEFAULT NULL ,
511`invoice_number`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
512`deferred_payment`  int(5) NULL DEFAULT NULL ,
513`tax_number`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
514`invoiced`  tinyint(4) NULL DEFAULT NULL ,
515`invoice_language`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
516`c/o`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
517`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
518`payment_method`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
519`iban`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
520`reference_number`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
521`total_without_tax`  decimal(15,2) NULL DEFAULT NULL ,
522`tax`  decimal(15,2) NULL DEFAULT NULL ,
523`total`  float(15,2) NULL DEFAULT NULL ,
524`cannot_reverse`  tinyint(4) NULL DEFAULT NULL ,
525`cannot_copy`  tinyint(4) NULL DEFAULT NULL ,
526`from_billing_account`  tinyint(4) NULL DEFAULT NULL ,
527`services_sum`  decimal(10,2) NULL DEFAULT NULL ,
528`services_tax`  decimal(10,2) NULL DEFAULT NULL ,
529`services_total`  decimal(10,2) NULL DEFAULT NULL ,
530`expenses_sum`  decimal(10,2) NULL DEFAULT NULL ,
531`created_by`  int(11) NULL DEFAULT NULL ,
532`modified_by`  int(11) NULL DEFAULT NULL ,
533`created`  datetime NULL DEFAULT NULL ,
534`modified`  datetime NULL DEFAULT NULL ,
535`non_billing_items_sum`  decimal(10,2) NULL DEFAULT NULL ,
536`non_billing_items_tax`  decimal(10,2) NULL DEFAULT NULL ,
537`non_billing_items_total`  decimal(10,2) NULL DEFAULT NULL ,
538`flat_sum`  decimal(10,2) NULL DEFAULT 0.00 ,
539`flat_tax`  decimal(10,2) NULL DEFAULT 0.00 ,
540`flat_total`  decimal(10,2) NULL DEFAULT 0.00 ,
541`exchange_rate_date`  date NULL DEFAULT NULL ,
542PRIMARY KEY (`id`)
543)
544ENGINE=InnoDB
545DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
546AUTO_INCREMENT=1
547
548;
549
550-- ----------------------------
551-- Records of invoices
552-- ----------------------------
553BEGIN;
554COMMIT;
555
556-- ----------------------------
557-- Table structure for languages
558-- ----------------------------
559DROP TABLE IF EXISTS `languages`;
560CREATE TABLE `languages` (
561`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
562`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
563`alias`  varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
564`created`  datetime NOT NULL ,
565`modified`  datetime NOT NULL ,
566PRIMARY KEY (`id`)
567)
568ENGINE=InnoDB
569DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
570AUTO_INCREMENT=3
571
572;
573
574-- ----------------------------
575-- Records of languages
576-- ----------------------------
577BEGIN;
578INSERT INTO `languages` VALUES ('1', 'Hrvatski', 'hr_HR', '2013-02-22 17:33:17', '2013-05-22 14:51:48'), ('2', 'English', 'en_US', '2013-02-22 17:34:42', '2013-05-23 08:59:05');
579COMMIT;
580
581-- ----------------------------
582-- Table structure for logs
583-- ----------------------------
584DROP TABLE IF EXISTS `logs`;
585CREATE TABLE `logs` (
586`id`  int(11) NOT NULL AUTO_INCREMENT ,
587`user_id`  varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
588`controller`  varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
589`action`  varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
590`data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
591`code`  int(11) NULL DEFAULT NULL ,
592`created`  datetime NULL DEFAULT NULL ,
593`seen`  tinyint(4) NULL DEFAULT NULL ,
594PRIMARY KEY (`id`)
595)
596ENGINE=InnoDB
597DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
598AUTO_INCREMENT=1
599
600;
601
602-- ----------------------------
603-- Records of logs
604-- ----------------------------
605BEGIN;
606COMMIT;
607
608-- ----------------------------
609-- Table structure for menu
610-- ----------------------------
611DROP TABLE IF EXISTS `menu`;
612CREATE TABLE `menu` (
613`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
614`ordinal_number`  int(5) NOT NULL ,
615`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
616`parent_id`  int(5) NULL DEFAULT NULL ,
617`store`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
618`model`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
619`view`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
620`view_update`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
621`translate`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
622`permissions`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
623`visible`  tinyint(4) NOT NULL DEFAULT 1 ,
624PRIMARY KEY (`id`)
625)
626ENGINE=InnoDB
627DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
628AUTO_INCREMENT=39
629
630;
631
632-- ----------------------------
633-- Records of menu
634-- ----------------------------
635BEGIN;
636INSERT INTO `menu` VALUES ('1', '1', 'Suits', '0', null, null, null, null, 'Lawsuits', null, '1'), ('2', '3', 'Contacts', '0', null, null, null, null, 'Contacts', null, '1'), ('3', '6', 'Administration', '0', null, null, null, null, 'Administration', null, '1'), ('4', '1', 'Suits', '1', 'MojSpis.store.Suits', 'MojSpis.model.Suit', 'MojSpis.view.Suits.Index', 'MojSpis.view.Suits.Update', 'Suits', 'suits_module', '1'), ('5', '2', 'MySuits', '1', 'MojSpis.store.MySuits', 'MojSpis.model.Suit', 'MojSpis.view.MySuits.Index', 'MojSpis.view.Suits.Update', 'My lawsuits', 'my_suits_module', '1'), ('6', '3', 'FavoriteSuits', '1', 'MojSpis.store.FavoriteSuits', 'MojSpis.model.Suit', 'MojSpis.view.FavoriteSuits.Index', 'MojSpis.view.Suits.Update', 'Favorite lawsuits', 'suits_favorites_module', '1'), ('7', '4', 'RecentSuits', '1', 'MojSpis.store.RecentSuits', 'MojSpis.model.Suit', 'MojSpis.view.RecentSuits.Index', 'MojSpis.view.Suits.Update', 'Lawsuit history', 'suits_recents_module', '1'), ('8', '5', 'ClientCard', '1', 'MojSpis.store.ClientCardSuits', 'MojSpis.model.Suit', 'MojSpis.view.ClientCard.Index', null, 'Client lawsuits', 'suits_client_lawsuits_module', '1'), ('9', '6', 'WorkerCard', '1', 'MojSpis.store.WorkerCardSuits', 'MojSpis.model.Suit', 'MojSpis.view.WorkerCard.Index', null, 'Employee lawsuits', 'suits_employee_lawsuits_module', '1'), ('10', '1', 'Contacts', '2', 'MojSpis.store.Contacts', 'MojSpis.model.Contact', 'MojSpis.view.Contacts.Index', 'MojSpis.view.Contacts.Update', 'Contacts', 'contacts_module', '1'), ('11', '2', 'FavoriteContacts', '2', 'MojSpis.store.FavoriteContacts', 'MojSpis.model.Contact', 'MojSpis.view.FavoriteContacts.Index', 'MojSpis.view.Contacts.Update', 'Favorite contacts', 'contacts_favorites_module', '1'), ('12', '3', 'RecentContacts', '2', 'MojSpis.store.RecentContacts', 'MojSpis.model.Contact', 'MojSpis.view.RecentContacts.Index', 'MojSpis.view.Contacts.Update', 'Contacts history', 'contacts_recents_module', '1'), ('13', '1', 'Users', '3', 'MojSpis.store.Users', 'MojSpis.model.User', 'MojSpis.view.Users.Index', 'MojSpis.view.Users.Update', 'Users', 'users_module', '1'), ('14', '2', 'Roles', '3', 'MojSpis.store.Roles', 'MojSpis.model.Role', 'MojSpis.view.Roles.Index', 'MojSpis.view.Roles.Update', 'Roles', 'roles_module', '1'), ('15', '3', 'SuitPriorities', '3', 'MojSpis.store.SuitPriorities', 'MojSpis.model.SuitPriority', 'MojSpis.view.SuitPriorities.Index', '', 'Lawsuit priorities', 'suit_priorities_module', '1'), ('16', '4', 'SuitTypes', '3', 'MojSpis.store.SuitTypes', 'MojSpis.model.SuitType', 'MojSpis.view.SuitTypes.Index', null, 'Lawsuit types', 'suit_types_module', '1'), ('17', '5', 'ClientStatuses', '3', 'MojSpis.store.ClientStatuses', 'MojSpis.model.ClientStatus', 'MojSpis.view.ClientStatuses.Index', null, 'Client statuses', 'client_statuses_module', '1'), ('18', '6', 'Jurisdictions', '3', 'MojSpis.store.Jurisdictions', 'MojSpis.model.Jurisdiction', 'MojSpis.view.Jurisdictions.Index', 'MojSpis.view.Contacts.Update', 'Jurisdictions', 'jurisdictions_module', '1'), ('19', '7', 'Judges', '3', 'MojSpis.store.Judges', 'MojSpis.model.Contact', 'MojSpis.view.Judges.Index', 'MojSpis.view.Contacts.Update', 'Judges', 'judges_module', '1'), ('20', '8', 'Languages', '3', 'MojSpis.store.Languages', 'MojSpis.model.Language', 'MojSpis.view.Languages.Index', '', 'Languages', 'languages_module', '1'), ('22', '5', 'Finance', '0', null, null, null, null, 'Finance', null, '1'), ('23', '1', 'Invoices', '22', 'MojSpis.store.Invoices', 'MojSpis.model.Invoice', 'MojSpis.view.Invoices.Index', 'MojSpis.view.Invoices.Update', 'Invoices', 'invoices_module', '1'), ('25', '3', 'BillingAccounts', '22', 'MojSpis.store.BillingAccounts', 'MojSpis.model.BillingAccount', 'MojSpis.view.BillingAccounts.Index', 'MojSpis.view.BillingAccounts.Update', 'BillingAccounts', 'billing_accounts_module', '1'), ('26', '7', 'ContactCard', '1', 'MojSpis.store.ContactCardSuits', 'MojSpis.model.Suit', 'MojSpis.view.ContactCard.Index', '', 'Contact lawsuits', 'suits_contact_lawsuits_module', '1'), ('28', '4', 'BillingItems', '22', 'MojSpis.store.BillingItems', 'MojSpis.model.BillingItem', 'MojSpis.view.BillingItems.Index', 'MojSpis.view.BillingItems.Update', 'BillingItems', 'billing_items_module', '1'), ('29', '4', 'Reports', '0', null, null, null, null, 'Reports', null, '1'), ('30', '1', 'ReportTasks', '29', '', '', 'MojSpis.view.ReportTasks.Index', 'MojSpis.view.ReportTasks.Update', 'ReportTasks', 'report_tasks_module', '1'), ('32', '2', 'InvoicesDraft', '22', 'MojSpis.store.InvoicesDraft', 'MojSpis.model.Invoice', 'MojSpis.view.InvoicesDraft.Index', 'MojSpis.view.InvoicesDraft.Update', 'InvoicesDraft', 'invoices_draft_module', '1'), ('33', '5', 'Products', '22', 'MojSpis.store.Products', 'MojSpis.model.Product', 'MojSpis.view.Products.Index', 'MojSpis.view.Products.Update', 'Products', 'products_module', '1'), ('34', '2', 'Projects', '0', null, null, null, null, 'Projects', null, '1'), ('35', '1', 'Projects', '34', 'MojSpis.store.Projects', 'MojSpis.model.Project', 'MojSpis.view.Projects.Index', 'MojSpis.view.Projects.Update', 'Projects', 'projects_module', '1'), ('36', '6', 'Currencies', '22', 'MojSpis.store.Currencies', 'MojSpis.model.Currency', 'MojSpis.view.Currencies.Index', null, 'Currencies', 'currencies_module', '1'), ('37', '2', 'ReportSuits', '29', '', null, 'MojSpis.view.ReportSuits.Index', null, 'ReportSuits', 'report_suits_module', '1'), ('38', '3', 'ReportProjects', '29', null, null, 'MojSpis.view.ReportProjects.Index', null, 'ReportProjects', 'report_projects_module', '1');
637COMMIT;
638
639-- ----------------------------
640-- Table structure for messages
641-- ----------------------------
642DROP TABLE IF EXISTS `messages`;
643CREATE TABLE `messages` (
644`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
645`from_id`  int(11) NULL DEFAULT NULL ,
646`to_id`  int(11) NULL DEFAULT NULL ,
647`subject`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
648`content`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
649`created`  datetime NULL DEFAULT NULL ,
650`modified`  datetime NULL DEFAULT NULL ,
651`user_id`  int(11) NULL DEFAULT NULL ,
652PRIMARY KEY (`id`)
653)
654ENGINE=InnoDB
655DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
656AUTO_INCREMENT=1
657
658;
659
660-- ----------------------------
661-- Records of messages
662-- ----------------------------
663BEGIN;
664COMMIT;
665
666-- ----------------------------
667-- Table structure for products
668-- ----------------------------
669DROP TABLE IF EXISTS `products`;
670CREATE TABLE `products` (
671`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
672`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
673`translate`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
674`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
675PRIMARY KEY (`id`)
676)
677ENGINE=InnoDB
678DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
679AUTO_INCREMENT=1
680
681;
682
683-- ----------------------------
684-- Records of products
685-- ----------------------------
686BEGIN;
687COMMIT;
688
689-- ----------------------------
690-- Table structure for projects
691-- ----------------------------
692DROP TABLE IF EXISTS `projects`;
693CREATE TABLE `projects` (
694`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
695`client_id`  int(11) NULL DEFAULT NULL ,
696`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
697`leader_id`  int(11) NULL DEFAULT NULL ,
698`opened`  datetime NULL DEFAULT NULL ,
699`closed`  datetime NULL DEFAULT NULL ,
700`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
701`tags`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
702`status`  tinyint(4) NULL DEFAULT NULL ,
703PRIMARY KEY (`id`)
704)
705ENGINE=InnoDB
706DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
707AUTO_INCREMENT=1
708
709;
710
711-- ----------------------------
712-- Records of projects
713-- ----------------------------
714BEGIN;
715COMMIT;
716
717-- ----------------------------
718-- Table structure for recents
719-- ----------------------------
720DROP TABLE IF EXISTS `recents`;
721CREATE TABLE `recents` (
722`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
723`foreign_key`  int(11) NULL DEFAULT NULL ,
724`module`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
725`user_id`  int(11) NULL DEFAULT NULL ,
726`created`  datetime NULL DEFAULT NULL ,
727PRIMARY KEY (`id`)
728)
729ENGINE=InnoDB
730DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
731AUTO_INCREMENT=1
732
733;
734
735-- ----------------------------
736-- Records of recents
737-- ----------------------------
738BEGIN;
739COMMIT;
740
741-- ----------------------------
742-- Table structure for roles
743-- ----------------------------
744DROP TABLE IF EXISTS `roles`;
745CREATE TABLE `roles` (
746`id`  int(11) NOT NULL AUTO_INCREMENT ,
747`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
748`created`  datetime NULL DEFAULT NULL ,
749`modified`  datetime NULL DEFAULT NULL ,
750PRIMARY KEY (`id`)
751)
752ENGINE=InnoDB
753DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
754AUTO_INCREMENT=1
755
756;
757
758-- ----------------------------
759-- Records of roles
760-- ----------------------------
761BEGIN;
762COMMIT;
763
764-- ----------------------------
765-- Table structure for suit_priorities
766-- ----------------------------
767DROP TABLE IF EXISTS `suit_priorities`;
768CREATE TABLE `suit_priorities` (
769`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
770`name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
771`created`  datetime NOT NULL ,
772`modified`  datetime NOT NULL ,
773PRIMARY KEY (`id`)
774)
775ENGINE=InnoDB
776DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
777AUTO_INCREMENT=4
778
779;
780
781-- ----------------------------
782-- Records of suit_priorities
783-- ----------------------------
784BEGIN;
785INSERT INTO `suit_priorities` VALUES ('1', 'Nizak', '2013-02-20 11:45:40', '2013-05-23 08:59:35'), ('2', 'Srednji', '2013-02-20 11:45:48', '2013-02-20 11:45:48'), ('3', 'Visok', '2013-02-20 11:45:55', '2013-02-20 11:45:55');
786COMMIT;
787
788-- ----------------------------
789-- Table structure for suit_types
790-- ----------------------------
791DROP TABLE IF EXISTS `suit_types`;
792CREATE TABLE `suit_types` (
793`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
794`name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
795`created`  datetime NOT NULL ,
796`modified`  datetime NOT NULL ,
797PRIMARY KEY (`id`)
798)
799ENGINE=InnoDB
800DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
801AUTO_INCREMENT=19
802
803;
804
805-- ----------------------------
806-- Records of suit_types
807-- ----------------------------
808BEGIN;
809INSERT INTO `suit_types` VALUES ('2', 'Izvanparnični', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('3', 'Javnobilježnički', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('4', 'Kazneni', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('5', 'Konzultantski', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('6', 'Mirni', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('7', 'Ostalo', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('8', 'Ostavinski', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('9', 'Ovršni', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('10', 'Parnični', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('11', 'Prekršajni', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('12', 'Radni', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('13', 'Stečajni', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('14', 'Upis u sudski registar', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('15', 'Upravni', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('16', 'Upravni spor ', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('17', 'Ustavni', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('18', 'Zemljišnoknjižni', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
810COMMIT;
811
812-- ----------------------------
813-- Table structure for suits
814-- ----------------------------
815DROP TABLE IF EXISTS `suits`;
816CREATE TABLE `suits` (
817`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
818`name`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
819`status`  tinyint(4) NOT NULL ,
820`suit_priority_id`  int(11) NOT NULL ,
821`opened`  date NULL DEFAULT NULL ,
822`closed`  date NULL DEFAULT NULL ,
823`suit_type_id`  int(11) NULL DEFAULT NULL ,
824`leader_id`  int(11) NOT NULL ,
825`substitute_id`  int(11) NULL DEFAULT NULL ,
826`assistant_id`  int(11) NULL DEFAULT NULL ,
827`client_id`  int(11) NOT NULL ,
828`client_status_id`  int(11) NOT NULL ,
829`counterparty_id`  int(11) NULL DEFAULT NULL ,
830`counterparty_status_id`  int(11) NULL DEFAULT NULL ,
831`counterparty_lawyer_id`  int(11) NULL DEFAULT NULL ,
832`judge_id`  int(11) NULL DEFAULT NULL ,
833`cause`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
834`suit_value`  decimal(10,2) NULL DEFAULT NULL ,
835`jurisdiction_id`  int(11) NULL DEFAULT NULL ,
836`jurisdiction_reference`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
837`location`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
838`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
839`tags`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
840`created_by`  int(11) NOT NULL ,
841`modified_by`  int(11) NOT NULL ,
842`created`  datetime NOT NULL ,
843`modified`  datetime NOT NULL ,
844PRIMARY KEY (`id`)
845)
846ENGINE=InnoDB
847DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
848AUTO_INCREMENT=1
849
850;
851
852-- ----------------------------
853-- Records of suits
854-- ----------------------------
855BEGIN;
856COMMIT;
857
858-- ----------------------------
859-- Table structure for taxes
860-- ----------------------------
861DROP TABLE IF EXISTS `taxes`;
862CREATE TABLE `taxes` (
863`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
864`name`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
865`tax`  float NULL DEFAULT NULL ,
866`created`  datetime NULL DEFAULT NULL ,
867`modified`  datetime NULL DEFAULT NULL ,
868PRIMARY KEY (`id`)
869)
870ENGINE=InnoDB
871DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
872AUTO_INCREMENT=102
873
874;
875
876-- ----------------------------
877-- Records of taxes
878-- ----------------------------
879BEGIN;
880INSERT INTO `taxes` VALUES ('1', 'PDV 00%', '0', null, null), ('2', 'PDV 01%', '0.01', null, null), ('3', 'PDV 02%', '0.02', null, null), ('4', 'PDV 03%', '0.03', null, null), ('5', 'PDV 04%', '0.04', null, null), ('6', 'PDV 05%', '0.05', null, null), ('7', 'PDV 06%', '0.06', null, null), ('8', 'PDV 07%', '0.07', null, null), ('9', 'PDV 08%', '0.08', null, null), ('10', 'PDV 09%', '0.09', null, null), ('11', 'PDV 10%', '0.1', null, null), ('12', 'PDV 11%', '0.11', null, null), ('13', 'PDV 12%', '0.12', null, null), ('14', 'PDV 13%', '0.13', null, null), ('15', 'PDV 14%', '0.14', null, null), ('16', 'PDV 15%', '0.15', null, null), ('17', 'PDV 16%', '0.16', null, null), ('18', 'PDV 17%', '0.17', null, null), ('19', 'PDV 18%', '0.18', null, null), ('20', 'PDV 19%', '0.19', null, null), ('21', 'PDV 20%', '0.2', null, null), ('22', 'PDV 21%', '0.21', null, null), ('23', 'PDV 22%', '0.22', null, null), ('24', 'PDV 23%', '0.23', null, null), ('25', 'PDV 24%', '0.24', null, null), ('26', 'PDV 25%', '0.25', null, null), ('27', 'PDV 26%', '0.26', null, null), ('28', 'PDV 27%', '0.27', null, null), ('29', 'PDV 28%', '0.28', null, null), ('30', 'PDV 29%', '0.29', null, null), ('31', 'PDV 30%', '0.3', null, null), ('32', 'PDV 31%', '0.31', null, null), ('33', 'PDV 32%', '0.32', null, null), ('34', 'PDV 33%', '0.33', null, null), ('35', 'PDV 34%', '0.34', null, null), ('36', 'PDV 35%', '0.35', null, null), ('37', 'PDV 36%', '0.36', null, null), ('38', 'PDV 37%', '0.37', null, null), ('39', 'PDV 38%', '0.38', null, null), ('40', 'PDV 39%', '0.39', null, null), ('41', 'PDV 40%', '0.4', null, null), ('42', 'PDV 41%', '0.41', null, null), ('43', 'PDV 42%', '0.42', null, null), ('44', 'PDV 43%', '0.43', null, null), ('45', 'PDV 44%', '0.44', null, null), ('46', 'PDV 45%', '0.45', null, null), ('47', 'PDV 46%', '0.46', null, null), ('48', 'PDV 47%', '0.47', null, null), ('49', 'PDV 48%', '0.48', null, null), ('50', 'PDV 49%', '0.49', null, null), ('51', 'PDV 50%', '0.5', null, null), ('52', 'PDV 51%', '0.51', null, null), ('53', 'PDV 52%', '0.52', null, null), ('54', 'PDV 53%', '0.53', null, null), ('55', 'PDV 54%', '0.54', null, null), ('56', 'PDV 55%', '0.55', null, null), ('57', 'PDV 56%', '0.56', null, null), ('58', 'PDV 57%', '0.57', null, null), ('59', 'PDV 58%', '0.58', null, null), ('60', 'PDV 59%', '0.59', null, null), ('61', 'PDV 60%', '0.6', null, null), ('62', 'PDV 61%', '0.61', null, null), ('63', 'PDV 62%', '0.62', null, null), ('64', 'PDV 63%', '0.63', null, null), ('65', 'PDV 64%', '0.64', null, null), ('66', 'PDV 65%', '0.65', null, null), ('67', 'PDV 66%', '0.66', null, null), ('68', 'PDV 67%', '0.67', null, null), ('69', 'PDV 68%', '0.68', null, null), ('70', 'PDV 69%', '0.69', null, null), ('71', 'PDV 70%', '0.7', null, null), ('72', 'PDV 71%', '0.71', null, null), ('73', 'PDV 72%', '0.72', null, null), ('74', 'PDV 73%', '0.73', null, null), ('75', 'PDV 74%', '0.74', null, null), ('76', 'PDV 75%', '0.75', null, null), ('77', 'PDV 76%', '0.76', null, null), ('78', 'PDV 77%', '0.77', null, null), ('79', 'PDV 78%', '0.78', null, null), ('80', 'PDV 79%', '0.79', null, null), ('81', 'PDV 80%', '0.8', null, null), ('82', 'PDV 81%', '0.81', null, null), ('83', 'PDV 82%', '0.82', null, null), ('84', 'PDV 83%', '0.83', null, null), ('85', 'PDV 84%', '0.84', null, null), ('86', 'PDV 85%', '0.85', null, null), ('87', 'PDV 86%', '0.86', null, null), ('88', 'PDV 87%', '0.87', null, null), ('89', 'PDV 88%', '0.88', null, null), ('90', 'PDV 89%', '0.89', null, null), ('91', 'PDV 90%', '0.9', null, null), ('92', 'PDV 91%', '0.91', null, null), ('93', 'PDV 92%', '0.92', null, null), ('94', 'PDV 93%', '0.93', null, null), ('95', 'PDV 94%', '0.94', null, null), ('96', 'PDV 95%', '0.95', null, null), ('97', 'PDV 96%', '0.96', null, null), ('98', 'PDV 97%', '0.97', null, null), ('99', 'PDV 98%', '0.98', null, null), ('100', 'PDV 99%', '0.99', null, null);
881INSERT INTO `taxes` VALUES ('101', 'PDV 100%', '1', null, null);
882COMMIT;
883
884-- ----------------------------
885-- Table structure for users
886-- ----------------------------
887DROP TABLE IF EXISTS `users`;
888CREATE TABLE `users` (
889`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
890`username`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
891`password`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
892`email`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
893`first_name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
894`last_name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
895`full_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
896`aro_id`  int(11) NULL DEFAULT NULL ,
897`language_id`  int(11) NOT NULL ,
898`status`  tinyint(4) NOT NULL ,
899`last_login`  datetime NULL DEFAULT NULL ,
900`created`  datetime NOT NULL ,
901`modified`  datetime NOT NULL ,
902PRIMARY KEY (`id`)
903)
904ENGINE=InnoDB
905DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
906AUTO_INCREMENT=4
907
908;
909
910-- ----------------------------
911-- Records of users
912-- ----------------------------
913BEGIN;
914INSERT INTO `users` VALUES ('1', 'davlozi', 'ea0e16ae90b714572cacb8568f5fdee30cd3fd2d', 'dlozic@tvz.hr', 'Davor', 'Lozić', 'Davor Lozić', '1', '1', '1', '2014-10-10 15:04:15', '2013-02-20 12:59:06', '2014-07-02 21:58:43'), ('2', 'vzderic', 'ea0e16ae90b714572cacb8568f5fdee30cd3fd2d', 'vladimir.zderic@podrska.hr', 'Vladimir', 'Žderić', 'Vladimir Žderić', '1', '1', '1', '2013-08-23 07:09:34', '2013-08-22 14:15:09', '2014-07-02 22:04:59'), ('3', 'guest', '82f9cb4ca0202ef220a8eff0ff4d3990da4587e5', 'guest@guest.com', 'Guest', 'Guest', 'Guest Guest', '1', '1', '1', '2014-08-18 16:23:21', '2014-08-17 15:22:21', '2014-08-17 15:22:21');
915COMMIT;
916
917-- ----------------------------
918-- Auto increment value for acos
919-- ----------------------------
920ALTER TABLE `acos` AUTO_INCREMENT=70;
921
922-- ----------------------------
923-- Auto increment value for acos_aros
924-- ----------------------------
925ALTER TABLE `acos_aros` AUTO_INCREMENT=208;
926
927-- ----------------------------
928-- Auto increment value for activities
929-- ----------------------------
930ALTER TABLE `activities` AUTO_INCREMENT=1;
931
932-- ----------------------------
933-- Auto increment value for aros
934-- ----------------------------
935ALTER TABLE `aros` AUTO_INCREMENT=4;
936
937-- ----------------------------
938-- Auto increment value for billing_accounts
939-- ----------------------------
940ALTER TABLE `billing_accounts` AUTO_INCREMENT=1;
941
942-- ----------------------------
943-- Auto increment value for billing_items
944-- ----------------------------
945ALTER TABLE `billing_items` AUTO_INCREMENT=1;
946
947-- ----------------------------
948-- Auto increment value for billing_price_list_items
949-- ----------------------------
950ALTER TABLE `billing_price_list_items` AUTO_INCREMENT=1;
951
952-- ----------------------------
953-- Auto increment value for billing_price_lists
954-- ----------------------------
955ALTER TABLE `billing_price_lists` AUTO_INCREMENT=1;
956
957-- ----------------------------
958-- Auto increment value for client_statuses
959-- ----------------------------
960ALTER TABLE `client_statuses` AUTO_INCREMENT=28;
961
962-- ----------------------------
963-- Auto increment value for config
964-- ----------------------------
965ALTER TABLE `config` AUTO_INCREMENT=103;
966
967-- ----------------------------
968-- Auto increment value for contacts
969-- ----------------------------
970ALTER TABLE `contacts` AUTO_INCREMENT=320;
971
972-- ----------------------------
973-- Auto increment value for currencies
974-- ----------------------------
975ALTER TABLE `currencies` AUTO_INCREMENT=6;
976
977-- ----------------------------
978-- Auto increment value for documents
979-- ----------------------------
980ALTER TABLE `documents` AUTO_INCREMENT=1;
981
982-- ----------------------------
983-- Auto increment value for exchange_rates
984-- ----------------------------
985ALTER TABLE `exchange_rates` AUTO_INCREMENT=5;
986
987-- ----------------------------
988-- Auto increment value for favorites
989-- ----------------------------
990ALTER TABLE `favorites` AUTO_INCREMENT=1;
991
992-- ----------------------------
993-- Auto increment value for invoice_items
994-- ----------------------------
995ALTER TABLE `invoice_items` AUTO_INCREMENT=1;
996
997-- ----------------------------
998-- Auto increment value for invoices
999-- ----------------------------
1000ALTER TABLE `invoices` AUTO_INCREMENT=1;
1001
1002-- ----------------------------
1003-- Auto increment value for languages
1004-- ----------------------------
1005ALTER TABLE `languages` AUTO_INCREMENT=3;
1006
1007-- ----------------------------
1008-- Auto increment value for logs
1009-- ----------------------------
1010ALTER TABLE `logs` AUTO_INCREMENT=1;
1011
1012-- ----------------------------
1013-- Auto increment value for menu
1014-- ----------------------------
1015ALTER TABLE `menu` AUTO_INCREMENT=39;
1016
1017-- ----------------------------
1018-- Auto increment value for messages
1019-- ----------------------------
1020ALTER TABLE `messages` AUTO_INCREMENT=1;
1021
1022-- ----------------------------
1023-- Auto increment value for products
1024-- ----------------------------
1025ALTER TABLE `products` AUTO_INCREMENT=1;
1026
1027-- ----------------------------
1028-- Auto increment value for projects
1029-- ----------------------------
1030ALTER TABLE `projects` AUTO_INCREMENT=1;
1031
1032-- ----------------------------
1033-- Auto increment value for recents
1034-- ----------------------------
1035ALTER TABLE `recents` AUTO_INCREMENT=1;
1036
1037-- ----------------------------
1038-- Auto increment value for roles
1039-- ----------------------------
1040ALTER TABLE `roles` AUTO_INCREMENT=1;
1041
1042-- ----------------------------
1043-- Auto increment value for suit_priorities
1044-- ----------------------------
1045ALTER TABLE `suit_priorities` AUTO_INCREMENT=4;
1046
1047-- ----------------------------
1048-- Auto increment value for suit_types
1049-- ----------------------------
1050ALTER TABLE `suit_types` AUTO_INCREMENT=19;
1051
1052-- ----------------------------
1053-- Auto increment value for suits
1054-- ----------------------------
1055ALTER TABLE `suits` AUTO_INCREMENT=1;
1056
1057-- ----------------------------
1058-- Auto increment value for taxes
1059-- ----------------------------
1060ALTER TABLE `taxes` AUTO_INCREMENT=102;
1061
1062-- ----------------------------
1063-- Auto increment value for users
1064-- ----------------------------
1065ALTER TABLE `users` AUTO_INCREMENT=4;