| 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) | |
| 75 | VALUES (inet '192.168.108.200', 'address 200'); | |
| 76 | INSERT INTO inet_addr (inet_addr, description) | |
| 77 | VALUES (inet '192.168.108.201', 'address 201'); | |
| 78 | INSERT INTO inet_addr (inet_addr, description) | |
| 79 | VALUES (inet '192.168.108.202', 'address 202'); | |
| 80 | INSERT INTO inet_addr (inet_addr, description) | |
| 81 | VALUES (inet '192.168.108.203', 'address 203'); | |
| 82 | INSERT INTO inet_addr (inet_addr, description) | |
| 83 | VALUES (inet '192.168.108.204', 'address 204'); | |
| 84 | INSERT INTO inet_addr (inet_addr, description) | |
| 85 | VALUES (inet '192.168.108.205', 'address 205'); | |
| 86 | INSERT INTO inet_addr (inet_addr, description) | |
| 87 | VALUES (inet '192.168.108.206', 'address 206'); | |
| 88 | INSERT INTO inet_addr (inet_addr, description) | |
| 89 | VALUES (inet '192.168.108.207', 'address 207'); | |
| 90 | INSERT INTO inet_addr (inet_addr, description) | |
| 91 | VALUES (inet '192.168.108.208', 'address 208'); | |
| 92 | INSERT INTO inet_addr (inet_addr, description) | |
| 93 | VALUES (inet '192.168.108.209', 'address 209'); | |
| 94 | INSERT INTO inet_addr (inet_addr, description) | |
| 95 | VALUES (inet '192.168.108.210', 'address 210'); | |
| 96 | ||
| 97 | -- | |
| 98 | -- Table: Hive | |
| 99 | -- | |
| 100 | INSERT INTO hive (hive_name, inet_addr_id, description) | |
| 101 | SELECT 'h81', inet_addr_id, 'Test Hive h081' FROM inet_addr WHERE inet_addr = inet '192.168.108.200'; | |
| 102 | ||
| 103 | -- | |
| 104 | -- table: packet | |
| 105 | -- | |
| 106 | INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id) | |
| 107 | SELECT 'hsh00', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr | |
| 108 | WHERE hive_name='h81' AND inet_addr = inet '192.168.108.201' AND member_id = 10000; | |
| 109 | INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id) | |
| 110 | SELECT 'hsh01', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr | |
| c464f5 | 111 | WHERE hive_name='h81' AND inet_addr = inet '192.168.108.202' AND member_id = 10000; |
| PH | 112 | |
| 113 | -- | |
| 114 | -- table: packet_component | |
| 115 | -- | |
| 116 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 117 | SELECT 1, 1, packet.packet_id, 2, current_date FROM packet | |
| 118 | WHERE packet.packet_name = 'hsh00'; | |
| 119 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 120 | SELECT 1, 2, packet.packet_id, 128, current_date FROM packet | |
| 121 | WHERE packet.packet_name = 'hsh00'; | |
| 122 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 123 | SELECT 1, 3, packet.packet_id, 0, current_date FROM packet | |
| 124 | WHERE packet.packet_name = 'hsh00'; | |
| 125 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 126 | SELECT 1, 4, packet.packet_id, 0, current_date FROM packet | |
| 127 | WHERE packet.packet_name = 'hsh00'; | |
| 128 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 129 | SELECT 1, 5, packet.packet_id, 0, current_date FROM packet | |
| 130 | WHERE packet.packet_name = 'hsh00'; | |
| 131 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 132 | SELECT 1, 1, packet.packet_id, 2, current_date FROM packet | |
| 133 | WHERE packet.packet_name = 'hsh01'; | |
| 134 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 135 | SELECT 1, 2, packet.packet_id, 128, current_date FROM packet | |
| 136 | WHERE packet.packet_name = 'hsh01'; | |
| 137 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 138 | SELECT 1, 3, packet.packet_id, 0, current_date FROM packet | |
| 139 | WHERE packet.packet_name = 'hsh01'; | |
| 140 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 141 | SELECT 1, 4, packet.packet_id, 0, current_date FROM packet | |
| 142 | WHERE packet.packet_name = 'hsh01'; | |
| 143 | INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created) | |
| 144 | SELECT 1, 5, packet.packet_id, 0, current_date FROM packet | |
| 145 | WHERE packet.packet_name = 'hsh01'; | |
| 146 | ||
| f94bfc | 147 | -- |
| PH | 148 | -- table: unixuser |
| 149 | -- | |
| 150 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 151 | SELECT 'hsh00', 'packet hsh00', '/bin/bash', '/home/pacs/hsh00', FALSE, packet_id, 10001 FROM packet | |
| 152 | WHERE packet_name='hsh00'; | |
| 153 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 154 | SELECT 'hsh01', 'packet hsh01', '/bin/bash', '/home/pacs/hsh01', FALSE, packet_id, 10002 FROM packet | |
| 155 | WHERE packet_name='hsh01'; | |
| 156 | INSERT INTO unixuser (name, comment, shell, homedir, locked, packet_id, userid) | |
| 613589 | 157 | SELECT 'hsh01-ad', 'hostmaster ad', '/bin/bash', '/home/pacs/hsh01/users/ad', FALSE, packet_id, 10003 FROM packet |
| f94bfc | 158 | WHERE packet_name='hsh01'; |
