CREATE TABLE machines (
machine SERIAL PRIMARY KEY,
- name VARCHAR NOT NULL
+ name VARCHAR NOT NULL,
+
+ UNIQUE ( name )
);
CREATE TABLE countries (
country SERIAL PRIMARY KEY,
- name VARCHAR NOT NULL
+ name VARCHAR NOT NULL,
+
+ UNIQUE ( name )
);
CREATE TABLE songs (
CREATE TABLE scoringsystems (
scoringsystem SERIAL PRIMARY KEY,
- name VARCHAR NOT NULL
+ name VARCHAR NOT NULL,
+
+ UNIQUE ( name )
);
CREATE TABLE songratings (
CREATE TABLE players (
player SERIAL PRIMARY KEY,
- nick VARCHAR NOT NULL
+ nick VARCHAR NOT NULL,
+
+ UNIQUE ( nick )
);
CREATE TABLE seasons (
season SERIAL PRIMARY KEY,
- name VARCHAR NOT NULL
+ name VARCHAR NOT NULL,
+
+ UNIQUE ( season )
);
CREATE TABLE tournaments (