Add query to populate file_progress table
diff --git a/babel-setup.sql b/babel-setup.sql
index b01d0f4..3f52504 100644
--- a/babel-setup.sql
+++ b/babel-setup.sql
@@ -373,3 +373,16 @@
insert into map_files values ("eclipse", "3.4", "ui.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/ui.map?view=co", 1);
insert into map_files values ("eclipse", "3.4", "update.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/update.map?view=co", 1);
insert into map_files values ("eclipse", "3.4", "userassist.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/userassist.map?view=co", 1);
+
+/* populate file_progress table */
+truncate table file_progress;
+INSERT INTO file_progress
+select f.file_id, l.language_id, IF(COUNT(s.string_id) > 0, COUNT(t.string_id)/COUNT(s.string_id)*100,0) AS translate_percent
+FROM files AS f
+ INNER JOIN languages as l ON l.is_active = 1
+ LEFT JOIN strings as s ON s.file_id = f.file_id
+ LEFT JOIN translations AS t ON (s.string_id = t.string_id
+ AND t.language_id = l.language_id AND t.is_active = 1)
+WHERE f.is_active = 1
+GROUP BY f.file_id, l.language_id;
+DELETE FROM file_progress WHERE pct_completed = 0;
\ No newline at end of file