From 278dc8e5b0c3830e661fd8297a65e71a66eed4ce Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Mon, 26 Dec 2011 16:25:39 +0100
Subject: changed angel types table layout

---
 db/install.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'db/install.sql')

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`
-- 
cgit v1.2.3-54-g00ecf

