More default values rewritten, UNSIGNED added to many numerical database columns...

[mailer.git] / inc / extensions / ext-booking.php

diff --git a/inc/extensions/ext-booking.php b/inc/extensions/ext-booking.php
index c438f0700435a1a79b3ce8872e0f813c79b80284..8cf06592216a121f73d5ddaabdc86f1f35b8b9e2 100644 (file)
--- a/inc/extensions/ext-booking.php
+++ b/inc/extensions/ext-booking.php
@@ -56,11 +56,11 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
        // Drop/create table for user bookings
        $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_user_book`";
        $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_user_book`(
-`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `subject` VARCHAR(255) NOT NULL DEFAULT 'missing',
 `mode` ENUM('add','sub') NOT NULL DEFAULT 'add',
-`points` DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.0000,
+`points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.0000,
 INDEX (`userid`),
 PRIMARY KEY(`id`)
 ) TYPE=MyISAM COMMENT='Member points booking table'";