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

[cbayle]

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

Modified Files:
        20040722.sql 
Log Message:
Try to reattribute old licences


Index: 20040722.sql
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20040722.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 20040722.sql        22 Jul 2004 20:06:21 -0000      1.1
+++ 20040722.sql        22 Jul 2004 20:54:21 -0000      1.2
@@ -6,37 +6,92 @@
 SELECT setval('licenses_license_id_seq',100);
 INSERT INTO licenses (license_id,license_name) VALUES (100,'None');
 
+-- 101 gpl 
 INSERT INTO licenses (license_name) VALUES ('GNU General Public License 
(GPL)');
+-- 102 lgpl
 INSERT INTO licenses (license_name) VALUES ('GNU Library Public License 
(LGPL)');
+-- 103 bsd
 INSERT INTO licenses (license_name) VALUES ('BSD License');
+-- 104 mit
 INSERT INTO licenses (license_name) VALUES ('MIT License');
+-- 105 artistic
 INSERT INTO licenses (license_name) VALUES ('Artistic License');
+-- 106 mpl
 INSERT INTO licenses (license_name) VALUES ('Mozilla Public License 1.0 
(MPL)');
+-- 107 qpl
 INSERT INTO licenses (license_name) VALUES ('Qt Public License (QPL)');
+-- 108 ibm
 INSERT INTO licenses (license_name) VALUES ('IBM Public License');
+-- 109 cvw
 INSERT INTO licenses (license_name) VALUES ('MITRE Collaborative Virtual 
Workspace License (CVW License)');
+-- 110 rscpl
 INSERT INTO licenses (license_name) VALUES ('Ricoh Source Code Public 
License');
+-- 111 python
 INSERT INTO licenses (license_name) VALUES ('Python License');
+-- 112 zlib
 INSERT INTO licenses (license_name) VALUES ('zlib/libpng License');
+-- 113 apache
 INSERT INTO licenses (license_name) VALUES ('Apache Software License');
+-- 114 vovida
 INSERT INTO licenses (license_name) VALUES ('Vovida Software License 1.0');
+-- 115 sissl
 INSERT INTO licenses (license_name) VALUES ('Sun Internet Standards Source 
License (SISSL)');
+-- 116 iosl
 INSERT INTO licenses (license_name) VALUES ('Intel Open Source License');
+-- 117 mpl11
 INSERT INTO licenses (license_name) VALUES ('Mozilla Public License 1.1 (MPL 
1.1)');
+-- 118 jabber
 INSERT INTO licenses (license_name) VALUES ('Jabber Open Source License');
+-- 119 nokia
 INSERT INTO licenses (license_name) VALUES ('Nokia Open Source License');
+-- 120 sleepycat
 INSERT INTO licenses (license_name) VALUES ('Sleepycat License');
+-- 121 nethack
 INSERT INTO licenses (license_name) VALUES ('Nethack General Public License');
+-- 122 ibmcpl
 INSERT INTO licenses (license_name) VALUES ('IBM Common Public License');
+-- 123 apsl
 INSERT INTO licenses (license_name) VALUES ('Apple Public Source License');
+-- 124 public
 INSERT INTO licenses (license_name) VALUES ('Public Domain');
+-- 125 website
 INSERT INTO licenses (license_name) VALUES ('Website Only');
+-- 126 other
 INSERT INTO licenses (license_name) VALUES ('Other/Proprietary License');
 
 ALTER TABLE groups RENAME COLUMN license TO license_dead;
 ALTER TABLE groups ADD COLUMN license INT;
 ALTER TABLE groups ALTER COLUMN license SET DEFAULT 100;
+
 UPDATE groups SET license=100;
+UPDATE groups SET license=101 where license_dead='gpl';
+UPDATE groups SET license=102 where license_dead='lgpl';
+UPDATE groups SET license=103 where license_dead='bsd';
+UPDATE groups SET license=104 where license_dead='mit';
+UPDATE groups SET license=105 where license_dead='artistic';
+UPDATE groups SET license=106 where license_dead='mpl';
+UPDATE groups SET license=107 where license_dead='qpl';
+UPDATE groups SET license=108 where license_dead='ibm';
+UPDATE groups SET license=109 where license_dead='cvw';
+UPDATE groups SET license=110 where license_dead='rscpl';
+UPDATE groups SET license=111 where license_dead='python';
+UPDATE groups SET license=112 where license_dead='zlib';
+UPDATE groups SET license=113 where license_dead='apache';
+UPDATE groups SET license=114 where license_dead='vovida';
+UPDATE groups SET license=115 where license_dead='sissl';
+UPDATE groups SET license=116 where license_dead='iosl';
+UPDATE groups SET license=117 where license_dead='mpl11';
+UPDATE groups SET license=118 where license_dead='jabber';
+UPDATE groups SET license=119 where license_dead='nokia';
+UPDATE groups SET license=120 where license_dead='sleepycat';
+UPDATE groups SET license=121 where license_dead='nethack';
+UPDATE groups SET license=122 where license_dead='ibmcpl';
+UPDATE groups SET license=123 where license_dead='apsl';
+UPDATE groups SET license=124 where license_dead='public';
+UPDATE groups SET license=125 where license_dead='website';
+UPDATE groups SET license=126 where license_dead='other';
+
+
 ALTER TABLE groups ADD CONSTRAINT groups_license
         FOREIGN KEY (license) REFERENCES licenses(license_id) MATCH FULL;
         ALTER TABLE groups DROP COLUMN license_dead;