From: Roland Mas <lolando@debian.org>
Date: Thu, 17 Nov 2011 19:54:21 +0000 (+0000)
Subject: More convergence SQL
X-Git-Tag: v5_2_rc1~433
X-Git-Url: https://scm.fusionforge.org/anonscm/gitweb?p=fusionforge%2Ffusionforge.git;a=commitdiff_plain;h=0aaf95bf043254559b46fd5f57eb0bafd8ca5273;hp=2ce54b139a7e55f5266432380600db4b36e27a93

More convergence SQL
---

diff --git a/src/db/20111017-schema-convergence-src-1.sql b/src/db/20111017-schema-convergence-src-1.sql
index 7fe28625ec..96e69e75a8 100644
--- a/src/db/20111017-schema-convergence-src-1.sql
+++ b/src/db/20111017-schema-convergence-src-1.sql
@@ -56,3 +56,28 @@ ALTER SEQUENCE group_cvs_history_pk_seq MAXVALUE 2147483647;
 ALTER SEQUENCE supported_languages_pk_seq MAXVALUE 2147483647;
 
 ALTER TABLE project_category ALTER COLUMN category_id SET DEFAULT nextval('project_categor_category_id_seq'::regclass);
+
+CREATE VIEW mta_users AS SELECT users.user_name AS login, users.email FROM users WHERE (users.status = 'A'::bpchar);
+CREATE OR REPLACE VIEW nss_shadow AS SELECT users.user_name AS login, users.unix_pw AS passwd, 'n'::character(1) AS expired, 'n'::character(1) AS pwchange FROM users WHERE (users.unix_status = 'A'::bpchar);
+
+INSERT INTO "project_status" (status_id, status_name) VALUES ('3', 'Deleted');
+INSERT INTO "supported_languages" (language_id, name, filename, classname, language_code) VALUES ('13', 'Esperanto', 'Esperanto.class', 'Esperanto', 'eo ');
+INSERT INTO "supported_languages" (language_id, name, filename, classname, language_code) VALUES ('15', 'Polish', 'Polish.class', 'Polish', 'pl ');
+INSERT INTO "supported_languages" (language_id, name, filename, classname, language_code) VALUES ('18', 'Portuguese', 'Portuguese.class', 'Portuguese', 'pt ');
+INSERT INTO "supported_languages" (language_id, name, filename, classname, language_code) VALUES ('19', 'Greek', 'Greek.class', 'Greek', 'el ');
+INSERT INTO "supported_languages" (language_id, name, filename, classname, language_code) VALUES ('21', 'Indonesian', 'Indonesian.class', 'Indonesian', 'id ');
+INSERT INTO "supported_languages" (language_id, name, filename, classname, language_code) VALUES ('25', 'Latin', 'Latin.class', 'Latin', 'la ');
+INSERT INTO "supported_languages" (language_id, name, filename, classname, language_code) VALUES ('3', 'Hebrew', 'Hebrew.class', 'Hebrew', 'iw ');
+INSERT INTO "supported_languages" (language_id, name, filename, classname, language_code) VALUES ('9', 'Norwegian', 'Norwegian.class', 'Norwegian', 'no ');
+
+INSERT INTO "artifact_status" (id, status_name) VALUES ('3', 'Deleted');
+
+INSERT INTO "people_skill" (skill_id, name) VALUES ('1', 'Ada');
+INSERT INTO "people_skill" (skill_id, name) VALUES ('2', 'C');
+INSERT INTO "people_skill" (skill_id, name) VALUES ('3', 'C++');
+INSERT INTO "people_skill" (skill_id, name) VALUES ('4', 'HTML');
+INSERT INTO "people_skill" (skill_id, name) VALUES ('5', 'LISP');
+INSERT INTO "people_skill" (skill_id, name) VALUES ('6', 'Perl');
+INSERT INTO "people_skill" (skill_id, name) VALUES ('7', 'PHP');
+INSERT INTO "people_skill" (skill_id, name) VALUES ('8', 'Python');
+INSERT INTO "people_skill" (skill_id, name) VALUES ('9', 'SQL');