| commit | author | age | ||
| 13151e | 1 | -- |
| PH | 2 | -- Table: basepacket |
| 3 | -- | |
| 4 | INSERT INTO basepacket (basepacket_code, description, sorting, valid) | |
| 5 | VALUES ('DW/B', 'Dynamic-Web/Base', 100, true); | |
| 6 | INSERT INTO basepacket (basepacket_code, description, sorting, valid) | |
| 7 | VALUES ('SW/B', 'Static-Web/Base', 200, true); | |
| 8 | ||
| 9 | -- | |
| 10 | -- Table: basecomponent | |
| 11 | -- | |
| 12 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) | |
| 13 | VALUES ('TRAFFIC', 'Monatliches Datenvolumen in GB', 100, true); | |
| 14 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) | |
| 15 | VALUES ('QUOTA', 'Festplattenspeicherplatz in MB', 200, true); | |
| 16 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) | |
| 17 | VALUES ('TOMCAT', 'Nutzung eines eigenen Tomcat-Servers', 300, true); | |
| 18 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) | |
| 19 | VALUES ('ZOPE', 'Nutzung eines eigenen Zope-Servers', 310, true); | |
| 20 | INSERT INTO basecomponent (basecomponent_code, description, sorting, valid) | |
| 21 | VALUES ('APACHE', 'Nutzung eines eigenen Apache-Servers', 310, true); | |
| 22 | ||
| 23 | -- | |
| 24 | -- Table: component | |
| 25 | -- | |
| 26 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 27 | SELECT basepacket_id, basecomponent_id, 128, 40960, 128, 128, 128, false FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='QUOTA'; | |
| 28 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 29 | SELECT basepacket_id, basecomponent_id, 512, 40960, 512, 512, 512, false FROM basepacket, basecomponent WHERE basepacket_code='SW/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) | |
| 31 | SELECT basepacket_id, basecomponent_id, 2, 40960, 2, 2, 2, false FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='TRAFFIC'; | |
| 32 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 33 | SELECT basepacket_id, basecomponent_id, 4, 40960, 4, 4, 4, false FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='TRAFFIC'; | |
| 34 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 35 | SELECT basepacket_id, basecomponent_id, 0, 4, 0, 1, 0, false FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='TOMCAT'; | |
| 36 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 37 | SELECT basepacket_id, basecomponent_id, 0, 0, 0, 1, 0, false FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='TOMCAT'; | |
| 38 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 39 | SELECT basepacket_id, basecomponent_id, 0, 4, 0, 1, 0, false FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='ZOPE'; | |
| 40 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 41 | SELECT basepacket_id, basecomponent_id, 0, 0, 0, 1, 0, false FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='ZOPE'; | |
| 42 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 43 | SELECT basepacket_id, basecomponent_id, 0, 4, 0, 1, 0, false FROM basepacket, basecomponent WHERE basepacket_code='DW/B' AND basecomponent_code='APACHE'; | |
| 44 | INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only) | |
| 45 | SELECT basepacket_id, basecomponent_id, 0, 0, 0, 1, 0, false FROM basepacket, basecomponent WHERE basepacket_code='SW/B' AND basecomponent_code='APACHE'; | |
| f94bfc | 46 | |
| PH | 47 | -- |
| 48 | -- Table: business_partner | |
| 49 | -- | |
| 50 | INSERT INTO business_partner (member_id, member_code, member_since, shares_signed) | |
| 51 | VALUES (10000, 'hsh00-hsh', current_date, 0); | |
| 52 | ||
| 53 | -- | |
| 54 | -- table: contact | |
| 55 | -- | |
| 56 | INSERT INTO contact (bp_id, salut, first_name, last_name, firma, email) | |
| 57 | SELECT bp_id, 'Herr', 'Uwe', 'Mueller', 'Hostsharing eG', 'service@hostsharing.net' FROM business_partner WHERE member_id=10000; | |
| 58 | ||
| 59 | -- | |
| 60 | -- table: bank_account | |
| 61 | -- | |
| 62 | INSERT INTO bank_account (bp_id) | |
| 63 | SELECT bp_id FROM business_partner WHERE member_id=10000; | |
| 64 | ||
| 65 | -- | |
| 66 | -- table: billdata | |
| 67 | -- | |
| 68 | INSERT INTO billdata (bp_id) | |
| 69 | SELECT bp_id FROM business_partner WHERE member_id=10000; | |
| 70 | ||
| 71 | -- | |
| 72 | -- Table: inet_addr | |
| 73 | -- | |
| 74 | INSERT INTO inet_addr (inet_addr, description) | |
| dc8716 | 75 | VALUES (inet '176.9.242.66', 'address 66'); |
| f94bfc | 76 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 77 | VALUES (inet '176.9.242.67', 'address 67'); |
| f94bfc | 78 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 79 | VALUES (inet '176.9.242.68', 'address 68'); |
| f94bfc | 80 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 81 | VALUES (inet '176.9.242.69', 'address 69'); |
| f94bfc | 82 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 83 | VALUES (inet '176.9.242.70', 'address 70'); |
| f94bfc | 84 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 85 | VALUES (inet '176.9.242.71', 'address 71'); |
| f94bfc | 86 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 87 | VALUES (inet '176.9.242.72', 'address 72'); |
| f94bfc | 88 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 89 | VALUES (inet '176.9.242.73', 'address 73'); |
| f94bfc | 90 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 91 | VALUES (inet '176.9.242.74', 'address 74'); |
| f94bfc | 92 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 93 | VALUES (inet '176.9.242.75', 'address 75'); |
| f94bfc | 94 | INSERT INTO inet_addr (inet_addr, description) |
| dc8716 | 95 | VALUES (inet '176.9.242.76', 'address 76'); |
| PH | 96 | INSERT INTO inet_addr (inet_addr, description) |
| 97 | VALUES (inet '176.9.242.77', 'address 77'); | |
| 98 | INSERT INTO inet_addr (inet_addr, description) | |
| 99 | VALUES (inet '176.9.242.78', 'address 78'); | |
| f94bfc | 100 | |
| PH | 101 | -- |
| 102 | -- Table: Hive | |
| 103 | -- | |
| 104 | INSERT INTO hive (hive_name, inet_addr_id, description) | |
| dc8716 | 105 | SELECT 'h81', inet_addr_id, 'Test Hive h081' FROM inet_addr WHERE inet_addr = inet '176.9.242.67'; |
| f94bfc | 106 | |
| PH | 107 | -- |
| 108 | -- table: packet | |
| 109 | -- | |
| 110 | INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id) | |
| 111 | SELECT 'hsh00', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr | |
| dc8716 | 112 | WHERE hive_name='h81' AND inet_addr = inet '176.9.242.68' AND member_id = 10000; |
| f94bfc | 113 | INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id) |
| PH | 114 | SELECT 'hsh01', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr |
| dc8716 | 115 | WHERE hive_name='h81' AND inet_addr = inet '176.9.242.69' AND member_id = 10000; |
| c464f5 | 116 | |
| PH | 117 | -- |
| 118 | -- table: packet_component | |
| 119 | -- | |
| 120 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 121 | SELECT 1, 1, packet.packet_id, 2, current_date FROM packet | |
| 122 | WHERE packet.packet_name = 'hsh00'; | |
| 123 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 124 | SELECT 1, 2, packet.packet_id, 128, 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, 3, packet.packet_id, 0, 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, 4, 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, 5, 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, 1, packet.packet_id, 2, current_date FROM packet | |
| 137 | WHERE packet.packet_name = 'hsh01'; | |
| 138 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 139 | SELECT 1, 2, packet.packet_id, 128, 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, 3, packet.packet_id, 0, 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, 4, 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, 5, packet.packet_id, 0, current_date FROM packet | |
| 149 | WHERE packet.packet_name = 'hsh01'; | |
| 150 | ||
| f94bfc | 151 | -- |
| PH | 152 | -- table: unixuser |
| 153 | -- | |
| 154 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 155 | SELECT 'hsh00', 'packet hsh00', '/bin/bash', '/home/pacs/hsh00', FALSE, packet_id, 10001 FROM packet | |
| 156 | WHERE packet_name='hsh00'; | |
| 157 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 158 | SELECT 'hsh01', 'packet hsh01', '/bin/bash', '/home/pacs/hsh01', FALSE, packet_id, 10002 FROM packet | |
| 159 | WHERE packet_name='hsh01'; | |
| 160 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 613589 | 161 | SELECT 'hsh01-ad', 'hostmaster ad', '/bin/bash', '/home/pacs/hsh01/users/ad', FALSE, packet_id, 10003 FROM packet |
| f94bfc | 162 | WHERE packet_name='hsh01'; |
