<?php

$SQL[] = "

CREATE TABLE IF NOT EXISTS `about` (
  `id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `about` (`id`, `description`) VALUES
(1, '<p>Energistically mesh professional products via standardized platforms. Distinctively target B2C technologies via client-centric methodologies. Completely implement functional customer service through leveraged users. Objectively matrix efficient technology through next-generation sources. Quickly mesh interactive materials after synergistic human capital.</p><p><br></p><p>Dramatically aggregate performance based information before world-class expertise. Monotonectally engage efficient infrastructures without empowered action.</p><p></p>');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `about_img` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `active` (
  `id` int(11) NOT NULL,
  `about` int(11) NOT NULL,
  `contacts` int(11) NOT NULL,
  `services` int(11) NOT NULL,
  `testimonials` int(11) NOT NULL,
  `partners` int(11) NOT NULL,
  `map` int(11) NOT NULL,
  `progress` int(11) NOT NULL,
  `countdown` int(11) NOT NULL,
  `form` int(11) NOT NULL,
  `subscribe` int(11) NOT NULL,
  `portfolio` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `active` (`id`, `about`, `contacts`, `services`, `testimonials`, `partners`, `map`, `progress`, `countdown`, `form`, `subscribe`, `portfolio`) VALUES
(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `background` (
  `id` int(11) NOT NULL,
  `type` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `background` (`id`, `type`) VALUES
(1, 'slide');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `slug` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

";

$SQL[] = "

INSERT INTO `categories` (`id`, `name`, `slug`) VALUES
(11, 'Photography', 'Photography'),
(9, 'Webdesign', 'Webdesign'),
(10, 'Branding', 'Branding');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `email` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `comingsoon` (
  `id` int(11) NOT NULL,
  `progress` int(11) NOT NULL,
  `countdown` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `comingsoon` (`id`, `progress`, `countdown`) VALUES
(1, 0, 1);

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `contactform_img` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `contacts` (
  `id` int(11) NOT NULL,
  `address` text NOT NULL,
  `code` text NOT NULL,
  `city` text NOT NULL,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  `title` text NOT NULL,
  `email` text NOT NULL,
  `phone` int(11) NOT NULL,
  `footer` text NOT NULL,
  `facebook` text NOT NULL,
  `twitter` text NOT NULL,
  `linkedin` text NOT NULL,
  `google` text NOT NULL,
  `youtube` text NOT NULL,
  `instagram` text NOT NULL,
  `pinterest` text NOT NULL,
  `tumblr` text NOT NULL,
  `vine` text NOT NULL,
  `snapchat` text NOT NULL,
  `reddit` text NOT NULL,
  `flickr` text NOT NULL,
  `soundcloud` text NOT NULL,
  `whatsapp` text NOT NULL,
  `slack` text NOT NULL,
  `xing` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `contacts` (`id`, `address`, `code`, `city`, `latitude`, `longitude`, `title`, `email`, `phone`, `footer`, `facebook`, `twitter`, `linkedin`, `google`, `youtube`, `instagram`, `pinterest`, `tumblr`, `vine`, `snapchat`, `reddit`, `flickr`, `soundcloud`, `whatsapp`, `slack`, `xing`) VALUES
(1, '5th Avenue', '23456-3453', 'Seattle', '47.6060643', '-122.3398535', 'FLY | Multipurpose One Page + CMS', 'geral@fly.com', 245324567, 'Copyright Â© EZCode 2017', 'https://www.facebook.com/joseoliveira82', '#', '#', '', '', '', '', '', '', '', '', '', '', '', '', '');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `contacts_img` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `contact_form` (
  `id` int(11) NOT NULL,
  `sendyouremail` text NOT NULL,
  `mailfrom` text NOT NULL,
  `sendto` text NOT NULL,
  `subject` text NOT NULL,
  `okmessage` text NOT NULL,
  `errormessage` text NOT NULL,
  `emailtext` text NOT NULL,
  `firstname` text NOT NULL,
  `lastname` text NOT NULL,
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `message` text NOT NULL,
  `button` text NOT NULL,
  `fn_holder` text NOT NULL,
  `ln_holder` text NOT NULL,
  `em_holder` text NOT NULL,
  `ph_holder` text NOT NULL,
  `mg_holder` text NOT NULL,
  `fn_error` text NOT NULL,
  `ln_error` text NOT NULL,
  `em_error` text NOT NULL,
  `mg_error` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `contact_form` (`id`, `sendyouremail`, `mailfrom`, `sendto`, `subject`, `okmessage`, `errormessage`, `emailtext`, `firstname`, `lastname`, `email`, `phone`, `message`, `button`, `fn_holder`, `ln_holder`, `em_holder`, `ph_holder`, `mg_holder`, `fn_error`, `ln_error`, `em_error`, `mg_error`) VALUES
(1, 'geral@fly.com', 'Demo contact form1', 'Demo contact form', 'New message from contact form', 'Contact form successfully submitted. Thank you, I will get back to you soon!', 'There was an error while submitting the form. Please try again later', 'You have new message from contact form', 'Your First Name', 'Last Name', 'Email', 'Phone', 'Message', 'Send me a Message', 'Please enter your firstname please *', 'Please enter your lastname *', 'Please enter your email *', 'Please enter your phone *', 'Message for me *', 'Firstname is required.', 'Lastname is required.', 'Valid email is required.', 'Please,leave us a message.');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `contact_type` (
  `id` int(11) NOT NULL,
  `type` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `contact_type` (`id`, `type`) VALUES
(1, 'material');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `countdown` (
  `id` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `day` int(11) NOT NULL,
  `bcolor` text NOT NULL,
  `bradius` text NOT NULL,
  `border` text NOT NULL,
  `dcolor` text NOT NULL,
  `dsize` text NOT NULL,
  `wcolor` text NOT NULL,
  `wsize` text NOT NULL,
  `active` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `countdown` (`id`, `year`, `month`, `day`, `bcolor`, `bradius`, `border`, `dcolor`, `dsize`, `wcolor`, `wsize`, `active`) VALUES
(1, 2018, 1, 12, '#2b9db7', '50', '5', '#ffffff', '5', '#ffffff', '20', 0);

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `css` (
  `id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `css` (`id`, `description`) VALUES
(1, 'h2{font-size:50px;}\r\n\r\n/* Tablet Landscape */\r\n@media only screen and (min-width: 958px) and (max-width: 1079px) {\r\n}\r\n\r\n/* Tablet Portrait size to standard 960 (devices and browsers) */\r\n@media only screen and (min-width: 768px) and (max-width: 959px) {\r\n}\r\n\r\n/* Mobile Landscape Size to Tablet Portrait (devices and browsers) */\r\n@media only screen and (min-width: 480px) and (max-width: 767px) {\r\n}\r\n\r\n/* Vertical Iphone */\r\n@media only screen and (max-width: 479px) {\r\n}\r\n');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `dashboard` (
  `id` int(11) NOT NULL,
  `font` text NOT NULL,
  `lcolor` text NOT NULL,
  `menu_color` text NOT NULL,
  `menu_bcolor` text NOT NULL,
  `menu_colorhover` text NOT NULL,
  `menu_bcolorhover` text NOT NULL,
  `background_color` text NOT NULL,
  `background_tcolor` text NOT NULL,
  `background_menu_color` text NOT NULL,
  `items_color` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `dashboard` (`id`, `font`, `lcolor`, `menu_color`, `menu_bcolor`, `menu_colorhover`, `menu_bcolorhover`, `background_color`, `background_tcolor`, `background_menu_color`, `items_color`) VALUES
(1, 'Quicksand', '#008ef5', '#ffffff', '#0274c7', '#dbdbdb', '#0274c7', '#008ef5', '#ffffff', '#333333', '#ffffff');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `hits` (
  `page` varchar(255) NOT NULL DEFAULT '',
  `count` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `hits` (`page`, `count`) VALUES
('FLY CMS', 0);

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `time_accessed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `logo` (
  `id` int(11) NOT NULL,
  `logo_text` text NOT NULL,
  `image` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `logo` (`id`, `logo_text`, `image`) VALUES
(0, 'logo', 'c261e744845f945e17c77ef4d92f621d.png');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `map` (
  `id` int(11) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `zoom` text NOT NULL,
  `api` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `map` (`id`, `latitude`, `longitude`, `title`, `description`, `zoom`, `api`) VALUES
(1, 47.6060643, -122.3398535, 'FLY | Multipurpose One Page + CMS', 'FLY | Multipurpose One Page + CMS', '14', 'AIzaSyAvOhtbl4wK5vOq3YZuc-gkldJTxI13eY4');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `particles` (
  `id` int(11) NOT NULL,
  `bpcolor` text NOT NULL,
  `dpcolor` text NOT NULL,
  `ppcolor` text NOT NULL,
  `type` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `particles` (`id`, `bpcolor`, `dpcolor`, `ppcolor`, `type`) VALUES
(1, '#389eb4', '#0274c7', '#ffffff', 'particles');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `partners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` text NOT NULL,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

";

$SQL[] = "

INSERT INTO `partners` (`id`, `image`, `name`, `website`) VALUES
(1, 'c2d8439ff998ac5fc0da9f94bdd029ea.jpg', 'Baliresort', 'https://themeforest.net/user/ezcode'),
(2, '046e87f2f0762c64a9510ceab16bb2ab.jpg', 'New York City Style', 'https://themeforest.net/user/ezcode'),
(3, '4f97171f0263b24c7fa5271a20c6c34d.jpg', 'Real Estate', 'https://themeforest.net/user/ezcode'),
(4, '83b9e0daee52ec4505953f718a1e994b.jpg', 'Brend Strong', 'https://themeforest.net/user/ezcode'),
(5, '221af6a11af00297a1409bca0dbaeed7.jpg', 'Goldengrid', 'https://themeforest.net/user/ezcode');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `partners_img` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `partners_img` (`id`, `image`) VALUES
(0, '3800817d0d43a1f6b4cc968b5392363d.jpg');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `portfolio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` text NOT NULL,
  `category` text NOT NULL,
  `title` text NOT NULL,
  `link` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

";

$SQL[] = "

INSERT INTO `portfolio` (`id`, `image`, `category`, `title`, `link`, `description`) VALUES
(7, '793d8c9996075ca97540d635be67d671.jpg', 'Photography', 'Photography', 'https://codecanyon.net/user/ezcode', 'Custom Branding'),
(8, '74dad46ff295bbf99df5d3e08ce95e2f.jpg', 'Photography', 'Landscape', 'https://codecanyon.net/user/ezcode', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(9, 'dd7b1e2c447147ba14e99f03e0ade9e9.jpg', 'Webdesign', 'Creative', 'https://codecanyon.net/user/ezcode', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(10, 'b6764d16f13e488fbeaf3addcc250e9e.jpg', 'Webdesign', 'Organization', '', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(11, '4553ca435f1468c52f45be2844676f78.jpg', 'Photography', 'Clear Sky', '', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(12, '085faf6eb70f6da0f457bbdf1ff958ee.jpg', 'Branding', 'Organization', '', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(13, '537a9a208bddc706f89c342f841639da.jpg', 'Branding', 'Clear Mind', '', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(14, '5b18c7e5094b81a4ea1d77802d9293a3.jpg', 'Photography', 'Trending Trees', '', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(15, 'c07fcb3cffe5f5cfecd0453b6c55564e.jpg', 'Webdesign', 'Technology', '', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(16, '29d8c07361a1d110cce241d065dc16b3.jpg', 'Webdesign', 'Coding', '', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(17, 'cb5520a034868882c3af6336f57169e9.jpg', 'Branding', 'Material', '', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.'),
(18, '86b4ec3f11ba36a4a7619756e80f4f34.jpg', 'Branding', 'Mind Clearification', 'https://codecanyon.net/user/ezcode', 'Efficiently fabricate open-source technologies rather than flexible customer service. Competently.');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `portfolio_img` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `progress` (
  `id` int(11) NOT NULL,
  `percent` text NOT NULL,
  `color` text NOT NULL,
  `height` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `progress` (`id`, `percent`, `color`, `height`) VALUES
(1, '80', 'rgba(0,139,217,1)', 50);

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `seo` (
  `id` int(11) NOT NULL,
  `keywords` text NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `seo` (`id`, `keywords`, `title`, `description`) VALUES
(1, 'coming soon, website builder, options panel, featured content, countdown timer, progress bar, bootstrap', 'FLY | Multipurpose One Page + CMS', 'The easiest way to create your Personal or Business One Page Website.');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `logo` text NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

";

$SQL[] = "

INSERT INTO `service` (`id`, `logo`, `title`, `description`) VALUES
(1, 'fa-check', 'Design', 'Appropriately architect client-focused strategic theme areas and.'),
(2, 'fa-cogs', 'Development', 'Appropriately architect client-focused strategic theme areas and.'),
(3, 'fa-thumbs-o-up', 'Creative', 'Appropriately architect client-focused strategic theme areas and.'),
(4, 'fa-heart-o', 'Support', 'Appropriately architect client-focused strategic theme areas and.');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `services` (
  `id` int(11) NOT NULL,
  `number` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `services` (`id`, `number`) VALUES
(1, 4);

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `services_img` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `services_img` (`id`, `image`) VALUES
(0, '881d86ba970ea3e59a62eecd90dd20b9.jpg');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `slide` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` text NOT NULL,
  `type` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

";

$SQL[] = "

INSERT INTO `slide` (`id`, `image`, `type`) VALUES
(6, '2e6f5d2c0ec72e72f9cef89717dcb206.jpg', 'slide'),
(7, '93216026f289b291fe5a1ad7e4a6b6df.jpg', 'slide');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `static` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  `type` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `static` (`id`, `image`, `type`) VALUES
(0, '517496f5eaad7f185b9ca1b4f809fe9e.jpg', 'static');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` text NOT NULL,
  `description` text NOT NULL,
  `name` text NOT NULL,
  `website` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

";

$SQL[] = "

INSERT INTO `testimonials` (`id`, `image`, `description`, `name`, `website`) VALUES
(1, '1e2905dd227f3376a5511334706f7c82.jpg', 'Uniquely maximize superior niches whereas client-based meta-services. Synergistically synthesize fully researched quality vectors vis-a-vis ethical data. Collaboratively disintermediate tactical.', 'John Doe', 'https://themeforest.net/user/ezcode'),
(2, '54a893adf973eee208a3578fee8be7c2.jpg', 'Uniquely maximize superior niches whereas client-based meta-services. Synergistically synthesize fully researched quality vectors vis-a-vis ethical data. Collaboratively disintermediate tactical.', 'Maria Doe', 'https://themeforest.net/user/ezcode'),
(3, 'ed92804a12f41fae081032167d9ff502.jpg', 'Uniquely maximize superior niches whereas client-based meta-services. Synergistically synthesize fully researched quality vectors vis-a-vis ethical data. Collaboratively disintermediate tactical.', 'JosÃ© Oliveira', 'https://themeforest.net/user/ezcode'),
(4, 'af70e85ac56bdb1791bb6df9b30c6ff3.jpg', 'Uniquely maximize superior niches whereas client-based meta-services. Synergistically synthesize fully researched quality vectors vis-a-vis ethical data. Collaboratively disintermediate tactical.', 'Telma Soares', 'https://themeforest.net/user/ezcode');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `testimonials_img` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `text` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `text` (`id`, `title`, `description`) VALUES
(1, 'FLY | Multipurpose One Page + CMS', 'The easiest way to create your Personal or Business One Page Website.');

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` char(64) COLLATE utf8_unicode_ci NOT NULL,
  `salt` char(16) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `video` (
  `v_id` int(11) NOT NULL,
  `video_name` varchar(255) NOT NULL,
  `type` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

CREATE TABLE IF NOT EXISTS `youtube` (
  `id` int(11) NOT NULL,
  `video_id` text NOT NULL,
  `type` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `youtube` (`id`, `video_id`, `type`) VALUES
(1, 'V8sqRCuvvzE', 'youtube');

";

$SQL[] = "

CREATE TABLE `portfolio_type` (
  `id` int(11) NOT NULL,
  `type` text NOT NULL
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `portfolio_type` (`id`, `type`) VALUES
(1, 'portfolio');

";

$SQL[] = "

CREATE TABLE `menu_type` (
  `id` int(11) NOT NULL,
  `type` text NOT NULL
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

";

$SQL[] = "

INSERT INTO `menu_type` (`id`, `type`) VALUES
(1, 'right');

";






?>