case 'register': // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// Coupon data
addDropTableSql('coupons');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_coupons` (
+ addCreateTableSql('coupons', "(
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`timestamp_created` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
`timestamp_expired` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
// Coupon->user connection table
addDropTableSql('user_coupons');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_coupons` (
+ addCreateTableSql('coupons', "(
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`coupon_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`userid` BIGINT(2) UNSIGNED NOT NULL DEFAULT 0,