[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    branches/work/kbugbuster-isi/KBugBuster-v2/src/model/sql
From:       Manuarii Stein <manuarii.stein () gmail ! com>
Date:       2009-01-30 15:40:24
Message-ID: 1233330024.283860.7482.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 918721 by mstein:

Added tables in the database (product, component, version, target) used for the \
advanced search interface.

 M  +25 -0     createBase.sql  
 M  +24 -0     devValues.sql  


--- branches/work/kbugbuster-isi/KBugBuster-v2/src/model/sql/createBase.sql \
#918720:918721 @@ -75,6 +75,31 @@
   FOREIGN KEY (bIdServer) REFERENCES server (sId)
 );
 
+CREATE TABLE if not exists product (
+	pid INTEGER,
+	pidServer INTEGER,
+	plabel VARCHAR(30),
+	PRIMARY KEY (pid, pidServer)
+);
+CREATE TABLE if not exists component (
+	idProduct INTEGER,
+	idServer INTEGER,
+	label VARCHAR(30),
+	PRIMARY KEY (idProduct, idServer)
+);
+CREATE TABLE if not exists version (
+	idProduct INTEGER,
+	idServer INTEGER,
+	label VARCHAR(20),
+	PRIMARY KEY(idProduct, idServer)
+);
+CREATE TABLE if not exists target (
+	idProduct INTEGER,
+	idServer INTEGER,
+	label VARCHAR(20),
+	PRIMARY KEY(idProduct, idServer)
+);
+
 CREATE TABLE if not exists status (label VARCHAR(20), idServer INTEGER,  PRIMARY KEY \
(label, idServer));  CREATE TABLE if not exists resolution (label VARCHAR(20), \
idServer INTEGER,  PRIMARY KEY (label, idServer));  CREATE TABLE if not exists \
                severity (label VARCHAR(20), idServer INTEGER,  PRIMARY KEY (label, \
                idServer));
--- branches/work/kbugbuster-isi/KBugBuster-v2/src/model/sql/devValues.sql \
#918720:918721 @@ -74,6 +74,30 @@
   PRIMARY KEY (bId, bIdServer),
   FOREIGN KEY (bIdServer) REFERENCES server (sId)
 );
+CREATE TABLE if not exists product (
+	pid INTEGER,
+	pidServer INTEGER,
+	plabel VARCHAR(30),
+	PRIMARY KEY (pid, pidServer)
+);
+CREATE TABLE if not exists component (
+	idProduct INTEGER,
+	idServer INTEGER,
+	label VARCHAR(30),
+	PRIMARY KEY (idProduct, idServer)
+);
+CREATE TABLE if not exists version (
+	idProduct INTEGER,
+	idServer INTEGER,
+	label VARCHAR(20),
+	PRIMARY KEY(idProduct, idServer)
+);
+CREATE TABLE if not exists target (
+	idProduct INTEGER,
+	idServer INTEGER,
+	label VARCHAR(20),
+	PRIMARY KEY(idProduct, idServer)
+);
 
 CREATE TABLE if not exists status (label VARCHAR(20), idServer INTEGER,  PRIMARY KEY \
(label, idServer));  CREATE TABLE if not exists resolution (label VARCHAR(20), \
idServer INTEGER,  PRIMARY KEY (label, idServer));


[prev in list] [next in list] [prev in thread] [next in thread]