/****************************************************************************
* SQL создания базы данных системы Корпорация 2
* Кодировка базы данных UTF8
*****************************************************************************/

/*** ВНИМАНИЕ! НУЖНО ПОЗАМЕНЯТЬ НА INNODB ? */

CREATE TABLE `wa_contact` (
  `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(150) COLLATE utf8_general_ci NOT NULL,
  `firstname` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `middlename` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `lastname` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `title` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `company` VARCHAR(150) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `jobtitle` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `company_contact_id` INTEGER(11) NOT NULL DEFAULT 0,
  `is_company` TINYINT(1) NOT NULL DEFAULT 0,
  `is_user` TINYINT(1) NOT NULL DEFAULT 0,
  `login` VARCHAR(32) COLLATE utf8_general_ci DEFAULT NULL,
  `password` VARCHAR(128) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `last_datetime` DATETIME DEFAULT NULL,
  `sex` ENUM('m','f') COLLATE utf8_general_ci DEFAULT NULL,
  `birth_day` TINYINT(2) UNSIGNED DEFAULT NULL,
  `birth_month` TINYINT(2) UNSIGNED DEFAULT NULL,
  `birth_year` SMALLINT(4) DEFAULT NULL,
  `about` TEXT COLLATE utf8_general_ci,
  `photo` INTEGER(10) UNSIGNED NOT NULL DEFAULT 0,
  `create_datetime` DATETIME NOT NULL,
  `create_app_id` VARCHAR(32) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `create_method` VARCHAR(32) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `create_contact_id` INTEGER(11) NOT NULL DEFAULT 0,
  `locale` VARCHAR(8) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `timezone` VARCHAR(64) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `login` (`login`) USING BTREE,
  KEY `name` (`name`) USING BTREE,
  KEY `id_name` (`id`, `name`) USING BTREE
) ENGINE=InnoDB
AUTO_INCREMENT=22 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;

CREATE TABLE `wa_contact_categories` (
  `category_id` INTEGER(11) NOT NULL,
  `contact_id` INTEGER(11) NOT NULL,
  PRIMARY KEY (`category_id`, `contact_id`) USING BTREE,
  KEY `contact_id` (`contact_id`) USING BTREE
) ENGINE=InnoDB
ROW_FORMAT=FIXED CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;


CREATE TABLE `wa_contact_category` (
  `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) COLLATE utf8_general_ci NOT NULL,
  `system_id` VARCHAR(64) COLLATE utf8_general_ci DEFAULT NULL,
  `app_id` VARCHAR(32) COLLATE utf8_general_ci DEFAULT NULL,
  `icon` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `cnt` INTEGER(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `system_id` (`system_id`) USING BTREE
) ENGINE=InnoDB
AUTO_INCREMENT=2 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;

