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` (
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` (
`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` (
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` (
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` (