LAS (logical area system) table renamed, table comments added:

- For all extension tables there is now a comment :-) Have fun to read.
- Table admin_menu_stats renamed to admin_las_stats to make it more clear

diff --git a/inc/extensions/ext-admins.php b/inc/extensions/ext-admins.php
index 53996e7c995c27f770dff0a32efd34f39a3d6518..2759d3f7935a47d186e7fb274d910e44bb760044 100644 (file)
--- a/inc/extensions/ext-admins.php
+++ b/inc/extensions/ext-admins.php
@@ -111,7 +111,7 @@ switch (getExtensionMode()) {
 `access_mode` ENUM('deny','allow') NOT NULL DEFAULT 'deny',
 KEY (`admin_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Access control lines (ACLs)'");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Sogn. ACLs werden hinzugef&uuml;gt: <strong>A</strong>ccess <strong>C</strong>ontrol <strong>L</strong>ines sind zu deutsch Zugriffkontrollzeilen, mit denen Sie einstellen k&ouml;nnen, was welcher Admin machen darf oder nicht. <strong>Nur Sie haben momentan Vollzugriff auf den Adminbereich.</strong>");
@@ -129,7 +129,7 @@ PRIMARY KEY (`id`)
 `mail_template` VARCHAR(255) NOT NULL,
 KEY (`admin_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Mail template -> admin connection table'");
                                addExtensionSql("INSERT INTO  `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('admins','admins_mails','Admin-Mails','Stellen Sie hier ein, welcher Admin welche Mail erhalten soll. Sie k&ouml;nnen dies (derzeit) jedoch erst, wenn einmal die Mail versendet wurde!',5)");
 
                                // Update notes (these will be set as task text!)

diff --git a/inc/extensions/ext-bank.php b/inc/extensions/ext-bank.php
index be9151be460137c3427f9db62698b0fc6bc0fc2f..be1fe1884a7e13f450ab6e0a4346b07d30d41129 100644 (file)
--- a/inc/extensions/ext-bank.php
+++ b/inc/extensions/ext-bank.php
@@ -54,44 +54,44 @@ switch (getExtensionMode()) {
                // SQL commands to run
                addDropTableSql('bank_accounts');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_bank_accounts` (
-id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-userid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-account_created BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-account_locked BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-locked_reason TINYTEXT,
-status ENUM('NEW','ACTIVE','LOCKED') NOT NULL DEFAULT 'NEW',
-account_balance FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
-output_mode ENUM('LOGIN','EMAIL','DISABLED'),
-pin VARCHAR(50) NOT NULL DEFAULT '',
-tan_mode ENUM('NORMAL','INDEXED'),
-tan_list_status ENUM('PENDING','ACTIVE','INVALID','LOCKED') NOT NULL DEFAULT 'PENDING',
-tan_key VARCHAR(50) NOT NULL DEFAULT '',
-month_transfered BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-last_tan VARCHAR(5) NOT NULL DEFAULT '00000',
-last_tan_stamp BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-last_tan_purpose TINYTEXT,
-account_type ENUM('CHECK','SAVING') NOT NULL DEFAULT 'CHECK',
-overdraft_credit FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
-PRIMARY KEY (id),
-UNIQUE KEY (pin),
-INDEX `userid_type` (userid, account_type),
-INDEX (account_created),
-INDEX (account_locked),
-INDEX (last_tan_stamp)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`account_created` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`account_locked` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`locked_reason` TINYTEXT,
+`status` ENUM('NEW','ACTIVE','LOCKED') NOT NULL DEFAULT 'NEW',
+`account_balance` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+`output_mode` ENUM('LOGIN','EMAIL','DISABLED'),
+`pin` VARCHAR(50) NOT NULL DEFAULT '',
+`tan_mode` ENUM('NORMAL','INDEXED'),
+`tan_list_status` ENUM('PENDING','ACTIVE','INVALID','LOCKED') NOT NULL DEFAULT 'PENDING',
+`tan_key` VARCHAR(50) NOT NULL DEFAULT '',
+`month_transfered` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`last_tan` VARCHAR(5) NOT NULL DEFAULT '00000',
+`last_tan_stamp` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`last_tan_purpose` TINYTEXT,
+`account_type` ENUM('CHECK','SAVING') NOT NULL DEFAULT 'CHECK',
+`overdraft_credit` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+PRIMARY KEY (`id`),
+UNIQUE KEY (`pin`),
+INDEX `userid_type` (`userid`, `account_type`),
+INDEX (`account_created`),
+INDEX (`account_locked`),
+INDEX (`last_tan_stamp`)
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User bank accounts data'");
                addDropTableSql('bank_transfers');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_bank_transfers` (
-id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-to_account_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-from_account_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-points_amount FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
-day_bookkeeping CHAR(4) NOT NULL DEFAULT '0000',
-day_available CHAR(4) NOT NULL DEFAULT '0000',
-transfer_purpose TINYTEXT,
-PRIMARY KEY (id),
-INDEX (to_account_id, from_account_id),
-INDEX (day_bookkeeping, day_available)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`to_account_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`from_account_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`points_amount` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+`day_bookkeeping` CHAR(4) NOT NULL DEFAULT '0000',
+`day_available` CHAR(4) NOT NULL DEFAULT '0000',
+`transfer_purpose` TINYTEXT,
+PRIMARY KEY (`id`),
+INDEX (`to_account_id`, `from_account_id`),
+INDEX (`day_bookkeeping`, `day_available`)
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Bank user->user transfers'");
                addDropTableSql('bank_packages');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_bank_packages` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -111,8 +111,8 @@ INDEX (day_bookkeeping, day_available)
 `free_account_stuff` TINYTEXT null,
 `tan_lock` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
-               // free_account_stuff will be a list of columns of the table _bank_packages
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Bank account packages'");
+               // Free_account_stuff will be a list of columns of the table _bank_packages
                // what the member shall get for the specified income. output_system_mode
                // must be extended with the mode you get for free: output_system_mode:LOGIN
                // should be fine. More than one entry and not DISABLED ;) are not supported.
@@ -125,7 +125,7 @@ PRIMARY KEY (`id`)
 `used` ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY (`id`),
 UNIQUE (`account_id`, `tan`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Bank TAN lists per user'");
 
                // Admin menu queries
                addAdminMenuSql('bank', NULL, 'Bank-Accounts','Verwalten Sie hier alle Bank-Accounts Ihrer Mitglieder, sowie Angebotspakete und Überweisungen.', 6);

diff --git a/inc/extensions/ext-beg.php b/inc/extensions/ext-beg.php
index 0a4f650bd24bda1a5458b5fcae6c9a54965c7081..c5ead91f5e5e4a4f611fef9967de2bdb35cde9d8 100644 (file)
--- a/inc/extensions/ext-beg.php
+++ b/inc/extensions/ext-beg.php
@@ -65,7 +65,7 @@ switch (getExtensionMode()) {
 `sid` VARCHAR(255) NOT NULL DEFAULT '',
 KEY (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'IP lock data for beg links'");
                break;
 
        case 'remove': // Do stuff when removing extension

diff --git a/inc/extensions/ext-birthday.php b/inc/extensions/ext-birthday.php
index 42e797914b54c12eb1b914282a861630daa86feb..5c96814e86266155da12ce23d431af70196111fa 100644 (file)
--- a/inc/extensions/ext-birthday.php
+++ b/inc/extensions/ext-birthday.php
@@ -86,7 +86,7 @@ switch (getExtensionMode()) {
 `chk_value` VARCHAR(255) NOT NULL DEFAULT '',
 KEY (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Pending birthday codes'");
                                addAdminMenuSql('setup','config_birthday','Geburtstagsmails','Stellen Sie hier ein, ob die Mitglieder {OPEN_CONFIG}POINTS{CLOSE_CONFIG} (nicht automatisch) gutgeschrieben kommen sollen oder nicht.', 9);
 
                                // Update notes (these will be set as task text!)

diff --git a/inc/extensions/ext-bonus.php b/inc/extensions/ext-bonus.php
index 789987a98762764ff1feca7f92820322f77ebb36..b57f4fced32058f8501dd69183f1939b9826502f 100644 (file)
--- a/inc/extensions/ext-bonus.php
+++ b/inc/extensions/ext-bonus.php
@@ -156,7 +156,7 @@ PRIMARY KEY (`id`),
 INDEX `mail_id` (`mail_id`),
 INDEX `bonus_id` (`bonus_id`),
 INDEX `userid` (`userid`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Fastest click rallye table'");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Turbo-Bonus wird in Tabelle gezählt für Anzeige, wer alles bereits geklickt hat und welchen Platz er gemacht hat.");

diff --git a/inc/extensions/ext-country.php b/inc/extensions/ext-country.php
index 5ed4b84c997ceb8ea075be5075294271a09bef6e..fd04c72618c112742059f0a731b05c7e8fcefd76 100644 (file)
--- a/inc/extensions/ext-country.php
+++ b/inc/extensions/ext-country.php
@@ -60,7 +60,7 @@ switch (getExtensionMode()) {
 `is_active` ENUM('Y','N') NOT NULL DEFAULT 'N',
 KEY (`code`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Country codes and their full-length descriptions'");
                addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (code, descr, is_active) VALUES ('DE','Deutschland','Y')");
 
                // Admin menu

diff --git a/inc/extensions/ext-doubler.php b/inc/extensions/ext-doubler.php
index da931e12c5bdf45f7fb39002482a0ce53fed818a..15a59f000143d60225b45f8e7f802b3e0fd8c8a5 100644 (file)
--- a/inc/extensions/ext-doubler.php
+++ b/inc/extensions/ext-doubler.php
@@ -62,7 +62,7 @@ switch (getExtensionMode()) {
 KEY (`refid`),
 KEY (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User doubler data'");
 
                //
                // --- SETTINGS ---

diff --git a/inc/extensions/ext-holiday.php b/inc/extensions/ext-holiday.php
index 8f93dacf6b1130166441b58a30862f3b55fc497c..6e025d459992f02e4a5600c977a8939d1f4bf1c0 100644 (file)
--- a/inc/extensions/ext-holiday.php
+++ b/inc/extensions/ext-holiday.php
@@ -58,7 +58,7 @@ switch (getExtensionMode()) {
 `comments` LONGTEXT NOT NULL,
 INDEX (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User holiday data'");
 
                // Add default values to config
                addConfigAddSql("holiday_max BIGINT(20) UNSIGNED NOT NULL DEFAULT '30'");

diff --git a/inc/extensions/ext-mediadata.php b/inc/extensions/ext-mediadata.php
index 71da33b5aab327b725ebfd2f16ba1a57891a8c44..c328aa75c70bf61fe0cdc17505e159f264550ab5 100644 (file)
--- a/inc/extensions/ext-mediadata.php
+++ b/inc/extensions/ext-mediadata.php
@@ -104,7 +104,7 @@ switch (getExtensionMode()) {
 `media_key` VARCHAR(255) NOT NULL DEFAULT '',
 `media_value` VARCHAR(255) NOT NULL DEFAULT '',
 PRIMARY KEY (`media_key`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Media data key->value'");
 
                                // Add auto-check file
                                addIncludeToPool('extension', 'inc/gen_mediadata.php');

diff --git a/inc/extensions/ext-online.php b/inc/extensions/ext-online.php
index 210f331aa503b026ad719b45f973f08f30d5c39d..8ea5bd76ac62b41d3a11aa188f32b5e6d8e5ca8f 100644 (file)
--- a/inc/extensions/ext-online.php
+++ b/inc/extensions/ext-online.php
@@ -66,7 +66,7 @@ PRIMARY KEY (`id`),
 INDEX (`userid`),
 INDEX (`refid`),
 INDEX `admin_member` (`is_admin`, `is_member`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Who-is-where data'");
                addAdminMenuSql('misc','usr_online','Online-Statistik','Eine Liste von derzeit "Online" Usern. Doppelte Einträge könnte auf mangelnden Cookie-Support des Browsers oder auf einen Spider hindeuten.', 1);
                break;
 

diff --git a/inc/extensions/ext-optimize.php b/inc/extensions/ext-optimize.php
index 0bdd839066677a27b3c792913e8a17e5f3ad2e95..dc434dfbf9fd3360a8bd2b1d2f78ea97c42aa387 100644 (file)
--- a/inc/extensions/ext-optimize.php
+++ b/inc/extensions/ext-optimize.php
@@ -57,7 +57,7 @@ switch (getExtensionMode()) {
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `gain` decimal(10,3) NOT NULL DEFAULT '0.000',
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Optimization history data'");
                addAdminMenuSql('misc', 'optimize', 'DB optimieren', 'Führen Sie dies ab und an aus, damit überflüssige Binärdaten aus der Datenbank entfernt werden.', 5);
                break;
 

diff --git a/inc/extensions/ext-payout.php b/inc/extensions/ext-payout.php
index 8a1b8fb86987d741f37a9ed9f7b7acbbeb3385cf..10f30779093073cb3d7b20ac92458ed1fb94de9a 100644 (file)
--- a/inc/extensions/ext-payout.php
+++ b/inc/extensions/ext-payout.php
@@ -62,7 +62,7 @@ switch (getExtensionMode()) {
 INDEX (`userid`),
 INDEX (`payout_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Done user payouts (and status)'");
                addDropTableSql('payout_types');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_payout_types` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -70,7 +70,7 @@ PRIMARY KEY (`id`)
 `rate` FLOAT(22,3) UNSIGNED NOT NULL DEFAULT '0.000',
 `min_points` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Payout types'");
                addAdminMenuSql('setup','config_payouts','Auszahlungen','Auszahlungsarten einstellen, neu anlegen oder löschen.',15);
                addAdminMenuSql('payouts','list_payouts','Anfragen auflisten','Listet alle Auszahlungsanfragen Ihrer Mitglieder auf.',16);
                addMemberMenuSql('main','payout','Auszahlungen','N','N',11);

diff --git a/inc/extensions/ext-rallye.php b/inc/extensions/ext-rallye.php
index 90583365c6fefcfe457a0756dcf6e39c28e052f7..f874bd1eb993e81e53e01e24efebdd35f0fedd5e 100644 (file)
--- a/inc/extensions/ext-rallye.php
+++ b/inc/extensions/ext-rallye.php
@@ -64,7 +64,7 @@ switch (getExtensionMode()) {
 `notified` ENUM('Y','N') NOT NULL DEFAULT 'N',
 KEY (`admin_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Main rallye data'");
                addDropTableSql('rallye_prices');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_rallye_prices` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -74,7 +74,7 @@ PRIMARY KEY (`id`)
 `info` LONGTEXT NOT NULL,
 INDEX (`rallye_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Prices data for a rallye'");
                addDropTableSql('rallye_users');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_rallye_users` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -84,7 +84,7 @@ PRIMARY KEY (`id`)
 INDEX (`rallye_id`),
 INDEX (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Rallye->user connection table'");
 
                // Admin menu
                addAdminMenuSql('rallye', NULL, 'Rallye-Management','Richten Sie neue Ref-Rallyes ein, die zeitgesteuert anfangen und aufhöhren. Dabei wird alles weitere automatisch geregelt.',9);

diff --git a/inc/extensions/ext-register.php b/inc/extensions/ext-register.php
index be486be9146d80cdc1fd45fceb70c930ee371817..dcaa8e3793f78956cc5a5289efeb207393289a05 100644 (file)
--- a/inc/extensions/ext-register.php
+++ b/inc/extensions/ext-register.php
@@ -54,8 +54,8 @@ switch (getExtensionMode()) {
 
        case 'remove': // Do stuff when removing extension
                // SQL commands to run
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_register'");
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='register'");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_register' LIMIT 1");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='register' LIMIT 1");
                addDropTableSql('must_register');
 
                // Unregister a filter
@@ -81,7 +81,7 @@ switch (getExtensionMode()) {
 `field_name` VARCHAR(255) NOT NULL DEFAULT '',
 `field_required` ENUM('Y','N') NOT NULL DEFAULT 'Y',
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Data which fields the user must fill out'");
 
                                // Add all entries as required (DO NOT DELETE THEM FROM DATABASE!)
                                addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_must_register` (`field_name`, `field_required`) VALUES ('surname','Y')");

diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php
index ea912b947c570814a60b8be32e0749b2b5e886d2..cf3564a6af76ab3828c3b76d62ac12cf2f5a00b2 100644 (file)
--- a/inc/extensions/ext-sponsor.php
+++ b/inc/extensions/ext-sponsor.php
@@ -98,7 +98,7 @@ INDEX (`refid`),
 INDEX (`email`),
 UNIQUE KEY (`hash`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Main sponsor data'");
                //
                // Sponsor orders
                //
@@ -118,7 +118,7 @@ INDEX (`regid`),
 INDEX (`admin_id`),
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor orders table'");
                //
                // Pay-types
                //
@@ -130,7 +130,7 @@ PRIMARY KEY (`id`)
 `pay_min_count` BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,
 `pay_currency` VARCHAR(255) NOT NULL DEFAULT '€',
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor payment types'");
                //
                // Points-to-action converting
                //
@@ -142,7 +142,7 @@ PRIMARY KEY (`id`)
 `conv_name` VARCHAR(255) NOT NULL DEFAULT 'Mails',
 INDEX (`ext_name`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Points to action convertion data'");
                //
                // Sponsor menu system (default)
                //
@@ -158,7 +158,7 @@ INDEX (`action`),
 UNIQUE KEY `action_what` (`action`,`what`),
 UNIQUE KEY (`what`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor menu'");
                //
                // Registry for performable actions by your sponsors
                //
@@ -172,7 +172,7 @@ PRIMARY KEY (`id`)
 INDEX (`ext_name`),
 INDEX (`admin_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor action registry'");
                //
                // URLs from the sponsors
                //
@@ -186,7 +186,7 @@ PRIMARY KEY (`id`)
 `status` ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'URLs from all sponsors'");
                //
                // Banners of any size from the sponsors
                //
@@ -202,7 +202,7 @@ PRIMARY KEY (`id`)
 `status` ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Banners from all sponsors'");
                //
                // Campaigns
                //
@@ -225,7 +225,7 @@ PRIMARY KEY (`id`)
 INDEX (`admin_id`),
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor campaigns'");
                //
                // Campaigns + URLs + Banner
                //
@@ -241,7 +241,7 @@ INDEX (`bannerid`),
 INDEX (`urlid`),
 INDEX (`campaignid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Campaign+Banner+URL connection data'");
                //
                // Allowed data to display (administrative)
                //
@@ -251,7 +251,7 @@ PRIMARY KEY (`id`)
 `data_row` VARCHAR(255) NOT NULL DEFAULT '',
 `display` ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Allowed data to display to the admin'");
                //
                // Allowed data to display (sponsor-side)
                //
@@ -263,7 +263,7 @@ PRIMARY KEY (`id`)
 `display` ENUM('Y','N') NOT NULL DEFAULT 'N',
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Data sponsors allowed to see'");
                //
                // Default allowed data to display
                //

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index 51d6045a02b7c9ff5b3ae9833d88031b4e0dabdb..1549db5e50e4b9098d07613efa1c357a91f02531 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -59,7 +59,7 @@ switch (getExtensionMode()) {
                // Drop tables
                addDropTableSql('admin_menu_las');
                addDropTableSql('admin_menu_las_data');
-               addDropTableSql('admin_menu_stats');
+               addDropTableSql('admin_las_stats');
                addDropTableSql('filters');
                addDropTableSql('dns_cache');
 
@@ -367,7 +367,7 @@ switch (getExtensionMode()) {
                                break;
 
                        case '0.3.2': // SQL queries for v0.3.2
-                               // Connection table between the menu system and the "logical area" system
+                               // Connection table between the menu system and the "logical area system"
                                addDropTableSql('admin_menu_las');
                                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_las` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -378,7 +378,7 @@ INDEX (`la_id`),
 INDEX (`la_action`),
 INDEX (`la_what`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Menu system -> LAS'");
                                // All "logical areas" together
                                addDropTableSql('admin_menu_las_data');
                                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_las_data` (
@@ -391,7 +391,7 @@ UNIQUE KEY (`la_id`),
 INDEX (`la_posx`),
 INDEX (`la_posy`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'LAS position and title data'");
                                // Which menu do you like?
                                addConfigAddSql('admin_menu', "ENUM('NEW','OLD') NOT NULL DEFAULT 'OLD'");
 
@@ -407,15 +407,15 @@ PRIMARY KEY (`id`)
                                addConfigAddSql('admin_menu_sorter', "ENUM('Y','N') NOT NULL DEFAULT 'Y'");
 
                                // The statistics table
-                               addDropTableSql('admin_menu_stats');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_stats` (
+                               addDropTableSql('admin_las_stats');
+                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_las_stats` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `type` ENUM('la','action','what') NOT NULL DEFAULT 'what',
 `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 INDEX (`admin_id`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'LAS click data'");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Admin-abhängig werden nun Klicks im Admin-Menü gezählt, die zur automatischen Anpassung des Menüs in den logischen Bereichen diennen. Dieses "intelligente Unbauen" können Sie auch ganz abschalten.");

diff --git a/inc/extensions/ext-transfer.php b/inc/extensions/ext-transfer.php
index 9686b0d0b3d40aecd014959dfe9f14f4c660f640..4d0e516c4f5afebc7036db1396b87bdc2916a39f 100644 (file)
--- a/inc/extensions/ext-transfer.php
+++ b/inc/extensions/ext-transfer.php
@@ -61,7 +61,7 @@ switch (getExtensionMode()) {
 KEY (`userid`),
 KEY (`from_userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Ingoing points transfers'");
 
                // Transfers to a member
                addDropTableSql('user_transfers_out');
@@ -76,7 +76,7 @@ PRIMARY KEY (`id`)
 KEY (`userid`),
 KEY (`to_userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Outgoing points transfers'");
 
                // Admin menu
                addAdminMenuSql('transfer', NULL, '{OPEN_CONFIG}POINTS{CLOSE_CONFIG}-Transfer','Verwalten Sie hier die {OPEN_CONFIG}POINTS{CLOSE_CONFIG}-Transaktionen zwischen Ihren Mitgliedern.', 7);

diff --git a/inc/extensions/ext-user.php b/inc/extensions/ext-user.php
index 344cb3258906753f11307c0d574465fc987a0211..8cc037b7daaf6577640794c1877ec1a866f8e77f 100644 (file)
--- a/inc/extensions/ext-user.php
+++ b/inc/extensions/ext-user.php
@@ -59,7 +59,7 @@ switch (getExtensionMode()) {
 PRIMARY KEY (`id`),
 INDEX (`userid`),
 INDEX (`cat_id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User->category connection data'");
 
                addDropTableSql('user_data');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_data` (
@@ -100,7 +100,7 @@ PRIMARY KEY (`userid`),
 UNIQUE (`user_hash`),
 INDEX (`refid`),
 INDEX `status_mails` (`status`,`max_mails`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Main user data'");
 
                addDropTableSql('user_points');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_points` (
@@ -111,7 +111,7 @@ INDEX `status_mails` (`status`,`max_mails`)
 `locked_points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 PRIMARY KEY (`id`),
 INDEX (`userid`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User points (no used points)'");
 
                addDropTableSql('user_links');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_links` (
@@ -122,7 +122,7 @@ INDEX (`userid`)
 PRIMARY KEY (`id`),
 INDEX (`userid`),
 INDEX (`stats_id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Unconfirmed mails per user'");
 
                addDropTableSql('user_stats');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_stats` (
@@ -144,7 +144,7 @@ INDEX (`userid`),
 INDEX (`cat_id`),
 INDEX (`payment_id`),
 INDEX (`pool_id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Mail statistics per user order'");
 
                addDropTableSql('user_stats_data');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_stats_data` (

diff --git a/inc/extensions/ext-wernis.php b/inc/extensions/ext-wernis.php
index cbd6d61f31ec199442e868adab7048ff4b72dd12..d781efb44755dfbea3397086f0b6410a80cb1ef4 100644 (file)
--- a/inc/extensions/ext-wernis.php
+++ b/inc/extensions/ext-wernis.php
@@ -61,7 +61,7 @@ switch (getExtensionMode()) {
 `wernis_api_status` VARCHAR(255) NULL DEFAULT NULL,
 INDEX (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Transfered Wernis per user'");
 
                // Confiuration
                addConfigAddSql("wernis_min_payout BIGINT(20) UNSIGNED NOT NULL DEFAULT '40000'");