--source include/have_sjis.inc --source include/have_innodb.inc --character_set sjis SET NAMES sjis; SET character_set_database = sjis; --disable_warnings DROP TABLE IF EXISTS `アアア`; DROP TABLE IF EXISTS `イイイ`; DROP TABLE IF EXISTS `ウウウ`; DROP TABLE IF EXISTS `エエエ`; DROP TABLE IF EXISTS `オオオ`; DROP TABLE IF EXISTS `あああ`; DROP TABLE IF EXISTS `いいい`; DROP TABLE IF EXISTS `ううう`; DROP TABLE IF EXISTS `えええ`; DROP TABLE IF EXISTS `おおお`; DROP TABLE IF EXISTS `ソソソ`; DROP TABLE IF EXISTS `十十十`; DROP TABLE IF EXISTS `表表表`; DROP TABLE IF EXISTS `予予予`; DROP TABLE IF EXISTS `構構構`; --enable_warnings CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = ujis engine=INNODB; CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = ujis engine=INNODB; CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE `ソソソ`(`噂噂噂` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE `十十十`(`蚕蚕蚕` char(1)) DEFAULT CHARSET = sjis engine=INNODB; # Tables should not be created because table names exist CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE IF NOT EXISTS `ソソソ`(`噂噂噂` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE IF NOT EXISTS `十十十`(`蚕蚕蚕` char(1)) DEFAULT CHARSET = sjis engine=INNODB; # Tables should be created CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE IF NOT EXISTS `表表表`(`申申申`char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TEMPORARY TABLE `予予予`(`貼貼貼` char(1)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TEMPORARY TABLE `構構構`(`能能能` char(1)) DEFAULT CHARSET = sjis engine=INNODB; DESC `アアア`; DESC `イイイ`; DESC `ウウウ`; DESC `エエエ`; DESC `オオオ`; DESC `あああ`; DESC `いいい`; DESC `ううう`; DESC `えええ`; DESC `おおお`; DESC `ソソソ`; DESC `十十十`; DESC `表表表`; DESC `予予予`; DESC `構構構`; SHOW CREATE TABLE `アアア`; SHOW CREATE TABLE `イイイ`; SHOW CREATE TABLE `ウウウ`; SHOW CREATE TABLE `エエエ`; SHOW CREATE TABLE `オオオ`; SHOW CREATE TABLE `あああ`; SHOW CREATE TABLE `いいい`; SHOW CREATE TABLE `ううう`; SHOW CREATE TABLE `えええ`; SHOW CREATE TABLE `おおお`; SHOW CREATE TABLE `ソソソ`; SHOW CREATE TABLE `十十十`; SHOW CREATE TABLE `表表表`; SHOW CREATE TABLE `予予予`; SHOW CREATE TABLE `構構構`; DROP TABLE `アアア`; DROP TABLE `イイイ`; DROP TABLE `ウウウ`; DROP TABLE `エエエ`; DROP TABLE `オオオ`; DROP TABLE `あああ`; DROP TABLE `いいい`; DROP TABLE `ううう`; DROP TABLE `えええ`; DROP TABLE `おおお`; DROP TABLE `ソソソ`; DROP TABLE `十十十`; DROP TABLE `表表表`; DROP TABLE `予予予`; DROP TABLE `構構構`; CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE `ソソソ`(`噂噂噂` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE `十十十`(`蚕蚕蚕` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; # Tables should not be created because table names exist CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE IF NOT EXISTS `ソソソ`(`噂噂噂` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE IF NOT EXISTS `十十十`(`蚕蚕蚕` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; # Tables should be created CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TABLE IF NOT EXISTS `表表表`(`申申申`char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TEMPORARY TABLE `予予予`(`貼貼貼` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; CREATE TEMPORARY TABLE `構構構`(`能能能` char(1)) DEFAULT CHARSET = sjis engine=MyISAM; DESC `アアア`; DESC `イイイ`; DESC `ウウウ`; DESC `エエエ`; DESC `オオオ`; DESC `あああ`; DESC `いいい`; DESC `ううう`; DESC `えええ`; DESC `おおお`; DESC `ソソソ`; DESC `十十十`; DESC `表表表`; DESC `予予予`; DESC `構構構`; SHOW CREATE TABLE `アアア`; SHOW CREATE TABLE `イイイ`; SHOW CREATE TABLE `ウウウ`; SHOW CREATE TABLE `エエエ`; SHOW CREATE TABLE `オオオ`; SHOW CREATE TABLE `あああ`; SHOW CREATE TABLE `いいい`; SHOW CREATE TABLE `ううう`; SHOW CREATE TABLE `えええ`; SHOW CREATE TABLE `おおお`; SHOW CREATE TABLE `ソソソ`; SHOW CREATE TABLE `十十十`; SHOW CREATE TABLE `表表表`; SHOW CREATE TABLE `予予予`; SHOW CREATE TABLE `構構構`; DROP TABLE `アアア`; DROP TABLE `イイイ`; DROP TABLE `ウウウ`; DROP TABLE `エエエ`; DROP TABLE `オオオ`; DROP TABLE `あああ`; DROP TABLE `いいい`; DROP TABLE `ううう`; DROP TABLE `えええ`; DROP TABLE `おおお`; DROP TABLE `ソソソ`; DROP TABLE `十十十`; DROP TABLE `表表表`; DROP TABLE `予予予`; DROP TABLE `構構構`; CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `ソソソ`(`噂噂噂` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `十十十`(`蚕蚕蚕` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; # Tables should not be created because table names exist CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE IF NOT EXISTS `ソソソ`(`噂噂噂` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE IF NOT EXISTS `十十十`(`蚕蚕蚕` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; # Tables should be created CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE IF NOT EXISTS `表表表`(`申申申`char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TEMPORARY TABLE `予予予`(`貼貼貼` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TEMPORARY TABLE `構構構`(`能能能` char(1)) DEFAULT CHARSET = sjis engine=MEMORY; DESC `アアア`; DESC `イイイ`; DESC `ウウウ`; DESC `エエエ`; DESC `オオオ`; DESC `あああ`; DESC `いいい`; DESC `ううう`; DESC `えええ`; DESC `おおお`; DESC `ソソソ`; DESC `十十十`; DESC `表表表`; DESC `予予予`; DESC `構構構`; SHOW CREATE TABLE `アアア`; SHOW CREATE TABLE `イイイ`; SHOW CREATE TABLE `ウウウ`; SHOW CREATE TABLE `エエエ`; SHOW CREATE TABLE `オオオ`; SHOW CREATE TABLE `あああ`; SHOW CREATE TABLE `いいい`; SHOW CREATE TABLE `ううう`; SHOW CREATE TABLE `えええ`; SHOW CREATE TABLE `おおお`; SHOW CREATE TABLE `ソソソ`; SHOW CREATE TABLE `十十十`; SHOW CREATE TABLE `表表表`; SHOW CREATE TABLE `予予予`; SHOW CREATE TABLE `構構構`; DROP TABLE `アアア`; DROP TABLE `イイイ`; DROP TABLE `ウウウ`; DROP TABLE `エエエ`; DROP TABLE `オオオ`; DROP TABLE `あああ`; DROP TABLE `いいい`; DROP TABLE `ううう`; DROP TABLE `えええ`; DROP TABLE `おおお`; DROP TABLE `ソソソ`; DROP TABLE `十十十`; DROP TABLE `表表表`; DROP TABLE `予予予`; DROP TABLE `構構構`;