From 59334ecde5ad866ad8937f002f1faee48c1906d6 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 22 Apr 1999 04:02:06 +0000
Subject: id fields get unique names

---
 schema.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 64c12cd..5fc2635 100644
--- a/schema.sql
+++ b/schema.sql
@@ -15,7 +15,7 @@ CREATE TABLE PERSONS_SETS (
 );
 
 CREATE TABLE SETS (
-  ID INT AUTO_INCREMENT PRIMARY KEY,
+  SET_ID INT AUTO_INCREMENT PRIMARY KEY,
   SETSTART DATETIME NOT NULL,
   DURATION INT,
   FILENAME VARCHAR(80),
@@ -30,7 +30,7 @@ CREATE TABLE SETS (
 );
 
 CREATE TABLE SHOWS (
-  ID INT AUTO_INCREMENT PRIMARY KEY,
+  SHOW_ID INT AUTO_INCREMENT PRIMARY KEY,
   PERSON_ID INT,
   SHOWSTART DATETIME NOT NULL,
   DURATION INT,
@@ -40,7 +40,7 @@ CREATE TABLE SHOWS (
 );
 
 CREATE TABLE STUDIOS (
-  ID INT AUTO_INCREMENT PRIMARY KEY,
+  STUDIO_ID INT AUTO_INCREMENT PRIMARY KEY,
   NAME VARCHAR(80),
   ISLIVE CHAR(1)
 );
-- 
cgit v1.2.1

