20 lines
451 B
SQL
20 lines
451 B
SQL
CREATE TABLE words (
|
|
word text not null,
|
|
is_new boolean not null,
|
|
rank integer not null,
|
|
primary key (word)
|
|
);
|
|
|
|
CREATE TABLE combos (
|
|
x text not null,
|
|
y text not null,
|
|
z text not null,
|
|
primary key (x, y),
|
|
foreign key (x) references words(word),
|
|
foreign key (y) references words(word),
|
|
foreign key (z) references words(word)
|
|
);
|
|
|
|
insert into words (word, rank, is_new)
|
|
values ('Earth', 1, 0), ('Wind', 1, 0), ('Fire', 1, 0), ('Water', 1, 0);
|