M2Dy5Prm

1-- CREATE:
2CREATE TABLE Items (name varchar(30) NOT NULL, PRIMARY KEY(name));
3CREATE TABLE Combinations (item_name varchar(30) NOT NULL,enchant_name varchar(30) NOT NULL, rating int4 NOT NULL,PRIMARY KEY (item_name, enchant_name));
4CREATE TABLE Enchants (name varchar(30) NOT NULL, max_level int4 NOT NULL, multiplier int4 NOT NULL, PRIMARY KEY (name));
5CREATE TABLE Conflicts (enchant_name varchar(30) NOT NULL, conflict_group int4 NOT NULL, PRIMARY KEY (enchant_name, conflict_group));
6ALTER TABLE Conflicts ADD CONSTRAINT FKConflicts829385 FOREIGN KEY (enchant_name) REFERENCES Enchants (name);
7ALTER TABLE Combinations ADD CONSTRAINT FKCombinatio976616 FOREIGN KEY (enchant_name) REFERENCES Enchants (name);
8ALTER TABLE Combinations ADD CONSTRAINT FKCombinatio499486 FOREIGN KEY (item_name) REFERENCES Items (name);
9
10-- DROP:
11ALTER TABLE Combinations DROP CONSTRAINT FKCombinatio976616;
12ALTER TABLE Combinations DROP CONSTRAINT FKCombinatio499486;
13ALTER TABLE Conflicts DROP CONSTRAINT FKConflicts829385;
14DROP TABLE IF EXISTS Items CASCADE;
15DROP TABLE IF EXISTS Combinations CASCADE;
16DROP TABLE IF EXISTS Enchants CASCADE;
17DROP TABLE IF EXISTS Conflicts CASCADE;