CREATE TABLE IF NOT EXISTS `pideb_config` (
				 `admin` VARCHAR(20) NOT NULL DEFAULT '',
				 `password` VARCHAR(90) NOT NULL DEFAULT '',
				 `email` VARCHAR(90) NOT NULL DEFAULT '',
				 `commentemail` VARCHAR(3) NOT NULL DEFAULT '',
				 `template` VARCHAR(150) NOT NULL DEFAULT '',
				 `imagepath` VARCHAR(150) NOT NULL DEFAULT '',
				 `siteurl` VARCHAR(100) NOT NULL DEFAULT '',
				 `sitetitle` VARCHAR(100) NOT NULL DEFAULT '',
				 `langfile` VARCHAR(100) NOT NULL DEFAULT '',
				 `calendar` VARCHAR(30) NOT NULL DEFAULT '',
				 `crop` VARCHAR(3) NOT NULL DEFAULT '',
				 `thumbwidth` INT(11) NOT NULL,
				 `thumbheight` INT(11) NOT NULL,
				 `thumbnumber` INT(11) NOT NULL,
				 `compression` INT(11) NOT NULL,
				 `dateformat` VARCHAR(30) NOT NULL DEFAULT '');

CREATE TABLE IF NOT EXISTS `pideb_categories` (
				 `id` INT(11) NOT NULL auto_increment,
				 `name` VARCHAR(100) NOT NULL DEFAULT '',
				 KEY id (`id`));
INSERT INTO `pideb_categories` VALUES (0, 'default');

CREATE TABLE IF NOT EXISTS `pideb_pixelpost` (
				 `id` INT(11) NOT NULL auto_increment,
				 `datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
				 `headline` VARCHAR(150) NOT NULL DEFAULT '',
				 `body` TEXT NOT NULL,
				 `image` TEXT NOT NULL,
				 `category` VARCHAR(150) NOT NULL DEFAULT '',
				 KEY id (`id`));

CREATE TABLE IF NOT EXISTS pideb_comments (
				 `id` INT(11) NOT NULL auto_increment,
				 `parent_id` INT(11) NOT NULL DEFAULT '0',
				 `datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
				 `ip` VARCHAR(20) NOT NULL DEFAULT '',
				 `message` TEXT NOT NULL,
				 `name` VARCHAR(20) NOT NULL DEFAULT '',
				 `url` VARCHAR(40) NOT NULL DEFAULT '',
				 KEY id (`id`));

