· 6 years ago · Jul 03, 2019, 04:02 PM
1# WordPress MySQL database migration
2#
3# Generated: Friday 28. June 2019 18:39 UTC
4# Hostname: localhost
5# Database: `wordpress`
6# URL: //www.wordpress4.com
7# Path: C:\\wamp64\\www\\isidoranikolic\\wordpress
8# Tables: wp_commentmeta, wp_comments, wp_links, wp_options, wp_postmeta, wp_posts, wp_term_relationships, wp_term_taxonomy, wp_termmeta, wp_terms, wp_usermeta, wp_users
9# Table Prefix: wp_
10# Post Types: revision, customize_changeset, nav_menu_item, page, post
11# Protocol: http
12# Multisite: false
13# Subsite Export: false
14# --------------------------------------------------------
15
16/*!40101 SET NAMES utf8mb4 */;
17
18SET sql_mode='NO_AUTO_VALUE_ON_ZERO';
19
20
21
22#
23# Delete any existing table `wp_commentmeta`
24#
25
26DROP TABLE IF EXISTS `wp_commentmeta`;
27
28
29#
30# Table structure of table `wp_commentmeta`
31#
32
33CREATE TABLE `wp_commentmeta` (
34 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
35 `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
36 `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
37 `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
38 PRIMARY KEY (`meta_id`),
39 KEY `comment_id` (`comment_id`),
40 KEY `meta_key` (`meta_key`(191))
41) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
42
43
44#
45# Data contents of table `wp_commentmeta`
46#
47
48#
49# End of data contents of table `wp_commentmeta`
50# --------------------------------------------------------
51
52
53
54#
55# Delete any existing table `wp_comments`
56#
57
58DROP TABLE IF EXISTS `wp_comments`;
59
60
61#
62# Table structure of table `wp_comments`
63#
64
65CREATE TABLE `wp_comments` (
66 `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
67 `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
68 `comment_author` tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL,
69 `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
70 `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
71 `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
72 `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
73 `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
74 `comment_content` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
75 `comment_karma` int(11) NOT NULL DEFAULT '0',
76 `comment_approved` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1',
77 `comment_agent` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
78 `comment_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
79 `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
80 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
81 PRIMARY KEY (`comment_ID`),
82 KEY `comment_post_ID` (`comment_post_ID`),
83 KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
84 KEY `comment_date_gmt` (`comment_date_gmt`),
85 KEY `comment_parent` (`comment_parent`),
86 KEY `comment_author_email` (`comment_author_email`(10))
87) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
88
89
90#
91# Data contents of table `wp_comments`
92#
93INSERT INTO `wp_comments` ( `comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES
94(1, 1, 'A WordPress Commenter', 'wapuu@wordpress.example', 'https://wordpress.org/', '', '2019-06-28 16:02:46', '2019-06-28 16:02:46', 'Hi, this is a comment.\nTo get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.\nCommenter avatars come from <a href="https://gravatar.com">Gravatar</a>.', 0, '1', '', '', 0, 0) ;
95
96#
97# End of data contents of table `wp_comments`
98# --------------------------------------------------------
99
100
101
102#
103# Delete any existing table `wp_links`
104#
105
106DROP TABLE IF EXISTS `wp_links`;
107
108
109#
110# Table structure of table `wp_links`
111#
112
113CREATE TABLE `wp_links` (
114 `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
115 `link_url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
116 `link_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
117 `link_image` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
118 `link_target` varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
119 `link_description` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
120 `link_visible` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
121 `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
122 `link_rating` int(11) NOT NULL DEFAULT '0',
123 `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
124 `link_rel` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
125 `link_notes` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
126 `link_rss` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
127 PRIMARY KEY (`link_id`),
128 KEY `link_visible` (`link_visible`)
129) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
130
131
132#
133# Data contents of table `wp_links`
134#
135
136#
137# End of data contents of table `wp_links`
138# --------------------------------------------------------
139
140
141
142#
143# Delete any existing table `wp_options`
144#
145
146DROP TABLE IF EXISTS `wp_options`;
147
148
149#
150# Table structure of table `wp_options`
151#
152
153CREATE TABLE `wp_options` (
154 `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
155 `option_name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
156 `option_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
157 `autoload` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes',
158 PRIMARY KEY (`option_id`),
159 UNIQUE KEY `option_name` (`option_name`)
160) ENGINE=MyISAM AUTO_INCREMENT=186 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
161
162
163#
164# Data contents of table `wp_options`
165#
166INSERT INTO `wp_options` ( `option_id`, `option_name`, `option_value`, `autoload`) VALUES
167(1, 'siteurl', 'http://www.wordpress4.com', 'yes'),
168(2, 'home', 'http://www.wordpress4.com', 'yes'),
169(3, 'blogname', 'wordpress', 'yes'),
170(4, 'blogdescription', 'Just another WordPress site', 'yes'),
171(5, 'users_can_register', '0', 'yes'),
172(6, 'admin_email', 'igor.janosevic@it-akademija.com', 'yes'),
173(7, 'start_of_week', '1', 'yes'),
174(8, 'use_balanceTags', '0', 'yes'),
175(9, 'use_smilies', '1', 'yes'),
176(10, 'require_name_email', '1', 'yes'),
177(11, 'comments_notify', '1', 'yes'),
178(12, 'posts_per_rss', '10', 'yes'),
179(13, 'rss_use_excerpt', '0', 'yes'),
180(14, 'mailserver_url', 'mail.example.com', 'yes'),
181(15, 'mailserver_login', 'login@example.com', 'yes'),
182(16, 'mailserver_pass', 'password', 'yes'),
183(17, 'mailserver_port', '110', 'yes'),
184(18, 'default_category', '1', 'yes'),
185(19, 'default_comment_status', 'open', 'yes'),
186(20, 'default_ping_status', 'open', 'yes'),
187(21, 'default_pingback_flag', '0', 'yes'),
188(22, 'posts_per_page', '10', 'yes'),
189(23, 'date_format', 'F j, Y', 'yes'),
190(24, 'time_format', 'g:i a', 'yes'),
191(25, 'links_updated_date_format', 'F j, Y g:i a', 'yes'),
192(26, 'comment_moderation', '0', 'yes'),
193(27, 'moderation_notify', '1', 'yes'),
194(28, 'permalink_structure', '/%postname%/', 'yes'),
195(29, 'rewrite_rules', 'a:87:{s:11:"^wp-json/?$";s:22:"index.php?rest_route=/";s:14:"^wp-json/(.*)?";s:33:"index.php?rest_route=/$matches[1]";s:21:"^index.php/wp-json/?$";s:22:"index.php?rest_route=/";s:24:"^index.php/wp-json/(.*)?";s:33:"index.php?rest_route=/$matches[1]";s:47:"category/(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$";s:52:"index.php?category_name=$matches[1]&feed=$matches[2]";s:42:"category/(.+?)/(feed|rdf|rss|rss2|atom)/?$";s:52:"index.php?category_name=$matches[1]&feed=$matches[2]";s:23:"category/(.+?)/embed/?$";s:46:"index.php?category_name=$matches[1]&embed=true";s:35:"category/(.+?)/page/?([0-9]{1,})/?$";s:53:"index.php?category_name=$matches[1]&paged=$matches[2]";s:17:"category/(.+?)/?$";s:35:"index.php?category_name=$matches[1]";s:44:"tag/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?tag=$matches[1]&feed=$matches[2]";s:39:"tag/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?tag=$matches[1]&feed=$matches[2]";s:20:"tag/([^/]+)/embed/?$";s:36:"index.php?tag=$matches[1]&embed=true";s:32:"tag/([^/]+)/page/?([0-9]{1,})/?$";s:43:"index.php?tag=$matches[1]&paged=$matches[2]";s:14:"tag/([^/]+)/?$";s:25:"index.php?tag=$matches[1]";s:45:"type/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?post_format=$matches[1]&feed=$matches[2]";s:40:"type/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?post_format=$matches[1]&feed=$matches[2]";s:21:"type/([^/]+)/embed/?$";s:44:"index.php?post_format=$matches[1]&embed=true";s:33:"type/([^/]+)/page/?([0-9]{1,})/?$";s:51:"index.php?post_format=$matches[1]&paged=$matches[2]";s:15:"type/([^/]+)/?$";s:33:"index.php?post_format=$matches[1]";s:48:".*wp-(atom|rdf|rss|rss2|feed|commentsrss2)\\.php$";s:18:"index.php?feed=old";s:20:".*wp-app\\.php(/.*)?$";s:19:"index.php?error=403";s:18:".*wp-register.php$";s:23:"index.php?register=true";s:32:"feed/(feed|rdf|rss|rss2|atom)/?$";s:27:"index.php?&feed=$matches[1]";s:27:"(feed|rdf|rss|rss2|atom)/?$";s:27:"index.php?&feed=$matches[1]";s:8:"embed/?$";s:21:"index.php?&embed=true";s:20:"page/?([0-9]{1,})/?$";s:28:"index.php?&paged=$matches[1]";s:27:"comment-page-([0-9]{1,})/?$";s:38:"index.php?&page_id=7&cpage=$matches[1]";s:41:"comments/feed/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?&feed=$matches[1]&withcomments=1";s:36:"comments/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?&feed=$matches[1]&withcomments=1";s:17:"comments/embed/?$";s:21:"index.php?&embed=true";s:44:"search/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:40:"index.php?s=$matches[1]&feed=$matches[2]";s:39:"search/(.+)/(feed|rdf|rss|rss2|atom)/?$";s:40:"index.php?s=$matches[1]&feed=$matches[2]";s:20:"search/(.+)/embed/?$";s:34:"index.php?s=$matches[1]&embed=true";s:32:"search/(.+)/page/?([0-9]{1,})/?$";s:41:"index.php?s=$matches[1]&paged=$matches[2]";s:14:"search/(.+)/?$";s:23:"index.php?s=$matches[1]";s:47:"author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?author_name=$matches[1]&feed=$matches[2]";s:42:"author/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?author_name=$matches[1]&feed=$matches[2]";s:23:"author/([^/]+)/embed/?$";s:44:"index.php?author_name=$matches[1]&embed=true";s:35:"author/([^/]+)/page/?([0-9]{1,})/?$";s:51:"index.php?author_name=$matches[1]&paged=$matches[2]";s:17:"author/([^/]+)/?$";s:33:"index.php?author_name=$matches[1]";s:69:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$";s:80:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]";s:64:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$";s:80:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]";s:45:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/embed/?$";s:74:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&embed=true";s:57:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$";s:81:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&paged=$matches[4]";s:39:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$";s:63:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]";s:56:"([0-9]{4})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$";s:64:"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]";s:51:"([0-9]{4})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$";s:64:"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]";s:32:"([0-9]{4})/([0-9]{1,2})/embed/?$";s:58:"index.php?year=$matches[1]&monthnum=$matches[2]&embed=true";s:44:"([0-9]{4})/([0-9]{1,2})/page/?([0-9]{1,})/?$";s:65:"index.php?year=$matches[1]&monthnum=$matches[2]&paged=$matches[3]";s:26:"([0-9]{4})/([0-9]{1,2})/?$";s:47:"index.php?year=$matches[1]&monthnum=$matches[2]";s:43:"([0-9]{4})/feed/(feed|rdf|rss|rss2|atom)/?$";s:43:"index.php?year=$matches[1]&feed=$matches[2]";s:38:"([0-9]{4})/(feed|rdf|rss|rss2|atom)/?$";s:43:"index.php?year=$matches[1]&feed=$matches[2]";s:19:"([0-9]{4})/embed/?$";s:37:"index.php?year=$matches[1]&embed=true";s:31:"([0-9]{4})/page/?([0-9]{1,})/?$";s:44:"index.php?year=$matches[1]&paged=$matches[2]";s:13:"([0-9]{4})/?$";s:26:"index.php?year=$matches[1]";s:27:".?.+?/attachment/([^/]+)/?$";s:32:"index.php?attachment=$matches[1]";s:37:".?.+?/attachment/([^/]+)/trackback/?$";s:37:"index.php?attachment=$matches[1]&tb=1";s:57:".?.+?/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:52:".?.+?/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:52:".?.+?/attachment/([^/]+)/comment-page-([0-9]{1,})/?$";s:50:"index.php?attachment=$matches[1]&cpage=$matches[2]";s:33:".?.+?/attachment/([^/]+)/embed/?$";s:43:"index.php?attachment=$matches[1]&embed=true";s:16:"(.?.+?)/embed/?$";s:41:"index.php?pagename=$matches[1]&embed=true";s:20:"(.?.+?)/trackback/?$";s:35:"index.php?pagename=$matches[1]&tb=1";s:40:"(.?.+?)/feed/(feed|rdf|rss|rss2|atom)/?$";s:47:"index.php?pagename=$matches[1]&feed=$matches[2]";s:35:"(.?.+?)/(feed|rdf|rss|rss2|atom)/?$";s:47:"index.php?pagename=$matches[1]&feed=$matches[2]";s:28:"(.?.+?)/page/?([0-9]{1,})/?$";s:48:"index.php?pagename=$matches[1]&paged=$matches[2]";s:35:"(.?.+?)/comment-page-([0-9]{1,})/?$";s:48:"index.php?pagename=$matches[1]&cpage=$matches[2]";s:24:"(.?.+?)(?:/([0-9]+))?/?$";s:47:"index.php?pagename=$matches[1]&page=$matches[2]";s:27:"[^/]+/attachment/([^/]+)/?$";s:32:"index.php?attachment=$matches[1]";s:37:"[^/]+/attachment/([^/]+)/trackback/?$";s:37:"index.php?attachment=$matches[1]&tb=1";s:57:"[^/]+/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:52:"[^/]+/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:52:"[^/]+/attachment/([^/]+)/comment-page-([0-9]{1,})/?$";s:50:"index.php?attachment=$matches[1]&cpage=$matches[2]";s:33:"[^/]+/attachment/([^/]+)/embed/?$";s:43:"index.php?attachment=$matches[1]&embed=true";s:16:"([^/]+)/embed/?$";s:37:"index.php?name=$matches[1]&embed=true";s:20:"([^/]+)/trackback/?$";s:31:"index.php?name=$matches[1]&tb=1";s:40:"([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:43:"index.php?name=$matches[1]&feed=$matches[2]";s:35:"([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:43:"index.php?name=$matches[1]&feed=$matches[2]";s:28:"([^/]+)/page/?([0-9]{1,})/?$";s:44:"index.php?name=$matches[1]&paged=$matches[2]";s:35:"([^/]+)/comment-page-([0-9]{1,})/?$";s:44:"index.php?name=$matches[1]&cpage=$matches[2]";s:24:"([^/]+)(?:/([0-9]+))?/?$";s:43:"index.php?name=$matches[1]&page=$matches[2]";s:16:"[^/]+/([^/]+)/?$";s:32:"index.php?attachment=$matches[1]";s:26:"[^/]+/([^/]+)/trackback/?$";s:37:"index.php?attachment=$matches[1]&tb=1";s:46:"[^/]+/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:41:"[^/]+/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:41:"[^/]+/([^/]+)/comment-page-([0-9]{1,})/?$";s:50:"index.php?attachment=$matches[1]&cpage=$matches[2]";s:22:"[^/]+/([^/]+)/embed/?$";s:43:"index.php?attachment=$matches[1]&embed=true";}', 'yes'),
196(30, 'hack_file', '0', 'yes'),
197(31, 'blog_charset', 'UTF-8', 'yes'),
198(32, 'moderation_keys', '', 'no'),
199(33, 'active_plugins', 'a:1:{i:0;s:31:"wp-migrate-db/wp-migrate-db.php";}', 'yes'),
200(34, 'category_base', '', 'yes'),
201(35, 'ping_sites', 'http://rpc.pingomatic.com/', 'yes'),
202(36, 'comment_max_links', '2', 'yes'),
203(37, 'gmt_offset', '0', 'yes'),
204(38, 'default_email_category', '1', 'yes'),
205(39, 'recently_edited', '', 'no'),
206(40, 'template', 'css-ani-ij', 'yes'),
207(41, 'stylesheet', 'css-ani-ij', 'yes'),
208(42, 'comment_whitelist', '1', 'yes'),
209(43, 'blacklist_keys', '', 'no'),
210(44, 'comment_registration', '0', 'yes'),
211(45, 'html_type', 'text/html', 'yes'),
212(46, 'use_trackback', '0', 'yes'),
213(47, 'default_role', 'subscriber', 'yes'),
214(48, 'db_version', '44719', 'yes'),
215(49, 'uploads_use_yearmonth_folders', '1', 'yes'),
216(50, 'upload_path', '', 'yes'),
217(51, 'blog_public', '0', 'yes'),
218(52, 'default_link_category', '2', 'yes'),
219(53, 'show_on_front', 'page', 'yes'),
220(54, 'tag_base', '', 'yes'),
221(55, 'show_avatars', '1', 'yes'),
222(56, 'avatar_rating', 'G', 'yes'),
223(57, 'upload_url_path', '', 'yes'),
224(58, 'thumbnail_size_w', '150', 'yes'),
225(59, 'thumbnail_size_h', '150', 'yes'),
226(60, 'thumbnail_crop', '1', 'yes'),
227(61, 'medium_size_w', '300', 'yes'),
228(62, 'medium_size_h', '300', 'yes'),
229(63, 'avatar_default', 'mystery', 'yes'),
230(64, 'large_size_w', '1024', 'yes'),
231(65, 'large_size_h', '1024', 'yes'),
232(66, 'image_default_link_type', 'none', 'yes'),
233(67, 'image_default_size', '', 'yes'),
234(68, 'image_default_align', '', 'yes'),
235(69, 'close_comments_for_old_posts', '0', 'yes'),
236(70, 'close_comments_days_old', '14', 'yes'),
237(71, 'thread_comments', '1', 'yes'),
238(72, 'thread_comments_depth', '5', 'yes'),
239(73, 'page_comments', '0', 'yes'),
240(74, 'comments_per_page', '50', 'yes'),
241(75, 'default_comments_page', 'newest', 'yes'),
242(76, 'comment_order', 'asc', 'yes'),
243(77, 'sticky_posts', 'a:0:{}', 'yes'),
244(78, 'widget_categories', 'a:2:{i:2;a:4:{s:5:"title";s:0:"";s:5:"count";i:0;s:12:"hierarchical";i:0;s:8:"dropdown";i:0;}s:12:"_multiwidget";i:1;}', 'yes'),
245(79, 'widget_text', 'a:2:{i:1;a:0:{}s:12:"_multiwidget";i:1;}', 'yes'),
246(80, 'widget_rss', 'a:2:{i:1;a:0:{}s:12:"_multiwidget";i:1;}', 'yes'),
247(81, 'uninstall_plugins', 'a:0:{}', 'no'),
248(82, 'timezone_string', '', 'yes'),
249(83, 'page_for_posts', '13', 'yes'),
250(84, 'page_on_front', '7', 'yes'),
251(85, 'default_post_format', '0', 'yes'),
252(86, 'link_manager_enabled', '0', 'yes'),
253(87, 'finished_splitting_shared_terms', '1', 'yes'),
254(88, 'site_icon', '0', 'yes'),
255(89, 'medium_large_size_w', '768', 'yes'),
256(90, 'medium_large_size_h', '0', 'yes'),
257(91, 'wp_page_for_privacy_policy', '3', 'yes'),
258(92, 'show_comments_cookies_opt_in', '1', 'yes'),
259(93, 'initial_db_version', '44719', 'yes'),
260(94, 'wp_user_roles', 'a:5:{s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:61:{s:13:"switch_themes";b:1;s:11:"edit_themes";b:1;s:16:"activate_plugins";b:1;s:12:"edit_plugins";b:1;s:10:"edit_users";b:1;s:10:"edit_files";b:1;s:14:"manage_options";b:1;s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:6:"import";b:1;s:15:"unfiltered_html";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:8:"level_10";b:1;s:7:"level_9";b:1;s:7:"level_8";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;s:12:"delete_users";b:1;s:12:"create_users";b:1;s:17:"unfiltered_upload";b:1;s:14:"edit_dashboard";b:1;s:14:"update_plugins";b:1;s:14:"delete_plugins";b:1;s:15:"install_plugins";b:1;s:13:"update_themes";b:1;s:14:"install_themes";b:1;s:11:"update_core";b:1;s:10:"list_users";b:1;s:12:"remove_users";b:1;s:13:"promote_users";b:1;s:18:"edit_theme_options";b:1;s:13:"delete_themes";b:1;s:6:"export";b:1;}}s:6:"editor";a:2:{s:4:"name";s:6:"Editor";s:12:"capabilities";a:34:{s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:15:"unfiltered_html";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;}}s:6:"author";a:2:{s:4:"name";s:6:"Author";s:12:"capabilities";a:10:{s:12:"upload_files";b:1;s:10:"edit_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:4:"read";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:12:"delete_posts";b:1;s:22:"delete_published_posts";b:1;}}s:11:"contributor";a:2:{s:4:"name";s:11:"Contributor";s:12:"capabilities";a:5:{s:10:"edit_posts";b:1;s:4:"read";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:12:"delete_posts";b:1;}}s:10:"subscriber";a:2:{s:4:"name";s:10:"Subscriber";s:12:"capabilities";a:2:{s:4:"read";b:1;s:7:"level_0";b:1;}}}', 'yes'),
261(95, 'fresh_site', '0', 'yes'),
262(96, 'widget_search', 'a:2:{i:2;a:1:{s:5:"title";s:0:"";}s:12:"_multiwidget";i:1;}', 'yes'),
263(97, 'widget_recent-posts', 'a:2:{i:2;a:2:{s:5:"title";s:0:"";s:6:"number";i:5;}s:12:"_multiwidget";i:1;}', 'yes'),
264(98, 'widget_recent-comments', 'a:2:{i:2;a:2:{s:5:"title";s:0:"";s:6:"number";i:5;}s:12:"_multiwidget";i:1;}', 'yes'),
265(99, 'widget_archives', 'a:2:{i:2;a:3:{s:5:"title";s:0:"";s:5:"count";i:0;s:8:"dropdown";i:0;}s:12:"_multiwidget";i:1;}', 'yes'),
266(100, 'widget_meta', 'a:2:{i:2;a:1:{s:5:"title";s:0:"";}s:12:"_multiwidget";i:1;}', 'yes') ;
267INSERT INTO `wp_options` ( `option_id`, `option_name`, `option_value`, `autoload`) VALUES
268(101, 'sidebars_widgets', 'a:3:{s:19:"wp_inactive_widgets";a:0:{}s:9:"sidebar-1";a:6:{i:0;s:8:"search-2";i:1;s:14:"recent-posts-2";i:2;s:17:"recent-comments-2";i:3;s:10:"archives-2";i:4;s:12:"categories-2";i:5;s:6:"meta-2";}s:13:"array_version";i:3;}', 'yes'),
269(102, 'cron', 'a:6:{i:1561748567;a:1:{s:34:"wp_privacy_delete_old_export_files";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:6:"hourly";s:4:"args";a:0:{}s:8:"interval";i:3600;}}}i:1561780967;a:3:{s:16:"wp_version_check";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:10:"twicedaily";s:4:"args";a:0:{}s:8:"interval";i:43200;}}s:17:"wp_update_plugins";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:10:"twicedaily";s:4:"args";a:0:{}s:8:"interval";i:43200;}}s:16:"wp_update_themes";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:10:"twicedaily";s:4:"args";a:0:{}s:8:"interval";i:43200;}}}i:1561824167;a:1:{s:32:"recovery_mode_clean_expired_keys";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:5:"daily";s:4:"args";a:0:{}s:8:"interval";i:86400;}}}i:1561824176;a:2:{s:19:"wp_scheduled_delete";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:5:"daily";s:4:"args";a:0:{}s:8:"interval";i:86400;}}s:25:"delete_expired_transients";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:5:"daily";s:4:"args";a:0:{}s:8:"interval";i:86400;}}}i:1561824178;a:1:{s:30:"wp_scheduled_auto_draft_delete";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:5:"daily";s:4:"args";a:0:{}s:8:"interval";i:86400;}}}s:7:"version";i:2;}', 'yes'),
270(103, 'widget_pages', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
271(104, 'widget_calendar', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
272(105, 'widget_media_audio', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
273(106, 'widget_media_image', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
274(107, 'widget_media_gallery', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
275(108, 'widget_media_video', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
276(109, 'widget_tag_cloud', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
277(110, 'widget_nav_menu', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
278(111, 'widget_custom_html', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
279(113, 'recovery_keys', 'a:0:{}', 'yes'),
280(117, 'theme_mods_twentynineteen', 'a:2:{s:18:"custom_css_post_id";i:-1;s:16:"sidebars_widgets";a:2:{s:4:"time";i:1561738362;s:4:"data";a:2:{s:19:"wp_inactive_widgets";a:0:{}s:9:"sidebar-1";a:6:{i:0;s:8:"search-2";i:1;s:14:"recent-posts-2";i:2;s:17:"recent-comments-2";i:3;s:10:"archives-2";i:4;s:12:"categories-2";i:5;s:6:"meta-2";}}}}', 'yes'),
281(128, 'can_compress_scripts', '1', 'no'),
282(141, 'theme_mods_css-ani-ij', 'a:2:{s:18:"custom_css_post_id";i:-1;s:18:"nav_menu_locations";a:1:{s:6:"menu-1";i:2;}}', 'yes'),
283(142, 'current_theme', 'CSS ANI [IJ]', 'yes'),
284(143, 'theme_switched', '', 'yes'),
285(144, 'theme_switched_via_customizer', '', 'yes'),
286(145, 'customize_stashed_theme_mods', 'a:0:{}', 'no'),
287(148, 'category_children', 'a:0:{}', 'yes'),
288(156, 'WPLANG', '', 'yes'),
289(157, 'new_admin_email', 'igor.janosevic@it-akademija.com', 'yes'),
290(167, 'nav_menu_options', 'a:2:{i:0;b:0;s:8:"auto_add";a:0:{}}', 'yes'),
291(172, 'recently_activated', 'a:0:{}', 'yes'),
292(183, 'wpmdb_usage', 'a:2:{s:6:"action";s:8:"savefile";s:4:"time";i:1561747181;}', 'no') ;
293
294#
295# End of data contents of table `wp_options`
296# --------------------------------------------------------
297
298
299
300#
301# Delete any existing table `wp_postmeta`
302#
303
304DROP TABLE IF EXISTS `wp_postmeta`;
305
306
307#
308# Table structure of table `wp_postmeta`
309#
310
311CREATE TABLE `wp_postmeta` (
312 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
313 `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
314 `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
315 `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
316 PRIMARY KEY (`meta_id`),
317 KEY `post_id` (`post_id`),
318 KEY `meta_key` (`meta_key`(191))
319) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
320
321
322#
323# Data contents of table `wp_postmeta`
324#
325INSERT INTO `wp_postmeta` ( `meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES
326(1, 2, '_wp_page_template', 'default'),
327(2, 3, '_wp_page_template', 'default'),
328(5, 6, '_wp_trash_meta_status', 'publish'),
329(6, 6, '_wp_trash_meta_time', '1561738362'),
330(7, 7, '_edit_lock', '1561746850:1'),
331(8, 9, '_edit_lock', '1561738268:1'),
332(9, 11, '_edit_lock', '1561738277:1'),
333(10, 13, '_edit_lock', '1561738293:1'),
334(20, 16, '_menu_item_type', 'post_type'),
335(21, 16, '_menu_item_menu_item_parent', '0'),
336(22, 16, '_menu_item_object_id', '9'),
337(23, 16, '_menu_item_object', 'page'),
338(24, 16, '_menu_item_target', ''),
339(25, 16, '_menu_item_classes', 'a:1:{i:0;s:0:"";}'),
340(26, 16, '_menu_item_xfn', ''),
341(27, 16, '_menu_item_url', ''),
342(29, 17, '_menu_item_type', 'post_type'),
343(30, 17, '_menu_item_menu_item_parent', '0'),
344(31, 17, '_menu_item_object_id', '13'),
345(32, 17, '_menu_item_object', 'page'),
346(33, 17, '_menu_item_target', ''),
347(34, 17, '_menu_item_classes', 'a:1:{i:0;s:0:"";}'),
348(35, 17, '_menu_item_xfn', ''),
349(36, 17, '_menu_item_url', ''),
350(38, 18, '_menu_item_type', 'post_type'),
351(39, 18, '_menu_item_menu_item_parent', '0'),
352(40, 18, '_menu_item_object_id', '11'),
353(41, 18, '_menu_item_object', 'page'),
354(42, 18, '_menu_item_target', ''),
355(43, 18, '_menu_item_classes', 'a:1:{i:0;s:0:"";}'),
356(44, 18, '_menu_item_xfn', ''),
357(45, 18, '_menu_item_url', ''),
358(47, 19, '_menu_item_type', 'post_type'),
359(48, 19, '_menu_item_menu_item_parent', '0'),
360(49, 19, '_menu_item_object_id', '7'),
361(50, 19, '_menu_item_object', 'page'),
362(51, 19, '_menu_item_target', ''),
363(52, 19, '_menu_item_classes', 'a:1:{i:0;s:0:"";}'),
364(53, 19, '_menu_item_xfn', ''),
365(54, 19, '_menu_item_url', ''),
366(65, 7, 'main_section_title', 'Nasi omiljeni postovi'),
367(67, 7, '_edit_last', '1'),
368(68, 7, 'main_section_description', 'Ovo je opis, urednik ce bolje znati koji tekst ovde dodje.') ;
369
370#
371# End of data contents of table `wp_postmeta`
372# --------------------------------------------------------
373
374
375
376#
377# Delete any existing table `wp_posts`
378#
379
380DROP TABLE IF EXISTS `wp_posts`;
381
382
383#
384# Table structure of table `wp_posts`
385#
386
387CREATE TABLE `wp_posts` (
388 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
389 `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
390 `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
391 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
392 `post_content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
393 `post_title` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
394 `post_excerpt` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
395 `post_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish',
396 `comment_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
397 `ping_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
398 `post_password` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
399 `post_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
400 `to_ping` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
401 `pinged` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
402 `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
403 `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
404 `post_content_filtered` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
405 `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
406 `guid` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
407 `menu_order` int(11) NOT NULL DEFAULT '0',
408 `post_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post',
409 `post_mime_type` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
410 `comment_count` bigint(20) NOT NULL DEFAULT '0',
411 PRIMARY KEY (`ID`),
412 KEY `post_name` (`post_name`(191)),
413 KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
414 KEY `post_parent` (`post_parent`),
415 KEY `post_author` (`post_author`)
416) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
417
418
419#
420# Data contents of table `wp_posts`
421#
422INSERT INTO `wp_posts` ( `ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES
423(1, 1, '2019-06-28 16:02:46', '2019-06-28 16:02:46', '<!-- wp:paragraph -->\n<p>Welcome to WordPress. This is your first post. Edit or delete it, then start writing!</p>\n<!-- /wp:paragraph -->', 'Hello world!', '', 'publish', 'open', 'open', '', 'hello-world', '', '', '2019-06-28 16:02:46', '2019-06-28 16:02:46', '', 0, 'http://www.wordpress4.com/?p=1', 0, 'post', '', 1),
424(2, 1, '2019-06-28 16:02:46', '2019-06-28 16:02:46', '<!-- wp:paragraph -->\n<p>This is an example page. It\'s different from a blog post because it will stay in one place and will show up in your site navigation (in most themes). Most people start with an About page that introduces them to potential site visitors. It might say something like this:</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:quote -->\n<blockquote class="wp-block-quote"><p>Hi there! I\'m a bike messenger by day, aspiring actor by night, and this is my website. I live in Los Angeles, have a great dog named Jack, and I like piña coladas. (And gettin\' caught in the rain.)</p></blockquote>\n<!-- /wp:quote -->\n\n<!-- wp:paragraph -->\n<p>...or something like this:</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:quote -->\n<blockquote class="wp-block-quote"><p>The XYZ Doohickey Company was founded in 1971, and has been providing quality doohickeys to the public ever since. Located in Gotham City, XYZ employs over 2,000 people and does all kinds of awesome things for the Gotham community.</p></blockquote>\n<!-- /wp:quote -->\n\n<!-- wp:paragraph -->\n<p>As a new WordPress user, you should go to <a href="http://www.wordpress4.com/wp-admin/">your dashboard</a> to delete this page and create new pages for your content. Have fun!</p>\n<!-- /wp:paragraph -->', 'Sample Page', '', 'publish', 'closed', 'open', '', 'sample-page', '', '', '2019-06-28 16:02:46', '2019-06-28 16:02:46', '', 0, 'http://www.wordpress4.com/?page_id=2', 0, 'page', '', 0),
425(3, 1, '2019-06-28 16:02:46', '2019-06-28 16:02:46', '<!-- wp:heading --><h2>Who we are</h2><!-- /wp:heading --><!-- wp:paragraph --><p>Our website address is: http://www.wordpress4.com.</p><!-- /wp:paragraph --><!-- wp:heading --><h2>What personal data we collect and why we collect it</h2><!-- /wp:heading --><!-- wp:heading {"level":3} --><h3>Comments</h3><!-- /wp:heading --><!-- wp:paragraph --><p>When visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection.</p><!-- /wp:paragraph --><!-- wp:paragraph --><p>An anonymized string created from your email address (also called a hash) may be provided to the Gravatar service to see if you are using it. The Gravatar service privacy policy is available here: https://automattic.com/privacy/. After approval of your comment, your profile picture is visible to the public in the context of your comment.</p><!-- /wp:paragraph --><!-- wp:heading {"level":3} --><h3>Media</h3><!-- /wp:heading --><!-- wp:paragraph --><p>If you upload images to the website, you should avoid uploading images with embedded location data (EXIF GPS) included. Visitors to the website can download and extract any location data from images on the website.</p><!-- /wp:paragraph --><!-- wp:heading {"level":3} --><h3>Contact forms</h3><!-- /wp:heading --><!-- wp:heading {"level":3} --><h3>Cookies</h3><!-- /wp:heading --><!-- wp:paragraph --><p>If you leave a comment on our site you may opt-in to saving your name, email address and website in cookies. These are for your convenience so that you do not have to fill in your details again when you leave another comment. These cookies will last for one year.</p><!-- /wp:paragraph --><!-- wp:paragraph --><p>If you visit our login page, we will set a temporary cookie to determine if your browser accepts cookies. This cookie contains no personal data and is discarded when you close your browser.</p><!-- /wp:paragraph --><!-- wp:paragraph --><p>When you log in, we will also set up several cookies to save your login information and your screen display choices. Login cookies last for two days, and screen options cookies last for a year. If you select "Remember Me", your login will persist for two weeks. If you log out of your account, the login cookies will be removed.</p><!-- /wp:paragraph --><!-- wp:paragraph --><p>If you edit or publish an article, an additional cookie will be saved in your browser. This cookie includes no personal data and simply indicates the post ID of the article you just edited. It expires after 1 day.</p><!-- /wp:paragraph --><!-- wp:heading {"level":3} --><h3>Embedded content from other websites</h3><!-- /wp:heading --><!-- wp:paragraph --><p>Articles on this site may include embedded content (e.g. videos, images, articles, etc.). Embedded content from other websites behaves in the exact same way as if the visitor has visited the other website.</p><!-- /wp:paragraph --><!-- wp:paragraph --><p>These websites may collect data about you, use cookies, embed additional third-party tracking, and monitor your interaction with that embedded content, including tracking your interaction with the embedded content if you have an account and are logged in to that website.</p><!-- /wp:paragraph --><!-- wp:heading {"level":3} --><h3>Analytics</h3><!-- /wp:heading --><!-- wp:heading --><h2>Who we share your data with</h2><!-- /wp:heading --><!-- wp:heading --><h2>How long we retain your data</h2><!-- /wp:heading --><!-- wp:paragraph --><p>If you leave a comment, the comment and its metadata are retained indefinitely. This is so we can recognize and approve any follow-up comments automatically instead of holding them in a moderation queue.</p><!-- /wp:paragraph --><!-- wp:paragraph --><p>For users that register on our website (if any), we also store the personal information they provide in their user profile. All users can see, edit, or delete their personal information at any time (except they cannot change their username). Website administrators can also see and edit that information.</p><!-- /wp:paragraph --><!-- wp:heading --><h2>What rights you have over your data</h2><!-- /wp:heading --><!-- wp:paragraph --><p>If you have an account on this site, or have left comments, you can request to receive an exported file of the personal data we hold about you, including any data you have provided to us. You can also request that we erase any personal data we hold about you. This does not include any data we are obliged to keep for administrative, legal, or security purposes.</p><!-- /wp:paragraph --><!-- wp:heading --><h2>Where we send your data</h2><!-- /wp:heading --><!-- wp:paragraph --><p>Visitor comments may be checked through an automated spam detection service.</p><!-- /wp:paragraph --><!-- wp:heading --><h2>Your contact information</h2><!-- /wp:heading --><!-- wp:heading --><h2>Additional information</h2><!-- /wp:heading --><!-- wp:heading {"level":3} --><h3>How we protect your data</h3><!-- /wp:heading --><!-- wp:heading {"level":3} --><h3>What data breach procedures we have in place</h3><!-- /wp:heading --><!-- wp:heading {"level":3} --><h3>What third parties we receive data from</h3><!-- /wp:heading --><!-- wp:heading {"level":3} --><h3>What automated decision making and/or profiling we do with user data</h3><!-- /wp:heading --><!-- wp:heading {"level":3} --><h3>Industry regulatory disclosure requirements</h3><!-- /wp:heading -->', 'Privacy Policy', '', 'draft', 'closed', 'open', '', 'privacy-policy', '', '', '2019-06-28 16:02:46', '2019-06-28 16:02:46', '', 0, 'http://www.wordpress4.com/?page_id=3', 0, 'page', '', 0),
426(4, 1, '2019-06-28 16:02:58', '0000-00-00 00:00:00', '', 'Auto Draft', '', 'auto-draft', 'open', 'open', '', '', '', '', '2019-06-28 16:02:58', '0000-00-00 00:00:00', '', 0, 'http://www.wordpress4.com/?p=4', 0, 'post', '', 0),
427(6, 1, '2019-06-28 16:12:42', '2019-06-28 16:12:42', '{"old_sidebars_widgets_data":{"value":{"wp_inactive_widgets":[],"sidebar-1":["search-2","recent-posts-2","recent-comments-2","archives-2","categories-2","meta-2"]},"type":"global_variable","user_id":1,"date_modified_gmt":"2019-06-28 16:12:42"}}', '', '', 'trash', 'closed', 'closed', '', '600a22f0-708b-42bf-aaf1-59e6acdd1bda', '', '', '2019-06-28 16:12:42', '2019-06-28 16:12:42', '', 0, 'http://www.wordpress4.com/2019/06/28/600a22f0-708b-42bf-aaf1-59e6acdd1bda/', 0, 'customize_changeset', '', 0),
428(7, 1, '2019-06-28 16:13:17', '2019-06-28 16:13:17', '', 'home', '', 'publish', 'closed', 'closed', '', 'home', '', '', '2019-06-28 18:31:53', '2019-06-28 18:31:53', '', 0, 'http://www.wordpress4.com/?page_id=7', 0, 'page', '', 0),
429(8, 1, '2019-06-28 16:13:17', '2019-06-28 16:13:17', '', 'home', '', 'inherit', 'closed', 'closed', '', '7-revision-v1', '', '', '2019-06-28 16:13:17', '2019-06-28 16:13:17', '', 7, 'http://www.wordpress4.com/2019/06/28/7-revision-v1/', 0, 'revision', '', 0),
430(9, 1, '2019-06-28 16:13:29', '2019-06-28 16:13:29', '', 'about us', '', 'publish', 'closed', 'closed', '', 'about-us', '', '', '2019-06-28 16:13:29', '2019-06-28 16:13:29', '', 0, 'http://www.wordpress4.com/?page_id=9', 0, 'page', '', 0),
431(10, 1, '2019-06-28 16:13:29', '2019-06-28 16:13:29', '', 'about us', '', 'inherit', 'closed', 'closed', '', '9-revision-v1', '', '', '2019-06-28 16:13:29', '2019-06-28 16:13:29', '', 9, 'http://www.wordpress4.com/2019/06/28/9-revision-v1/', 0, 'revision', '', 0),
432(11, 1, '2019-06-28 16:13:39', '2019-06-28 16:13:39', '', 'contact', '', 'publish', 'closed', 'closed', '', 'contact', '', '', '2019-06-28 16:13:39', '2019-06-28 16:13:39', '', 0, 'http://www.wordpress4.com/?page_id=11', 0, 'page', '', 0),
433(12, 1, '2019-06-28 16:13:39', '2019-06-28 16:13:39', '', 'contact', '', 'inherit', 'closed', 'closed', '', '11-revision-v1', '', '', '2019-06-28 16:13:39', '2019-06-28 16:13:39', '', 11, 'http://www.wordpress4.com/2019/06/28/11-revision-v1/', 0, 'revision', '', 0),
434(13, 1, '2019-06-28 16:13:49', '2019-06-28 16:13:49', '', 'blog', '', 'publish', 'closed', 'closed', '', 'blog', '', '', '2019-06-28 16:13:49', '2019-06-28 16:13:49', '', 0, 'http://www.wordpress4.com/?page_id=13', 0, 'page', '', 0),
435(14, 1, '2019-06-28 16:13:49', '2019-06-28 16:13:49', '', 'blog', '', 'inherit', 'closed', 'closed', '', '13-revision-v1', '', '', '2019-06-28 16:13:49', '2019-06-28 16:13:49', '', 13, 'http://www.wordpress4.com/2019/06/28/13-revision-v1/', 0, 'revision', '', 0),
436(16, 1, '2019-06-28 17:34:27', '2019-06-28 17:34:27', ' ', '', '', 'publish', 'closed', 'closed', '', '16', '', '', '2019-06-28 17:36:19', '2019-06-28 17:36:19', '', 0, 'http://www.wordpress4.com/?p=16', 2, 'nav_menu_item', '', 0),
437(17, 1, '2019-06-28 17:34:27', '2019-06-28 17:34:27', ' ', '', '', 'publish', 'closed', 'closed', '', '17', '', '', '2019-06-28 17:36:19', '2019-06-28 17:36:19', '', 0, 'http://www.wordpress4.com/?p=17', 3, 'nav_menu_item', '', 0),
438(18, 1, '2019-06-28 17:34:28', '2019-06-28 17:34:28', ' ', '', '', 'publish', 'closed', 'closed', '', '18', '', '', '2019-06-28 17:36:19', '2019-06-28 17:36:19', '', 0, 'http://www.wordpress4.com/?p=18', 4, 'nav_menu_item', '', 0),
439(19, 1, '2019-06-28 17:34:28', '2019-06-28 17:34:28', ' ', '', '', 'publish', 'closed', 'closed', '', '19', '', '', '2019-06-28 17:36:19', '2019-06-28 17:36:19', '', 0, 'http://www.wordpress4.com/?p=19', 1, 'nav_menu_item', '', 0) ;
440
441#
442# End of data contents of table `wp_posts`
443# --------------------------------------------------------
444
445
446
447#
448# Delete any existing table `wp_term_relationships`
449#
450
451DROP TABLE IF EXISTS `wp_term_relationships`;
452
453
454#
455# Table structure of table `wp_term_relationships`
456#
457
458CREATE TABLE `wp_term_relationships` (
459 `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
460 `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
461 `term_order` int(11) NOT NULL DEFAULT '0',
462 PRIMARY KEY (`object_id`,`term_taxonomy_id`),
463 KEY `term_taxonomy_id` (`term_taxonomy_id`)
464) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
465
466
467#
468# Data contents of table `wp_term_relationships`
469#
470INSERT INTO `wp_term_relationships` ( `object_id`, `term_taxonomy_id`, `term_order`) VALUES
471(1, 1, 0),
472(16, 2, 0),
473(17, 2, 0),
474(18, 2, 0),
475(19, 2, 0) ;
476
477#
478# End of data contents of table `wp_term_relationships`
479# --------------------------------------------------------
480
481
482
483#
484# Delete any existing table `wp_term_taxonomy`
485#
486
487DROP TABLE IF EXISTS `wp_term_taxonomy`;
488
489
490#
491# Table structure of table `wp_term_taxonomy`
492#
493
494CREATE TABLE `wp_term_taxonomy` (
495 `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
496 `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
497 `taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
498 `description` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
499 `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
500 `count` bigint(20) NOT NULL DEFAULT '0',
501 PRIMARY KEY (`term_taxonomy_id`),
502 UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
503 KEY `taxonomy` (`taxonomy`)
504) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
505
506
507#
508# Data contents of table `wp_term_taxonomy`
509#
510INSERT INTO `wp_term_taxonomy` ( `term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES
511(1, 1, 'category', '', 0, 1),
512(2, 2, 'nav_menu', '', 0, 4) ;
513
514#
515# End of data contents of table `wp_term_taxonomy`
516# --------------------------------------------------------
517
518
519
520#
521# Delete any existing table `wp_termmeta`
522#
523
524DROP TABLE IF EXISTS `wp_termmeta`;
525
526
527#
528# Table structure of table `wp_termmeta`
529#
530
531CREATE TABLE `wp_termmeta` (
532 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
533 `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
534 `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
535 `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
536 PRIMARY KEY (`meta_id`),
537 KEY `term_id` (`term_id`),
538 KEY `meta_key` (`meta_key`(191))
539) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
540
541
542#
543# Data contents of table `wp_termmeta`
544#
545
546#
547# End of data contents of table `wp_termmeta`
548# --------------------------------------------------------
549
550
551
552#
553# Delete any existing table `wp_terms`
554#
555
556DROP TABLE IF EXISTS `wp_terms`;
557
558
559#
560# Table structure of table `wp_terms`
561#
562
563CREATE TABLE `wp_terms` (
564 `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
565 `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
566 `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
567 `term_group` bigint(10) NOT NULL DEFAULT '0',
568 PRIMARY KEY (`term_id`),
569 KEY `slug` (`slug`(191)),
570 KEY `name` (`name`(191))
571) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
572
573
574#
575# Data contents of table `wp_terms`
576#
577INSERT INTO `wp_terms` ( `term_id`, `name`, `slug`, `term_group`) VALUES
578(1, 'Uncategorized', 'uncategorized', 0),
579(2, 'Glavni', 'glavni', 0) ;
580
581#
582# End of data contents of table `wp_terms`
583# --------------------------------------------------------
584
585
586
587#
588# Delete any existing table `wp_usermeta`
589#
590
591DROP TABLE IF EXISTS `wp_usermeta`;
592
593
594#
595# Table structure of table `wp_usermeta`
596#
597
598CREATE TABLE `wp_usermeta` (
599 `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
600 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
601 `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
602 `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
603 PRIMARY KEY (`umeta_id`),
604 KEY `user_id` (`user_id`),
605 KEY `meta_key` (`meta_key`(191))
606) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
607
608
609#
610# Data contents of table `wp_usermeta`
611#
612INSERT INTO `wp_usermeta` ( `umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
613(1, 1, 'nickname', 'ubuntu'),
614(2, 1, 'first_name', ''),
615(3, 1, 'last_name', ''),
616(4, 1, 'description', ''),
617(5, 1, 'rich_editing', 'true'),
618(6, 1, 'syntax_highlighting', 'true'),
619(7, 1, 'comment_shortcuts', 'false'),
620(8, 1, 'admin_color', 'fresh'),
621(9, 1, 'use_ssl', '0'),
622(10, 1, 'show_admin_bar_front', 'true'),
623(11, 1, 'locale', ''),
624(12, 1, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
625(13, 1, 'wp_user_level', '10'),
626(14, 1, 'dismissed_wp_pointers', ''),
627(15, 1, 'show_welcome_panel', '0'),
628(16, 1, 'session_tokens', 'a:1:{s:64:"0a4abf0682830faf64e71827c27d5438b62bdcbac491b3f27a382468cfebb776";a:4:{s:10:"expiration";i:1561910576;s:2:"ip";s:3:"::1";s:2:"ua";s:115:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36";s:5:"login";i:1561737776;}}'),
629(17, 1, 'wp_dashboard_quick_press_last_post_id', '4'),
630(18, 1, 'managenav-menuscolumnshidden', 'a:5:{i:0;s:11:"link-target";i:1;s:11:"css-classes";i:2;s:3:"xfn";i:3;s:11:"description";i:4;s:15:"title-attribute";}'),
631(19, 1, 'metaboxhidden_nav-menus', 'a:1:{i:0;s:12:"add-post_tag";}'),
632(20, 1, 'nav_menu_recently_edited', '2'),
633(21, 1, 'enable_custom_fields', '1') ;
634
635#
636# End of data contents of table `wp_usermeta`
637# --------------------------------------------------------
638
639
640
641#
642# Delete any existing table `wp_users`
643#
644
645DROP TABLE IF EXISTS `wp_users`;
646
647
648#
649# Table structure of table `wp_users`
650#
651
652CREATE TABLE `wp_users` (
653 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
654 `user_login` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
655 `user_pass` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
656 `user_nicename` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
657 `user_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
658 `user_url` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
659 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
660 `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
661 `user_status` int(11) NOT NULL DEFAULT '0',
662 `display_name` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
663 PRIMARY KEY (`ID`),
664 KEY `user_login_key` (`user_login`),
665 KEY `user_nicename` (`user_nicename`),
666 KEY `user_email` (`user_email`)
667) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
668
669
670#
671# Data contents of table `wp_users`
672#
673INSERT INTO `wp_users` ( `ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
674(1, 'ubuntu', '$P$B9GoMlpqvFKT2.snbrENYxRMYhXceV.', 'ubuntu', 'igor.janosevic@it-akademija.com', '', '2019-06-28 16:02:46', '', 0, 'ubuntu') ;
675
676#
677# End of data contents of table `wp_users`
678# --------------------------------------------------------
679
680#
681# Add constraints back in and apply any alter data queries.
682#