· 8 years ago · May 08, 2018, 02:58 AM
1# This is a fix for InnoDB in MySQL >= 4.1.x
2# It "suspends judgement" for fkey relationships until are tables are set.
3SET FOREIGN_KEY_CHECKS = 0;
4
5#-----------------------------------------------------------------------------
6#-- modules
7#-----------------------------------------------------------------------------
8
9DROP TABLE IF EXISTS `modules`;
10
11
12CREATE TABLE `modules`
13(
14 `name` INTEGER NOT NULL COMMENT 'Module-Identifikationname',
15 PRIMARY KEY (`name`)
16)Type=MyISAM COMMENT='Eingelesene Module';
17
18# This restores the fkey checks, after having unset them earlier
19SET FOREIGN_KEY_CHECKS = 1;