Zhang Huangbin skrev: > > Hi, Max. > > They all worked :( > > mysql> CREATE TABLE noInnoDB ( test varchar(10)) ENGINE=MyISAM; > Query OK, 0 rows affected (0.08 sec) > > mysql> drop table noInnoDB; > Query OK, 0 rows affected (0.00 sec) > > mysql> CREATE TABLE testInnoDB ( test varchar(10)) ENGINE=InnoDB; > Query OK, 0 rows affected (0.08 sec) > > mysql> drop table testInnoDB; > Query OK, 0 rows affected (0.01 sec) >
Hi Zhang Can you send the output from mysql> show tables; and mysql> CREATE TABLE quarantine ( mail_id varchar(12) NOT NULL, -- long-term unique mail id chunk_ind integer unsigned NOT NULL, -- chunk number, starting with 1 mail_text blob NOT NULL, -- store mail as chunks of octets PRIMARY KEY (mail_id,chunk_ind), FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE ) ENGINE=InnoDB; /Max ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
