| commit | author | age | ||
| 13151e | 1 | -- |
| PH | 2 | -- Table: basepacket |
| 3 | -- | |
| f572d9 | 4 | INSERT INTO basepacket (basepacket_code, description, sorting, valid, article_number) |
| PH | 5 | VALUES ('DW/B', 'Dynamic-Web/Base', 200, true, 100); |
| 6 | INSERT INTO basepacket (basepacket_code, description, sorting, valid, article_number) | |
| 7 | VALUES ('SW/B', 'Static-Web/Base', 300, true, 200); | |
| 8 | INSERT INTO basepacket (basepacket_code, description, sorting, valid, article_number) | |
| 9 | VALUES ('WEB', 'Web/Base', 100, true, 300); | |
| 13151e | 10 | |
| PH | 11 | -- |
| 12 | -- Table: basecomponent | |
| 13 | -- | |
| 14 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) | |
| 15 | VALUES ('TRAFFIC', 'Monatliches Datenvolumen in GB', 100, true); | |
| 16 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) | |
| 17 | VALUES ('QUOTA', 'Festplattenspeicherplatz in MB', 200, true); | |
| 18 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) | |
| f572d9 | 19 | VALUES ('DAEMON', 'Nutzung eines eigenen Servers/Daemons', 300, true); |
| 13151e | 20 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) |
| f572d9 | 21 | VALUES ('MIRROR', 'Echtzeitspiegelung der Daten', 400, true); |
| 13151e | 22 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) |
| f572d9 | 23 | VALUES ('BACKUP', 'Nächtliches Backup', 500, true); |
| 13151e | 24 | |
| PH | 25 | -- |
| 26 | -- Table: component | |
| 27 | -- | |
| f572d9 | 28 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) |
| PH | 29 | SELECT basepacket_id, basecomponent_id, 128, 40960, 128, 128, 128, false, 101 FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='QUOTA'; |
| 30 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 31 | SELECT basepacket_id, basecomponent_id, 512, 40960, 512, 512, 512, false, 201 FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='QUOTA'; | |
| 32 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 33 | SELECT basepacket_id, basecomponent_id, 512, 40960, 512, 512, 0, false, 301 FROM basepacket, basecomponent WHERE basepacket_code='WEB' AND basecomponent_code='QUOTA'; | |
| 34 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 35 | SELECT basepacket_id, basecomponent_id, 2, 40960, 2, 2, 2, false, 102 FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='TRAFFIC'; | |
| 36 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 37 | SELECT basepacket_id, basecomponent_id, 4, 40960, 4, 4, 4, false, 202 FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='TRAFFIC'; | |
| 38 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 39 | SELECT basepacket_id, basecomponent_id, 5, 40960, 5, 5, 0, false, 302 FROM basepacket, basecomponent WHERE basepacket_code='WEB' AND basecomponent_code='TRAFFIC'; | |
| 40 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 41 | SELECT basepacket_id, basecomponent_id, 0, 4, 0, 1, 0, false, 103 FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='DAEMON'; | |
| 42 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 43 | SELECT basepacket_id, basecomponent_id, 0, 0, 0, 1, 0, false, 203 FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='DAEMON'; | |
| 44 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 45 | SELECT basepacket_id, basecomponent_id, 0, 4, 0, 1, 0, false, 303 FROM basepacket, basecomponent WHERE basepacket_code='WEB' AND basecomponent_code='DAEMON'; | |
| 46 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 47 | SELECT basepacket_id, basecomponent_id, 0, 1, 1, 1, 1, false, 104 FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='MIRROR'; | |
| 48 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 49 | SELECT basepacket_id, basecomponent_id, 0, 1, 1, 1, 1, false, 204 FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='MIRROR'; | |
| 50 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 51 | SELECT basepacket_id, basecomponent_id, 0, 1, 1, 1, 1, false, 304 FROM basepacket, basecomponent WHERE basepacket_code='WEB' AND basecomponent_code='MIRROR'; | |
| 52 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 53 | SELECT basepacket_id, basecomponent_id, 0, 1, 1, 1, 1, false, 105 FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='BACKUP'; | |
| 54 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 55 | SELECT basepacket_id, basecomponent_id, 0, 1, 1, 1, 1, false, 205 FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='BACKUP'; | |
| 56 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number) | |
| 57 | SELECT basepacket_id, basecomponent_id, 0, 1, 1, 1, 1, false, 305 FROM basepacket, basecomponent WHERE basepacket_code='WEB' AND basecomponent_code='BACKUP'; | |
| f94bfc | 58 | |
| PH | 59 | -- |
| 60 | -- Table: business_partner | |
| 61 | -- | |
| 62 | INSERT INTO business_partner (member_id, member_code, member_since, shares_signed) | |
| 63 | VALUES (10000, 'hsh00-hsh', current_date, 0); | |
| 64 | ||
| 65 | -- | |
| 66 | -- table: contact | |
| 67 | -- | |
| 68 | INSERT INTO contact (bp_id, salut, first_name, last_name, firma, email) | |
| 69 | SELECT bp_id, 'Herr', 'Uwe', 'Mueller', 'Hostsharing eG', 'service@hostsharing.net' FROM business_partner WHERE member_id=10000; | |
| 70 | ||
| 71 | -- | |
| 72 | -- table: bank_account | |
| 73 | -- | |
| f2fd2d | 74 | INSERT INTO bank_account (bp_id, autodebit_ga, autodebit_ar, autodebit_op, |
| P | 75 | bank_customer, bank_account, bank_code, bank_name) |
| 76 | SELECT bp_id, false, false, false, '', '', '', '' FROM business_partner WHERE member_id=10000; | |
| f94bfc | 77 | |
| PH | 78 | -- |
| 79 | -- table: billdata | |
| 80 | -- | |
| 81 | INSERT INTO billdata (bp_id) | |
| 82 | SELECT bp_id FROM business_partner WHERE member_id=10000; | |
| 83 | ||
| 84 | -- | |
| 85 | -- Table: inet_addr | |
| 86 | -- | |
| 87 | INSERT INTO inet_addr (inet_addr, description) | |
| dc8716 | 88 | VALUES (inet '176.9.242.67', 'address 67'); |
| f94bfc | 89 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 90 | VALUES (inet '176.9.242.72', 'address 72'); |
| f94bfc | 91 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 92 | VALUES (inet '176.9.242.73', 'address 73'); |
| f94bfc | 93 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 94 | VALUES (inet '176.9.242.74', 'address 74'); |
| f94bfc | 95 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 96 | VALUES (inet '176.9.242.75', 'address 75'); |
| f94bfc | 97 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 98 | VALUES (inet '176.9.242.76', 'address 76'); |
| PH | 99 | INSERT INTO inet_addr (inet_addr, description) |
| 100 | VALUES (inet '176.9.242.77', 'address 77'); | |
| 101 | INSERT INTO inet_addr (inet_addr, description) | |
| 102 | VALUES (inet '176.9.242.78', 'address 78'); | |
| f94bfc | 103 | |
| PH | 104 | -- |
| 105 | -- Table: Hive | |
| 106 | -- | |
| 107 | INSERT INTO hive (hive_name, inet_addr_id, description) | |
| a9e0da | 108 | SELECT 'h99', inet_addr_id, 'Test Hive h99' FROM inet_addr WHERE inet_addr = inet '176.9.242.67'; |
| f94bfc | 109 | |
| PH | 110 | -- |
| 111 | -- table: packet | |
| 112 | -- | |
| 113 | INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id) | |
| 114 | SELECT 'hsh00', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr | |
| 6bca4d | 115 | WHERE hive_name='h99' AND inet_addr = inet '176.9.242.72' AND member_id = 10000; |
| f94bfc | 116 | INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id) |
| PH | 117 | SELECT 'hsh01', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr |
| b3a545 | 118 | WHERE hive_name='h99' AND inet_addr = inet '176.9.242.73' AND member_id = 10000; |
| c464f5 | 119 | |
| PH | 120 | -- |
| 121 | -- table: packet_component | |
| 122 | -- | |
| 123 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 124 | SELECT 1, 1, packet.packet_id, 2, current_date FROM packet | |
| 125 | WHERE packet.packet_name = 'hsh00'; | |
| 126 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 127 | SELECT 1, 2, packet.packet_id, 128, current_date FROM packet | |
| 128 | WHERE packet.packet_name = 'hsh00'; | |
| 129 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 130 | SELECT 1, 3, packet.packet_id, 0, current_date FROM packet | |
| 131 | WHERE packet.packet_name = 'hsh00'; | |
| 132 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 133 | SELECT 1, 4, packet.packet_id, 0, current_date FROM packet | |
| 134 | WHERE packet.packet_name = 'hsh00'; | |
| 135 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 136 | SELECT 1, 5, packet.packet_id, 0, current_date FROM packet | |
| 137 | WHERE packet.packet_name = 'hsh00'; | |
| 138 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 139 | SELECT 1, 1, packet.packet_id, 2, current_date FROM packet | |
| 140 | WHERE packet.packet_name = 'hsh01'; | |
| 141 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 142 | SELECT 1, 2, packet.packet_id, 128, current_date FROM packet | |
| 143 | WHERE packet.packet_name = 'hsh01'; | |
| 144 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 145 | SELECT 1, 3, packet.packet_id, 0, current_date FROM packet | |
| 146 | WHERE packet.packet_name = 'hsh01'; | |
| 147 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 148 | SELECT 1, 4, packet.packet_id, 0, current_date FROM packet | |
| 149 | WHERE packet.packet_name = 'hsh01'; | |
| 150 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 151 | SELECT 1, 5, packet.packet_id, 0, current_date FROM packet | |
| 152 | WHERE packet.packet_name = 'hsh01'; | |
| 153 | ||
| f94bfc | 154 | -- |
| PH | 155 | -- table: unixuser |
| 156 | -- | |
| 157 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 158 | SELECT 'hsh00', 'packet hsh00', '/bin/bash', '/home/pacs/hsh00', FALSE, packet_id, 10001 FROM packet | |
| 159 | WHERE packet_name='hsh00'; | |
| 160 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 161 | SELECT 'hsh01', 'packet hsh01', '/bin/bash', '/home/pacs/hsh01', FALSE, packet_id, 10002 FROM packet | |
| 162 | WHERE packet_name='hsh01'; | |
| 163 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 613589 | 164 | SELECT 'hsh01-ad', 'hostmaster ad', '/bin/bash', '/home/pacs/hsh01/users/ad', FALSE, packet_id, 10003 FROM packet |
| f94bfc | 165 | WHERE packet_name='hsh01'; |
| d379af | 166 | |
| PB | 167 | -- |
| 168 | -- table: domain_option | |
| 169 | -- | |
| 170 | INSERT INTO domain_option (domain_option_name) | |
| ea42d6 | 171 | VALUES ('backupmxforexternalmx'); |
| PB | 172 | INSERT INTO domain_option (domain_option_name) |
| 173 | VALUES ('greylisting'); | |
| d379af | 174 | INSERT INTO domain_option (domain_option_name) |
| ea42d6 | 175 | VALUES ('htdocsfallback'); |
| PB | 176 | INSERT INTO domain_option (domain_option_name) |
| 177 | VALUES ('includes'); | |
| 178 | INSERT INTO domain_option (domain_option_name) | |
| 179 | VALUES ('indexes'); | |
| 180 | INSERT INTO domain_option (domain_option_name) | |
| 181 | VALUES ('multiviews'); | |
| e5fe2a | 182 | INSERT INTO domain_option (domain_option_name) |
| PB | 183 | VALUES ('php'); |
| f32fd2 | 184 | |
| PH | 185 | -- |
| 186 | -- table: price_list | |
| 187 | -- | |
| 188 | INSERT INTO price_list VALUES (1, 'Default Price List'); | |
| 189 | ||
| 190 | -- | |
| 191 | -- table: customer_price_list_mapping | |
| 192 | -- | |
| 193 | INSERT INTO customer_price_list_mapping (SELECT bp_id, 1 FROM business_partner); | |
| 194 | ||
| 195 | ||
