} // END - if
// Version number
-setThisExtensionVersion('0.0.2');
+setThisExtensionVersion('0.0.3');
// Version history array (add more with , '0.0.1' and so on)
-setExtensionVersionHistory(array('0.0.0','0.0.1', '0.0.2'));
+setExtensionVersionHistory(array('0.0.0','0.0.1', '0.0.2', '0.0.3'));
switch (getExtensionMode()) {
case 'register': // Do stuff when installation is running
`refback` float(4,1) NOT NULL DEFAULT 0.0,
`points` FLOAT(20,5) DEFAULT 0.00000 NOT NULL,
PRIMARY KEY (`id`),
-UNIQUE `user_refid` (`userid`,`level`,`refid`),
+UNIQUE `user_refid` (`userid`, `level`, `refid`),
INDEX (`level`),
INDEX (`refid`)",
'User Referals With Refback');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Updates von ext-user hier her verschoben.");
break;
+
+ case '0.0.3': // SQL queries for v0.0.3
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_points_data` (`subject`, `column_name`, `locked_mode`, `payment_method`) VALUES ('refback','points','LOCKED','DIRECT')");
+
+ // This depends on ext-sql_patches
+ addExtensionDependency('sql_patches');
+
+ // Update notes
+ setExtensionUpdateNotes("Refback-Gutschriften werden nun über die Tabelle <strong>{OPEN_CONFIG}_MYSQL_PREFIX{CLOSE_CONFIG}_points_data</strong> verwaltet.");
+ break;
} // END - switch
break;