More fixes, thanks to Piter01

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

diff --git a/inc/extensions/ext-rallye.php b/inc/extensions/ext-rallye.php
index 541692f87f44c38cb2ecb7f06c868d7aa1277d5d..5d8d1c54a9ac5b50709ef477ef8dc35604534bad 100644 (file)
--- a/inc/extensions/ext-rallye.php
+++ b/inc/extensions/ext-rallye.php
@@ -55,12 +55,12 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
        $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_users";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_data (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
        $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_users";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_data (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,

-admin_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+admin_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

 title VARCHAR(255) NOT NULL DEFAULT '',
 descr LONGBLOB NOT NULL,
 template VARCHAR(255) NOT NULL DEFAULT '',
 title VARCHAR(255) NOT NULL DEFAULT '',
 descr LONGBLOB NOT NULL,
 template VARCHAR(255) NOT NULL DEFAULT '',

-start_time VARCHAR(10) NOT NULL DEFAULT '0',
-end_time VARCHAR(10) NOT NULL DEFAULT '0',
+start_time VARCHAR(10) NOT NULL DEFAULT 0,
+end_time VARCHAR(10) NOT NULL DEFAULT 0,

 auto_add_new_user ENUM('Y','N') NOT NULL DEFAULT 'Y',
 is_active ENUM('Y','N') NOT NULL DEFAULT 'N',
 send_notify ENUM('Y','N') NOT NULL DEFAULT 'Y',
 auto_add_new_user ENUM('Y','N') NOT NULL DEFAULT 'Y',
 is_active ENUM('Y','N') NOT NULL DEFAULT 'N',
 send_notify ENUM('Y','N') NOT NULL DEFAULT 'Y',


@@ -70,18 +70,18 @@ PRIMARY KEY (id)
 ) TYPE=MyISAM";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_prices (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 ) TYPE=MyISAM";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_prices (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,

-rallye_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-price_level BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-points BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+rallye_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+price_level BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+points BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

 info LONGBLOB NOT NULL,
 KEY (rallye_id),
 PRIMARY KEY(id)
 ) TYPE=MyISAM";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_users (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 info LONGBLOB NOT NULL,
 KEY (rallye_id),
 PRIMARY KEY(id)
 ) TYPE=MyISAM";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_users (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,

-rallye_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-userid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-refs BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+rallye_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+userid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+refs BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

 KEY (rallye_id),
 KEY (userid),
 PRIMARY KEY(id)
 KEY (rallye_id),
 KEY (userid),
 PRIMARY KEY(id)


@@ -157,7 +157,7 @@ case "update": // Update an extension
                break;
 
        case "0.1.0": // SQL queries for v0.2.1
                break;
 
        case "0.1.0": // SQL queries for v0.2.1

-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users CHANGE curr_points curr_points DOUBLE(23,5) NOT NULL DEFAULT '0.00000'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users CHANGE curr_points curr_points DOUBLE(23,5) NOT NULL DEFAULT 0.00000";

 
                // Update notes (these will be set as task text!)
                $UPDATE_NOTES = "5 Nachkommastellen implementiert.";
 
                // Update notes (these will be set as task text!)
                $UPDATE_NOTES = "5 Nachkommastellen implementiert.";


@@ -209,7 +209,7 @@ case "update": // Update an extension
                break;
 
        case "0.2.0": // SQL queries for v0.2.0
                break;
 
        case "0.2.0": // SQL queries for v0.2.0

-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_users BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_users BIGINT(20) UNSIGNED NOT NULL DEFAULT 0";

                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_prices BIGINT(20) UNSIGNED NOT NULL DEFAULT '3'";
 
                // Update notes (these will be set as task text!)
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_prices BIGINT(20) UNSIGNED NOT NULL DEFAULT '3'";
 
                // Update notes (these will be set as task text!)