[05-Aug-2014 13:21:31 Europe/Madrid]  ----- START updateDB ----- 
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_username VARCHAR(40) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_password CHAR(60) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_email VARCHAR(100) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_secret VARCHAR(40) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_moderator TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_email VARCHAR(100) DEFAULT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_user_id INT(10) UNSIGNED DEFAULT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_search LONGTEXT
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_secret VARCHAR(40) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_active TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- e_type enum('INSTANT','HOURLY','DAILY','WEEKLY','CUSTOM') NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_date DATETIME NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_unsub_date DATETIME NULL DEFAULT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- d_date DATE NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_alerts_sent INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(250) NOT NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_ip VARCHAR(50) NOT NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_email VARCHAR(250) NOT NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_parent_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_expiration_days INT(3) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_position INT(2) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_price_enabled TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_icon VARCHAR(250) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_locale_code CHAR(5) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(100) NULL DEFAULT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_description TEXT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_slug VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_region_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(60) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_slug VARCHAR(60) NOT NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_country_code CHAR(2) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_active TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_city_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(255) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_city_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_c_code CHAR(2) NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(80) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_slug VARCHAR(80) NOT NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_country_code CHAR(2) NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- e_type enum('INSTANT','HOURLY','DAILY','WEEKLY','CUSTOM') NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- d_last_exec DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- d_next_exec DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_c_code CHAR(3) NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(40) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_description VARCHAR(80) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_user_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_pub_date DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_mod_date DATETIME NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- f_price FLOAT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_price BIGINT(20) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_currency_code CHAR(3) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_contact_name VARCHAR(100) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_contact_email VARCHAR(140) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_ip VARCHAR(64) NOT NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_premium TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_active TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_spam TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_secret VARCHAR(40) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_show_email TINYINT(1) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_expiration datetime NOT NULL DEFAULT '9999-12-31 23:59:59'
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_pub_date DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_title VARCHAR(200) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_author_name VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_author_email VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_body TEXT NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_active TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_spam TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_user_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_locale_code CHAR(5) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_title VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_description MEDIUMTEXT NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_country_code CHAR(2) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_country VARCHAR(40) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_address VARCHAR(100) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_zip VARCHAR(15) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_region_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_region VARCHAR(100)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_city_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_city VARCHAR(100) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_city_area_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_city_area VARCHAR(200) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- d_coord_lat DECIMAL(10,6)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- d_coord_long DECIMAL(10,6)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_field_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_value TEXT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_multi VARCHAR(20) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(60) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_extension VARCHAR(10) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_content_type VARCHAR(40) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_path VARCHAR(250) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_views INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_spam INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_repeated INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_bad_classified INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_offensive INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_expired INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_premium_views INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_date DATE NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_md5 VARCHAR(32) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_locale_code CHAR(5) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_original_text VARCHAR(255) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_anchor_text VARCHAR(255) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_normalized_text VARCHAR(255) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_category_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_city_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- d_date DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_search VARCHAR(255) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_c_code CHAR(5) NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_short_name VARCHAR(40) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_description VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_version VARCHAR(20) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_author_name VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_author_url VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_currency_format VARCHAR(50) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_dec_point VARCHAR(2) NULL DEFAULT '.'
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_thousands_sep VARCHAR(2) NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_dec TINYINT(4) NULL DEFAULT 2
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_date_format VARCHAR(20) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_stop_words TEXT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_enabled_bo TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- id_location varchar(10) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- e_type enum('COUNTRY','REGION','CITY') NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_date DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_section VARCHAR(50) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_action VARCHAR(50) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_data VARCHAR(250) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_ip VARCHAR(50) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_who VARCHAR(50) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_who_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_field_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(255) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_slug VARCHAR(255) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- e_type ENUM('TEXT','TEXTAREA','DROPDOWN','RADIO','CHECKBOX','URL', 'DATE', 'DATEINTERVAL') NOT NULL DEFAULT  'TEXT'
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_options VARCHAR(255) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_required TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_searchable TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_internal_name VARCHAR(50) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_indelible TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_link TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_pub_date DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_mod_date DATETIME NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_order INT(3) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_meta TEXT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_pages_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_locale_code CHAR(5) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_title VARCHAR(255) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_text TEXT
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_plugin_name VARCHAR(40) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_section VARCHAR(40) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(40) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_value LONGTEXT NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- e_type ENUM('STRING', 'INTEGER', 'BOOLEAN') NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_country_code CHAR(2) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(60) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_slug VARCHAR(60) NOT NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_active TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_region_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_reg_date DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_mod_date DATETIME NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_name VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_username VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_password CHAR(60) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_secret VARCHAR(40) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_email VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_website VARCHAR(100) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_phone_land VARCHAR(45)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_phone_mobile VARCHAR(45)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_active TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_pass_code VARCHAR(100) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_pass_date DATETIME NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_pass_ip VARCHAR(15) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_country_code CHAR(2) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_country VARCHAR(40) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_address VARCHAR(100) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_zip VARCHAR(15) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_region_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_region VARCHAR(100)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_city_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_city VARCHAR(100) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_city_area_id INT(10) UNSIGNED NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_city_area VARCHAR(200) NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- d_coord_lat DECIMAL(10,6)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- d_coord_long DECIMAL(10,6)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- b_company TINYINT(1) NOT NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_items INT(10) UNSIGNED NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- i_comments INT(10) UNSIGNED NULL DEFAULT 0
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_access_date DATETIME NOT NULL DEFAULT  '0000-00-00 00:00:00'
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_access_ip VARCHAR(15) NOT NULL DEFAULT ''
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_user_id INT(10) UNSIGNED NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_c_locale_code CHAR(5) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_info TEXT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- fk_i_user_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_new_email VARCHAR(100) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- dt_date DATETIME NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_description VARCHAR(40) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_location VARCHAR(40) NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- e_kind ENUM('TEXT', 'HTML') NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- s_content MEDIUMTEXT NOT NULL
[05-Aug-2014 13:21:31 Europe/Madrid]  --- last_struct_queries ---
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_category ADD INDEX (fk_i_parent_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_category ADD INDEX (i_position)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_city ADD INDEX (fk_i_region_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_city_area ADD INDEX (fk_i_city_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_item ADD INDEX (fk_i_user_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_item ADD INDEX idx_b_premium (b_premium)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_item ADD INDEX (fk_i_category_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_item ADD INDEX (fk_c_currency_code)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_item_comment ADD INDEX (fk_i_item_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_item_resource ADD INDEX (fk_i_item_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_item_stats ADD INDEX (dt_date, fk_i_item_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_keywords ADD INDEX (fk_i_category_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_keywords ADD INDEX (fk_i_city_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_plugin_category ADD INDEX (fk_i_category_id)
[05-Aug-2014 13:21:31 Europe/Madrid]  --- ALTER TABLE oc_t_region ADD INDEX (fk_c_country_code)
[05-Aug-2014 13:21:31 Europe/Madrid]  ----- END updateDB ----- 
[05-Aug-2014 13:21:31 Europe/Madrid]  ------- START upgrade-funcs -------