[babel-dev] Missing data in babel-setup.sql

[Sean Flanigan <sflaniga@xxxxxxxxxx>]

Hi,

I've been trying to set up a local Babel server for testing, and so that 
I can grab the English strings for all projects using the maps processor.

Along the way, I found that I had to add some data to babel-setup.sql to 
make some foreign key constraints happy.  Patch attached.  I basically 
guessed which projects and versions should be marked as active, so you 
might want to check them!

I'm more of a Java developer than a Linux developer, so I had to dig 
around a bit to find Apache's config file, and to know which yum 
packages I needed to run php+apache+mysql.  I've added a few lines with 
this information to 
http://wiki.eclipse.org/Babel_/_Server_Tool_Development_Process in case 
it helps.  It's a little Fedora-specific, but it can't hurt.

Regards,

--
Sean

Index: babel-setup.sql
===================================================================
RCS file: /cvsroot/technology/org.eclipse.babel/server/babel-setup.sql,v
retrieving revision 1.30
diff -u -r1.30 babel-setup.sql
--- babel-setup.sql	11 Jun 2008 19:36:02 -0000	1.30
+++ babel-setup.sql	3 Jul 2008 05:52:54 -0000
@@ -376,6 +376,18 @@
 insert into profiles set login_name = "test", cryptpassword = "", realname = "tester", disabledtext = false, mybugslink = 1, extern_id = 1, disable_mail = false;
 insert into users set userid = 1, username = "babel@xxxxxxxxxxx",first_name="babel",last_name="fish",email="babel@xxxxxxxxxxx",primary_language_id = "",password_hash = "HSD9a.ShTTdvo", is_committer = true;
 insert into projects set project_id = 'eclipse', is_active = 1 ;
+insert into projects set project_id = 'europa', is_active = 1 ;
+insert into projects set project_id = 'birt', is_active = 1 ;
+insert into projects set project_id = 'modeling.emf', is_active = 1 ;
+insert into projects set project_id = 'modeling.emft', is_active = 1 ;
+insert into projects set project_id = 'modeling.gmf', is_active = 1 ;
+insert into projects set project_id = 'modeling.mdt', is_active = 1 ;
+insert into projects set project_id = 'stp', is_active = 1 ;
+insert into projects set project_id = 'tools.cdt', is_active = 1 ;
+insert into projects set project_id = 'tools.gef', is_active = 1 ;
+insert into projects set project_id = 'tools.pdt', is_active = 1 ;
+insert into projects set project_id = 'webtools', is_active = 1 ;
+
 INSERT INTO `languages` VALUES (1,'en',NULL,'English',1),
 (2,'fr',NULL,'French',1),
 (3,'ja',NULL,'Japanese',1),
@@ -407,6 +419,18 @@
 insert into languages set iso_code = 'es_CA', name = "Spanish-Catalonian";
 insert into project_versions set project_id = "eclipse", version = "3.4", is_active = 1;
 
+insert into project_versions set project_id = "eclipse", version = "3.3.1", is_active = 0;
+insert into project_versions set project_id = "stp", version = "0.8", is_active = 0;
+insert into project_versions set project_id = "birt", version = "2.3.0", is_active = 1;
+insert into project_versions set project_id = "modeling.emf", version = "2.4.0", is_active = 1;
+insert into project_versions set project_id = "modeling.emft", version = "0.8", is_active = 1;
+insert into project_versions set project_id = "modeling.gmf", version = "2.1", is_active = 1;
+insert into project_versions set project_id = "modeling.mdt", version = "2.4.0", is_active = 1;
+insert into project_versions set project_id = "stp", version = "1.0", is_active = 1;
+insert into project_versions set project_id = "tools.cdt", version = "5.0", is_active = 1;
+insert into project_versions set project_id = "tools.gef", version = "3.4", is_active = 1;
+insert into project_versions set project_id = "tools.pdt", version = "1.5.1", is_active = 1;
+insert into project_versions set project_id = "webtools", version = "3.0", is_active = 1;
 
 /* MAP INPUTS */
 insert into map_files values ("eclipse", "3.4", "ant.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/ant.map?view=co";, 1);