mK8XK9pM

1$installer = new Mage_Core_Model_Resource_Setup();
2$installer->startSetup();
3
4$installer->run("
5         DROP TABLE IF EXISTS {$installer->getTable('test')};
6         CREATE TABLE {$installer->getTable('test')} (
7                        ci tinyint(3) unsigned NOT NULL auto_increment,
8                        cc char(2) NOT NULL,
9                        cn varchar(50) NOT NULL,
10                        PRIMARY KEY (ci)
11                        ) AUTO_INCREMENT=1 ;
12                        ");
13
14$installer->endSetup();