Advertisement
M3GAFAB

Serbian Government Owned - Part 1

Feb 17th, 2014
1,123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 108.88 KB | None | 0 0
  1. ______ _
  2. | ___ \ | |
  3. | |_/ /__ _ __ | |_ __ _ __ _ ___ _ __
  4. | __/ _ \ '_ \| __/ _` |/ _` |/ _ \| '_ \
  5. | | | __/ | | | || (_| | (_| | (_) | | | |#PentaSeC
  6. \_| \___|_| |_|\__\__,_|\__, |\___/|_| |_|#KosovaHackersSecurity.
  7. __/ |
  8. |___/
  9.  
  10. _____ _____
  11. / __ \ |____ |
  12. | / \/_ __ / /_ __
  13. | | | '__| \ \ \ /\ / /
  14. | \__/\ | .___/ /\ V V / #Kosovo6Years
  15. \____/_| \____/ \_/\_/ #LongLiveKOSOVO-ALBANIA.
  16.  
  17. ___________________________________________________________________________________________________
  18.  
  19.  
  20. __ ____ ______ ____ ______ ____
  21. /'\_/`\ /'__`\ /\ _`\ /\ _ \/\ _`\ /\ _ \/\ _`\
  22. /\ \/\_\L\ \\ \ \L\_\ \ \L\ \ \ \L\_\ \ \L\ \ \ \L\ \
  23. \ \ \__\ \/_/_\_<_\ \ \L_L\ \ __ \ \ _\/\ \ __ \ \ _ <'
  24. \ \ \_/\ \/\ \L\ \\ \ \/, \ \ \/\ \ \ \/ \ \ \/\ \ \ \L\ \
  25. \ \_\\ \_\ \____/ \ \____/\ \_\ \_\ \_\ \ \_\ \_\ \____/#Part 1.
  26. \/_/ \/_/\/___/ \/___/ \/_/\/_/\/_/ \/_/\/_/\/___/ #MyLastDay./
  27.  
  28. _____________________________________________________________________________________________________
  29.  
  30.  
  31. Target : www.mpt.gov.rs
  32.  
  33. Database: scms_minpolj_final
  34. Table: language
  35. [8 columns]
  36. +------------+-------------+
  37. | Column | Type |
  38. +------------+-------------+
  39. | active | int(1) |
  40. | created | datetime |
  41. | creator | int(11) |
  42. | id | int(11) |
  43. | modified | datetime |
  44. | modifier | int(11) |
  45. | name | varchar(20) |
  46. | short_name | varchar(3) |
  47. +------------+-------------+
  48.  
  49. Database: scms_minpolj_final
  50. Table: forum
  51. [9 columns]
  52. +--------------+----------+
  53. | Column | Type |
  54. +--------------+----------+
  55. | active | int(1) |
  56. | categorie_id | int(11) |
  57. | created | datetime |
  58. | creator | int(11) |
  59. | id | int(11) |
  60. | modified | datetime |
  61. | modifier | int(11) |
  62. | parent_id | int(11) |
  63. | text | text |
  64. +--------------+----------+
  65.  
  66. Database: scms_minpolj_final
  67. Table: core_widgets
  68. [8 columns]
  69. +----------+--------------+
  70. | Column | Type |
  71. +----------+--------------+
  72. | created | datetime |
  73. | creator | int(11) |
  74. | id | int(11) |
  75. | modified | datetime |
  76. | modifier | int(11) |
  77. | name | varchar(256) |
  78. | type | varchar(10) |
  79. | uses | varchar(256) |
  80. +----------+--------------+
  81.  
  82. Database: scms_minpolj_final
  83. Table: utils
  84. [9 columns]
  85. +-----------+-------------+
  86. | Column | Type |
  87. +-----------+-------------+
  88. | active | int(1) |
  89. | created | datetime |
  90. | creator | int(11) |
  91. | id | int(11) |
  92. | modified | datetime |
  93. | modifier | int(11) |
  94. | name | varchar(50) |
  95. | options | tinytext |
  96. | real_name | varchar(50) |
  97. +-----------+-------------+
  98.  
  99. Database: scms_minpolj_final
  100. Table: addressbook
  101. [17 columns]
  102. +----------------+---------------------------+
  103. | Column | Type |
  104. +----------------+---------------------------+
  105. | language | varchar(3) |
  106. | no | int(11) |
  107. | active | int(1) |
  108. | address | tinytext |
  109. | addressbook_id | int(11) unsigned zerofill |
  110. | categorie_id | int(11) |
  111. | contact | varchar(256) |
  112. | created | datetime |
  113. | creator | int(11) |
  114. | description | varchar(256) |
  115. | filename | varchar(256) |
  116. | id | int(11) |
  117. | mail | varchar(256) |
  118. | modified | datetime |
  119. | modifier | int(11) |
  120. | name | varchar(256) |
  121. | website | varchar(256) |
  122. +----------------+---------------------------+
  123.  
  124. Database: scms_minpolj_final
  125. Table: friendship_requests
  126. [5 columns]
  127. +----------+-----------+
  128. | Column | Type |
  129. +----------+-----------+
  130. | created | timestamp |
  131. | creator | int(11) |
  132. | id | int(11) |
  133. | user_one | int(11) |
  134. | user_two | int(11) |
  135. +----------+-----------+
  136.  
  137. Database: scms_minpolj_final
  138. Table: article_photos
  139. [7 columns]
  140. +--------------+--------------+
  141. | Column | Type |
  142. +--------------+--------------+
  143. | no | int(11) |
  144. | categorie_id | int(11) |
  145. | created | datetime |
  146. | creator | int(11) |
  147. | id | int(11) |
  148. | name | varchar(256) |
  149. | number | int(11) |
  150. +--------------+--------------+
  151.  
  152. Database: scms_minpolj_final
  153. Table: reports
  154. [7 columns]
  155. +-------------+-------------+
  156. | Column | Type |
  157. +-------------+-------------+
  158. | created | datetime |
  159. | creator | int(11) |
  160. | description | tinytext |
  161. | id | int(11) |
  162. | rel_id | int(11) |
  163. | rel_page | varchar(36) |
  164. | type | varchar(15) |
  165. +-------------+-------------+
  166.  
  167. Database: scms_minpolj_final
  168. Table: tips_categories
  169. [13 columns]
  170. +-------------+---------------+
  171. | Column | Type |
  172. +-------------+---------------+
  173. | language | varchar(3) |
  174. | no | int(11) |
  175. | active | int(1) |
  176. | created | datetime |
  177. | creator | int(11) |
  178. | description | varchar(500) |
  179. | id | int(11) |
  180. | image | varchar(50) |
  181. | modified | datetime |
  182. | modifier | int(11) |
  183. | name | varchar(256) |
  184. | options | varchar(1000) |
  185. | parent_id | int(11) |
  186. +-------------+---------------+
  187.  
  188. Database: scms_minpolj_final
  189. Table: newsletter
  190. [4 columns]
  191. +----------+--------------+
  192. | Column | Type |
  193. +----------+--------------+
  194. | language | varchar(3) |
  195. | active | tinyint(1) |
  196. | email | varchar(150) |
  197. | id | int(11) |
  198. +----------+--------------+
  199.  
  200. Database: scms_minpolj_final
  201. Table: messanger_trash
  202. [7 columns]
  203. +---------+--------------+
  204. | Column | Type |
  205. +---------+--------------+
  206. | created | timestamp |
  207. | creator | int(11) |
  208. | id | int(11) |
  209. | name | varchar(250) |
  210. | readed | int(1) |
  211. | sent_to | int(11) |
  212. | text | text |
  213. +---------+--------------+
  214.  
  215. Database: scms_minpolj_final
  216. Table: omladina_kdo
  217. [16 columns]
  218. +------------------------+--------------+
  219. | Column | Type |
  220. +------------------------+--------------+
  221. | active | int(1) |
  222. | adresa | varchar(150) |
  223. | broj_clanova_do | int(6) |
  224. | categorie_id | int(11) |
  225. | created | datetime |
  226. | creator | int(11) |
  227. | do_trideset | int(6) |
  228. | fax | varchar(12) |
  229. | id | int(11) |
  230. | mail | varchar(100) |
  231. | modified | datetime |
  232. | modifier | int(11) |
  233. | name | varchar(50) |
  234. | oo_do_trideset | int(6) |
  235. | poslednja_konferencija | date |
  236. | telefon | varchar(12) |
  237. +------------------------+--------------+
  238.  
  239. Database: scms_minpolj_final
  240. Table: documents
  241. [14 columns]
  242. +--------------+---------------+
  243. | Column | Type |
  244. +--------------+---------------+
  245. | language | varchar(13) |
  246. | no | int(11) |
  247. | size | varchar(10) |
  248. | active | int(1) |
  249. | categorie_id | int(11) |
  250. | created | datetime |
  251. | creator | int(11) |
  252. | description | varchar(1000) |
  253. | id | int(11) |
  254. | meta | varchar(256) |
  255. | modified | datetime |
  256. | modifier | int(11) |
  257. | name | varchar(256) |
  258. | real_name | varchar(256) |
  259. +--------------+---------------+
  260.  
  261. Database: scms_minpolj_final
  262. Table: user_loged_in
  263. [7 columns]
  264. +-------------+--------------+
  265. | Column | Type |
  266. +-------------+--------------+
  267. | time | datetime |
  268. | id | int(11) |
  269. | id_user | int(11) |
  270. | ip | varchar(13) |
  271. | last_active | datetime |
  272. | session_id | varchar(40) |
  273. | username | varchar(256) |
  274. +-------------+--------------+
  275.  
  276. Database: scms_minpolj_final
  277. Table: menu
  278. [14 columns]
  279. +-----------+--------------+
  280. | Column | Type |
  281. +-----------+--------------+
  282. | language | varchar(3) |
  283. | no | int(11) |
  284. | active | int(1) |
  285. | created | datetime |
  286. | creator | int(11) |
  287. | id | int(11) |
  288. | image | varchar(100) |
  289. | link | varchar(256) |
  290. | menu_id | int(11) |
  291. | modified | datetime |
  292. | modifier | int(11) |
  293. | name | varchar(256) |
  294. | options | tinytext |
  295. | parent_id | int(11) |
  296. +-----------+--------------+
  297.  
  298. Database: scms_minpolj_final
  299. Table: baned_user_rels
  300. [7 columns]
  301. +-----------------+-------------+
  302. | Column | Type |
  303. +-----------------+-------------+
  304. | no | int(4) |
  305. | id | int(11) |
  306. | modified | datetime |
  307. | rel_custom_id | int(11) |
  308. | rel_custom_name | varchar(36) |
  309. | rel_id | int(11) |
  310. | rel_page | varchar(36) |
  311. +-----------------+-------------+
  312.  
  313. Database: scms_minpolj_final
  314. Table: user_profile
  315. [18 columns]
  316. +------------+--------------+
  317. | Column | Type |
  318. +------------+--------------+
  319. | date | date |
  320. | active | tinyint(1) |
  321. | avatar | varchar(256) |
  322. | blog | varchar(256) |
  323. | created | datetime |
  324. | creator | int(11) |
  325. | facebook | varchar(256) |
  326. | first_name | varchar(20) |
  327. | id | int(11) |
  328. | last_name | varchar(20) |
  329. | mail | varchar(256) |
  330. | modified | datetime |
  331. | modifier | int(11) |
  332. | phone | varchar(16) |
  333. | places_id | int(11) |
  334. | twitter | varchar(256) |
  335. | user_id | int(11) |
  336. | www | varchar(256) |
  337. +------------+--------------+
  338.  
  339. Database: scms_minpolj_final
  340. Table: addressbook_categories
  341. [12 columns]
  342. +-----------+---------------+
  343. | Column | Type |
  344. +-----------+---------------+
  345. | language | varchar(3) |
  346. | no | int(11) |
  347. | active | int(1) |
  348. | created | datetime |
  349. | creator | int(11) |
  350. | id | int(11) |
  351. | image | varchar(50) |
  352. | modified | datetime |
  353. | modifier | int(11) |
  354. | name | varchar(256) |
  355. | options | varchar(1000) |
  356. | parent_id | int(11) |
  357. +-----------+---------------+
  358.  
  359. Database: scms_minpolj_final
  360. Table: comments
  361. [14 columns]
  362. +-----------+--------------+
  363. | Column | Type |
  364. +-----------+--------------+
  365. | language | varchar(3) |
  366. | no | int(11) |
  367. | active | int(1) |
  368. | comment | tinytext |
  369. | created | datetime |
  370. | creator | int(11) |
  371. | id | int(11) |
  372. | mail | tinytext |
  373. | modified | datetime |
  374. | modifier | int(11) |
  375. | name | varchar(256) |
  376. | parent_id | int(11) |
  377. | rel_id | int(11) |
  378. | rel_name | varchar(15) |
  379. +-----------+--------------+
  380.  
  381. Database: scms_minpolj_final
  382. Table: admin_user_rels
  383. [7 columns]
  384. +-----------------+-------------+
  385. | Column | Type |
  386. +-----------------+-------------+
  387. | no | int(4) |
  388. | id | int(11) |
  389. | modified | datetime |
  390. | rel_custom_id | int(11) |
  391. | rel_custom_name | varchar(36) |
  392. | rel_id | int(11) |
  393. | rel_page | varchar(36) |
  394. +-----------------+-------------+
  395.  
  396. Database: scms_minpolj_final
  397. Table: blog
  398. [11 columns]
  399. +--------------+--------------+
  400. | Column | Type |
  401. +--------------+--------------+
  402. | active | int(1) |
  403. | categorie_id | int(11) |
  404. | created | datetime |
  405. | creator | int(11) |
  406. | description | tinytext |
  407. | id | int(11) |
  408. | meta | tinytext |
  409. | modified | datetime |
  410. | modifier | int(11) |
  411. | text | text |
  412. | title | varchar(256) |
  413. +--------------+--------------+
  414.  
  415. Database: scms_minpolj_final
  416. Table: user
  417. [10 columns]
  418. +----------+--------------+
  419. | Column | Type |
  420. +----------+--------------+
  421. | key | varchar(32) |
  422. | active | int(1) |
  423. | created | datetime |
  424. | creator | int(11) |
  425. | id | int(11) |
  426. | modified | datetime |
  427. | modifier | int(11) |
  428. | password | varchar(256) |
  429. | salt | varchar(256) |
  430. | username | varchar(18) |
  431. +----------+--------------+
  432.  
  433. Database: scms_minpolj_final
  434. Table: group_page_xref
  435. [5 columns]
  436. +----------+-------------+
  437. | Column | Type |
  438. +----------+-------------+
  439. | group_id | int(11) |
  440. | id | int(11) |
  441. | page | varchar(30) |
  442. | task | varchar(50) |
  443. | type | varchar(10) |
  444. +----------+-------------+
  445.  
  446. Database: scms_minpolj_final
  447. Table: tips
  448. [12 columns]
  449. +--------------+------------+
  450. | Column | Type |
  451. +--------------+------------+
  452. | language | varchar(3) |
  453. | no | int(11) |
  454. | active | int(1) |
  455. | categorie_id | int(11) |
  456. | created | datetime |
  457. | creator | int(11) |
  458. | id | int(11) |
  459. | meta | tinytext |
  460. | modified | datetime |
  461. | modifier | int(11) |
  462. | text | tinytext |
  463. | title | tinytext |
  464. +--------------+------------+
  465.  
  466. Database: scms_minpolj_final
  467. Table: rel_misc_gallery
  468. [4 columns]
  469. +-----------+-------------+
  470. | Column | Type |
  471. +-----------+-------------+
  472. | gal_id | int(11) |
  473. | id | int(11) |
  474. | rel_id | int(11) |
  475. | rel_table | varchar(50) |
  476. +-----------+-------------+
  477.  
  478. Database: scms_minpolj_final
  479. Table: messanger
  480. [7 columns]
  481. +---------+--------------+
  482. | Column | Type |
  483. +---------+--------------+
  484. | created | timestamp |
  485. | creator | int(11) |
  486. | id | int(11) |
  487. | name | varchar(250) |
  488. | readed | int(1) |
  489. | sent_to | int(11) |
  490. | text | text |
  491. +---------+--------------+
  492.  
  493. Database: scms_minpolj_final
  494. Table: core
  495. [3 columns]
  496. +--------+--------------+
  497. | Column | Type |
  498. +--------+--------------+
  499. | active | int(1) |
  500. | id | int(11) |
  501. | name | varchar(256) |
  502. +--------+--------------+
  503.  
  504. Database: scms_minpolj_final
  505. Table: rel_customs
  506. [7 columns]
  507. +-----------------+-------------+
  508. | Column | Type |
  509. +-----------------+-------------+
  510. | no | int(4) |
  511. | id | int(11) |
  512. | modified | datetime |
  513. | rel_custom_id | int(11) |
  514. | rel_custom_name | varchar(36) |
  515. | rel_id | int(11) |
  516. | rel_page | varchar(36) |
  517. +-----------------+-------------+
  518.  
  519. Database: scms_minpolj_final
  520. Table: banner_categories
  521. [12 columns]
  522. +-------------+--------------+
  523. | Column | Type |
  524. +-------------+--------------+
  525. | language | varchar(3) |
  526. | no | int(11) |
  527. | active | int(1) |
  528. | created | datetime |
  529. | creator | int(11) |
  530. | description | varchar(500) |
  531. | id | int(11) |
  532. | image | varchar(50) |
  533. | modified | datetime |
  534. | modifier | int(11) |
  535. | name | varchar(256) |
  536. | parent_id | int(11) |
  537. +-------------+--------------+
  538.  
  539. Database: scms_minpolj_final
  540. Table: gallery_categories
  541. [12 columns]
  542. +-------------+--------------+
  543. | Column | Type |
  544. +-------------+--------------+
  545. | language | varchar(3) |
  546. | no | int(11) |
  547. | active | int(1) |
  548. | created | datetime |
  549. | creator | int(11) |
  550. | description | varchar(500) |
  551. | id | int(11) |
  552. | image | varchar(50) |
  553. | modified | datetime |
  554. | modifier | int(11) |
  555. | name | varchar(256) |
  556. | parent_id | int(11) |
  557. +-------------+--------------+
  558.  
  559. Database: scms_minpolj_final
  560. Table: zadaci
  561. [8 columns]
  562. +----------+--------------+
  563. | Column | Type |
  564. +----------+--------------+
  565. | no | int(11) |
  566. | created | datetime |
  567. | creator | int(11) |
  568. | id | int(11) |
  569. | modified | datetime |
  570. | modifier | int(11) |
  571. | name | varchar(256) |
  572. | stav | tinytext |
  573. +----------+--------------+
  574.  
  575. Database: scms_minpolj_final
  576. Table: pages
  577. [4 columns]
  578. +---------+--------------+
  579. | Column | Type |
  580. +---------+--------------+
  581. | active | int(1) |
  582. | id | int(11) |
  583. | name | varchar(256) |
  584. | visible | tinyint(4) |
  585. +---------+--------------+
  586.  
  587. Database: scms_minpolj_final
  588. Table: suspended_groups_rels
  589. [7 columns]
  590. +-----------------+-------------+
  591. | Column | Type |
  592. +-----------------+-------------+
  593. | no | int(4) |
  594. | id | int(11) |
  595. | modified | datetime |
  596. | rel_custom_id | int(11) |
  597. | rel_custom_name | varchar(36) |
  598. | rel_id | int(11) |
  599. | rel_page | varchar(36) |
  600. +-----------------+-------------+
  601.  
  602. Database: scms_minpolj_final
  603. Table: user_groups
  604. [9 columns]
  605. +-------------+--------------+
  606. | Column | Type |
  607. +-------------+--------------+
  608. | active | int(1) |
  609. | created | datetime |
  610. | creator | int(11) |
  611. | description | varchar(256) |
  612. | id | int(11) |
  613. | modified | datetime |
  614. | modifier | int(11) |
  615. | name | varchar(256) |
  616. | type | int(1) |
  617. +-------------+--------------+
  618.  
  619. Database: scms_minpolj_final
  620. Table: user_fan_group
  621. [7 columns]
  622. +-----------------+-------------+
  623. | Column | Type |
  624. +-----------------+-------------+
  625. | no | int(4) |
  626. | id | int(11) |
  627. | modified | datetime |
  628. | rel_custom_id | int(11) |
  629. | rel_custom_name | varchar(36) |
  630. | rel_id | int(11) |
  631. | rel_page | varchar(36) |
  632. +-----------------+-------------+
  633.  
  634. Database: scms_minpolj_final
  635. Table: rel_user_group
  636. [3 columns]
  637. +--------------+---------+
  638. | Column | Type |
  639. +--------------+---------+
  640. | id | int(11) |
  641. | id_rel_group | int(11) |
  642. | id_rel_user | int(11) |
  643. +--------------+---------+
  644.  
  645. Database: scms_minpolj_final
  646. Table: fan_groups_reported
  647. [3 columns]
  648. +---------+-------------+
  649. | Column | Type |
  650. +---------+-------------+
  651. | id | int(11) |
  652. | ip | varchar(15) |
  653. | user_id | int(11) |
  654. +---------+-------------+
  655.  
  656. Database: scms_minpolj_final
  657. Table: fan_groups
  658. [10 columns]
  659. +--------------+-------------+
  660. | Column | Type |
  661. +--------------+-------------+
  662. | active | int(1) |
  663. | categorie_id | int(11) |
  664. | comment | text |
  665. | created | datetime |
  666. | creator | int(11) |
  667. | id | int(11) |
  668. | modified | datetime |
  669. | modifier | int(11) |
  670. | text | tinytext |
  671. | type | varchar(11) |
  672. +--------------+-------------+
  673.  
  674. Database: scms_minpolj_final
  675. Table: mediji
  676. [9 columns]
  677. +----------+---------------+
  678. | Column | Type |
  679. +----------+---------------+
  680. | no | int(11) |
  681. | created | datetime |
  682. | creator | int(11) |
  683. | id | int(11) |
  684. | link | varchar(1000) |
  685. | modified | datetime |
  686. | modifier | int(11) |
  687. | name | varchar(256) |
  688. | regex | varchar(256) |
  689. +----------+---------------+
  690.  
  691. Database: scms_minpolj_final
  692. Table: rel_widgets_menus
  693. [3 columns]
  694. +-----------+---------+
  695. | Column | Type |
  696. +-----------+---------+
  697. | id | int(11) |
  698. | menu_id | int(11) |
  699. | widget_id | int(11) |
  700. +-----------+---------+
  701.  
  702. Database: scms_minpolj_final
  703. Table: gallery
  704. [11 columns]
  705. +--------------+--------------+
  706. | Column | Type |
  707. +--------------+--------------+
  708. | language | varchar(50) |
  709. | no | int(11) |
  710. | size | varchar(50) |
  711. | active | tinyint(4) |
  712. | categorie_id | int(11) |
  713. | created | datetime |
  714. | creator | int(11) |
  715. | description | varchar(50) |
  716. | id | int(11) |
  717. | name | varchar(256) |
  718. | title | varchar(256) |
  719. +--------------+--------------+
  720.  
  721. Database: scms_minpolj_final
  722. Table: rss
  723. [9 columns]
  724. +----------+--------------+
  725. | Column | Type |
  726. +----------+--------------+
  727. | no | int(11) |
  728. | created | datetime |
  729. | creator | int(11) |
  730. | id | int(11) |
  731. | link | tinytext |
  732. | medij_id | int(11) |
  733. | modified | datetime |
  734. | modifier | int(11) |
  735. | name | varchar(256) |
  736. +----------+--------------+
  737.  
  738. Database: scms_minpolj_final
  739. Table: articles
  740. [15 columns]
  741. +--------------+---------------+
  742. | Column | Type |
  743. +--------------+---------------+
  744. | date | datetime |
  745. | language | varchar(3) |
  746. | no | int(11) |
  747. | active | int(1) |
  748. | article_id | int(11) |
  749. | categorie_id | int(11) |
  750. | created | datetime |
  751. | creator | int(11) |
  752. | description | varchar(256) |
  753. | id | int(11) |
  754. | meta | varchar(1000) |
  755. | modified | datetime |
  756. | modifier | int(11) |
  757. | text | longtext |
  758. | title | varchar(256) |
  759. +--------------+---------------+
  760.  
  761. Database: scms_minpolj_final
  762. Table: hits
  763. [5 columns]
  764. +----------+-------------+
  765. | Column | Type |
  766. +----------+-------------+
  767. | hits | int(11) |
  768. | id | int(11) |
  769. | modified | datetime |
  770. | page | varchar(30) |
  771. | rel_id | int(11) |
  772. +----------+-------------+
  773.  
  774. Database: scms_minpolj_final
  775. Table: article_categories
  776. [13 columns]
  777. +-------------+---------------+
  778. | Column | Type |
  779. +-------------+---------------+
  780. | language | varchar(3) |
  781. | no | int(11) |
  782. | active | int(1) |
  783. | created | datetime |
  784. | creator | int(11) |
  785. | description | varchar(500) |
  786. | id | int(11) |
  787. | image | varchar(50) |
  788. | modified | datetime |
  789. | modifier | int(11) |
  790. | name | varchar(256) |
  791. | options | varchar(1000) |
  792. | parent_id | int(11) |
  793. +-------------+---------------+
  794.  
  795. Database: scms_minpolj_final
  796. Table: like
  797. [6 columns]
  798. +----------------+-------------+
  799. | Column | Type |
  800. +----------------+-------------+
  801. | id | int(11) |
  802. | rating_dislike | int(11) |
  803. | rating_like | int(11) |
  804. | rel_id | int(11) |
  805. | rel_page | varchar(50) |
  806. | user_id | int(11) |
  807. +----------------+-------------+
  808.  
  809. Database: scms_minpolj_final
  810. Table: article_photo_categories
  811. [12 columns]
  812. +-------------+--------------+
  813. | Column | Type |
  814. +-------------+--------------+
  815. | language | varchar(3) |
  816. | no | int(11) |
  817. | active | int(1) |
  818. | created | datetime |
  819. | creator | int(11) |
  820. | description | varchar(500) |
  821. | id | int(11) |
  822. | image | varchar(100) |
  823. | modified | datetime |
  824. | modifier | int(11) |
  825. | name | varchar(256) |
  826. | parent_id | int(11) |
  827. +-------------+--------------+
  828.  
  829. Database: scms_minpolj_final
  830. Table: blog_categories
  831. [12 columns]
  832. +-----------+---------------+
  833. | Column | Type |
  834. +-----------+---------------+
  835. | language | varchar(3) |
  836. | no | int(11) |
  837. | active | int(1) |
  838. | created | datetime |
  839. | creator | int(11) |
  840. | id | int(11) |
  841. | image | varchar(50) |
  842. | modified | datetime |
  843. | modifier | int(11) |
  844. | name | varchar(256) |
  845. | options | varchar(1000) |
  846. | parent_id | int(11) |
  847. +-----------+---------------+
  848.  
  849. Database: scms_minpolj_final
  850. Table: forum_categories
  851. [13 columns]
  852. +-------------+--------------+
  853. | Column | Type |
  854. +-------------+--------------+
  855. | language | varchar(3) |
  856. | no | int(11) |
  857. | active | int(1) |
  858. | created | datetime |
  859. | creator | int(11) |
  860. | description | varchar(500) |
  861. | id | int(11) |
  862. | image | varchar(100) |
  863. | modified | datetime |
  864. | modifier | int(11) |
  865. | name | varchar(256) |
  866. | parent_id | int(11) |
  867. | views | int(11) |
  868. +-------------+--------------+
  869.  
  870. Database: scms_minpolj_final
  871. Table: widgets
  872. [12 columns]
  873. +-------------+--------------+
  874. | Column | Type |
  875. +-------------+--------------+
  876. | no | int(3) |
  877. | position | varchar(256) |
  878. | active | int(11) |
  879. | created | datetime |
  880. | creator | int(11) |
  881. | id | int(11) |
  882. | modified | int(11) |
  883. | modifier | datetime |
  884. | name | varchar(256) |
  885. | native_name | varchar(256) |
  886. | options | text |
  887. | type | varchar(256) |
  888. +-------------+--------------+
  889.  
  890. Database: scms_minpolj_final
  891. Table: fan_group_categories
  892. [13 columns]
  893. +-------------+---------------+
  894. | Column | Type |
  895. +-------------+---------------+
  896. | language | varchar(3) |
  897. | no | int(11) |
  898. | active | int(1) |
  899. | created | datetime |
  900. | creator | int(11) |
  901. | description | varchar(1000) |
  902. | id | int(11) |
  903. | image | varchar(50) |
  904. | modified | datetime |
  905. | modifier | int(11) |
  906. | name | varchar(256) |
  907. | options | varchar(1000) |
  908. | parent_id | int(11) |
  909. +-------------+---------------+
  910.  
  911. Database: scms_minpolj_final
  912. Table: forum_security
  913. [3 columns]
  914. +----------+-------------+
  915. | Column | Type |
  916. +----------+-------------+
  917. | action | varchar(10) |
  918. | group_id | int(11) |
  919. | id | int(11) |
  920. +----------+-------------+
  921.  
  922. Database: scms_minpolj_final
  923. Table: places
  924. [13 columns]
  925. +-------------+--------------+
  926. | Column | Type |
  927. +-------------+--------------+
  928. | language | varchar(3) |
  929. | no | int(11) |
  930. | active | int(1) |
  931. | created | datetime |
  932. | creator | int(11) |
  933. | description | text |
  934. | id | int(11) |
  935. | image | tinytext |
  936. | modified | datetime |
  937. | modifier | int(11) |
  938. | name | varchar(250) |
  939. | number | int(11) |
  940. | parent_id | int(11) |
  941. +-------------+--------------+
  942.  
  943. Database: scms_minpolj_final
  944. Table: komentari
  945. [11 columns]
  946. +-----------+--------------+
  947. | Column | Type |
  948. +-----------+--------------+
  949. | no | int(11) |
  950. | created | datetime |
  951. | creator | int(11) |
  952. | id | int(11) |
  953. | md5hash | varchar(32) |
  954. | modified | datetime |
  955. | modifier | int(11) |
  956. | name | varchar(256) |
  957. | published | int(1) |
  958. | tekst | text |
  959. | vest_id | int(11) |
  960. +-----------+--------------+
  961.  
  962. Database: scms_minpolj_final
  963. Table: banners
  964. [16 columns]
  965. +--------------+--------------+
  966. | Column | Type |
  967. +--------------+--------------+
  968. | language | varchar(20) |
  969. | no | int(11) |
  970. | size | varchar(10) |
  971. | active | tinyint(4) |
  972. | categorie_id | int(11) |
  973. | created | datetime |
  974. | creator | int(11) |
  975. | description | text |
  976. | expires | varchar(10) |
  977. | id | int(11) |
  978. | link | varchar(50) |
  979. | name | varchar(256) |
  980. | number | int(11) |
  981. | sizey | varchar(10) |
  982. | title | varchar(50) |
  983. | url | varchar(50) |
  984. +--------------+--------------+
  985.  
  986. Database: scms_minpolj_final
  987. Table: friendship
  988. [5 columns]
  989. +----------+-----------+
  990. | Column | Type |
  991. +----------+-----------+
  992. | created | timestamp |
  993. | creator | int(11) |
  994. | id | int(11) |
  995. | user_one | int(11) |
  996. | user_two | int(11) |
  997. +----------+-----------+
  998.  
  999. Database: scms_minpolj_final
  1000. Table: document_categories
  1001. [12 columns]
  1002. +-------------+---------------+
  1003. | Column | Type |
  1004. +-------------+---------------+
  1005. | language | varchar(3) |
  1006. | no | int(11) |
  1007. | active | int(1) |
  1008. | created | datetime |
  1009. | creator | int(11) |
  1010. | description | varchar(2000) |
  1011. | id | int(11) |
  1012. | image | varchar(50) |
  1013. | modified | datetime |
  1014. | modifier | int(11) |
  1015. | name | varchar(256) |
  1016. | parent_id | int(11) |
  1017. +-------------+---------------+
  1018.  
  1019. Database: scms_minpolj_final
  1020. Table: vesti
  1021. [9 columns]
  1022. +----------+---------------+
  1023. | Column | Type |
  1024. +----------+---------------+
  1025. | date | datetime |
  1026. | created | datetime |
  1027. | creator | int(11) |
  1028. | id | int(11) |
  1029. | link | varchar(1000) |
  1030. | medij_id | int(11) |
  1031. | modified | datetime |
  1032. | modifier | int(11) |
  1033. | name | varchar(256) |
  1034. +----------+---------------+
  1035.  
  1036. available databases [8]:
  1037. [*] information_schema
  1038. [*] minpolj
  1039. [*] mysql
  1040. [*] scms_minpolj
  1041. [*] scms_minpolj_final
  1042. [*] scms_minpolj_new
  1043. [*] scms_minpolj_old
  1044. [*] webminpolj
  1045.  
  1046. [11:43:41] [INFO] fetching tables for databases: 'information_schema, minpolj, mysql, scms_minpolj, scms_minpolj_final, scms_minpolj_new, scms_minpolj_old, webminpolj'
  1047. Database: scms_minpolj_final
  1048. [58 tables]
  1049. +---------------------------------------+
  1050. | language |
  1051. | like |
  1052. | user |
  1053. | addressbook |
  1054. | addressbook_categories |
  1055. | admin_user_rels |
  1056. | article_categories |
  1057. | article_photo_categories |
  1058. | article_photos |
  1059. | articles |
  1060. | baned_user_rels |
  1061. | banner_categories |
  1062. | banners |
  1063. | blog |
  1064. | blog_categories |
  1065. | comments |
  1066. | core |
  1067. | core_widgets |
  1068. | document_categories |
  1069. | documents |
  1070. | fan_group_categories |
  1071. | fan_groups |
  1072. | fan_groups_reported |
  1073. | forum |
  1074. | forum_categories |
  1075. | forum_security |
  1076. | friendship |
  1077. | friendship_requests |
  1078. | gallery |
  1079. | gallery_categories |
  1080. | group_page_xref |
  1081. | hits |
  1082. | komentari |
  1083. | mediji |
  1084. | menu |
  1085. | messanger |
  1086. | messanger_trash |
  1087. | newsletter |
  1088. | omladina_kdo |
  1089. | pages |
  1090. | places |
  1091. | rel_customs |
  1092. | rel_misc_gallery |
  1093. | rel_user_group |
  1094. | rel_widgets_menus |
  1095. | reports |
  1096. | rss |
  1097. | suspended_groups_rels |
  1098. | tips |
  1099. | tips_categories |
  1100. | user_fan_group |
  1101. | user_groups |
  1102. | user_loged_in |
  1103. | user_profile |
  1104. | utils |
  1105. | vesti |
  1106. | widgets |
  1107. | zadaci |
  1108. +---------------------------------------+
  1109.  
  1110. Database: scms_minpolj_old
  1111. [1 table]
  1112. +---------------------------------------+
  1113. | anketa |
  1114. +---------------------------------------+
  1115.  
  1116. Database: scms_minpolj
  1117. [26 tables]
  1118. +---------------------------------------+
  1119. | baneri |
  1120. | banner_talk |
  1121. | c_online |
  1122. | clanak |
  1123. | clanak_copy |
  1124. | clanak_foto |
  1125. | dokument |
  1126. | dokument_kategorija |
  1127. | download |
  1128. | download_kategorija |
  1129. | galerija |
  1130. | galerija_foto |
  1131. | glasac_anketa |
  1132. | kategorija |
  1133. | komentari_clanak |
  1134. | komponente |
  1135. | korisnik |
  1136. | korisnik_grupa |
  1137. | meni |
  1138. | meni_pozicija |
  1139. | newsletter |
  1140. | newsletter_prijavljeni |
  1141. | odgovori_anketa |
  1142. | rating |
  1143. | slanje_mail |
  1144. | video_lokal |
  1145. +---------------------------------------+
  1146.  
  1147. Database: scms_minpolj_new
  1148. [27 tables]
  1149. +---------------------------------------+
  1150. | anketa |
  1151. | baneri |
  1152. | banner_talk |
  1153. | c_online |
  1154. | clanak |
  1155. | clanak_copy |
  1156. | clanak_foto |
  1157. | dokument |
  1158. | dokument_kategorija |
  1159. | download |
  1160. | download_kategorija |
  1161. | galerija |
  1162. | galerija_foto |
  1163. | glasac_anketa |
  1164. | kategorija |
  1165. | komentari_clanak |
  1166. | komponente |
  1167. | korisnik |
  1168. | korisnik_grupa |
  1169. | meni |
  1170. | meni_pozicija |
  1171. | newsletter |
  1172. | newsletter_prijavljeni |
  1173. | odgovori_anketa |
  1174. | rating |
  1175. | slanje_mail |
  1176. | video_lokal |
  1177. +---------------------------------------+
  1178.  
  1179. Database: mysql
  1180. [17 tables]
  1181. +---------------------------------------+
  1182. | user |
  1183. | columns_priv |
  1184. | db |
  1185. | func |
  1186. | help_category |
  1187. | help_keyword |
  1188. | help_relation |
  1189. | help_topic |
  1190. | host |
  1191. | proc |
  1192. | procs_priv |
  1193. | tables_priv |
  1194. | time_zone |
  1195. | time_zone_leap_second |
  1196. | time_zone_name |
  1197. | time_zone_transition |
  1198. | time_zone_transition_type |
  1199. +---------------------------------------+
  1200.  
  1201. Database: information_schema
  1202. [17 tables]
  1203. +---------------------------------------+
  1204. | CHARACTER_SETS |
  1205. | COLLATIONS |
  1206. | COLLATION_CHARACTER_SET_APPLICABILITY |
  1207. | COLUMNS |
  1208. | COLUMN_PRIVILEGES |
  1209. | KEY_COLUMN_USAGE |
  1210. | PROFILING |
  1211. | ROUTINES |
  1212. | SCHEMATA |
  1213. | SCHEMA_PRIVILEGES |
  1214. | STATISTICS |
  1215. | TABLES |
  1216. | TABLE_CONSTRAINTS |
  1217. | TABLE_PRIVILEGES |
  1218. | TRIGGERS |
  1219. | USER_PRIVILEGES |
  1220. | VIEWS |
  1221. +---------------------------------------+
  1222.  
  1223. Database: webminpolj
  1224. [56 tables]
  1225. +---------------------------------------+
  1226. | jos_banner |
  1227. | jos_bannerclient |
  1228. | jos_bannerfinish |
  1229. | jos_categories |
  1230. | jos_components |
  1231. | jos_contact_details |
  1232. | jos_content |
  1233. | jos_content_frontpage |
  1234. | jos_content_rating |
  1235. | jos_core_acl_aro |
  1236. | jos_core_acl_aro_groups |
  1237. | jos_core_acl_aro_sections |
  1238. | jos_core_acl_groups_aro_map |
  1239. | jos_core_log_items |
  1240. | jos_core_log_searches |
  1241. | jos_docman |
  1242. | jos_docman_groups |
  1243. | jos_docman_history |
  1244. | jos_docman_licenses |
  1245. | jos_docman_log |
  1246. | jos_events |
  1247. | jos_events_categories |
  1248. | jos_groups |
  1249. | jos_jf_content |
  1250. | jos_jf_tableinfo |
  1251. | jos_joomap |
  1252. | jos_languages |
  1253. | jos_mambots |
  1254. | jos_menu |
  1255. | jos_messages |
  1256. | jos_messages_cfg |
  1257. | jos_modules |
  1258. | jos_modules_menu |
  1259. | jos_newsfeeds |
  1260. | jos_poll_data |
  1261. | jos_poll_date |
  1262. | jos_poll_menu |
  1263. | jos_polls |
  1264. | jos_redirection |
  1265. | jos_sections |
  1266. | jos_session |
  1267. | jos_sh404SEF_meta |
  1268. | jos_sh404sef_aliases |
  1269. | jos_stats_agents |
  1270. | jos_template_positions |
  1271. | jos_templates_menu |
  1272. | jos_users |
  1273. | jos_usertypes |
  1274. | jos_videogallerys |
  1275. | jos_videogallerys_categories |
  1276. | jos_videogallerys_savedvideos |
  1277. | jos_videogallerys_scores |
  1278. | jos_weblinks |
  1279. | jos_xmap |
  1280. | jos_xmap_ext |
  1281. | jos_xmap_sitemap |
  1282. +---------------------------------------+
  1283.  
  1284.  
  1285. Database: scms_minpolj_final
  1286. Table: language
  1287. [4 entries]
  1288. +----+-----------------+--------+---------+---------------------+---------------------+----------+------------+
  1289. | id | name | active | creator | created | modified | modifier | short_name |
  1290. +----+-----------------+--------+---------+---------------------+---------------------+----------+------------+
  1291. | 1 | serbian lat | 1 | 14 | 2010-05-24 17:20:31 | 2010-05-24 18:41:37 | 14 | lat |
  1292. | 5 | Српски ћирилица | 0 | 19 | 2010-06-05 15:36:53 | NULL | NULL | cir |
  1293. | 4 | Spanish | 0 | 14 | 2010-05-24 18:53:39 | NULL | NULL | esp |
  1294. | 3 | English | 1 | 14 | 2010-05-24 18:53:25 | NULL | NULL | en |
  1295. +----+-----------------+--------+---------+---------------------+---------------------+----------+------------+
  1296.  
  1297.  
  1298. Database: mysql
  1299. Table: user
  1300. [5 entries]
  1301. +------------------------+------------------+-------------------------------------------+
  1302. | Host | User | Password |
  1303. +------------------------+------------------+-------------------------------------------+
  1304. | test.minpolj.sr.gov.rs | root | <blank> |
  1305. | localhost | root | *59237AA77AA70B3353D46A95DDF8F71EB3171176 |
  1306. | localhost | mvni2997_minpolj | *A79CD06CEA82B9306C1124CE0522A153CEB7A95F |
  1307. | minpolj.sr.gov.rs | root | *59237AA77AA70B3353D46A95DDF8F71EB3171176 |
  1308. | 127.0.0.1 | root | <blank> |
  1309. +------------------------+------------------+-------------------------------------------+
  1310.  
  1311. ________________________________________________________________________________________________
  1312.  
  1313. L O N G L I V E K O S O V O & A L B A N I A ...
  1314. ________________________________________________________________________________________________
  1315.  
  1316.  
  1317. Target : www.hidmet.gov.rs !
  1318.  
  1319. available databases [13]:
  1320. [*] hidmet
  1321. [*] hidro
  1322. [*] hidro_kopija
  1323. [*] information_schema
  1324. [*] kvalitet_vazduha
  1325. [*] kvalitet_voda
  1326. [*] meteo
  1327. [*] moss-gms
  1328. [*] mysql
  1329. [*] opsta
  1330. [*] pgz
  1331. [*] podzemne
  1332. [*] pov
  1333.  
  1334.  
  1335.  
  1336. Database: podzemne
  1337. [26 tables]
  1338. +---------------------------------------+
  1339. | automatski_import |
  1340. | datumi |
  1341. | datumi_20092013 |
  1342. | datumi_2012 |
  1343. | datumi_2013 |
  1344. | godisnjak_sadrzaj |
  1345. | hid_pod_karakter |
  1346. | hid_pod_kon |
  1347. | hid_pod_kon_kopija |
  1348. | hid_pod_kvalitet |
  1349. | hid_pod_kvalitet_kopija |
  1350. | hid_pod_nivo |
  1351. | hid_pod_nivo_20092013 |
  1352. | hid_pod_nivo_2012 |
  1353. | hid_pod_nivo_brojke |
  1354. | hid_pod_plan |
  1355. | hid_pod_plan_seme |
  1356. | hid_pod_pz |
  1357. | hid_pod_temp |
  1358. | hid_pod_temp_20092013 |
  1359. | hid_pod_temp_2012 |
  1360. | hid_pod_tip_merenja |
  1361. | stanice_sajt |
  1362. | vodna_podrucja |
  1363. | vodna_podrucja_rang |
  1364. | vodna_podrucja_rang_stara |
  1365. +---------------------------------------+
  1366.  
  1367. Database: hidmet
  1368. [8 tables]
  1369. +---------------------------------------+
  1370. | moss |
  1371. | najave |
  1372. | najave_eng |
  1373. | najave_privremeno |
  1374. | novosti |
  1375. | novosti_eng |
  1376. | sinopticke |
  1377. | users |
  1378. +---------------------------------------+
  1379.  
  1380. Database: pov
  1381. [98 tables]
  1382. +---------------------------------------+
  1383. | dani |
  1384. | elmer |
  1385. | fnanos |
  1386. | fnanosgod |
  1387. | fnanosmax |
  1388. | fprotok |
  1389. | fprotok_cas |
  1390. | fprotokgod |
  1391. | fprotokmax |
  1392. | geolog |
  1393. | godisnjak |
  1394. | graf_god_tmp |
  1395. | graf_led_tmp |
  1396. | hg |
  1397. | hgeograf |
  1398. | hid_trajanje |
  1399. | hidmreza |
  1400. | hidro |
  1401. | hidrogeo |
  1402. | host |
  1403. | ist_stan |
  1404. | karak_q |
  1405. | karte |
  1406. | klima |
  1407. | krilo |
  1408. | kriva |
  1409. | led |
  1410. | led_4lj_tmp |
  1411. | m_fnanos |
  1412. | m_fnanosmax |
  1413. | m_fprotok |
  1414. | m_fprotokmax |
  1415. | m_nanos |
  1416. | m_nanosmax |
  1417. | m_pronos |
  1418. | m_pronosmax |
  1419. | m_stan |
  1420. | m_temp |
  1421. | m_tempmax |
  1422. | m_vodo |
  1423. | m_vodogod |
  1424. | m_vodomax |
  1425. | meseci |
  1426. | morfo |
  1427. | nanos |
  1428. | nanosgod |
  1429. | nanosmax |
  1430. | nanostab |
  1431. | oprema |
  1432. | pedolog |
  1433. | pojava |
  1434. | pomoc_sif |
  1435. | profil |
  1436. | pronos |
  1437. | pronosgod |
  1438. | pronosm |
  1439. | pronosmax |
  1440. | pronostab |
  1441. | protok |
  1442. | protoktab |
  1443. | radovi |
  1444. | reduk |
  1445. | reke |
  1446. | samir_datum |
  1447. | samir_protok |
  1448. | samir_reke |
  1449. | samir_stan_akt |
  1450. | samir_ucest |
  1451. | samir_vise_merenja |
  1452. | scs |
  1453. | stan |
  1454. | stan_elm |
  1455. | stanje |
  1456. | tac_kr |
  1457. | tac_pr |
  1458. | tac_re |
  1459. | tac_ver |
  1460. | temp |
  1461. | temperatura |
  1462. | tempgod |
  1463. | tempmax |
  1464. | tempsat |
  1465. | tip_po |
  1466. | tmp_popuna |
  1467. | vegetac |
  1468. | vode |
  1469. | vodo |
  1470. | vodo_cas |
  1471. | vodo_cas_dig |
  1472. | vodo_cas_dl |
  1473. | vodo_let |
  1474. | vodogod |
  1475. | vodoled |
  1476. | vodomax |
  1477. | vodomax_let |
  1478. | vodopom |
  1479. | vodosat |
  1480. | vodostaj |
  1481. +---------------------------------------+
  1482.  
  1483. Database: opsta
  1484. [18 tables]
  1485. +---------------------------------------+
  1486. | anketa |
  1487. | hidro_najava |
  1488. | hidro_upozorenja |
  1489. | imenik |
  1490. | imenik_kopija |
  1491. | kontakt_forma |
  1492. | meteo_najava |
  1493. | nabavka |
  1494. | nabavka_dokumenti |
  1495. | novosti_cir |
  1496. | novosti_eng |
  1497. | novosti_lat |
  1498. | users |
  1499. | zakon_clanovi |
  1500. | zakon_komentari |
  1501. | zakon_poredak |
  1502. | zakon_predlozi |
  1503. | zakon_users |
  1504. +---------------------------------------+
  1505.  
  1506. Database: hidro
  1507. [79 tables]
  1508. +---------------------------------------+
  1509. | hbv_blazevo_pad |
  1510. | hbv_blazevo_temp |
  1511. | hbv_blazevo_temp_sred |
  1512. | hbv_blazevo_vlaga |
  1513. | hbv_donja_bresnica_pad |
  1514. | hbv_donja_bresnica_temp |
  1515. | hbv_donja_bresnica_temp_sred |
  1516. | hbv_donja_bresnica_vlaga |
  1517. | hbv_hidroloske_stanice |
  1518. | hbv_lukovska_banja_pad |
  1519. | hbv_lukovska_banja_temp |
  1520. | hbv_lukovska_banja_temp_sred |
  1521. | hbv_lukovska_banja_vlaga |
  1522. | hbv_majinovic_pad |
  1523. | hbv_majinovic_temp |
  1524. | hbv_majinovic_temp_sred |
  1525. | hbv_majinovic_vlaga |
  1526. | hbv_meteo_stanice |
  1527. | hbv_najava |
  1528. | hbv_prolom_banja_pad |
  1529. | hbv_prolom_banja_temp |
  1530. | hbv_prolom_banja_temp_sred |
  1531. | hbv_prolom_banja_vlaga |
  1532. | hbv_slivovi |
  1533. | hbv_sopot_pad |
  1534. | hbv_stavica_pad |
  1535. | hbv_stavica_temp |
  1536. | hbv_stavica_temp_sred |
  1537. | hbv_stavica_vlaga |
  1538. | hbv_stragari_pad |
  1539. | hbv_tendencije |
  1540. | hbv_tendencije_azuriranje |
  1541. | hbv_tendencije_pomocna |
  1542. | hbv_velikaivanca_pad |
  1543. | hid_alarm_karte |
  1544. | hid_alarm_prognoza |
  1545. | hid_alarm_sektori |
  1546. | hid_alarm_skala |
  1547. | hid_istorijat |
  1548. | hid_kota_nule |
  1549. | hid_nrt |
  1550. | hid_nrt_grdc |
  1551. | hid_nrt_pd |
  1552. | hid_odeljenja |
  1553. | hid_odsek |
  1554. | hid_projekti |
  1555. | hid_radnici |
  1556. | hiddjerdap |
  1557. | hiddjerdap_pod |
  1558. | hidmreza |
  1559. | hidmreza_old |
  1560. | hidmreza_ukinute |
  1561. | hidopseg |
  1562. | hidosmotreni |
  1563. | hidosmotreni_nrt |
  1564. | hidprognoza |
  1565. | hidradio |
  1566. | hidradio_pod |
  1567. | hidradio_prog |
  1568. | hidradio_temp |
  1569. | hidreke |
  1570. | hidslivovi |
  1571. | hidveza |
  1572. | hrsnazivi |
  1573. | kriva |
  1574. | sk_datoteke |
  1575. | sk_podaci |
  1576. | t42010 |
  1577. | t42020 |
  1578. | t42035 |
  1579. | t42045 |
  1580. | t42055 |
  1581. | t44020 |
  1582. | t44040 |
  1583. | t45090 |
  1584. | t45094 |
  1585. | t45099 |
  1586. | t47010 |
  1587. | t47090 |
  1588. +---------------------------------------+
  1589.  
  1590. Database: moss-gms
  1591. [23 tables]
  1592. +---------------------------------------+
  1593. | gms |
  1594. | gms_agro |
  1595. | gms_dnevni |
  1596. | gms_sneg |
  1597. | gms_synop |
  1598. | korisnici |
  1599. | korisnici_parametri |
  1600. | korisnici_stanice |
  1601. | ks |
  1602. | ks_podaci |
  1603. | ks_pojave |
  1604. | ks_pojave_uz_oblacnost |
  1605. | ks_ps_intenzitet_pojave |
  1606. | ks_ps_vreme_pocetka_prestanka_pojave |
  1607. | ks_stanje_tla |
  1608. | ks_vrsta_pojava |
  1609. | mreza_srbija |
  1610. | okruzi |
  1611. | opstine |
  1612. | ps |
  1613. | ps_podaci |
  1614. | ps_pojave |
  1615. | ps_vrsta_pojava |
  1616. +---------------------------------------+
  1617.  
  1618. Database: kvalitet_voda
  1619. [12 tables]
  1620. +---------------------------------------+
  1621. | automatske |
  1622. | godisnjikvalitetvode |
  1623. | hidreke |
  1624. | hidslivovi |
  1625. | kv_vode_dnevni |
  1626. | kvvodamreza |
  1627. | parametri |
  1628. | rezultati |
  1629. | rezultati_2008 |
  1630. | rezultati_2009 |
  1631. | rezultati_2010 |
  1632. | stanice |
  1633. +---------------------------------------+
  1634.  
  1635. Database: meteo
  1636. [57 tables]
  1637. +---------------------------------------+
  1638. | agro_evapotranspiracija |
  1639. | agro_evapotranspiracija_stanice |
  1640. | agro_osmotreni |
  1641. | agro_temperature |
  1642. | automatske_padavine |
  1643. | automatske_stanice |
  1644. | bioprognoza |
  1645. | elektrane |
  1646. | elektrane_2011 |
  1647. | elektrane_2012 |
  1648. | elektrane_dnevni |
  1649. | elektrane_dnevni_2011 |
  1650. | elektrane_dnevni_2012 |
  1651. | fwi_osm |
  1652. | fwi_pro |
  1653. | kolubara_a |
  1654. | kolubara_b |
  1655. | kosutnjak |
  1656. | meteo_alarm |
  1657. | meteo_alarm_kriterijumi |
  1658. | meteo_alarm_kriterijumi_2010 |
  1659. | meteo_alarm_kriterijumi_2011 |
  1660. | meteo_alarm_kriterijumi_2012 |
  1661. | meteo_alarm_kriterijumi_2014 |
  1662. | meteo_alarm_kriterijumi_kopija |
  1663. | meteo_alarm_povratna |
  1664. | meteo_alarm_sada |
  1665. | moss |
  1666. | mreza_evropa |
  1667. | mreza_srbija |
  1668. | mteo_alarm_kriterijumi_kopija |
  1669. | osmotreni_evropa |
  1670. | osmotreni_meteo_alarm |
  1671. | osmotreni_sneg |
  1672. | osmotreni_sneg_evropa |
  1673. | osmotreni_sr |
  1674. | osmotreni_synop |
  1675. | p3_nmm_dwd |
  1676. | p3_nmm_dwd_gradovi |
  1677. | pancevo |
  1678. | pojave_os |
  1679. | pojave_pr |
  1680. | prognoza_5 |
  1681. | prognoza_danas |
  1682. | prognoza_nmm_dani |
  1683. | prognoza_nmm_sati |
  1684. | prognoza_normale |
  1685. | prognoza_sutra |
  1686. | radarska_slika |
  1687. | sinopticke |
  1688. | swc |
  1689. | synop_mreza_evropa |
  1690. | synop_rucno |
  1691. | talasi |
  1692. | talasi_regioni |
  1693. | uv_dwd |
  1694. | vazduhoplovna_prognoza |
  1695. +---------------------------------------+
  1696.  
  1697. Database: hidro_kopija
  1698. [45 tables]
  1699. +---------------------------------------+
  1700. | hid_alarm_karte |
  1701. | hid_alarm_prognoza |
  1702. | hid_alarm_sektori |
  1703. | hid_alarm_skala |
  1704. | hid_istorijat |
  1705. | hid_kota_nule |
  1706. | hid_nrt |
  1707. | hid_nrt_grdc |
  1708. | hid_nrt_pd |
  1709. | hid_odeljenja |
  1710. | hid_odsek |
  1711. | hid_projekti |
  1712. | hid_radnici |
  1713. | hiddjerdap |
  1714. | hiddjerdap_pod |
  1715. | hidmreza |
  1716. | hidmreza_old |
  1717. | hidmreza_ukinute |
  1718. | hidopseg |
  1719. | hidosmotreni |
  1720. | hidosmotreni_nrt |
  1721. | hidprognoza |
  1722. | hidradio |
  1723. | hidradio_pod |
  1724. | hidradio_prog |
  1725. | hidradio_temp |
  1726. | hidreke |
  1727. | hidslivovi |
  1728. | hidveza |
  1729. | hrsnazivi |
  1730. | kriva |
  1731. | sk_datoteke |
  1732. | sk_podaci |
  1733. | t42010 |
  1734. | t42020 |
  1735. | t42035 |
  1736. | t42045 |
  1737. | t42055 |
  1738. | t44020 |
  1739. | t44040 |
  1740. | t45090 |
  1741. | t45094 |
  1742. | t45099 |
  1743. | t47010 |
  1744. | t47090 |
  1745. +---------------------------------------+
  1746.  
  1747. Database: kvalitet_vazduha
  1748. [6 tables]
  1749. +---------------------------------------+
  1750. | kvvazduha_mesec |
  1751. | kvvazduha_tekucimesec |
  1752. | moss |
  1753. | sinopticke |
  1754. | vazduhosmotreni |
  1755. | vazduhstanice |
  1756. +---------------------------------------+
  1757.  
  1758. Database: mysql
  1759. [17 tables]
  1760. +---------------------------------------+
  1761. | user |
  1762. | columns_priv |
  1763. | db |
  1764. | func |
  1765. | help_category |
  1766. | help_keyword |
  1767. | help_relation |
  1768. | help_topic |
  1769. | host |
  1770. | proc |
  1771. | procs_priv |
  1772. | tables_priv |
  1773. | time_zone |
  1774. | time_zone_leap_second |
  1775. | time_zone_name |
  1776. | time_zone_transition |
  1777. | time_zone_transition_type |
  1778. +---------------------------------------+
  1779.  
  1780. Database: pgz
  1781. [21 tables]
  1782. +---------------------------------------+
  1783. | etape |
  1784. | etape_slike |
  1785. | mail_users |
  1786. | mail_users_dejstva |
  1787. | mail_users_stara |
  1788. | novost |
  1789. | pgz_dejstva_op |
  1790. | pgz_dejstva_st |
  1791. | pgz_dejstva_st_kopija |
  1792. | pgz_najava |
  1793. | pgz_opstine |
  1794. | pgz_opstine_strelci |
  1795. | pgz_rc |
  1796. | pgz_slike |
  1797. | pgz_stanice |
  1798. | pgz_status_opstine |
  1799. | pgz_status_pgs |
  1800. | pgz_steta |
  1801. | pgz_steta_opstine |
  1802. | slike |
  1803. | users |
  1804. +---------------------------------------+
  1805.  
  1806. Database: information_schema
  1807. [17 tables]
  1808. +---------------------------------------+
  1809. | CHARACTER_SETS |
  1810. | COLLATIONS |
  1811. | COLLATION_CHARACTER_SET_APPLICABILITY |
  1812. | COLUMNS |
  1813. | COLUMN_PRIVILEGES |
  1814. | KEY_COLUMN_USAGE |
  1815. | PROFILING |
  1816. | ROUTINES |
  1817. | SCHEMATA |
  1818. | SCHEMA_PRIVILEGES |
  1819. | STATISTICS |
  1820. | TABLES |
  1821. | TABLE_CONSTRAINTS |
  1822. | TABLE_PRIVILEGES |
  1823. | TRIGGERS |
  1824. | USER_PRIVILEGES |
  1825. | VIEWS |
  1826. +---------------------------------------+
  1827.  
  1828.  
  1829.  
  1830.  
  1831.  
  1832.  
  1833.  
  1834.  
  1835.  
  1836.  
  1837. Database: meteo
  1838. Table: elektrane_dnevni
  1839. [8 columns]
  1840. +---------------+--------------+
  1841. | Column | Type |
  1842. +---------------+--------------+
  1843. | el_azur | timestamp |
  1844. | el_datum | date |
  1845. | el_id | mediumint(9) |
  1846. | el_opis | tinytext |
  1847. | el_temp_max | tinyint(4) |
  1848. | el_temp_min | tinyint(4) |
  1849. | el_vetar_max | tinyint(4) |
  1850. | el_vetar_sred | tinyint(4) |
  1851. +---------------+--------------+
  1852.  
  1853. Database: meteo
  1854. Table: kolubara_a
  1855. [10 columns]
  1856. +-------------+--------------+
  1857. | Column | Type |
  1858. +-------------+--------------+
  1859. | pa_id | int(11) |
  1860. | pa_pad | decimal(4,1) |
  1861. | pa_prit | decimal(5,1) |
  1862. | pa_temp_2m | decimal(3,1) |
  1863. | pa_v_10m | decimal(3,1) |
  1864. | pa_v_pr_10m | int(3) |
  1865. | pa_vlaz_2m | decimal(4,1) |
  1866. | pa_vreme | datetime |
  1867. | pa_zr | decimal(5,1) |
  1868. | vreme_fajl | time |
  1869. +-------------+--------------+
  1870.  
  1871. Database: meteo
  1872. Table: kolubara_b
  1873. [10 columns]
  1874. +-------------+--------------+
  1875. | Column | Type |
  1876. +-------------+--------------+
  1877. | pa_id | int(11) |
  1878. | pa_pad | decimal(4,1) |
  1879. | pa_prit | decimal(5,1) |
  1880. | pa_temp_2m | decimal(3,1) |
  1881. | pa_v_10m | decimal(3,1) |
  1882. | pa_v_pr_10m | int(3) |
  1883. | pa_vlaz_2m | decimal(4,1) |
  1884. | pa_vreme | datetime |
  1885. | pa_zr | decimal(5,1) |
  1886. | vreme_fajl | time |
  1887. +-------------+--------------+
  1888.  
  1889. Database: meteo
  1890. Table: sinopticke
  1891. [11 columns]
  1892. +--------------+---------+
  1893. | Column | Type |
  1894. +--------------+---------+
  1895. | si_god | char(4) |
  1896. | si_id | char(5) |
  1897. | si_maxpad | char(5) |
  1898. | si_maxsneg | char(4) |
  1899. | si_naziv | text |
  1900. | si_paddatum | text |
  1901. | si_snegdatum | text |
  1902. | si_tmax | char(4) |
  1903. | si_tmaxdatum | text |
  1904. | si_tmin | char(5) |
  1905. | si_tmindatum | text |
  1906. +--------------+---------+
  1907.  
  1908. Database: meteo
  1909. Table: p3_nmm_dwd
  1910. [11 columns]
  1911. +----------------+----------------------+
  1912. | Column | Type |
  1913. +----------------+----------------------+
  1914. | grad | tinyint(4) unsigned |
  1915. | p3 | smallint(9) |
  1916. | padavine | tinyint(4) unsigned |
  1917. | pritisak | smallint(6) unsigned |
  1918. | simbol | tinyint(4) unsigned |
  1919. | start_prognoza | datetime |
  1920. | temperatura | tinyint(4) |
  1921. | vetar_brzina | tinyint(10) unsigned |
  1922. | vetar_smer | char(2) |
  1923. | vlaga | tinyint(4) unsigned |
  1924. | vreme_prognoza | datetime |
  1925. +----------------+----------------------+
  1926.  
  1927. Database: meteo
  1928. Table: moss
  1929. [6 columns]
  1930. +----------------+---------+
  1931. | Column | Type |
  1932. +----------------+---------+
  1933. | moss_duzina | text |
  1934. | moss_id | char(5) |
  1935. | moss_naziv_cir | text |
  1936. | moss_naziv_lat | text |
  1937. | moss_sirina | text |
  1938. | moss_visina | text |
  1939. +----------------+---------+
  1940.  
  1941. Database: meteo
  1942. Table: agro_evapotranspiracija
  1943. [7 columns]
  1944. +--------------------+-------------+
  1945. | Column | Type |
  1946. +--------------------+-------------+
  1947. | evapo_stanica | varchar(20) |
  1948. | evapotranspiracija | varchar(20) |
  1949. | id | int(11) |
  1950. | mo_id | char(5) |
  1951. | mo_max | char(5) |
  1952. | mo_min | char(5) |
  1953. | mo_vreme | date |
  1954. +--------------------+-------------+
  1955.  
  1956. Database: meteo
  1957. Table: meteo_alarm_sada
  1958. [181 columns]
  1959. +---------------------+------------+
  1960. | Column | Type |
  1961. +---------------------+------------+
  1962. | ma_azurirano | datetime |
  1963. | ma_ba_grmljavina | tinyint(1) |
  1964. | ma_ba_grmljavina_kr | tinyint(1) |
  1965. | ma_ba_kisa | tinyint(1) |
  1966. | ma_ba_kisa_kr | tinyint(1) |
  1967. | ma_ba_magla | tinyint(1) |
  1968. | ma_ba_magla_kr | tinyint(1) |
  1969. | ma_ba_max_temp | tinyint(1) |
  1970. | ma_ba_max_temp_kr | tinyint(1) |
  1971. | ma_ba_min_temp | tinyint(1) |
  1972. | ma_ba_min_temp_kr | tinyint(1) |
  1973. | ma_ba_sneg | tinyint(1) |
  1974. | ma_ba_sneg_kr | tinyint(1) |
  1975. | ma_ba_sume | tinyint(1) |
  1976. | ma_ba_sume_kr | tinyint(1) |
  1977. | ma_ba_vetar | tinyint(1) |
  1978. | ma_ba_vetar_kr | tinyint(1) |
  1979. | ma_bc_grmljavina | tinyint(1) |
  1980. | ma_bc_grmljavina_kr | tinyint(1) |
  1981. | ma_bc_kisa | tinyint(1) |
  1982. | ma_bc_kisa_kr | tinyint(1) |
  1983. | ma_bc_magla | tinyint(1) |
  1984. | ma_bc_magla_kr | tinyint(1) |
  1985. | ma_bc_max_temp | tinyint(1) |
  1986. | ma_bc_max_temp_kr | tinyint(1) |
  1987. | ma_bc_min_temp | tinyint(1) |
  1988. | ma_bc_min_temp_kr | tinyint(1) |
  1989. | ma_bc_sneg | tinyint(1) |
  1990. | ma_bc_sneg_kr | tinyint(1) |
  1991. | ma_bc_sume | tinyint(1) |
  1992. | ma_bc_sume_kr | tinyint(1) |
  1993. | ma_bc_vetar | tinyint(1) |
  1994. | ma_bc_vetar_kr | tinyint(1) |
  1995. | ma_bg_grmljavina | tinyint(1) |
  1996. | ma_bg_grmljavina_kr | tinyint(1) |
  1997. | ma_bg_kisa | tinyint(1) |
  1998. | ma_bg_kisa_kr | tinyint(1) |
  1999. | ma_bg_magla | tinyint(1) |
  2000. | ma_bg_magla_kr | tinyint(1) |
  2001. | ma_bg_max_temp | tinyint(1) |
  2002. | ma_bg_max_temp_kr | tinyint(1) |
  2003. | ma_bg_min_temp | tinyint(1) |
  2004. | ma_bg_min_temp_kr | tinyint(1) |
  2005. | ma_bg_sneg | tinyint(1) |
  2006. | ma_bg_sneg_kr | tinyint(1) |
  2007. | ma_bg_sume | tinyint(1) |
  2008. | ma_bg_sume_kr | tinyint(1) |
  2009. | ma_bg_vetar | tinyint(1) |
  2010. | ma_bg_vetar_kr | tinyint(1) |
  2011. | ma_id | tinyint(1) |
  2012. | ma_is_grmljavina | tinyint(1) |
  2013. | ma_is_grmljavina_kr | tinyint(1) |
  2014. | ma_is_kisa | tinyint(1) |
  2015. | ma_is_kisa_kr | tinyint(1) |
  2016. | ma_is_magla | tinyint(1) |
  2017. | ma_is_magla_kr | tinyint(1) |
  2018. | ma_is_max_temp | tinyint(1) |
  2019. | ma_is_max_temp_kr | tinyint(1) |
  2020. | ma_is_min_temp | tinyint(1) |
  2021. | ma_is_min_temp_kr | tinyint(1) |
  2022. | ma_is_sneg | tinyint(1) |
  2023. | ma_is_sneg_kr | tinyint(1) |
  2024. | ma_is_sume | tinyint(1) |
  2025. | ma_is_sume_kr | tinyint(1) |
  2026. | ma_is_vetar | tinyint(1) |
  2027. | ma_is_vetar_kr | tinyint(1) |
  2028. | ma_ji_grmljavina | tinyint(1) |
  2029. | ma_ji_grmljavina_kr | tinyint(1) |
  2030. | ma_ji_kisa | tinyint(1) |
  2031. | ma_ji_kisa_kr | tinyint(1) |
  2032. | ma_ji_magla | tinyint(1) |
  2033. | ma_ji_magla_kr | tinyint(1) |
  2034. | ma_ji_max_temp | tinyint(1) |
  2035. | ma_ji_max_temp_kr | tinyint(1) |
  2036. | ma_ji_min_temp | tinyint(1) |
  2037. | ma_ji_min_temp_kr | tinyint(1) |
  2038. | ma_ji_sneg | tinyint(1) |
  2039. | ma_ji_sneg_kr | tinyint(1) |
  2040. | ma_ji_sume | tinyint(1) |
  2041. | ma_ji_sume_kr | tinyint(1) |
  2042. | ma_ji_vetar | tinyint(1) |
  2043. | ma_ji_vetar_kr | tinyint(1) |
  2044. | ma_jz_grmljavina | tinyint(1) |
  2045. | ma_jz_grmljavina_kr | tinyint(1) |
  2046. | ma_jz_kisa | tinyint(1) |
  2047. | ma_jz_kisa_kr | tinyint(1) |
  2048. | ma_jz_magla | tinyint(1) |
  2049. | ma_jz_magla_kr | tinyint(1) |
  2050. | ma_jz_max_temp | tinyint(1) |
  2051. | ma_jz_max_temp_kr | tinyint(1) |
  2052. | ma_jz_min_temp | tinyint(1) |
  2053. | ma_jz_min_temp_kr | tinyint(1) |
  2054. | ma_jz_sneg | tinyint(1) |
  2055. | ma_jz_sneg_kr | tinyint(1) |
  2056. | ma_jz_sume | tinyint(1) |
  2057. | ma_jz_sume_kr | tinyint(1) |
  2058. | ma_jz_vetar | tinyint(1) |
  2059. | ma_jz_vetar_kr | tinyint(1) |
  2060. | ma_km_grmljavina | tinyint(1) |
  2061. | ma_km_grmljavina_kr | tinyint(1) |
  2062. | ma_km_kisa | tinyint(1) |
  2063. | ma_km_kisa_kr | tinyint(1) |
  2064. | ma_km_magla | tinyint(1) |
  2065. | ma_km_magla_kr | tinyint(1) |
  2066. | ma_km_max_temp | tinyint(1) |
  2067. | ma_km_max_temp_kr | tinyint(1) |
  2068. | ma_km_min_temp | tinyint(1) |
  2069. | ma_km_min_temp_kr | tinyint(1) |
  2070. | ma_km_sneg | tinyint(1) |
  2071. | ma_km_sneg_kr | tinyint(1) |
  2072. | ma_km_sume | tinyint(1) |
  2073. | ma_km_sume_kr | tinyint(1) |
  2074. | ma_km_vetar | tinyint(1) |
  2075. | ma_km_vetar_kr | tinyint(1) |
  2076. | ma_po_grmljavina | tinyint(1) |
  2077. | ma_po_grmljavina_kr | tinyint(1) |
  2078. | ma_po_kisa | tinyint(1) |
  2079. | ma_po_kisa_kr | tinyint(1) |
  2080. | ma_po_magla | tinyint(1) |
  2081. | ma_po_magla_kr | tinyint(1) |
  2082. | ma_po_max_temp | tinyint(1) |
  2083. | ma_po_max_temp_kr | tinyint(1) |
  2084. | ma_po_min_temp | tinyint(1) |
  2085. | ma_po_min_temp_kr | tinyint(1) |
  2086. | ma_po_sneg | tinyint(1) |
  2087. | ma_po_sneg_kr | tinyint(1) |
  2088. | ma_po_sume | tinyint(1) |
  2089. | ma_po_sume_kr | tinyint(1) |
  2090. | ma_po_vetar | tinyint(1) |
  2091. | ma_po_vetar_kr | tinyint(1) |
  2092. | ma_sr_grmljavina | tinyint(1) |
  2093. | ma_sr_grmljavina_kr | tinyint(1) |
  2094. | ma_sr_kisa | tinyint(1) |
  2095. | ma_sr_kisa_kr | tinyint(1) |
  2096. | ma_sr_magla | tinyint(1) |
  2097. | ma_sr_magla_kr | tinyint(1) |
  2098. | ma_sr_max_temp | tinyint(1) |
  2099. | ma_sr_max_temp_kr | tinyint(1) |
  2100. | ma_sr_min_temp | tinyint(1) |
  2101. | ma_sr_min_temp_kr | tinyint(1) |
  2102. | ma_sr_sneg | tinyint(1) |
  2103. | ma_sr_sneg_kr | tinyint(1) |
  2104. | ma_sr_sume | tinyint(1) |
  2105. | ma_sr_sume_kr | tinyint(1) |
  2106. | ma_sr_vetar | tinyint(1) |
  2107. | ma_sr_vetar_kr | tinyint(1) |
  2108. | ma_su_grmljavina | tinyint(1) |
  2109. | ma_su_grmljavina_kr | tinyint(1) |
  2110. | ma_su_kisa | tinyint(1) |
  2111. | ma_su_kisa_kr | tinyint(1) |
  2112. | ma_su_magla | tinyint(1) |
  2113. | ma_su_magla_kr | tinyint(1) |
  2114. | ma_su_max_temp | tinyint(1) |
  2115. | ma_su_max_temp_kr | tinyint(1) |
  2116. | ma_su_min_temp | tinyint(1) |
  2117. | ma_su_min_temp_kr | tinyint(1) |
  2118. | ma_su_sneg | tinyint(1) |
  2119. | ma_su_sneg_kr | tinyint(1) |
  2120. | ma_su_sume | tinyint(1) |
  2121. | ma_su_sume_kr | tinyint(1) |
  2122. | ma_su_vetar | tinyint(1) |
  2123. | ma_su_vetar_kr | tinyint(1) |
  2124. | ma_trajanje | datetime |
  2125. | ma_zs_grmljavina | tinyint(1) |
  2126. | ma_zs_grmljavina_kr | tinyint(1) |
  2127. | ma_zs_kisa | tinyint(1) |
  2128. | ma_zs_kisa_kr | tinyint(1) |
  2129. | ma_zs_magla | tinyint(1) |
  2130. | ma_zs_magla_kr | tinyint(1) |
  2131. | ma_zs_max_temp | tinyint(1) |
  2132. | ma_zs_max_temp_kr | tinyint(1) |
  2133. | ma_zs_min_temp | tinyint(1) |
  2134. | ma_zs_min_temp_kr | tinyint(1) |
  2135. | ma_zs_sneg | tinyint(1) |
  2136. | ma_zs_sneg_kr | tinyint(1) |
  2137. | ma_zs_sume | tinyint(1) |
  2138. | ma_zs_sume_kr | tinyint(1) |
  2139. | ma_zs_vetar | tinyint(1) |
  2140. | ma_zs_vetar_kr | tinyint(1) |
  2141. | maks | tinyint(4) |
  2142. | tekst | text |
  2143. +---------------------+------------+
  2144.  
  2145. Database: meteo
  2146. Table: prognoza_nmm_dani
  2147. [6 columns]
  2148. +--------+-------------+
  2149. | Column | Type |
  2150. +--------+-------------+
  2151. | max | varchar(5) |
  2152. | min | varchar(5) |
  2153. | pad | varchar(5) |
  2154. | datum | date |
  2155. | mesto | varchar(40) |
  2156. | sred | varchar(5) |
  2157. +--------+-------------+
  2158.  
  2159. Database: meteo
  2160. Table: osmotreni_meteo_alarm
  2161. [11 columns]
  2162. +---------------+----------+
  2163. | Column | Type |
  2164. +---------------+----------+
  2165. | om_grmljavina | char(1) |
  2166. | om_hladno | char(1) |
  2167. | om_id | char(5) |
  2168. | om_kisa | char(1) |
  2169. | om_magla | char(1) |
  2170. | om_poledica | char(1) |
  2171. | om_sada | datetime |
  2172. | om_sneg | char(1) |
  2173. | om_toplo | char(1) |
  2174. | om_vetar | char(1) |
  2175. | om_vreme | datetime |
  2176. +---------------+----------+
  2177.  
  2178. Database: meteo
  2179. Table: elektrane_2012
  2180. [7 columns]
  2181. +---------------+--------------+
  2182. | Column | Type |
  2183. +---------------+--------------+
  2184. | el_azur | timestamp |
  2185. | el_datum | datetime |
  2186. | el_id | mediumint(9) |
  2187. | el_opis | tinytext |
  2188. | el_temp | tinyint(4) |
  2189. | el_vetar_max | tinyint(4) |
  2190. | el_vetar_sred | tinyint(4) |
  2191. +---------------+--------------+
  2192.  
  2193. Database: meteo
  2194. Table: elektrane_2011
  2195. [7 columns]
  2196. +---------------+--------------+
  2197. | Column | Type |
  2198. +---------------+--------------+
  2199. | el_azur | timestamp |
  2200. | el_datum | datetime |
  2201. | el_id | mediumint(9) |
  2202. | el_opis | tinytext |
  2203. | el_temp | tinyint(4) |
  2204. | el_vetar_max | tinyint(4) |
  2205. | el_vetar_sred | tinyint(4) |
  2206. +---------------+--------------+
  2207.  
  2208. Database: meteo
  2209. Table: prognoza_danas
  2210. [4 columns]
  2211. +-------------+----------+
  2212. | Column | Type |
  2213. +-------------+----------+
  2214. | mp_datum | datetime |
  2215. | mp_id | char(5) |
  2216. | mp_t1max | char(3) |
  2217. | mp_t1pojava | char(2) |
  2218. +-------------+----------+
  2219.  
  2220. Database: meteo
  2221. Table: synop_mreza_evropa
  2222. [4 columns]
  2223. +--------------+----------+
  2224. | Column | Type |
  2225. +--------------+----------+
  2226. | ms_id | char(5) |
  2227. | ms_naziv_cir | tinytext |
  2228. | ms_naziv_eng | tinytext |
  2229. | ms_naziv_lat | tinytext |
  2230. +--------------+----------+
  2231.  
  2232. Database: meteo
  2233. Table: radarska_slika
  2234. [4 columns]
  2235. +--------+-------------+
  2236. | Column | Type |
  2237. +--------+-------------+
  2238. | id | int(11) |
  2239. | radar | char(1) |
  2240. | slika | varchar(40) |
  2241. | vreme | datetime |
  2242. +--------+-------------+
  2243.  
  2244. Database: meteo
  2245. Table: meteo_alarm_kriterijumi_kopija
  2246. [12 columns]
  2247. +---------------+---------------------------+
  2248. | Column | Type |
  2249. +---------------+---------------------------+
  2250. | kr_cir | tinytext |
  2251. | kr_do | date |
  2252. | kr_eng | tinytext |
  2253. | kr_id | int(11) |
  2254. | kr_kriterijum | char(10) |
  2255. | kr_lat | tinytext |
  2256. | kr_meteo_nivo | enum('2','3','4') |
  2257. | kr_od | date |
  2258. | kr_vrednost | enum('1','2','3','4','5') |
  2259. | ut_cir | text |
  2260. | ut_eng | text |
  2261. | ut_lat | text |
  2262. +---------------+---------------------------+
  2263.  
  2264. Database: meteo
  2265. Table: agro_osmotreni
  2266. [4 columns]
  2267. +----------+-------------+
  2268. | Column | Type |
  2269. +----------+-------------+
  2270. | id | int(11) |
  2271. | mo_id | char(5) |
  2272. | mo_temp | smallint(9) |
  2273. | mo_vreme | datetime |
  2274. +----------+-------------+
  2275.  
  2276. Database: meteo
  2277. Table: pancevo
  2278. [10 columns]
  2279. +-------------+--------------+
  2280. | Column | Type |
  2281. +-------------+--------------+
  2282. | pa_id | int(11) |
  2283. | pa_pad | decimal(4,1) |
  2284. | pa_prit | decimal(5,1) |
  2285. | pa_sat | char(5) |
  2286. | pa_temp_2m | decimal(3,1) |
  2287. | pa_v_10m | decimal(3,1) |
  2288. | pa_v_pr_10m | int(3) |
  2289. | pa_vlaz_2m | decimal(4,1) |
  2290. | pa_vreme | datetime |
  2291. | pa_zr | decimal(5,1) |
  2292. +-------------+--------------+
  2293.  
  2294. Database: meteo
  2295. Table: osmotreni_sneg_evropa
  2296. [2 columns]
  2297. +-----------+---------+
  2298. | Column | Type |
  2299. +-----------+---------+
  2300. | sg_id | char(5) |
  2301. | sg_visina | char(3) |
  2302. +-----------+---------+
  2303.  
  2304. Database: meteo
  2305. Table: vazduhoplovna_prognoza
  2306. [15 columns]
  2307. +-----------------------+------------+
  2308. | Column | Type |
  2309. +-----------------------+------------+
  2310. | azuriranje | datetime |
  2311. | id | tinyint(4) |
  2312. | minus_deset_stupnjeva | text |
  2313. | nula_stupnjeva | text |
  2314. | oblacnost | text |
  2315. | opasne_pojave | text |
  2316. | pojave | text |
  2317. | prognosticar | text |
  2318. | sinopticka_situacija | text |
  2319. | sloj_inverzije | text |
  2320. | turbulencija | text |
  2321. | vetar_u_prizemlju | text |
  2322. | vidljivost | text |
  2323. | vreme | text |
  2324. | zaledjivanje | text |
  2325. +-----------------------+------------+
  2326.  
  2327. Database: meteo
  2328. Table: prognoza_5
  2329. [22 columns]
  2330. +-------------+----------+
  2331. | Column | Type |
  2332. +-------------+----------+
  2333. | mp_datum | datetime |
  2334. | mp_datumt1 | date |
  2335. | mp_datumt2 | date |
  2336. | mp_datumt3 | date |
  2337. | mp_datumt4 | date |
  2338. | mp_datumt5 | date |
  2339. | mp_id | char(5) |
  2340. | mp_t1max | char(3) |
  2341. | mp_t1min | char(3) |
  2342. | mp_t1pojava | char(2) |
  2343. | mp_t2max | char(3) |
  2344. | mp_t2min | char(3) |
  2345. | mp_t2pojava | char(2) |
  2346. | mp_t3max | char(3) |
  2347. | mp_t3min | char(3) |
  2348. | mp_t3pojava | char(2) |
  2349. | mp_t4max | char(3) |
  2350. | mp_t4min | char(3) |
  2351. | mp_t4pojava | char(2) |
  2352. | mp_t5max | char(3) |
  2353. | mp_t5min | char(3) |
  2354. | mp_t5pojava | char(2) |
  2355. +-------------+----------+
  2356.  
  2357. Database: meteo
  2358. Table: swc
  2359. [3 columns]
  2360. +------------+----------+
  2361. | Column | Type |
  2362. +------------+----------+
  2363. | azuriranje | datetime |
  2364. | id | char(1) |
  2365. | valid | datetime |
  2366. +------------+----------+
  2367.  
  2368. Database: meteo
  2369. Table: fwi_pro
  2370. [14 columns]
  2371. +--------------+-------------+
  2372. | Column | Type |
  2373. +--------------+-------------+
  2374. | fwi_bui | varchar(5) |
  2375. | fwi_dc | varchar(5) |
  2376. | fwi_dmc | varchar(5) |
  2377. | fwi_ffmc | varchar(5) |
  2378. | fwi_fwi | varchar(5) |
  2379. | fwi_id | smallint(6) |
  2380. | fwi_isi | varchar(5) |
  2381. | fwi_opasnost | char(1) |
  2382. | fwi_p24 | varchar(5) |
  2383. | fwi_rv | char(3) |
  2384. | fwi_st_id | char(5) |
  2385. | fwi_t | char(5) |
  2386. | fwi_vet | varchar(5) |
  2387. | fwi_vreme | datetime |
  2388. +--------------+-------------+
  2389.  
  2390. Database: meteo
  2391. Table: agro_evapotranspiracija_stanice
  2392. [3 columns]
  2393. +------------+--------------+
  2394. | Column | Type |
  2395. +------------+--------------+
  2396. | datum | date |
  2397. | evapo | decimal(4,2) |
  2398. | stanica_id | char(5) |
  2399. +------------+--------------+
  2400.  
  2401. Database: meteo
  2402. Table: meteo_alarm_kriterijumi_2014
  2403. [12 columns]
  2404. +---------------+---------------------------+
  2405. | Column | Type |
  2406. +---------------+---------------------------+
  2407. | kr_cir | tinytext |
  2408. | kr_do | date |
  2409. | kr_eng | tinytext |
  2410. | kr_id | int(11) |
  2411. | kr_kriterijum | char(10) |
  2412. | kr_lat | tinytext |
  2413. | kr_meteo_nivo | enum('2','3','4') |
  2414. | kr_od | date |
  2415. | kr_vrednost | enum('1','2','3','4','5') |
  2416. | ut_cir | text |
  2417. | ut_eng | text |
  2418. | ut_lat | text |
  2419. +---------------+---------------------------+
  2420.  
  2421. Database: meteo
  2422. Table: osmotreni_sr
  2423. [10 columns]
  2424. +-----------+----------+
  2425. | Column | Type |
  2426. +-----------+----------+
  2427. | id | int(11) |
  2428. | mo_id | char(5) |
  2429. | mo_opis | char(2) |
  2430. | mo_prit | char(6) |
  2431. | mo_sada | datetime |
  2432. | mo_temp | char(5) |
  2433. | mo_vetbrz | char(4) |
  2434. | mo_vetpra | char(2) |
  2435. | mo_vlaz | char(4) |
  2436. | mo_vreme | datetime |
  2437. +-----------+----------+
  2438.  
  2439. Database: meteo
  2440. Table: kosutnjak
  2441. [47 columns]
  2442. +---------------------+-------------+
  2443. | Column | Type |
  2444. +---------------------+-------------+
  2445. | SuncevoZracenjeW/m2 | float |
  2446. | Brzina10mAVG | float |
  2447. | Brzina10mMax | float |
  2448. | Brzina10mMin | float |
  2449. | Brzina2mAVG | float |
  2450. | Brzina2mMax | float |
  2451. | Brzina2mMin | float |
  2452. | Datum | datetime |
  2453. | I1 | tinyint(1) |
  2454. | I10 | tinyint(1) |
  2455. | I11 | tinyint(1) |
  2456. | I12 | tinyint(1) |
  2457. | I13 | tinyint(1) |
  2458. | I14 | tinyint(1) |
  2459. | I15 | tinyint(1) |
  2460. | I16 | tinyint(1) |
  2461. | I17 | tinyint(1) |
  2462. | I18 | tinyint(1) |
  2463. | I19 | tinyint(1) |
  2464. | I2 | tinyint(1) |
  2465. | I20 | tinyint(1) |
  2466. | I21 | tinyint(1) |
  2467. | I22 | tinyint(1) |
  2468. | I3 | tinyint(1) |
  2469. | I4 | tinyint(1) |
  2470. | I5 | tinyint(1) |
  2471. | I6 | tinyint(1) |
  2472. | I7 | tinyint(1) |
  2473. | I8 | tinyint(1) |
  2474. | I9 | tinyint(1) |
  2475. | KolicinaPadavina | float |
  2476. | PadavinaDaNe | float |
  2477. | Pravac10mAVG | float |
  2478. | Pravac10mMax | float |
  2479. | Pravac10mMin | float |
  2480. | Pravac2mAVG | float |
  2481. | Pravac2mMax | float |
  2482. | Pravac2mMin | float |
  2483. | Pritisak | float |
  2484. | Stanica | smallint(5) |
  2485. | SuncevoZracenjeDaNE | float |
  2486. | SuncevoZracenjeM | float |
  2487. | Temperatura2m | float |
  2488. | Temperatura5cm | float |
  2489. | TrajanjePadavina | float |
  2490. | Vlaga | float |
  2491. | Vreme | datetime |
  2492. +---------------------+-------------+
  2493.  
  2494. Database: meteo
  2495. Table: meteo_alarm_kriterijumi_2010
  2496. [12 columns]
  2497. +---------------+---------------------------+
  2498. | Column | Type |
  2499. +---------------+---------------------------+
  2500. | kr_cir | tinytext |
  2501. | kr_do | date |
  2502. | kr_eng | tinytext |
  2503. | kr_id | int(11) |
  2504. | kr_kriterijum | char(10) |
  2505. | kr_lat | tinytext |
  2506. | kr_meteo_nivo | enum('2','3','4') |
  2507. | kr_od | date |
  2508. | kr_vrednost | enum('1','2','3','4','5') |
  2509. | ut_cir | text |
  2510. | ut_eng | text |
  2511. | ut_lat | text |
  2512. +---------------+---------------------------+
  2513.  
  2514. Database: meteo
  2515. Table: meteo_alarm_kriterijumi_2011
  2516. [12 columns]
  2517. +---------------+---------------------------+
  2518. | Column | Type |
  2519. +---------------+---------------------------+
  2520. | kr_cir | tinytext |
  2521. | kr_do | date |
  2522. | kr_eng | tinytext |
  2523. | kr_id | int(11) |
  2524. | kr_kriterijum | char(10) |
  2525. | kr_lat | tinytext |
  2526. | kr_meteo_nivo | enum('2','3','4') |
  2527. | kr_od | date |
  2528. | kr_vrednost | enum('1','2','3','4','5') |
  2529. | ut_cir | text |
  2530. | ut_eng | text |
  2531. | ut_lat | text |
  2532. +---------------+---------------------------+
  2533.  
  2534. Database: meteo
  2535. Table: meteo_alarm_kriterijumi_2012
  2536. [12 columns]
  2537. +---------------+---------------------------+
  2538. | Column | Type |
  2539. +---------------+---------------------------+
  2540. | kr_cir | tinytext |
  2541. | kr_do | date |
  2542. | kr_eng | tinytext |
  2543. | kr_id | int(11) |
  2544. | kr_kriterijum | char(10) |
  2545. | kr_lat | tinytext |
  2546. | kr_meteo_nivo | enum('2','3','4') |
  2547. | kr_od | date |
  2548. | kr_vrednost | enum('1','2','3','4','5') |
  2549. | ut_cir | text |
  2550. | ut_eng | text |
  2551. | ut_lat | text |
  2552. +---------------+---------------------------+
  2553.  
  2554. Database: meteo
  2555. Table: talasi_regioni
  2556. [8 columns]
  2557. +----------------+---------------+
  2558. | Column | Type |
  2559. +----------------+---------------+
  2560. | ta_azurirano | datetime |
  2561. | ta_id | tinyint(4) |
  2562. | ta_model | enum('0','1') |
  2563. | ta_od | date |
  2564. | ta_opis | char(37) |
  2565. | ta_opis_kratki | char(4) |
  2566. | ta_region | char(18) |
  2567. | ta_sifra | char(2) |
  2568. +----------------+---------------+
  2569.  
  2570. Database: meteo
  2571. Table: mreza_srbija
  2572. [5 columns]
  2573. +--------------+---------------+
  2574. | Column | Type |
  2575. +--------------+---------------+
  2576. | hash | char(32) |
  2577. | ms_id | char(5) |
  2578. | ms_naziv_lat | tinytext |
  2579. | ms_stb | tinyint(4) |
  2580. | synop | enum('d','n') |
  2581. +--------------+---------------+
  2582.  
  2583. Database: meteo
  2584. Table: meteo_alarm_kriterijumi
  2585. [12 columns]
  2586. +---------------+---------------------------+
  2587. | Column | Type |
  2588. +---------------+---------------------------+
  2589. | kr_cir | tinytext |
  2590. | kr_do | date |
  2591. | kr_eng | tinytext |
  2592. | kr_id | mediumint(9) |
  2593. | kr_kriterijum | char(10) |
  2594. | kr_lat | tinytext |
  2595. | kr_meteo_nivo | enum('2','3','4') |
  2596. | kr_od | date |
  2597. | kr_vrednost | enum('1','2','3','4','5') |
  2598. | ut_cir | text |
  2599. | ut_eng | text |
  2600. | ut_lat | text |
  2601. +---------------+---------------------------+
  2602.  
  2603. Database: meteo
  2604. Table: talasi
  2605. [4 columns]
  2606. +------------+--------------+
  2607. | Column | Type |
  2608. +------------+--------------+
  2609. | ta_id | mediumint(9) |
  2610. | ta_od | date |
  2611. | ta_sifra | char(2) |
  2612. | ta_stanica | char(5) |
  2613. +------------+--------------+
  2614.  
  2615. Database: meteo
  2616. Table: fwi_osm
  2617. [14 columns]
  2618. +--------------+-------------+
  2619. | Column | Type |
  2620. +--------------+-------------+
  2621. | fwi_bui | varchar(5) |
  2622. | fwi_dc | varchar(5) |
  2623. | fwi_dmc | varchar(5) |
  2624. | fwi_ffmc | varchar(5) |
  2625. | fwi_fwi | varchar(5) |
  2626. | fwi_id | smallint(6) |
  2627. | fwi_isi | varchar(5) |
  2628. | fwi_opasnost | char(1) |
  2629. | fwi_p24 | varchar(5) |
  2630. | fwi_rv | char(3) |
  2631. | fwi_st_id | char(5) |
  2632. | fwi_t | char(5) |
  2633. | fwi_vet | varchar(5) |
  2634. | fwi_vreme | datetime |
  2635. +--------------+-------------+
  2636.  
  2637. Database: meteo
  2638. Table: automatske_padavine
  2639. [7 columns]
  2640. +-----------+---------------+
  2641. | Column | Type |
  2642. +-----------+---------------+
  2643. | as_id | int(11) |
  2644. | podatak_2 | char(5) |
  2645. | podatak_3 | char(5) |
  2646. | podatak_5 | char(8) |
  2647. | pun_sat | enum('0','1') |
  2648. | stanica | char(5) |
  2649. | termin | datetime |
  2650. +-----------+---------------+
  2651.  
  2652. Database: meteo
  2653. Table: bioprognoza
  2654. [11 columns]
  2655. +----------------+-------------------+
  2656. | Column | Type |
  2657. +----------------+-------------------+
  2658. | bio_datum | date |
  2659. | bio_id | smallint(9) |
  2660. | bio_naslov | tinytext |
  2661. | bio_naslov_eng | tinytext |
  2662. | bio_s1 | enum('p','n','r') |
  2663. | bio_s2 | enum('p','n','r') |
  2664. | bio_s3 | enum('p','n','r') |
  2665. | bio_s4 | enum('p','n','r') |
  2666. | bio_s5 | enum('p','n','r') |
  2667. | bio_tekst | text |
  2668. | bio_tekst_eng | text |
  2669. +----------------+-------------------+
  2670.  
  2671. Database: meteo
  2672. Table: mteo_alarm_kriterijumi_kopija
  2673. [12 columns]
  2674. +---------------+---------------------------+
  2675. | Column | Type |
  2676. +---------------+---------------------------+
  2677. | kr_cir | tinytext |
  2678. | kr_do | date |
  2679. | kr_eng | tinytext |
  2680. | kr_id | int(11) |
  2681. | kr_kriterijum | char(10) |
  2682. | kr_lat | tinytext |
  2683. | kr_meteo_nivo | enum('2','3','4') |
  2684. | kr_od | date |
  2685. | kr_vrednost | enum('1','2','3','4','5') |
  2686. | ut_cir | text |
  2687. | ut_eng | text |
  2688. | ut_lat | text |
  2689. +---------------+---------------------------+
  2690.  
  2691. Database: meteo
  2692. Table: prognoza_sutra
  2693. [8 columns]
  2694. +-------------+----------+
  2695. | Column | Type |
  2696. +-------------+----------+
  2697. | mp_datum | datetime |
  2698. | mp_id | char(5) |
  2699. | mp_t1max | char(3) |
  2700. | mp_t1min | char(3) |
  2701. | mp_t1pojava | char(2) |
  2702. | mp_t2max | char(3) |
  2703. | mp_t2min | char(3) |
  2704. | mp_t2pojava | char(2) |
  2705. +-------------+----------+
  2706.  
  2707. Database: meteo
  2708. Table: automatske_stanice
  2709. [68 columns]
  2710. +-------------------------------------+---------------+
  2711. | Column | Type |
  2712. +-------------------------------------+---------------+
  2713. | as_id | int(11) |
  2714. | osuncanost_60_trajanje | char(2) |
  2715. | padavine_10_max | char(5) |
  2716. | padavine_1_max | char(5) |
  2717. | padavine_60 | char(5) |
  2718. | padavine_60_trajanje | char(2) |
  2719. | pritisak_morski | char(6) |
  2720. | pritisak_morski_60_max | char(6) |
  2721. | pritisak_morski_60_max_termin | datetime |
  2722. | pritisak_morski_60_min | char(6) |
  2723. | pritisak_morski_60_min_termin | datetime |
  2724. | pritisak_morski_60_srednji | char(6) |
  2725. | pritisak_stanicni | char(6) |
  2726. | pritisak_stanicni_60_max | char(6) |
  2727. | pritisak_stanicni_60_max_termin | datetime |
  2728. | pritisak_stanicni_60_min | char(6) |
  2729. | pritisak_stanicni_60_min_termin | datetime |
  2730. | pritisak_stanicni_60_srednji | char(6) |
  2731. | pritisak_tendencija_180 | char(4) |
  2732. | pritisak_tendencija_karakter_180 | char(1) |
  2733. | pun_sat | enum('0','1') |
  2734. | relativna_vlaznost | char(3) |
  2735. | relativna_vlaznost_60_max | char(3) |
  2736. | relativna_vlaznost_60_max_termin | datetime |
  2737. | relativna_vlaznost_60_min | char(3) |
  2738. | relativna_vlaznost_60_min_termin | datetime |
  2739. | relativna_vlaznost_60_srednja | char(3) |
  2740. | stanica | char(5) |
  2741. | tacka_rose | char(5) |
  2742. | tacka_rose_60_max | char(5) |
  2743. | tacka_rose_60_max_termin | datetime |
  2744. | tacka_rose_60_min | char(5) |
  2745. | tacka_rose_60_min_termin | datetime |
  2746. | tacka_rose_60_srednja | char(5) |
  2747. | temperatura | char(5) |
  2748. | temperatura_5cm_iznad | char(5) |
  2749. | temperatura_5cm_iznad_60_max | char(5) |
  2750. | temperatura_5cm_iznad_60_max_termin | datetime |
  2751. | temperatura_5cm_iznad_60_min | char(5) |
  2752. | temperatura_5cm_iznad_60_min_termin | datetime |
  2753. | temperatura_5cm_iznad_60_srednja | char(5) |
  2754. | temperatura_60_max | char(5) |
  2755. | temperatura_60_max_termin | datetime |
  2756. | temperatura_60_min | char(5) |
  2757. | temperatura_60_min_termin | datetime |
  2758. | temperatura_60_srednja | char(5) |
  2759. | temperatura_zemlja_100cm | char(5) |
  2760. | temperatura_zemlja_10cm | char(5) |
  2761. | temperatura_zemlja_20cm | char(5) |
  2762. | temperatura_zemlja_50cm | char(5) |
  2763. | temperatura_zemlja_5cm | char(5) |
  2764. | termin | datetime |
  2765. | vetar_10_brzina | char(4) |
  2766. | vetar_10_smer | char(3) |
  2767. | vetar_60_brzina | char(4) |
  2768. | vetar_60_smer | char(3) |
  2769. | vetar_smer_60_preovladjujuci | char(3) |
  2770. | vetar_udari_10_brzina | char(4) |
  2771. | vetar_udari_10_max_termin | datetime |
  2772. | vetar_udari_10_smer | char(3) |
  2773. | vetar_udari_60_brzina | char(4) |
  2774. | vetar_udari_60_max_termin | datetime |
  2775. | vetar_udari_60_smer | char(3) |
  2776. | zracenje | char(3) |
  2777. | zracenje_max | char(4) |
  2778. | zracenje_max_termin | datetime |
  2779. | zracenje_min | char(4) |
  2780. | zracenje_min_termin | datetime |
  2781. +-------------------------------------+---------------+
  2782.  
  2783. Database: meteo
  2784. Table: meteo_alarm_povratna
  2785. [19 columns]
  2786. +-------------------+------------+
  2787. | Column | Type |
  2788. +-------------------+------------+
  2789. | po_blagovremenost | tinytext |
  2790. | po_datum | datetime |
  2791. | po_email | tinytext |
  2792. | po_fwi | tinytext |
  2793. | po_hidro | tinytext |
  2794. | po_id | int(11) |
  2795. | po_ime | tinytext |
  2796. | po_izgled | tinytext |
  2797. | po_jednostavnost | tinytext |
  2798. | po_jezik | varchar(3) |
  2799. | po_kvalitet | tinytext |
  2800. | po_meteo | tinytext |
  2801. | po_napomena | text |
  2802. | po_poseta | tinytext |
  2803. | po_preporuka | tinytext |
  2804. | po_radar | tinytext |
  2805. | po_tacnost | tinytext |
  2806. | po_talas | tinytext |
  2807. | po_uv | tinytext |
  2808. +-------------------+------------+
  2809.  
  2810. Database: meteo
  2811. Table: prognoza_normale
  2812. [16 columns]
  2813. +--------+--------------+
  2814. | Column | Type |
  2815. +--------+--------------+
  2816. | a_10 | decimal(5,1) |
  2817. | a_2 | decimal(5,1) |
  2818. | a_25 | decimal(5,1) |
  2819. | a_50 | decimal(5,1) |
  2820. | a_75 | decimal(5,1) |
  2821. | a_90 | decimal(5,1) |
  2822. | a_98 | decimal(5,1) |
  2823. | datum | char(5) |
  2824. | i_10 | decimal(5,1) |
  2825. | i_2 | decimal(5,1) |
  2826. | i_25 | decimal(5,1) |
  2827. | i_50 | decimal(5,1) |
  2828. | i_75 | decimal(5,1) |
  2829. | i_90 | decimal(5,1) |
  2830. | i_98 | decimal(5,1) |
  2831. | id | char(5) |
  2832. +--------+--------------+
  2833.  
  2834. Database: meteo
  2835. Table: elektrane
  2836. [7 columns]
  2837. +---------------+--------------+
  2838. | Column | Type |
  2839. +---------------+--------------+
  2840. | el_azur | timestamp |
  2841. | el_datum | datetime |
  2842. | el_id | mediumint(9) |
  2843. | el_opis | tinytext |
  2844. | el_temp | tinyint(4) |
  2845. | el_vetar_max | tinyint(4) |
  2846. | el_vetar_sred | tinyint(4) |
  2847. +---------------+--------------+
  2848.  
  2849. Database: meteo
  2850. Table: agro_temperature
  2851. [5 columns]
  2852. +----------+---------+
  2853. | Column | Type |
  2854. +----------+---------+
  2855. | id | int(11) |
  2856. | mo_id | char(5) |
  2857. | mo_max | char(5) |
  2858. | mo_min | char(5) |
  2859. | mo_vreme | date |
  2860. +----------+---------+
  2861.  
  2862. Database: meteo
  2863. Table: meteo_alarm
  2864. [181 columns]
  2865. +---------------------+------------+
  2866. | Column | Type |
  2867. +---------------------+------------+
  2868. | ma_azurirano | datetime |
  2869. | ma_ba_grmljavina | tinyint(1) |
  2870. | ma_ba_grmljavina_kr | tinyint(1) |
  2871. | ma_ba_kisa | tinyint(1) |
  2872. | ma_ba_kisa_kr | tinyint(1) |
  2873. | ma_ba_magla | tinyint(1) |
  2874. | ma_ba_magla_kr | tinyint(1) |
  2875. | ma_ba_max_temp | tinyint(1) |
  2876. | ma_ba_max_temp_kr | tinyint(1) |
  2877. | ma_ba_min_temp | tinyint(1) |
  2878. | ma_ba_min_temp_kr | tinyint(1) |
  2879. | ma_ba_sneg | tinyint(1) |
  2880. | ma_ba_sneg_kr | tinyint(1) |
  2881. | ma_ba_sume | tinyint(1) |
  2882. | ma_ba_sume_kr | tinyint(1) |
  2883. | ma_ba_vetar | tinyint(1) |
  2884. | ma_ba_vetar_kr | tinyint(1) |
  2885. | ma_bc_grmljavina | tinyint(1) |
  2886. | ma_bc_grmljavina_kr | tinyint(1) |
  2887. | ma_bc_kisa | tinyint(1) |
  2888. | ma_bc_kisa_kr | tinyint(1) |
  2889. | ma_bc_magla | tinyint(1) |
  2890. | ma_bc_magla_kr | tinyint(1) |
  2891. | ma_bc_max_temp | tinyint(1) |
  2892. | ma_bc_max_temp_kr | tinyint(1) |
  2893. | ma_bc_min_temp | tinyint(1) |
  2894. | ma_bc_min_temp_kr | tinyint(1) |
  2895. | ma_bc_sneg | tinyint(1) |
  2896. | ma_bc_sneg_kr | tinyint(1) |
  2897. | ma_bc_sume | tinyint(1) |
  2898. | ma_bc_sume_kr | tinyint(1) |
  2899. | ma_bc_vetar | tinyint(1) |
  2900. | ma_bc_vetar_kr | tinyint(1) |
  2901. | ma_bg_grmljavina | tinyint(1) |
  2902. | ma_bg_grmljavina_kr | tinyint(1) |
  2903. | ma_bg_kisa | tinyint(1) |
  2904. | ma_bg_kisa_kr | tinyint(1) |
  2905. | ma_bg_magla | tinyint(1) |
  2906. | ma_bg_magla_kr | tinyint(1) |
  2907. | ma_bg_max_temp | tinyint(1) |
  2908. | ma_bg_max_temp_kr | tinyint(1) |
  2909. | ma_bg_min_temp | tinyint(1) |
  2910. | ma_bg_min_temp_kr | tinyint(1) |
  2911. | ma_bg_sneg | tinyint(1) |
  2912. | ma_bg_sneg_kr | tinyint(1) |
  2913. | ma_bg_sume | tinyint(1) |
  2914. | ma_bg_sume_kr | tinyint(1) |
  2915. | ma_bg_vetar | tinyint(1) |
  2916. | ma_bg_vetar_kr | tinyint(1) |
  2917. | ma_datum | date |
  2918. | ma_id | int(11) |
  2919. | ma_is_grmljavina | tinyint(1) |
  2920. | ma_is_grmljavina_kr | tinyint(1) |
  2921. | ma_is_kisa | tinyint(1) |
  2922. | ma_is_kisa_kr | tinyint(1) |
  2923. | ma_is_magla | tinyint(1) |
  2924. | ma_is_magla_kr | tinyint(1) |
  2925. | ma_is_max_temp | tinyint(1) |
  2926. | ma_is_max_temp_kr | tinyint(1) |
  2927. | ma_is_min_temp | tinyint(1) |
  2928. | ma_is_min_temp_kr | tinyint(1) |
  2929. | ma_is_sneg | tinyint(1) |
  2930. | ma_is_sneg_kr | tinyint(1) |
  2931. | ma_is_sume | tinyint(1) |
  2932. | ma_is_sume_kr | tinyint(1) |
  2933. | ma_is_vetar | tinyint(1) |
  2934. | ma_is_vetar_kr | tinyint(1) |
  2935. | ma_ji_grmljavina | tinyint(1) |
  2936. | ma_ji_grmljavina_kr | tinyint(1) |
  2937. | ma_ji_kisa | tinyint(1) |
  2938. | ma_ji_kisa_kr | tinyint(1) |
  2939. | ma_ji_magla | tinyint(1) |
  2940. | ma_ji_magla_kr | tinyint(1) |
  2941. | ma_ji_max_temp | tinyint(1) |
  2942. | ma_ji_max_temp_kr | tinyint(1) |
  2943. | ma_ji_min_temp | tinyint(1) |
  2944. | ma_ji_min_temp_kr | tinyint(1) |
  2945. | ma_ji_sneg | tinyint(1) |
  2946. | ma_ji_sneg_kr | tinyint(1) |
  2947. | ma_ji_sume | tinyint(1) |
  2948. | ma_ji_sume_kr | tinyint(1) |
  2949. | ma_ji_vetar | tinyint(1) |
  2950. | ma_ji_vetar_kr | tinyint(1) |
  2951. | ma_jz_grmljavina | tinyint(1) |
  2952. | ma_jz_grmljavina_kr | tinyint(1) |
  2953. | ma_jz_kisa | tinyint(1) |
  2954. | ma_jz_kisa_kr | tinyint(1) |
  2955. | ma_jz_magla | tinyint(1) |
  2956. | ma_jz_magla_kr | tinyint(1) |
  2957. | ma_jz_max_temp | tinyint(1) |
  2958. | ma_jz_max_temp_kr | tinyint(1) |
  2959. | ma_jz_min_temp | tinyint(1) |
  2960. | ma_jz_min_temp_kr | tinyint(1) |
  2961. | ma_jz_sneg | tinyint(1) |
  2962. | ma_jz_sneg_kr | tinyint(1) |
  2963. | ma_jz_sume | tinyint(1) |
  2964. | ma_jz_sume_kr | tinyint(1) |
  2965. | ma_jz_vetar | tinyint(1) |
  2966. | ma_jz_vetar_kr | tinyint(1) |
  2967. | ma_km_grmljavina | tinyint(1) |
  2968. | ma_km_grmljavina_kr | tinyint(1) |
  2969. | ma_km_kisa | tinyint(1) |
  2970. | ma_km_kisa_kr | tinyint(1) |
  2971. | ma_km_magla | tinyint(1) |
  2972. | ma_km_magla_kr | tinyint(1) |
  2973. | ma_km_max_temp | tinyint(1) |
  2974. | ma_km_max_temp_kr | tinyint(1) |
  2975. | ma_km_min_temp | tinyint(1) |
  2976. | ma_km_min_temp_kr | tinyint(1) |
  2977. | ma_km_sneg | tinyint(1) |
  2978. | ma_km_sneg_kr | tinyint(1) |
  2979. | ma_km_sume | tinyint(1) |
  2980. | ma_km_sume_kr | tinyint(1) |
  2981. | ma_km_vetar | tinyint(1) |
  2982. | ma_km_vetar_kr | tinyint(1) |
  2983. | ma_po_grmljavina | tinyint(1) |
  2984. | ma_po_grmljavina_kr | tinyint(1) |
  2985. | ma_po_kisa | tinyint(1) |
  2986. | ma_po_kisa_kr | tinyint(1) |
  2987. | ma_po_magla | tinyint(1) |
  2988. | ma_po_magla_kr | tinyint(1) |
  2989. | ma_po_max_temp | tinyint(1) |
  2990. | ma_po_max_temp_kr | tinyint(1) |
  2991. | ma_po_min_temp | tinyint(1) |
  2992. | ma_po_min_temp_kr | tinyint(1) |
  2993. | ma_po_sneg | tinyint(1) |
  2994. | ma_po_sneg_kr | tinyint(1) |
  2995. | ma_po_sume | tinyint(1) |
  2996. | ma_po_sume_kr | tinyint(1) |
  2997. | ma_po_vetar | tinyint(1) |
  2998. | ma_po_vetar_kr | tinyint(1) |
  2999. | ma_sr_grmljavina | tinyint(1) |
  3000. | ma_sr_grmljavina_kr | tinyint(1) |
  3001. | ma_sr_kisa | tinyint(1) |
  3002. | ma_sr_kisa_kr | tinyint(1) |
  3003. | ma_sr_magla | tinyint(1) |
  3004. | ma_sr_magla_kr | tinyint(1) |
  3005. | ma_sr_max_temp | tinyint(1) |
  3006. | ma_sr_max_temp_kr | tinyint(1) |
  3007. | ma_sr_min_temp | tinyint(1) |
  3008. | ma_sr_min_temp_kr | tinyint(1) |
  3009. | ma_sr_sneg | tinyint(1) |
  3010. | ma_sr_sneg_kr | tinyint(1) |
  3011. | ma_sr_sume | tinyint(1) |
  3012. | ma_sr_sume_kr | tinyint(1) |
  3013. | ma_sr_vetar | tinyint(1) |
  3014. | ma_sr_vetar_kr | tinyint(1) |
  3015. | ma_su_grmljavina | tinyint(1) |
  3016. | ma_su_grmljavina_kr | tinyint(1) |
  3017. | ma_su_kisa | tinyint(1) |
  3018. | ma_su_kisa_kr | tinyint(1) |
  3019. | ma_su_magla | tinyint(1) |
  3020. | ma_su_magla_kr | tinyint(1) |
  3021. | ma_su_max_temp | tinyint(1) |
  3022. | ma_su_max_temp_kr | tinyint(1) |
  3023. | ma_su_min_temp | tinyint(1) |
  3024. | ma_su_min_temp_kr | tinyint(1) |
  3025. | ma_su_sneg | tinyint(1) |
  3026. | ma_su_sneg_kr | tinyint(1) |
  3027. | ma_su_sume | tinyint(1) |
  3028. | ma_su_sume_kr | tinyint(1) |
  3029. | ma_su_vetar | tinyint(1) |
  3030. | ma_su_vetar_kr | tinyint(1) |
  3031. | ma_zs_grmljavina | tinyint(1) |
  3032. | ma_zs_grmljavina_kr | tinyint(1) |
  3033. | ma_zs_kisa | tinyint(1) |
  3034. | ma_zs_kisa_kr | tinyint(1) |
  3035. | ma_zs_magla | tinyint(1) |
  3036. | ma_zs_magla_kr | tinyint(1) |
  3037. | ma_zs_max_temp | tinyint(1) |
  3038. | ma_zs_max_temp_kr | tinyint(1) |
  3039. | ma_zs_min_temp | tinyint(1) |
  3040. | ma_zs_min_temp_kr | tinyint(1) |
  3041. | ma_zs_sneg | tinyint(1) |
  3042. | ma_zs_sneg_kr | tinyint(1) |
  3043. | ma_zs_sume | tinyint(1) |
  3044. | ma_zs_sume_kr | tinyint(1) |
  3045. | ma_zs_vetar | tinyint(1) |
  3046. | ma_zs_vetar_kr | tinyint(1) |
  3047. | maks | tinyint(4) |
  3048. | tekst | text |
  3049. +---------------------+------------+
  3050.  
  3051. Database: meteo
  3052. Table: mreza_evropa
  3053. [2 columns]
  3054. +----------+----------+
  3055. | Column | Type |
  3056. +----------+----------+
  3057. | ms_id | char(5) |
  3058. | ms_naziv | tinytext |
  3059. +----------+----------+
  3060.  
  3061. Database: meteo
  3062. Table: pojave_pr
  3063. [3 columns]
  3064. +-------------+----------+
  3065. | Column | Type |
  3066. +-------------+----------+
  3067. | pr_id | char(2) |
  3068. | pr_opis_eng | tinytext |
  3069. | pr_opis_lat | tinytext |
  3070. +-------------+----------+
  3071.  
  3072. Database: meteo
  3073. Table: elektrane_dnevni_2012
  3074. [8 columns]
  3075. +---------------+--------------+
  3076. | Column | Type |
  3077. +---------------+--------------+
  3078. | el_azur | timestamp |
  3079. | el_datum | date |
  3080. | el_id | mediumint(9) |
  3081. | el_opis | tinytext |
  3082. | el_temp_max | tinyint(4) |
  3083. | el_temp_min | tinyint(4) |
  3084. | el_vetar_max | tinyint(4) |
  3085. | el_vetar_sred | tinyint(4) |
  3086. +---------------+--------------+
  3087.  
  3088. Database: meteo
  3089. Table: elektrane_dnevni_2011
  3090. [8 columns]
  3091. +---------------+--------------+
  3092. | Column | Type |
  3093. +---------------+--------------+
  3094. | el_azur | timestamp |
  3095. | el_datum | date |
  3096. | el_id | mediumint(9) |
  3097. | el_opis | tinytext |
  3098. | el_temp_max | tinyint(4) |
  3099. | el_temp_min | tinyint(4) |
  3100. | el_vetar_max | tinyint(4) |
  3101. | el_vetar_sred | tinyint(4) |
  3102. +---------------+--------------+
  3103.  
  3104. Database: meteo
  3105. Table: osmotreni_evropa
  3106. [6 columns]
  3107. +-----------+---------+
  3108. | Column | Type |
  3109. +-----------+---------+
  3110. | mo_id | char(5) |
  3111. | mo_opis | char(2) |
  3112. | mo_prit | char(6) |
  3113. | mo_temp | char(5) |
  3114. | mo_vetbrz | char(4) |
  3115. | mo_vetpra | char(4) |
  3116. +-----------+---------+
  3117.  
  3118. Database: meteo
  3119. Table: pojave_os
  3120. [3 columns]
  3121. +-------------+----------+
  3122. | Column | Type |
  3123. +-------------+----------+
  3124. | op_id | char(2) |
  3125. | op_opis_eng | tinytext |
  3126. | op_opis_lat | tinytext |
  3127. +-------------+----------+
  3128.  
  3129. Database: meteo
  3130. Table: prognoza_nmm_sati
  3131. [8 columns]
  3132. +--------+-------------+
  3133. | Column | Type |
  3134. +--------+-------------+
  3135. | pad | varchar(5) |
  3136. | brzina | varchar(5) |
  3137. | datum | date |
  3138. | mesto | varchar(40) |
  3139. | pravac | varchar(5) |
  3140. | sati | char(2) |
  3141. | temp | varchar(5) |
  3142. | udari | varchar(5) |
  3143. +--------+-------------+
  3144.  
  3145. Database: meteo
  3146. Table: uv_dwd
  3147. [4 columns]
  3148. +-------------+---------+
  3149. | Column | Type |
  3150. +-------------+---------+
  3151. | uv_datum | date |
  3152. | uv_id | int(11) |
  3153. | uv_stanica | char(5) |
  3154. | uv_vrednost | char(4) |
  3155. +-------------+---------+
  3156.  
  3157. Database: meteo
  3158. Table: osmotreni_synop
  3159. [22 columns]
  3160. +----------------+----------+
  3161. | Column | Type |
  3162. +----------------+----------+
  3163. | id | int(11) |
  3164. | mo_id | char(5) |
  3165. | mo_opis | char(2) |
  3166. | mo_prit | char(6) |
  3167. | mo_prit_sveden | char(6) |
  3168. | mo_sada | datetime |
  3169. | mo_temp | char(5) |
  3170. | mo_vetbrz | char(4) |
  3171. | mo_vetpra | char(3) |
  3172. | mo_vlaz | char(3) |
  3173. | mo_vreme | datetime |
  3174. | mo_vreme_utc | datetime |
  3175. | padavine_12h | char(3) |
  3176. | padavine_6h | char(3) |
  3177. | sneg | char(3) |
  3178. | t_5cm | char(5) |
  3179. | t_max | char(5) |
  3180. | t_min | char(5) |
  3181. | tlo | char(1) |
  3182. | tlo_sneg | char(1) |
  3183. | vetar_udari | char(2) |
  3184. | vidljivost | char(5) |
  3185. +----------------+----------+
  3186.  
  3187. Database: meteo
  3188. Table: synop_rucno
  3189. [24 columns]
  3190. +---------+----------+
  3191. | Column | Type |
  3192. +---------+----------+
  3193. | id | int(11) |
  3194. | p1 | char(5) |
  3195. | p10 | char(5) |
  3196. | p11 | char(5) |
  3197. | p12 | char(5) |
  3198. | p13 | char(5) |
  3199. | p14 | char(5) |
  3200. | p15 | char(5) |
  3201. | p16 | char(5) |
  3202. | p17 | char(5) |
  3203. | p18 | char(5) |
  3204. | p19 | char(5) |
  3205. | p2 | char(5) |
  3206. | p20 | char(5) |
  3207. | p3 | char(5) |
  3208. | p4 | char(5) |
  3209. | p5 | char(5) |
  3210. | p6 | char(5) |
  3211. | p7 | char(5) |
  3212. | p8 | char(5) |
  3213. | p9 | char(5) |
  3214. | stanica | char(5) |
  3215. | termin | datetime |
  3216. | vreme | datetime |
  3217. +---------+----------+
  3218.  
  3219. Database: meteo
  3220. Table: p3_nmm_dwd_gradovi
  3221. [3 columns]
  3222. +--------+-------------+
  3223. | Column | Type |
  3224. +--------+-------------+
  3225. | ciril | varchar(50) |
  3226. | id | tinyint(4) |
  3227. | latin | varchar(50) |
  3228. +--------+-------------+
  3229.  
  3230. Database: meteo
  3231. Table: osmotreni_sneg
  3232. [3 columns]
  3233. +--------------+----------+
  3234. | Column | Type |
  3235. +--------------+----------+
  3236. | sg_id | char(5) |
  3237. | sg_prirastaj | char(10) |
  3238. | sg_visina | char(10) |
  3239. +--------------+----------+
  3240.  
  3241. Database: mysql
  3242. Table: user
  3243. [36 entries]
  3244. +-------------------------+-------------+------------------+
  3245. | Host | User | Password |
  3246. +-------------------------+-------------+------------------+
  3247. | localhost | root | 28235f1213d6bf53 |
  3248. | web-rhmz | root | 28235f1213d6bf53 |
  3249. | % | hidmet | 7b50e0f31e3bdf27 |
  3250. | localhost | pgz_pise | 37acb19c4c7698a8 |
  3251. | localhost | hidmet | 7b50e0f31e3bdf27 |
  3252. | localhost | pgz_cita | 37d5ec664bca533e |
  3253. | localhost | pgz_sve | 0f94e69c7f70003e |
  3254. | localhost | meteo_cita | 0041af2a6a384af6 |
  3255. | localhost | meteo_pise | 032c829870485d85 |
  3256. | localhost | meteo_sve | 7fac065010fa444e |
  3257. | % | meteo_pise | 032c829870485d85 |
  3258. | % | meteo_cita | 0041af2a6a384af6 |
  3259. | % | pgz_cita | 37d5ec664bca533e |
  3260. | % | pod_sve | 18a316fe6cadc6ca |
  3261. | localhost | pod_cita | 7bd743630e0fca31 |
  3262. | % | pod_cita | 7bd743630e0fca31 |
  3263. | localhost | pod_sve | 18a316fe6cadc6ca |
  3264. | % | kvvoda_cita | 039c178642312fe9 |
  3265. | localhost | kvvoda_cita | 039c178642312fe9 |
  3266. | localhost | kvvoda_sve | 4cdab8a100da5fb2 |
  3267. | % | kvvoda_sve | 4cdab8a100da5fb2 |
  3268. | localhost | opsti | 5561b88400eee439 |
  3269. | localhost | hidro | 66ff4bc113494af7 |
  3270. | % | hidro | 66ff4bc113494af7 |
  3271. | godisnjak.hidmet.gov.rs | root | 28235f1213d6bf53 |
  3272. | localhost | gms | 1717a9a738a727a2 |
  3273. | % | crnubg | 74fe57714e9505ab |
  3274. | % | crnuns | 0a5c485018a2d170 |
  3275. | % | crnuni | 411149246a3aa0fd |
  3276. | % | crnukv | 464eaa98536cdf71 |
  3277. | % | klima1 | 4959be3f53aaa8b8 |
  3278. | % | agro1 | 7bc2ea3a30083c6b |
  3279. | localhost | moss | 39220f7a303b6708 |
  3280. | % | klimadj | 1846873e14eb72b3 |
  3281. | localhost | podvod | 4f53795222a37dfa |
  3282. | % | pov | 78d7fddb27fc3ca2 |
  3283. +-------------------------+-------------+------------------+
  3284.  
  3285. __________________________________________________________________________________________________
  3286. ##################################################################################################
  3287. megafab.net
  3288. twitter.com/M3GAFAB
  3289. fb.com/M3GAFABB
  3290. instagram.com/M3GAFAB ..
  3291. ##################################################################################################
  3292. __________________________________________________________________________________________________
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement