|
1 Description: Upstream changes introduced in version 2011072500-8 |
|
2 This patch has been created by dpkg-source during the package build. |
|
3 Here's the last changelog entry, hopefully it gives details on why |
|
4 those changes were made: |
|
5 . |
|
6 littlebird (2011072500-8) stable; urgency=low |
|
7 . |
|
8 * fixed db installation script |
|
9 . |
|
10 The person named in the Author field signed this changelog entry. |
|
11 Author: Heiko Schlittermann <hs@schlittermann.de> |
|
12 |
|
13 --- |
|
14 The information above should follow the Patch Tagging Guidelines, please |
|
15 checkout http://dep.debian.net/deps/dep3/ to learn about the format. Here |
|
16 are templates for supplementary fields that you might want to add: |
|
17 |
|
18 Origin: <vendor|upstream|other>, <url of original patch> |
|
19 Bug: <url in upstream bugtracker> |
|
20 Bug-Debian: http://bugs.debian.org/<bugnumber> |
|
21 Bug-Ubuntu: https://launchpad.net/bugs/<bugnumber> |
|
22 Forwarded: <no|not-needed|url proving that it has been forwarded> |
|
23 Reviewed-By: <name and email of someone who approved the patch> |
|
24 Last-Update: <YYYY-MM-DD> |
|
25 |
|
26 --- littlebird-2011072500.orig/LittleBird/encoded/LittleBird-Test/Database/install_test_iteration_2011-06.sh |
|
27 +++ littlebird-2011072500/LittleBird/encoded/LittleBird-Test/Database/install_test_iteration_2011-06.sh |
|
28 @@ -1,66 +1,90 @@ |
|
29 #!/bin/bash |
|
30 +# leichte Anpassungen durch hs@schlittermann.de |
|
31 +# Aufruf wie immer, dann werden die bisherigen Angaben *root* und das bisherige |
|
32 +# Passwort verwendet. Oder |
|
33 +# install_test_iteration_2011-06.sh DB_HOST DB_NAME DB_ADMIN DB_ADMINPASS DB_USER DB_USERPASS |
|
34 + |
|
35 +# ACHTUNG: DIE DATENBANK WIRD KOMPLETT GEERDET! |
|
36 |
|
37 #DB Update Dev - Test, |
|
38 #Iteration Mai, Juni |
|
39 |
|
40 #Test Stand vor der Iteration |
|
41 +DB_HOST=${1-localhost}; shift |
|
42 +DB_NAME=${1-trustcenter_history_test}; shift |
|
43 + |
|
44 +DB_ADMIN=${1-root}; shift |
|
45 +DB_ADMINPASS=${1-Pa55w0rd}; shift |
|
46 |
|
47 +DB_USER=${1-$DB_ADMIN}; shift |
|
48 +DB_USERPASS=${1-$DB_ADMINPASS}; shift |
|
49 |
|
50 -mysql -u root -pPa55w0rd --default-character-set=utf8 < install_dev_tc_2011-04-30_023.sql |
|
51 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_install_dev_tc_2011-04-30_023.sql |
|
52 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_002_install_dev_tc_2011-04-30_023.sql |
|
53 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_003_install_dev_tc_2011-04-30_023.sql |
|
54 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_004_install_dev_tc_2011-04-30_023.sql |
|
55 - |
|
56 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_024.sql |
|
57 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_025.sql |
|
58 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_026.sql |
|
59 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_027.sql |
|
60 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_028.sql |
|
61 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_029.sql |
|
62 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_030.sql |
|
63 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_031.sql |
|
64 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_032.sql |
|
65 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_033.sql |
|
66 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_034.sql |
|
67 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_035.sql |
|
68 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_036.sql |
|
69 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_037.sql |
|
70 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-04-30_038.sql |
|
71 +#echo "$DB_ADMIN $DB_ADMINPASS $DB_NAME" |
|
72 +#echo "$DB_USER $DB_USERPASS $DB_NAME" |
|
73 + |
|
74 +fix_db_name() { sed "s/trustcenter_history_test/$DB_NAME/g"; } |
|
75 +mysql() { fix_db_name | command mysql "$@" -h"$DB_HOST" -D"$DB_NAME" --default-character-set=utf8; } |
|
76 +mysql_as_admin() { echo "as admin: $1"; <"$1" mysql -u "$DB_ADMIN" -p"$DB_ADMINPASS"; } |
|
77 +mysql_as_user() { echo "as user: $1"; <"$1" mysql -u "$DB_USER" -p"$DB_USERPASS"; } |
|
78 + |
|
79 +mysql_as_admin install_dev_tc_2011-04-30_023.sql |
|
80 +mysql_as_admin update_install_dev_tc_2011-04-30_023.sql |
|
81 + |
|
82 + |
|
83 +mysql_as_user update_002_install_dev_tc_2011-04-30_023.sql |
|
84 +mysql_as_user update_003_install_dev_tc_2011-04-30_023.sql |
|
85 +mysql_as_user update_004_install_dev_tc_2011-04-30_023.sql |
|
86 +mysql_as_user update_trustcenter_history_2011-04-30_024.sql |
|
87 + |
|
88 +mysql_as_admin update_trustcenter_history_2011-04-30_025.sql |
|
89 +mysql_as_admin update_trustcenter_history_2011-04-30_026.sql |
|
90 + |
|
91 +mysql_as_user update_trustcenter_history_2011-04-30_027.sql |
|
92 +mysql_as_admin update_trustcenter_history_2011-04-30_028.sql |
|
93 +mysql_as_user update_trustcenter_history_2011-04-30_029.sql |
|
94 +mysql_as_user update_trustcenter_history_2011-04-30_030.sql |
|
95 +mysql_as_user update_trustcenter_history_2011-04-30_031.sql |
|
96 +mysql_as_admin update_trustcenter_history_2011-04-30_032.sql |
|
97 +mysql_as_admin update_trustcenter_history_2011-04-30_033.sql |
|
98 +mysql_as_admin update_trustcenter_history_2011-04-30_034.sql |
|
99 +mysql_as_user update_trustcenter_history_2011-04-30_035.sql |
|
100 +mysql_as_admin update_trustcenter_history_2011-04-30_036.sql |
|
101 +mysql_as_user update_trustcenter_history_2011-04-30_037.sql |
|
102 +mysql_as_user update_trustcenter_history_2011-04-30_038.sql |
|
103 |
|
104 #Todo update - 06-2011 |
|
105 |
|
106 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-06-30_001.sql |
|
107 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-06-30_002.sql |
|
108 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < update_trustcenter_history_2011-06-30_003.sql |
|
109 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_1112.sql |
|
110 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_1152.sql |
|
111 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_1116.sql |
|
112 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_1163.sql |
|
113 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-07-31_652.sql |
|
114 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_1144.sql |
|
115 +mysql_as_admin update_trustcenter_history_2011-06-30_001.sql |
|
116 +mysql_as_user update_trustcenter_history_2011-06-30_002.sql |
|
117 +mysql_as_user update_trustcenter_history_2011-06-30_003.sql |
|
118 +mysql_as_user 2011-06-30_1112.sql |
|
119 +mysql_as_user 2011-06-30_1152.sql |
|
120 +mysql_as_user 2011-06-30_1116.sql |
|
121 +mysql_as_admin 2011-06-30_1163.sql |
|
122 +mysql_as_user 2011-07-31_652.sql |
|
123 +mysql_as_user 2011-06-30_1144.sql |
|
124 |
|
125 #cryptKey + editorID set |
|
126 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_627.sql |
|
127 +mysql_as_admin 2011-06-30_627.sql |
|
128 |
|
129 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_910_909.sql |
|
130 +mysql_as_admin 2011-06-30_910_909.sql |
|
131 |
|
132 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_document_premerge.sql |
|
133 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_task1157_betreuungsvertrag_V2.sql |
|
134 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_task1155_betreuungsvertragTP_V2.sql |
|
135 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_task1101_einzugsermaechtigung_V2.sql |
|
136 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_task1125_betreuungsgebuehr_V2.sql |
|
137 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_task1098_aerztlicheVollmacht_V2.sql |
|
138 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_task1100_abholberechtigung_V2.sql |
|
139 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_acl_calc.sql |
|
140 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_1168.sql |
|
141 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_1186.sql |
|
142 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_task1208_textbausteine_sortierbar.sql |
|
143 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_task1223_rechtliches_sonstiges.sql |
|
144 +mysql_as_user 2011-06-30_document_premerge.sql |
|
145 +mysql_as_user 2011-06-30_task1157_betreuungsvertrag_V2.sql |
|
146 +mysql_as_user 2011-06-30_task1155_betreuungsvertragTP_V2.sql |
|
147 +mysql_as_user 2011-06-30_task1101_einzugsermaechtigung_V2.sql |
|
148 +mysql_as_user 2011-06-30_task1125_betreuungsgebuehr_V2.sql |
|
149 +mysql_as_user 2011-06-30_task1098_aerztlicheVollmacht_V2.sql |
|
150 +mysql_as_user 2011-06-30_task1100_abholberechtigung_V2.sql |
|
151 +mysql_as_user 2011-06-30_acl_calc.sql |
|
152 +mysql_as_admin 2011-06-30_1168.sql |
|
153 +mysql_as_admin 2011-06-30_1186.sql |
|
154 +mysql_as_user 2011-06-30_task1208_textbausteine_sortierbar.sql |
|
155 +mysql_as_user 2011-06-30_task1223_rechtliches_sonstiges.sql |
|
156 |
|
157 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_1182.sql |
|
158 +mysql_as_user 2011-06-30_1182.sql |
|
159 |
|
160 #cryptKey + editorID set |
|
161 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_update_heidenau_fees.sql |
|
162 +mysql_as_user 2011-06-30_update_heidenau_fees.sql |
|
163 |
|
164 -mysql -u root -pPa55w0rd -Dtrustcenter_history_test --default-character-set=utf8 < 2011-06-30_allg_db_update.sql |
|
165 +mysql_as_admin 2011-06-30_allg_db_update.sql |