[Gforge-commits] gforge/db 20041014.sql,1.1,1.2

[cbayle]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/tmp/cvs-serv13149

Modified Files:
        20041014.sql 
Log Message:
Don't insert if the theme already exists


Index: 20041014.sql
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20041014.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 20041014.sql        14 Oct 2004 14:47:19 -0000      1.1
+++ 20041014.sql        25 Oct 2004 14:34:33 -0000      1.2
@@ -1,2 +1,4 @@
-insert into themes (dirname,fullname,enabled) 
-       values ('ultralite','Ultra-Lite Text-only Theme',true);
+-- Insert ultralite, only if it doesn't already exists
+INSERT INTO themes (dirname,fullname,enabled) (SELECT 'ultralite','Ultra-Lite 
Text-only Theme',true WHERE (SELECT COUNT(*) FROM themes WHERE dirname 
='ultralite' ) = 0) ;     
+UPDATE themes SET fullname = 'Ultra-Lite Text-only Theme' where dirname = 
'ultralite';
+