Здравствуйте. у меня есть база данных sql для определённой программы. но проблема в том, что на другом компьютере выдаётся множественные ошибки синтаксиса (пусть и не значительные). Помогите понять, как это исправить...


Сообщение 102, уровень 15, состояние 1, строка 18
Неправильный синтаксис около конструкции "`".
Сообщение 343, уровень 15, состояние 1, строка 340
Неизвестный тип объекта "ALGORITHM" в инструкции CREATE, DROP или ALTER.
Сообщение 102, уровень 15, состояние 1, строка 340
Неправильный синтаксис около конструкции "`".
Сообщение 343, уровень 15, состояние 1, строка 346
Неизвестный тип объекта "ALGORITHM" в инструкции CREATE, DROP или ALTER.
Сообщение 343, уровень 15, состояние 1, строка 352
Неизвестный тип объекта "ALGORITHM" в инструкции CREATE, DROP или ALTER.
Сообщение 343, уровень 15, состояние 1, строка 358
Неизвестный тип объекта "ALGORITHM" в инструкции CREATE, DROP или ALTER.
Сообщение 102, уровень 15, состояние 1, строка 358
Неправильный синтаксис около конструкции "`".


/* SQL-Front 5.1 (Build 4.16)*/

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


/* Host: localhost Database: gantt*/
/* ------------------------------------------------------*/
/* Server version 5.5.23*/

CREATE DATABASE `gantt` /*!40100 DEFAULT CHARACTER SET cp1251 */;
USE `gantt`;

/* */
/* Source for table client */
/* */

CREATE TABLE `client` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`name_client` varchar(150) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`phone` varchar(30) DEFAULT NULL,
`desc` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table client*/
/* */

LOCK TABLES `client` WRITE;
/*!40000 ALTER TABLE `client` DISABLE KEYS */;
INSERT INTO `client` VALUES (1,'ООО \"Нева\"','neva@neva.ru','8-963-569-85-98','пластиковые окна');
INSERT INTO `client` VALUES (2,'ООО \"Лада\"','zzz@mail.ru','8-963-555-55-63','автомобили и запчасти');
/*!40000 ALTER TABLE `client` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table project*/
/* */

