diff options
| author | Philip Häusler <msquare@notrademark.de> | 2011-12-26 16:25:39 +0100 |
|---|---|---|
| committer | Philip Häusler <msquare@notrademark.de> | 2011-12-26 16:25:39 +0100 |
| commit | 278dc8e5b0c3830e661fd8297a65e71a66eed4ce (patch) | |
| tree | 2c8a9657f177e012df14cd9e6fadc74ca4d2d222 /db/install.sql | |
| parent | 0d37e85f347a59e51a94c0bc7443c0377f6efba6 (diff) | |
changed angel types table layout
Diffstat (limited to 'db/install.sql')
| -rw-r--r-- | db/install.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/db/install.sql b/db/install.sql index 9e414f89..77c1c559 100644 --- a/db/install.sql +++ b/db/install.sql @@ -20,12 +20,12 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- CREATE TABLE IF NOT EXISTS `AngelTypes` ( - `TID` int(11) NOT NULL AUTO_INCREMENT, - `Name` varchar(25) NOT NULL DEFAULT '', - `Man` text, - PRIMARY KEY (`TID`), - UNIQUE KEY `Name` (`Name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; + `id` int(11) NOT NULL AUTO_INCREMENT, + `name` varchar(25) NOT NULL DEFAULT '', + `restricted` int(1) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `Name` (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- Daten für Tabelle `AngelTypes` |