summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2011-12-26 16:13:37 +0100
committerPhilip Häusler <msquare@notrademark.de>2011-12-26 16:13:37 +0100
commit0d37e85f347a59e51a94c0bc7443c0377f6efba6 (patch)
tree870357bfb25c1dfbc435250d8d251970ddf2de77
parentd0bb9fbbebf2112b7330476a471c18e06222634b (diff)
#44 table userangeltypes
-rw-r--r--db/install.sql9
1 files changed, 8 insertions, 1 deletions
diff --git a/db/install.sql b/db/install.sql
index e12ccb99..9e414f89 100644
--- a/db/install.sql
+++ b/db/install.sql
@@ -1170,6 +1170,13 @@ CREATE TABLE IF NOT EXISTS `Wecken` (
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--- Daten für Tabelle `Wecken`
+-- Tabellenstruktur für Tabelle `UserAngelTypes`
--
+CREATE TABLE `engelsystem`.`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 ;