[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 16:38:10
Message-ID: 1233333490.681419.9738.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 918739 by mstein:

fixed column definition for server, search and bug tables

 M  +7 -8      createBase.sql  
 M  +25 -14    devValues.sql  


--- branches/work/kbugbuster-isi/KBugBuster-v2/src/model/sql/createBase.sql \
#918738:918739 @@ -8,7 +8,7 @@
 );
 
 CREATE TABLE if not exists search (
-  seId INTEGER AUTOINCREMENT unique,
+  seId INTEGER PRIMARY KEY AUTOINCREMENT unique,
   seIdServer INTEGER,
   seIdBug INTEGER,
   seName VARCHAR(30),
@@ -38,12 +38,11 @@
   seUrl VARCHAR(30),
   seVersion VARCHAR(10),
   seWhiteboard VARCHAR(30), 
-  seLastupdate INTEGER,       
-  PRIMARY KEY (seId, seIdServer),                                  
+  seLastupdate INTEGER,                                    
   FOREIGN KEY (seIdServer) REFERENCES server (sId)
 );
 CREATE TABLE if not exists bug (
-  bId INTEGER AUTOINCREMENT unique,
+  bId INTEGER,
   bIdServer INTEGER,
   bAlias VARCHAR(50),
   bAssigned VARCHAR(50),
@@ -76,10 +75,10 @@
 );
 
 CREATE TABLE if not exists product (
-	pid INTEGER,
-	pidServer INTEGER,
-	plabel VARCHAR(30),
-	PRIMARY KEY (pid, pidServer)
+	id INTEGER,
+	idServer INTEGER,
+	label VARCHAR(30),
+	PRIMARY KEY (id, idServer)
 );
 CREATE TABLE if not exists component (
 	idProduct INTEGER,
--- branches/work/kbugbuster-isi/KBugBuster-v2/src/model/sql/devValues.sql \
#918738:918739 @@ -8,7 +8,7 @@
 );
 
 CREATE TABLE if not exists search (
-  seId INTEGER AUTOINCREMENT unique,
+  seId INTEGER PRIMARY KEY AUTOINCREMENT unique,
   seIdServer INTEGER,
   seIdBug INTEGER,
   seName VARCHAR(30),
@@ -38,12 +38,11 @@
   seUrl VARCHAR(30),
   seVersion VARCHAR(10),
   seWhiteboard VARCHAR(30), 
-  seLastupdate INTEGER,       
-  PRIMARY KEY (seId, seIdServer),                                  
+  seLastupdate INTEGER,                                    
   FOREIGN KEY (seIdServer) REFERENCES server (sId)
 );
 CREATE TABLE if not exists bug (
-  bId INTEGER AUTOINCREMENT unique,
+  bId INTEGER,
   bIdServer INTEGER,
   bAlias VARCHAR(50),
   bAssigned VARCHAR(50),
@@ -75,28 +74,28 @@
   FOREIGN KEY (bIdServer) REFERENCES server (sId)
 );
 CREATE TABLE if not exists product (
-	pid INTEGER,
-	pidServer INTEGER,
-	plabel VARCHAR(30),
-	PRIMARY KEY (pid, pidServer)
+	id INTEGER,
+	idServer INTEGER,
+	label VARCHAR(30),
+	PRIMARY KEY (id, idServer)
 );
 CREATE TABLE if not exists component (
 	idProduct INTEGER,
 	idServer INTEGER,
 	label VARCHAR(30),
-	PRIMARY KEY (idProduct, idServer)
+	PRIMARY KEY (idProduct, idServer, label)
 );
 CREATE TABLE if not exists version (
 	idProduct INTEGER,
 	idServer INTEGER,
 	label VARCHAR(20),
-	PRIMARY KEY(idProduct, idServer)
+	PRIMARY KEY(idProduct, idServer, label)
 );
 CREATE TABLE if not exists target (
 	idProduct INTEGER,
 	idServer INTEGER,
 	label VARCHAR(20),
-	PRIMARY KEY(idProduct, idServer)
+	PRIMARY KEY(idProduct, idServer, label)
 );
 
 CREATE TABLE if not exists status (label VARCHAR(20), idServer INTEGER,  PRIMARY KEY \
(label, idServer)); @@ -106,9 +105,6 @@
 CREATE TABLE if not exists hardware (label VARCHAR(20),idServer INTEGER,  PRIMARY \
KEY (label, idServer));  CREATE TABLE if not exists os (label VARCHAR(20), idServer \
INTEGER,  PRIMARY KEY (label, idServer));  
-
-
-
 insert into server (sId, sName, sAddress, sLogin, sPassword) 
 values (1, "KDE Server", \
'https://bugs.kde.org','julien.bringuier@gmail.com','brinbrin');  
@@ -149,9 +145,24 @@
 insert into bug (bId, bIdServer, bAssigned, bSummary, bOs,bSeverity, bPriority, \
bStatus)   values (8, 2,'assigned@gmail.com', 'Summary Bug', \
'Vista','major','P3','NEW');  
+insert into product(id, idServer, label) values(1, 1, "akonadi");
+insert into product(id, idServer, label) values(2, 1, "akregator");
+insert into product(id, idServer, label) values(3, 1, "kpresenter");
 
+insert into component(idProduct, idServer, label) values(1, 1, "general");
+insert into component(idProduct, idServer, label) values(1, 1, "akonadeur");
+insert into component(idProduct, idServer, label) values(2, 1, "generale");
+insert into component(idProduct, idServer, label) values(3, 1, "generaleuh");
 
+insert into version(idProduct, idServer, label) values(1,1,"0.0.1");
+insert into version(idProduct, idServer, label) values(2,1,"0.0.4");
+insert into version(idProduct, idServer, label) values(2,1,"0.0.5");
+insert into version(idProduct, idServer, label) values(3,1,"0.0.1");
 
+insert into target(idProduct, idServer, label) values(1,1, "RC1");
+insert into target(idProduct, idServer, label) values(2,1, "RC2");
+insert into target(idProduct, idServer, label) values(3,1, "V2.0");
+
 insert into status  values ("UNCONFIRMED",1);
 insert into status  values ("NEW",1);
 insert into status  values ("ASSIGNED",1);


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