Migrating to New Server - MySQL Error [Archive] - Canon Digital Photography Forums

mchilders

29th of June 2005 (Wed), 13:43

Hi Pekka,
I am trying to migrate my database to my new server at lunarpages.com and I receive the following error in the process when trying to restore with ee_backup:

filename: ee_backup_files/markchilders_2005-06-27@20_27_13.sql
target EE Backup db id: 0
delimiter: |EE|BACKUP|
sql dump filesize: 6946863
parse offset is now: 0000297
connection retries so far: 0

NEXT SQL COMMAND:
--------------------------------------------------
CREATE TABLE `ee_accessory` (
`ee_accessory_id` int(11) NOT NULL auto_increment,
`ee_accessory_photo_url` text NOT NULL,
PRIMARY KEY (`ee_accessory_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
--------------------------------------------------

PROBLEM: Can not go on.
COMMAND WAS REJECTED:

CREATE TABLE `ee_accessory` ( `ee_accessory_id` int(11) NOT NULL auto_increment, `ee_accessory_photo_url` text NOT NULL, PRIMARY KEY (`ee_accessory_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

PLEASE CHECK FIRST THAT THE CHOSEN READING DELIMITER (|EE|BACKUP|) IS CORRECT.

One possible reason for this error could be that the backup set you are trying to restore has commands like 'UNION' (near line above) which are only available in later version of MySQL. In this case, if you are aware of the implications of altering table creation parameters, you can try saving the backup set as a file and editing out the unsuitable commands before restoring it to this MySQL.

There is also a remote possibility that this error is caused by EE Backup's file parser. In that case check that there are no ')|EE|BACKUP| delimiter character blocks in the middle of a command. NOTE: EE Backup's file restore is compatible ONLY for sql backup files created with EE Backup.

Pekka

29th of June 2005 (Wed), 14:02

It is possible that the MySQL server you are trying to move is OLDER than the version you came from. That is why command "CHARSET=latin1" will fail (CHARSET is MySQL 4.1 command, it is not version 3 or 4.0 compatible).

One possibility to fix this is to manually remove CHARSET commands from CREATE TABLE command blocks. You can test the effect of this by making a text file with just

CREATE TABLE `ee_accessory` (
`ee_accessory_id` int(11) NOT NULL auto_increment,
`ee_accessory_photo_url` text NOT NULL,
PRIMARY KEY (`ee_accessory_id`)
) ENGINE=MyISAM

and save it as test.sql and upload to EE Backup and restore it in slow mode. If you get no errors then do the same correction for the whole dump.

mchilders

29th of June 2005 (Wed), 14:17

Thanks Pekka,
That seems to be the case the server is the previous version. That got me farther. But now I get this error:

EE BACKUP FILE RESTORE (SLOW MODE)

filename: ee_backup_files/markchilders_2005-06-27@NOlatin.sql
target EE Backup db id: 0
delimiter: |EE|BACKUP|
sql dump filesize: 6945521
parse offset is now: 0007253
connection retries so far: 0

NEXT SQL COMMAND:
--------------------------------------------------
CREATE TABLE `ee_exhibition` (
`ee_exhibition_id` int(11) NOT NULL auto_increment,
`ee_exhibition_start` date default NULL,
`ee_exhibition_end` date default NULL,
`ee_exhibition_pass` varchar(255) NOT NULL default 'public',
`ee_owner_id` int(11) NOT NULL default '0',
`ee_thumbs_id` int(11) NOT NULL default '0',
`ee_exhibition_sql_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`ee_exhibition_counter_offset` int(11) NOT NULL default '0',
`ee_exhibition_style_id` int(11) NOT NULL default '1',
`ee_list_view` varchar(255) NOT NULL default '',
`ee_list_perpage` int(11) NOT NULL default '10',
`ee_list_order` varchar(4) NOT NULL default 'ASC',
`ee_simplenavigation_search` tinyint(1) NOT NULL default '1',
`ee_detaillist_1` varchar(50) NOT NULL default '1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1',
`ee_detaillist_2` varchar(50) NOT NULL default '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1',
`ee_sort_row` varchar(255) NOT NULL default 'ee_photo.ee_photo_id',
`ee_simplenavigation_sort` tinyint(1) NOT NULL default '1',
`ee_simplenavigation_perpage` tinyint(1) NOT NULL default '1',
`ee_activate_links_list` tinyint(1) NOT NULL default '1',
`ee_activate_br_list` tinyint(1) NOT NULL default '1',
`ee_tooltip_showdetail` tinyint(1) NOT NULL default '1',
`ee_counter_scale` int(3) NOT NULL default '50',
`ee_use_custom_list_settings` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ee_exhibition_id`),
KEY `ee_owner_id` (`ee_owner_id`),
KEY `ee_thumbs_id` (`ee_thumbs_id`)
) ENGINE=MyISAM
--------------------------------------------------

PROBLEM: Can not go on.
COMMAND WAS REJECTED:

CREATE TABLE `ee_exhibition` ( `ee_exhibition_id` int(11) NOT NULL auto_increment, `ee_exhibition_start` date default NULL, `ee_exhibition_end` date default NULL, `ee_exhibition_pass` varchar(255) NOT NULL default 'public', `ee_owner_id` int(11) NOT NULL default '0', `ee_thumbs_id` int(11) NOT NULL default '0', `ee_exhibition_sql_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `ee_exhibition_counter_offset` int(11) NOT NULL default '0', `ee_exhibition_style_id` int(11) NOT NULL default '1', `ee_list_view` varchar(255) NOT NULL default '', `ee_list_perpage` int(11) NOT NULL default '10', `ee_list_order` varchar(4) NOT NULL default 'ASC', `ee_simplenavigation_search` tinyint(1) NOT NULL default '1', `ee_detaillist_1` varchar(50) NOT NULL default '1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1', `ee_detaillist_2` varchar(50) NOT NULL default '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1', `ee_sort_row` varchar(255) NOT NULL default 'ee_photo.ee_photo_id', `ee_simplenavigation_sort` tinyint(1) NOT NULL default '1', `ee_simplenavigation_perpage` tinyint(1) NOT NULL default '1', `ee_activate_links_list` tinyint(1) NOT NULL default '1', `ee_activate_br_list` tinyint(1) NOT NULL default '1', `ee_tooltip_showdetail` tinyint(1) NOT NULL default '1', `ee_counter_scale` int(3) NOT NULL default '50', `ee_use_custom_list_settings` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ee_exhibition_id`), KEY `ee_owner_id` (`ee_owner_id`), KEY `ee_thumbs_id` (`ee_thumbs_id`) ) ENGINE=MyISAM

