API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 5th, 2015
1,546
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 151.44 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. Navicat MySQL Data Transfer
  3.  
  4. Source Server         : localhost
  5. Source Server Version : 50617
  6. Source Host           : localhost:3306
  7. Source Database       : mojspis
  8.  
  9. Target Server Type    : MYSQL
  10. Target Server Version : 50617
  11. File Encoding         : 65001
  12.  
  13. Date: 2014-12-12 14:59:56
  14. */
  15.  
  16. SET FOREIGN_KEY_CHECKS=0;
  17.  
  18. -- ----------------------------
  19. -- Table structure for acos
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `acos`;
  22. CREATE TABLE `acos` (
  23. `id`  INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
  24. `name`  VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  25. PRIMARY KEY (`id`)
  26. )
  27. ENGINE=InnoDB
  28. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  29. AUTO_INCREMENT=70
  30.  
  31. ;
  32.  
  33. -- ----------------------------
  34. -- Records of acos
  35. -- ----------------------------
  36. BEGIN;
  37. INSERT 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');
  38. COMMIT;
  39.  
  40. -- ----------------------------
  41. -- Table structure for acos_aros
  42. -- ----------------------------
  43. DROP TABLE IF EXISTS `acos_aros`;
  44. CREATE 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 ,
  49. PRIMARY KEY (`id`)
  50. )
  51. ENGINE=InnoDB
  52. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  53. AUTO_INCREMENT=208
  54.  
  55. ;
  56.  
  57. -- ----------------------------
  58. -- Records of acos_aros
  59. -- ----------------------------
  60. BEGIN;
  61. INSERT 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');
  62. INSERT 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');
  63. INSERT 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');
  64. COMMIT;
  65.  
  66. -- ----------------------------
  67. -- Table structure for activities
  68. -- ----------------------------
  69. DROP TABLE IF EXISTS `activities`;
  70. CREATE 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 ,
  93. PRIMARY KEY (`id`)
  94. )
  95. ENGINE=InnoDB
  96. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  97. AUTO_INCREMENT=1
  98.  
  99. ;
  100.  
  101. -- ----------------------------
  102. -- Records of activities
  103. -- ----------------------------
  104. BEGIN;
  105. COMMIT;
  106.  
  107. -- ----------------------------
  108. -- Table structure for aros
  109. -- ----------------------------
  110. DROP TABLE IF EXISTS `aros`;
  111. CREATE TABLE `aros` (
  112. `id`  INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
  113. `alias`  VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  114. PRIMARY KEY (`id`)
  115. )
  116. ENGINE=InnoDB
  117. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  118. AUTO_INCREMENT=4
  119.  
  120. ;
  121.  
  122. -- ----------------------------
  123. -- Records of aros
  124. -- ----------------------------
  125. BEGIN;
  126. INSERT INTO `aros` VALUES ('1', 'Administrator'), ('2', 'User'), ('3', 'Guest');
  127. COMMIT;
  128.  
  129. -- ----------------------------
  130. -- Table structure for billing_accounts
  131. -- ----------------------------
  132. DROP TABLE IF EXISTS `billing_accounts`;
  133. CREATE 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 ,
  144. PRIMARY KEY (`id`)
  145. )
  146. ENGINE=InnoDB
  147. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  148. AUTO_INCREMENT=1
  149.  
  150. ;
  151.  
  152. -- ----------------------------
  153. -- Records of billing_accounts
  154. -- ----------------------------
  155. BEGIN;
  156. COMMIT;
  157.  
  158. -- ----------------------------
  159. -- Table structure for billing_items
  160. -- ----------------------------
  161. DROP TABLE IF EXISTS `billing_items`;
  162. CREATE 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 ,
  183. PRIMARY KEY (`id`)
  184. )
  185. ENGINE=InnoDB
  186. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  187. AUTO_INCREMENT=1
  188.  
  189. ;
  190.  
  191. -- ----------------------------
  192. -- Records of billing_items
  193. -- ----------------------------
  194. BEGIN;
  195. COMMIT;
  196.  
  197. -- ----------------------------
  198. -- Table structure for billing_price_list_items
  199. -- ----------------------------
  200. DROP TABLE IF EXISTS `billing_price_list_items`;
  201. CREATE 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 ,
  207. PRIMARY KEY (`id`)
  208. )
  209. ENGINE=InnoDB
  210. DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
  211. AUTO_INCREMENT=1
  212.  
  213. ;
  214.  
  215. -- ----------------------------
  216. -- Records of billing_price_list_items
  217. -- ----------------------------
  218. BEGIN;
  219. COMMIT;
  220.  
  221. -- ----------------------------
  222. -- Table structure for billing_price_lists
  223. -- ----------------------------
  224. DROP TABLE IF EXISTS `billing_price_lists`;
  225. CREATE 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 ,
  229. PRIMARY KEY (`id`)
  230. )
  231. ENGINE=InnoDB
  232. DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
  233. AUTO_INCREMENT=1
  234.  
  235. ;
  236.  
  237. -- ----------------------------
  238. -- Records of billing_price_lists
  239. -- ----------------------------
  240. BEGIN;
  241. COMMIT;
  242.  
  243. -- ----------------------------
  244. -- Table structure for client_statuses
  245. -- ----------------------------
  246. DROP TABLE IF EXISTS `client_statuses`;
  247. CREATE 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 ,
  252. PRIMARY KEY (`id`)
  253. )
  254. ENGINE=InnoDB
  255. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  256. AUTO_INCREMENT=28
  257.  
  258. ;
  259.  
  260. -- ----------------------------
  261. -- Records of client_statuses
  262. -- ----------------------------
  263. BEGIN;
  264. INSERT 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');
  265. COMMIT;
  266.  
  267. -- ----------------------------
  268. -- Table structure for config
  269. -- ----------------------------
  270. DROP TABLE IF EXISTS `config`;
  271. CREATE 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 ,
  280. PRIMARY KEY (`id`)
  281. )
  282. ENGINE=InnoDB
  283. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  284. AUTO_INCREMENT=103
  285.  
  286. ;
  287.  
  288. -- ----------------------------
  289. -- Records of config
  290. -- ----------------------------
  291. BEGIN;
  292. INSERT 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);
  293. COMMIT;
  294.  
  295. -- ----------------------------
  296. -- Table structure for contacts
  297. -- ----------------------------
  298. DROP TABLE IF EXISTS `contacts`;
  299. CREATE 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 ,
  334. PRIMARY KEY (`id`)
  335. )
  336. ENGINE=InnoDB
  337. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  338. AUTO_INCREMENT=320
  339.  
  340. ;
  341.  
  342. -- ----------------------------
  343. -- Records of contacts
  344. -- ----------------------------
  345. BEGIN;
  346. INSERT 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');
  347. INSERT 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');
  348. INSERT 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');
  349. COMMIT;
  350.  
  351. -- ----------------------------
  352. -- Table structure for currencies
  353. -- ----------------------------
  354. DROP TABLE IF EXISTS `currencies`;
  355. CREATE 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 ,
  359. PRIMARY KEY (`id`)
  360. )
  361. ENGINE=InnoDB
  362. DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
  363. AUTO_INCREMENT=6
  364.  
  365. ;
  366.  
  367. -- ----------------------------
  368. -- Records of currencies
  369. -- ----------------------------
  370. BEGIN;
  371. INSERT INTO `currencies` VALUES ('1', 'Croatian Kuna', 'HRK'), ('2', 'Euro', 'EUR'), ('5', 'United States Dollar', 'USD');
  372. COMMIT;
  373.  
  374. -- ----------------------------
  375. -- Table structure for documents
  376. -- ----------------------------
  377. DROP TABLE IF EXISTS `documents`;
  378. CREATE 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 ,
  388. PRIMARY KEY (`id`)
  389. )
  390. ENGINE=InnoDB
  391. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  392. AUTO_INCREMENT=1
  393.  
  394. ;
  395.  
  396. -- ----------------------------
  397. -- Records of documents
  398. -- ----------------------------
  399. BEGIN;
  400. COMMIT;
  401.  
  402. -- ----------------------------
  403. -- Table structure for exchange_rates
  404. -- ----------------------------
  405. DROP TABLE IF EXISTS `exchange_rates`;
  406. CREATE 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 ,
  411. PRIMARY KEY (`id`)
  412. )
  413. ENGINE=InnoDB
  414. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  415. AUTO_INCREMENT=5
  416.  
  417. ;
  418.  
  419. -- ----------------------------
  420. -- Records of exchange_rates
  421. -- ----------------------------
  422. BEGIN;
  423. INSERT 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');
  424. COMMIT;
  425.  
  426. -- ----------------------------
  427. -- Table structure for favorites
  428. -- ----------------------------
  429. DROP TABLE IF EXISTS `favorites`;
  430. CREATE 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 ,
  435. PRIMARY KEY (`id`)
  436. )
  437. ENGINE=InnoDB
  438. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  439. AUTO_INCREMENT=1
  440.  
  441. ;
  442.  
  443. -- ----------------------------
  444. -- Records of favorites
  445. -- ----------------------------
  446. BEGIN;
  447. COMMIT;
  448.  
  449. -- ----------------------------
  450. -- Table structure for invoice_items
  451. -- ----------------------------
  452. DROP TABLE IF EXISTS `invoice_items`;
  453. CREATE 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 ,
  486. PRIMARY KEY (`id`)
  487. )
  488. ENGINE=InnoDB
  489. DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
  490. AUTO_INCREMENT=1
  491.  
  492. ;
  493.  
  494. -- ----------------------------
  495. -- Records of invoice_items
  496. -- ----------------------------
  497. BEGIN;
  498. COMMIT;
  499.  
  500. -- ----------------------------
  501. -- Table structure for invoices
  502. -- ----------------------------
  503. DROP TABLE IF EXISTS `invoices`;
  504. CREATE 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 ,
  542. PRIMARY KEY (`id`)
  543. )
  544. ENGINE=InnoDB
  545. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  546. AUTO_INCREMENT=1
  547.  
  548. ;
  549.  
  550. -- ----------------------------
  551. -- Records of invoices
  552. -- ----------------------------
  553. BEGIN;
  554. COMMIT;
  555.  
  556. -- ----------------------------
  557. -- Table structure for languages
  558. -- ----------------------------
  559. DROP TABLE IF EXISTS `languages`;
  560. CREATE 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 ,
  566. PRIMARY KEY (`id`)
  567. )
  568. ENGINE=InnoDB
  569. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  570. AUTO_INCREMENT=3
  571.  
  572. ;
  573.  
  574. -- ----------------------------
  575. -- Records of languages
  576. -- ----------------------------
  577. BEGIN;
  578. INSERT 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');
  579. COMMIT;
  580.  
  581. -- ----------------------------
  582. -- Table structure for logs
  583. -- ----------------------------
  584. DROP TABLE IF EXISTS `logs`;
  585. CREATE 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 ,
  594. PRIMARY KEY (`id`)
  595. )
  596. ENGINE=InnoDB
  597. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  598. AUTO_INCREMENT=1
  599.  
  600. ;
  601.  
  602. -- ----------------------------
  603. -- Records of logs
  604. -- ----------------------------
  605. BEGIN;
  606. COMMIT;
  607.  
  608. -- ----------------------------
  609. -- Table structure for menu
  610. -- ----------------------------
  611. DROP TABLE IF EXISTS `menu`;
  612. CREATE 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 ,
  624. PRIMARY KEY (`id`)
  625. )
  626. ENGINE=InnoDB
  627. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  628. AUTO_INCREMENT=39
  629.  
  630. ;
  631.  
  632. -- ----------------------------
  633. -- Records of menu
  634. -- ----------------------------
  635. BEGIN;
  636. INSERT 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');
  637. COMMIT;
  638.  
  639. -- ----------------------------
  640. -- Table structure for messages
  641. -- ----------------------------
  642. DROP TABLE IF EXISTS `messages`;
  643. CREATE 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 ,
  652. PRIMARY KEY (`id`)
  653. )
  654. ENGINE=InnoDB
  655. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  656. AUTO_INCREMENT=1
  657.  
  658. ;
  659.  
  660. -- ----------------------------
  661. -- Records of messages
  662. -- ----------------------------
  663. BEGIN;
  664. COMMIT;
  665.  
  666. -- ----------------------------
  667. -- Table structure for products
  668. -- ----------------------------
  669. DROP TABLE IF EXISTS `products`;
  670. CREATE 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 ,
  675. PRIMARY KEY (`id`)
  676. )
  677. ENGINE=InnoDB
  678. DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
  679. AUTO_INCREMENT=1
  680.  
  681. ;
  682.  
  683. -- ----------------------------
  684. -- Records of products
  685. -- ----------------------------
  686. BEGIN;
  687. COMMIT;
  688.  
  689. -- ----------------------------
  690. -- Table structure for projects
  691. -- ----------------------------
  692. DROP TABLE IF EXISTS `projects`;
  693. CREATE 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 ,
  703. PRIMARY KEY (`id`)
  704. )
  705. ENGINE=InnoDB
  706. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  707. AUTO_INCREMENT=1
  708.  
  709. ;
  710.  
  711. -- ----------------------------
  712. -- Records of projects
  713. -- ----------------------------
  714. BEGIN;
  715. COMMIT;
  716.  
  717. -- ----------------------------
  718. -- Table structure for recents
  719. -- ----------------------------
  720. DROP TABLE IF EXISTS `recents`;
  721. CREATE 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 ,
  727. PRIMARY KEY (`id`)
  728. )
  729. ENGINE=InnoDB
  730. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  731. AUTO_INCREMENT=1
  732.  
  733. ;
  734.  
  735. -- ----------------------------
  736. -- Records of recents
  737. -- ----------------------------
  738. BEGIN;
  739. COMMIT;
  740.  
  741. -- ----------------------------
  742. -- Table structure for roles
  743. -- ----------------------------
  744. DROP TABLE IF EXISTS `roles`;
  745. CREATE 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 ,
  750. PRIMARY KEY (`id`)
  751. )
  752. ENGINE=InnoDB
  753. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  754. AUTO_INCREMENT=1
  755.  
  756. ;
  757.  
  758. -- ----------------------------
  759. -- Records of roles
  760. -- ----------------------------
  761. BEGIN;
  762. COMMIT;
  763.  
  764. -- ----------------------------
  765. -- Table structure for suit_priorities
  766. -- ----------------------------
  767. DROP TABLE IF EXISTS `suit_priorities`;
  768. CREATE 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 ,
  773. PRIMARY KEY (`id`)
  774. )
  775. ENGINE=InnoDB
  776. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  777. AUTO_INCREMENT=4
  778.  
  779. ;
  780.  
  781. -- ----------------------------
  782. -- Records of suit_priorities
  783. -- ----------------------------
  784. BEGIN;
  785. INSERT 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');
  786. COMMIT;
  787.  
  788. -- ----------------------------
  789. -- Table structure for suit_types
  790. -- ----------------------------
  791. DROP TABLE IF EXISTS `suit_types`;
  792. CREATE 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 ,
  797. PRIMARY KEY (`id`)
  798. )
  799. ENGINE=InnoDB
  800. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  801. AUTO_INCREMENT=19
  802.  
  803. ;
  804.  
  805. -- ----------------------------
  806. -- Records of suit_types
  807. -- ----------------------------
  808. BEGIN;
  809. INSERT 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');
  810. COMMIT;
  811.  
  812. -- ----------------------------
  813. -- Table structure for suits
  814. -- ----------------------------
  815. DROP TABLE IF EXISTS `suits`;
  816. CREATE 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 ,
  844. PRIMARY KEY (`id`)
  845. )
  846. ENGINE=InnoDB
  847. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  848. AUTO_INCREMENT=1
  849.  
  850. ;
  851.  
  852. -- ----------------------------
  853. -- Records of suits
  854. -- ----------------------------
  855. BEGIN;
  856. COMMIT;
  857.  
  858. -- ----------------------------
  859. -- Table structure for taxes
  860. -- ----------------------------
  861. DROP TABLE IF EXISTS `taxes`;
  862. CREATE 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 ,
  868. PRIMARY KEY (`id`)
  869. )
  870. ENGINE=InnoDB
  871. DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
  872. AUTO_INCREMENT=102
  873.  
  874. ;
  875.  
  876. -- ----------------------------
  877. -- Records of taxes
  878. -- ----------------------------
  879. BEGIN;
  880. INSERT 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);
  881. INSERT INTO `taxes` VALUES ('101', 'PDV 100%', '1', NULL, NULL);
  882. COMMIT;
  883.  
  884. -- ----------------------------
  885. -- Table structure for users
  886. -- ----------------------------
  887. DROP TABLE IF EXISTS `users`;
  888. CREATE 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 ,
  902. PRIMARY KEY (`id`)
  903. )
  904. ENGINE=InnoDB
  905. DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  906. AUTO_INCREMENT=4
  907.  
  908. ;
  909.  
  910. -- ----------------------------
  911. -- Records of users
  912. -- ----------------------------
  913. BEGIN;
  914. INSERT 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');
  915. COMMIT;
  916.  
  917. -- ----------------------------
  918. -- Auto increment value for acos
  919. -- ----------------------------
  920. ALTER TABLE `acos` AUTO_INCREMENT=70;
  921.  
  922. -- ----------------------------
  923. -- Auto increment value for acos_aros
  924. -- ----------------------------
  925. ALTER TABLE `acos_aros` AUTO_INCREMENT=208;
  926.  
  927. -- ----------------------------
  928. -- Auto increment value for activities
  929. -- ----------------------------
  930. ALTER TABLE `activities` AUTO_INCREMENT=1;
  931.  
  932. -- ----------------------------
  933. -- Auto increment value for aros
  934. -- ----------------------------
  935. ALTER TABLE `aros` AUTO_INCREMENT=4;
  936.  
  937. -- ----------------------------
  938. -- Auto increment value for billing_accounts
  939. -- ----------------------------
  940. ALTER TABLE `billing_accounts` AUTO_INCREMENT=1;
  941.  
  942. -- ----------------------------
  943. -- Auto increment value for billing_items
  944. -- ----------------------------
  945. ALTER TABLE `billing_items` AUTO_INCREMENT=1;
  946.  
  947. -- ----------------------------
  948. -- Auto increment value for billing_price_list_items
  949. -- ----------------------------
  950. ALTER TABLE `billing_price_list_items` AUTO_INCREMENT=1;
  951.  
  952. -- ----------------------------
  953. -- Auto increment value for billing_price_lists
  954. -- ----------------------------
  955. ALTER TABLE `billing_price_lists` AUTO_INCREMENT=1;
  956.  
  957. -- ----------------------------
  958. -- Auto increment value for client_statuses
  959. -- ----------------------------
  960. ALTER TABLE `client_statuses` AUTO_INCREMENT=28;
  961.  
  962. -- ----------------------------
  963. -- Auto increment value for config
  964. -- ----------------------------
  965. ALTER TABLE `config` AUTO_INCREMENT=103;
  966.  
  967. -- ----------------------------
  968. -- Auto increment value for contacts
  969. -- ----------------------------
  970. ALTER TABLE `contacts` AUTO_INCREMENT=320;
  971.  
  972. -- ----------------------------
  973. -- Auto increment value for currencies
  974. -- ----------------------------
  975. ALTER TABLE `currencies` AUTO_INCREMENT=6;
  976.  
  977. -- ----------------------------
  978. -- Auto increment value for documents
  979. -- ----------------------------
  980. ALTER TABLE `documents` AUTO_INCREMENT=1;
  981.  
  982. -- ----------------------------
  983. -- Auto increment value for exchange_rates
  984. -- ----------------------------
  985. ALTER TABLE `exchange_rates` AUTO_INCREMENT=5;
  986.  
  987. -- ----------------------------
  988. -- Auto increment value for favorites
  989. -- ----------------------------
  990. ALTER TABLE `favorites` AUTO_INCREMENT=1;
  991.  
  992. -- ----------------------------
  993. -- Auto increment value for invoice_items
  994. -- ----------------------------
  995. ALTER TABLE `invoice_items` AUTO_INCREMENT=1;
  996.  
  997. -- ----------------------------
  998. -- Auto increment value for invoices
  999. -- ----------------------------
  1000. ALTER TABLE `invoices` AUTO_INCREMENT=1;
  1001.  
  1002. -- ----------------------------
  1003. -- Auto increment value for languages
  1004. -- ----------------------------
  1005. ALTER TABLE `languages` AUTO_INCREMENT=3;
  1006.  
  1007. -- ----------------------------
  1008. -- Auto increment value for logs
  1009. -- ----------------------------
  1010. ALTER TABLE `logs` AUTO_INCREMENT=1;
  1011.  
  1012. -- ----------------------------
  1013. -- Auto increment value for menu
  1014. -- ----------------------------
  1015. ALTER TABLE `menu` AUTO_INCREMENT=39;
  1016.  
  1017. -- ----------------------------
  1018. -- Auto increment value for messages
  1019. -- ----------------------------
  1020. ALTER TABLE `messages` AUTO_INCREMENT=1;
  1021.  
  1022. -- ----------------------------
  1023. -- Auto increment value for products
  1024. -- ----------------------------
  1025. ALTER TABLE `products` AUTO_INCREMENT=1;
  1026.  
  1027. -- ----------------------------
  1028. -- Auto increment value for projects
  1029. -- ----------------------------
  1030. ALTER TABLE `projects` AUTO_INCREMENT=1;
  1031.  
  1032. -- ----------------------------
  1033. -- Auto increment value for recents
  1034. -- ----------------------------
  1035. ALTER TABLE `recents` AUTO_INCREMENT=1;
  1036.  
  1037. -- ----------------------------
  1038. -- Auto increment value for roles
  1039. -- ----------------------------
  1040. ALTER TABLE `roles` AUTO_INCREMENT=1;
  1041.  
  1042. -- ----------------------------
  1043. -- Auto increment value for suit_priorities
  1044. -- ----------------------------
  1045. ALTER TABLE `suit_priorities` AUTO_INCREMENT=4;
  1046.  
  1047. -- ----------------------------
  1048. -- Auto increment value for suit_types
  1049. -- ----------------------------
  1050. ALTER TABLE `suit_types` AUTO_INCREMENT=19;
  1051.  
  1052. -- ----------------------------
  1053. -- Auto increment value for suits
  1054. -- ----------------------------
  1055. ALTER TABLE `suits` AUTO_INCREMENT=1;
  1056.  
  1057. -- ----------------------------
  1058. -- Auto increment value for taxes
  1059. -- ----------------------------
  1060. ALTER TABLE `taxes` AUTO_INCREMENT=102;
  1061.  
  1062. -- ----------------------------
  1063. -- Auto increment value for users
  1064. -- ----------------------------
  1065. ALTER TABLE `users` AUTO_INCREMENT=4;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!