From 6f8a68c6c5ed9eeae1bf790f5d758c800b5d5d5d Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Sat, 25 Jun 2011 02:34:12 +0000 Subject: [PATCH] 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 --- inc/extensions/ext-admins.php | 4 +- inc/extensions/ext-bank.php | 78 +++++++++++++++--------------- inc/extensions/ext-beg.php | 2 +- inc/extensions/ext-birthday.php | 2 +- inc/extensions/ext-bonus.php | 2 +- inc/extensions/ext-country.php | 2 +- inc/extensions/ext-doubler.php | 2 +- inc/extensions/ext-holiday.php | 2 +- inc/extensions/ext-mediadata.php | 2 +- inc/extensions/ext-online.php | 2 +- inc/extensions/ext-optimize.php | 2 +- inc/extensions/ext-payout.php | 4 +- inc/extensions/ext-rallye.php | 6 +-- inc/extensions/ext-register.php | 6 +-- inc/extensions/ext-sponsor.php | 24 ++++----- inc/extensions/ext-sql_patches.php | 14 +++--- inc/extensions/ext-transfer.php | 4 +- inc/extensions/ext-user.php | 10 ++-- inc/extensions/ext-wernis.php | 2 +- 19 files changed, 85 insertions(+), 85 deletions(-) diff --git a/inc/extensions/ext-admins.php b/inc/extensions/ext-admins.php index 53996e7c99..2759d3f793 100644 --- 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ügt: Access Control Lines sind zu deutsch Zugriffkontrollzeilen, mit denen Sie einstellen können, was welcher Admin machen darf oder nicht. Nur Sie haben momentan Vollzugriff auf den Adminbereich."); @@ -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ö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 be9151be46..be1fe1884a 100644 --- 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 0a4f650bd2..c5ead91f5e 100644 --- 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 42e797914b..5c96814e86 100644 --- 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 789987a987..b57f4fced3 100644 --- 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 5ed4b84c99..fd04c72618 100644 --- 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 da931e12c5..15a59f0001 100644 --- 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 8f93dacf6b..6e025d4599 100644 --- 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 71da33b5aa..c328aa75c7 100644 --- 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 210f331aa5..8ea5bd76ac 100644 --- 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 0bdd839066..dc434dfbf9 100644 --- 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 8a1b8fb869..10f3077909 100644 --- 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 90583365c6..f874bd1eb9 100644 --- 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 be486be914..dcaa8e3793 100644 --- 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 ea912b947c..cf3564a6af 100644 --- 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 51d6045a02..1549db5e50 100644 --- 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 9686b0d0b3..4d0e516c4f 100644 --- 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 344cb32589..8cc037b7da 100644 --- 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 cbd6d61f31..d781efb447 100644 --- 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'"); -- 2.30.2