source: branches/posledni/sql/updates/626.sql

Last change on this file was 626, checked in by george, 15 years ago
  • Odebráno: Stará verze minimanageru.
  • Odebráno: Styrý neudržovaný systém správy domků spolků.
  • Opraveno: Zobrazení domků spolků.
File size: 514 bytes
Line 
1CREATE TABLE IF NOT EXISTS `GuildHouse` (
2 `Id` int(255) default NULL,
3 `Type` int(255) NOT NULL,
4 `NextPayment` date default NULL,
5 KEY `Id` (`Id`),
6 KEY `Type` (`Type`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8
9
10CREATE TABLE `GuildHouseType` (
11`Id` INT NOT NULL AUTO_INCREMENT ,
12`Name` VARCHAR( 255 ) NOT NULL ,
13`Tax` INT NOT NULL ,
14PRIMARY KEY ( `Id` )
15) ENGINE = InnoDB ;
16
17ALTER TABLE `GuildHouse`
18 ADD CONSTRAINT `GuildHouse_ibfk_1` FOREIGN KEY (`Type`) REFERENCES `GuildHouseType` (`Id`);
Note: See TracBrowser for help on using the repository browser.