- addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_countries`");
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_countries` (
-id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-code CHAR(2) NOT NULL DEFAULT 'DE',
-descr VARCHAR(255) NOT NULL DEFAULT 'Deutschland',
-is_active ENUM('Y','N') NOT NULL DEFAULT 'N',
-KEY (code),
-PRIMARY KEY (id)
-) TYPE={?_TABLE_TYPE?}");
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (code, descr, is_active) VALUES ('DE','Deutschland','Y')");
+ addDropTableSql('countries');
+ addCreateTableSql('countries', "
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`code` CHAR(2) NOT NULL DEFAULT 'DE',
+`descr` VARCHAR(255) NOT NULL DEFAULT 'Deutschland',
+`is_active` ENUM('Y','N') NOT NULL DEFAULT 'N',
+PRIMARY KEY (`id`),
+UNIQUE INDEX (`code`)",
+ 'Country codes and their full-length descriptions');
+
+ // Insert first (Germany) country
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DE','Deutschland','Y')");