diff options
| author | Jan-Philipp Litza <janphilipp@litza.de> | 2011-12-26 16:37:19 +0100 |
|---|---|---|
| committer | Jan-Philipp Litza <janphilipp@litza.de> | 2011-12-26 16:37:19 +0100 |
| commit | d9896abc4d09f4469baa865f2caca457cd227f56 (patch) | |
| tree | 5b03b2413dc8f42d818b0d0505048516d6832c18 /db/install.sql | |
| parent | 36354d307eb7edca75b4dddec91e547b4d3ede46 (diff) | |
| parent | 278dc8e5b0c3830e661fd8297a65e71a66eed4ce (diff) | |
Merge branch 'master' of https://vcs.wybt.net/engelsystem/git
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` |