CREATE TABLE IF NOT EXISTS pideb_visitors (
				 `id` INT(11) NOT NULL auto_increment,
				 `datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
				 `host` VARCHAR(100) NOT NULL DEFAULT '',
				 `referer` VARCHAR(255) NOT NULL DEFAULT '',
				 `ua` VARCHAR(255) NOT NULL DEFAULT '',
				 `ip` VARCHAR(255) NOT NULL DEFAULT '',
				 `ruri` VARCHAR(150) NOT NULL DEFAULT '',
				 PRIMARY KEY (`id`));
-- INSERT INTO `pideb_config`
	
--  	(`admin` , `password`       ,  `email`  , `commentemail`  , `template`  ,  `imagepath`     ,   `siteurl`   ,  `sitetitle`  ,  `langfile`  ,   `calendar`    ,  `crop`  ,  `thumbwidth`  ,  `thumbheight`  ,  `thumbnumber`  ,  `compression`  ,    `dateformat`   )VALUES
--  	('admin', MD5('ChangeMe') ,    ''     ,      'no'       , 'simple'    , '../images/'   ,  'http://www.yourdomain.tld/pixelpost/'  ,  'Pixelpost on Debian'  ,   'english'  ,  'No Calendar'  ,  'yes'   ,     '100'      ,      '75'       ,       '5'       ,      '75'       ,    'Y-m-d H:i:s'  );

CREATE TABLE IF NOT EXISTS `pideb_version` (
				 `id` INT(10) unsigned NOT NULL auto_increment,
				 `upgrade_date` TIMESTAMP(14) NOT NULL,
				 `version` FLOAT NOT NULL DEFAULT '0',
				 PRIMARY KEY  (`id`),
				 KEY `version` (`version`));
INSERT INTO `pideb_version` (`version`) VALUES ('1.4');

CREATE TABLE IF NOT EXISTS `pideb_catassoc` (
				 `id` INT(11) NOT NULL auto_increment,
				 `cat_id` INT(11) NOT NULL DEFAULT '0',
				 `image_id` INT(11) NOT NULL DEFAULT '0',
				 PRIMARY KEY  (id),
				 KEY cat_id (`cat_id`),
				 KEY image_id (`image_id`));

ALTER TABLE `pideb_config` ADD `timezone` FLOAT DEFAULT '2' NOT NULL;
ALTER TABLE `pideb_config` ADD `catgluestart` VARCHAR(5) DEFAULT '[' NOT NULL;
ALTER TABLE `pideb_config` ADD `catglueend` VARCHAR(5) DEFAULT ']' NOT NULL;
ALTER TABLE `pideb_config` ADD `htmlemailnote` CHAR(3) DEFAULT 'yes';
ALTER TABLE `pideb_comments` ADD `email` VARCHAR(100);
ALTER TABLE `pideb_comments` MODIFY  `name` VARCHAR(30);
ALTER TABLE `pideb_comments` MODIFY  `url` VARCHAR(70);
ALTER TABLE `pideb_config` ADD `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `pideb_categories` DROP INDEX `id`, ADD PRIMARY KEY (`id`);
ALTER TABLE `pideb_comments` DROP INDEX `id`, ADD PRIMARY KEY (`id`), ADD INDEX (`parent_id`);
ALTER TABLE `pideb_pixelpost` DROP INDEX `id`, ADD PRIMARY KEY (`id`), ADD INDEX (`datetime`);
ALTER TABLE `pideb_visitors` ADD INDEX (`datetime`), ADD INDEX (`referer`), ADD INDEX (`ip`);

--		    340 Query       SELECT `id`, `category` FROM pideb_pixelpost

INSERT INTO `pideb_version` (`version`) VALUES ('1.41');

ALTER TABLE `pideb_config` ADD `moderate_comments` VARCHAR(3) DEFAULT 'no' NOT NULL;
ALTER TABLE pideb_comments ADD `publish` VARCHAR(3) DEFAULT 'yes' NOT NULL;

CREATE TABLE `pideb_addons` (
					 `id` INT(11) NOT NULL auto_increment,
					 `addon_name` VARCHAR(66) NOT NULL DEFAULT '',		
					 `status` VARCHAR(3) NOT NULL DEFAULT 'on',		
					 `type` VARCHAR(15) NOT NULL DEFAULT 'normal',
					 PRIMARY KEY (`id`));

--		    340 Query       SHOW TABLES FROM `pixelpost` LIKE 'pideb_addons'
--		    340 Query       select id from pideb_addons where addon_name='admin_ping'
INSERT INTO pideb_addons VALUES ( NULL, 'admin_ping',  'off', 'admin');

--		    340 Query       select id from pideb_addons where addon_name='_akismet/admin_akismet_comment'
INSERT INTO pideb_addons VALUES ( NULL, '_akismet/admin_akismet_comment',  'off', 'admin');

--		    340 Query       select id from pideb_addons where addon_name='_akismet/front_akismet_comment'
INSERT INTO pideb_addons VALUES ( NULL, '_akismet/front_akismet_comment',  'off', 'front');

--		    340 Query       select id from pideb_addons where addon_name='_defensio/admin_defensio'
INSERT INTO pideb_addons VALUES ( NULL, '_defensio/admin_defensio',  'off', 'admin');

--		    340 Query       select id from pideb_addons where addon_name='_defensio/front_defensio'
INSERT INTO pideb_addons VALUES ( NULL, '_defensio/front_defensio',  'off', 'front');

--		    340 Query       select id from pideb_addons where addon_name='admin_12CropImage'
INSERT INTO pideb_addons VALUES ( NULL, 'admin_12CropImage',  'off', 'admin');

--		    340 Query       select id from pideb_addons where addon_name='admin_update_exif'
INSERT INTO pideb_addons VALUES ( NULL, 'admin_update_exif',  'off', 'admin');

--		    340 Query       select id from pideb_addons where addon_name='advanced_stat'
INSERT INTO pideb_addons VALUES ( NULL, 'advanced_stat', 'off', 'normal');

--		    340 Query       select id from pideb_addons where addon_name='calendar'
INSERT INTO pideb_addons VALUES ( NULL, 'calendar', 'off', 'normal');

--		    340 Query       select id from pideb_addons where addon_name='copy_folder'
INSERT INTO pideb_addons VALUES ( NULL, 'copy_folder', 'off', 'normal');

--		    340 Query       select id from pideb_addons where addon_name='current_datetime'
INSERT INTO pideb_addons VALUES ( NULL, 'current_datetime', 'off', 'normal');

--		    340 Query       select id from pideb_addons where addon_name='paged_archive'
INSERT INTO pideb_addons VALUES ( NULL, 'paged_archive', 'off', 'normal');

ALTER TABLE `pideb_config` ADD `timestamp` VARCHAR(4) DEFAULT 'yes' NOT NULL;
ALTER TABLE `pideb_config` ADD `visitorbooking` VARCHAR(4) DEFAULT 'yes' NOT NULL;
INSERT INTO `pideb_version` (`version`) VALUES (1.49995);

CREATE TABLE `pideb_tags` (
				 `img_id` INT NOT NULL ,
				 `tag` TINYTEXT NOT NULL,
				 `alt_tag` TINYTEXT NOT NULL);
ALTER TABLE `pideb_config` ADD `altlangfile` VARCHAR(100) DEFAULT 'Off' NOT NULL;
ALTER TABLE `pideb_pixelpost` ADD `alt_headline` VARCHAR(150) DEFAULT '' NOT NULL,ADD `alt_body` TEXT;
ALTER TABLE pideb_categories ADD `alt_name` VARCHAR(100) DEFAULT 'DEFAULT' NOT NULL;
ALTER TABLE `pideb_config` ADD `markdown` VARCHAR(1) DEFAULT 'f' NOT NULL;
ALTER TABLE pideb_tags ADD PRIMARY KEY (`img_id` , `tag` (128), `alt_tag` (128));
ALTER TABLE `pideb_config` DROP `moderate_comments`;
ALTER TABLE `pideb_config` ADD `global_comments` ENUM('A', 'M', 'F') NOT NULL DEFAULT 'A';
ALTER TABLE `pideb_pixelpost` ADD `comments` ENUM('A', 'M', 'F') NOT NULL DEFAULT 'A';
ALTER TABLE `pideb_config` DROP `markdown`;
ALTER TABLE `pideb_config` ADD `markdown` ENUM('F', 'T') NOT NULL DEFAULT 'F';
ALTER TABLE `pideb_config` ADD `exif` ENUM('F', 'T') NOT NULL DEFAULT 'T';
ALTER TABLE `pideb_pixelpost` ADD `exif_info` TEXT NULL DEFAULT NULL;
ALTER TABLE `pideb_config` ADD `token` ENUM('F', 'T') NOT NULL DEFAULT 'F';
ALTER TABLE `pideb_config` ADD `token_time` VARCHAR(2) NOT NULL DEFAULT '5';
ALTER TABLE `pideb_config` ADD `comment_dsbl` ENUM('F', 'T') NOT NULL DEFAULT 'F';
ALTER TABLE `pideb_config` ADD `comment_timebetween` VARCHAR(3) NOT NULL DEFAULT '30';
ALTER TABLE `pideb_config` ADD `rsstype` ENUM('F', 'T', 'O' ,'N') NOT NULL DEFAULT 'T';
ALTER TABLE `pideb_config` ADD `feeditems` VARCHAR(3) NOT NULL DEFAULT '10';
ALTER TABLE `pideb_config` ADD `max_uri_comments` VARCHAR(3) NOT NULL DEFAULT '5';

INSERT INTO `pideb_version` (`version`) VALUES ('1.59');

ALTER TABLE `pideb_config` DROP `rsstype`;
ALTER TABLE `pideb_config` ADD `rsstype` ENUM('F', 'T', 'O' ,'N') NOT NULL DEFAULT 'T';

INSERT INTO `pideb_version` (version) VALUES (1.6);

--		    340 Query       SELECT count(`status`) as `total` FROM `pideb_addons` WHERE `status` = 'on'
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = '_akismet/admin_akismet_comment';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = '_akismet/front_akismet_comment';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = '_defensio/admin_defensio';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = '_defensio/front_defensio';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = 'admin_12CropImage';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = 'admin_ping';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = 'admin_update_exif';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = 'advanced_stat';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = 'calendar';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = 'copy_folder';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = 'current_datetime';
-- UPDATE `pideb_addons` SET `status` = `status_backup`, `status_backup` = 'res' WHERE `addon_name` = 'paged_archive';

--		    340 Query       SELECT `addon_name` FROM `pideb_addons` where `status_backup` = 'on'
-- ALTER TABLE `pideb_addons` DROP `status_backup`;
ALTER TABLE `pideb_config` ADD `admin_langfile` VARCHAR(100) NOT NULL DEFAULT 'english';
ALTER TABLE `pideb_config` ADD `thumbnailpath` VARCHAR(150) NOT NULL DEFAULT '../thumbnails/' AFTER `imagepath`;
ALTER TABLE `pideb_config` ADD `subtitle` VARCHAR(100) NOT NULL DEFAULT 'Authentic photoblog flavour' AFTER `sitetitle`;
ALTER TABLE `pideb_config` DROP `rsstype`;
ALTER TABLE `pideb_config` ADD `rsstype` ENUM('F', 'FO', 'T', 'O', 'N') NOT NULL DEFAULT 'T' AFTER `max_uri_comments`;
ALTER TABLE `pideb_config` ADD `feed_discovery` ENUM('RA', 'R', 'A', 'E', 'N') NOT NULL DEFAULT 'RA' AFTER `rsstype`;
ALTER TABLE `pideb_config` ADD `feed_title` VARCHAR(100) NOT NULL DEFAULT 'Pixelpost' AFTER `feed_discovery`;
ALTER TABLE `pideb_config` ADD `feed_description` VARCHAR(100) NOT NULL DEFAULT 'Authentic photoblog flavour' AFTER `feed_title`;
ALTER TABLE `pideb_config` ADD `feed_copyright` VARCHAR(100) NOT NULL DEFAULT 'Copyright 2008 yoursite.com, All Rights Reserved' AFTER `feed_description`;
ALTER TABLE `pideb_config` ADD `allow_comment_feed`  ENUM('Y', 'N') NOT NULL DEFAULT 'Y' AFTER `feed_copyright`;
ALTER TABLE `pideb_config` ADD `feed_external` VARCHAR(150) NOT NULL DEFAULT '' AFTER `allow_comment_feed`;
ALTER TABLE `pideb_config` ADD `feed_external_type` ENUM('ER', 'EA') NOT NULL DEFAULT 'ER' AFTER `feed_external`;
ALTER TABLE `pideb_config` ADD `display_order` ENUM('default', 'reversed') NOT NULL DEFAULT 'default';
ALTER TABLE `pideb_config` ADD `thumb_sharpening` VARCHAR(1) DEFAULT '0';
ALTER TABLE `pideb_config` ADD `display_sort_by` VARCHAR(150) NOT NULL DEFAULT 'datetime' AFTER `display_order`;
ALTER TABLE `pideb_config` DROP `comment_dsbl`;
-- UPDATE `pideb_config` SET `thumbnailpath` = '../thumbnails/';

INSERT INTO `pideb_version` (version) VALUES (1.7);
INSERT INTO `pideb_version` (version) VALUES (1.71);

--		    340 Query       SELECT version FROM pideb_version ORDER BY version DESC LIMIT 1
-- UPDATE pideb_config SET
--  	`email`   = '',
--  	`siteurl` = 'http://www.yourdomain.tld/pixelpost/',
--  	`admin_langfile` = 'english',
--  	`sitetitle`= 'Pixelpost on Debian',
--  	`subtitle` = 'Authentic photoblog flavour',
--  	`feed_title`= 'Pixelpost on Debian',
--  	`feed_description` = 'Authentic photoblog flavour',
--  	`feed_copyright` = 'Copyright 2008 http://www.yourdomain.tld/pixelpost/, All Rights Reserved',
--  	`timezone` = '0';

-- INSERT INTO `pideb_config` 
-- 	(`id`, `admin`, `password`, `email`, `commentemail`, `template`, `imagepath`, `thumbnailpath`, `siteurl`, `sitetitle`, `subtitle`, `langfile`, `calendar`, `crop`, `thumbwidth`, `thumbheight`, `thumbnumber`, `compression`, `dateformat`, `timezone`, `catgluestart`, `catglueend`, `htmlemailnote`, `timestamp`, `visitorbooking`, `altlangfile`, `global_comments`, `markdown`, `exif`, `token`, `token_time`, `comment_timebetween`, `feeditems`, `max_uri_comments`, `rsstype`, `feed_discovery`, `feed_title`, `feed_description`, `feed_copyright`, `allow_comment_feed`, `feed_external`, `feed_external_type`, `admin_langfile`, `display_order`, `display_sort_by`, `thumb_sharpening`) 
-- 	VALUES 
-- 	(1,'admin',MD5('ChangeMe'),'','no','horizon','../images/','../thumbnails/','http://www.yourdomain.tld/pixelpost/','Pixelpost on Debian','Authentic photoblog flavour','english','No Calendar','yes',100,75,5,75,'Y-m-d H:i:s',0,'[',']','yes','yes','yes','Off','A','F','T','F','5','30','10','5','T','RA','Pixelpost on Debian','Authentic photoblog flavour','Copyright 2008 http://www.yourdomain.tld/pixelpost/, All Rights Reserved','Y','','ER','english','default','datetime','0');