CREATE TABLE `project` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`name_project` varchar(150) DEFAULT NULL,
`date_create` date DEFAULT NULL,
`id_vid` int(11) DEFAULT NULL,
`date_end` date DEFAULT NULL,
`id_client` int(11) DEFAULT NULL,
`sum_dog` decimal(10,2) DEFAULT NULL,
`dog` blob,
`dog_ext` varchar(5) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `id_vid` (`id_vid`),
KEY `id_client` (`id_client`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table project*/
/* */

LOCK TABLES `project` WRITE;
/*!40000 ALTER TABLE `project` DISABLE KEYS */;
INSERT INTO `project` VALUES (1,'Сайт-визитка для ООО \"Нева\"','2017-06-01',1,'2017-07-20',1,45000,NULL,NULL);
INSERT INTO `project` VALUES (2,'Корпоративный портал xero.net','2017-01-15',2,'2017-04-20',2,690000,NULL,NULL);
INSERT INTO `project` VALUES (3,'Интернет-магазин ozon.ru','2017-01-01',3,'2017-11-30',1,2900000,NULL,NULL);
INSERT INTO `project` VALUES (4,'Сайт-визитка','2017-04-02',1,'2017-06-05',2,120000,NULL,NULL);
/*!40000 ALTER TABLE `project` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table shablon*/
/* */

CREATE TABLE `shablon` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`id_vid` int(11) DEFAULT NULL,
`name_shablon` varchar(150) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `id_vid` (`id_vid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table shablon*/
/* */

LOCK TABLES `shablon` WRITE;
/*!40000 ALTER TABLE `shablon` DISABLE KEYS */;
INSERT INTO `shablon` VALUES (1,1,'простой сайт-визитка');
INSERT INTO `shablon` VALUES (2,1,'сайт-визитка+телефонный звонок');
INSERT INTO `shablon` VALUES (3,2,'корпоративный сайт (до 5 разделов)');
/*!40000 ALTER TABLE `shablon` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table shablon_spec*/
/* */

CREATE TABLE `shablon_spec` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`id_shablon` int(11) DEFAULT NULL,
`id_rab` int(11) DEFAULT NULL,
`days` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `id_shablon` (`id_shablon`),
KEY `id_rab` (`id_rab`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table shablon_spec*/
/* */

LOCK TABLES `shablon_spec` WRITE;
/*!40000 ALTER TABLE `shablon_spec` DISABLE KEYS */;
INSERT INTO `shablon_spec` VALUES (1,1,1,2);
INSERT INTO `shablon_spec` VALUES (2,1,2,8);
INSERT INTO `shablon_spec` VALUES (3,1,3,2);
INSERT INTO `shablon_spec` VALUES (4,1,4,15);
INSERT INTO `shablon_spec` VALUES (5,1,5,15);
INSERT INTO `shablon_spec` VALUES (6,1,6,7);
INSERT INTO `shablon_spec` VALUES (7,1,7,3);
INSERT INTO `shablon_spec` VALUES (8,1,8,5);
INSERT INTO `shablon_spec` VALUES (9,2,1,5);
INSERT INTO `shablon_spec` VALUES (10,2,2,10);
INSERT INTO `shablon_spec` VALUES (11,2,3,8);
INSERT INTO `shablon_spec` VALUES (12,2,4,14);
INSERT INTO `shablon_spec` VALUES (13,2,5,18);
INSERT INTO `shablon_spec` VALUES (14,2,6,15);
INSERT INTO `shablon_spec` VALUES (15,2,7,1);
INSERT INTO `shablon_spec` VALUES (16,3,1,15);
INSERT INTO `shablon_spec` VALUES (17,3,2,25);
INSERT INTO `shablon_spec` VALUES (18,3,3,10);
INSERT INTO `shablon_spec` VALUES (19,3,6,15);
/*!40000 ALTER TABLE `shablon_spec` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table sotr*/
/* */

CREATE TABLE `sotr` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`FIO` varchar(150) DEFAULT NULL,
`email` varchar(30) DEFAULT NULL,
`phone` varchar(30) DEFAULT NULL,
`dolj` varchar(100) DEFAULT NULL,
`comment` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table sotr*/
/* */

LOCK TABLES `sotr` WRITE;
/*!40000 ALTER TABLE `sotr` DISABLE KEYS */;
INSERT INTO `sotr` VALUES (1,'Иванов А.К,','-','8-96-99','программист','все');
INSERT INTO `sotr` VALUES (2,'Лазарев А,К.','laz@mail.ru','8-55-63','программист','все');
INSERT INTO `sotr` VALUES (3,'Захаров У.Е.','-','8-56-77','программист','Java');
INSERT INTO `sotr` VALUES (4,'Муромов К.Е.','-','8-96-55','программист','PHP');
INSERT INTO `sotr` VALUES (5,'Кушнарев К.О.','lush@mail.ru','8-99-66','программист','Python');
INSERT INTO `sotr` VALUES (6,'Пушкин В.К.','-','8-78-52','программист','Java');
INSERT INTO `sotr` VALUES (7,'Варенцов К.Г.','var@mail.ru','8-96-88','программист','все');
/*!40000 ALTER TABLE `sotr` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table user*/
/* */

CREATE TABLE `user` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`FIO` varchar(150) DEFAULT NULL,
`login` varchar(20) DEFAULT NULL,
`pass` varchar(20) DEFAULT NULL,
`plan` bit(1) DEFAULT NULL,
`fact` bit(1) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table user*/
/* */

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Иванов А,А.','admin','admin',b'1',b'1');
INSERT INTO `user` VALUES (2,'Петров В.В.','user1','user1',b'1',NULL);
INSERT INTO `user` VALUES (3,'Сидоров С.С.','user2','user2',NULL,b'1');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table vid_project*/
/* */

CREATE TABLE `vid_project` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`name_vid` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table vid_project*/
/* */

LOCK TABLES `vid_project` WRITE;
/*!40000 ALTER TABLE `vid_project` DISABLE KEYS */;
INSERT INTO `vid_project` VALUES (1,'сайт-визитка');
INSERT INTO `vid_project` VALUES (2,'корпоративный сайт');
INSERT INTO `vid_project` VALUES (3,'интернет-магазин');
INSERT INTO `vid_project` VALUES (4,'интернет-портал');
INSERT INTO `vid_project` VALUES (5,'лэндинг');
/*!40000 ALTER TABLE `vid_project` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table vid_rab*/
/* */

CREATE TABLE `vid_rab` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`name_rab` varchar(255) DEFAULT NULL,
`count_days` int(11) DEFAULT NULL,
`desc` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table vid_rab*/
/* */

LOCK TABLES `vid_rab` WRITE;
/*!40000 ALTER TABLE `vid_rab` DISABLE KEYS */;
INSERT INTO `vid_rab` VALUES (1,'сбор данных',2,NULL);
INSERT INTO `vid_rab` VALUES (2,'составление тех.задания',5,NULL);
INSERT INTO `vid_rab` VALUES (3,'согласование тех.задания',2,NULL);
INSERT INTO `vid_rab` VALUES (4,'разработка структуры проекта',10,NULL);
INSERT INTO `vid_rab` VALUES (5,'разработка интрерфейса',10,NULL);
INSERT INTO `vid_rab` VALUES (6,'разработка программных модулей',30,NULL);
INSERT INTO `vid_rab` VALUES (7,'тестирование',15,NULL);
INSERT INTO `vid_rab` VALUES (8,'сдача',10,NULL);
/*!40000 ALTER TABLE `vid_rab` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table work*/
/* */

CREATE TABLE `work` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`id_project` int(11) DEFAULT NULL,
`id_rab` int(11) DEFAULT NULL,
`dt_start` date DEFAULT NULL,
`dt_end` date DEFAULT NULL,
`koef_sloj` decimal(10,2) DEFAULT NULL,
`koef_povtor` decimal(10,2) DEFAULT NULL,
`dt_st_fact` date DEFAULT NULL,
`dt_end_fact` date DEFAULT NULL,
`comment_fact` varchar(255) DEFAULT NULL,
`plan_dn` int(11) DEFAULT NULL,
`fact_dn` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `id_rab` (`id_rab`),
KEY `id_project` (`id_project`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table work*/
/* */

LOCK TABLES `work` WRITE;
/*!40000 ALTER TABLE `work` DISABLE KEYS */;
INSERT INTO `work` VALUES (9,1,1,'2017-06-01','2017-06-03',NULL,NULL,'2017-06-01','2017-06-02',NULL,2,1);
INSERT INTO `work` VALUES (10,1,2,'2017-06-03','2017-06-11',NULL,NULL,'2017-06-02','2017-06-15',NULL,8,13);
INSERT INTO `work` VALUES (11,1,3,'2017-06-11','2017-06-13',NULL,NULL,NULL,NULL,NULL,2,NULL);
INSERT INTO `work` VALUES (12,1,4,'2017-06-13','2017-07-05',50,NULL,NULL,NULL,NULL,15,NULL);
INSERT INTO `work` VALUES (13,1,5,'2017-07-05','2017-07-13',NULL,50,NULL,NULL,NULL,15,NULL);
INSERT INTO `work` VALUES (14,1,6,'2017-07-13','2017-07-26',80,NULL,NULL,NULL,NULL,7,NULL);
INSERT INTO `work` VALUES (15,1,7,'2017-07-26','2017-07-29',NULL,NULL,NULL,NULL,NULL,3,NULL);
INSERT INTO `work` VALUES (16,1,8,'2017-07-29','2017-08-03',NULL,NULL,NULL,NULL,NULL,5,NULL);
INSERT INTO `work` VALUES (41,2,1,'2017-01-15','2017-01-30',NULL,NULL,NULL,NULL,NULL,15,NULL);
INSERT INTO `work` VALUES (42,2,2,'2017-01-30','2017-02-24',NULL,NULL,NULL,NULL,NULL,25,NULL);
INSERT INTO `work` VALUES (43,2,3,'2017-02-24','2017-03-06',NULL,NULL,NULL,NULL,NULL,10,NULL);
INSERT INTO `work` VALUES (44,2,6,'2017-03-06','2017-03-21',NULL,NULL,NULL,NULL,NULL,15,NULL);
/*!40000 ALTER TABLE `work` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for table work_sotr*/
/* */

CREATE TABLE `work_sotr` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`id_work` int(11) DEFAULT NULL,
`id_sotr` int(11) DEFAULT NULL,
`comment` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `id_work` (`id_work`),
KEY `id_sotr` (`id_sotr`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

/* */
/* Dumping data for table work_sotr*/
/* */

LOCK TABLES `work_sotr` WRITE;
/*!40000 ALTER TABLE `work_sotr` DISABLE KEYS */;
INSERT INTO `work_sotr` VALUES (1,9,1,'сбор требований у заказчика');
INSERT INTO `work_sotr` VALUES (2,9,2,'обсуждение интерфейса');
INSERT INTO `work_sotr` VALUES (3,9,4,'обсуждение финкционала');
INSERT INTO `work_sotr` VALUES (4,10,6,NULL);
INSERT INTO `work_sotr` VALUES (5,10,6,NULL);
INSERT INTO `work_sotr` VALUES (6,11,7,NULL);
INSERT INTO `work_sotr` VALUES (7,12,3,NULL);
INSERT INTO `work_sotr` VALUES (8,12,5,NULL);
INSERT INTO `work_sotr` VALUES (9,13,4,NULL);
INSERT INTO `work_sotr` VALUES (10,13,5,NULL);
INSERT INTO `work_sotr` VALUES (11,13,6,NULL);
INSERT INTO `work_sotr` VALUES (12,13,1,NULL);
INSERT INTO `work_sotr` VALUES (13,14,3,NULL);
INSERT INTO `work_sotr` VALUES (14,14,1,NULL);
INSERT INTO `work_sotr` VALUES (15,14,6,NULL);
INSERT INTO `work_sotr` VALUES (16,15,3,NULL);
INSERT INTO `work_sotr` VALUES (17,15,4,NULL);
INSERT INTO `work_sotr` VALUES (18,16,7,NULL);
/*!40000 ALTER TABLE `work_sotr` ENABLE KEYS */;
UNLOCK TABLES;

/* */
/* Source for view plan_view*/
/* */

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `plan_view` AS select `project`.`name_project` AS `name_project`,`vid_rab`.`name_rab` AS `name_rab`,`work`.`dt_start` AS `dt_start`,`work`.`dt_end` AS `dt_end`,`work`.`plan_dn` AS `plan_dn`,count(distinct `work_sotr`.`id_sotr`) AS `uch_count` from (((`work` join `project` on((`work`.`id_project` = `project`.`Id`))) join `vid_rab` on((`work`.`id_rab` = `vid_rab`.`Id`))) join `work_sotr` on((`work_sotr`.`id_work` = `work`.`Id`))) group by `project`.`name_project`,`vid_rab`.`name_rab`,`work`.`dt_start`,`work`.`dt_end`,`work`.`plan_dn`;

/* */
/* Source for view planfact_view*/
/* */

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `planfact_view` AS select `project`.`name_project` AS `name_project`,`vid_rab`.`name_rab` AS `name_rab`,`work`.`dt_start` AS `dt_start`,`work`.`dt_end` AS `dt_end`,`work`.`plan_dn` AS `plan_dn`,`work`.`dt_st_fact` AS `dt_st_fact`,`work`.`dt_end_fact` AS `dt_end_fact`,`work`.`fact_dn` AS `fact_dn`,(`work`.`plan_dn` - `work`.`fact_dn`) AS `otkl` from ((`work` join `project` on((`work`.`id_project` = `project`.`Id`))) join `vid_rab` on((`work`.`id_rab` = `vid_rab`.`Id`)));

/* */
/* Source for view stat*/
/* */

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `stat` AS select `project`.`name_project` AS `name_project`,`project`.`date_create` AS `date_create`,`project`.`date_end` AS `date_end`,sum(`work`.`plan_dn`) AS `poplanu`,sum(`work`.`fact_dn`) AS `pofaktu`,(sum(`work`.`plan_dn`) - sum(`work`.`fact_dn`)) AS `otkl` from (`project` join `work` on((`work`.`id_project` = `project`.`Id`))) group by `project`.`name_project`,`project`.`date_create`,`project`.`date_end`;

/* */
/* Source for view zan_sotr*/
/* */

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `zan_sotr` AS select `project`.`name_project` AS `name_project`,`sotr`.`FIO` AS `FIO`,sum(`work`.`plan_dn`) AS `plan_dn`,sum(`work`.`fact_dn`) AS `fact_dn` from (((`work_sotr` join `work` on((`work_sotr`.`id_work` = `work`.`Id`))) join `sotr` on((`work_sotr`.`id_sotr` = `sotr`.`Id`))) join `project` on((`work`.`id_project` = `project`.`Id`))) group by `project`.`name_project`,`sotr`.`FIO`;

/* */
/* Foreign keys for table project*/
/* */

ALTER TABLE `project`
ADD CONSTRAINT `project_ibfk_1` FOREIGN KEY (`id_vid`) REFERENCES `vid_project` (`Id`),
ADD CONSTRAINT `project_ibfk_2` FOREIGN KEY (`id_client`) REFERENCES `client` (`Id`);

/* */
/* Foreign keys for table shablon*/
/* */

ALTER TABLE `shablon`
ADD CONSTRAINT `shablon_ibfk_1` FOREIGN KEY (`id_vid`) REFERENCES `vid_project` (`Id`);

/* */
/* Foreign keys for table shablon_spec */
/* */

ALTER TABLE `shablon_spec`
ADD CONSTRAINT `shablon_spec_ibfk_2` FOREIGN KEY (`id_rab`) REFERENCES `vid_rab` (`Id`),
ADD CONSTRAINT `shablon_spec_ibfk_1` FOREIGN KEY (`id_shablon`) REFERENCES `shablon` (`Id`);

/* */
/* Foreign keys for table work*/
/* */

ALTER TABLE `work`
ADD CONSTRAINT `work_ibfk_1` FOREIGN KEY (`id_rab`) REFERENCES `vid_rab` (`Id`),
ADD CONSTRAINT `work_ibfk_2` FOREIGN KEY (`id_project`) REFERENCES `project` (`Id`);

/* */
/* Foreign keys for table work_sotr*/
/* */

ALTER TABLE `work_sotr`
ADD CONSTRAINT `work_sotr_ibfk_2` FOREIGN KEY (`id_sotr`) REFERENCES `sotr` (`Id`),
ADD CONSTRAINT `work_sotr_ibfk_1` FOREIGN KEY (`id_work`) REFERENCES `work` (`Id`);


/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;