- Surfbar extended with dynamic percentage (only config)

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

diff --git a/inc/extensions/ext-rallye.php b/inc/extensions/ext-rallye.php
index 46065fd5bca3db8e9c840fe011f59af3a6b6fc03..e1d89f8397f7efed2a5eeaa559eece6dd5fdc836 100644 (file)
--- a/inc/extensions/ext-rallye.php
+++ b/inc/extensions/ext-rallye.php
@@ -55,34 +55,34 @@ case "register": // Do stuff when installtion is running (modules.php?module=adm
        $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_prices";
        $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_users";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_data (
-id bigint(20) not null auto_increment,
-admin_id bigint(20) not null default '0',
-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',
-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',
-notified enum('Y', 'N') not null default 'N',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) NOT NULL DEFAULT '0',
+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',
+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',
+notified ENUM('Y', 'N') NOT NULL DEFAULT 'N',
 KEY (admin_id),
 PRIMARY KEY (id)
 ) TYPE=MyISAM";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_prices (
-id bigint(20) not null auto_increment,
-rallye_id bigint(20) not null default '0',
-price_level bigint(20) not null default '0',
-points bigint(20) not null default '0',
-info longblob not null,
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+rallye_id BIGINT(20) NOT NULL DEFAULT '0',
+price_level BIGINT(20) NOT NULL DEFAULT '0',
+points BIGINT(20) 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) not null auto_increment,
-rallye_id bigint(20) not null default '0',
-userid bigint(20) not null default '0',
-refs bigint(20) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+rallye_id BIGINT(20) NOT NULL DEFAULT '0',
+userid BIGINT(20) NOT NULL DEFAULT '0',
+refs BIGINT(20) NOT NULL DEFAULT '0',
 KEY (rallye_id),
 KEY (userid),
 PRIMARY KEY(id)
@@ -124,14 +124,14 @@ case "update": // Update an extension
        switch ($EXT_VER)
        {
        case "0.0.1": // SQL queries for v0.0.1
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD expired enum('Y', 'N') not null default 'N'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD expired ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
 
                // Update notes (these will be set as task text!)
                $UPDATE_NOTES = "Ablaufen der Rallyes intergriert.";
                break;
 
        case "0.0.2": // SQL queries for v0.0.2
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users ADD curr_points double(23,3) not null default '0.000'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users ADD curr_points DOUBLE(23,3) NOT NULL DEFAULT '0.000'";
 
                // Update notes (these will be set as task text!)
                $UPDATE_NOTES = "Aktueller {!POINTS!}-Stand wird beachtet.";
@@ -158,7 +158,7 @@ case "update": // Update an extension
                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.";
@@ -210,8 +210,8 @@ case "update": // Update an extension
                break;
 
        case "0.2.0": // SQL queries for v0.2.0
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_users bigint(20) not null default '0'";
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_prices bigint(20) not null default '3'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_users BIGINT(20) NOT NULL DEFAULT '0'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_prices BIGINT(20) NOT NULL DEFAULT '3'";
 
                // Update notes (these will be set as task text!)
                $UPDATE_NOTES = "Ablaufen der Rallyes intergriert. Bauen Sie in Ihr Template <STRONG>templates/de/emails/member/member_rallye_notifty.tpl</STRONG> folgende zwei Zeilen ein:<br />