ZhUW05T9

1-- phpMyAdmin SQL Dump
2-- version 4.1.12
3--
4-- Хост: localhost:3306
5-- Версия сервера: 5.6.33-log
6-- Версия PHP: 5.4.32
7
8SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
9SET time_zone = "+00:00";
10
11
12/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
13/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
14/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
15/*!40101 SET NAMES utf8 */;
16
17--
18-- База данных: `candyman_rubiz`
19--
20
21-- --------------------------------------------------------
22
23--
24-- Структура таблицы `ches_biz`
25--
26
27DROP TABLE IF EXISTS `ches_biz`;
28CREATE TABLE IF NOT EXISTS `ches_biz` (
29  `ID` int(11) NOT NULL AUTO_INCREMENT,
30  `Source_ID` text,
31  `OGRN` text,
32  `Short_Comp_name` text,
33  `Full_Comp_name` text,
34  `Owner_Duty` text,
35  `Owner_Name` text,
36  `Owner_INN` text,
37  `INN_REG_DATE` text,
38  `Owner_IS_CEO` text,
39  `Other_Comp` text,
40  `Sole_Owner` text,
41  `PHONE` text,
42  `Address` text,
43  `LAT` text NOT NULL,
44  `LNG` text NOT NULL,
45  `INN` text,
46  `KPP` text,
47  `REG_DATE` text,
48  `REG_ORG` text,
49  `INITIAL_SUM` text,
50  `FNS_REG_ORG` text,
51  `FNS_REG_NAME` text,
52  `FNS_ADDRESS` text,
53  `PFR_REG_NUM` text,
54  `PFR_REG_DATE` text,
55  `PFR_REG_NAME` text,
56  `FSS_REG_NUM` text,
57  `FSS_REG_DATE` text,
58  `FSS_REG_NAME` text,
59  `MAIN_DEAL` text,
60  `Other_Deals` text,
61  `uchereditels` text,
62  `uchrejdennie` text NOT NULL,
63  `upravlyaemie` text NOT NULL,
64  `falials` text NOT NULL,
65  `predstavitelstva` text NOT NULL,
66  `Comp_Status` text,
67  `Address_Counter` text,
68  `LIKVID_DATE` text,
69  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
70  PRIMARY KEY (`ID`)
71) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=365186 ;