Skip to content
This repository was archived by the owner on Mar 31, 2022. It is now read-only.

Commit ab17413

Browse files
filipemenezesfilipemenezes
committed
Engine and collate from tables install script updated
1 parent ec9b4d6 commit ab17413

1 file changed

Lines changed: 12 additions & 12 deletions

File tree

‎db/install.sql‎

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -16,7 +16,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_user` (
1616

1717
PRIMARY KEY (`id`),
1818
KEY `username` (`username`)
19-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
19+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
2020

2121
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_chat` (
2222
`id` bigint COMMENT 'Unique user or chat identifier',
@@ -30,7 +30,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_chat` (
3030

3131
PRIMARY KEY (`id`),
3232
KEY `old_id` (`old_id`)
33-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
33+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
3434

3535
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_user_chat` (
3636
`user_id` bigint COMMENT 'Unique user identifier',
@@ -40,7 +40,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_user_chat` (
4040

4141
FOREIGN KEY (`user_id`) REFERENCES `glpi_plugin_telegrambot_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
4242
FOREIGN KEY (`chat_id`) REFERENCES `glpi_plugin_telegrambot_chat` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
43-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
43+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
4444

4545
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_inline_query` (
4646
`id` bigint UNSIGNED COMMENT 'Unique identifier for this query',
@@ -54,7 +54,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_inline_query` (
5454
KEY `user_id` (`user_id`),
5555

5656
FOREIGN KEY (`user_id`) REFERENCES `glpi_plugin_telegrambot_user` (`id`)
57-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
57+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
5858

5959
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_chosen_inline_result` (
6060
`id` bigint UNSIGNED AUTO_INCREMENT COMMENT 'Unique identifier for this entry',
@@ -69,7 +69,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_chosen_inline_result` (
6969
KEY `user_id` (`user_id`),
7070

7171
FOREIGN KEY (`user_id`) REFERENCES `glpi_plugin_telegrambot_user` (`id`)
72-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
72+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
7373

7474
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_message` (
7575
`chat_id` bigint COMMENT 'Unique chat identifier',
@@ -124,7 +124,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_message` (
124124
FOREIGN KEY (`reply_to_chat`, `reply_to_message`) REFERENCES `glpi_plugin_telegrambot_message` (`chat_id`, `id`),
125125
FOREIGN KEY (`forward_from`) REFERENCES `glpi_plugin_telegrambot_user` (`id`),
126126
FOREIGN KEY (`left_chat_member`) REFERENCES `glpi_plugin_telegrambot_user` (`id`)
127-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
127+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
128128

129129
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_callback_query` (
130130
`id` bigint UNSIGNED COMMENT 'Unique identifier for this query',
@@ -142,7 +142,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_callback_query` (
142142

143143
FOREIGN KEY (`user_id`) REFERENCES `glpi_plugin_telegrambot_user` (`id`),
144144
FOREIGN KEY (`chat_id`, `message_id`) REFERENCES `glpi_plugin_telegrambot_message` (`chat_id`, `id`)
145-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
145+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
146146

147147
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_edited_message` (
148148
`id` bigint UNSIGNED AUTO_INCREMENT COMMENT 'Unique identifier for this entry',
@@ -162,7 +162,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_edited_message` (
162162
FOREIGN KEY (`chat_id`) REFERENCES `glpi_plugin_telegrambot_chat` (`id`),
163163
FOREIGN KEY (`chat_id`, `message_id`) REFERENCES `glpi_plugin_telegrambot_message` (`chat_id`, `id`),
164164
FOREIGN KEY (`user_id`) REFERENCES `glpi_plugin_telegrambot_user` (`id`)
165-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
165+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
166166

167167
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_telegram_update` (
168168
`id` bigint UNSIGNED COMMENT 'Update''s unique identifier',
@@ -185,7 +185,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_telegram_update` (
185185
FOREIGN KEY (`chosen_inline_result_id`) REFERENCES `glpi_plugin_telegrambot_chosen_inline_result` (`id`),
186186
FOREIGN KEY (`callback_query_id`) REFERENCES `glpi_plugin_telegrambot_callback_query` (`id`),
187187
FOREIGN KEY (`edited_message_id`) REFERENCES `glpi_plugin_telegrambot_edited_message` (`id`)
188-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
188+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
189189

190190
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_conversation` (
191191
`id` bigint(20) unsigned AUTO_INCREMENT COMMENT 'Unique identifier for this entry',
@@ -204,7 +204,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_conversation` (
204204

205205
FOREIGN KEY (`user_id`) REFERENCES `glpi_plugin_telegrambot_user` (`id`),
206206
FOREIGN KEY (`chat_id`) REFERENCES `glpi_plugin_telegrambot_chat` (`id`)
207-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
207+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
208208

209209
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_botan_shortener` (
210210
`id` bigint UNSIGNED AUTO_INCREMENT COMMENT 'Unique identifier for this entry',
@@ -216,7 +216,7 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_botan_shortener` (
216216
PRIMARY KEY (`id`),
217217

218218
FOREIGN KEY (`user_id`) REFERENCES `glpi_plugin_telegrambot_user` (`id`)
219-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
219+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;
220220

221221
CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_request_limiter` (
222222
`id` bigint UNSIGNED AUTO_INCREMENT COMMENT 'Unique identifier for this entry',
@@ -226,4 +226,4 @@ CREATE TABLE IF NOT EXISTS `glpi_plugin_telegrambot_request_limiter` (
226226
`created_at` timestamp NULL DEFAULT NULL COMMENT 'Entry date creation',
227227

228228
PRIMARY KEY (`id`)
229-
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
229+
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;

0 commit comments

Comments
 (0)