Файл: oc-includes/osclass/installer/struct.sql
Строк: 262
SET NAMES 'UTF8';
CREATE TABLE /*TABLE_PREFIX*/t_locale (
pk_c_code
CHAR(5) NOT NULL,
s_name VARCHAR(100) NOT NULL,
s_short_name
VARCHAR(40) NOT NULL,
s_description VARCHAR(100) NOT NULL,
s_version VARCHAR(20) NOT NULL,
s_author_name VARCHAR(100) NOT NULL,
s_author_url VARCHAR(100) NOT NULL,
s_currency_format VARCHAR(50) NOT
NULL,
s_dec_point VARCHAR(2) NULL DEFAULT '.',
s_thousands_sep
VARCHAR(2) NULL DEFAULT '',
i_num_dec TINYINT(4) NULL DEFAULT 2,
s_date_format VARCHAR(20) NOT NULL,
s_stop_words TEXT NULL,
b_enabled TINYINT(1) NOT NULL DEFAULT 1,
b_enabled_bo TINYINT(1) NOT
NULL DEFAULT 1,
PRIMARY KEY (pk_c_code),
UNIQUE KEY
(s_short_name)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_country (
pk_c_code
CHAR(2) NOT NULL,
s_name VARCHAR(80) NOT NULL,
s_slug VARCHAR(80)
NOT NULL DEFAULT '',
PRIMARY KEY (pk_c_code),
INDEX
idx_s_slug (s_slug),
INDEX idx_s_name (s_name)
) ENGINE=InnoDB
DEFAULT CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_currency (
pk_c_code CHAR(3) NOT NULL,
s_name
VARCHAR(40) NOT NULL,
s_description VARCHAR(80) NULL,
b_enabled
TINYINT(1) NOT NULL DEFAULT 1,
PRIMARY KEY (pk_c_code),
UNIQUE KEY (s_name)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_region (
pk_i_id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
fk_c_country_code CHAR(2) NOT
NULL,
s_name VARCHAR(60) NOT NULL,
s_slug VARCHAR(60) NOT NULL
DEFAULT '',
b_active TINYINT(1) NOT NULL DEFAULT 1,
PRIMARY
KEY (pk_i_id),
INDEX (fk_c_country_code),
INDEX idx_s_name
(s_name),
INDEX idx_s_slug (s_slug),
FOREIGN KEY
(fk_c_country_code) REFERENCES /*TABLE_PREFIX*/t_country (pk_c_code)
)
ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_city (
pk_i_id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
fk_i_region_id INT(10)
UNSIGNED NOT NULL,
s_name VARCHAR(60) NOT NULL,
s_slug VARCHAR(60)
NOT NULL DEFAULT '',
fk_c_country_code CHAR(2) NULL,
b_active
TINYINT(1) NOT NULL DEFAULT 1,
PRIMARY KEY (pk_i_id),
INDEX (fk_i_region_id),
INDEX idx_s_name (s_name),
INDEX
idx_s_slug (s_slug),
FOREIGN KEY (fk_i_region_id) REFERENCES
/*TABLE_PREFIX*/t_region (pk_i_id),
FOREIGN KEY (fk_c_country_code)
REFERENCES /*TABLE_PREFIX*/t_country (pk_c_code)
) ENGINE=InnoDB DEFAULT
CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_city_area (
pk_i_id INT(10) UNSIGNED NOT NULL,
fk_i_city_id INT(10) UNSIGNED NOT NULL,
s_name VARCHAR(255) NOT NULL,
PRIMARY KEY (pk_i_id),
INDEX (fk_i_city_id),
INDEX
idx_s_name (s_name),
FOREIGN KEY (fk_i_city_id) REFERENCES
/*TABLE_PREFIX*/t_city (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET
'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_widget (
pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
s_description
VARCHAR(40) NOT NULL,
s_location VARCHAR(40) NOT NULL,
e_kind
ENUM('TEXT', 'HTML') NOT NULL,
s_content MEDIUMTEXT NOT NULL,
PRIMARY KEY (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_admin (
pk_i_id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
s_name VARCHAR(100) NOT
NULL,
s_username VARCHAR(40) NOT NULL,
s_password CHAR(60) NOT
NULL,
s_email VARCHAR(100) NULL,
s_secret VARCHAR(40) NULL,
b_moderator TINYINT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (pk_i_id),
UNIQUE KEY (s_username),
UNIQUE KEY (s_email)
)
ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_user (
pk_i_id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
dt_reg_date DATETIME NOT
NULL,
dt_mod_date DATETIME NULL,
s_name VARCHAR(100) NOT NULL,
s_username VARCHAR(100) NOT NULL,
s_password CHAR(60) NOT NULL,
s_secret VARCHAR(40) NULL,
s_email VARCHAR(100) NOT NULL,
s_website
VARCHAR(100) NULL,
s_phone_land VARCHAR(45),
s_phone_mobile
VARCHAR(45),
b_enabled TINYINT(1) NOT NULL DEFAULT 1,
b_active
TINYINT(1) NOT NULL DEFAULT 0,
s_pass_code VARCHAR(100) NULL ,
s_pass_date DATETIME NULL ,
s_pass_ip VARCHAR(15) NULL,
fk_c_country_code CHAR(2) NULL,
s_country VARCHAR(40) NULL,
s_address VARCHAR(100) NULL,
s_zip VARCHAR(15) NULL,
fk_i_region_id
INT(10) UNSIGNED NULL,
s_region VARCHAR(100),
fk_i_city_id INT(10)
UNSIGNED NULL,
s_city VARCHAR(100) NULL,
fk_i_city_area_id INT(10)
UNSIGNED NULL,
s_city_area VARCHAR(200) NULL,
d_coord_lat
DECIMAL(10,6),
d_coord_long DECIMAL(10,6),
b_company TINYINT(1) NOT
NULL DEFAULT 0,
i_items INT(10) UNSIGNED NULL DEFAULT 0,
i_comments
INT(10) UNSIGNED NULL DEFAULT 0,
dt_access_date DATETIME NOT NULL
DEFAULT '0000-00-00 00:00:00',
s_access_ip VARCHAR(15) NOT NULL
DEFAULT '',
PRIMARY KEY (pk_i_id),
UNIQUE KEY (s_email),
INDEX idx_s_name (s_name(6)),
INDEX idx_s_username
(s_username),
FOREIGN KEY (fk_c_country_code) REFERENCES
/*TABLE_PREFIX*/t_country (pk_c_code),
FOREIGN KEY (fk_i_region_id)
REFERENCES /*TABLE_PREFIX*/t_region (pk_i_id),
FOREIGN KEY
(fk_i_city_id) REFERENCES /*TABLE_PREFIX*/t_city (pk_i_id),
FOREIGN
KEY (fk_i_city_area_id) REFERENCES /*TABLE_PREFIX*/t_city_area (pk_i_id)
)
ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_user_description (
fk_i_user_id INT(10) UNSIGNED NOT NULL,
fk_c_locale_code CHAR(5) NOT
NULL,
s_info TEXT NULL,
PRIMARY KEY (fk_i_user_id,
fk_c_locale_code),
FOREIGN KEY (fk_i_user_id) REFERENCES
/*TABLE_PREFIX*/t_user (pk_i_id),
FOREIGN KEY (fk_c_locale_code)
REFERENCES /*TABLE_PREFIX*/t_locale (pk_c_code)
) ENGINE=InnoDB DEFAULT
CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_user_email_tmp (
fk_i_user_id INT(10) UNSIGNED NOT
NULL,
s_new_email VARCHAR(100) NOT NULL,
dt_date DATETIME NOT
NULL,
PRIMARY KEY (fk_i_user_id),
FOREIGN KEY
(fk_i_user_id) REFERENCES /*TABLE_PREFIX*/t_user (pk_i_id)
) ENGINE=InnoDB
DEFAULT CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_category (
pk_i_id INT(10) UNSIGNED NOT NULL
AUTO_INCREMENT,
fk_i_parent_id INT(10) UNSIGNED NULL,
i_expiration_days INT(3) UNSIGNED NOT NULL DEFAULT 0,
i_position INT(2)
UNSIGNED NOT NULL DEFAULT 0,
b_enabled TINYINT(1) NOT NULL DEFAULT 1,
b_price_enabled TINYINT(1) NOT NULL DEFAULT 1,
s_icon VARCHAR(250)
NULL,
PRIMARY KEY (pk_i_id),
INDEX (fk_i_parent_id),
INDEX (i_position),
FOREIGN KEY (fk_i_parent_id) REFERENCES
/*TABLE_PREFIX*/t_category (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET
'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_category_description (
fk_i_category_id INT(10)
UNSIGNED NOT NULL,
fk_c_locale_code CHAR(5) NOT NULL,
s_name
VARCHAR(100) NULL DEFAULT NULL,
s_description TEXT NULL,
s_slug
VARCHAR(100) NOT NULL,
PRIMARY KEY (fk_i_category_id,
fk_c_locale_code),
INDEX idx_s_slug (s_slug),
FOREIGN KEY
(fk_i_category_id) REFERENCES /*TABLE_PREFIX*/t_category (pk_i_id),
FOREIGN KEY (fk_c_locale_code) REFERENCES /*TABLE_PREFIX*/t_locale
(pk_c_code)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_category_stats (
fk_i_category_id INT(10) UNSIGNED NOT NULL,
i_num_items INT(10)
UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (fk_i_category_id),
FOREIGN KEY (fk_i_category_id) REFERENCES /*TABLE_PREFIX*/t_category
(pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_item (
pk_i_id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
fk_i_user_id INT(10) UNSIGNED
NULL,
fk_i_category_id INT(10) UNSIGNED NOT NULL,
dt_pub_date
DATETIME NOT NULL,
dt_mod_date DATETIME NULL,
f_price FLOAT NULL,
i_price BIGINT(20) NULL,
fk_c_currency_code CHAR(3) NULL,
s_contact_name VARCHAR(100) NULL,
s_contact_email VARCHAR(140) NOT
NULL,
s_ip VARCHAR(64) NOT NULL DEFAULT '',
b_premium TINYINT(1)
NOT NULL DEFAULT 0,
b_enabled TINYINT(1) NOT NULL DEFAULT 1,
b_active TINYINT(1) NOT NULL DEFAULT 0,
b_spam TINYINT(1) NOT NULL
DEFAULT 0,
s_secret VARCHAR(40) NULL,
b_show_email TINYINT(1)
NULL,
dt_expiration datetime NOT NULL DEFAULT '9999-12-31 23:59:59',
PRIMARY KEY (pk_i_id),
FOREIGN KEY (fk_i_user_id) REFERENCES
/*TABLE_PREFIX*/t_user (pk_i_id),
FOREIGN KEY (fk_i_category_id)
REFERENCES /*TABLE_PREFIX*/t_category (pk_i_id),
FOREIGN KEY
(fk_c_currency_code) REFERENCES /*TABLE_PREFIX*/t_currency (pk_c_code),
INDEX (fk_i_user_id),
INDEX idx_b_premium (b_premium),
INDEX idx_s_contact_email (s_contact_email(10)),
INDEX
(fk_i_category_id),
INDEX (fk_c_currency_code),
INDEX
idx_pub_date (dt_pub_date),
INDEX idx_price (i_price)
)
ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_item_description (
fk_i_item_id INT(10) UNSIGNED NOT NULL,
fk_c_locale_code CHAR(5) NOT
NULL,
s_title VARCHAR(100) NOT NULL,
s_description MEDIUMTEXT NOT
NULL,
PRIMARY KEY (fk_i_item_id, fk_c_locale_code),
FULLTEXT s_description (s_description, s_title)
) ENGINE=MyISAM DEFAULT
CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_item_location (
fk_i_item_id INT(10) UNSIGNED NOT
NULL,
fk_c_country_code CHAR(2) NULL,
s_country VARCHAR(40) NULL,
s_address VARCHAR(100) NULL,
s_zip VARCHAR(15) NULL,
fk_i_region_id INT(10) UNSIGNED NULL,
s_region VARCHAR(100),
fk_i_city_id INT(10) UNSIGNED NULL,
s_city VARCHAR(100) NULL,
fk_i_city_area_id INT(10) UNSIGNED NULL,
s_city_area VARCHAR(200)
NULL,
d_coord_lat DECIMAL(10,6),
d_coord_long DECIMAL(10,6),
PRIMARY KEY (fk_i_item_id),
FOREIGN KEY (fk_i_item_id) REFERENCES
/*TABLE_PREFIX*/t_item (pk_i_id),
FOREIGN KEY (fk_c_country_code)
REFERENCES /*TABLE_PREFIX*/t_country (pk_c_code),
FOREIGN KEY
(fk_i_region_id) REFERENCES /*TABLE_PREFIX*/t_region (pk_i_id),
FOREIGN KEY (fk_i_city_id) REFERENCES /*TABLE_PREFIX*/t_city (pk_i_id),
FOREIGN KEY (fk_i_city_area_id) REFERENCES /*TABLE_PREFIX*/t_city_area
(pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_item_stats (
fk_i_item_id INT(10) UNSIGNED NOT NULL,
i_num_views INT(10) UNSIGNED
NOT NULL DEFAULT 0,
i_num_spam INT(10) UNSIGNED NOT NULL DEFAULT 0,
i_num_repeated INT(10) UNSIGNED NOT NULL DEFAULT 0,
i_num_bad_classified INT(10) UNSIGNED NOT NULL DEFAULT 0,
i_num_offensive INT(10) UNSIGNED NOT NULL DEFAULT 0,
i_num_expired
INT(10) UNSIGNED NOT NULL DEFAULT 0,
i_num_premium_views INT(10)
UNSIGNED NOT NULL DEFAULT 0,
dt_date DATE NOT NULL,
PRIMARY
KEY (fk_i_item_id, dt_date),
INDEX (dt_date, fk_i_item_id),
FOREIGN KEY (fk_i_item_id) REFERENCES /*TABLE_PREFIX*/t_item (pk_i_id)
)
ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_item_resource (
pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
fk_i_item_id INT(10)
UNSIGNED NOT NULL,
s_name VARCHAR(60) NULL,
s_extension VARCHAR(10)
NULL,
s_content_type VARCHAR(40) NULL,
s_path VARCHAR(250) NULL,
PRIMARY KEY (pk_i_id),
INDEX (fk_i_item_id),
INDEX
idx_s_content_type (pk_i_id,s_content_type(10)),
FOREIGN KEY
(fk_i_item_id) REFERENCES /*TABLE_PREFIX*/t_item (pk_i_id)
) ENGINE=InnoDB
DEFAULT CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_item_comment (
pk_i_id INT(10) UNSIGNED NOT NULL
AUTO_INCREMENT,
fk_i_item_id INT(10) UNSIGNED NOT NULL,
dt_pub_date
DATETIME NOT NULL,
s_title VARCHAR(200) NOT NULL,
s_author_name
VARCHAR(100) NOT NULL,
s_author_email VARCHAR(100) NOT NULL,
s_body
TEXT NOT NULL,
b_enabled TINYINT(1) NOT NULL DEFAULT 1,
b_active
TINYINT(1) NOT NULL DEFAULT 0,
b_spam TINYINT(1) NOT NULL DEFAULT 0,
fk_i_user_id INT(10) UNSIGNED NULL,
PRIMARY KEY (pk_i_id),
INDEX (fk_i_item_id),
FOREIGN KEY (fk_i_item_id) REFERENCES
/*TABLE_PREFIX*/t_item (pk_i_id),
FOREIGN KEY (fk_i_user_id)
REFERENCES /*TABLE_PREFIX*/t_user (pk_i_id)
) ENGINE=InnoDB DEFAULT
CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_preference (
s_section VARCHAR(40) NOT NULL,
s_name VARCHAR(40) NOT NULL,
s_value LONGTEXT NOT NULL,
e_type
ENUM('STRING', 'INTEGER', 'BOOLEAN') NOT NULL,
UNIQUE KEY
(s_section, s_name)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_pages (
pk_i_id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
s_internal_name VARCHAR(50)
NULL,
b_indelible TINYINT(1) NOT NULL DEFAULT 0,
b_link TINYINT(1)
NOT NULL DEFAULT 1,
dt_pub_date DATETIME NOT NULL,
dt_mod_date
DATETIME NULL,
i_order INT(3) NOT NULL DEFAULT 0,
s_meta TEXT
NULL,
PRIMARY KEY (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET
'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_pages_description (
fk_i_pages_id INT(10) UNSIGNED
NOT NULL,
fk_c_locale_code CHAR(5) NOT NULL,
s_title VARCHAR(255)
NOT NULL,
s_text TEXT,
PRIMARY KEY (fk_i_pages_id,
fk_c_locale_code),
FOREIGN KEY (fk_i_pages_id) REFERENCES
/*TABLE_PREFIX*/t_pages (pk_i_id),
FOREIGN KEY (fk_c_locale_code)
REFERENCES /*TABLE_PREFIX*/t_locale (pk_c_code)
) ENGINE=InnoDB DEFAULT
CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_plugin_category (
s_plugin_name VARCHAR(40) NOT
NULL,
fk_i_category_id INT(10) UNSIGNED NOT NULL,
INDEX
(fk_i_category_id),
FOREIGN KEY (fk_i_category_id) REFERENCES
/*TABLE_PREFIX*/t_category (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET
'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_cron (
e_type enum('INSTANT','HOURLY','DAILY','WEEKLY','CUSTOM') NOT NULL,
d_last_exec DATETIME NOT NULL,
d_next_exec DATETIME NOT NULL
)
ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_alerts (
pk_i_id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
s_email VARCHAR(100) DEFAULT
NULL,
fk_i_user_id INT(10) UNSIGNED DEFAULT NULL,
s_search
LONGTEXT,
s_secret VARCHAR(40) NULL,
b_active TINYINT(1) NOT NULL
DEFAULT 0,
e_type enum('INSTANT','HOURLY','DAILY','WEEKLY','CUSTOM')
NOT NULL,
dt_date DATETIME NULL,
dt_unsub_date DATETIME NULL
DEFAULT NULL,
PRIMARY KEY (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER
SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_alerts_sent (
d_date DATE NOT NULL,
i_num_alerts_sent INT(10) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY
(d_date)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_keywords (
s_md5
VARCHAR(32) NOT NULL,
fk_c_locale_code CHAR(5) NOT NULL,
s_original_text VARCHAR(255) NOT NULL,
s_anchor_text VARCHAR(255) NOT
NULL,
s_normalized_text VARCHAR(255) NOT NULL,
fk_i_category_id
INT(10) UNSIGNED NULL,
fk_i_city_id INT(10) UNSIGNED NULL,
PRIMARY KEY (s_md5, fk_c_locale_code),
INDEX (fk_i_category_id),
INDEX (fk_i_city_id),
FOREIGN KEY (fk_i_category_id)
REFERENCES /*TABLE_PREFIX*/t_category (pk_i_id),
FOREIGN KEY
(fk_i_city_id) REFERENCES /*TABLE_PREFIX*/t_city (pk_i_id),
FOREIGN
KEY (fk_c_locale_code) REFERENCES /*TABLE_PREFIX*/t_locale (pk_c_code)
)
ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_latest_searches (
d_date DATETIME NOT NULL,
s_search VARCHAR(255) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_meta_fields (
pk_i_id INT(10) UNSIGNED NOT NULL
AUTO_INCREMENT,
s_name VARCHAR(255) NOT NULL,
s_slug VARCHAR(255)
NOT NULL,
e_type
ENUM('TEXT','TEXTAREA','DROPDOWN','RADIO','CHECKBOX','URL', 'DATE',
'DATEINTERVAL') NOT NULL DEFAULT 'TEXT',
s_options VARCHAR(2048)
NULL,
b_required TINYINT(1) NOT NULL DEFAULT 0,
b_searchable
TINYINT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (pk_i_id)
)
ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_meta_categories (
fk_i_category_id INT(10) UNSIGNED NOT NULL,
fk_i_field_id INT(10)
UNSIGNED NOT NULL,
PRIMARY KEY (fk_i_category_id, fk_i_field_id),
FOREIGN KEY (fk_i_category_id) REFERENCES /*TABLE_PREFIX*/t_category
(pk_i_id),
FOREIGN KEY (fk_i_field_id) REFERENCES
/*TABLE_PREFIX*/t_meta_fields (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER
SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_item_meta (
fk_i_item_id INT(10) UNSIGNED NOT NULL,
fk_i_field_id INT(10) UNSIGNED NOT NULL,
s_value TEXT NULL,
s_multi VARCHAR(20) NOT NULL DEFAULT '',
PRIMARY KEY
(fk_i_item_id, fk_i_field_id, s_multi),
INDEX s_value
(s_value(255)),
FOREIGN KEY (fk_i_item_id) REFERENCES
/*TABLE_PREFIX*/t_item (pk_i_id),
FOREIGN KEY (fk_i_field_id)
REFERENCES /*TABLE_PREFIX*/t_meta_fields (pk_i_id)
) ENGINE=InnoDB DEFAULT
CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_log (
dt_date DATETIME NOT NULL,
s_section
VARCHAR(50) NOT NULL,
s_action VARCHAR(50) NOT NULL,
fk_i_id
INT(10) UNSIGNED NOT NULL,
s_data VARCHAR(250) NOT NULL,
s_ip
VARCHAR(50) NOT NULL,
s_who VARCHAR(50) NOT NULL,
fk_i_who_id
INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8'
COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_city_stats (
fk_i_city_id INT(10) UNSIGNED NOT NULL,
i_num_items INT(10) UNSIGNED
NOT NULL DEFAULT 0,
PRIMARY KEY (fk_i_city_id),
INDEX
idx_num_items (i_num_items),
FOREIGN KEY (fk_i_city_id) REFERENCES
/*TABLE_PREFIX*/t_city (pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET
'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_region_stats (
fk_i_region_id INT(10) UNSIGNED NOT
NULL,
i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY
KEY (fk_i_region_id),
INDEX idx_num_items (i_num_items),
FOREIGN KEY (fk_i_region_id) REFERENCES /*TABLE_PREFIX*/t_region
(pk_i_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_country_stats (
fk_c_country_code CHAR(2) NOT NULL,
i_num_items INT(10) UNSIGNED NOT
NULL DEFAULT 0,
PRIMARY KEY (fk_c_country_code),
INDEX
idx_num_items (i_num_items),
FOREIGN KEY (fk_c_country_code)
REFERENCES /*TABLE_PREFIX*/t_country (pk_c_code)
) ENGINE=InnoDB DEFAULT
CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';
CREATE TABLE
/*TABLE_PREFIX*/t_locations_tmp (
id_location varchar(10) NOT NULL,
e_type enum('COUNTRY','REGION','CITY') NOT NULL,
PRIMARY KEY
(id_location, e_type)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE
'UTF8_GENERAL_CI';
CREATE TABLE /*TABLE_PREFIX*/t_ban_rule (
pk_i_id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
s_name VARCHAR(250) NOT NULL
DEFAULT '',
s_ip VARCHAR(50) NOT NULL DEFAULT '',
s_email VARCHAR(250)
NOT NULL DEFAULT '',
PRIMARY KEY (pk_i_id)
) ENGINE=InnoDB DEFAULT
CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';