<?php
	if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly

	divdemo_terms();
	function divdemo_terms() {
		global $wpdb, $wp_rewrite;
		if (!get_option("blogname", false)) {
			return;
		}
	ob_start();
?>SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

DROP TABLE IF EXISTS `@@TABLE_PREFIX@@comments`;
CREATE TABLE IF NOT EXISTS `@@TABLE_PREFIX@@comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `comment_author` tinytext NOT NULL,
  `comment_author_email` varchar(100) NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) NOT NULL DEFAULT '',
  `comment_type` varchar(20) NOT NULL DEFAULT '',
  `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

INSERT INTO `@@TABLE_PREFIX@@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
(2, 32, 'Shindiri Studio', 'support@shindiristudio.com', '', '178.149.94.8', '2014-02-28 13:49:35', '2014-02-28 13:49:35', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Lorem ipsum dolor sit amet, consectetur adipisicin', 0, '1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36', '', 0, 1),
(3, 32, 'Shindiri Studio', 'support@shindiristudio.com', '', '178.149.94.8', '2014-02-28 14:31:19', '2014-02-28 14:31:19', 'Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 0, '1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36', '', 2, 1),
(4, 32, 'Shindiri Studio', 'support@shindiristudio.com', '', '178.149.94.8', '2014-02-28 14:32:23', '2014-02-28 14:32:23', 'Share a little biographical information to fill out your profile. This may be shown publicly. If you would like to change the password type a new one. Otherwise leave this blank.', 0, '1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36', '', 0, 1),
(5, 384, 'Shindiri Studio', 'support@shindiristudio.com', '', '178.149.94.8', '2014-03-13 16:04:36', '2014-03-13 16:04:36', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do ei', 0, '1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:27.0) Gecko/20100101 Firefox/27.0', '', 0, 1);

DROP TABLE IF EXISTS `@@TABLE_PREFIX@@term_taxonomy`;
CREATE TABLE IF NOT EXISTS `@@TABLE_PREFIX@@term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

INSERT INTO `@@TABLE_PREFIX@@term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES
(1, 1, 'category', '', 0, 0),
(3, 3, 'category', '', 0, 0),
(4, 4, 'category', 'The description is not prominent by default; however, some themes may show it.', 3, 6),
(5, 5, 'post_tag', '', 0, 1),
(6, 6, 'post_tag', '', 0, 1),
(7, 7, 'post_format', '', 0, 1),
(8, 8, 'category', '', 15, 1),
(9, 9, 'post_format', '', 0, 1),
(10, 10, 'post_tag', '', 0, 1),
(11, 11, 'post_tag', '', 0, 1),
(12, 12, 'post_format', '', 0, 2),
(13, 13, 'category', '', 15, 0),
(14, 14, 'post_format', '', 0, 2),
(15, 15, 'category', '', 0, 5),
(16, 16, 'category', '', 15, 0),
(17, 17, 'category', '', 15, 0),
(18, 18, 'nav_menu', '', 0, 11),
(19, 19, 'category', '', 0, 6),
(20, 20, 'category', '', 0, 6),
(21, 21, 'category', '', 0, 6);

DROP TABLE IF EXISTS `@@TABLE_PREFIX@@term_relationships`;
CREATE TABLE IF NOT EXISTS `@@TABLE_PREFIX@@term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `@@TABLE_PREFIX@@term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`) VALUES
(32, 5, 0),
(32, 6, 0),
(32, 7, 0),
(32, 19, 0),
(32, 21, 0),
(70, 8, 0),
(70, 9, 0),
(70, 10, 0),
(70, 11, 0),
(72, 12, 0),
(72, 19, 0),
(72, 20, 0),
(74, 14, 0),
(74, 19, 0),
(74, 21, 0),
(83, 19, 0),
(83, 20, 0),
(100, 18, 0),
(101, 18, 0),
(102, 18, 0),
(103, 18, 0),
(104, 18, 0),
(182, 19, 0),
(182, 21, 0),
(268, 18, 0),
(269, 18, 0),
(384, 12, 0),
(384, 15, 0),
(389, 14, 0),
(389, 15, 0),
(399, 15, 0),
(401, 15, 0),
(403, 15, 0),
(420, 19, 0),
(420, 20, 0),
(446, 18, 0),
(454, 4, 0),
(454, 21, 0),
(462, 4, 0),
(462, 21, 0),
(476, 4, 0),
(476, 21, 0),
(480, 4, 0),
(480, 20, 0),
(485, 4, 0),
(485, 20, 0),
(489, 4, 0),
(489, 20, 0),
(497, 18, 0),
(541, 18, 0),
(542, 18, 0);

DROP TABLE IF EXISTS `@@TABLE_PREFIX@@terms`;
CREATE TABLE IF NOT EXISTS `@@TABLE_PREFIX@@terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(200) NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

INSERT INTO `@@TABLE_PREFIX@@terms` (`term_id`, `name`, `slug`, `term_group`) VALUES
(1, 'Uncategorized', 'uncategorized', 0),
(3, 'Portfolio', 'portfolio', 0),
(4, 'Logos', 'logos', 0),
(5, 'vector', 'vector', 0),
(6, 'yellow', 'yellow', 0),
(7, 'post-format-image', 'post-format-image', 0),
(8, 'Quotes', 'quotes', 0),
(9, 'post-format-quote', 'post-format-quote', 0),
(10, 'quotes', 'quotes-2', 0),
(11, 'thoughts', 'thoughts', 0),
(12, 'post-format-video', 'post-format-video', 0),
(13, 'Galleries', 'galleries', 0),
(14, 'post-format-gallery', 'post-format-gallery', 0),
(15, 'Blog', 'blog', 0),
(16, 'Videos', 'videos', 0),
(17, 'Notices', 'notices', 0),
(18, 'Menu 1', 'menu-1', 0),
(19, 'Photography', 'photography', 0),
(20, 'Illustrations', 'illustrations', 0),
(21, 'Design', 'design', 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
<?php
	$sql   =  ob_get_clean();

	$sql   = str_replace(array("@@TABLE_PREFIX@@", "@@SITE_URL@@"),array($wpdb->prefix, get_option("siteurl")),$sql);
	$lines = explode("\n", $sql);
	$query = "";

	foreach ($lines as $line) {
		$line = trim($line);
		if (strlen($line)==0) continue;
		if (substr($line,-1)==";") {
			$query.=" ".$line;
			$wpdb->query($query);
			$query = "";
		} else {
			$query.=" ".$line;
		}
	}

	$wp_rewrite->flush_rules();
	wp_cache_flush();

}