izaAV8kZ

1-- phpMyAdmin SQL Dump
2-- version 4.6.6
3-- https://www.phpmyadmin.net/
4--
5-- Хост: localhost
6-- Время создания: Июл 21 2017 г., 00:55
7-- Версия сервера: 5.5.52-38.3
8-- Версия PHP: 5.6.30
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19
20-- --------------------------------------------------------
21
22--
23-- Структура таблицы `oc_country`
24--
25
26CREATE TABLE IF NOT EXISTS `oc_country` (
27  `country_id` int(11) NOT NULL AUTO_INCREMENT,
28  `name` varchar(128) NOT NULL,
29  `iso_code_2` varchar(2) NOT NULL,
30  `iso_code_3` varchar(3) NOT NULL,
31  `address_format` text NOT NULL,
32  `postcode_required` tinyint(1) NOT NULL,
33  `status` tinyint(1) NOT NULL DEFAULT '1',
34  PRIMARY KEY (`country_id`)
35) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=utf8;
36
37
38TRUNCATE TABLE `oc_country`;
39--
40-- Дамп данных таблицы `oc_country`
41--
42
43INSERT INTO `oc_country` (`country_id`, `name`, `iso_code_2`, `iso_code_3`, `address_format`, `postcode_required`, `status`) VALUES
44(11, 'Армения', 'AM', 'ARM', '', 0, 1),
45(20, 'Белоруссия (Беларусь)', 'BY', 'BLR', '', 0, 1),
46(109, 'Казахстан', 'KZ', 'KAZ', '', 0, 1),
47(115, 'Киргизия (Кыргызстан)', 'KG', 'KGZ', '', 0, 1),
48(176, 'Российская Федерация', 'RU', 'RUS', '', 0, 1),
49
50/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
51/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
52/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;