diff options
author | Jan-Philipp Litza <janphilipp@litza.de> | 2011-12-26 16:56:54 +0100 |
---|---|---|
committer | Jan-Philipp Litza <janphilipp@litza.de> | 2011-12-26 16:56:54 +0100 |
commit | 01e7bdce1d0a232610b531661f418b0606c0fa84 (patch) | |
tree | 48574ea95b2d05148f6553269d6dcd791974e620 /db/install.sql | |
parent | d9896abc4d09f4469baa865f2caca457cd227f56 (diff) |
update script for UserAngelTypes and fixes to install.sql
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 ; |