YbpZB2Ry

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));
5ALTER TABLE Combinations ADD CONSTRAINT FKCombinatio976616 FOREIGN KEY (enchant_name) REFERENCES Enchants (name);
6ALTER TABLE Combinations ADD CONSTRAINT FKCombinatio499486 FOREIGN KEY (item_name) REFERENCES Items (name);
7
8-- DROP:
9ALTER TABLE Combinations DROP CONSTRAINT FKCombinatio976616;
10ALTER TABLE Combinations DROP CONSTRAINT FKCombinatio499486;
11DROP TABLE IF EXISTS Items CASCADE;
12DROP TABLE IF EXISTS Combinations CASCADE;
13DROP TABLE IF EXISTS Enchants CASCADE;