1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
|
DROP TABLE IF EXISTS `dandd`.`tblotherpossessions`;
CREATE TABLE `dandd`.`tblotherpossessions` (
`idOtherPossession` int(11) NOT NULL auto_increment,
`UniqueItem` bit(1) default NULL,
`Name` varchar(20) default NULL,
`Weight` int(11) default NULL,
PRIMARY KEY (`idOtherPossession`),
UNIQUE KEY `XPKtblOtherPossessions` (`idOtherPossession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `dandd`.`tblbonuses`;
CREATE TABLE `dandd`.`tblbonuses` (
`idBonus` int(11) NOT NULL auto_increment,
`BonusScore` int(11) default NULL,
`onWhat` char(20) default NULL,
PRIMARY KEY (`idBonus`),
UNIQUE KEY `XPKtblBonuses` (`idBonus`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `dandd`.`tblpossessionsbonuses`;
CREATE TABLE `dandd`.`tblpossessionsbonuses` (
`idfiBonus` int(11) NOT NULL default '0',
`idfiOtherPossession` int(11) NOT NULL default '0',
PRIMARY KEY (`idfiBonus`,`idfiOtherPossession`),
UNIQUE KEY `XPKtblPossessionsBonuses` (`idfiBonus`,`idfiOtherPossession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `dandd`.`tblprerequisitesotherpossessionsbonuses`;
CREATE TABLE `dandd`.`tblprerequisitesotherpossessionsbonuses` (
`idfiPrerequisite` int(11) NOT NULL default '0',
`idfiBonus` int(11) NOT NULL default '0',
`idOtherPossession` int(11) NOT NULL default '0',
PRIMARY KEY (`idfiPrerequisite`,`idfiBonus`,`idOtherPossession`),
UNIQUE KEY `XPKtblPrerequisitesOtherPossessionsBonuses` (`idfiPrerequisite`,`idfiBonus`,`idOtherPossession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|