summaryrefslogtreecommitdiff
path: root/db/install.sql
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2011-12-26 16:25:39 +0100
committerPhilip Häusler <msquare@notrademark.de>2011-12-26 16:25:39 +0100
commit278dc8e5b0c3830e661fd8297a65e71a66eed4ce (patch)
tree2c8a9657f177e012df14cd9e6fadc74ca4d2d222 /db/install.sql
parent0d37e85f347a59e51a94c0bc7443c0377f6efba6 (diff)
changed angel types table layout
Diffstat (limited to 'db/install.sql')
-rw-r--r--db/install.sql12
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`