As in the question title - is it possible for a MySQL database to have duplicate tables with the same name? Is there a directive that can be used for a database to allow this?
Normally, when trying to add duplicate tables, MySQL should return an error #1050 - Table 'tablename' already exists, but recently, while working on a project, I noticed that almost every table in the database is duplicated (only the structure, new tables are empty). While I know that some table-creating scripts could be executed, MySQL shouldn't allow this, right?
How to even deal with such an issue? The program causing this is a Magento - a PHP-based eCommerce platform.
There are parts of a dump from this database:
--
-- Table structure for table `adminnotification_inbox`
--
CREATE TABLE IF NOT EXISTS `adminnotification_inbox` (
`notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Notification id',
`severity` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Problem type',
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Create date',
`title` varchar(255) NOT NULL COMMENT 'Title',
`description` text COMMENT 'Description',
`url` varchar(255) DEFAULT NULL COMMENT 'Url',
`is_read` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification read',
`is_remove` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification might be removed',
PRIMARY KEY (`notification_id`),
KEY `IDX_ADMINNOTIFICATION_INBOX_SEVERITY` (`severity`),
KEY `IDX_ADMINNOTIFICATION_INBOX_IS_READ` (`is_read`),
KEY `IDX_ADMINNOTIFICATION_INBOX_IS_REMOVE` (`is_remove`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Adminnotification Inbox' AUTO_INCREMENT=26 ;
--
-- Dumping data for table `adminnotification_inbox`
--
-- there was some data from this table, not relevant here
-- --------------------------------------------------------
--
-- Table structure for table `
adminnotification_inbox`
--
-- in use(#1146 - Table 'dev_noelasmar_1_12'dev_testproject_1_12.
adminnotification_inbox' doesn't exist)
-- in use (#1146 - Table 'dev_noelasmar_1_12'dev_testproject_1_12.
adminnotification_inbox' doesn't exist)
-- --------------------------------------------------------
I don't think this dump would even run without errors.