Sql Dump – Views

[fvdw]

I use views in my DB. When I export my db, the dump generated by SQLYog look like this

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

USE `IAH6_oct2011`;

/*Table structure for table `crm_accounts` */

DROP TABLE IF EXISTS `crm_accounts`;

/*!50001 DROP VIEW IF EXISTS `crm_accounts` */;

/*!50001 DROP TABLE IF EXISTS `crm_accounts` */;

/*!50001 CREATE TABLE `crm_accounts`(

`id` char(36) ,

`date_entered` datetime ,

`date_modified` datetime ,

`modified_user_id` char(36) ,

Etc…

/*View structure for view crm_accounts */

/*!50001 DROP TABLE IF EXISTS `crm_accounts` */;

/*!50001 DROP VIEW IF EXISTS `crm_accounts` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `crm_accounts` AS select `IAH6_oct2011`.`accounts`.`id` AS `id`,`IAH6_oct2011`.`accounts`.`date_entered` AS `date_entered`,`IAH6_oct2011`.`accounts`.`date_modified` AS `date_modified`,`IAH6_oct2011`.`accounts`.`modified_user_id` AS `modified_user_id`,`IAH6_oct2011`.`accounts`.`assigned_user_id` …

Etc… */;

Where crm_account is a view, not a table in my DB. I understand this for backward compatibility. When I restore this dump on some server, the table crm_account is created and the view is not created however the target server support views.

My resquest / sugget : add some option to allow or not the creation of such tables (and create view without backward compatibility).

[Author]

Posts