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