From a0c29dc24500059c580f6ec2647e8a2d2385ea77 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 13 Feb 2005 18:11:49 +0000 Subject: [PATCH] Add UNIQUE to the trivial tables. --- sql/ccbs.sql | 20 +++++++++++++++----- 1 file changed, 15 insertions(+), 5 deletions(-) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index e4a129f..0bbc009 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -2,12 +2,16 @@ 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 ( @@ -24,7 +28,9 @@ CREATE TABLE songs ( CREATE TABLE scoringsystems ( scoringsystem SERIAL PRIMARY KEY, - name VARCHAR NOT NULL + name VARCHAR NOT NULL, + + UNIQUE ( name ) ); CREATE TABLE songratings ( @@ -38,12 +44,16 @@ 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 ( -- 2.39.2