CREATE TABLE `wa_contact_data` (
  `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `contact_id` INTEGER(11) NOT NULL,
  `field` VARCHAR(32) COLLATE utf8_general_ci NOT NULL,
  `ext` VARCHAR(32) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `value` VARCHAR(255) COLLATE utf8_general_ci NOT NULL,
  `sort` INTEGER(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `contact_field_sort` (`contact_id`, `field`, `sort`) USING BTREE,
  KEY `contact_id` (`contact_id`) USING BTREE,
  KEY `value` (`value`) USING BTREE,
  KEY `field` (`field`) USING BTREE
) ENGINE=InnoDB
AUTO_INCREMENT=131 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;

CREATE TABLE `wa_contact_emails` (
  `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `contact_id` INTEGER(11) NOT NULL,
  `email` VARCHAR(255) COLLATE utf8_general_ci NOT NULL,
  `ext` VARCHAR(32) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `sort` INTEGER(11) NOT NULL DEFAULT 0,
  `status` ENUM('unknown','confirmed','unconfirmed','unavailable') COLLATE utf8_general_ci NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `contact_sort` (`contact_id`, `sort`) USING BTREE,
  KEY `email` (`email`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB
AUTO_INCREMENT=21 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;


CREATE TABLE `wa_contact_rights` (
  `group_id` INTEGER(11) NOT NULL,
  `app_id` VARCHAR(32) COLLATE utf8_general_ci NOT NULL,
  `name` VARCHAR(64) COLLATE utf8_general_ci NOT NULL,
  `value` INTEGER(11) NOT NULL,
  PRIMARY KEY (`group_id`, `app_id`, `name`) USING BTREE,
  KEY `name_value` (`name`, `value`, `group_id`, `app_id`) USING BTREE
) ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;

CREATE TABLE `wa_contact_settings` (
  `contact_id` INTEGER(11) NOT NULL,
  `app_id` VARCHAR(32) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `name` VARCHAR(32) COLLATE utf8_general_ci NOT NULL,
  `value` TEXT COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`contact_id`, `app_id`, `name`) USING BTREE
) ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;

CREATE TABLE `wa_country` (
  `name` VARCHAR(255) COLLATE utf8_general_ci NOT NULL,
  `iso3letter` VARCHAR(3) COLLATE utf8_general_ci NOT NULL,
  `iso2letter` VARCHAR(2) COLLATE utf8_general_ci NOT NULL,
  `isonumeric` VARCHAR(3) COLLATE utf8_general_ci NOT NULL,
  `fav_sort` INTEGER(11) DEFAULT NULL,
  PRIMARY KEY (`iso3letter`) USING BTREE,
  UNIQUE KEY `isonumeric` (`isonumeric`) USING BTREE,
  UNIQUE KEY `iso2letter` (`iso2letter`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;

INSERT INTO `wa_country` (`name`, `iso3letter`, `iso2letter`, `isonumeric`, `fav_sort`) VALUES
('Afghanistan', 'afg', 'af', '004', NULL),
('Åland Islands', 'ala', 'ax', '248', NULL),
('Albania', 'alb', 'al', '008', NULL),
('Algeria', 'dza', 'dz', '012', NULL),
('American Samoa', 'asm', 'as', '016', NULL),
('Andorra', 'and', 'ad', '020', NULL),
('Angola', 'ago', 'ao', '024', NULL),
('Anguilla', 'aia', 'ai', '660', NULL),
('Antigua and Barbuda', 'atg', 'ag', '028', NULL),
('Argentina', 'arg', 'ar', '032', NULL),
('Armenia', 'arm', 'am', '051', NULL),
('Aruba', 'abw', 'aw', '533', NULL),
('Australia', 'aus', 'au', '036', NULL),
('Austria', 'aut', 'at', '040', NULL),
('Azerbaijan', 'aze', 'az', '031', NULL),
('Bahamas', 'bhs', 'bs', '044', NULL),
('Bahrain', 'bhr', 'bh', '048', NULL),
('Bangladesh', 'bgd', 'bd', '050', NULL),
('Barbados', 'brb', 'bb', '052', NULL),
('Belarus', 'blr', 'by', '112', NULL),
('Belgium', 'bel', 'be', '056', NULL),
('Belize', 'blz', 'bz', '084', NULL),
('Benin', 'ben', 'bj', '204', NULL),
('Bermuda', 'bmu', 'bm', '060', NULL),
('Bhutan', 'btn', 'bt', '064', NULL),
('Bolivia, Plurinational State of', 'bol', 'bo', '068', NULL),
('Bosnia and Herzegovina', 'bih', 'ba', '070', NULL),
('Botswana', 'bwa', 'bw', '072', NULL),
('Bouvet Island', 'bvt', 'bv', '074', NULL),
('Brazil', 'bra', 'br', '076', NULL),
('British Indian Ocean Territory', 'iot', 'io', '086', NULL),
('Brunei Darussalam', 'brn', 'bn', '096', NULL),
('Bulgaria', 'bgr', 'bg', '100', NULL),
('Burkina Faso', 'bfa', 'bf', '854', NULL),
('Burundi', 'bdi', 'bi', '108', NULL),
('Côte d''Ivoire', 'civ', 'ci', '384', NULL),
('Cambodia', 'khm', 'kh', '116', NULL),
('Cameroon', 'cmr', 'cm', '120', NULL),
('Canada', 'can', 'ca', '124', NULL),
('Cape Verde', 'cpv', 'cv', '132', NULL),
('Cayman Islands', 'cym', 'ky', '136', NULL),
('Central African Republic', 'caf', 'cf', '140', NULL),
('Chad', 'tcd', 'td', '148', NULL),
('Chile', 'chl', 'cl', '152', NULL),
('China', 'chn', 'cn', '156', NULL),
('Christmas Island', 'cxr', 'cx', '162', NULL),
('Cocos (Keeling) Islands', 'cck', 'cc', '166', NULL),
('Colombia', 'col', 'co', '170', NULL),
('Comoros', 'com', 'km', '174', NULL),
('Congo', 'cog', 'cg', '178', NULL),
('Congo, the Democratic Republic of the', 'cod', 'cd', '180', NULL),
('Cook Islands', 'cok', 'ck', '184', NULL),
('Costa Rica', 'cri', 'cr', '188', NULL),
('Croatia', 'hrv', 'hr', '191', NULL),
('Cuba', 'cub', 'cu', '192', NULL),
('Cyprus', 'cyp', 'cy', '196', NULL),
('Czech Republic', 'cze', 'cz', '203', NULL),
('Denmark', 'dnk', 'dk', '208', NULL),
('Djibouti', 'dji', 'dj', '262', NULL),
('Dominica', 'dma', 'dm', '212', NULL),
('Dominican Republic', 'dom', 'do', '214', NULL),
('Ecuador', 'ecu', 'ec', '218', NULL),
('Egypt', 'egy', 'eg', '818', NULL),
('El Salvador', 'slv', 'sv', '222', NULL),
('Equatorial Guinea', 'gnq', 'gq', '226', NULL),
('Eritrea', 'eri', 'er', '232', NULL),
('Estonia', 'est', 'ee', '233', NULL),
('Ethiopia', 'eth', 'et', '231', NULL),
('Falkland Islands (Malvinas)', 'flk', 'fk', '238', NULL),
('Faroe Islands', 'fro', 'fo', '234', NULL),
('Fiji', 'fji', 'fj', '242', NULL),
('Finland', 'fin', 'fi', '246', NULL),
('France', 'fra', 'fr', '250', NULL),
('French Guiana', 'guf', 'gf', '254', NULL),
('French Polynesia', 'pyf', 'pf', '258', NULL),
('French Southern Territories', 'atf', 'tf', '260', NULL),
('Gabon', 'gab', 'ga', '266', NULL),
('Gambia', 'gmb', 'gm', '270', NULL),
('Georgia', 'geo', 'ge', '268', NULL),
('Germany', 'deu', 'de', '276', NULL),
('Ghana', 'gha', 'gh', '288', NULL),
('Gibraltar', 'gib', 'gi', '292', NULL),
('Greece', 'grc', 'gr', '300', NULL),
('Greenland', 'grl', 'gl', '304', NULL),
('Grenada', 'grd', 'gd', '308', NULL),
('Guadeloupe', 'glp', 'gp', '312', NULL),
('Guam', 'gum', 'gu', '316', NULL),
('Guatemala', 'gtm', 'gt', '320', NULL),
('Guinea', 'gin', 'gn', '324', NULL),
('Guinea-Bissau', 'gnb', 'gw', '624', NULL),
('Guyana', 'guy', 'gy', '328', NULL),
('Haiti', 'hti', 'ht', '332', NULL),
('Heard Island and McDonald Islands', 'hmd', 'hm', '334', NULL),
('Holy See (Vatican City State)', 'vat', 'va', '336', NULL),
('Honduras', 'hnd', 'hn', '340', NULL),
('Hong Kong', 'hkg', 'hk', '344', NULL),
('Hungary', 'hun', 'hu', '348', NULL),
('Iceland', 'isl', 'is', '352', NULL),
('India', 'ind', 'in', '356', NULL),
('Indonesia', 'idn', 'id', '360', NULL),
('Iran, Islamic Republic of', 'irn', 'ir', '364', NULL),
('Iraq', 'irq', 'iq', '368', NULL),
('Ireland', 'irl', 'ie', '372', NULL),
('Israel', 'isr', 'il', '376', NULL),
('Italy', 'ita', 'it', '380', NULL),
('Jamaica', 'jam', 'jm', '388', NULL),
('Japan', 'jpn', 'jp', '392', NULL),
('Jordan', 'jor', 'jo', '400', NULL),
('Kazakhstan', 'kaz', 'kz', '398', NULL),
('Kenya', 'ken', 'ke', '404', NULL),
('Kiribati', 'kir', 'ki', '296', NULL),
('Korea, Democratic People''s Republic of', 'prk', 'kp', '408', NULL),
('Korea, Republic of', 'kor', 'kr', '410', NULL),
('Kuwait', 'kwt', 'kw', '414', NULL),
('Kyrgyzstan', 'kgz', 'kg', '417', NULL),
('Lao People''s Democratic Republic', 'lao', 'la', '418', NULL),
('Latvia', 'lva', 'lv', '428', NULL),
('Lebanon', 'lbn', 'lb', '422', NULL),
('Lesotho', 'lso', 'ls', '426', NULL),
('Liberia', 'lbr', 'lr', '430', NULL),
('Libyan Arab Jamahiriya', 'lby', 'ly', '434', NULL),
('Liechtenstein', 'lie', 'li', '438', NULL),
('Lithuania', 'ltu', 'lt', '440', NULL),
('Luxembourg', 'lux', 'lu', '442', NULL),
('Macao', 'mac', 'mo', '446', NULL),
('Macedonia, the former Yugoslav Republic of', 'mkd', 'mk', '807', NULL),
('Madagascar', 'mdg', 'mg', '450', NULL),
('Malawi', 'mwi', 'mw', '454', NULL),
('Malaysia', 'mys', 'my', '458', NULL),
('Maldives', 'mdv', 'mv', '462', NULL),
('Mali', 'mli', 'ml', '466', NULL),
('Malta', 'mlt', 'mt', '470', NULL),
('Marshall Islands', 'mhl', 'mh', '584', NULL),
('Martinique', 'mtq', 'mq', '474', NULL),
('Mauritania', 'mrt', 'mr', '478', NULL),
('Mauritius', 'mus', 'mu', '480', NULL),
('Mayotte', 'myt', 'yt', '175', NULL),
('Mexico', 'mex', 'mx', '484', NULL),
('Micronesia, Federated States of', 'fsm', 'fm', '583', NULL),
('Moldova, Republic of', 'mda', 'md', '498', NULL),
('Monaco', 'mco', 'mc', '492', NULL),
('Mongolia', 'mng', 'mn', '496', NULL),
('Montenegro', 'mne', 'me', '499', NULL),
('Montserrat', 'msr', 'ms', '500', NULL),
('Morocco', 'mar', 'ma', '504', NULL),
('Mozambique', 'moz', 'mz', '508', NULL),
('Myanmar', 'mmr', 'mm', '104', NULL),
('Namibia', 'nam', 'na', '516', NULL),
('Nauru', 'nru', 'nr', '520', NULL),
('Nepal', 'npl', 'np', '524', NULL),
('Netherlands', 'nld', 'nl', '528', NULL),
('Netherlands Antilles', 'ant', 'an', '530', NULL),
('New Caledonia', 'ncl', 'nc', '540', NULL),
('New Zealand', 'nzl', 'nz', '554', NULL),
('Nicaragua', 'nic', 'ni', '558', NULL),
('Niger', 'ner', 'ne', '562', NULL),
('Nigeria', 'nga', 'ng', '566', NULL),
('Niue', 'niu', 'nu', '570', NULL),
('Norfolk Island', 'nfk', 'nf', '574', NULL),
('Northern Mariana Islands', 'mnp', 'mp', '580', NULL),
('Norway', 'nor', 'no', '578', NULL),
('Oman', 'omn', 'om', '512', NULL),
('Pakistan', 'pak', 'pk', '586', NULL),
('Palau', 'plw', 'pw', '585', NULL),
('Palestinian Territory, Occupied', 'pse', 'ps', '275', NULL),
('Panama', 'pan', 'pa', '591', NULL),
('Papua New Guinea', 'png', 'pg', '598', NULL),
('Paraguay', 'pry', 'py', '600', NULL),
('Peru', 'per', 'pe', '604', NULL),
('Philippines', 'phl', 'ph', '608', NULL),
('Pitcairn', 'pcn', 'pn', '612', NULL),
('Poland', 'pol', 'pl', '616', NULL),
('Portugal', 'prt', 'pt', '620', NULL),
('Puerto Rico', 'pri', 'pr', '630', NULL),
('Qatar', 'qat', 'qa', '634', NULL),
('Réunion', 'reu', 're', '638', NULL),
('Romania', 'rou', 'ro', '642', NULL),
('Russian Federation', 'rus', 'ru', '643', NULL),
('Rwanda', 'rwa', 'rw', '646', NULL),
('Saint Helena, Ascension and Tristan da Cunha', 'shn', 'sh', '654', NULL),
('Saint Kitts and Nevis', 'kna', 'kn', '659', NULL),
('Saint Lucia', 'lca', 'lc', '662', NULL),
('Saint Pierre and Miquelon', 'spm', 'pm', '666', NULL),
('Saint Vincent and the Grenadines', 'vct', 'vc', '670', NULL),
('Samoa', 'wsm', 'ws', '882', NULL),
('San Marino', 'smr', 'sm', '674', NULL),
('Sao Tome and Principe', 'stp', 'st', '678', NULL),
('Saudi Arabia', 'sau', 'sa', '682', NULL),
('Senegal', 'sen', 'sn', '686', NULL),
('Serbia', 'srb', 'rs', '688', NULL),
('Seychelles', 'syc', 'sc', '690', NULL),
('Sierra Leone', 'sle', 'sl', '694', NULL),
('Singapore', 'sgp', 'sg', '702', NULL),
('Slovakia', 'svk', 'sk', '703', NULL),
('Slovenia', 'svn', 'si', '705', NULL),
('Solomon Islands', 'slb', 'sb', '090', NULL),
('Somalia', 'som', 'so', '706', NULL),
('South Africa', 'zaf', 'za', '710', NULL),
('South Georgia and the South Sandwich Islands', 'sgs', 'gs', '239', NULL),
('Spain', 'esp', 'es', '724', NULL),
('Sri Lanka', 'lka', 'lk', '144', NULL),
('Sudan', 'sdn', 'sd', '736', NULL),
('Suriname', 'sur', 'sr', '740', NULL),
('Svalbard and Jan Mayen', 'sjm', 'sj', '744', NULL),
('Swaziland', 'swz', 'sz', '748', NULL),
('Sweden', 'swe', 'se', '752', NULL),
('Switzerland', 'che', 'ch', '756', NULL),
('Syrian Arab Republic', 'syr', 'sy', '760', NULL),
('Taiwan, Province of China', 'twn', 'tw', '158', NULL),
('Tajikistan', 'tjk', 'tj', '762', NULL),
('Tanzania, United Republic of', 'tza', 'tz', '834', NULL),
('Thailand', 'tha', 'th', '764', NULL),
('Timor-Leste', 'tls', 'tl', '626', NULL),
('Togo', 'tgo', 'tg', '768', NULL),
('Tokelau', 'tkl', 'tk', '772', NULL),
('Tonga', 'ton', 'to', '776', NULL),
('Trinidad and Tobago', 'tto', 'tt', '780', NULL),
('Tunisia', 'tun', 'tn', '788', NULL),
('Turkey', 'tur', 'tr', '792', NULL),
('Turkmenistan', 'tkm', 'tm', '795', NULL),
('Turks and Caicos Islands', 'tca', 'tc', '796', NULL),
('Tuvalu', 'tuv', 'tv', '798', NULL),
('Uganda', 'uga', 'ug', '800', NULL),
('Ukraine', 'ukr', 'ua', '804', 1),
('United Arab Emirates', 'are', 'ae', '784', NULL),
('United Kingdom', 'gbr', 'gb', '826', NULL),
('United States', 'usa', 'us', '840', NULL),
('United States Minor Outlying Islands', 'umi', 'um', '581', NULL),
('Uruguay', 'ury', 'uy', '858', NULL),
('Uzbekistan', 'uzb', 'uz', '860', NULL),
('Vanuatu', 'vut', 'vu', '548', NULL),
('Venezuela, Bolivarian Republic of', 'ven', 've', '862', NULL),
('Viet Nam', 'vnm', 'vn', '704', NULL),
('Virgin Islands, British', 'vgb', 'vg', '092', NULL),
('Virgin Islands, U.S.', 'vir', 'vi', '850', NULL),
('Wallis and Futuna', 'wlf', 'wf', '876', NULL),
('Western Sahara', 'esh', 'eh', '732', NULL),
('Yemen', 'yem', 'ye', '887', NULL),
('Zambia', 'zmb', 'zm', '894', NULL),
('Zimbabwe', 'zwe', 'zw', '716', NULL);


ALTER TABLE `wa_country`
  ADD PRIMARY KEY (`iso3letter`),
  ADD UNIQUE KEY `isonumeric` (`isonumeric`),
  ADD UNIQUE KEY `iso2letter` (`iso2letter`),
  ADD KEY `name` (`name`);


CREATE TABLE `wa_log` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `app_id` VARCHAR(32) COLLATE utf8_general_ci NOT NULL,
  `contact_id` INTEGER(11) NOT NULL,
  `datetime` DATETIME NOT NULL,
  `action` VARCHAR(255) COLLATE utf8_general_ci NOT NULL,
  `subject_contact_id` INTEGER(11) DEFAULT NULL,
  `params` TEXT COLLATE utf8_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB
AUTO_INCREMENT=4874 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;

CREATE TABLE `wa_login_log` (
  `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `contact_id` INTEGER(11) NOT NULL,
  `datetime_in` DATETIME NOT NULL,
  `datetime_out` DATETIME DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB
AUTO_INCREMENT=463 ROW_FORMAT=FIXED CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;


CREATE TABLE IF NOT EXISTS `wa_region` (
  `country_iso3` varchar(3) NOT NULL,
  `code` varchar(8) NOT NULL,
  `name` varchar(255) NOT NULL,
  `fav_sort` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `wa_region` (`country_iso3`, `code`, `name`, `fav_sort`) VALUES
('usa', 'AK', 'Alaska', NULL),
('usa', 'AL', 'Alabama', NULL),
('usa', 'AR', 'Arkansas', NULL),
('usa', 'AZ', 'Arizona', NULL),
('usa', 'CA', 'California', NULL),
('usa', 'CO', 'Colorado', NULL),
('usa', 'CT', 'Connecticut', NULL),
('usa', 'DC', 'Washington, D.C.', NULL),
('usa', 'DE', 'Delaware', NULL),
('usa', 'FL', 'Florida', NULL),
('usa', 'GA', 'Georgia', NULL),
('usa', 'HI', 'Hawaii', NULL),
('usa', 'IA', 'Iowa', NULL),
('usa', 'ID', 'Idaho', NULL),
('usa', 'IL', 'Illinois', NULL),
('usa', 'IN', 'Indiana', NULL),
('usa', 'KS', 'Kansas', NULL),
('usa', 'KY', 'Kentucky', NULL),
('usa', 'LA', 'Louisiana', NULL),
('usa', 'MA', 'Massachusetts', NULL),
('usa', 'MD', 'Maryland', NULL),
('usa', 'ME', 'Maine', NULL),
('usa', 'MI', 'Michigan', NULL),
('usa', 'MN', 'Minnesota', NULL),
('usa', 'MO', 'Missouri', NULL),
('usa', 'MS', 'Mississippi', NULL),
('usa', 'MT', 'Montana', NULL),
('usa', 'NC', 'North Carolina', NULL),
('usa', 'ND', 'North Dakota', NULL),
('usa', 'NE', 'Nebraska', NULL),
('usa', 'NH', 'New Hampshire', NULL),
('usa', 'NJ', 'New Jersey', NULL),
('usa', 'NM', 'New Mexico', NULL),
('usa', 'NV', 'Nevada', NULL),
('usa', 'NY', 'New York', NULL),
('usa', 'OH', 'Ohio', NULL),
('usa', 'OK', 'Oklahoma', NULL),
('usa', 'OR', 'Oregon', NULL),
('usa', 'PA', 'Pennsylvania', NULL),
('usa', 'RI', 'Rhode Island', NULL),
('usa', 'SC', 'South Carolina', NULL),
('usa', 'SD', 'South Dakota', NULL),
('usa', 'TN', 'Tennessee', NULL),
('usa', 'TX', 'Texas', NULL),
('usa', 'UT', 'Utah', NULL),
('usa', 'VA', 'Virginia', NULL),
('usa', 'VT', 'Vermont', NULL),
('usa', 'WA', 'Washington', NULL),
('usa', 'WI', 'Wisconsin', NULL),
('usa', 'WV', 'West Virginia', NULL),
('usa', 'WY', 'Wyoming', NULL),
('can', 'AB', 'Alberta', NULL),
('can', 'BC', 'British Columbia', NULL),
('can', 'MB', 'Manitoba', NULL),
('can', 'NB', 'New Brunswick', NULL),
('can', 'NL', 'Newfoundland and Labrador', NULL),
('can', 'NS', 'Nova Scotia', NULL),
('can', 'ON', 'Ontario', NULL),
('can', 'PE', 'Prince Edward Island', NULL),
('can', 'QC', 'Quebec', NULL),
('can', 'SK', 'Saskatchewan', NULL),
('can', 'NT', 'Northwest Territories', NULL),
('can', 'YT', 'Yukon', NULL),
('can', 'NU', 'Nunavut', NULL),
('rus', '01', 'Адыгея республика', NULL),
('rus', '04', 'Алтай республика', NULL),
('rus', '22', 'Алтайский край', NULL),
('rus', '28', 'Амурская область', NULL),
('rus', '29', 'Архангельская область', NULL),
('rus', '30', 'Астраханская область', NULL),
('rus', '02', 'Башкортостан республика', NULL),
('rus', '31', 'Белгородская область', NULL),
('rus', '32', 'Брянская область', NULL),
('rus', '03', 'Бурятия республика', NULL),
('rus', '33', 'Владимирская область', NULL),
('rus', '34', 'Волгоградская область', NULL),
('rus', '35', 'Вологодская область', NULL),
('rus', '36', 'Воронежская область', NULL),
('rus', '05', 'Дагестан республика', NULL),
('rus', '79', 'Еврейская автономная область', NULL),
('rus', '75', 'Забайкальский край', NULL),
('rus', '37', 'Ивановская область', NULL),
('rus', '06', 'Ингушетия республика', NULL),
('rus', '38', 'Иркутская область', NULL),
('rus', '07', 'Кабардино-Балкарская республика', NULL),
('rus', '09', 'Карачаево-Черкесская республика', NULL),
('rus', '39', 'Калининградская область', NULL),
('rus', '08', 'Калмыкия республика', NULL),
('rus', '40', 'Калужская область', NULL),
('rus', '41', 'Камчатский край', NULL),
('rus', '10', 'Карелия республика', NULL),
('rus', '42', 'Кемеровская область', NULL),
('rus', '43', 'Кировская область', NULL),
('rus', '11', 'Коми республика', NULL),
('rus', '44', 'Костромская область', NULL),
('rus', '23', 'Краснодарский край', NULL),
('rus', '24', 'Красноярский край', NULL),
('rus', '45', 'Курганская область', NULL),
('rus', '46', 'Курская область', NULL),
('rus', '47', 'Ленинградская область', NULL),
('rus', '48', 'Липецкая область', NULL),
('rus', '49', 'Магаданская область', NULL),
('rus', '12', 'Марий Эл республика', NULL),
('rus', '50', 'Московская область', NULL),
('rus', '77', 'Москва', NULL),
('rus', '13', 'Мордовия республика', NULL),
('rus', '51', 'Мурманская область', NULL),
('rus', '83', 'Ненецкий автономный округ', NULL),
('rus', '52', 'Нижегородская область', NULL),
('rus', '53', 'Новгородская область', NULL),
('rus', '54', 'Новосибирская область', NULL),
('rus', '55', 'Омская область', NULL),
('rus', '56', 'Оренбургская область', NULL),
('rus', '57', 'Орловская область', NULL),
('rus', '58', 'Пензенская область', NULL),
('rus', '59', 'Пермский край', NULL),
('rus', '25', 'Приморский край', NULL),
('rus', '60', 'Псковская область', NULL),
('rus', '61', 'Ростовская область', NULL),
('rus', '62', 'Рязанская область', NULL),
('rus', '63', 'Самарская область', NULL),
('rus', '78', 'Санкт-Петербург', NULL),
('rus', '64', 'Саратовская область', NULL),
('rus', '14', 'Саха (Якутия) республика', NULL),
('rus', '65', 'Сахалинская область', NULL),
('rus', '66', 'Свердловская область', NULL),
('rus', '15', 'Северная Осетия-Алания', NULL),
('rus', '67', 'Смоленская область', NULL),
('rus', '26', 'Ставропольский край', NULL),
('rus', '68', 'Тамбовская область', NULL),
('rus', '16', 'Татарстан республика', NULL),
('rus', '69', 'Тверская область', NULL),
('rus', '70', 'Томская область', NULL),
('rus', '71', 'Тульская область', NULL),
('rus', '72', 'Тюменская область', NULL),
('rus', '17', 'Тыва республика', NULL),
('rus', '18', 'Удмуртская республика', NULL),
('rus', '73', 'Ульяновская область', NULL),
('rus', '27', 'Хабаровский край', NULL),
('rus', '19', 'Хакасия республика', NULL),
('rus', '86', 'Ханты-Мансийский-Югра автономный округ', NULL),
('rus', '74', 'Челябинская область', NULL),
('rus', '20', 'Чеченская республика', NULL),
('rus', '21', 'Чувашская республика', NULL),
('rus', '87', 'Чукотский автономный округ', NULL),
('rus', '89', 'Ямало-Ненецкий автономный округ', NULL),
('rus', '76', 'Ярославская область', NULL),
('ukr', '20', 'Тернопільська область', NULL),
('ukr', '19', 'Сумська область', NULL),
('ukr', '18', 'Рівненська область', NULL),
('ukr', '17', 'Полтавська область', NULL),
('ukr', '16', 'Одеська область', NULL),
('ukr', '15', 'Миколаївська область', NULL),
('ukr', '27', 'місто Севастополь', NULL),
('ukr', '11', 'місто Київ', 1),
('ukr', '14', 'Львівська область', NULL),
('ukr', '13', 'Луганська область', NULL),
('ukr', '10', 'Київська область', NULL),
('ukr', '12', 'Кіровоградська область', NULL),
('ukr', '08', 'Запорізька область', NULL),
('ukr', '07', 'Закарпатська область', NULL),
('ukr', '06', 'Житомирська область', NULL),
('ukr', '05', 'Донецька область', NULL),
('ukr', '04', 'Дніпропетровська область', NULL),
('ukr', '03', 'Волинська область', NULL),
('ukr', '02', 'Вінницька область', NULL),
('ukr', '01', 'Автономна Республіка Крим', NULL),
('ukr', '09', 'Івано-Франківська область', NULL),
('ukr', '21', 'Харківська область', NULL),
('ukr', '22', 'Херсонська область', NULL),
('ukr', '23', 'Хмельницька область', NULL),
('ukr', '24', 'Черкаська область', NULL),
('ukr', '26', 'Чернівецька область', NULL),
('ukr', '25', 'Чернігівська область', NULL);



ALTER TABLE `wa_region`
  ADD PRIMARY KEY (`country_iso3`,`code`);



CREATE TABLE IF NOT EXISTS `shop_product` (
  `id` int(11) NOT NULL,
  `id_1c` varchar(36) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `summary` text,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` text,
  `meta_description` text,
  `description` text,
  `contact_id` int(11) DEFAULT NULL,
  `create_datetime` datetime NOT NULL,
  `edit_datetime` datetime DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type_id` int(11) DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `image_filename` varchar(225) NOT NULL DEFAULT '',
  `sku_id` int(11) DEFAULT NULL,
  `ext` varchar(10) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `rating` decimal(3,2) NOT NULL DEFAULT '0.00',
  `price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `compare_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `currency` char(3) DEFAULT NULL,
  `min_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `max_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `tax_id` int(11) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `cross_selling` tinyint(1) DEFAULT NULL,
  `upselling` tinyint(1) DEFAULT NULL,
  `rating_count` int(11) NOT NULL DEFAULT '0',
  `total_sales` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `category_id` int(11) DEFAULT NULL,
  `badge` varchar(255) DEFAULT NULL,
  `sku_type` tinyint(1) NOT NULL DEFAULT '0',
  `base_price_selectable` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `compare_price_selectable` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `purchase_price_selectable` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `sku_count` int(11) NOT NULL DEFAULT '1',
  `k2type_import` varchar(75) NOT NULL,
  `k2keyimport` varchar(75) NOT NULL,
  `cnt_keywords` int(11) DEFAULT NULL,
  `cnt_razrez_keywords` int(11) DEFAULT NULL,
  `k2import_url` varchar(2048) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2391 DEFAULT CHARSET=utf8;


ALTER TABLE `shop_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url` (`url`),
  ADD KEY `total_sales` (`total_sales`),
  ADD KEY `id_1c` (`id_1c`),
  ADD KEY `k2type_import` (`k2type_import`),
  ADD KEY `k2keyimport` (`k2keyimport`);


CREATE TABLE IF NOT EXISTS `shop_product_images` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `upload_datetime` datetime NOT NULL,
  `edit_datetime` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `width` int(5) NOT NULL DEFAULT '0',
  `height` int(5) NOT NULL DEFAULT '0',
  `size` int(11) DEFAULT NULL,
  `filename` varchar(225) NOT NULL DEFAULT '',
  `original_filename` varchar(255) DEFAULT NULL,
  `ext` varchar(10) DEFAULT NULL,
  `badge_type` int(4) DEFAULT NULL,
  `badge_code` text
) ENGINE=InnoDB AUTO_INCREMENT=2089 DEFAULT CHARSET=utf8;


ALTER TABLE `shop_product_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);


CREATE TABLE IF NOT EXISTS `shop_product_skus` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `id_1c` varchar(36) DEFAULT NULL,
  `sku` varchar(255) NOT NULL,
  `sort` int(11) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `image_id` int(11) DEFAULT NULL,
  `price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `primary_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `purchase_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `compare_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `count` int(11) DEFAULT NULL,
  `available` int(11) NOT NULL DEFAULT '1',
  `dimension_id` int(11) DEFAULT NULL,
  `file_name` varchar(255) NOT NULL DEFAULT '',
  `file_size` int(11) NOT NULL DEFAULT '0',
  `file_description` text,
  `virtual` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=2391 DEFAULT CHARSET=utf8;


ALTER TABLE `shop_product_skus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `id_1c` (`id_1c`);

CREATE TABLE IF NOT EXISTS `shop_category_images` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `standard_out` int(11) NOT NULL DEFAULT '1',
  `upload_datetime` datetime NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `ext` varchar(10) NOT NULL,
  `width` int(5) NOT NULL DEFAULT '0',
  `height` int(5) NOT NULL DEFAULT '0',
  `size` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;


ALTER TABLE `shop_category_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

CREATE TABLE IF NOT EXISTS `shop_category` (
  `id` int(11) NOT NULL,
  `id_1c` varchar(36) DEFAULT NULL,
  `left_key` int(11) DEFAULT NULL,
  `right_key` int(11) DEFAULT NULL,
  `depth` int(11) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` text,
  `meta_description` text,
  `type` int(1) NOT NULL DEFAULT '0',
  `url` varchar(255) DEFAULT NULL,
  `full_url` varchar(255) DEFAULT NULL,
  `count` int(11) NOT NULL DEFAULT '0',
  `description` text,
  `conditions` text,
  `create_datetime` datetime NOT NULL,
  `edit_datetime` datetime DEFAULT NULL,
  `filter` text,
  `sort_products` varchar(32) DEFAULT NULL,
  `include_sub_categories` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `k2type_import` varchar(75) DEFAULT NULL,
  `k2keyimport` varchar(75) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8;


ALTER TABLE `shop_category`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url` (`parent_id`,`url`),
  ADD UNIQUE KEY `full_url` (`full_url`),
  ADD KEY `ns_keys` (`left_key`,`right_key`),
  ADD KEY `id_1c` (`id_1c`),
  ADD KEY `shop_category_idx_keyimp` (`k2type_import`,`k2keyimport`);


CREATE TABLE IF NOT EXISTS `shop_category_products` (
  `product_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `shop_category_products`
  ADD PRIMARY KEY (`category_id`,`product_id`);


CREATE TABLE IF NOT EXISTS `site_page` (
  `id` int(11) NOT NULL,
  `domain_id` int(11) NOT NULL,
  `route` varchar(64) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) DEFAULT NULL,
  `full_url` varchar(255) DEFAULT NULL,
  `content` longtext NOT NULL,
  `create_datetime` datetime NOT NULL,
  `update_datetime` datetime NOT NULL,
  `create_contact_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;


ALTER TABLE `site_page`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url` (`domain_id`,`route`,`full_url`),
  ADD KEY `parent_id` (`parent_id`);


CREATE TABLE IF NOT EXISTS `k2anticapcha` (
  `hashid` varchar(150) COLLATE utf8_bin NOT NULL,
  `decode_capcha` varchar(150) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE `k2anticapcha`
  ADD PRIMARY KEY (`hashid`);


CREATE TABLE IF NOT EXISTS `k2keys` (
  `k2keys` bigint(20) NOT NULL,
  `keysid` varchar(75) DEFAULT NULL,
  `keyrazrez` varchar(75) DEFAULT NULL,
  `keywords` varchar(10240) DEFAULT NULL,
  `resurs` varchar(75) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=23236 DEFAULT CHARSET=utf8 PACK_KEYS=0;


ALTER TABLE `k2keys`
  ADD PRIMARY KEY (`k2keys`),
  ADD KEY `k2keys_idx1` (`keysid`,`keyrazrez`),
  ADD KEY `k2keys_idx2` (`resurs`);


CREATE TABLE IF NOT EXISTS `k2keywords` (
  `id` bigint(20) NOT NULL,
  `keyid` varchar(75) NOT NULL,
  `keyrazrez` varchar(75) NOT NULL,
  `keyword` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=546037 DEFAULT CHARSET=utf8 PACK_KEYS=0;



ALTER TABLE `k2keywords`
  ADD PRIMARY KEY (`id`),
  ADD KEY `keyrazrez` (`keyrazrez`,`id`),
  ADD KEY `keyrazrez_2` (`keyrazrez`),
  ADD KEY `keyid` (`keyid`),
  ADD KEY `k2keywords_idx1` (`keyid`,`keyrazrez`);


CREATE TABLE IF NOT EXISTS `k2razrez_keywords` (
  `idrazrez` varchar(75) COLLATE utf8_bin NOT NULL,
  `name_razrez` varchar(250) COLLATE utf8_bin DEFAULT NULL,
  `comment` varchar(250) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin PACK_KEYS=0;


ALTER TABLE `k2razrez_keywords`
  ADD PRIMARY KEY (`idrazrez`),
  ADD UNIQUE KEY `idrazrez` (`idrazrez`);


/* Дальнейшие изменения */




/********************************************************************/
/*  Скрипт обмена электронных денег									*/
/********************************************************************/
CREATE TABLE `k2ObmenEmoney` (
  `emoneyid` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `emoneyname` VARCHAR(150) DEFAULT NULL,
  PRIMARY KEY (`emoneyid`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;

ALTER TABLE `k2ObmenEmoney` RENAME AS `k2_obmen_emoney`;

CREATE TABLE `k2_obmen_val` (
  `valid` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `valname` VARCHAR(150) DEFAULT NULL,
  PRIMARY KEY (`valid`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;






CREATE TABLE IF NOT EXISTS `k2_obmen_emoneyval` (
  `emoneyvalid` int(11) NOT NULL,
  `emoneyid` int(11) DEFAULT NULL,
  `valid` int(11) DEFAULT NULL,
  `emoneyvalname` varchar(250) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_bin PACK_KEYS=0;


INSERT INTO `k2_obmen_emoneyval` (`emoneyvalid`, `emoneyid`, `valid`, `emoneyvalname`) VALUES
(1, 1, 1, 'Webmoney WMZ'),
(2, 1, 2, 'Webmoney WMU'),
(3, 1, 3, 'Webmoney WMR'),
(4, 1, 4, 'Webmoney WME'),
(5, 2, 3, 'Яндекс.Деньги RUR'),
(6, 3, 3, 'Qiwi RUR'),
(7, 4, 2, 'Приват24 UAH'),
(8, 5, 2, 'Visa/Master UAH'),
(12, 5, 3, 'Visa/Master RUR');


CREATE TABLE IF NOT EXISTS `k2_obmen_val` (
  `valid` int(11) NOT NULL,
  `valname` varchar(150) COLLATE utf8_bin DEFAULT NULL,
  `sokrname` varchar(75) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_bin PACK_KEYS=0;

INSERT INTO `k2_obmen_val` (`valid`, `valname`, `sokrname`) VALUES
(1, 'Доллар', '$'),
(2, 'Гривна', 'Грн.'),
(3, 'Российские рубли', 'Руб.'),
(4, 'Евро', 'Евро');








CREATE TABLE `k2_obmen_kurs` (
  `kursid` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `emoneyid1` INTEGER(11) DEFAULT NULL,
  `emoneyid2` INTEGER(11) DEFAULT NULL,
  `sumval1` DECIMAL(11,2) DEFAULT NULL,
  `sumval2` DECIMAL(11,2) DEFAULT NULL,
  PRIMARY KEY (`kursid`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;



ALTER TABLE `k2_obmen_kurs` MODIFY COLUMN `sumval1` DECIMAL(11,4) DEFAULT NULL;
ALTER TABLE `k2_obmen_kurs` MODIFY COLUMN `sumval2` DECIMAL(11,4) DEFAULT NULL;


CREATE TABLE IF NOT EXISTS `k2_obmen_emoney` (
  `emoneyid` int(11) NOT NULL,
  `emoneyname` varchar(150) COLLATE utf8_bin DEFAULT NULL,
  `iconname` varchar(250) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin PACK_KEYS=0;


INSERT INTO `k2_obmen_emoney` (`emoneyid`, `emoneyname`, `iconname`) VALUES
(1, 'Webmoney', 'webmoney.png'),
(2, 'Яндекс.Деньги!', 'yandex.png'),
(3, 'Qiwi', 'qiwi.png'),
(4, 'Приват24', 'privat24.png'),
(5, 'Visa/Master Card', 'visamaster.png');



INSERT INTO `k2_obmen_kurs` (`kursid`, `emoneyid1`, `emoneyid2`, `sumval1`, `sumval2`) VALUES
(1, 1, 2, 1.0000, 24.2700),
(2, 1, 3, 1.0000, 67.3000),
(3, 3, 8, 2.8800, 1.0000),
(4, 3, 12, 1.0400, 1.0000),
(5, 2, 8, 1.0200, 1.0000),
(6, 2, 12, 1.0000, 2.6900),
(7, 4, 7, 1.0000, 25.7700),
(8, 4, 8, 1.0000, 25.7700),
(9, 4, 12, 1.0000, 71.2800),
(10, 5, 8, 2.8900, 1.0000),
(11, 5, 12, 1.0500, 1.0000),
(12, 6, 8, 2.9100, 1.0000),
(13, 7, 1, 24.7600, 1.0000),
(14, 7, 3, 1.0000, 2.8000),
(15, 7, 2, 1.0000, 1.0030),
(16, 7, 4, 26.7600, 1.0000),
(17, 7, 5, 1.0000, 2.8000),
(18, 7, 6, 1.0000, 2.7900),
(19, 8, 1, 25.0600, 1.0000),
(20, 8, 12, 1.0000, 2.7500),
(21, 8, 2, 1.0100, 1.0000),
(22, 8, 4, 26.9200, 1.0000),
(23, 8, 5, 1.0000, 2.7500),
(24, 8, 6, 1.0000, 2.7600),
(25, 5, 7, 2.8890, 1.0000),
(26, 1, 3, 1.0000, 68.8400),
(27, 1, 7, 1.0000, 24.2700),
(28, 3, 7, 2.8750, 1.0000),
(29, 6, 7, 2.9050, 1.0000),
(30, 1, 2, 1.0000, 24.3800),
(31, 1, 4, 1.0831, 1.0000),
(32, 1, 5, 1.0000, 68.5000),
(33, 1, 6, 1.0000, 68.5000),
(34, 2, 7, 1.0210, 1.0000),
(35, 3, 1, 70.8600, 1.0000),
(36, 3, 2, 2.8550, 1.0000),
(37, 3, 4, 75.8700, 1.0000),
(38, 3, 5, 1.0030, 1.0000),
(39, 3, 6, 1.0080, 1.0000),
(40, 2, 1, 25.3300, 1.0000),
(41, 2, 3, 1.0000, 2.7300),
(42, 2, 4, 26.9600, 1.0000),
(43, 2, 5, 1.0000, 2.7500),
(44, 2, 6, 1.0000, 2.7600),
(45, 4, 1, 1.0000, 1.0480),
(46, 4, 3, 1.0000, 72.7700),
(47, 4, 2, 1.0000, 25.8000),
(48, 4, 5, 1.0000, 71.8800),
(49, 4, 6, 1.0000, 71.5000),
(50, 5, 1, 70.4500, 1.0000),
(51, 5, 3, 1.0130, 1.0000),
(52, 5, 2, 2.8890, 1.0000),
(53, 5, 4, 76.2400, 1.0000),
(54, 5, 6, 1.0210, 1.0000),
(55, 6, 1, 70.1800, 1.0000),
(56, 6, 3, 1.0000, 1.0000),
(57, 6, 2, 2.9050, 1.0000),
(58, 6, 4, 75.5500, 1.0000),
(59, 6, 5, 1.0000, 1.0050);





/*************************************/
/*  Proxy                            */
/*************************************/
CREATE TABLE `k2_proxy` (
  `proxyid` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `ipadress` VARCHAR(75) COLLATE utf8_general_ci DEFAULT NULL,
  `port` INTEGER(11) DEFAULT NULL,
  `sort` INTEGER(11) DEFAULT NULL,
  `checked` INTEGER(11) DEFAULT NULL,
  PRIMARY KEY (`proxyid`) USING BTREE
) ENGINE=InnoDB
AUTO_INCREMENT=29 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
;

ALTER TABLE `k2_proxy` ADD COLUMN `checked` BOOLEAN DEFAULT NULL;

ALTER TABLE `k2_proxy` MODIFY COLUMN `checked` INTEGER(11) DEFAULT NULL;




/*************************************/
/*  Меню (типы меню)                 */
/*************************************/
CREATE TABLE `k2menu` (
  `k2menuid` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `menu_name` VARCHAR(250) DEFAULT NULL,
  `ident` VARCHAR(150) DEFAULT NULL,
  `comment` VARCHAR(1024) DEFAULT NULL,
  `act` INTEGER(11) DEFAULT 1,
  PRIMARY KEY (`k2menuid`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;


CREATE TABLE `k2menuitems` (
  `k2menuitemid` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `k2menuid` INTEGER(11) DEFAULT NULL,
  `caption` VARCHAR(1024) DEFAULT NULL,
  `parentid` INTEGER(11) DEFAULT NULL,
  `act` INTEGER(11) DEFAULT 1,
  PRIMARY KEY (`k2menuitemid`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;

ALTER TABLE `k2menuitems` ADD INDEX `k2menuitems_parent` (`parentid`);
ALTER TABLE `k2menuitems` ADD INDEX `k2menuitems_idx1` (`caption`);
ALTER TABLE `k2menuitems` ADD COLUMN `hint` VARCHAR(1024) DEFAULT NULL;

ALTER TABLE `k2menuitems` ADD COLUMN `command` VARCHAR(1024) DEFAULT NULL;

CREATE TABLE `k2content` (
  `contentid` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `title` VARCHAR(1024) DEFAULT NULL,
  `desc` VARCHAR(1024) DEFAULT NULL,
  `keywords` VARCHAR(1024) DEFAULT NULL,
  `content` TEXT(1),
  `command` VARCHAR(150) DEFAULT NULL,
  PRIMARY KEY (`contentid`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;

ALTER TABLE `k2content` ADD COLUMN `parentcontent` VARCHAR(150) DEFAULT NULL;

ALTER TABLE `k2content` CHANGE COLUMN `desc` `descript` VARCHAR(1024) COLLATE utf8_bin DEFAULT NULL;

ALTER TABLE `k2_obmen_kurs` ADD COLUMN `act` INTEGER(11) DEFAULT 1;

ALTER TABLE `k2menuitems` ADD COLUMN `url` VARCHAR(250) DEFAULT NULL;

ALTER TABLE `k2menuitems` ADD COLUMN `ord` INTEGER(11) DEFAULT NULL;



CREATE TABLE IF NOT EXISTS `shop_order` (
  `id` int(11) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `create_datetime` datetime NOT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `state_id` varchar(32) NOT NULL DEFAULT 'new',
  `total` decimal(15,4) NOT NULL,
  `currency` char(3) NOT NULL,
  `rate` decimal(15,8) NOT NULL DEFAULT '1.00000000',
  `tax` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `shipping` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `discount` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `assigned_contact_id` int(11) DEFAULT NULL,
  `paid_year` smallint(6) DEFAULT NULL,
  `paid_quarter` smallint(6) DEFAULT NULL,
  `paid_month` smallint(6) DEFAULT NULL,
  `paid_date` date DEFAULT NULL,
  `is_first` tinyint(1) NOT NULL DEFAULT '0',
  `comment` text,
  `roistat_visit` varchar(255) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

ALTER TABLE `shop_order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state_id` (`state_id`),
  ADD KEY `contact_id` (`contact_id`);


ALTER TABLE `k2content` MODIFY COLUMN `content` TEXT COLLATE utf8_bin;

ALTER TABLE `k2content` ADD COLUMN `h1` VARCHAR(1024) DEFAULT NULL;

ALTER TABLE `k2content` ADD COLUMN `script` LONGTEXT;
ALTER TABLE `k2content` MODIFY COLUMN `content` LONGTEXT COLLATE utf8_bin;


ALTER TABLE `wa_contact` ADD COLUMN `email` VARCHAR(255) DEFAULT NULL;
ALTER TABLE `wa_contact` ADD COLUMN `phone` VARCHAR(150) DEFAULT NULL;
ALTER TABLE `wa_contact` ADD COLUMN `roleid` VARCHAR(150) DEFAULT NULL;


ALTER TABLE `wa_contact` ADD COLUMN `remember_hash` VARCHAR(150) DEFAULT NULL;
ALTER TABLE `wa_contact` ADD INDEX `wa_contact_remember_idx` (`remember_hash`);



ALTER TABLE `k2_obmen_kurs` ADD UNIQUE INDEX `k2_obmen_kurs_idx1` (`emoneyid1`, `emoneyid2`);


CREATE TABLE `k2_obmen_zakaz` (
  `k2obmzak1` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `emoneyvalid1` INTEGER(11) DEFAULT NULL,
  `emoneyvalid2` INTEGER(11) DEFAULT NULL,
  `sumobmen` DECIMAL(15,4) DEFAULT NULL,
  `username` VARCHAR(150) DEFAULT NULL,
  `obmenna` DECIMAL(15,2) DEFAULT NULL,
  `datezak` DATETIME(6) DEFAULT NULL,
  `comment` VARCHAR(1024) DEFAULT NULL,
  `fam` VARCHAR(150) DEFAULT NULL,
  `im` VARCHAR(150) DEFAULT NULL,
  `otch` VARCHAR(150) DEFAULT NULL,
  `schet_from` VARCHAR(150) DEFAULT NULL,
  `schet_to` VARCHAR(150) DEFAULT NULL,
  `commision` INTEGER(11) DEFAULT NULL,
  PRIMARY KEY (`k2obmzak1`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;



ALTER TABLE `k2_obmen_zakaz` ADD COLUMN `status` INTEGER(11) DEFAULT NULL;

CREATE TABLE `k2_status_zak` (
  `k2statid` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `statname` VARCHAR(150) DEFAULT NULL,
  PRIMARY KEY (`k2statid`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;


ALTER TABLE `k2_obmen_zakaz` ADD COLUMN `sumobmento` DECIMAL(15,2) DEFAULT NULL;


ALTER TABLE `k2_obmen_zakaz` ADD COLUMN `email` VARCHAR(150) DEFAULT NULL;

ALTER TABLE `k2_obmen_zakaz` ADD COLUMN `phone` VARCHAR(150) DEFAULT NULL;

ALTER TABLE `k2content` ADD COLUMN `short_description` LONGTEXT;




DROP TABLE IF EXISTS ajax_chat_online;
CREATE TABLE ajax_chat_online (
  userID INT(11) NOT NULL,
  userName VARCHAR(64) NOT NULL,
  userRole INT(1) NOT NULL,
  channel INT(11) NOT NULL,
  dateTime DATETIME NOT NULL,
  ip VARBINARY(16) NOT NULL,
  PRIMARY KEY (userID),
  INDEX (userName)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS ajax_chat_messages;
CREATE TABLE ajax_chat_messages (
  id INT(11) NOT NULL AUTO_INCREMENT,
  userID INT(11) NOT NULL,
  userName VARCHAR(64) NOT NULL,
  userRole INT(1) NOT NULL,
  channel INT(11) NOT NULL,
  dateTime DATETIME NOT NULL,
  ip VARBINARY(16) NOT NULL,
  text TEXT,
  PRIMARY KEY (id),
  INDEX message_condition (id, channel, dateTime),
  INDEX (dateTime)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS ajax_chat_bans;
CREATE TABLE ajax_chat_bans (
  userID INT(11) NOT NULL,
  userName VARCHAR(64) NOT NULL,
  dateTime DATETIME NOT NULL,
  ip VARBINARY(16) NOT NULL,
  PRIMARY KEY (userID),
  INDEX (userName),
  INDEX (dateTime)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS ajax_chat_invitations;
CREATE TABLE ajax_chat_invitations (
  userID INT(11) NOT NULL,
  channel INT(11) NOT NULL,
  dateTime DATETIME NOT NULL,
  PRIMARY KEY (userID, channel),
  INDEX (dateTime)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



CREATE TABLE `k2chat_room` (
  `roomid` INTEGER(11) NOT NULL AUTO_INCREMENT UNIQUE,
  `name` VARCHAR(150) DEFAULT NULL,
  PRIMARY KEY (`roomid`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;



ALTER TABLE `k2chat_room` ENGINE=InnoDB, CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

ALTER TABLE `k2chat_room` MODIFY COLUMN `name` VARCHAR(150) COLLATE utf8_general_ci DEFAULT NULL;