Pekka

29th of June 2005 (Wed), 16:12

Here is the whole table creation part for EE 1.5 RC4, MySQL 4.0. Replace the whole block of commands, or save and restore this as separate file and delete those commands from your backup dump:

DROP TABLE IF EXISTS `ee_accessory`|EE|BACKUP|
CREATE TABLE `ee_accessory` (
`ee_accessory_id` int(11) NOT NULL auto_increment,
`ee_accessory_photo_url` text NOT NULL,
PRIMARY KEY (`ee_accessory_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_accessory_eng`|EE|BACKUP|
CREATE TABLE `ee_accessory_eng` (
`ee_accessory_id` int(11) NOT NULL auto_increment,
`ee_accessory_displayname` varchar(255) NOT NULL default '',
`ee_accessory_description` text NOT NULL,
PRIMARY KEY (`ee_accessory_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_admin`|EE|BACKUP|
CREATE TABLE `ee_admin` (
`ee_admin_id` int(11) NOT NULL auto_increment,
`ee_admin_name` varchar(32) NOT NULL default '',
`ee_admin_pass` varchar(32) NOT NULL default '',
`ee_admin_login` datetime NOT NULL default '2003-01-01 01:01:01',
`ee_admin_logout` datetime NOT NULL default '2003-01-01 01:01:02',
`ee_admin_session_id` varchar(32) NOT NULL default '00000000000000000000000000000000',
`ee_admin_session_ip` varchar(15) NOT NULL default '000.000.000.000',
`ee_admin_session_browser` varchar(255) NOT NULL default 'n/a',
PRIMARY KEY (`ee_admin_id`)
) TYPE=MyISAM COMMENT='ee editor user login'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_camera`|EE|BACKUP|
CREATE TABLE `ee_camera` (
`ee_camera_id` int(11) NOT NULL auto_increment,
`ee_camera_manufacturer` varchar(255) NOT NULL default '',
`ee_camera_model` varchar(255) NOT NULL default '',
`ee_camera_year` year(4) NOT NULL default '0000',
`ee_camera_photo_url` text NOT NULL,
`ee_camera_focal_multiplier` float NOT NULL default '0',
PRIMARY KEY (`ee_camera_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_camera_eng`|EE|BACKUP|
CREATE TABLE `ee_camera_eng` (
`ee_camera_id` int(11) NOT NULL auto_increment,
`ee_camera_displayname` varchar(255) NOT NULL default '',
`ee_camera_features` text NOT NULL,
`ee_camera_description` text NOT NULL,
`ee_camera_comments` text NOT NULL,
PRIMARY KEY (`ee_camera_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_category_eng`|EE|BACKUP|
CREATE TABLE `ee_category_eng` (
`ee_category_id` int(11) NOT NULL auto_increment,
`ee_category_name` varchar(255) NOT NULL default '',
`ee_category_description` text NOT NULL,
PRIMARY KEY (`ee_category_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_commerce_template`|EE|BACKUP|
CREATE TABLE `ee_commerce_template` (
`ee_commerce_template_id` int(11) NOT NULL auto_increment,
`ee_commerce_template_name` varchar(255) NOT NULL default '',
`ee_commerce_template_name_short` varchar(255) NOT NULL default '',
`ee_commerce_template_path` varchar(255) NOT NULL default '',
`ee_commerce_template_comment` text NOT NULL,
PRIMARY KEY (`ee_commerce_template_id`)
) TYPE=MyISAM COMMENT='EE commerce list of template paths'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_counter`|EE|BACKUP|
CREATE TABLE `ee_counter` (
`ee_counter_id` int(11) NOT NULL auto_increment,
`ee_counter_value` int(11) NOT NULL default '0',
`ee_counter_group` int(11) NOT NULL default '1',
PRIMARY KEY (`ee_counter_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_counter_index`|EE|BACKUP|
CREATE TABLE `ee_counter_index` (
`ee_counter_index_hits` int(11) NOT NULL default '1'
) TYPE=MyISAM COMMENT='index page hits'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_counter_list`|EE|BACKUP|
CREATE TABLE `ee_counter_list` (
`ee_counter_list_id` int(11) NOT NULL auto_increment,
`ee_counter_list_exhibition_id` int(11) NOT NULL default '0',
`ee_counter_list_perpage` varchar(255) NOT NULL default '',
`ee_counter_list_category_id` int(11) NOT NULL default '0',
`ee_counter_list_hits` int(11) NOT NULL default '1',
`ee_counter_list_output` varchar(255) NOT NULL default '',
`ee_counter_list_timestamp` date NOT NULL default '0000-00-00',
`ee_counter_list_keyword` varchar(255) NOT NULL default '',
`ee_counter_list_keyword_field` varchar(255) NOT NULL default '',
PRIMARY KEY (`ee_counter_list_id`),
KEY `ee_counter_list_exhibition_id` (`ee_counter_list_exhibition_id`),
KEY `ee_counter_list_category_id` (`ee_counter_list_category_id`)
) TYPE=MyISAM COMMENT='Some usage info from list.php'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_country_eng`|EE|BACKUP|
CREATE TABLE `ee_country_eng` (
`ee_country_id` int(11) NOT NULL auto_increment,
`ee_country_name` varchar(255) default NULL,
`ee_country_info` text NOT NULL,
PRIMARY KEY (`ee_country_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_defaults`|EE|BACKUP|
CREATE TABLE `ee_defaults` (
`ee_defaults_id` int(11) NOT NULL auto_increment,
`ee_exhibition_id` int(11) NOT NULL default '0',
`ee_camera_id` int(11) NOT NULL default '1',
`ee_lens_id` int(11) NOT NULL default '1',
`ee_country_id` int(11) NOT NULL default '1',
`ee_location_id` int(11) NOT NULL default '1',
`ee_light_id` int(11) NOT NULL default '1',
`ee_owner_id` int(11) NOT NULL default '1',
`ee_workflow_id` int(11) NOT NULL default '1',
`ee_photo_exif_date` date NOT NULL default '0000-00-00',
`ee_photo_exif_time` time NOT NULL default '00:00:00',
`ee_photo_exif_mode` varchar(50) NOT NULL default 'Manual',
`ee_photo_exif_metering` varchar(50) NOT NULL default 'Center-weighted',
`ee_photo_exif_iso` int(7) NOT NULL default '100',
`ee_photo_exif_zoom` float NOT NULL default '0',
`ee_photo_exif_focus` varchar(5) NOT NULL default '',
`ee_photo_exif_flash` varchar(255) NOT NULL default '',
`ee_photo_retouch` text NOT NULL,
`ee_photo_darkroom` text NOT NULL,
`ee_photo_camerasupport` varchar(255) NOT NULL default 'handheld',
`ee_photo_showdetail` tinyint(1) NOT NULL default '1',
`ee_photo_header` varchar(255) NOT NULL default 'New Photo',
`ee_photo_text` text NOT NULL,
`ee_photo_panorama` tinyint(1) NOT NULL default '0',
`ee_photo_exif_ev` varchar(7) NOT NULL default '0',
`ee_photo_orientation` char(1) NOT NULL default 'h',
`ee_backstage_pass` varchar(255) NOT NULL default 'public',
`ee_photo_showcountry` tinyint(1) NOT NULL default '1',
`ee_photo_header_style` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`ee_defaults_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_exhibition`|EE|BACKUP|
CREATE TABLE `ee_exhibition` (
`ee_exhibition_id` int(11) NOT NULL auto_increment,
`ee_exhibition_start` date default NULL,
`ee_exhibition_end` date default NULL,
`ee_exhibition_pass` varchar(255) NOT NULL default 'public',
`ee_owner_id` int(11) NOT NULL default '0',
`ee_thumbs_id` int(11) NOT NULL default '0',
`ee_exhibition_sql_modified` timestamp(14) NOT NULL,
`ee_exhibition_counter_offset` int(11) NOT NULL default '0',
`ee_exhibition_style_id` int(11) NOT NULL default '1',
`ee_list_view` varchar(255) NOT NULL default '',
`ee_list_perpage` int(11) NOT NULL default '10',
`ee_list_order` varchar(4) NOT NULL default 'ASC',
`ee_simplenavigation_search` tinyint(1) NOT NULL default '1',
`ee_detaillist_1` varchar(50) NOT NULL default '1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1',
`ee_detaillist_2` varchar(50) NOT NULL default '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1',
`ee_sort_row` varchar(255) NOT NULL default 'ee_photo.ee_photo_id',
`ee_simplenavigation_sort` tinyint(1) NOT NULL default '1',
`ee_simplenavigation_perpage` tinyint(1) NOT NULL default '1',
`ee_activate_links_list` tinyint(1) NOT NULL default '1',
`ee_activate_br_list` tinyint(1) NOT NULL default '1',
`ee_tooltip_showdetail` tinyint(1) NOT NULL default '1',
`ee_counter_scale` int(3) NOT NULL default '50',
`ee_use_custom_list_settings` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ee_exhibition_id`),
KEY `ee_owner_id` (`ee_owner_id`),
KEY `ee_thumbs_id` (`ee_thumbs_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_exhibition_eng`|EE|BACKUP|
CREATE TABLE `ee_exhibition_eng` (
`ee_exhibition_id` int(11) NOT NULL auto_increment,
`ee_exhibition_name` varchar(255) NOT NULL default '',
`ee_exhibition_description` text NOT NULL,
`ee_exhibition_meta_keywords` text NOT NULL,
`ee_exhibition_meta_description` text NOT NULL,
PRIMARY KEY (`ee_exhibition_id`),
KEY `ee_exhibition_name` (`ee_exhibition_name`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_exhibition_feedback`|EE|BACKUP|
CREATE TABLE `ee_exhibition_feedback` (
`ee_exhibition_feedback_id` int(11) NOT NULL auto_increment,
`ee_exhibition_id` int(11) NOT NULL default '0',
`ee_country_id` int(11) NOT NULL default '0',
`ee_exhibition_feedback_name` varchar(255) NOT NULL default '',
`ee_exhibition_feedback_email` varchar(255) NOT NULL default '',
`ee_exhibition_feedback_homepage` varchar(255) NOT NULL default '',
`ee_exhibition_feedback_text` text NOT NULL,
`ee_exhibition_feedback_comment` text NOT NULL,
`ee_exhibition_feedback_approved` char(3) NOT NULL default 'no',
`ee_exhibition_feedback_timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ee_exhibition_feedback_id`),
KEY `ee_exhibition_id` (`ee_exhibition_id`),
KEY `ee_country_id` (`ee_country_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_exhibition_group_eng`|EE|BACKUP|
CREATE TABLE `ee_exhibition_group_eng` (
`ee_exhibition_group_id` int(11) NOT NULL auto_increment,
`ee_exhibition_group_name` varchar(255) NOT NULL default '',
`ee_exhibition_group_description` text NOT NULL,
`ee_exhibition_group_image` text NOT NULL,
`ee_groupthumbs_style` tinyint(1) NOT NULL default '1',
`ee_groupthumbs_amount` int(3) NOT NULL default '3',
`ee_groupthumbs_size` tinyint(1) NOT NULL default '2',
PRIMARY KEY (`ee_exhibition_group_id`)
) TYPE=MyISAM COMMENT='Exhibition group definitions'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_exhibition_to_group`|EE|BACKUP|
CREATE TABLE `ee_exhibition_to_group` (
`ee_exhibition_to_group_id` int(11) NOT NULL auto_increment,
`ee_exhibition_id` int(11) NOT NULL default '0',
`ee_exhibition_group_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_exhibition_to_group_id`),
KEY `ee_exhibition_id` (`ee_exhibition_id`),
KEY `ee_exhibition_group_id` (`ee_exhibition_group_id`)
) TYPE=MyISAM COMMENT='map exhibitions to groups'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_ftp`|EE|BACKUP|
CREATE TABLE `ee_ftp` (
`ee_ftp_id` int(11) NOT NULL auto_increment,
`ee_ftp_name` varchar(255) NOT NULL default '',
`ee_ftp_server` varchar(255) NOT NULL default '',
`ee_ftp_passivemode` int(1) NOT NULL default '1',
`ee_ftp_username` varchar(255) NOT NULL default '',
`ee_ftp_password` text NOT NULL,
`ee_ftp_hidepass` tinyint(1) NOT NULL default '0',
`ee_ftp_testroot` varchar(255) NOT NULL default '',
`ee_ftp_ssl` int(1) NOT NULL default '0',
`ee_ftp_servertype` tinyint(4) NOT NULL default '0',
`ee_ftp_idletime` int(2) NOT NULL default '0',
`ee_ftp_uploadbuffer` int(11) NOT NULL default '512',
`ee_ftp_downloadbuffer` int(11) NOT NULL default '2048',
PRIMARY KEY (`ee_ftp_id`)
) TYPE=MyISAM COMMENT='Set up ftp servers for EE'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_ftp_to_microthumb`|EE|BACKUP|
CREATE TABLE `ee_ftp_to_microthumb` (
`ee_ftp_to_microthumb_id` int(11) NOT NULL auto_increment,
`ee_ftp_id` int(11) NOT NULL default '0',
`ee_microthumb_path_id` int(11) NOT NULL default '0',
`ee_resizemethod_id` int(11) NOT NULL default '0',
`ee_ftp_to_microthumb_folder` text NOT NULL,
PRIMARY KEY (`ee_ftp_to_microthumb_id`)
) TYPE=MyISAM COMMENT='Map ftp sites to size paths'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_ftp_to_size`|EE|BACKUP|
CREATE TABLE `ee_ftp_to_size` (
`ee_ftp_to_size_id` int(11) NOT NULL auto_increment,
`ee_ftp_id` int(11) NOT NULL default '0',
`ee_size_id` int(11) NOT NULL default '0',
`ee_resizemethod_id` int(11) NOT NULL default '0',
`ee_ftp_to_size_folder` text NOT NULL,
PRIMARY KEY (`ee_ftp_to_size_id`)
) TYPE=MyISAM COMMENT='Map ftp sites to size paths'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_ftp_to_thumb`|EE|BACKUP|
CREATE TABLE `ee_ftp_to_thumb` (
`ee_ftp_to_thumb_id` int(11) NOT NULL auto_increment,
`ee_ftp_id` int(11) NOT NULL default '0',
`ee_thumb_path_id` int(11) NOT NULL default '0',
`ee_resizemethod_id` int(11) NOT NULL default '0',
`ee_ftp_to_thumb_folder` text NOT NULL,
PRIMARY KEY (`ee_ftp_to_thumb_id`)
) TYPE=MyISAM COMMENT='Map ftp sites to size paths'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_language`|EE|BACKUP|
CREATE TABLE `ee_language` (
`ee_language_id` int(11) NOT NULL auto_increment,
`ee_language_var` char(3) NOT NULL default '',
`ee_language_menuname` varchar(255) NOT NULL default '',
`ee_language_comment` varchar(255) NOT NULL default '',
`ee_language_public` tinyint(1) NOT NULL default '0',
`ee_language_primary` tinyint(1) NOT NULL default '0',
`ee_language_lazylang` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ee_language_id`)
) TYPE=MyISAM COMMENT='EE Language selection list (only installed languages)'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_lens`|EE|BACKUP|
CREATE TABLE `ee_lens` (
`ee_lens_id` int(11) NOT NULL auto_increment,
`ee_lens_manufacturer` varchar(255) NOT NULL default '',
`ee_lens_min_mm` float NOT NULL default '0',
`ee_lens_max_mm` float NOT NULL default '0',
`ee_lens_min_f` float NOT NULL default '0',
`ee_lens_max_f` float NOT NULL default '0',
`ee_lens_model` varchar(255) NOT NULL default '',
`ee_lens_photo_url` varchar(255) NOT NULL default '',
PRIMARY KEY (`ee_lens_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_lens_eng`|EE|BACKUP|
CREATE TABLE `ee_lens_eng` (
`ee_lens_id` int(11) NOT NULL auto_increment,
`ee_lens_displayname` varchar(255) NOT NULL default '',
`ee_lens_description` text NOT NULL,
`ee_lens_comments` text NOT NULL,
PRIMARY KEY (`ee_lens_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_light_eng`|EE|BACKUP|
CREATE TABLE `ee_light_eng` (
`ee_light_id` int(11) NOT NULL auto_increment,
`ee_light_description` text NOT NULL,
PRIMARY KEY (`ee_light_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_location`|EE|BACKUP|
CREATE TABLE `ee_location` (
`ee_location_id` int(11) NOT NULL auto_increment,
`ee_location_name` varchar(255) NOT NULL default '',
`ee_location_info` text NOT NULL,
PRIMARY KEY (`ee_location_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_message`|EE|BACKUP|
CREATE TABLE `ee_message` (
`ee_message_id` int(11) NOT NULL auto_increment,
`ee_message_text` text NOT NULL,
`ee_message_originator` varchar(255) NOT NULL default '',
`ee_message_timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ee_message_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_microthumb_path`|EE|BACKUP|
CREATE TABLE `ee_microthumb_path` (
`ee_microthumb_path_id` int(11) NOT NULL auto_increment,
`ee_microthumb_path_url` varchar(255) NOT NULL default '',
`ee_microthumb_path` varchar(255) NOT NULL default '',
PRIMARY KEY (`ee_microthumb_path_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_news`|EE|BACKUP|
CREATE TABLE `ee_news` (
`ee_news_id` int(11) NOT NULL auto_increment,
`ee_news_date` date NOT NULL default '0000-00-00',
`ee_news_time` time default NULL,
`ee_news_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`ee_news_for_www` char(3) NOT NULL default '',
PRIMARY KEY (`ee_news_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_news_eng`|EE|BACKUP|
CREATE TABLE `ee_news_eng` (
`ee_news_id` int(11) NOT NULL auto_increment,
`ee_news_header` varchar(255) NOT NULL default '',
`ee_news_text` text NOT NULL,
PRIMARY KEY (`ee_news_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_order_to_exhibition`|EE|BACKUP|
CREATE TABLE `ee_order_to_exhibition` (
`ee_order_to_exhibition_id` int(11) NOT NULL auto_increment,
`ee_exhibition_id` int(11) NOT NULL default '1',
`ee_photo_id` int(11) NOT NULL default '1',
`ee_order` int(11) NOT NULL default '1',
PRIMARY KEY (`ee_order_to_exhibition_id`),
KEY `ee_exhibition_id` (`ee_exhibition_id`),
KEY `ee_photo_id` (`ee_photo_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_order_to_group`|EE|BACKUP|
CREATE TABLE `ee_order_to_group` (
`ee_order_to_group_id` int(11) NOT NULL auto_increment,
`ee_exhibition_group_id` int(11) NOT NULL default '0',
`ee_order` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_order_to_group_id`),
KEY `ee_exhibition_group_id` (`ee_exhibition_group_id`),
KEY `ee_order` (`ee_order`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_order_to_indexpage`|EE|BACKUP|
CREATE TABLE `ee_order_to_indexpage` (
`ee_order_to_indexpage_id` int(11) NOT NULL auto_increment,
`ee_exhibition_id` int(11) NOT NULL default '1',
`ee_order` int(11) NOT NULL default '1',
PRIMARY KEY (`ee_order_to_indexpage_id`),
KEY `ee_exhibition_id` (`ee_exhibition_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_owner`|EE|BACKUP|
CREATE TABLE `ee_owner` (
`ee_owner_id` int(11) NOT NULL auto_increment,
`ee_owner_name` varchar(255) NOT NULL default '',
`ee_owner_email` varchar(255) NOT NULL default '',
`ee_owner_homepage` text NOT NULL,
`ee_location_id` int(11) NOT NULL default '1',
`ee_country_id` int(11) NOT NULL default '191',
PRIMARY KEY (`ee_owner_id`),
KEY `ee_location_id` (`ee_location_id`),
KEY `ee_country_id` (`ee_country_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_owner_eng`|EE|BACKUP|
CREATE TABLE `ee_owner_eng` (
`ee_owner_id` int(11) NOT NULL auto_increment,
`ee_owner_text` text NOT NULL,
PRIMARY KEY (`ee_owner_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_performance`|EE|BACKUP|
CREATE TABLE `ee_performance` (
`ee_performance_id` timestamp(14) NOT NULL,
`ee_performance_source_id` int(11) NOT NULL default '0',
`ee_performance_1` decimal(6,4) NOT NULL default '0.0000',
`ee_performance_2` decimal(6,4) NOT NULL default '0.0000',
`ee_performance_3` decimal(6,4) NOT NULL default '0.0000',
`ee_performance_4` decimal(6,4) NOT NULL default '0.0000',
`ee_performance_source` tinyint(3) NOT NULL default '1',
`ee_performance_extrainfo_1` char(100) NOT NULL default '',
`ee_performance_extrainfo_2` char(100) NOT NULL default ''
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_photo`|EE|BACKUP|
CREATE TABLE `ee_photo` (
`ee_photo_id` int(11) NOT NULL auto_increment,
`ee_photo_displayorder` int(11) NOT NULL default '9999',
`ee_camera_id` int(11) NOT NULL default '1',
`ee_photo_filename` varchar(255) NOT NULL default '',
`ee_photo_panorama` tinyint(1) NOT NULL default '0',
`ee_owner_id` int(11) NOT NULL default '1',
`ee_country_id` int(11) NOT NULL default '191',
`ee_location_id` int(11) NOT NULL default '1',
`ee_photo_exif_date` date NOT NULL default '0000-00-00',
`ee_photo_exif_time` time NOT NULL default '00:00:00',
`ee_photo_exif_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`ee_photo_exif_mode` varchar(50) NOT NULL default 'Manual',
`ee_photo_exif_metering` varchar(50) NOT NULL default 'Center-weighted',
`ee_photo_exif_shutter` decimal(6,1) NOT NULL default '0.0',
`ee_photo_shutter_unit` varchar(5) NOT NULL default '1/100',
`ee_photo_exif_aperture` float NOT NULL default '0',
`ee_photo_exif_ev` varchar(7) NOT NULL default '0',
`ee_photo_exif_iso` int(7) NOT NULL default '100',
`ee_lens_id` int(11) NOT NULL default '1',
`ee_photo_exif_zoom` float NOT NULL default '0',
`ee_photo_exif_focus` varchar(5) NOT NULL default '',
`ee_photo_exif_media` varchar(255) NOT NULL default '',
`ee_photo_for_www` char(3) NOT NULL default 'no',
`ee_photo_orientation` char(1) NOT NULL default 'h',
`ee_counter_id` int(11) NOT NULL default '0',
`ee_light_id` int(11) NOT NULL default '1',
`ee_workflow_id` int(11) NOT NULL default '1',
`ee_photo_sql_modified` timestamp(14) NOT NULL,
`ee_photo_sql_created` datetime default '2002-01-01 00:00:00',
`ee_photo_showdetail` tinyint(1) NOT NULL default '1',
`ee_photo_showcountry` tinyint(1) NOT NULL default '1',
`ee_photo_foo` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`ee_photo_id`),
KEY `ee_camera_id` (`ee_camera_id`),
KEY `ee_owner_id` (`ee_owner_id`),
KEY `ee_lens_id` (`ee_lens_id`),
KEY `ee_workflow_id` (`ee_workflow_id`),
KEY `ee_location_id` (`ee_location_id`),
KEY `ee_country_id` (`ee_country_id`),
KEY `ee_counter_id` (`ee_counter_id`),
KEY `ee_light_id` (`ee_light_id`),
KEY `ee_photo_id` (`ee_photo_id`)
) TYPE=MyISAM PACK_KEYS=1|EE|BACKUP|
DROP TABLE IF EXISTS `ee_photo_comment`|EE|BACKUP|
CREATE TABLE `ee_photo_comment` (
`ee_photo_comment_id` int(11) NOT NULL auto_increment,
`ee_photo_id` int(11) NOT NULL default '0',
`ee_country_id` int(11) NOT NULL default '0',
`ee_photo_comment_name` varchar(255) NOT NULL default '',
`ee_photo_comment_email` varchar(255) NOT NULL default '',
`ee_photo_comment_homepage` varchar(255) NOT NULL default '',
`ee_photo_comment_text` text NOT NULL,
`ee_photo_comment_comment` text NOT NULL,
`ee_photo_comment_approved` int(1) NOT NULL default '0',
`ee_photo_comment_timestamp` datetime default NULL,
`ee_photo_comment_ratings` varchar(11) NOT NULL default '',
`ee_photo_comment_ip` varchar(15) NOT NULL default '',
`ee_photo_comment_user_agent` varchar(255) NOT NULL default '',
PRIMARY KEY (`ee_photo_comment_id`),
KEY `ee_photo_comment_ratings` (`ee_photo_comment_ratings`),
KEY `ee_photo_id` (`ee_photo_id`),
KEY `ee_country_id` (`ee_country_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_photo_eng`|EE|BACKUP|
CREATE TABLE `ee_photo_eng` (
`ee_photo_id` int(11) NOT NULL auto_increment,
`ee_photo_header` varchar(255) NOT NULL default 'New Photo',
`ee_photo_text` text NOT NULL,
`ee_photo_exif_flash` varchar(255) NOT NULL default 'no',
`ee_photo_retouch` text NOT NULL,
`ee_photo_darkroom` text NOT NULL,
`ee_photo_camerasupport` varchar(255) NOT NULL default 'handheld',
`ee_photo_meta_keywords` text NOT NULL,
PRIMARY KEY (`ee_photo_id`),
KEY `ee_photo_id` (`ee_photo_id`)
) TYPE=MyISAM PACK_KEYS=1|EE|BACKUP|
DROP TABLE IF EXISTS `ee_photo_size`|EE|BACKUP|
CREATE TABLE `ee_photo_size` (
`ee_photo_size_id` int(11) NOT NULL auto_increment,
`ee_photo_id` int(11) NOT NULL default '0',
`ee_size_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_photo_size_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_photo_to_accessory`|EE|BACKUP|
CREATE TABLE `ee_photo_to_accessory` (
`ee_photo_to_accessory_id` int(11) NOT NULL auto_increment,
`ee_photo_id` int(11) NOT NULL default '0',
`ee_accessory_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_photo_to_accessory_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_photo_to_category`|EE|BACKUP|
CREATE TABLE `ee_photo_to_category` (
`ee_photo_to_category_id` int(11) NOT NULL auto_increment,
`ee_photo_id` int(11) NOT NULL default '0',
`ee_category_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_photo_to_category_id`),
KEY `ee_photo_id` (`ee_photo_id`),
KEY `ee_category_id` (`ee_category_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_photo_to_ee_commerce_template`|EE|BACKUP|
CREATE TABLE `ee_photo_to_ee_commerce_template` (
`ee_photo_to_ee_commerce_template_id` int(11) NOT NULL auto_increment,
`ee_photo_id` int(11) NOT NULL default '0',
`ee_commerce_template_id` int(11) NOT NULL default '0',
`ee_thumb_path_id` int(11) NOT NULL default '0',
`ee_size_id` int(11) NOT NULL default '0',
`ee_photo_to_ee_commerce_template_comment` text NOT NULL,
PRIMARY KEY (`ee_photo_to_ee_commerce_template_id`),
KEY `ee_photo_id` (`ee_photo_id`),
KEY `ee_commerce_template_id` (`ee_commerce_template_id`),
KEY `ee_thumb_path_id` (`ee_thumb_path_id`),
KEY `ee_size_id` (`ee_size_id`)
) TYPE=MyISAM COMMENT='Map a photo to any number fo EE commerce templates'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_photo_to_exhibition`|EE|BACKUP|
CREATE TABLE `ee_photo_to_exhibition` (
`ee_photo_to_exhibition_id` int(11) NOT NULL auto_increment,
`ee_photo_id` int(11) NOT NULL default '0',
`ee_exhibition_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_photo_to_exhibition_id`),
KEY `ee_exhibition_id` (`ee_exhibition_id`),
KEY `ee_photo_id` (`ee_photo_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_resizemethod`|EE|BACKUP|
CREATE TABLE `ee_resizemethod` (
`ee_resizemethod_id` int(11) NOT NULL auto_increment,
`ee_resizemethod_method` varchar(20) NOT NULL default '',
`ee_resizemethod_name` varchar(255) NOT NULL default '',
`ee_resizemethod_resizestyle` tinyint(1) NOT NULL default '1',
`ee_resizemethod_resize_value` int(5) NOT NULL default '100',
`ee_resizemethod_resize_value_2` int(5) NOT NULL default '0',
`ee_resizemethod_compressionquality` int(3) NOT NULL default '75',
`ee_resizemethod_sharpening` tinyint(1) NOT NULL default '0',
`ee_resizemethod_usm_radius` float NOT NULL default '0',
`ee_resizemethod_usm_treshold` float NOT NULL default '0',
`ee_resizemethod_usm_amount` int(1) NOT NULL default '0',
`ee_resizemethod_usm_sigma` float NOT NULL default '0',
`ee_resizemethod_remove_profiles` tinyint(1) NOT NULL default '1',
`ee_resizemethod_antialias` tinyint(1) NOT NULL default '1',
`ee_resizemethod_safetynet` varchar(255) NOT NULL default '',
`ee_resizemethod_is_thumb` tinyint(1) NOT NULL default '0',
`ee_resizemethod_is_microthumb` tinyint(1) NOT NULL default '0',
`ee_resizemethod_extracommand` varchar(255) NOT NULL default '',
`ee_resizemethod_watermark` tinyint(1) NOT NULL default '0',
`ee_resizemethod_watermark_order` tinyint(1) NOT NULL default '2',
`ee_resizemethod_watermark_image` varchar(255) NOT NULL default '',
`ee_resizemethod_watermark_placement` int(2) NOT NULL default '3',
`ee_resizemethod_watermark_transparency` int(3) NOT NULL default '80',
PRIMARY KEY (`ee_resizemethod_id`)
) TYPE=MyISAM COMMENT='resize method list'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_settings`|EE|BACKUP|
CREATE TABLE `ee_settings` (
`ee_version` varchar(255) NOT NULL default '',
`ee_list_view` varchar(255) NOT NULL default '',
`ee_list_perpage` int(11) NOT NULL default '10',
`ee_list_order` varchar(4) NOT NULL default '',
`ee_showlowernavigation` tinyint(4) NOT NULL default '1',
`ee_indexpage_style_id` int(11) NOT NULL default '1',
`ee_selectphoto_size` varchar(255) NOT NULL default 'thumb',
`ee_activate_links_photo` tinyint(1) NOT NULL default '1',
`ee_activate_links_index` tinyint(1) NOT NULL default '1',
`ee_activate_links_list` tinyint(1) NOT NULL default '1',
`ee_activate_links_gear` tinyint(1) NOT NULL default '1',
`ee_activate_br_photo` tinyint(1) NOT NULL default '1',
`ee_activate_br_list` tinyint(1) NOT NULL default '1',
`ee_activate_br_gear` tinyint(1) NOT NULL default '1',
`ee_activate_br_index` tinyint(1) NOT NULL default '1',
`ee_photoclick_rule` tinyint(1) NOT NULL default '2',
`ee_messagerefresh` int(3) NOT NULL default '5',
`ee_feedbackrule` tinyint(1) NOT NULL default '1',
`ee_simplenavigation_search` tinyint(1) NOT NULL default '1',
`ee_photopage_thumbs` int(2) NOT NULL default '3',
`ee_photocenter` tinyint(1) NOT NULL default '1',
`ee_detaillist_1` varchar(255) NOT NULL default '1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1',
`ee_detaillist_2` varchar(255) NOT NULL default '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1',
`ee_indexstyle` int(11) NOT NULL default '1',
`ee_sort_row` varchar(255) NOT NULL default 'ee_photo.ee_photo_id',
`ee_sizepathmenu_sort` varchar(255) NOT NULL default 'ee_size.ee_size_id',
`ee_sizepathmenu_sort_direction` varchar(4) NOT NULL default 'DESC',
`ee_imagecheckifthere` tinyint(1) NOT NULL default '0',
`ee_indexpage_order` tinyint(1) NOT NULL default '1',
`ee_optimizelimit_1` int(11) NOT NULL default '100',
`ee_framebust` tinyint(1) NOT NULL default '1',
`ee_indexcolumns` tinyint(2) NOT NULL default '3',
`ee_check_orientation` tinyint(1) NOT NULL default '1',
`ee_indexpage_countries` tinyint(2) NOT NULL default '4',
`ee_indexpage_microthumbs` tinyint(2) NOT NULL default '8',
`ee_indexpage_news` tinyint(2) NOT NULL default '5',
`ee_indexpage_thumblistmethod` varchar(6) NOT NULL default 'random',
`ee_help` tinyint(1) NOT NULL default '1',
`ee_on` tinyint(1) NOT NULL default '1',
`ee_indexpage_showowner` tinyint(1) NOT NULL default '1',
`ee_indexpage_showdescription` tinyint(1) NOT NULL default '1',
`ee_indexpage_showexhibphotocount` tinyint(1) NOT NULL default '1',
`ee_indexpage_indiv_feedbacklinks` tinyint(1) NOT NULL default '1',
`ee_zeromargin` tinyint(1) NOT NULL default '1',
`ee_simplenavigation_sort` tinyint(1) NOT NULL default '1',
`ee_simplenavigation_perpage` tinyint(1) NOT NULL default '1',
`ee_additional_margin` smallint(3) NOT NULL default '15',
`ee_showvalidpaths` tinyint(1) NOT NULL default '0',
`ee_javascriptlinks` tinyint(1) NOT NULL default '1',
`ee_dateformat` tinyint(2) NOT NULL default '1',
`ee_show_counter` tinyint(1) NOT NULL default '1',
`ee_counter_scale` int(3) NOT NULL default '50',
`ee_featuredlist` varchar(255) NOT NULL default '',
`ee_mogrify_path` text NOT NULL,
`ee_composite_path` text NOT NULL,
`ee_upload_hide_photos` tinyint(1) NOT NULL default '1',
`ee_upload_guess_owner` tinyint(1) NOT NULL default '1',
`ee_upload_guess_camera` tinyint(1) NOT NULL default '1',
`ee_upload_guess_lens` tinyint(1) NOT NULL default '1',
`ee_upload_guess_location` tinyint(1) NOT NULL default '1',
`ee_upload_guess_country` tinyint(1) NOT NULL default '1',
`ee_upload_auto_rename` smallint(1) NOT NULL default '1',
`ee_ftp_servername` varchar(255) NOT NULL default '',
`ee_ftp_username` varchar(255) NOT NULL default '',
`ee_ftp_userpass` varchar(255) NOT NULL default '',
`ee_ftp_hidepass` tinyint(1) NOT NULL default '0',
`ee_ftp_ee_root` varchar(255) NOT NULL default '',
`ee_ftp_passivemode` int(1) NOT NULL default '1',
`ee_ftp_ssl` int(1) NOT NULL default '0',
`ee_ftp_servertype` tinyint(4) NOT NULL default '0',
`ee_ftp_idletime` int(2) NOT NULL default '0',
`ee_ftp_uploadbuffer` int(11) NOT NULL default '512',
`ee_ftp_downloadbuffer` int(11) NOT NULL default '2048',
`ee_ftp_do_filetests` tinyint(1) NOT NULL default '1',
`comment_needs_approving` int(1) NOT NULL default '1',
`ee_backup_source` char(2) NOT NULL default '0',
`ee_backup_target` char(2) NOT NULL default '0',
`ee_backup_style` int(1) NOT NULL default '2',
`ee_show_pass_field` tinyint(1) NOT NULL default '1',
`ee_show_ratings` char(1) NOT NULL default '1',
`ee_num_ratings` tinyint(1) NOT NULL default '3',
`ee_ratings_required` int(3) NOT NULL default '5',
`ee_rating_thumb` varchar(10) NOT NULL default 'microthumb',
`ee_show_comments` tinyint(1) NOT NULL default '1',
`ee_show_combined` tinyint(1) NOT NULL default '1',
`ee_autorefresh_active` tinyint(1) NOT NULL default '1',
`ee_installed_imagemagick` tinyint(1) NOT NULL default '0',
`ee_installed_imagick` tinyint(1) NOT NULL default '0',
`ee_installed_gd` tinyint(1) NOT NULL default '0',
`ee_installed_exif` tinyint(1) NOT NULL default '0',
`ee_installed_iptc` tinyint(1) NOT NULL default '0',
`ee_photopage_showdetail` tinyint(1) NOT NULL default '1',
`ee_tooltip_showdetail` tinyint(1) NOT NULL default '1',
`ee_ratedlist` text NOT NULL,
`ee_commentedlist` text NOT NULL,
`ee_imagemagick_profile_command` varchar(255) NOT NULL default '"*"',
`ee_ftp_filesorting_order` char(2) NOT NULL default '1d',
`ee_performance_samples` int(4) NOT NULL default '200',
`ee_add_path_trailing_slash` tinyint(1) NOT NULL default '1',
`ee_editor_font_size` int(2) NOT NULL default '11',
`ee_use_pt_pano` tinyint(1) NOT NULL default '0',
`ee_use_pt_flat` tinyint(1) NOT NULL default '0',
`ee_make_pt_files_local` tinyint(1) NOT NULL default '0',
`ee_try_pt_crypt` tinyint(1) NOT NULL default '0',
`ee_ftp_view` tinyint(1) NOT NULL default '0',
`ee_flash_view` tinyint(1) NOT NULL default '0',
`ee_ftp_cleanup` int(3) NOT NULL default '100',
`ee_debug` tinyint(1) NOT NULL default '0',
`ee_editor_font_family` varchar(255) NOT NULL default 'Verdana, Geneva, Arial, Helvetica, sans-serif',
`ee_indexpage_thumbcaption` tinyint(1) NOT NULL default '1',
`ee_indexpage_thumbsize` varchar(10) NOT NULL default 'microthumb',
`ee_ftp_engine` char(3) NOT NULL default 'php',
`ee_galleryroot` varchar(255) NOT NULL default '',
`ee_gather_performance_data` tinyint(1) NOT NULL default '1',
`ee_upload_category_method` tinyint(1) NOT NULL default '1',
`ee_photodetailrow` varchar(255) NOT NULL default '2,2,3,2,4,2,5,2,6,2,7,2,8,2,9,2,10,2,11,2,12,2,13 ,2,14,2,15,2,16,2,17,2,18,2,19,2,20,2,21,2,22,2,23 ,2,24,2,25,2,26,2,27',
`ee_center_photopage_detail` tinyint(1) NOT NULL default '0',
`ee_show_photopage_detail_switch` tinyint(1) NOT NULL default '1',
`ee_performance_list_breakdown` int(5) NOT NULL default '5'
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_settings_eng`|EE|BACKUP|
CREATE TABLE `ee_settings_eng` (
`ee_webmaster_email` varchar(255) NOT NULL default '',
`ee_indexpage_header` varchar(255) NOT NULL default 'Welcome',
`ee_indexpage_title` varchar(255) NOT NULL default '',
`ee_indexpage_text` text NOT NULL,
`ee_copyright_info` text NOT NULL,
`ee_indexlink` varchar(255) NOT NULL default 'INDEX OF EXHIBITIONS + NEWS',
`ee_off_message` text NOT NULL,
`ee_indexpage_headersize` smallint(5) unsigned NOT NULL default '18',
`ee_indexpage_truncatedescription` int(5) NOT NULL default '0',
`ee_include_header` text NOT NULL,
`ee_include_footer` text NOT NULL,
`ee_charset` varchar(255) NOT NULL default 'iso-8859-1'
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_size`|EE|BACKUP|
CREATE TABLE `ee_size` (
`ee_size_id` int(11) NOT NULL auto_increment,
`ee_size_url` text NOT NULL,
`ee_size_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`ee_size_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_size_defaults`|EE|BACKUP|
CREATE TABLE `ee_size_defaults` (
`ee_size_defaults_id` int(11) NOT NULL auto_increment,
`ee_size_id` int(11) NOT NULL default '0',
`ee_exhibition_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_size_defaults_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_size_eng`|EE|BACKUP|
CREATE TABLE `ee_size_eng` (
`ee_size_id` int(11) NOT NULL auto_increment,
`ee_size_menutext` varchar(255) NOT NULL default '',
PRIMARY KEY (`ee_size_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_style`|EE|BACKUP|
CREATE TABLE `ee_style` (
`ee_style_id` int(11) NOT NULL auto_increment,
`ee_style_name` varchar(255) NOT NULL default '',
`ee_style_path` text NOT NULL,
`ee_style_description` text NOT NULL,
PRIMARY KEY (`ee_style_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_thumb_path`|EE|BACKUP|
CREATE TABLE `ee_thumb_path` (
`ee_thumb_path_id` int(11) NOT NULL auto_increment,
`ee_thumb_path_url` varchar(255) NOT NULL default '',
`ee_thumb_path` varchar(255) NOT NULL default '',
PRIMARY KEY (`ee_thumb_path_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_thumbs`|EE|BACKUP|
CREATE TABLE `ee_thumbs` (
`ee_thumbs_id` int(11) NOT NULL auto_increment,
`ee_thumb_path_id` int(11) NOT NULL default '0',
`ee_microthumb_path_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_thumbs_id`),
KEY `ee_thumb_path_id` (`ee_thumb_path_id`),
KEY `ee_microthumb_path_id` (`ee_microthumb_path_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_uncookied`|EE|BACKUP|
CREATE TABLE `ee_uncookied` (
`ee_uncookied_id` int(11) NOT NULL auto_increment,
`ee_uncookied_data` text NOT NULL,
`ee_uncookied_compression` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ee_uncookied_id`)
) TYPE=MyISAM COMMENT='uncookied data'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_uncookied_settings`|EE|BACKUP|
CREATE TABLE `ee_uncookied_settings` (
`ee_uncookied_splitter` char(50) NOT NULL default '|',
`ee_uncookied_foochar` char(50) NOT NULL default '',
`ee_uncookied_compressed` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM COMMENT='Uncookied settings'|EE|BACKUP|
DROP TABLE IF EXISTS `ee_workflow`|EE|BACKUP|
CREATE TABLE `ee_workflow` (
`ee_workflow_id` int(11) NOT NULL auto_increment,
`ee_owner_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ee_workflow_id`)
) TYPE=MyISAM|EE|BACKUP|
DROP TABLE IF EXISTS `ee_workflow_eng`|EE|BACKUP|
CREATE TABLE `ee_workflow_eng` (
`ee_workflow_id` int(11) NOT NULL auto_increment,
`ee_workflow_name` varchar(255) NOT NULL default '',
`ee_workflow_text` text NOT NULL,
PRIMARY KEY (`ee_workflow_id`)
) TYPE=MyISAM|EE|BACKUP|

mchilders

29th of June 2005 (Wed), 21:02

Thanks for the quick help. My migration is now complete.

-Mark