diff options
Diffstat (limited to 'db/install.sql')
| -rw-r--r-- | db/install.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/install.sql b/db/install.sql index 77c1c559..97103f51 100644 --- a/db/install.sql +++ b/db/install.sql @@ -1173,10 +1173,10 @@ CREATE TABLE IF NOT EXISTS `Wecken` ( -- Tabellenstruktur für Tabelle `UserAngelTypes` -- -CREATE TABLE `engelsystem`.`UserAngelTypes` ( +CREATE TABLE IF NOT EXISTS `UserAngelTypes` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `user_id` INT NOT NULL , `angeltype_id` INT NOT NULL , `confirm_user_id` INT NULL , INDEX ( `user_id` , `angeltype_id` , `confirm_user_id` ) -) ENGINE = MYISAM ; +) ENGINE = MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |