--
-- Host: localhost    Database: dictionaries
-- ------------------------------------------------------


--
-- Temporary view structure for view `abnormalquantity`
--

/*!50001 DROP VIEW IF EXISTS `abnormalquantity`*/;
/*!50001 CREATE VIEW `abnormalquantity` AS SELECT 
 1 AS `barcode`,
 1 AS `minquant`,
 1 AS `maxquant`*/;

--
-- Table structure for table `abnormalquantity1`
--

CREATE TABLE `abnormalquantity1` (
  `barcode` varchar(255) NOT NULL,
  `minquant` decimal(13,3) DEFAULT NULL,
  `maxquant` decimal(13,3) DEFAULT NULL,
  PRIMARY KEY (`barcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abnormalquantity1`
--


--
-- Table structure for table `abnormalquantity2`
--

CREATE TABLE `abnormalquantity2` (
  `barcode` varchar(255) NOT NULL,
  `minquant` decimal(13,3) DEFAULT NULL,
  `maxquant` decimal(13,3) DEFAULT NULL,
  PRIMARY KEY (`barcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abnormalquantity2`
--


--
-- Temporary view structure for view `accountmask`
--

/*!50001 DROP VIEW IF EXISTS `accountmask`*/;
/*!50001 CREATE VIEW `accountmask` AS SELECT 
 1 AS `maskid`,
 1 AS `providerid`,
 1 AS `mask`,
 1 AS `transform`*/;

--
-- Table structure for table `accountmask1`
--

CREATE TABLE `accountmask1` (
  `maskid` int NOT NULL AUTO_INCREMENT,
  `providerid` int NOT NULL,
  `mask` varchar(200) NOT NULL,
  `transform` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`maskid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `accountmask1`
--


--
-- Table structure for table `accountmask2`
--

CREATE TABLE `accountmask2` (
  `maskid` int NOT NULL AUTO_INCREMENT,
  `providerid` int NOT NULL,
  `mask` varchar(200) NOT NULL,
  `transform` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`maskid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `accountmask2`
--


--
-- Temporary view structure for view `accumulatesprices`
--

/*!50001 DROP VIEW IF EXISTS `accumulatesprices`*/;
/*!50001 CREATE VIEW `accumulatesprices` AS SELECT 
 1 AS `code`,
 1 AS `name`*/;

--
-- Table structure for table `accumulatesprices1`
--

CREATE TABLE `accumulatesprices1` (
  `code` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `accumulatesprices1`
--


--
-- Table structure for table `accumulatesprices2`
--

CREATE TABLE `accumulatesprices2` (
  `code` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `accumulatesprices2`
--


--
-- Temporary view structure for view `actionpanel`
--

/*!50001 DROP VIEW IF EXISTS `actionpanel`*/;
/*!50001 CREATE VIEW `actionpanel` AS SELECT 
 1 AS `actionpanelcode`,
 1 AS `context`,
 1 AS `page`,
 1 AS `rowcount`,
 1 AS `columncount`*/;

--
-- Table structure for table `actionpanel1`
--

CREATE TABLE `actionpanel1` (
  `actionpanelcode` int NOT NULL AUTO_INCREMENT,
  `context` int NOT NULL,
  `page` int NOT NULL,
  `rowcount` int NOT NULL,
  `columncount` int NOT NULL,
  PRIMARY KEY (`actionpanelcode`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `actionpanel1`
--

INSERT INTO `actionpanel1` VALUES (1,6,1,6,4),(2,7,1,6,4),(3,8,1,6,4),(4,9,1,6,4),(5,17,1,3,6),(6,6,2,1,6),(7,6,3,2,6);

--
-- Table structure for table `actionpanel2`
--

CREATE TABLE `actionpanel2` (
  `actionpanelcode` int NOT NULL AUTO_INCREMENT,
  `context` int NOT NULL,
  `page` int NOT NULL,
  `rowcount` int NOT NULL,
  `columncount` int NOT NULL,
  PRIMARY KEY (`actionpanelcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `actionpanel2`
--


--
-- Temporary view structure for view `actionpanelitem`
--

/*!50001 DROP VIEW IF EXISTS `actionpanelitem`*/;
/*!50001 CREATE VIEW `actionpanelitem` AS SELECT 
 1 AS `actionpanelitemcode`,
 1 AS `actionpanelcode`,
 1 AS `actioncode`,
 1 AS `row`,
 1 AS `column`,
 1 AS `rowspan`,
 1 AS `columnspan`,
 1 AS `color`,
 1 AS `name`*/;

--
-- Table structure for table `actionpanelitem1`
--

CREATE TABLE `actionpanelitem1` (
  `actionpanelitemcode` int NOT NULL AUTO_INCREMENT,
  `actionpanelcode` int NOT NULL,
  `actioncode` int NOT NULL,
  `row` int NOT NULL,
  `column` int NOT NULL,
  `rowspan` int DEFAULT NULL,
  `columnspan` int DEFAULT NULL,
  `color` varchar(20) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`actionpanelitemcode`),
  UNIQUE KEY `uix_actionpanelitem_actionpanelcode_row_column` (`actionpanelcode`,`row`,`column`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `actionpanelitem1`
--

INSERT INTO `actionpanelitem1` VALUES (5,1,16,3,4,1,1,'','Отмена чека'),(6,1,197,6,1,1,1,NULL,'Средний пакет'),(9,1,246,4,1,1,2,NULL,'Каталог'),(10,1,211,3,3,1,1,'','Ручные скидки'),(16,1,101,5,3,2,2,NULL,NULL),(17,2,227,3,3,2,2,NULL,'Назад'),(23,3,227,4,3,1,2,NULL,'Назад'),(28,4,23,3,1,2,2,NULL,NULL),(31,4,227,5,3,2,2,NULL,'Продолжить'),(32,1,228,4,3,1,2,NULL,'Поиск товара'),(33,5,35,1,6,3,1,'ed2e28','Закрыть'),(34,5,2,3,1,1,1,NULL,NULL),(35,5,15,1,1,1,1,NULL,NULL),(36,5,16,2,1,1,1,NULL,NULL),(37,5,9,3,2,1,1,NULL,NULL),(38,5,112,1,3,1,1,NULL,NULL),(39,5,29,2,3,1,1,NULL,NULL),(40,5,192,3,3,1,1,NULL,NULL),(41,5,113,1,4,1,1,NULL,NULL),(42,5,194,2,4,1,1,NULL,NULL),(43,5,99,1,5,2,1,NULL,NULL),(44,5,22,2,2,1,1,NULL,NULL),(45,5,197,1,2,1,1,NULL,NULL),(46,6,50,1,2,1,1,NULL,NULL),(47,6,103,1,3,1,1,NULL,NULL),(48,6,25,1,4,1,1,NULL,'Инфо о карте'),(50,6,252,1,1,1,1,NULL,'Назад'),(51,7,252,1,5,1,2,NULL,'Назад'),(52,7,116,2,1,1,2,NULL,'Отложить'),(53,7,117,2,3,1,2,NULL,'Восстановить'),(54,7,235,2,5,1,2,NULL,'Просмотр отложенных чеков'),(56,1,285,6,2,1,1,NULL,'Большой пакет'),(57,1,9,3,1,1,1,NULL,'Количество'),(59,1,284,3,2,1,1,NULL,'Чек'),(60,1,50,5,1,1,2,NULL,'Карта'),(61,2,288,5,3,2,2,NULL,'СберБанк'),(62,2,287,5,1,2,2,NULL,'Наличные'),(63,2,289,3,1,1,2,NULL,'СБП'),(64,2,247,4,1,1,2,NULL,'Сертификат'),(65,3,35,5,3,2,2,NULL,'Закрыть чек'),(66,4,271,3,3,2,2,NULL,'Печать последнего фискального документа'),(67,4,262,5,1,2,2,NULL,'Печать копии слипа');

--
-- Table structure for table `actionpanelitem2`
--

CREATE TABLE `actionpanelitem2` (
  `actionpanelitemcode` int NOT NULL AUTO_INCREMENT,
  `actionpanelcode` int NOT NULL,
  `actioncode` int NOT NULL,
  `row` int NOT NULL,
  `column` int NOT NULL,
  `rowspan` int DEFAULT NULL,
  `columnspan` int DEFAULT NULL,
  `color` varchar(20) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`actionpanelitemcode`),
  UNIQUE KEY `uix_actionpanelitem_actionpanelcode_row_column` (`actionpanelcode`,`row`,`column`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `actionpanelitem2`
--


--
-- Temporary view structure for view `actionparameter`
--

/*!50001 DROP VIEW IF EXISTS `actionparameter`*/;
/*!50001 CREATE VIEW `actionparameter` AS SELECT 
 1 AS `actionparametercode`,
 1 AS `parameterorder`,
 1 AS `parametervalue`,
 1 AS `cmactioncode`,
 1 AS `parametername`*/;

--
-- Table structure for table `actionparameter1`
--

CREATE TABLE `actionparameter1` (
  `actionparametercode` int NOT NULL AUTO_INCREMENT,
  `parameterorder` int DEFAULT NULL,
  `parametervalue` text,
  `cmactioncode` int DEFAULT NULL,
  `parametername` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`actionparametercode`),
  KEY `actionparametercmactioncode` (`cmactioncode`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `actionparameter1`
--

INSERT INTO `actionparameter1` VALUES (1,1,'1',1,'menucode'),(3,1,'3',19,'department'),(10,1,'6',55,NULL),(14,1,'10',60,'menucode'),(15,1,'frdoc://frxreport/lll',62,'url'),(16,1,'frdoc://frzreport?kkm=all',63,'url'),(18,1,'frdoc://frdeptreport?kkm=selected&mode=single',64,'url'),(19,1,'report://xreport?out=print&shift=selected',65,'url'),(21,1,'1',68,'macrocode'),(23,1,'report://zreport?out=print',74,'url'),(24,1,'report://deptreport?out=print&shift=selected',75,'url'),(25,1,'report://streport?out=print&shift=selected',76,'url'),(26,1,'report://streport?out=print&shift=current',77,'url'),(27,1,'shell:////bin/bash%20/linuxcash/cash/bin/oncloseshift.sh',78,'url'),(28,1,'shell:////linuxcash/cash/sync/scripts/unloadSales.sh &',49,'url'),(39,1,'shell:////linuxcash/cash/exchangesystems/exchangers/scripts/cash/unload_sales.sh?shift=current&document=none#%20-o%20-s%20%(shift.num[d])@%(shift.num[d])%20-c%202',121,'url'),(50,1,'shell:////linuxcash/cash/exchangesystems/exchangers/scripts/cash/unload_sales.sh?shift=selected&document=none#%20-s%20%(shift.num[d])@%(shift.num[d])%20-c%202',131,'url'),(53,2,'1,4',76,'roles'),(56,2,'1,4',65,'roles'),(57,2,'1,4',75,'roles'),(58,2,'1,4',121,'roles'),(60,2,'1,4',64,'roles'),(61,2,'1,4',74,'roles'),(62,2,'1,4',63,'roles'),(63,2,'1,4',77,'roles'),(64,2,'1,4',231,'roles'),(65,2,'1,4',62,'roles'),(66,2,'1,4',131,'roles'),(67,1,'shell:////linuxcash/cash/sync/scripts/unloadSales.sh?shift=current&document=none#%20-s%20%(shift.num[d])@%(shift.num[d])%20-c%202',133,'url'),(68,2,'1,4',133,'roles'),(69,1,'13',182,NULL),(70,1,'14',183,NULL),(71,1,'15',185,NULL),(72,1,'1',92,'button'),(73,1,'http://localhost/',196,'url'),(74,2,'false',196,'showCursor'),(75,1,'1',197,'hotKeyCode'),(76,1,'3',198,'valut'),(77,1,'16',199,NULL),(78,2,'1,4',204,'roles'),(79,1,'report://bonusreport?out=print&shift=selected',204,'url'),(80,1,'17',210,NULL),(89,1,'frdoc://frvatreport',222,'url'),(90,2,'1,4',222,'roles'),(91,1,'report://cashier?out=print&shift=selected&kkm=selected',231,'url'),(92,1,'0',244,'department'),(93,1,'excise',245,'type'),(96,1,'last',95,'mode'),(99,2,'true',197,'showEmptyLines'),(100,1,'sst-sco',269,'type'),(101,1,'frdoc://frlastfndocument',271,'url'),(102,2,'1,4',271,'roles'),(103,1,'2',184,'valutcode'),(104,1,'1',9,'mode'),(105,1,'1',10,'mode'),(106,1,'1',246,'multilevel'),(107,1,'active',276,'status'),(112,1,'3',79,'valutcode'),(115,3,'true',133,'showProgress'),(121,1,'2',283,'page'),(122,1,'3',284,'page'),(123,1,'2',285,'hotKeyCode'),(124,1,'18',286,NULL),(125,1,'1',287,'valCode'),(126,1,'3',288,'valCode'),(127,1,'3',289,'valCode');

--
-- Table structure for table `actionparameter2`
--

CREATE TABLE `actionparameter2` (
  `actionparametercode` int NOT NULL AUTO_INCREMENT,
  `parameterorder` int DEFAULT NULL,
  `parametervalue` text,
  `cmactioncode` int DEFAULT NULL,
  `parametername` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`actionparametercode`),
  KEY `actionparametercmactioncode` (`cmactioncode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `actionparameter2`
--


--
-- Temporary view structure for view `agent`
--

/*!50001 DROP VIEW IF EXISTS `agent`*/;
/*!50001 CREATE VIEW `agent` AS SELECT 
 1 AS `code`,
 1 AS `name`,
 1 AS `inn`,
 1 AS `phone`,
 1 AS `address`*/;

--
-- Table structure for table `agent1`
--

CREATE TABLE `agent1` (
  `code` varchar(100) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `inn` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `agent1`
--


--
-- Table structure for table `agent2`
--

CREATE TABLE `agent2` (
  `code` varchar(100) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `inn` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `agent2`
--


--
-- Temporary view structure for view `agerestrict`
--

/*!50001 DROP VIEW IF EXISTS `agerestrict`*/;
/*!50001 CREATE VIEW `agerestrict` AS SELECT 
 1 AS `alcoholpercent`,
 1 AS `age`*/;

--
-- Table structure for table `agerestrict1`
--

CREATE TABLE `agerestrict1` (
  `alcoholpercent` decimal(4,2) NOT NULL,
  `age` int DEFAULT NULL,
  PRIMARY KEY (`alcoholpercent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `agerestrict1`
--


--
-- Table structure for table `agerestrict2`
--

CREATE TABLE `agerestrict2` (
  `alcoholpercent` decimal(4,2) NOT NULL,
  `age` int DEFAULT NULL,
  PRIMARY KEY (`alcoholpercent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `agerestrict2`
--


--
-- Temporary view structure for view `alcocode`
--

/*!50001 DROP VIEW IF EXISTS `alcocode`*/;
/*!50001 CREATE VIEW `alcocode` AS SELECT 
 1 AS `alcocode`*/;

--
-- Table structure for table `alcocode1`
--

CREATE TABLE `alcocode1` (
  `alcocode` varchar(20) NOT NULL,
  PRIMARY KEY (`alcocode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `alcocode1`
--


--
-- Table structure for table `alcocode2`
--

CREATE TABLE `alcocode2` (
  `alcocode` varchar(20) NOT NULL,
  PRIMARY KEY (`alcocode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `alcocode2`
--


--
-- Temporary view structure for view `alcoset`
--

/*!50001 DROP VIEW IF EXISTS `alcoset`*/;
/*!50001 CREATE VIEW `alcoset` AS SELECT 
 1 AS `alcosetbarcode`,
 1 AS `code`,
 1 AS `barcode`,
 1 AS `price`,
 1 AS `taracapacity`,
 1 AS `quant`*/;

--
-- Table structure for table `alcoset1`
--

CREATE TABLE `alcoset1` (
  `alcosetbarcode` varchar(100) NOT NULL,
  `code` varchar(100) NOT NULL,
  `barcode` varchar(100) NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `taracapacity` decimal(13,3) DEFAULT NULL,
  `quant` int DEFAULT NULL,
  PRIMARY KEY (`alcosetbarcode`,`barcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `alcoset1`
--

INSERT INTO `alcoset1` VALUES ('2280481231231','1','1',2900.00,0.700,NULL),('2280481231231','2','2',500.00,0.500,NULL);

--
-- Table structure for table `alcoset2`
--

CREATE TABLE `alcoset2` (
  `alcosetbarcode` varchar(100) NOT NULL,
  `code` varchar(100) NOT NULL,
  `barcode` varchar(100) NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `taracapacity` decimal(13,3) DEFAULT NULL,
  `quant` int DEFAULT NULL,
  PRIMARY KEY (`alcosetbarcode`,`barcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `alcoset2`
--


--
-- Temporary view structure for view `aspect`
--

/*!50001 DROP VIEW IF EXISTS `aspect`*/;
/*!50001 CREATE VIEW `aspect` AS SELECT 
 1 AS `aspectcode`,
 1 AS `aspectname`,
 1 AS `aspectorder`,
 1 AS `aspectschemecode`,
 1 AS `aspectvaluedesc`*/;

--
-- Table structure for table `aspect1`
--

CREATE TABLE `aspect1` (
  `aspectcode` varchar(30) NOT NULL,
  `aspectname` varchar(255) DEFAULT NULL,
  `aspectorder` int DEFAULT NULL,
  `aspectschemecode` int DEFAULT NULL,
  `aspectvaluedesc` int DEFAULT NULL,
  PRIMARY KEY (`aspectcode`),
  KEY `aspectschemecode` (`aspectschemecode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspect1`
--


--
-- Table structure for table `aspect2`
--

CREATE TABLE `aspect2` (
  `aspectcode` varchar(30) NOT NULL,
  `aspectname` varchar(255) DEFAULT NULL,
  `aspectorder` int DEFAULT NULL,
  `aspectschemecode` int DEFAULT NULL,
  `aspectvaluedesc` int DEFAULT NULL,
  PRIMARY KEY (`aspectcode`),
  KEY `aspectschemecode` (`aspectschemecode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspect2`
--


--
-- Temporary view structure for view `aspectscheme`
--

/*!50001 DROP VIEW IF EXISTS `aspectscheme`*/;
/*!50001 CREATE VIEW `aspectscheme` AS SELECT 
 1 AS `aspectschemecode`,
 1 AS `aspectschemename`*/;

--
-- Table structure for table `aspectscheme1`
--

CREATE TABLE `aspectscheme1` (
  `aspectschemecode` int NOT NULL AUTO_INCREMENT,
  `aspectschemename` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`aspectschemecode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspectscheme1`
--


--
-- Table structure for table `aspectscheme2`
--

CREATE TABLE `aspectscheme2` (
  `aspectschemecode` int NOT NULL AUTO_INCREMENT,
  `aspectschemename` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`aspectschemecode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspectscheme2`
--


--
-- Temporary view structure for view `aspectvalue`
--

/*!50001 DROP VIEW IF EXISTS `aspectvalue`*/;
/*!50001 CREATE VIEW `aspectvalue` AS SELECT 
 1 AS `aspectvaluecode`,
 1 AS `aspectvaluename`,
 1 AS `aspectcode`*/;

--
-- Table structure for table `aspectvalue1`
--

CREATE TABLE `aspectvalue1` (
  `aspectvaluecode` varchar(30) NOT NULL,
  `aspectvaluename` varchar(255) DEFAULT NULL,
  `aspectcode` varchar(30) NOT NULL,
  PRIMARY KEY (`aspectvaluecode`),
  KEY `aspectcode` (`aspectcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspectvalue1`
--


--
-- Table structure for table `aspectvalue2`
--

CREATE TABLE `aspectvalue2` (
  `aspectvaluecode` varchar(30) NOT NULL,
  `aspectvaluename` varchar(255) DEFAULT NULL,
  `aspectcode` varchar(30) NOT NULL,
  PRIMARY KEY (`aspectvaluecode`),
  KEY `aspectcode` (`aspectcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspectvalue2`
--


--
-- Temporary view structure for view `aspectvalueset`
--

/*!50001 DROP VIEW IF EXISTS `aspectvalueset`*/;
/*!50001 CREATE VIEW `aspectvalueset` AS SELECT 
 1 AS `aspectvaluesetcode`,
 1 AS `cquant`,
 1 AS `price`,
 1 AS `tmc_code`,
 1 AS `aspectschemecode`,
 1 AS `measure`,
 1 AS `remain`,
 1 AS `name`,
 1 AS `remaindate`,
 1 AS `packingprice`,
 1 AS `productsectioncode`*/;

--
-- Table structure for table `aspectvalueset1`
--

CREATE TABLE `aspectvalueset1` (
  `aspectvaluesetcode` int NOT NULL AUTO_INCREMENT,
  `cquant` decimal(19,2) DEFAULT NULL,
  `price` decimal(19,2) DEFAULT NULL,
  `tmc_code` varchar(255) DEFAULT NULL,
  `aspectschemecode` int DEFAULT NULL,
  `measure` int DEFAULT NULL,
  `remain` decimal(13,3) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `remaindate` datetime DEFAULT NULL,
  `packingprice` decimal(15,2) DEFAULT NULL,
  `productsectioncode` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`aspectvaluesetcode`),
  UNIQUE KEY `aspectvaluesetuniqueidx` (`tmc_code`,`productsectioncode`),
  KEY `aspectschemecode` (`aspectschemecode`),
  KEY `aspectvsidxprice` (`price`),
  KEY `aspectvaluesetidxtmc_code` (`tmc_code`),
  KEY `aspectvaluesetidxproductsectioncode` (`productsectioncode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspectvalueset1`
--


--
-- Table structure for table `aspectvalueset2`
--

CREATE TABLE `aspectvalueset2` (
  `aspectvaluesetcode` int NOT NULL AUTO_INCREMENT,
  `cquant` decimal(19,2) DEFAULT NULL,
  `price` decimal(19,2) DEFAULT NULL,
  `tmc_code` varchar(255) DEFAULT NULL,
  `aspectschemecode` int DEFAULT NULL,
  `measure` int DEFAULT NULL,
  `remain` decimal(13,3) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `remaindate` datetime DEFAULT NULL,
  `packingprice` decimal(15,2) DEFAULT NULL,
  `productsectioncode` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`aspectvaluesetcode`),
  UNIQUE KEY `aspectvaluesetuniqueidx` (`tmc_code`,`productsectioncode`),
  KEY `aspectschemecode` (`aspectschemecode`),
  KEY `aspectvsidxprice` (`price`),
  KEY `aspectvaluesetidxtmc_code` (`tmc_code`),
  KEY `aspectvaluesetidxproductsectioncode` (`productsectioncode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspectvalueset2`
--


--
-- Temporary view structure for view `aspectvaluesetvalues`
--

/*!50001 DROP VIEW IF EXISTS `aspectvaluesetvalues`*/;
/*!50001 CREATE VIEW `aspectvaluesetvalues` AS SELECT 
 1 AS `aspectcode`,
 1 AS `aspectvaluecode`,
 1 AS `aspectvaluesetcode`,
 1 AS `productsectioncode`,
 1 AS `tmc_code`*/;

--
-- Table structure for table `aspectvaluesetvalues1`
--

CREATE TABLE `aspectvaluesetvalues1` (
  `aspectcode` varchar(30) NOT NULL,
  `aspectvaluecode` varchar(30) NOT NULL,
  `aspectvaluesetcode` int NOT NULL,
  `productsectioncode` varchar(10) NOT NULL,
  `tmc_code` varchar(255) NOT NULL,
  PRIMARY KEY (`aspectcode`,`aspectvaluecode`,`aspectvaluesetcode`,`productsectioncode`,`tmc_code`),
  KEY `aspectcode` (`aspectcode`),
  KEY `aspectvaluecode` (`aspectvaluecode`),
  KEY `aspectvaluesetcode` (`aspectvaluesetcode`),
  KEY `aspectvaluesetvaluesidxproductsectioncode` (`productsectioncode`),
  KEY `aspectvaluesetvaluesidxtmc_code` (`tmc_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspectvaluesetvalues1`
--


--
-- Table structure for table `aspectvaluesetvalues2`
--

CREATE TABLE `aspectvaluesetvalues2` (
  `aspectcode` varchar(30) NOT NULL,
  `aspectvaluecode` varchar(30) NOT NULL,
  `aspectvaluesetcode` int NOT NULL,
  `productsectioncode` varchar(10) NOT NULL,
  `tmc_code` varchar(255) NOT NULL,
  PRIMARY KEY (`aspectcode`,`aspectvaluecode`,`aspectvaluesetcode`,`productsectioncode`,`tmc_code`),
  KEY `aspectcode` (`aspectcode`),
  KEY `aspectvaluecode` (`aspectvaluecode`),
  KEY `aspectvaluesetcode` (`aspectvaluesetcode`),
  KEY `aspectvaluesetvaluesidxproductsectioncode` (`productsectioncode`),
  KEY `aspectvaluesetvaluesidxtmc_code` (`tmc_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aspectvaluesetvalues2`
--


--
-- Temporary view structure for view `backreason`
--

/*!50001 DROP VIEW IF EXISTS `backreason`*/;
/*!50001 CREATE VIEW `backreason` AS SELECT 
 1 AS `code`,
 1 AS `reason`,
 1 AS `doctype`*/;

--
-- Table structure for table `backreason1`
--

CREATE TABLE `backreason1` (
  `code` int NOT NULL AUTO_INCREMENT,
  `reason` varchar(100) NOT NULL,
  `doctype` int DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `backreason1`
--


--
-- Table structure for table `backreason2`
--

CREATE TABLE `backreason2` (
  `code` int NOT NULL AUTO_INCREMENT,
  `reason` varchar(100) NOT NULL,
  `doctype` int DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `backreason2`
--


--
-- Temporary view structure for view `barcodes`
--

/*!50001 DROP VIEW IF EXISTS `barcodes`*/;
/*!50001 CREATE VIEW `barcodes` AS SELECT 
 1 AS `code`,
 1 AS `barcode`,
 1 AS `name`,
 1 AS `price`,
 1 AS `cquant`,
 1 AS `measure`,
 1 AS `aspectvaluesetcode`,
 1 AS `quantdefault`,
 1 AS `packingmeasure`,
 1 AS `packingprice`,
 1 AS `minprice`,
 1 AS `minretailprice`,
 1 AS `customsdeclarationnumber`,
 1 AS `tmctype`,
 1 AS `ntin`,
 1 AS `packagecode`*/;

--
-- Table structure for table `barcodes1`
--

CREATE TABLE `barcodes1` (
  `code` varchar(100) NOT NULL,
  `barcode` varchar(100) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `price` decimal(15,2) DEFAULT NULL,
  `cquant` decimal(13,3) DEFAULT NULL,
  `measure` int DEFAULT NULL,
  `aspectvaluesetcode` int DEFAULT NULL,
  `quantdefault` decimal(13,3) DEFAULT NULL,
  `packingmeasure` int DEFAULT NULL,
  `packingprice` decimal(15,2) DEFAULT NULL,
  `minprice` decimal(13,2) DEFAULT NULL,
  `minretailprice` decimal(13,2) DEFAULT NULL,
  `customsdeclarationnumber` varchar(32) DEFAULT NULL,
  `tmctype` int DEFAULT NULL,
  `ntin` varchar(255) DEFAULT NULL,
  `packagecode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`barcode`),
  KEY `barcodesidxcode` (`code`),
  KEY `barcodesidxprice` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `barcodes1`
--

INSERT INTO `barcodes1` VALUES ('1000001','1000001','Подарочная карта 500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000002','1000002','Подарочная карта 1000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000003','1000003','Подарочная карта 2000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000004','1000004','Подарочная карта 5000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000005','1000005','Пакет подарочный \"Для тебя\" , 31*26*12СМ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000006','1000006','Пакет подарочный \"Цветы и бабочки\" , 31*26*12СМ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000007','1000007','Пакет подарочный \"Hello Spring\" ,  31*26*12СМ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000008','1000008','Пакет подарочный \"Для тебя\" ,  31*26*12СМ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000009','1000009','Футболка поло колор блок с коротким рукавом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000010','1000010','Футболка оверсайз силуэт из хлопка с принтом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000011','1000011','Футболка поло с коротким рукавом и принтом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000012','1000012','Футболка из хлопка с коротким рукавом и надписью',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000013','1000013','Футболка из хлопка с вырезом сердечко со стразами',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000014','1000014','Лонгслив из полупрозрачной сетки с фактурным узором с драконами',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000015','1000015','Трикотажный джемпер оверсайз в полоску с укороченным рукавом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000016','1000016','Свитшот с фактурным узором и укороченными рукавами',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000017','1000017','Короткая вязаная шапка-бини из хлопка с отворотом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000018','1000018','Трикотажная шапка-бини с отворотом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000019','1000019','Короткая вязаная шапка-бини из хлопка с отворотом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000020','1000020','Трикотажная шапка-бини с отворотом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000021','1000021','Тёплые перчатки в спортивном стиле на синтепоне с флисом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000022','1000022','Текстильный ремень с пряжкой',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000023','1000023','Ремень из экокожи',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000024','1000024','Поясная сумка из экокожи',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000025','1000025','Тёплая укороченная куртка с высоким воротником',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000026','1000026','Жилет прямого силуэта из вязаного трикотажа с узором',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000027','1000027','Тонкий вязаный джемпер из хлопка в полоску',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000028','1000028','Тёплая куртка с капюшоном на синтепоне',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000029','1000029','Джинсовая куртка-рубашка из хлопка на кнопках',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000030','1000030','Утеплённая трикотажная куртка-рубашка с начёсом',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000031','1000031','Новогодняя шапка-бини с лампочками и помпоном',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000032','1000032','Бейсболка из хлопка с полукруглым козырьком',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1000033','1000033','Тёплая шапка-ушанка на синтепоне',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `barcodes2`
--

CREATE TABLE `barcodes2` (
  `code` varchar(100) NOT NULL,
  `barcode` varchar(100) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `price` decimal(15,2) DEFAULT NULL,
  `cquant` decimal(13,3) DEFAULT NULL,
  `measure` int DEFAULT NULL,
  `aspectvaluesetcode` int DEFAULT NULL,
  `quantdefault` decimal(13,3) DEFAULT NULL,
  `packingmeasure` int DEFAULT NULL,
  `packingprice` decimal(15,2) DEFAULT NULL,
  `minprice` decimal(13,2) DEFAULT NULL,
  `minretailprice` decimal(13,2) DEFAULT NULL,
  `customsdeclarationnumber` varchar(32) DEFAULT NULL,
  `tmctype` int DEFAULT NULL,
  `ntin` varchar(255) DEFAULT NULL,
  `packagecode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`barcode`),
  KEY `barcodesidxcode` (`code`),
  KEY `barcodesidxprice` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `barcodes2`
--


--
-- Temporary view structure for view `button`
--

/*!50001 DROP VIEW IF EXISTS `button`*/;
/*!50001 CREATE VIEW `button` AS SELECT 
 1 AS `code`,
 1 AS `name`,
 1 AS `tag`,
 1 AS `rateobject`,
 1 AS `ratetype`,
 1 AS `ratevalue`,
 1 AS `maxratevalue`,
 1 AS `minratevalue`*/;

--
-- Table structure for table `button1`
--

CREATE TABLE `button1` (
  `code` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `tag` varchar(100) DEFAULT NULL,
  `rateobject` int NOT NULL,
  `ratetype` int NOT NULL,
  `ratevalue` decimal(15,2) DEFAULT NULL,
  `maxratevalue` decimal(15,2) DEFAULT NULL,
  `minratevalue` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `button1`
--

INSERT INTO `button1` VALUES (1,'Скидка по кнопке',NULL,0,0,5.00,NULL,NULL);

--
-- Table structure for table `button2`
--

CREATE TABLE `button2` (
  `code` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `tag` varchar(100) DEFAULT NULL,
  `rateobject` int NOT NULL,
  `ratetype` int NOT NULL,
  `ratevalue` decimal(15,2) DEFAULT NULL,
  `maxratevalue` decimal(15,2) DEFAULT NULL,
  `minratevalue` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `button2`
--


--
-- Temporary view structure for view `campaign`
--

/*!50001 DROP VIEW IF EXISTS `campaign`*/;
/*!50001 CREATE VIEW `campaign` AS SELECT 
 1 AS `campaignid`,
 1 AS `name`*/;

--
-- Table structure for table `campaign1`
--

CREATE TABLE `campaign1` (
  `campaignid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`campaignid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `campaign1`
--


--
-- Table structure for table `campaign2`
--

CREATE TABLE `campaign2` (
  `campaignid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`campaignid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `campaign2`
--


--
-- Temporary view structure for view `card`
--

/*!50001 DROP VIEW IF EXISTS `card`*/;
/*!50001 CREATE VIEW `card` AS SELECT 
 1 AS `idcard`,
 1 AS `idcardgroup`,
 1 AS `idclient`,
 1 AS `number`,
 1 AS `validitydatebeg`,
 1 AS `validitydateend`,
 1 AS `cardSum`,
 1 AS `blocked`,
 1 AS `lastknownbonusbalance`,
 1 AS `lastknownbonusbalancedate`,
 1 AS `multiplicator`,
 1 AS `multiplicatorbeg`,
 1 AS `multiplicatorend`,
 1 AS `multiplicatorcurrent`,
 1 AS `discountpercent`,
 1 AS `purchases`,
 1 AS `pincode`,
 1 AS `cardstatus`,
 1 AS `shopcode`,
 1 AS `options`*/;

--
-- Table structure for table `card1`
--

CREATE TABLE `card1` (
  `idcard` varchar(100) NOT NULL,
  `idcardgroup` int DEFAULT NULL,
  `idclient` varchar(100) DEFAULT NULL,
  `number` varchar(200) DEFAULT NULL,
  `validitydatebeg` date DEFAULT NULL,
  `validitydateend` date DEFAULT NULL,
  `cardSum` decimal(20,2) DEFAULT NULL,
  `blocked` int DEFAULT NULL,
  `lastknownbonusbalance` decimal(15,2) DEFAULT NULL,
  `lastknownbonusbalancedate` datetime DEFAULT NULL,
  `multiplicator` decimal(15,2) DEFAULT NULL,
  `multiplicatorbeg` datetime DEFAULT NULL,
  `multiplicatorend` datetime DEFAULT NULL,
  `multiplicatorcurrent` decimal(15,2) DEFAULT NULL,
  `discountpercent` decimal(5,2) DEFAULT NULL,
  `purchases` int DEFAULT NULL,
  `pincode` varchar(100) DEFAULT NULL,
  `cardstatus` int DEFAULT NULL,
  `shopcode` varchar(255) DEFAULT NULL,
  `options` int DEFAULT NULL,
  PRIMARY KEY (`idcard`),
  UNIQUE KEY `cardnumber` (`number`),
  KEY `cardidcardgroup` (`idcardgroup`),
  KEY `cardidclient` (`idclient`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `card1`
--

INSERT INTO `card1` VALUES ('4029893e93b9e4e70193b9e5cab60002',NULL,NULL,'111',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `card2`
--

CREATE TABLE `card2` (
  `idcard` varchar(100) NOT NULL,
  `idcardgroup` int DEFAULT NULL,
  `idclient` varchar(100) DEFAULT NULL,
  `number` varchar(200) DEFAULT NULL,
  `validitydatebeg` date DEFAULT NULL,
  `validitydateend` date DEFAULT NULL,
  `cardSum` decimal(20,2) DEFAULT NULL,
  `blocked` int DEFAULT NULL,
  `lastknownbonusbalance` decimal(15,2) DEFAULT NULL,
  `lastknownbonusbalancedate` datetime DEFAULT NULL,
  `multiplicator` decimal(15,2) DEFAULT NULL,
  `multiplicatorbeg` datetime DEFAULT NULL,
  `multiplicatorend` datetime DEFAULT NULL,
  `multiplicatorcurrent` decimal(15,2) DEFAULT NULL,
  `discountpercent` decimal(5,2) DEFAULT NULL,
  `purchases` int DEFAULT NULL,
  `pincode` varchar(100) DEFAULT NULL,
  `cardstatus` int DEFAULT NULL,
  `shopcode` varchar(255) DEFAULT NULL,
  `options` int DEFAULT NULL,
  PRIMARY KEY (`idcard`),
  UNIQUE KEY `cardnumber` (`number`),
  KEY `cardidcardgroup` (`idcardgroup`),
  KEY `cardidclient` (`idclient`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `card2`
--


--
-- Temporary view structure for view `cardgroup`
--

/*!50001 DROP VIEW IF EXISTS `cardgroup`*/;
/*!50001 CREATE VIEW `cardgroup` AS SELECT 
 1 AS `idcardgroup`,
 1 AS `name`,
 1 AS `text`,
 1 AS `cardmode`,
 1 AS `prefixbeg`,
 1 AS `prefixend`,
 1 AS `lenbeg`,
 1 AS `lenend`,
 1 AS `regexpattern`,
 1 AS `inputmask`,
 1 AS `regexrule`,
 1 AS `valutcode`,
 1 AS `discounttype`,
 1 AS `discountvalue`,
 1 AS `bonususecase`,
 1 AS `showinfo`,
 1 AS `notaddemptycard`,
 1 AS `printinfo`,
 1 AS `additionalregistration`,
 1 AS `searchrule`,
 1 AS `userawdata`,
 1 AS `options`*/;

--
-- Table structure for table `cardgroup1`
--

CREATE TABLE `cardgroup1` (
  `idcardgroup` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `text` varchar(200) DEFAULT NULL,
  `cardmode` int DEFAULT NULL,
  `prefixbeg` varchar(200) DEFAULT NULL,
  `prefixend` varchar(200) DEFAULT NULL,
  `lenbeg` int DEFAULT NULL,
  `lenend` int DEFAULT NULL,
  `regexpattern` varchar(200) DEFAULT NULL,
  `inputmask` int DEFAULT NULL,
  `regexrule` varchar(200) DEFAULT NULL,
  `valutcode` int DEFAULT NULL,
  `discounttype` int DEFAULT NULL,
  `discountvalue` decimal(5,2) DEFAULT NULL,
  `bonususecase` int DEFAULT NULL,
  `showinfo` tinyint(1) DEFAULT NULL,
  `notaddemptycard` int DEFAULT NULL,
  `printinfo` tinyint(1) DEFAULT NULL,
  `additionalregistration` int DEFAULT NULL,
  `searchrule` int DEFAULT NULL,
  `userawdata` tinyint(1) DEFAULT NULL,
  `options` int DEFAULT NULL,
  PRIMARY KEY (`idcardgroup`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cardgroup1`
--

INSERT INTO `cardgroup1` VALUES (1,'Карта с магнитной полосой','Карта с магнитной полосой',0,NULL,NULL,NULL,NULL,';([0-9]+)\\?',4,'\\1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Карта со штрих-кодом','Карта с штрих-кодом',0,NULL,NULL,0,0,'[0-9]+',31,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `cardgroup2`
--

CREATE TABLE `cardgroup2` (
  `idcardgroup` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `text` varchar(200) DEFAULT NULL,
  `cardmode` int DEFAULT NULL,
  `prefixbeg` varchar(200) DEFAULT NULL,
  `prefixend` varchar(200) DEFAULT NULL,
  `lenbeg` int DEFAULT NULL,
  `lenend` int DEFAULT NULL,
  `regexpattern` varchar(200) DEFAULT NULL,
  `inputmask` int DEFAULT NULL,
  `regexrule` varchar(200) DEFAULT NULL,
  `valutcode` int DEFAULT NULL,
  `discounttype` int DEFAULT NULL,
  `discountvalue` decimal(5,2) DEFAULT NULL,
  `bonususecase` int DEFAULT NULL,
  `showinfo` tinyint(1) DEFAULT NULL,
  `notaddemptycard` int DEFAULT NULL,
  `printinfo` tinyint(1) DEFAULT NULL,
  `additionalregistration` int DEFAULT NULL,
  `searchrule` int DEFAULT NULL,
  `userawdata` tinyint(1) DEFAULT NULL,
  `options` int DEFAULT NULL,
  PRIMARY KEY (`idcardgroup`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cardgroup2`
--


--
-- Temporary view structure for view `cardgroupverification`
--

/*!50001 DROP VIEW IF EXISTS `cardgroupverification`*/;
/*!50001 CREATE VIEW `cardgroupverification` AS SELECT 
 1 AS `idcardgroup`,
 1 AS `idverification`,
 1 AS `inputsource`,
 1 AS `extraverification`*/;

--
-- Table structure for table `cardgroupverification1`
--

CREATE TABLE `cardgroupverification1` (
  `idcardgroup` int NOT NULL,
  `idverification` int NOT NULL,
  `inputsource` int NOT NULL,
  `extraverification` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`idcardgroup`,`idverification`,`inputsource`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cardgroupverification1`
--


--
-- Table structure for table `cardgroupverification2`
--

CREATE TABLE `cardgroupverification2` (
  `idcardgroup` int NOT NULL,
  `idverification` int NOT NULL,
  `inputsource` int NOT NULL,
  `extraverification` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`idcardgroup`,`idverification`,`inputsource`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cardgroupverification2`
--


--
-- Temporary view structure for view `cashconfig`
--

/*!50001 DROP VIEW IF EXISTS `cashconfig`*/;
/*!50001 CREATE VIEW `cashconfig` AS SELECT 
 1 AS `name`,
 1 AS `value`*/;

--
-- Table structure for table `cashconfig1`
--

CREATE TABLE `cashconfig1` (
  `name` varchar(100) NOT NULL,
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cashconfig1`
--


--
-- Table structure for table `cashconfig2`
--

CREATE TABLE `cashconfig2` (
  `name` varchar(100) NOT NULL,
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cashconfig2`
--


--
-- Temporary view structure for view `catalog`
--

/*!50001 DROP VIEW IF EXISTS `catalog`*/;
/*!50001 CREATE VIEW `catalog` AS SELECT 
 1 AS `catalogid`,
 1 AS `catalogname`,
 1 AS `image`,
 1 AS `type`*/;

--
-- Table structure for table `catalog1`
--

CREATE TABLE `catalog1` (
  `catalogid` int NOT NULL AUTO_INCREMENT,
  `catalogname` varchar(100) DEFAULT NULL,
  `image` text,
  `type` int DEFAULT NULL,
  PRIMARY KEY (`catalogid`)
) ENGINE=InnoDB AUTO_INCREMENT=1913973963 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `catalog1`
--

INSERT INTO `catalog1` VALUES (1913973962,'СИЗ',NULL,NULL);

--
-- Table structure for table `catalog2`
--

CREATE TABLE `catalog2` (
  `catalogid` int NOT NULL AUTO_INCREMENT,
  `catalogname` varchar(100) DEFAULT NULL,
  `image` text,
  `type` int DEFAULT NULL,
  PRIMARY KEY (`catalogid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `catalog2`
--


--
-- Temporary view structure for view `catalogattribute`
--

/*!50001 DROP VIEW IF EXISTS `catalogattribute`*/;
/*!50001 CREATE VIEW `catalogattribute` AS SELECT 
 1 AS `catalogid`,
 1 AS `alcoholpercent`,
 1 AS `age`,
 1 AS `attribute`,
 1 AS `egaistype`*/;

--
-- Table structure for table `catalogattribute1`
--

CREATE TABLE `catalogattribute1` (
  `catalogid` int NOT NULL AUTO_INCREMENT,
  `alcoholpercent` decimal(4,2) DEFAULT NULL,
  `age` int DEFAULT NULL,
  `attribute` int NOT NULL,
  `egaistype` int DEFAULT NULL,
  PRIMARY KEY (`catalogid`)
) ENGINE=InnoDB AUTO_INCREMENT=1913973963 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `catalogattribute1`
--

INSERT INTO `catalogattribute1` VALUES (1913973962,NULL,NULL,7,NULL);

--
-- Table structure for table `catalogattribute2`
--

CREATE TABLE `catalogattribute2` (
  `catalogid` int NOT NULL AUTO_INCREMENT,
  `alcoholpercent` decimal(4,2) DEFAULT NULL,
  `age` int DEFAULT NULL,
  `attribute` int NOT NULL,
  `egaistype` int DEFAULT NULL,
  PRIMARY KEY (`catalogid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `catalogattribute2`
--


--
-- Temporary view structure for view `catalogrestrict`
--

/*!50001 DROP VIEW IF EXISTS `catalogrestrict`*/;
/*!50001 CREATE VIEW `catalogrestrict` AS SELECT 
 1 AS `catalogid`,
 1 AS `deptcode`,
 1 AS `restrictid`,
 1 AS `id`*/;

--
-- Table structure for table `catalogrestrict1`
--

CREATE TABLE `catalogrestrict1` (
  `catalogid` int DEFAULT NULL,
  `deptcode` int DEFAULT NULL,
  `restrictid` int NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `catalogrestrictidx` (`catalogid`,`deptcode`,`restrictid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `catalogrestrict1`
--


--
-- Table structure for table `catalogrestrict2`
--

CREATE TABLE `catalogrestrict2` (
  `catalogid` int DEFAULT NULL,
  `deptcode` int DEFAULT NULL,
  `restrictid` int NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `catalogrestrictidx` (`catalogid`,`deptcode`,`restrictid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `catalogrestrict2`
--


--
-- Temporary view structure for view `category`
--

/*!50001 DROP VIEW IF EXISTS `category`*/;
/*!50001 CREATE VIEW `category` AS SELECT 
 1 AS `categoryid`,
 1 AS `agentcode`,
 1 AS `categorycode`,
 1 AS `name`*/;

--
-- Table structure for table `category1`
--

CREATE TABLE `category1` (
  `categoryid` int NOT NULL AUTO_INCREMENT,
  `agentcode` varchar(100) NOT NULL,
  `categorycode` varchar(100) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `category1`
--


--
-- Table structure for table `category2`
--

CREATE TABLE `category2` (
  `categoryid` int NOT NULL AUTO_INCREMENT,
  `agentcode` varchar(100) NOT NULL,
  `categorycode` varchar(100) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `category2`
--


--
-- Temporary view structure for view `certificate`
--

/*!50001 DROP VIEW IF EXISTS `certificate`*/;
/*!50001 CREATE VIEW `certificate` AS SELECT 
 1 AS `code`,
 1 AS `rangefrom`,
 1 AS `rangeto`,
 1 AS `name`,
 1 AS `sum`,
 1 AS `inputmask`,
 1 AS `fullyspend`,
 1 AS `skiplastsymbol`,
 1 AS `tmccode`,
 1 AS `minsum`,
 1 AS `maxsum`,
 1 AS `multiplesum`,
 1 AS `deptcode`,
 1 AS `vatcode`,
 1 AS `paymentobject`,
 1 AS `regexpattern`,
 1 AS `discountcampaign`*/;

--
-- Table structure for table `certificate1`
--

CREATE TABLE `certificate1` (
  `code` varchar(100) NOT NULL,
  `rangefrom` decimal(20,0) NOT NULL,
  `rangeto` decimal(20,0) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `sum` decimal(20,2) DEFAULT NULL,
  `inputmask` int NOT NULL,
  `fullyspend` int DEFAULT NULL,
  `skiplastsymbol` int DEFAULT NULL,
  `tmccode` varchar(30) DEFAULT NULL,
  `minsum` decimal(13,2) DEFAULT NULL,
  `maxsum` decimal(13,2) DEFAULT NULL,
  `multiplesum` decimal(13,2) DEFAULT NULL,
  `deptcode` int DEFAULT NULL,
  `vatcode` int DEFAULT NULL,
  `paymentobject` int DEFAULT NULL,
  `regexpattern` varchar(50) DEFAULT NULL,
  `discountcampaign` text,
  PRIMARY KEY (`code`),
  KEY `certificateidxrangefrom` (`rangefrom`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `certificate1`
--


--
-- Table structure for table `certificate2`
--

CREATE TABLE `certificate2` (
  `code` varchar(100) NOT NULL,
  `rangefrom` decimal(20,0) NOT NULL,
  `rangeto` decimal(20,0) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `sum` decimal(20,2) DEFAULT NULL,
  `inputmask` int NOT NULL,
  `fullyspend` int DEFAULT NULL,
  `skiplastsymbol` int DEFAULT NULL,
  `tmccode` varchar(30) DEFAULT NULL,
  `minsum` decimal(13,2) DEFAULT NULL,
  `maxsum` decimal(13,2) DEFAULT NULL,
  `multiplesum` decimal(13,2) DEFAULT NULL,
  `deptcode` int DEFAULT NULL,
  `vatcode` int DEFAULT NULL,
  `paymentobject` int DEFAULT NULL,
  `regexpattern` varchar(50) DEFAULT NULL,
  `discountcampaign` text,
  PRIMARY KEY (`code`),
  KEY `certificateidxrangefrom` (`rangefrom`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `certificate2`
--


--
-- Temporary view structure for view `client`
--

/*!50001 DROP VIEW IF EXISTS `client`*/;
/*!50001 CREATE VIEW `client` AS SELECT 
 1 AS `idclient`,
 1 AS `name`,
 1 AS `text`,
 1 AS `sex`,
 1 AS `birthday`,
 1 AS `specialdate1`,
 1 AS `specialdate2`,
 1 AS `specialdate3`,
 1 AS `specialdate1name`,
 1 AS `specialdate2name`,
 1 AS `specialdate3name`,
 1 AS `zipcode`,
 1 AS `address`,
 1 AS `email`,
 1 AS `webpage`,
 1 AS `phonenumber`,
 1 AS `inn`,
 1 AS `document`,
 1 AS `okpo`,
 1 AS `okpd`,
 1 AS `occupation`,
 1 AS `childrencount`,
 1 AS `extendedoptions`,
 1 AS `organizationcode`,
 1 AS `options`,
 1 AS `lastname`,
 1 AS `patronymic`,
 1 AS `communications`*/;

--
-- Table structure for table `client1`
--

CREATE TABLE `client1` (
  `idclient` varchar(100) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `text` varchar(200) DEFAULT NULL,
  `sex` int DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `specialdate1` date DEFAULT NULL,
  `specialdate2` date DEFAULT NULL,
  `specialdate3` date DEFAULT NULL,
  `specialdate1name` varchar(200) DEFAULT NULL,
  `specialdate2name` varchar(200) DEFAULT NULL,
  `specialdate3name` varchar(200) DEFAULT NULL,
  `zipcode` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `webpage` varchar(200) DEFAULT NULL,
  `phonenumber` varchar(200) DEFAULT NULL,
  `inn` varchar(200) DEFAULT NULL,
  `document` varchar(200) DEFAULT NULL,
  `okpo` varchar(200) DEFAULT NULL,
  `okpd` varchar(200) DEFAULT NULL,
  `occupation` varchar(200) DEFAULT NULL,
  `childrencount` int DEFAULT NULL,
  `extendedoptions` text,
  `organizationcode` varchar(255) DEFAULT NULL,
  `options` int DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `patronymic` varchar(255) DEFAULT NULL,
  `communications` int DEFAULT NULL,
  PRIMARY KEY (`idclient`),
  KEY `clientphonenumber` (`phonenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `client1`
--


--
-- Table structure for table `client2`
--

CREATE TABLE `client2` (
  `idclient` varchar(100) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `text` varchar(200) DEFAULT NULL,
  `sex` int DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `specialdate1` date DEFAULT NULL,
  `specialdate2` date DEFAULT NULL,
  `specialdate3` date DEFAULT NULL,
  `specialdate1name` varchar(200) DEFAULT NULL,
  `specialdate2name` varchar(200) DEFAULT NULL,
  `specialdate3name` varchar(200) DEFAULT NULL,
  `zipcode` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `webpage` varchar(200) DEFAULT NULL,
  `phonenumber` varchar(200) DEFAULT NULL,
  `inn` varchar(200) DEFAULT NULL,
  `document` varchar(200) DEFAULT NULL,
  `okpo` varchar(200) DEFAULT NULL,
  `okpd` varchar(200) DEFAULT NULL,
  `occupation` varchar(200) DEFAULT NULL,
  `childrencount` int DEFAULT NULL,
  `extendedoptions` text,
  `organizationcode` varchar(255) DEFAULT NULL,
  `options` int DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `patronymic` varchar(255) DEFAULT NULL,
  `communications` int DEFAULT NULL,
  PRIMARY KEY (`idclient`),
  KEY `clientphonenumber` (`phonenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `client2`
--


--
-- Temporary view structure for view `clientcardmask`
--

/*!50001 DROP VIEW IF EXISTS `clientcardmask`*/;
/*!50001 CREATE VIEW `clientcardmask` AS SELECT 
 1 AS `clientcardmaskid`,
 1 AS `agentcode`,
 1 AS `mask`,
 1 AS `transform`*/;

--
-- Table structure for table `clientcardmask1`
--

CREATE TABLE `clientcardmask1` (
  `clientcardmaskid` int NOT NULL AUTO_INCREMENT,
  `agentcode` varchar(255) NOT NULL,
  `mask` varchar(255) DEFAULT NULL,
  `transform` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`clientcardmaskid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `clientcardmask1`
--


--
-- Table structure for table `clientcardmask2`
--

CREATE TABLE `clientcardmask2` (
  `clientcardmaskid` int NOT NULL AUTO_INCREMENT,
  `agentcode` varchar(255) NOT NULL,
  `mask` varchar(255) DEFAULT NULL,
  `transform` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`clientcardmaskid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `clientcardmask2`
--


--
-- Temporary view structure for view `cmaction`
--

/*!50001 DROP VIEW IF EXISTS `cmaction`*/;
/*!50001 CREATE VIEW `cmaction` AS SELECT 
 1 AS `cmactioncode`,
 1 AS `cmactionname`,
 1 AS `commandcode`,
 1 AS `logmode`,
 1 AS `notshowinservicemenu`*/;

--
-- Table structure for table `cmaction1`
--

CREATE TABLE `cmaction1` (
  `cmactioncode` int NOT NULL AUTO_INCREMENT,
  `cmactionname` varchar(255) DEFAULT NULL,
  `commandcode` int DEFAULT NULL,
  `logmode` int NOT NULL DEFAULT '0',
  `notshowinservicemenu` int DEFAULT NULL,
  PRIMARY KEY (`cmactioncode`)
) ENGINE=InnoDB AUTO_INCREMENT=290 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cmaction1`
--

INSERT INTO `cmaction1` VALUES (1,'Главное меню',3,0,1),(2,'Выход в меню',1,0,NULL),(3,'Блокировка кассы',2,1,NULL),(6,'Монитор кассира (продажа)',4,0,NULL),(7,'Режим \"Продажа\"',5,0,NULL),(8,'Режим \"Возврат\"',6,1,NULL),(9,'Изменить количество',7,1,NULL),(10,'Изменить цену',8,1,NULL),(11,'Ввод по штрих-коду',9,0,NULL),(12,'Ввод по коду',10,0,NULL),(14,'Изменить отдел',11,0,NULL),(15,'Сторно текущей позиции',12,1,NULL),(16,'Сторно всех позиций',13,1,NULL),(18,'Применить модификаторы к позиции',15,1,NULL),(19,'Продажа в отдел',16,0,NULL),(22,'Взвесить',18,0,NULL),(23,'Печать копии чека',19,0,NULL),(24,'Печать товарного чека',20,0,NULL),(25,'Информация о карте',21,0,NULL),(28,'Информация о товаре (по штрих-коду)',22,1,NULL),(29,'Выбрать по штрих-коду',23,0,NULL),(30,'Расфасовка',24,0,NULL),(33,'Открыть денежный ящик',27,1,NULL),(34,'Калькулятор',28,0,NULL),(35,'Итог',29,0,NULL),(37,'Выбрать тип оплаты',30,0,NULL),(49,'Почековая выгрузка',49,0,NULL),(50,'Карта: добавить',42,0,NULL),(53,'Внесение денег',92,0,1),(54,'Выем денег',93,0,1),(55,'Операции с деньгами',3,0,1),(56,'Выход',46,0,1),(59,'Просмотр документа',48,0,NULL),(60,'Отчеты',3,0,1),(62,'X отчет (ФР)',49,0,1),(63,'Z отчет (ФР)',49,0,1),(64,'Отчет по отделам (ФР)',49,0,1),(65,'X отчет',49,0,1),(68,'Закрытие смены',50,0,1),(69,'Тест табло покупателя',52,0,1),(70,'Тест денежного ящика',55,0,1),(71,'Тест устройств ввода',54,0,1),(72,'Тест ККМ',53,0,1),(74,'Z отчет',49,0,1),(75,'Отчет по отделам',49,0,1),(76,'Отчет по сторно',49,0,1),(77,'Отчет по сторно (текущая смена)',49,0,1),(78,'Обслуживание системы',49,0,1),(79,'Сверка итогов по безналу',56,0,1),(87,'Добавить оплату в чеке',58,0,NULL),(90,'Режим \"Инвентаризация\"',61,0,NULL),(92,'Скидка по кнопке',63,0,NULL),(94,'Документ: аннулировать',65,0,1),(95,'Документ: аннулировать последний',65,0,1),(99,'Информация о товаре (по наименованию)',70,0,NULL),(101,'Подытог',72,0,NULL),(103,'Карта: удалить',74,0,NULL),(106,'Возврат по чеку продажи',77,0,NULL),(111,'Выбрать по наименованию',82,0,NULL),(112,'Выбрать по коду',83,0,NULL),(113,'Информация о товаре (по коду)',84,0,NULL),(115,'Сумма в денежном ящике',86,1,NULL),(116,'Отложить чек',87,0,NULL),(117,'Восстановить чек',88,0,NULL),(121,'Выгрузка продаж',49,0,1),(122,'Ввод',90,0,1),(131,'Сформировать файл продаж',49,0,1),(133,'Выгрузка продаж в КС',49,0,1),(182,'Документы',3,0,1),(183,'Сверка итогов',3,0,NULL),(184,'Печать отчета по безналу',94,0,1),(185,'Сервис',3,0,NULL),(186,'Вход в тренировочный режим',95,0,NULL),(187,'Выход из тренировочного режима',96,0,NULL),(189,'Вызвать меню \"Сервис\"',97,0,1),(190,'О программе',98,0,NULL),(191,'Оплатить бонусами',99,0,NULL),(192,'Выбрать по цене',100,0,NULL),(193,'Выбрать по артикулу',101,0,NULL),(194,'Информация о товаре (по цене)',102,0,NULL),(195,'Информация о товаре (по артикулу)',103,0,NULL),(196,'Встроенный браузер',104,0,1),(197,'Горячая клавиша №1',105,0,1),(198,'Подытог по карте',106,0,NULL),(199,'Завершение работы',3,0,NULL),(200,'Отмена',46,0,NULL),(201,'Перезагрузить кассу',107,0,NULL),(202,'Перезапустить программу',108,0,NULL),(203,'Выключить кассу',109,0,NULL),(204,'Отчет по бонусам',49,0,1),(205,'Журнал учета алкогольной продукции',136,0,1),(206,'Обязательный выем денежных средств',137,0,1),(207,'Баланс банковской карты',138,0,NULL),(208,'Удалить купоны',139,0,NULL),(209,'Режим \"Возврат поставщику\"',140,0,NULL),(210,'Тест оборудования',3,0,NULL),(211,'Выбрать скидку из списка',141,0,NULL),(212,'Отменить скидки выбранные вручную',142,0,NULL),(214,'Выбор консультанта из списка',143,0,NULL),(215,'Тест весов',145,0,1),(216,'Назначить консультанта на свободные позиции',146,0,1),(217,'Добавить адрес покупателя',147,0,1),(218,'Отключить контроль финансовых операций',148,0,1),(219,'Просмотр электронного журнала',149,0,NULL),(220,'Выем без участия кассира',150,0,NULL),(221,'Лицензионное соглашение',152,1,NULL),(222,'Отчет по налогам (ФР)',49,0,1),(223,'Авторасчет социальных товаров',153,0,NULL),(224,'Пометка позиции как \'социальная\'',154,0,NULL),(225,'Печать копии фискального документа',155,0,NULL),(226,'Получить информацию по сертификату',156,0,NULL),(227,'ESC',159,0,NULL),(228,'Подбор товара по нескольким параметрам',160,0,NULL),(229,'Коррекция прихода',162,0,NULL),(230,'Коррекция расхода',163,0,NULL),(231,'Отчет по кассирам',49,0,1),(232,'Просмотр информации по нескольким параметрам',166,0,NULL),(233,'Ввести 00',167,0,NULL),(234,'Печать счета-фактуры',168,0,NULL),(235,'Просмотр отложенных чеков',169,0,NULL),(236,'Отрезка бумаги',170,0,NULL),(237,'Восстановить онлайн-чек',171,0,NULL),(242,'Софт-чек',176,0,NULL),(244,'Возврат с указанной суммой в отдел',178,0,1),(245,'Работа с ТТН (ЕГАИС)',179,0,1),(246,'Выбор товара из каталога',181,0,NULL),(247,'Добавление сертификата',151,0,NULL),(248,'Открыть смену',144,0,1),(250,'Выбор причины коррекции',165,0,1),(251,'Выбор типа коррекции',164,0,1),(252,'Выйти из текущей страницы панели действий',158,0,1),(254,'Макрос',59,0,1),(255,'Ввод информации о владельце карты лояльности',161,0,1),(256,'Переключить страницу панели действий',157,0,1),(257,'Тест отрезчика ФР',170,0,1),(258,'Замена карты',182,0,1),(259,'Регистрация лотерейного билета',183,0,1),(260,'Печать краткого отчета по безналу',184,0,1),(261,'Проверка связи с пинпадом',185,0,1),(262,'Печать копии слипа',186,0,1),(263,'Выдача карты',187,0,1),(264,'Просмотр остатков товара',188,0,1),(265,'Добавить купон',189,0,1),(266,'Покупюрная ведомость',190,0,1),(267,'Информация о лицензии',192,0,NULL),(268,'Выбор лекарства',193,0,NULL),(269,'Изменение типа кассы',194,0,NULL),(270,'Заказать лекарства',195,0,NULL),(271,'Печать последнего документа из ФН',49,0,1),(272,'Изменение языка',196,0,NULL),(273,'Создание карты',197,0,NULL),(274,'Просмотр онлайн-заказов',198,0,0),(275,'Просмотр онлайн-заказов из резерва',199,0,NULL),(276,'Просмотр электронных рецептов',200,0,NULL),(277,'Показать прайс-лист',201,0,NULL),(278,'Тест QR-дисплея',202,0,NULL),(279,'Согласование онлайн-чека',204,0,NULL),(280,'Замена товара в онлайн-чеке',205,0,NULL),(281,'Печать копии отчета',206,0,NULL),(282,'Выдача наличных',207,1,NULL),(283,'Переключиться на тач панель Карта',157,1,1),(284,'Переключиться на тач панель Чек',157,1,1),(285,'Горячая клавиша №2 (большой пакет)',105,0,1),(286,'Боковая панель',3,0,NULL),(287,'Оплата наличными',30,1,1),(288,'Оплата СберБанк',30,1,1),(289,'Оплата СБП',30,1,1);

--
-- Table structure for table `cmaction2`
--

CREATE TABLE `cmaction2` (
  `cmactioncode` int NOT NULL AUTO_INCREMENT,
  `cmactionname` varchar(255) DEFAULT NULL,
  `commandcode` int DEFAULT NULL,
  `logmode` int NOT NULL DEFAULT '0',
  `notshowinservicemenu` int DEFAULT NULL,
  PRIMARY KEY (`cmactioncode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cmaction2`
--


--
-- Temporary view structure for view `cmevent`
--

/*!50001 DROP VIEW IF EXISTS `cmevent`*/;
/*!50001 CREATE VIEW `cmevent` AS SELECT 
 1 AS `eventname`,
 1 AS `eventdescription`,
 1 AS `macrocode`*/;

--
-- Table structure for table `cmevent1`
--

CREATE TABLE `cmevent1` (
  `eventname` varchar(255) NOT NULL,
  `eventdescription` varchar(255) DEFAULT NULL,
  `macrocode` int DEFAULT NULL,
  PRIMARY KEY (`eventname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cmevent1`
--

INSERT INTO `cmevent1` VALUES ('AfterMoneyOperation','Действия после закрытия денежного документа внесения/выема',NULL),('DocumentAfterClosing','Действия после закрытия документа',2),('DocumentAfterRegistration','Действия после добавления позиции',NULL),('DocumentInventoryAfterClosing','Действия после закрытия документа инвентаризации',NULL),('DocumentInventoryAfterRegistration','Действия после добавления позиции в документ инвентаризации',NULL);

--
-- Table structure for table `cmevent2`
--

CREATE TABLE `cmevent2` (
  `eventname` varchar(255) NOT NULL,
  `eventdescription` varchar(255) DEFAULT NULL,
  `macrocode` int DEFAULT NULL,
  PRIMARY KEY (`eventname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cmevent2`
--


--
-- Temporary view structure for view `cmkeys`
--

/*!50001 DROP VIEW IF EXISTS `cmkeys`*/;
/*!50001 CREATE VIEW `cmkeys` AS SELECT 
 1 AS `keycode`,
 1 AS `command`,
 1 AS `params`*/;

--
-- Table structure for table `cmkeys1`
--

CREATE TABLE `cmkeys1` (
  `keycode` int NOT NULL AUTO_INCREMENT,
  `command` varchar(60) DEFAULT NULL,
  `params` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`keycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cmkeys1`
--


--
-- Table structure for table `cmkeys2`
--

CREATE TABLE `cmkeys2` (
  `keycode` int NOT NULL AUTO_INCREMENT,
  `command` varchar(60) DEFAULT NULL,
  `params` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`keycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cmkeys2`
--


--
-- Temporary view structure for view `command`
--

/*!50001 DROP VIEW IF EXISTS `command`*/;
/*!50001 CREATE VIEW `command` AS SELECT 
 1 AS `commandcode`,
 1 AS `commandname`,
 1 AS `description`,
 1 AS `logmode`*/;

--
-- Table structure for table `command1`
--

CREATE TABLE `command1` (
  `commandcode` int NOT NULL AUTO_INCREMENT,
  `commandname` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `logmode` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`commandcode`)
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `command1`
--

INSERT INTO `command1` VALUES (1,'COMMAND_EXIT','Выход',0),(2,'COMMAND_LOGIN','Регистрация',0),(3,'COMMAND_MENU','Меню',0),(4,'COMMAND_TERMINAL','Терминал',0),(5,'COMMAND_SALE','Переход в режим \"продажа\"',0),(6,'COMMAND_BACK','Переход в режим \"возврат\"',0),(7,'COMMAND_QUANT','Изменение количества',0),(8,'COMMAND_PRICE','Изменение цены',0),(9,'COMMAND_BCODE','Ввод по штрих-коду',0),(10,'COMMAND_CODE','Ввод по коду',0),(11,'COMMAND_DEPT','Изменение номера отдела',0),(12,'COMMAND_STORNOSELECT','Сторно выбранного',0),(13,'COMMAND_STORNOALL','Сторно всех позиций',0),(15,'COMMAND_APPLY','Применение модификаторов',0),(16,'COMMAND_DEPTN','Продажа по свободной цене',0),(18,'COMMAND_SCALES','Взвешивание',0),(19,'COMMAND_PRINTCOPY','Печать копии чека',0),(20,'COMMAND_PRINTGOODSCH','Печать товарного чека',0),(21,'COMMAND_CARDINFO','Просмотр информации по карте',0),(22,'COMMAND_BCODETEST','Просмотр информации о товаре',0),(23,'COMMAND_SELECTTMC','Выбор по штрих-коду',0),(24,'COMMAND_PACKING','Расфасовка',0),(27,'COMMAND_OPENDRAWER','Открыть денежный ящик',0),(28,'COMMAND_CALC','Калькулятор',0),(29,'COMMAND_TOTAL','Итог',0),(30,'COMMAND_VALUT','Оплата валютой',0),(42,'COMMAND_CARD','Скидка по карте',0),(46,'COMMAND_MENUEXIT','Выход из меню',0),(48,'COMMAND_VIEW','Просмотр',0),(49,'COMMAND_OPERATION','Операция',0),(50,'COMMAND_SHIFTCLOSE','Закрытие смены',0),(52,'COMMAND_CDTEST','Тестирование табло покупателя',0),(53,'COMMAND_KKMTEST','Тестирование ККМ',0),(54,'COMMAND_KBTEST','Тестирование клавиатуры',0),(55,'COMMAND_DRAWERTEST','Тестирование денежного ящика',0),(56,'COMMAND_VERIFYTOTAL','Сверка итогов по безналу',0),(58,'COMMAND_ADDPAYMENTPOSITION','Добавление оплаты в чеке',0),(59,'COMMAND_MACRO','Макрос',0),(61,'COMMAND_INVENTORY','Инвентаризация',0),(63,'COMMAND_BUTTON','Скидка по кнопке',0),(65,'COMMAND_DOCCANCEL','Аннулирование документа',0),(70,'COMMAND_BCODETESTBYNAME','Просмотр информации о товаре (подбор по наименованию)',0),(72,'COMMAND_SUBTOTAL','Подытог',0),(74,'COMMAND_DELETECARD','Отмена карты',0),(77,'COMMAND_BACKBYSALE','Возврат по чеку продажи',0),(82,'COMMAND_SELECTBYNAME','Выбрать по наименованию',0),(83,'COMMAND_SELECTBYCODE','Выбрать по коду',0),(84,'COMMAND_TESTBYCODE','Просмотр информации о товаре (подбор по коду)',0),(86,'COMMAND_CASHDRAWERSUM','Просмотр суммы в денежном ящике',0),(87,'COMMAND_PUTOUT','Отложить чек',0),(88,'COMMAND_REVEAL','Восстановить чек',0),(90,'COMMAND_ENTER','Ввод',0),(92,'COMMAND_MONEYIN','Внесение денег',0),(93,'COMMAND_MONEYOUT','Выем денег',0),(94,'COMMAND_EMV_PRINTREPORT','Печать отчета по безналу',0),(95,'COMMAND_ENTER_TRAINING_MODE','Вход в тренировочный режим',0),(96,'COMMAND_EXIT_TRAINING_MODE','Выход из тренировочного режима',0),(97,'COMMAND_SERVICE_MENU','Вызов меню \"Сервис\"',0),(98,'COMMAND_ABOUT','Просмотр информации о программе',0),(99,'COMMAND_PAYWITHBONUS','Оплата бонусами',0),(100,'COMMAND_SELECTBYPRICE','Выбрать по цене',0),(101,'COMMAND_SELECTBYARTICUL','Выбрать по артикулу',0),(102,'COMMAND_TESTBYPRICE','Информация о товаре (по цене)',0),(103,'COMMAND_TESTBYARTICUL','Информация о товаре (по артикулу)',0),(104,'COMMAND_WEB_BROWSER','Встроенный браузер',0),(105,'COMMAND_HOTKEY','Горячая клавиша',0),(106,'COMMAND_SUBTOTAL_BYCARD','Подытог по карте',0),(107,'COMMAND_REBOOT','Перезагрузить кассу',0),(108,'COMMAND_RESTART','Перезапустить программу',0),(109,'COMMAND_SHUTDOWN','Выключить кассу',0),(110,'KEY_ARROW_DOWN','Клавиша стрелка вниз',0),(111,'KEY_ARROW_UP','Клавиша стрелка вверх',0),(112,'KEY_ARROW_LEFT','Клавиша стрелка влево',0),(113,'KEY_ARROW_RIGHT','Клавиша стрелка вправо',0),(114,'KEY_PAGEUP','Клавиша PageUp',0),(115,'KEY_PAGEDOWN','Клавиша PageDown',0),(116,'KEY_ENTER','Клавиша Enter',0),(117,'KEY_ESC','Клавиша Esc',0),(118,'KEY_BACKSPACE','Клавиша Backspace',0),(119,'KEY_0','Клавиша 0',0),(120,'KEY_1','Клавиша 1',0),(121,'KEY_2','Клавиша 2',0),(122,'KEY_3','Клавиша 3',0),(123,'KEY_4','Клавиша 4',0),(124,'KEY_5','Клавиша 5',0),(125,'KEY_6','Клавиша 6',0),(126,'KEY_7','Клавиша 7',0),(127,'KEY_8','Клавиша 8',0),(128,'KEY_9','Клавиша 9',0),(129,'KEY_SLASH','Клавиша Деления',0),(130,'KEY_ASTERISK','Клавиша Умножения',0),(131,'KEY_MINUS','Клавиша Вычитания',0),(132,'KEY_PLUS','Клавиша Сложения',0),(133,'KEY_PERIOD','Клавиша Десятичный разделитель',0),(134,'KEY_HOME','Клавиша Home',0),(135,'KEY_END','Клавиша End',0),(136,'COMMAND_JOURNAL','Журнал учета алкогольной продукции',0),(137,'COMMAND_MONEYOUTALL','Обязательный выем денежных средств',0),(138,'COMMAND_BANK_CARD_BALANCE','Баланс банковской карты',0),(139,'COMMAND_COUPON_DELETE','Удалить купоны',0),(140,'COMMAND_BACKTOSUPPLIER','Возврат поставщику',0),(141,'COMMAND_MANUAL_DISCOUNT','Выбрать скидку из списка',0),(142,'COMMAND_CLEAR_MANUAL_DISCOUNT','Отменить скидки выбранные вручную',0),(143,'COMMAND_CONSULTANT','Выбор консультанта из списка',0),(144,'COMMAND_SHIFTOPEN','Открыть смену',0),(145,'COMMAND_SCALETEST','Тест весов',0),(146,'COMMAND_CONSULTANT_FILL','Назначить консультанта на свободные позиции',0),(147,'COMMAND_CUSTOMER_ADDRESS_ADD','Добавить адрес покупателя',0),(148,'COMMAND_SUSPEND_CFO','Отключить контроль финансовых операций',0),(149,'COMMAND_SHOW_EJ','Просмотр электронного журнала',0),(150,'COMMAND_MONEYOUT_WITHOUTCASHIER','Выем без участия кассира',0),(151,'COMMAND_CERTIFICATE','Добавление сертификата',0),(152,'COMMAND_LICENSEDOC','Просмотр лицензионного соглашения',0),(153,'COMMAND_SOCIAL_AUTODISTRIBUTE','Авторасчет социальных товаров',0),(154,'COMMAND_SOCIAL_MANUALSET','Пометка позиции как \'социальная\'',0),(155,'COMMAND_PRINTFNDOCUMENTCOPY','Печать копии фискального докумета',0),(156,'COMMAND_CERTIFICATE_INFO','Получить информацию по сертификату',0),(157,'COMMAND_ACTION_PANEL_PAGE','Переключить страницу панели действий',0),(158,'COMMAND_ACTION_PANEL_PAGE_EXIT','Выйти из текущей страницы панели действий',0),(159,'COMMAND_ESC','ESC',0),(160,'COMMAND_SELECTMULTIPLE','Подбор товара по нескольким параметрам',0),(161,'COMMAND_FILL_CARDOWNER_INFO','Ввод информации о владельце карты лояльности',0),(162,'COMMAND_CORRECTION_SALE','Коррекция прихода',0),(163,'COMMAND_CORRECTION_BACK','Коррекция расхода',0),(164,'COMMAND_CORRECTION_TYPE','Выбор типа коррекции',0),(165,'COMMAND_CORRECTION_REASON','Выбор причины коррекции',0),(166,'COMMAND_TESTMULTIPLE','Информация о товаре по нескольким параметрам',0),(167,'KEY_00','Клавиша 00',0),(168,'COMMAND_PRINTWAYBILL','Печать счета-фактуры',0),(169,'COMMAND_SELECTDEFERRED','Просмотр отложенных чеков',0),(170,'COMMAND_PAPERCUT','Отрезка бумаги',0),(171,'COMMAND_ONLINECHECK','Восстановить онлайн-чек',0),(176,'COMMAND_SOFTCHECK','Софт-чек',0),(178,'COMMAND_BACK_WITH_SUM','Возврат с указанной суммой в отдел',0),(179,'COMMAND_EGAIS_TTN','Работа с ТТН (ЕГАИС)',0),(180,'COMMAND_TESTSKNOCONNECTION','Проверка соединения СКНО с сервером',0),(181,'COMMAND_SELECTFROMPICKLIST','Выбор товара из каталога',0),(182,'COMMAND_CARDREPLACE','Замена карты',0),(183,'COMMAND_LOTTERY','Регистрация лотерейного билета',0),(184,'COMMAND_EMV_PRINTSHORTREPORT','Печать краткого отчета по безналу',0),(185,'COMMAND_EMV_TESTCONNECTION','Проверка связи с пинпадом',0),(186,'COMMAND_EMV_PRINTSLIPCOPY','Печать копии слипа',0),(187,'COMMAND_CARDISSUANCE','Выдача карты',0),(188,'COMMAND_SHOW_REMAINS','Просмотр остатков товара',0),(189,'COMMAND_COUPON_ADD','Добавить купон',0),(190,'COMMAND_VERIFYBILLS','Покупюрная ведомость',0),(191,'COMMAND_DIALOGTEST','Тестирование диалогов',0),(192,'COMMAND_LICENSEINFO','Показать информацию о лицензии',0),(193,'COMMAND_SELECTMEDICINE','Выбор лекарства',0),(194,'COMMAND_CHANGECASHTYPE','Изменение типа кассы',0),(195,'COMMAND_ORDERMEDICINE','Заказать лекарства',0),(196,'COMMAND_LANGUAGE','Изменение языка',0),(197,'COMMAND_CARDCREATE','Создание карты',0),(198,'COMMAND_SELECT_ONLINE_ORDER','Просмотр онлайн-заказов',0),(199,'COMMAND_SELECT_ORDER_FROM_RESERVE','Просмотр онлайн-заказов из резерва',0),(200,'COMMAND_PROCESS_ELECTRONIC_PRESCRIPTIONS','Просмотр электронных рецептов',0),(201,'COMMAND_PRICELIST','Показать прайс-лист',0),(202,'COMMAND_QRDTEST','Тест QR-дисплея',0),(203,'COMMAND_CUSTOMER_INN','Добавить ИНН покупателя',0),(204,'COMMAND_ONLINECHECK_REVIEW','Согласование онлайн-чека',0),(205,'COMMAND_REPLACE_GOODS_ITEM','Замена товара в онлайн-чеке',0),(206,'COMMAND_PRINT_REPORTCOPY','Печать копии отчета',0),(207,'COMMAND_CASHADVANCE','Выдача наличных',0),(208,'COMMAND_PROCESSING_REGSTATICQR','Регистрация кассовой ссылки',0),(209,'COMMAND_CONNECT_TAP','Постановка на кран',0),(210,'COMMAND_DISCONNECT_TAP','Отключение от крана',0),(211,'COMMAND_DRAFTBEER_REMAINS','Просмотр остатков пива',0),(212,'COMMAND_FISCAL_COPY','Печать фискальной копии чека',0),(213,'COMMAND_NOTE','Выполнение примечания по коду',0),(214,'COMMAND_CONSULTANT_DELETE','Удаление консультанта',0);

--
-- Table structure for table `command2`
--

CREATE TABLE `command2` (
  `commandcode` int NOT NULL AUTO_INCREMENT,
  `commandname` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `logmode` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`commandcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `command2`
--


--
-- Temporary view structure for view `commission`
--

/*!50001 DROP VIEW IF EXISTS `commission`*/;
/*!50001 CREATE VIEW `commission` AS SELECT 
 1 AS `commissionid`,
 1 AS `providerid`,
 1 AS `minsum`,
 1 AS `type`,
 1 AS `amount`,
 1 AS `datebegin`,
 1 AS `dateend`,
 1 AS `timebegin`,
 1 AS `timeend`,
 1 AS `cardgroup`*/;

--
-- Table structure for table `commission1`
--

CREATE TABLE `commission1` (
  `commissionid` int NOT NULL AUTO_INCREMENT,
  `providerid` int NOT NULL,
  `minsum` decimal(15,2) NOT NULL,
  `type` int NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `datebegin` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `timebegin` time DEFAULT NULL,
  `timeend` time DEFAULT NULL,
  `cardgroup` int DEFAULT NULL,
  PRIMARY KEY (`commissionid`),
  KEY `ix_commission_providerid` (`providerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `commission1`
--


--
-- Table structure for table `commission2`
--

CREATE TABLE `commission2` (
  `commissionid` int NOT NULL AUTO_INCREMENT,
  `providerid` int NOT NULL,
  `minsum` decimal(15,2) NOT NULL,
  `type` int NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `datebegin` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `timebegin` time DEFAULT NULL,
  `timeend` time DEFAULT NULL,
  `cardgroup` int DEFAULT NULL,
  PRIMARY KEY (`commissionid`),
  KEY `ix_commission_providerid` (`providerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `commission2`
--


--
-- Temporary view structure for view `consultant`
--

/*!50001 DROP VIEW IF EXISTS `consultant`*/;
/*!50001 CREATE VIEW `consultant` AS SELECT 
 1 AS `code`,
 1 AS `password`,
 1 AS `name`*/;

--
-- Temporary view structure for view `correctionreason`
--

/*!50001 DROP VIEW IF EXISTS `correctionreason`*/;
/*!50001 CREATE VIEW `correctionreason` AS SELECT 
 1 AS `code`,
 1 AS `reason`*/;

--
-- Table structure for table `correctionreason1`
--

CREATE TABLE `correctionreason1` (
  `code` int NOT NULL AUTO_INCREMENT,
  `reason` varchar(256) NOT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `correctionreason1`
--


--
-- Table structure for table `correctionreason2`
--

CREATE TABLE `correctionreason2` (
  `code` int NOT NULL AUTO_INCREMENT,
  `reason` varchar(256) NOT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `correctionreason2`
--


--
-- Temporary view structure for view `country`
--

/*!50001 DROP VIEW IF EXISTS `country`*/;
/*!50001 CREATE VIEW `country` AS SELECT 
 1 AS `code`,
 1 AS `name`*/;

--
-- Table structure for table `country1`
--

CREATE TABLE `country1` (
  `code` int NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `country1`
--


--
-- Table structure for table `country2`
--

CREATE TABLE `country2` (
  `code` int NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `country2`
--


--
-- Temporary view structure for view `defcode`
--

/*!50001 DROP VIEW IF EXISTS `defcode`*/;
/*!50001 CREATE VIEW `defcode` AS SELECT 
 1 AS `defcodeid`,
 1 AS `providerid`,
 1 AS `rangemin`,
 1 AS `rangemax`,
 1 AS `regionid`*/;

--
-- Table structure for table `defcode1`
--

CREATE TABLE `defcode1` (
  `defcodeid` int NOT NULL AUTO_INCREMENT,
  `providerid` int NOT NULL,
  `rangemin` varchar(100) NOT NULL,
  `rangemax` varchar(100) NOT NULL,
  `regionid` int NOT NULL,
  PRIMARY KEY (`defcodeid`),
  KEY `defcodeproviderrange` (`providerid`,`rangemin`,`rangemax`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `defcode1`
--


--
-- Table structure for table `defcode2`
--

CREATE TABLE `defcode2` (
  `defcodeid` int NOT NULL AUTO_INCREMENT,
  `providerid` int NOT NULL,
  `rangemin` varchar(100) NOT NULL,
  `rangemax` varchar(100) NOT NULL,
  `regionid` int NOT NULL,
  PRIMARY KEY (`defcodeid`),
  KEY `defcodeproviderrange` (`providerid`,`rangemin`,`rangemax`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `defcode2`
--


--
-- Temporary view structure for view `dept`
--

/*!50001 DROP VIEW IF EXISTS `dept`*/;
/*!50001 CREATE VIEW `dept` AS SELECT 
 1 AS `code`,
 1 AS `name`,
 1 AS `bcode`,
 1 AS `vatcode1`,
 1 AS `vatcode2`,
 1 AS `vatcode3`,
 1 AS `vatcode4`,
 1 AS `vatcode5`,
 1 AS `mode1`,
 1 AS `mode2`,
 1 AS `pricetype`,
 1 AS `sum_limit`,
 1 AS `idclient`,
 1 AS `documentprefix`,
 1 AS `merchantid`*/;

--
-- Table structure for table `dept1`
--

CREATE TABLE `dept1` (
  `code` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `bcode` varchar(20) DEFAULT NULL,
  `vatcode1` int DEFAULT NULL,
  `vatcode2` int DEFAULT NULL,
  `vatcode3` int DEFAULT NULL,
  `vatcode4` int DEFAULT NULL,
  `vatcode5` int DEFAULT NULL,
  `mode1` int DEFAULT NULL,
  `mode2` int DEFAULT NULL,
  `pricetype` int DEFAULT NULL,
  `sum_limit` decimal(13,2) DEFAULT NULL,
  `idclient` varchar(100) DEFAULT NULL,
  `documentprefix` varchar(20) DEFAULT NULL,
  `merchantid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `dept1`
--

INSERT INTO `dept1` VALUES (1,'Отдел 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Отдел 2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `dept2`
--

CREATE TABLE `dept2` (
  `code` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `bcode` varchar(20) DEFAULT NULL,
  `vatcode1` int DEFAULT NULL,
  `vatcode2` int DEFAULT NULL,
  `vatcode3` int DEFAULT NULL,
  `vatcode4` int DEFAULT NULL,
  `vatcode5` int DEFAULT NULL,
  `mode1` int DEFAULT NULL,
  `mode2` int DEFAULT NULL,
  `pricetype` int DEFAULT NULL,
  `sum_limit` decimal(13,2) DEFAULT NULL,
  `idclient` varchar(100) DEFAULT NULL,
  `documentprefix` varchar(20) DEFAULT NULL,
  `merchantid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `dept2`
--


--
-- Temporary view structure for view `disccard`
--

/*!50001 DROP VIEW IF EXISTS `disccard`*/;
/*!50001 CREATE VIEW `disccard` AS SELECT 
 1 AS `cardnumber`,
 1 AS `name`,
 1 AS `rtext`,
 1 AS `cardsum`,
 1 AS `discasheme`,
 1 AS `denycard`,
 1 AS `notaccumulate`,
 1 AS `positionmode`,
 1 AS `ispaycard`,
 1 AS `allpositions`,
 1 AS `msgsheme`,
 1 AS `rcount`,
 1 AS `acdiscscheme`,
 1 AS `cardmode`,
 1 AS `bonussum`,
 1 AS `bonuscode`,
 1 AS `groupcode`,
 1 AS `birthday`,
 1 AS `acdiscasheme`*/;

--
-- Temporary view structure for view `disccardaccumulate`
--

/*!50001 DROP VIEW IF EXISTS `disccardaccumulate`*/;
/*!50001 CREATE VIEW `disccardaccumulate` AS SELECT 
 1 AS `disccode`,
 1 AS `name`,
 1 AS `rtext`,
 1 AS `discperc`,
 1 AS `isbegsum`,
 1 AS `begsum`,
 1 AS `isendsum`,
 1 AS `endsum`,
 1 AS `isbegrcount`,
 1 AS `begrcount`,
 1 AS `isendrcount`,
 1 AS `endrcount`,
 1 AS `discscheme`,
 1 AS `discschemename`*/;

--
-- Table structure for table `disccardaccumulate1`
--

CREATE TABLE `disccardaccumulate1` (
  `disccode` int DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `rtext` varchar(30) DEFAULT NULL,
  `discperc` decimal(5,1) DEFAULT NULL,
  `isbegsum` int DEFAULT NULL,
  `begsum` decimal(17,2) DEFAULT NULL,
  `isendsum` int DEFAULT NULL,
  `endsum` decimal(17,2) DEFAULT NULL,
  `isbegrcount` int DEFAULT NULL,
  `begrcount` decimal(20,0) DEFAULT NULL,
  `isendrcount` int DEFAULT NULL,
  `endrcount` decimal(20,0) DEFAULT NULL,
  `discscheme` int DEFAULT NULL,
  `discschemename` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `disccardaccumulate1`
--


--
-- Table structure for table `disccardaccumulate2`
--

CREATE TABLE `disccardaccumulate2` (
  `disccode` int DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `rtext` varchar(30) DEFAULT NULL,
  `discperc` decimal(5,1) DEFAULT NULL,
  `isbegsum` int DEFAULT NULL,
  `begsum` decimal(17,2) DEFAULT NULL,
  `isendsum` int DEFAULT NULL,
  `endsum` decimal(17,2) DEFAULT NULL,
  `isbegrcount` int DEFAULT NULL,
  `begrcount` decimal(20,0) DEFAULT NULL,
  `isendrcount` int DEFAULT NULL,
  `endrcount` decimal(20,0) DEFAULT NULL,
  `discscheme` int DEFAULT NULL,
  `discschemename` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `disccardaccumulate2`
--


--
-- Temporary view structure for view `discountsauto`
--

/*!50001 DROP VIEW IF EXISTS `discountsauto`*/;
/*!50001 CREATE VIEW `discountsauto` AS SELECT 
 1 AS `shemecode`,
 1 AS `disccode`,
 1 AS `name`,
 1 AS `disctype`,
 1 AS `discmode`,
 1 AS `discsize`,
 1 AS `rtext`,
 1 AS `date_beg`,
 1 AS `date_end`,
 1 AS `time_beg`,
 1 AS `time_end`,
 1 AS `days_beg`,
 1 AS `days_end`,
 1 AS `quant_beg`,
 1 AS `quant_end`,
 1 AS `sum_beg`,
 1 AS `sum_end`,
 1 AS `pricecode`,
 1 AS `rsummode`,
 1 AS `cardgroupcode`,
 1 AS `birthdaymode`,
 1 AS `catalogid`,
 1 AS `catalogquantbeg`,
 1 AS `catalogquantend`,
 1 AS `catalogsumbeg`,
 1 AS `catalogsumend`*/;

--
-- Table structure for table `discountsauto1`
--

CREATE TABLE `discountsauto1` (
  `shemecode` int NOT NULL,
  `disccode` int NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `disctype` int DEFAULT NULL,
  `discmode` int DEFAULT NULL,
  `discsize` decimal(15,2) DEFAULT NULL,
  `rtext` varchar(30) DEFAULT NULL,
  `date_beg` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `time_beg` time DEFAULT NULL,
  `time_end` time DEFAULT NULL,
  `days_beg` int DEFAULT NULL,
  `days_end` int DEFAULT NULL,
  `quant_beg` decimal(17,3) DEFAULT NULL,
  `quant_end` decimal(17,3) DEFAULT NULL,
  `sum_beg` decimal(17,2) DEFAULT NULL,
  `sum_end` decimal(17,2) DEFAULT NULL,
  `pricecode` int DEFAULT NULL,
  `rsummode` int DEFAULT NULL,
  `cardgroupcode` int DEFAULT NULL,
  `birthdaymode` int DEFAULT NULL,
  `catalogid` int DEFAULT NULL,
  `catalogquantbeg` decimal(17,3) DEFAULT NULL,
  `catalogquantend` decimal(17,3) DEFAULT NULL,
  `catalogsumbeg` decimal(15,2) DEFAULT NULL,
  `catalogsumend` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`shemecode`,`disccode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `discountsauto1`
--


--
-- Table structure for table `discountsauto2`
--

CREATE TABLE `discountsauto2` (
  `shemecode` int NOT NULL,
  `disccode` int NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `disctype` int DEFAULT NULL,
  `discmode` int DEFAULT NULL,
  `discsize` decimal(15,2) DEFAULT NULL,
  `rtext` varchar(30) DEFAULT NULL,
  `date_beg` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `time_beg` time DEFAULT NULL,
  `time_end` time DEFAULT NULL,
  `days_beg` int DEFAULT NULL,
  `days_end` int DEFAULT NULL,
  `quant_beg` decimal(17,3) DEFAULT NULL,
  `quant_end` decimal(17,3) DEFAULT NULL,
  `sum_beg` decimal(17,2) DEFAULT NULL,
  `sum_end` decimal(17,2) DEFAULT NULL,
  `pricecode` int DEFAULT NULL,
  `rsummode` int DEFAULT NULL,
  `cardgroupcode` int DEFAULT NULL,
  `birthdaymode` int DEFAULT NULL,
  `catalogid` int DEFAULT NULL,
  `catalogquantbeg` decimal(17,3) DEFAULT NULL,
  `catalogquantend` decimal(17,3) DEFAULT NULL,
  `catalogsumbeg` decimal(15,2) DEFAULT NULL,
  `catalogsumend` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`shemecode`,`disccode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `discountsauto2`
--


--
-- Temporary view structure for view `discountsfixed`
--

/*!50001 DROP VIEW IF EXISTS `discountsfixed`*/;
/*!50001 CREATE VIEW `discountsfixed` AS SELECT 
 1 AS `disccode`,
 1 AS `name`,
 1 AS `disctype`,
 1 AS `discmode`,
 1 AS `discsize`,
 1 AS `rtext`,
 1 AS `cardpref`,
 1 AS `receiptmode`,
 1 AS `positionmode`,
 1 AS `cardonly`,
 1 AS `cardsum_beg`,
 1 AS `cardsum_end`*/;

--
-- Table structure for table `discountsfixed1`
--

CREATE TABLE `discountsfixed1` (
  `disccode` int NOT NULL AUTO_INCREMENT,
  `name` varchar(25) DEFAULT NULL,
  `disctype` int DEFAULT NULL,
  `discmode` int DEFAULT NULL,
  `discsize` decimal(15,2) DEFAULT NULL,
  `rtext` varchar(30) DEFAULT NULL,
  `cardpref` varchar(24) DEFAULT NULL,
  `receiptmode` int DEFAULT NULL,
  `positionmode` int DEFAULT NULL,
  `cardonly` int DEFAULT NULL,
  `cardsum_beg` decimal(18,2) DEFAULT NULL,
  `cardsum_end` decimal(18,2) DEFAULT NULL,
  PRIMARY KEY (`disccode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `discountsfixed1`
--


--
-- Table structure for table `discountsfixed2`
--

CREATE TABLE `discountsfixed2` (
  `disccode` int NOT NULL AUTO_INCREMENT,
  `name` varchar(25) DEFAULT NULL,
  `disctype` int DEFAULT NULL,
  `discmode` int DEFAULT NULL,
  `discsize` decimal(15,2) DEFAULT NULL,
  `rtext` varchar(30) DEFAULT NULL,
  `cardpref` varchar(24) DEFAULT NULL,
  `receiptmode` int DEFAULT NULL,
  `positionmode` int DEFAULT NULL,
  `cardonly` int DEFAULT NULL,
  `cardsum_beg` decimal(18,2) DEFAULT NULL,
  `cardsum_end` decimal(18,2) DEFAULT NULL,
  PRIMARY KEY (`disccode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `discountsfixed2`
--


--
-- Temporary view structure for view `discountsystem`
--

/*!50001 DROP VIEW IF EXISTS `discountsystem`*/;
/*!50001 CREATE VIEW `discountsystem` AS SELECT 
 1 AS `discsystem`,
 1 AS `name`,
 1 AS `discountsystemid`,
 1 AS `bonusearnsystem`,
 1 AS `bonuslimitsystem`,
 1 AS `update_time`,
 1 AS `seconddiscsystem`*/;

--
-- Table structure for table `discountsystem1`
--

CREATE TABLE `discountsystem1` (
  `discsystem` mediumtext,
  `name` varchar(100) DEFAULT NULL,
  `discountsystemid` int NOT NULL AUTO_INCREMENT,
  `bonusearnsystem` mediumtext,
  `bonuslimitsystem` mediumtext,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `seconddiscsystem` mediumtext,
  PRIMARY KEY (`discountsystemid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `discountsystem1`
--

INSERT INTO `discountsystem1` VALUES ('&id002 !!python/object:artixds.domain.DiscountCampaignGroup\nchildGroups: []\ndiscountCampaigns:\n- &id001 !!python/object:artixds.domain.DiscountCampaign\n  active: true\n  beginBonusesDateCalculate: null\n  beginBonusesIntervalCondition: null\n  beginBonusesIntervalMetric: null\n  beginBonusesIntervalValue: 0\n  beginDate: null\n  beginDateWithBeginCurrentMetric: null\n  beginDateWithBeginNextMetric: null\n  beginRangeDate: null\n  beginTime: null\n  checkedTags: null\n  daysOfWeek: []\n  discounts:\n  - !!python/object:artixds.domain.Discount\n    active: true\n    campaign: *id001\n    cashText: null\n    clientDisplayText: null\n    clientText: null\n    conditions: []\n    counters: []\n    coupons: []\n    discountRate: !!python/object:artixds.domain.PercentDiscountRate {type: percent,\n      value: 10.0}\n    gifts: []\n    id: 10\n    minPriceIgnored: false\n    name: \"\\u0420\\u0443\\u0447\\u043D\\u0430\\u044F \\u0441\\u043A\\u0438\\u0434\\u043A\\u0430\\\n      \\ 10% \\u043E\\u0442 \\u0447\\u0435\\u043A\\u0430\"\n    objects:\n    - !!python/object:artixds.domain.CheckObject\n      data: {}\n    reports: []\n    showCashTextToConsultant: false\n  endBonusesDateCalculate: null\n  endBonusesIntervalCondition: null\n  endBonusesIntervalMetric: null\n  endBonusesIntervalValue: 30\n  endDate: null\n  endRangeDate: null\n  endTime: null\n  id: 6\n  interactionType: all\n  labels: null\n  manualActivate: true\n  name: \"\\u0420\\u0443\\u0447\\u043D\\u0430\\u044F \\u0441\\u043A\\u0438\\u0434\\u043A\\u0430\\\n    \\ 10%\"\n  parent: *id002\n  parentGroup: null\n  priority: null\n  qualifiers: !!set {}\n  tagsIsAllowed: false\n  weight: null\n- &id003 !!python/object:artixds.domain.DiscountCampaign\n  active: true\n  beginBonusesDateCalculate: null\n  beginBonusesIntervalCondition: null\n  beginBonusesIntervalMetric: null\n  beginBonusesIntervalValue: 0\n  beginDate: null\n  beginDateWithBeginCurrentMetric: null\n  beginDateWithBeginNextMetric: null\n  beginRangeDate: null\n  beginTime: null\n  checkedTags: null\n  daysOfWeek: []\n  discounts:\n  - !!python/object:artixds.domain.Discount\n    active: true\n    campaign: *id003\n    cashText: null\n    clientDisplayText: null\n    clientText: null\n    conditions: []\n    counters: []\n    coupons: []\n    discountRate: !!python/object:artixds.domain.PercentDiscountRate {type: percent,\n      value: 20.0}\n    gifts: []\n    id: 11\n    minPriceIgnored: false\n    name: \"\\u0420\\u0443\\u0447\\u043D\\u0430\\u044F \\u0441\\u043A\\u0438\\u0434\\u043A\\u0430\\\n      \\ 20% \\u043E\\u0442 \\u0447\\u0435\\u043A\\u0430\"\n    objects:\n    - !!python/object:artixds.domain.CheckObject\n      data: {}\n    reports: []\n    showCashTextToConsultant: false\n  endBonusesDateCalculate: null\n  endBonusesIntervalCondition: null\n  endBonusesIntervalMetric: null\n  endBonusesIntervalValue: 30\n  endDate: null\n  endRangeDate: null\n  endTime: null\n  id: 12\n  interactionType: all\n  labels: null\n  manualActivate: true\n  name: \"\\u0420\\u0443\\u0447\\u043D\\u0430\\u044F \\u0441\\u043A\\u0438\\u0434\\u043A\\u0430\\\n    \\ 20%\"\n  parent: *id002\n  parentGroup: null\n  priority: null\n  qualifiers: !!set {}\n  tagsIsAllowed: false\n  weight: null\nid: 0\ninteractionType: all\nname: !!python/unicode \'all\'\nparent: null\nparentGroup: null\npriority: null\nversion: !!python/unicode \'2.1\'\n',NULL,1,'&id002 !!python/object:artixds.domain.DiscountCampaignGroup\nchildGroups: []\ndiscountCampaigns:\n- &id001 !!python/object:artixds.domain.DiscountCampaign\n  active: true\n  beginBonusesDateCalculate: null\n  beginBonusesIntervalCondition: !!python/unicode \'not_set\'\n  beginBonusesIntervalMetric: !!python/unicode \'day\'\n  beginBonusesIntervalValue: 0\n  beginDate: null\n  beginDateWithBeginCurrentMetric: !!python/unicode \'day\'\n  beginDateWithBeginNextMetric: !!python/unicode \'day\'\n  beginRangeDate: 2021-04-23\n  beginTime: null\n  checkedTags: null\n  daysOfWeek: []\n  discounts:\n  - !!python/object:artixds.domain.Discount\n    active: true\n    campaign: *id001\n    cashText: null\n    clientDisplayText: null\n    clientText: null\n    conditions:\n    - !!python/object:artixds.domain.DiscountCardCondition\n      condition: !!python/unicode \'True\'\n      definition: null\n      description: \"\\u041F\\u0440\\u0438\\u043C\\u0435\\u043D\\u0435\\u043D\\u0430 \\u043A\\u0430\\\n        \\u0440\\u0442\\u0430\"\n      specification: null\n      templateValues: []\n    counters: []\n    coupons: []\n    discountRate: !!python/object:artixds.domain.PercentDiscountRate {type: percent,\n      value: 5.0}\n    gifts: []\n    id: 2\n    minPriceIgnored: false\n    name: \"\\u041D\\u043E\\u0432\\u043E\\u0435 \\u0438\\u043C\\u044F\"\n    objects:\n    - !!python/object:artixds.domain.CheckObject\n      data: {}\n    showCashTextToConsultant: null\n  - !!python/object:artixds.domain.Discount\n    active: true\n    campaign: *id001\n    cashText: null\n    clientDisplayText: null\n    clientText: null\n    conditions:\n    - !!python/object:artixds.domain.DiscountCardCondition\n      condition: !!python/unicode \'True\'\n      definition: null\n      description: \"\\u041F\\u0440\\u0438\\u043C\\u0435\\u043D\\u0435\\u043D\\u0430 \\u043A\\u0430\\\n        \\u0440\\u0442\\u0430\"\n      specification: null\n      templateValues: []\n    - !!python/object:artixds.domain.DiscountCondition\n      condition: !!python/unicode \'object[\"tmc\"][\"code\"] == u\"100\"\'\n      definition: !!python/unicode \'object[\"tmc\"][\"code\"] == ${..}\'\n      description: \"\\u041A\\u043E\\u0434 \\u0442\\u043E\\u0432\\u0430\\u0440\\u0430 \\u0440\\\n        \\u0430\\u0432\\u043D\\u043E u\\\"100\\\" \"\n      specification: \"\\u041A\\u043E\\u0434 \\u0442\\u043E\\u0432\\u0430\\u0440\\u0430 \\u0440\\\n        \\u0430\\u0432\\u043D\\u043E [..]\"\n      templateValues:\n      - {defaultValue: !!python/unicode \'100\', label: \"\\u041A\\u043E\\u0434\", type: !!python/unicode \'code\'}\n    counters: []\n    coupons: []\n    discountRate: !!python/object:artixds.domain.PercentDiscountRate {type: percent,\n      value: 10.0}\n    gifts: []\n    id: 3\n    minPriceIgnored: false\n    name: \"\\u041D\\u043E\\u0432\\u043E\\u0435 \\u0438\\u043C\\u044F\"\n    objects:\n    - !!python/object:artixds.domain.PositionObject\n      data: {}\n    showCashTextToConsultant: null\n  endBonusesDateCalculate: null\n  endBonusesIntervalCondition: !!python/unicode \'not_set\'\n  endBonusesIntervalMetric: !!python/unicode \'day\'\n  endBonusesIntervalValue: 30\n  endDate: null\n  endRangeDate: 2021-04-24\n  endTime: null\n  id: 1\n  interactionType: all\n  labels: null\n  manualActivate: null\n  name: \"\\u041D\\u0430\\u0447\\u0438\\u0441\\u043B\\u0435\\u043D\\u0438\\u0435\"\n  parent: *id002\n  parentGroup: null\n  priority: null\n  qualifiers: !!set {}\n  tagsIsAllowed: false\n  weight: null\nid: 0\ninteractionType: all\nname: !!python/unicode \'bonusall\'\nparent: null\nparentGroup: null\npriority: null\nversion: !!python/unicode \'2.1\'\n',NULL,'2024-12-17 10:35:37',NULL);

--
-- Table structure for table `discountsystem2`
--

CREATE TABLE `discountsystem2` (
  `discsystem` mediumtext,
  `name` varchar(100) DEFAULT NULL,
  `discountsystemid` int NOT NULL AUTO_INCREMENT,
  `bonusearnsystem` mediumtext,
  `bonuslimitsystem` mediumtext,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `seconddiscsystem` mediumtext,
  PRIMARY KEY (`discountsystemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `discountsystem2`
--


--
-- Temporary view structure for view `excisemarkwhite`
--

/*!50001 DROP VIEW IF EXISTS `excisemarkwhite`*/;
/*!50001 CREATE VIEW `excisemarkwhite` AS SELECT 
 1 AS `excisemarkid`,
 1 AS `barcode`,
 1 AS `updatetime`,
 1 AS `shopcode`,
 1 AS `excisetype`,
 1 AS `serialnumber`*/;

--
-- Table structure for table `excisemarkwhite1`
--

CREATE TABLE `excisemarkwhite1` (
  `excisemarkid` varchar(255) NOT NULL,
  `barcode` varchar(100) NOT NULL,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `shopcode` varchar(30) DEFAULT NULL,
  `excisetype` varchar(30) NOT NULL DEFAULT 'ALCOHOL',
  `serialnumber` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`excisemarkid`,`barcode`(45),`excisetype`),
  KEY `ix_excisemarkwhite_barcode` (`barcode`),
  KEY `ix_excisemarkwhite_updatetime` (`updatetime`),
  KEY `excisemarkwhiteidxserialnumber` (`serialnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `excisemarkwhite1`
--


--
-- Table structure for table `excisemarkwhite2`
--

CREATE TABLE `excisemarkwhite2` (
  `excisemarkid` varchar(255) NOT NULL,
  `barcode` varchar(100) NOT NULL,
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `shopcode` varchar(30) DEFAULT NULL,
  `excisetype` varchar(30) NOT NULL DEFAULT 'ALCOHOL',
  `serialnumber` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`excisemarkid`,`barcode`(45),`excisetype`),
  KEY `ix_excisemarkwhite_barcode` (`barcode`),
  KEY `ix_excisemarkwhite_updatetime` (`updatetime`),
  KEY `excisemarkwhiteidxserialnumber` (`serialnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `excisemarkwhite2`
--


--
-- Temporary view structure for view `extendedparameter`
--

/*!50001 DROP VIEW IF EXISTS `extendedparameter`*/;
/*!50001 CREATE VIEW `extendedparameter` AS SELECT 
 1 AS `extendedparameterid`,
 1 AS `providerid`,
 1 AS `code`,
 1 AS `name`,
 1 AS `mask`,
 1 AS `required`*/;

--
-- Table structure for table `extendedparameter1`
--

CREATE TABLE `extendedparameter1` (
  `extendedparameterid` int NOT NULL AUTO_INCREMENT,
  `providerid` int NOT NULL,
  `code` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `mask` varchar(200) DEFAULT NULL,
  `required` int DEFAULT NULL,
  PRIMARY KEY (`extendedparameterid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `extendedparameter1`
--


--
-- Table structure for table `extendedparameter2`
--

CREATE TABLE `extendedparameter2` (
  `extendedparameterid` int NOT NULL AUTO_INCREMENT,
  `providerid` int NOT NULL,
  `code` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `mask` varchar(200) DEFAULT NULL,
  `required` int DEFAULT NULL,
  PRIMARY KEY (`extendedparameterid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `extendedparameter2`
--


--
-- Temporary view structure for view `goodstimerestrict`
--

/*!50001 DROP VIEW IF EXISTS `goodstimerestrict`*/;
/*!50001 CREATE VIEW `goodstimerestrict` AS SELECT 
 1 AS `bcode`,
 1 AS `code`,
 1 AS `flag`,
 1 AS `text`,
 1 AS `time_beg`,
 1 AS `time_end`*/;

--
-- Table structure for table `goodstimerestrict1`
--

CREATE TABLE `goodstimerestrict1` (
  `bcode` varchar(100) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `flag` int DEFAULT NULL,
  `text` varchar(100) DEFAULT NULL,
  `time_beg` datetime DEFAULT NULL,
  `time_end` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `goodstimerestrict1`
--


--
-- Table structure for table `goodstimerestrict2`
--

CREATE TABLE `goodstimerestrict2` (
  `bcode` varchar(100) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `flag` int DEFAULT NULL,
  `text` varchar(100) DEFAULT NULL,
  `time_beg` datetime DEFAULT NULL,
  `time_end` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `goodstimerestrict2`
--


--
-- Temporary view structure for view `groups`
--

/*!50001 DROP VIEW IF EXISTS `groups`*/;
/*!50001 CREATE VIEW `groups` AS SELECT 
 1 AS `class`,
 1 AS `sclass`,
 1 AS `name`,
 1 AS `pricetype`*/;

--
-- Table structure for table `groups1`
--

CREATE TABLE `groups1` (
  `class` int DEFAULT NULL,
  `sclass` int DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `pricetype` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `groups1`
--


--
-- Table structure for table `groups2`
--

CREATE TABLE `groups2` (
  `class` int DEFAULT NULL,
  `sclass` int DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `pricetype` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `groups2`
--


--
-- Temporary view structure for view `hotkey`
--

/*!50001 DROP VIEW IF EXISTS `hotkey`*/;
/*!50001 CREATE VIEW `hotkey` AS SELECT 
 1 AS `hotkeycode`,
 1 AS `hotkeyname`,
 1 AS `bybarcode`*/;

--
-- Table structure for table `hotkey1`
--

CREATE TABLE `hotkey1` (
  `hotkeycode` int NOT NULL AUTO_INCREMENT,
  `hotkeyname` varchar(100) DEFAULT NULL,
  `bybarcode` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`hotkeycode`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hotkey1`
--

INSERT INTO `hotkey1` VALUES (1,'Горячая клавиша №1 (средний пакет)',0),(2,'Горячая клавиша №2 (большой пакет)',0);

--
-- Table structure for table `hotkey2`
--

CREATE TABLE `hotkey2` (
  `hotkeycode` int NOT NULL AUTO_INCREMENT,
  `hotkeyname` varchar(100) DEFAULT NULL,
  `bybarcode` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`hotkeycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hotkey2`
--


--
-- Temporary view structure for view `hotkeyinvent`
--

/*!50001 DROP VIEW IF EXISTS `hotkeyinvent`*/;
/*!50001 CREATE VIEW `hotkeyinvent` AS SELECT 
 1 AS `hotkeyinventid`,
 1 AS `inventcode`,
 1 AS `hotkeycode`*/;

--
-- Table structure for table `hotkeyinvent1`
--

CREATE TABLE `hotkeyinvent1` (
  `hotkeyinventid` int NOT NULL AUTO_INCREMENT,
  `inventcode` varchar(100) DEFAULT NULL,
  `hotkeycode` int NOT NULL,
  PRIMARY KEY (`hotkeyinventid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hotkeyinvent1`
--

INSERT INTO `hotkeyinvent1` VALUES (1,'10344',1),(2,'10345',2);

--
-- Table structure for table `hotkeyinvent2`
--

CREATE TABLE `hotkeyinvent2` (
  `hotkeyinventid` int NOT NULL AUTO_INCREMENT,
  `inventcode` varchar(100) DEFAULT NULL,
  `hotkeycode` int NOT NULL,
  PRIMARY KEY (`hotkeyinventid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hotkeyinvent2`
--


--
-- Temporary view structure for view `images`
--

/*!50001 DROP VIEW IF EXISTS `images`*/;
/*!50001 CREATE VIEW `images` AS SELECT 
 1 AS `id`,
 1 AS `idtype`,
 1 AS `usagetype`,
 1 AS `hash`*/;

--
-- Temporary view structure for view `kbkey`
--

/*!50001 DROP VIEW IF EXISTS `kbkey`*/;
/*!50001 CREATE VIEW `kbkey` AS SELECT 
 1 AS `keycode`,
 1 AS `cmactioncode`,
 1 AS `keyvalue`,
 1 AS `context`*/;

--
-- Table structure for table `kbkey1`
--

CREATE TABLE `kbkey1` (
  `keycode` int NOT NULL,
  `cmactioncode` int DEFAULT NULL,
  `keyvalue` varchar(10) DEFAULT NULL,
  `context` varchar(100) NOT NULL,
  PRIMARY KEY (`keycode`,`context`),
  KEY `kbkeycmactioncode` (`cmactioncode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `kbkey1`
--

INSERT INTO `kbkey1` VALUES (13,122,'Enter','receiptforming'),(13,87,'Enter','receiptpayment'),(13,11,'Enter','receiptview'),(99,276,'C','receiptforming'),(100,92,'D','allcontext'),(109,189,'M','allcontext'),(111,237,'O','receiptforming'),(112,116,'P','allcontext'),(114,117,'R','receiptforming'),(115,242,'S','receiptforming'),(120,275,'X','receiptforming'),(122,274,'Z','receiptforming'),(265,113,'F1','allcontext'),(266,268,'F2','receiptforming'),(267,15,'F3','allcontext'),(268,16,'F4','allcontext'),(269,30,'F5','receiptforming'),(270,22,'F6','receiptforming'),(271,3,'F7','allcontext'),(272,50,'F8','receiptforming'),(273,9,'F9','allcontext'),(274,10,'F10','allcontext'),(275,33,'F11','allcontext'),(276,35,'F12','allcontext'),(276,101,'F12','receiptforming'),(277,247,'SHIFT+F1','receiptforming'),(278,226,'SHIFT+F2','receiptforming'),(279,265,'SHIFT+F3','receiptforming'),(280,208,'SHIFT+F4','receiptforming'),(281,24,'SHIFT+F5','allcontext'),(282,106,'SHIFT+F6','receiptforming'),(283,14,'SHIFT+F7','receiptforming'),(284,191,'SHIFT+F8','receiptpayment'),(285,18,'SHIFT+F9','allcontext'),(286,25,'SHIFT+F10','allcontext'),(287,2,'SHIFT+F11','allcontext'),(288,23,'SHIFT+F12','allcontext'),(289,112,'CTRL+F1','receiptforming'),(290,111,'CTRL+F2','receiptforming'),(291,193,'CTRL+F3','receiptforming'),(292,37,'CTRL+F4','receiptpayment'),(293,7,'CTRL+F5','receiptforming'),(294,8,'CTRL+F6','receiptforming'),(295,34,'CTRL+F7','allcontext'),(296,103,'CTRL+F8','receiptforming'),(297,29,'CTRL+F9','allcontext'),(298,192,'CTRL+F10','receiptforming'),(299,228,'CTRL+F11','receiptforming'),(300,246,'CTRL+F12','receiptforming'),(1208,90,'CTRL+I','allcontext');

--
-- Table structure for table `kbkey2`
--

CREATE TABLE `kbkey2` (
  `keycode` int NOT NULL,
  `cmactioncode` int DEFAULT NULL,
  `keyvalue` varchar(10) DEFAULT NULL,
  `context` varchar(100) NOT NULL,
  PRIMARY KEY (`keycode`,`context`),
  KEY `kbkeycmactioncode` (`cmactioncode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `kbkey2`
--


--
-- Temporary view structure for view `kit`
--

/*!50001 DROP VIEW IF EXISTS `kit`*/;
/*!50001 CREATE VIEW `kit` AS SELECT 
 1 AS `campaignid`,
 1 AS `kitid`,
 1 AS `name`,
 1 AS `kittype`,
 1 AS `maxtimes`*/;

--
-- Table structure for table `kit1`
--

CREATE TABLE `kit1` (
  `campaignid` int NOT NULL,
  `kitid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `kittype` int DEFAULT NULL,
  `maxtimes` int DEFAULT NULL,
  PRIMARY KEY (`kitid`),
  KEY `kitcampaignid` (`campaignid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `kit1`
--


--
-- Table structure for table `kit2`
--

CREATE TABLE `kit2` (
  `campaignid` int NOT NULL,
  `kitid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `kittype` int DEFAULT NULL,
  `maxtimes` int DEFAULT NULL,
  PRIMARY KEY (`kitid`),
  KEY `kitcampaignid` (`campaignid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `kit2`
--


--
-- Temporary view structure for view `kitdisc`
--

/*!50001 DROP VIEW IF EXISTS `kitdisc`*/;
/*!50001 CREATE VIEW `kitdisc` AS SELECT 
 1 AS `disckind`,
 1 AS `disctype`,
 1 AS `discval`,
 1 AS `kitdiscid`,
 1 AS `kitgoodsid`,
 1 AS `impactmode`*/;

--
-- Table structure for table `kitdisc1`
--

CREATE TABLE `kitdisc1` (
  `disckind` int DEFAULT NULL,
  `disctype` int DEFAULT NULL,
  `discval` decimal(14,3) DEFAULT NULL,
  `kitdiscid` int NOT NULL AUTO_INCREMENT,
  `kitgoodsid` int NOT NULL,
  `impactmode` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`kitdiscid`),
  KEY `kitdisckitgoodsid` (`kitgoodsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `kitdisc1`
--


--
-- Table structure for table `kitdisc2`
--

CREATE TABLE `kitdisc2` (
  `disckind` int DEFAULT NULL,
  `disctype` int DEFAULT NULL,
  `discval` decimal(14,3) DEFAULT NULL,
  `kitdiscid` int NOT NULL AUTO_INCREMENT,
  `kitgoodsid` int NOT NULL,
  `impactmode` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`kitdiscid`),
  KEY `kitdisckitgoodsid` (`kitgoodsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `kitdisc2`
--


--
-- Temporary view structure for view `kitgoods`
--

/*!50001 DROP VIEW IF EXISTS `kitgoods`*/;
/*!50001 CREATE VIEW `kitgoods` AS SELECT 
 1 AS `goodscode`,
 1 AS `kitgoodsid`,
 1 AS `kitid`,
 1 AS `quantity`*/;

--
-- Table structure for table `kitgoods1`
--

CREATE TABLE `kitgoods1` (
  `goodscode` varchar(100) NOT NULL,
  `kitgoodsid` int NOT NULL AUTO_INCREMENT,
  `kitid` int NOT NULL,
  `quantity` decimal(14,3) DEFAULT NULL,
  PRIMARY KEY (`kitgoodsid`),
  KEY `kitgoodsgoodscode` (`goodscode`),
  KEY `kitgoodskitid` (`kitid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `kitgoods1`
--


--
-- Table structure for table `kitgoods2`
--

CREATE TABLE `kitgoods2` (
  `goodscode` varchar(100) NOT NULL,
  `kitgoodsid` int NOT NULL AUTO_INCREMENT,
  `kitid` int NOT NULL,
  `quantity` decimal(14,3) DEFAULT NULL,
  PRIMARY KEY (`kitgoodsid`),
  KEY `kitgoodsgoodscode` (`goodscode`),
  KEY `kitgoodskitid` (`kitid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `kitgoods2`
--


--
-- Temporary view structure for view `macro`
--

/*!50001 DROP VIEW IF EXISTS `macro`*/;
/*!50001 CREATE VIEW `macro` AS SELECT 
 1 AS `macrocode`,
 1 AS `macroname`*/;

--
-- Table structure for table `macro1`
--

CREATE TABLE `macro1` (
  `macrocode` int NOT NULL AUTO_INCREMENT,
  `macroname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`macrocode`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `macro1`
--

INSERT INTO `macro1` VALUES (1,'Закрытие смены'),(2,'Почековая выгрузка');

--
-- Table structure for table `macro2`
--

CREATE TABLE `macro2` (
  `macrocode` int NOT NULL AUTO_INCREMENT,
  `macroname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`macrocode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `macro2`
--


--
-- Temporary view structure for view `macroparameters`
--

/*!50001 DROP VIEW IF EXISTS `macroparameters`*/;
/*!50001 CREATE VIEW `macroparameters` AS SELECT 
 1 AS `macroparametercode`,
 1 AS `macroparameterorder`,
 1 AS `cmactioncode`,
 1 AS `macrocode`*/;

--
-- Table structure for table `macroparameters1`
--

CREATE TABLE `macroparameters1` (
  `macroparametercode` int NOT NULL AUTO_INCREMENT,
  `macroparameterorder` int DEFAULT NULL,
  `cmactioncode` int DEFAULT NULL,
  `macrocode` int NOT NULL,
  PRIMARY KEY (`macroparametercode`),
  KEY `macroparameterscmactioncode` (`cmactioncode`),
  KEY `macroparametersmacrocode` (`macrocode`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `macroparameters1`
--

INSERT INTO `macroparameters1` VALUES (1,10,79,1),(2,20,63,1),(3,30,74,1),(4,40,133,1),(5,50,78,1),(6,60,202,1),(7,1,49,2);

--
-- Table structure for table `macroparameters2`
--

CREATE TABLE `macroparameters2` (
  `macroparametercode` int NOT NULL AUTO_INCREMENT,
  `macroparameterorder` int DEFAULT NULL,
  `cmactioncode` int DEFAULT NULL,
  `macrocode` int NOT NULL,
  PRIMARY KEY (`macroparametercode`),
  KEY `macroparameterscmactioncode` (`cmactioncode`),
  KEY `macroparametersmacrocode` (`macrocode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `macroparameters2`
--


--
-- Temporary view structure for view `medicine`
--

/*!50001 DROP VIEW IF EXISTS `medicine`*/;
/*!50001 CREATE VIEW `medicine` AS SELECT 
 1 AS `code`,
 1 AS `party`,
 1 AS `barcode`,
 1 AS `series`,
 1 AS `shelflife`,
 1 AS `producer`,
 1 AS `price`,
 1 AS `inn`,
 1 AS `remainquant`,
 1 AS `remaindatetime`,
 1 AS `countrycode`,
 1 AS `options`,
 1 AS `packingprice`,
 1 AS `cquant`,
 1 AS `packquant`,
 1 AS `supplydate`,
 1 AS `rating`,
 1 AS `bonusonsale`,
 1 AS `row`,
 1 AS `shelf`,
 1 AS `dictname`,
 1 AS `dictcode`*/;

--
-- Table structure for table `medicine1`
--

CREATE TABLE `medicine1` (
  `code` int NOT NULL,
  `party` varchar(255) DEFAULT NULL,
  `barcode` varchar(255) NOT NULL,
  `series` varchar(255) DEFAULT NULL,
  `shelflife` date DEFAULT NULL,
  `producer` varchar(255) DEFAULT NULL,
  `price` decimal(13,2) NOT NULL,
  `inn` text,
  `remainquant` int DEFAULT NULL,
  `remaindatetime` datetime DEFAULT NULL,
  `countrycode` int DEFAULT NULL,
  `options` int DEFAULT NULL,
  `packingprice` decimal(13,2) DEFAULT NULL,
  `cquant` decimal(13,3) DEFAULT NULL,
  `packquant` decimal(13,3) DEFAULT NULL,
  `supplydate` date DEFAULT NULL,
  `rating` int DEFAULT NULL,
  `bonusonsale` int DEFAULT NULL,
  `row` varchar(255) DEFAULT NULL,
  `shelf` varchar(255) DEFAULT NULL,
  `dictname` varchar(255) DEFAULT NULL,
  `dictcode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`),
  KEY `dictcodeidx` (`dictcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `medicine1`
--


--
-- Table structure for table `medicine2`
--

CREATE TABLE `medicine2` (
  `code` int NOT NULL,
  `party` varchar(255) DEFAULT NULL,
  `barcode` varchar(255) NOT NULL,
  `series` varchar(255) DEFAULT NULL,
  `shelflife` date DEFAULT NULL,
  `producer` varchar(255) DEFAULT NULL,
  `price` decimal(13,2) NOT NULL,
  `inn` text,
  `remainquant` int DEFAULT NULL,
  `remaindatetime` datetime DEFAULT NULL,
  `countrycode` int DEFAULT NULL,
  `options` int DEFAULT NULL,
  `packingprice` decimal(13,2) DEFAULT NULL,
  `cquant` decimal(13,3) DEFAULT NULL,
  `packquant` decimal(13,3) DEFAULT NULL,
  `supplydate` date DEFAULT NULL,
  `rating` int DEFAULT NULL,
  `bonusonsale` int DEFAULT NULL,
  `row` varchar(255) DEFAULT NULL,
  `shelf` varchar(255) DEFAULT NULL,
  `dictname` varchar(255) DEFAULT NULL,
  `dictcode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`),
  KEY `dictcodeidx` (`dictcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `medicine2`
--


--
-- Temporary view structure for view `menu`
--

/*!50001 DROP VIEW IF EXISTS `menu`*/;
/*!50001 CREATE VIEW `menu` AS SELECT 
 1 AS `menucode`,
 1 AS `menuname`*/;

--
-- Table structure for table `menu1`
--

CREATE TABLE `menu1` (
  `menucode` int NOT NULL AUTO_INCREMENT,
  `menuname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`menucode`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `menu1`
--

INSERT INTO `menu1` VALUES (1,'Главное меню'),(6,'Операции с деньгами'),(10,'Отчеты'),(13,'Документы'),(14,'Сверка итогов'),(15,'Сервис'),(16,'Завершение работы'),(17,'Тест оборудования'),(18,'Боковая панель');

--
-- Table structure for table `menu2`
--

CREATE TABLE `menu2` (
  `menucode` int NOT NULL AUTO_INCREMENT,
  `menuname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`menucode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `menu2`
--


--
-- Temporary view structure for view `menuitem`
--

/*!50001 DROP VIEW IF EXISTS `menuitem`*/;
/*!50001 CREATE VIEW `menuitem` AS SELECT 
 1 AS `menuitemcode`,
 1 AS `menuitemorder`,
 1 AS `cmactioncode`,
 1 AS `menucode`*/;

--
-- Table structure for table `menuitem1`
--

CREATE TABLE `menuitem1` (
  `menuitemcode` int NOT NULL AUTO_INCREMENT,
  `menuitemorder` int DEFAULT NULL,
  `cmactioncode` int DEFAULT NULL,
  `menucode` int NOT NULL,
  PRIMARY KEY (`menuitemcode`),
  KEY `menuitemcmactioncode` (`cmactioncode`),
  KEY `menuitemmenucode` (`menucode`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `menuitem1`
--

INSERT INTO `menuitem1` VALUES (1,1,6,1),(2,2,55,1),(3,3,182,1),(4,4,3,1),(5,5,60,1),(6,6,185,1),(7,7,183,1),(8,8,68,1),(9,9,199,1),(10,1,53,6),(11,2,54,6),(12,3,115,6),(13,4,56,6),(20,1,59,13),(21,2,23,13),(22,3,24,13),(23,4,225,13),(24,5,271,13),(25,6,106,13),(26,7,229,13),(27,8,230,13),(28,9,56,13),(31,1,65,10),(32,2,62,10),(33,3,75,10),(34,4,64,10),(35,5,76,10),(36,6,204,10),(37,7,222,10),(38,8,231,10),(39,9,205,10),(40,10,56,10),(51,1,210,15),(52,2,186,15),(53,3,187,15),(54,4,221,15),(55,5,267,15),(56,6,190,15),(57,7,56,15),(61,1,69,17),(62,2,70,17),(63,3,71,17),(64,4,215,17),(65,5,257,17),(66,6,72,17),(67,7,56,17),(71,1,79,14),(72,2,184,14),(73,3,266,14),(74,4,56,14),(81,1,203,16),(82,2,201,16),(83,3,202,16),(84,4,200,16),(89,2,278,17),(90,4,2,18),(91,2,34,18),(92,1,3,18),(93,3,106,18);

--
-- Table structure for table `menuitem2`
--

CREATE TABLE `menuitem2` (
  `menuitemcode` int NOT NULL AUTO_INCREMENT,
  `menuitemorder` int DEFAULT NULL,
  `cmactioncode` int DEFAULT NULL,
  `menucode` int NOT NULL,
  PRIMARY KEY (`menuitemcode`),
  KEY `menuitemcmactioncode` (`cmactioncode`),
  KEY `menuitemmenucode` (`menucode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `menuitem2`
--


--
-- Table structure for table `migrate_version`
--

CREATE TABLE `migrate_version` (
  `repository_id` varchar(250) NOT NULL,
  `repository_path` text,
  `version` int DEFAULT NULL,
  PRIMARY KEY (`repository_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `migrate_version`
--

INSERT INTO `migrate_version` VALUES ('Artix Dictionaries','dictionaries',169);

--
-- Temporary view structure for view `mol`
--

/*!50001 DROP VIEW IF EXISTS `mol`*/;
/*!50001 CREATE VIEW `mol` AS SELECT 
 1 AS `code`,
 1 AS `login`,
 1 AS `loginmode`,
 1 AS `name`,
 1 AS `password`,
 1 AS `locked`,
 1 AS `usergroup`,
 1 AS `drawer`,
 1 AS `start`,
 1 AS `keyposition`,
 1 AS `rank`,
 1 AS `inn`*/;

--
-- Temporary view structure for view `molaccess`
--

/*!50001 DROP VIEW IF EXISTS `molaccess`*/;
/*!50001 CREATE VIEW `molaccess` AS SELECT 
 1 AS `code`,
 1 AS `shopcode`,
 1 AS `cashcode`*/;

--
-- Table structure for table `molaccess1`
--

CREATE TABLE `molaccess1` (
  `code` varchar(30) NOT NULL,
  `shopcode` varchar(150) NOT NULL,
  `cashcode` varchar(150) NOT NULL,
  PRIMARY KEY (`code`,`shopcode`,`cashcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `molaccess1`
--


--
-- Table structure for table `molaccess2`
--

CREATE TABLE `molaccess2` (
  `code` varchar(30) NOT NULL,
  `shopcode` varchar(150) NOT NULL,
  `cashcode` varchar(150) NOT NULL,
  PRIMARY KEY (`code`,`shopcode`,`cashcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `molaccess2`
--


--
-- Temporary view structure for view `mop`
--

/*!50001 DROP VIEW IF EXISTS `mop`*/;
/*!50001 CREATE VIEW `mop` AS SELECT 
 1 AS `scode`,
 1 AS `opcode`,
 1 AS `turnon`,
 1 AS `password`*/;

--
-- Temporary view structure for view `note`
--

/*!50001 DROP VIEW IF EXISTS `note`*/;
/*!50001 CREATE VIEW `note` AS SELECT 
 1 AS `id`,
 1 AS `name`,
 1 AS `type`,
 1 AS `triggertype`,
 1 AS `saveresult`,
 1 AS `template`*/;

--
-- Table structure for table `note1`
--

CREATE TABLE `note1` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` int DEFAULT NULL,
  `triggertype` int DEFAULT NULL,
  `saveresult` tinyint(1) DEFAULT NULL,
  `template` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `note1`
--


--
-- Table structure for table `note2`
--

CREATE TABLE `note2` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` int DEFAULT NULL,
  `triggertype` int DEFAULT NULL,
  `saveresult` tinyint(1) DEFAULT NULL,
  `template` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `note2`
--


--
-- Temporary view structure for view `op`
--

/*!50001 DROP VIEW IF EXISTS `op`*/;
/*!50001 CREATE VIEW `op` AS SELECT 
 1 AS `opcode`,
 1 AS `name`,
 1 AS `sign`,
 1 AS `mode`,
 1 AS `opgroup`,
 1 AS `keypos`,
 1 AS `password`,
 1 AS `extcode`,
 1 AS `logstring`*/;

--
-- Temporary view structure for view `option`
--

/*!50001 DROP VIEW IF EXISTS `option`*/;
/*!50001 CREATE VIEW `option` AS SELECT 
 1 AS `idoption`,
 1 AS `type`,
 1 AS `text`*/;

--
-- Table structure for table `option1`
--

CREATE TABLE `option1` (
  `idoption` int NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `text` varchar(200) NOT NULL,
  PRIMARY KEY (`idoption`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `option1`
--


--
-- Table structure for table `option2`
--

CREATE TABLE `option2` (
  `idoption` int NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `text` varchar(200) NOT NULL,
  PRIMARY KEY (`idoption`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `option2`
--


--
-- Temporary view structure for view `organization`
--

/*!50001 DROP VIEW IF EXISTS `organization`*/;
/*!50001 CREATE VIEW `organization` AS SELECT 
 1 AS `organizationcode`,
 1 AS `name`,
 1 AS `registeredaddress`,
 1 AS `correspondenceaddress`,
 1 AS `ogrn`,
 1 AS `inn`,
 1 AS `kpp`,
 1 AS `okpo`,
 1 AS `operatingaccount`,
 1 AS `bank`,
 1 AS `correspondingaccount`,
 1 AS `bik`,
 1 AS `receiver`,
 1 AS `customer`,
 1 AS `payer`,
 1 AS `deliveryaddress`*/;

--
-- Table structure for table `organization1`
--

CREATE TABLE `organization1` (
  `organizationcode` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `registeredaddress` varchar(255) NOT NULL,
  `correspondenceaddress` varchar(255) DEFAULT NULL,
  `ogrn` varchar(255) DEFAULT NULL,
  `inn` varchar(255) NOT NULL,
  `kpp` varchar(255) NOT NULL,
  `okpo` varchar(255) DEFAULT NULL,
  `operatingaccount` varchar(255) NOT NULL,
  `bank` varchar(255) NOT NULL,
  `correspondingaccount` varchar(255) NOT NULL,
  `bik` varchar(255) NOT NULL,
  `receiver` varchar(255) DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `payer` varchar(255) DEFAULT NULL,
  `deliveryaddress` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`organizationcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `organization1`
--


--
-- Table structure for table `organization2`
--

CREATE TABLE `organization2` (
  `organizationcode` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `registeredaddress` varchar(255) NOT NULL,
  `correspondenceaddress` varchar(255) DEFAULT NULL,
  `ogrn` varchar(255) DEFAULT NULL,
  `inn` varchar(255) NOT NULL,
  `kpp` varchar(255) NOT NULL,
  `okpo` varchar(255) DEFAULT NULL,
  `operatingaccount` varchar(255) NOT NULL,
  `bank` varchar(255) NOT NULL,
  `correspondingaccount` varchar(255) NOT NULL,
  `bik` varchar(255) NOT NULL,
  `receiver` varchar(255) DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `payer` varchar(255) DEFAULT NULL,
  `deliveryaddress` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`organizationcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `organization2`
--


--
-- Temporary view structure for view `payforbiddance`
--

/*!50001 DROP VIEW IF EXISTS `payforbiddance`*/;
/*!50001 CREATE VIEW `payforbiddance` AS SELECT 
 1 AS `valutcode`,
 1 AS `deptcode`*/;

--
-- Table structure for table `payforbiddance1`
--

CREATE TABLE `payforbiddance1` (
  `valutcode` int NOT NULL,
  `deptcode` int NOT NULL,
  PRIMARY KEY (`valutcode`,`deptcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `payforbiddance1`
--


--
-- Table structure for table `payforbiddance2`
--

CREATE TABLE `payforbiddance2` (
  `valutcode` int NOT NULL,
  `deptcode` int NOT NULL,
  PRIMARY KEY (`valutcode`,`deptcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `payforbiddance2`
--


--
-- Temporary view structure for view `picklist`
--

/*!50001 DROP VIEW IF EXISTS `picklist`*/;
/*!50001 CREATE VIEW `picklist` AS SELECT 
 1 AS `code`,
 1 AS `name`,
 1 AS `image`,
 1 AS `parent`,
 1 AS `tmccode`,
 1 AS `itemorder`*/;

--
-- Table structure for table `picklist1`
--

CREATE TABLE `picklist1` (
  `code` varchar(32) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` text NOT NULL,
  `parent` varchar(32) DEFAULT NULL,
  `tmccode` varchar(100) DEFAULT NULL,
  `itemorder` int DEFAULT NULL,
  PRIMARY KEY (`code`),
  KEY `ix_picklist_name` (`name`),
  KEY `ix_picklist_parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `picklist1`
--

INSERT INTO `picklist1` VALUES ('1','Женская одежда','[BLOB]',NULL,NULL,1),('10','БАБОЧКИ , 31*26*12СМ','[BLOB]','3','1000006',NULL),('11','HELLO SPRING , 31*26*12СМ','[BLOB]','3','1000007',NULL),('12','КРАСОТА, 31*26*12СМ','[BLOB]','3','1000008',NULL),('14','Поло с коротким рукавом','[BLOB]','2','1000009',1),('15','Оверсайз силуэт из хлопка','[BLOB]','2','1000010',2),('16','Поло с коротким рукавом и принтом','[BLOB]','2','1000011',3),('17','Из хлопка с коротким рукавом и надписью','[BLOB]','2','1000012',4),('18','Из хлопка с вырезом сердечко со стразами','[BLOB]','1','1000013',0),