1-- AUTOGENERATED BY storj.io/dbx 2-- DO NOT EDIT 3CREATE TABLE accounting_rollups ( 4 node_id bytea NOT NULL, 5 start_time timestamp with time zone NOT NULL, 6 put_total bigint NOT NULL, 7 get_total bigint NOT NULL, 8 get_audit_total bigint NOT NULL, 9 get_repair_total bigint NOT NULL, 10 put_repair_total bigint NOT NULL, 11 at_rest_total double precision NOT NULL, 12 PRIMARY KEY ( node_id, start_time ) 13); 14CREATE TABLE accounting_timestamps ( 15 name text NOT NULL, 16 value timestamp with time zone NOT NULL, 17 PRIMARY KEY ( name ) 18); 19CREATE TABLE audit_histories ( 20 node_id bytea NOT NULL, 21 history bytea NOT NULL, 22 PRIMARY KEY ( node_id ) 23); 24CREATE TABLE bucket_bandwidth_rollups ( 25 bucket_name bytea NOT NULL, 26 project_id bytea NOT NULL, 27 interval_start timestamp with time zone NOT NULL, 28 interval_seconds integer NOT NULL, 29 action integer NOT NULL, 30 inline bigint NOT NULL, 31 allocated bigint NOT NULL, 32 settled bigint NOT NULL, 33 PRIMARY KEY ( bucket_name, project_id, interval_start, action ) 34); 35CREATE TABLE bucket_bandwidth_rollup_archives ( 36 bucket_name bytea NOT NULL, 37 project_id bytea NOT NULL, 38 interval_start timestamp with time zone NOT NULL, 39 interval_seconds integer NOT NULL, 40 action integer NOT NULL, 41 inline bigint NOT NULL, 42 allocated bigint NOT NULL, 43 settled bigint NOT NULL, 44 PRIMARY KEY ( bucket_name, project_id, interval_start, action ) 45); 46CREATE TABLE bucket_storage_tallies ( 47 bucket_name bytea NOT NULL, 48 project_id bytea NOT NULL, 49 interval_start timestamp with time zone NOT NULL, 50 inline bigint NOT NULL, 51 remote bigint NOT NULL, 52 remote_segments_count integer NOT NULL, 53 inline_segments_count integer NOT NULL, 54 object_count integer NOT NULL, 55 metadata_size bigint NOT NULL, 56 PRIMARY KEY ( bucket_name, project_id, interval_start ) 57); 58CREATE TABLE coinpayments_transactions ( 59 id text NOT NULL, 60 user_id bytea NOT NULL, 61 address text NOT NULL, 62 amount bytea NOT NULL, 63 received bytea NOT NULL, 64 status integer NOT NULL, 65 key text NOT NULL, 66 timeout integer NOT NULL, 67 created_at timestamp with time zone NOT NULL, 68 PRIMARY KEY ( id ) 69); 70CREATE TABLE coupons ( 71 id bytea NOT NULL, 72 user_id bytea NOT NULL, 73 amount bigint NOT NULL, 74 description text NOT NULL, 75 type integer NOT NULL, 76 status integer NOT NULL, 77 duration bigint NOT NULL, 78 coupon_code_name text, 79 created_at timestamp with time zone NOT NULL, 80 PRIMARY KEY ( id ) 81); 82CREATE TABLE coupon_codes ( 83 id bytea NOT NULL, 84 name text NOT NULL, 85 amount bigint NOT NULL, 86 description text NOT NULL, 87 type integer NOT NULL, 88 duration bigint NOT NULL, 89 created_at timestamp with time zone NOT NULL, 90 PRIMARY KEY ( id ), 91 UNIQUE ( name ) 92); 93CREATE TABLE coupon_usages ( 94 coupon_id bytea NOT NULL, 95 amount bigint NOT NULL, 96 status integer NOT NULL, 97 period timestamp with time zone NOT NULL, 98 PRIMARY KEY ( coupon_id, period ) 99); 100CREATE TABLE graceful_exit_progress ( 101 node_id bytea NOT NULL, 102 bytes_transferred bigint NOT NULL, 103 pieces_transferred bigint NOT NULL DEFAULT 0, 104 pieces_failed bigint NOT NULL DEFAULT 0, 105 updated_at timestamp with time zone NOT NULL, 106 PRIMARY KEY ( node_id ) 107); 108CREATE TABLE graceful_exit_transfer_queue ( 109 node_id bytea NOT NULL, 110 path bytea NOT NULL, 111 piece_num integer NOT NULL, 112 root_piece_id bytea, 113 durability_ratio double precision NOT NULL, 114 queued_at timestamp with time zone NOT NULL, 115 requested_at timestamp with time zone, 116 last_failed_at timestamp with time zone, 117 last_failed_code integer, 118 failed_count integer, 119 finished_at timestamp with time zone, 120 order_limit_send_count integer NOT NULL DEFAULT 0, 121 PRIMARY KEY ( node_id, path, piece_num ) 122); 123CREATE TABLE injuredsegments ( 124 path bytea NOT NULL, 125 data bytea NOT NULL, 126 attempted timestamp with time zone, 127 updated_at timestamp with time zone NOT NULL DEFAULT current_timestamp, 128 segment_health double precision NOT NULL DEFAULT 1, 129 PRIMARY KEY ( path ) 130); 131CREATE TABLE irreparabledbs ( 132 segmentpath bytea NOT NULL, 133 segmentdetail bytea NOT NULL, 134 pieces_lost_count bigint NOT NULL, 135 seg_damaged_unix_sec bigint NOT NULL, 136 repair_attempt_count bigint NOT NULL, 137 PRIMARY KEY ( segmentpath ) 138); 139CREATE TABLE nodes ( 140 id bytea NOT NULL, 141 address text NOT NULL DEFAULT '', 142 last_net text NOT NULL, 143 last_ip_port text, 144 protocol integer NOT NULL DEFAULT 0, 145 type integer NOT NULL DEFAULT 0, 146 email text NOT NULL, 147 wallet text NOT NULL, 148 wallet_features text NOT NULL DEFAULT '', 149 free_disk bigint NOT NULL DEFAULT -1, 150 piece_count bigint NOT NULL DEFAULT 0, 151 major bigint NOT NULL DEFAULT 0, 152 minor bigint NOT NULL DEFAULT 0, 153 patch bigint NOT NULL DEFAULT 0, 154 hash text NOT NULL DEFAULT '', 155 timestamp timestamp with time zone NOT NULL DEFAULT '0001-01-01 00:00:00+00', 156 release boolean NOT NULL DEFAULT false, 157 latency_90 bigint NOT NULL DEFAULT 0, 158 audit_success_count bigint NOT NULL DEFAULT 0, 159 total_audit_count bigint NOT NULL DEFAULT 0, 160 vetted_at timestamp with time zone, 161 uptime_success_count bigint NOT NULL DEFAULT 0, 162 total_uptime_count bigint NOT NULL DEFAULT 0, 163 created_at timestamp with time zone NOT NULL DEFAULT current_timestamp, 164 updated_at timestamp with time zone NOT NULL DEFAULT current_timestamp, 165 last_contact_success timestamp with time zone NOT NULL DEFAULT 'epoch', 166 last_contact_failure timestamp with time zone NOT NULL DEFAULT 'epoch', 167 contained boolean NOT NULL DEFAULT false, 168 disqualified timestamp with time zone, 169 suspended timestamp with time zone, 170 unknown_audit_suspended timestamp with time zone, 171 offline_suspended timestamp with time zone, 172 under_review timestamp with time zone, 173 online_score double precision NOT NULL DEFAULT 1, 174 audit_reputation_alpha double precision NOT NULL DEFAULT 1, 175 audit_reputation_beta double precision NOT NULL DEFAULT 0, 176 unknown_audit_reputation_alpha double precision NOT NULL DEFAULT 1, 177 unknown_audit_reputation_beta double precision NOT NULL DEFAULT 0, 178 exit_initiated_at timestamp with time zone, 179 exit_loop_completed_at timestamp with time zone, 180 exit_finished_at timestamp with time zone, 181 exit_success boolean NOT NULL DEFAULT false, 182 PRIMARY KEY ( id ) 183); 184CREATE TABLE node_api_versions ( 185 id bytea NOT NULL, 186 api_version integer NOT NULL, 187 created_at timestamp with time zone NOT NULL, 188 updated_at timestamp with time zone NOT NULL, 189 PRIMARY KEY ( id ) 190); 191CREATE TABLE offers ( 192 id serial NOT NULL, 193 name text NOT NULL, 194 description text NOT NULL, 195 award_credit_in_cents integer NOT NULL DEFAULT 0, 196 invitee_credit_in_cents integer NOT NULL DEFAULT 0, 197 award_credit_duration_days integer, 198 invitee_credit_duration_days integer, 199 redeemable_cap integer, 200 expires_at timestamp with time zone NOT NULL, 201 created_at timestamp with time zone NOT NULL, 202 status integer NOT NULL, 203 type integer NOT NULL, 204 PRIMARY KEY ( id ) 205); 206CREATE TABLE peer_identities ( 207 node_id bytea NOT NULL, 208 leaf_serial_number bytea NOT NULL, 209 chain bytea NOT NULL, 210 updated_at timestamp with time zone NOT NULL, 211 PRIMARY KEY ( node_id ) 212); 213CREATE TABLE pending_audits ( 214 node_id bytea NOT NULL, 215 piece_id bytea NOT NULL, 216 stripe_index bigint NOT NULL, 217 share_size bigint NOT NULL, 218 expected_share_hash bytea NOT NULL, 219 reverify_count bigint NOT NULL, 220 path bytea NOT NULL, 221 PRIMARY KEY ( node_id ) 222); 223CREATE TABLE projects ( 224 id bytea NOT NULL, 225 name text NOT NULL, 226 description text NOT NULL, 227 usage_limit bigint, 228 bandwidth_limit bigint, 229 rate_limit integer, 230 max_buckets integer, 231 partner_id bytea, 232 owner_id bytea NOT NULL, 233 created_at timestamp with time zone NOT NULL, 234 PRIMARY KEY ( id ) 235); 236CREATE TABLE project_bandwidth_rollups ( 237 project_id bytea NOT NULL, 238 interval_month date NOT NULL, 239 egress_allocated bigint NOT NULL, 240 PRIMARY KEY ( project_id, interval_month ) 241); 242CREATE TABLE registration_tokens ( 243 secret bytea NOT NULL, 244 owner_id bytea, 245 project_limit integer NOT NULL, 246 created_at timestamp with time zone NOT NULL, 247 PRIMARY KEY ( secret ), 248 UNIQUE ( owner_id ) 249); 250CREATE TABLE reset_password_tokens ( 251 secret bytea NOT NULL, 252 owner_id bytea NOT NULL, 253 created_at timestamp with time zone NOT NULL, 254 PRIMARY KEY ( secret ), 255 UNIQUE ( owner_id ) 256); 257CREATE TABLE revocations ( 258 revoked bytea NOT NULL, 259 api_key_id bytea NOT NULL, 260 PRIMARY KEY ( revoked ) 261); 262CREATE TABLE storagenode_bandwidth_rollups ( 263 storagenode_id bytea NOT NULL, 264 interval_start timestamp with time zone NOT NULL, 265 interval_seconds integer NOT NULL, 266 action integer NOT NULL, 267 allocated bigint DEFAULT 0, 268 settled bigint NOT NULL, 269 PRIMARY KEY ( storagenode_id, interval_start, action ) 270); 271CREATE TABLE storagenode_bandwidth_rollup_archives ( 272 storagenode_id bytea NOT NULL, 273 interval_start timestamp with time zone NOT NULL, 274 interval_seconds integer NOT NULL, 275 action integer NOT NULL, 276 allocated bigint DEFAULT 0, 277 settled bigint NOT NULL, 278 PRIMARY KEY ( storagenode_id, interval_start, action ) 279); 280CREATE TABLE storagenode_bandwidth_rollups_phase2 ( 281 storagenode_id bytea NOT NULL, 282 interval_start timestamp with time zone NOT NULL, 283 interval_seconds integer NOT NULL, 284 action integer NOT NULL, 285 allocated bigint DEFAULT 0, 286 settled bigint NOT NULL, 287 PRIMARY KEY ( storagenode_id, interval_start, action ) 288); 289CREATE TABLE storagenode_payments ( 290 id bigserial NOT NULL, 291 created_at timestamp with time zone NOT NULL, 292 node_id bytea NOT NULL, 293 period text NOT NULL, 294 amount bigint NOT NULL, 295 receipt text, 296 notes text, 297 PRIMARY KEY ( id ) 298); 299CREATE TABLE storagenode_paystubs ( 300 period text NOT NULL, 301 node_id bytea NOT NULL, 302 created_at timestamp with time zone NOT NULL, 303 codes text NOT NULL, 304 usage_at_rest double precision NOT NULL, 305 usage_get bigint NOT NULL, 306 usage_put bigint NOT NULL, 307 usage_get_repair bigint NOT NULL, 308 usage_put_repair bigint NOT NULL, 309 usage_get_audit bigint NOT NULL, 310 comp_at_rest bigint NOT NULL, 311 comp_get bigint NOT NULL, 312 comp_put bigint NOT NULL, 313 comp_get_repair bigint NOT NULL, 314 comp_put_repair bigint NOT NULL, 315 comp_get_audit bigint NOT NULL, 316 surge_percent bigint NOT NULL, 317 held bigint NOT NULL, 318 owed bigint NOT NULL, 319 disposed bigint NOT NULL, 320 paid bigint NOT NULL, 321 distributed bigint NOT NULL, 322 PRIMARY KEY ( period, node_id ) 323); 324CREATE TABLE storagenode_storage_tallies ( 325 node_id bytea NOT NULL, 326 interval_end_time timestamp with time zone NOT NULL, 327 data_total double precision NOT NULL, 328 PRIMARY KEY ( interval_end_time, node_id ) 329); 330CREATE TABLE stripe_customers ( 331 user_id bytea NOT NULL, 332 customer_id text NOT NULL, 333 created_at timestamp with time zone NOT NULL, 334 PRIMARY KEY ( user_id ), 335 UNIQUE ( customer_id ) 336); 337CREATE TABLE stripecoinpayments_invoice_project_records ( 338 id bytea NOT NULL, 339 project_id bytea NOT NULL, 340 storage double precision NOT NULL, 341 egress bigint NOT NULL, 342 objects bigint NOT NULL, 343 period_start timestamp with time zone NOT NULL, 344 period_end timestamp with time zone NOT NULL, 345 state integer NOT NULL, 346 created_at timestamp with time zone NOT NULL, 347 PRIMARY KEY ( id ), 348 UNIQUE ( project_id, period_start, period_end ) 349); 350CREATE TABLE stripecoinpayments_tx_conversion_rates ( 351 tx_id text NOT NULL, 352 rate bytea NOT NULL, 353 created_at timestamp with time zone NOT NULL, 354 PRIMARY KEY ( tx_id ) 355); 356CREATE TABLE users ( 357 id bytea NOT NULL, 358 email text NOT NULL, 359 normalized_email text NOT NULL, 360 full_name text NOT NULL, 361 short_name text, 362 password_hash bytea NOT NULL, 363 status integer NOT NULL, 364 partner_id bytea, 365 created_at timestamp with time zone NOT NULL, 366 project_limit integer NOT NULL DEFAULT 0, 367 position text, 368 company_name text, 369 company_size integer, 370 working_on text, 371 is_professional boolean NOT NULL DEFAULT false, 372 employee_count text, 373 PRIMARY KEY ( id ) 374); 375CREATE TABLE value_attributions ( 376 project_id bytea NOT NULL, 377 bucket_name bytea NOT NULL, 378 partner_id bytea NOT NULL, 379 last_updated timestamp with time zone NOT NULL, 380 PRIMARY KEY ( project_id, bucket_name ) 381); 382CREATE TABLE api_keys ( 383 id bytea NOT NULL, 384 project_id bytea NOT NULL REFERENCES projects( id ) ON DELETE CASCADE, 385 head bytea NOT NULL, 386 name text NOT NULL, 387 secret bytea NOT NULL, 388 partner_id bytea, 389 created_at timestamp with time zone NOT NULL, 390 PRIMARY KEY ( id ), 391 UNIQUE ( head ), 392 UNIQUE ( name, project_id ) 393); 394CREATE TABLE bucket_metainfos ( 395 id bytea NOT NULL, 396 project_id bytea NOT NULL REFERENCES projects( id ), 397 name bytea NOT NULL, 398 partner_id bytea, 399 path_cipher integer NOT NULL, 400 created_at timestamp with time zone NOT NULL, 401 default_segment_size integer NOT NULL, 402 default_encryption_cipher_suite integer NOT NULL, 403 default_encryption_block_size integer NOT NULL, 404 default_redundancy_algorithm integer NOT NULL, 405 default_redundancy_share_size integer NOT NULL, 406 default_redundancy_required_shares integer NOT NULL, 407 default_redundancy_repair_shares integer NOT NULL, 408 default_redundancy_optimal_shares integer NOT NULL, 409 default_redundancy_total_shares integer NOT NULL, 410 PRIMARY KEY ( id ), 411 UNIQUE ( project_id, name ) 412); 413CREATE TABLE project_members ( 414 member_id bytea NOT NULL REFERENCES users( id ) ON DELETE CASCADE, 415 project_id bytea NOT NULL REFERENCES projects( id ) ON DELETE CASCADE, 416 created_at timestamp with time zone NOT NULL, 417 PRIMARY KEY ( member_id, project_id ) 418); 419CREATE TABLE stripecoinpayments_apply_balance_intents ( 420 tx_id text NOT NULL REFERENCES coinpayments_transactions( id ) ON DELETE CASCADE, 421 state integer NOT NULL, 422 created_at timestamp with time zone NOT NULL, 423 PRIMARY KEY ( tx_id ) 424); 425CREATE TABLE user_credits ( 426 id serial NOT NULL, 427 user_id bytea NOT NULL REFERENCES users( id ) ON DELETE CASCADE, 428 offer_id integer NOT NULL REFERENCES offers( id ), 429 referred_by bytea REFERENCES users( id ) ON DELETE SET NULL, 430 type text NOT NULL, 431 credits_earned_in_cents integer NOT NULL, 432 credits_used_in_cents integer NOT NULL, 433 expires_at timestamp with time zone NOT NULL, 434 created_at timestamp with time zone NOT NULL, 435 PRIMARY KEY ( id ), 436 UNIQUE ( id, offer_id ) 437); 438CREATE INDEX accounting_rollups_start_time_index ON accounting_rollups ( start_time ); 439CREATE INDEX bucket_bandwidth_rollups_project_id_action_interval_index ON bucket_bandwidth_rollups ( project_id, action, interval_start ); 440CREATE INDEX bucket_bandwidth_rollups_action_interval_project_id_index ON bucket_bandwidth_rollups ( action, interval_start, project_id ); 441CREATE INDEX bucket_bandwidth_rollups_archive_project_id_action_interval_index ON bucket_bandwidth_rollup_archives ( project_id, action, interval_start ); 442CREATE INDEX bucket_bandwidth_rollups_archive_action_interval_project_id_index ON bucket_bandwidth_rollup_archives ( action, interval_start, project_id ); 443CREATE INDEX bucket_storage_tallies_project_id_interval_start_index ON bucket_storage_tallies ( project_id, interval_start ); 444CREATE INDEX graceful_exit_transfer_queue_nid_dr_qa_fa_lfa_index ON graceful_exit_transfer_queue ( node_id, durability_ratio, queued_at, finished_at, last_failed_at ); 445CREATE INDEX injuredsegments_attempted_index ON injuredsegments ( attempted ); 446CREATE INDEX injuredsegments_segment_health_index ON injuredsegments ( segment_health ); 447CREATE INDEX injuredsegments_updated_at_index ON injuredsegments ( updated_at ); 448CREATE INDEX node_last_ip ON nodes ( last_net ); 449CREATE INDEX nodes_dis_unk_exit_fin_last_success_index ON nodes ( disqualified, unknown_audit_suspended, exit_finished_at, last_contact_success ); 450CREATE INDEX storagenode_bandwidth_rollups_interval_start_index ON storagenode_bandwidth_rollups ( interval_start ); 451CREATE INDEX storagenode_bandwidth_rollup_archives_interval_start_index ON storagenode_bandwidth_rollup_archives ( interval_start ); 452CREATE INDEX storagenode_payments_node_id_period_index ON storagenode_payments ( node_id, period ); 453CREATE INDEX storagenode_paystubs_node_id_index ON storagenode_paystubs ( node_id ); 454CREATE INDEX storagenode_storage_tallies_node_id_index ON storagenode_storage_tallies ( node_id ); 455CREATE UNIQUE INDEX credits_earned_user_id_offer_id ON user_credits ( id, offer_id ); 456 457INSERT INTO "offers" ("id", "name", "description", "award_credit_in_cents", "invitee_credit_in_cents", "expires_at", "created_at", "status", "type", "award_credit_duration_days", "invitee_credit_duration_days") VALUES (1, 'Default referral offer', 'Is active when no other active referral offer', 300, 600, '2119-03-14 08:28:24.636949+00', '2019-07-14 08:28:24.636949+00', 1, 2, 365, 14); 458INSERT INTO "offers" ("id", "name", "description", "award_credit_in_cents", "invitee_credit_in_cents", "expires_at", "created_at", "status", "type", "award_credit_duration_days", "invitee_credit_duration_days") VALUES (2, 'Default free credit offer', 'Is active when no active free credit offer', 0, 300, '2119-03-14 08:28:24.636949+00', '2019-07-14 08:28:24.636949+00', 1, 1, NULL, 14); 459 460-- MAIN DATA -- 461 462INSERT INTO "accounting_rollups"("node_id", "start_time", "put_total", "get_total", "get_audit_total", "get_repair_total", "put_repair_total", "at_rest_total") VALUES (E'\\367M\\177\\251]t/\\022\\256\\214\\265\\025\\224\\204:\\217\\212\\0102<\\321\\374\\020&\\271Qc\\325\\261\\354\\246\\233'::bytea, '2019-02-09 00:00:00+00', 3000, 6000, 9000, 12000, 0, 15000); 463 464INSERT INTO "accounting_timestamps" VALUES ('LastAtRestTally', '0001-01-01 00:00:00+00'); 465INSERT INTO "accounting_timestamps" VALUES ('LastRollup', '0001-01-01 00:00:00+00'); 466INSERT INTO "accounting_timestamps" VALUES ('LastBandwidthTally', '0001-01-01 00:00:00+00'); 467 468INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "uptime_success_count", "total_uptime_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "online_score") VALUES (E'\\153\\313\\233\\074\\327\\177\\136\\070\\346\\001', '127.0.0.1:55516', '', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 0, 5, 0, 5, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 1, 0, false, 1); 469INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "uptime_success_count", "total_uptime_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "online_score") VALUES (E'\\006\\223\\250R\\221\\005\\365\\377v>0\\266\\365\\216\\255?\\347\\244\\371?2\\264\\262\\230\\007<\\001\\262\\263\\237\\247n', '127.0.0.1:55518', '', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 0, 0, 3, 3, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 1, 0, false, 1); 470INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "uptime_success_count", "total_uptime_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "online_score") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014', '127.0.0.1:55517', '', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 0, 0, 0, 0, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 1, 0, false, 1); 471INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "uptime_success_count", "total_uptime_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "online_score") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\015', '127.0.0.1:55519', '', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 1, 2, 1, 2, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 1, 0, false, 1); 472INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "uptime_success_count", "total_uptime_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "vetted_at", "online_score") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', '127.0.0.1:55520', '', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 300, 400, 300, 400, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 300, 0, 1, 0, false, '2020-03-18 12:00:00.000000+00', 1); 473INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "uptime_success_count", "total_uptime_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "online_score") VALUES (E'\\154\\313\\233\\074\\327\\177\\136\\070\\346\\001', '127.0.0.1:55516', '', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 0, 5, 0, 5, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 75, 25, false, 1); 474INSERT INTO "nodes"("id", "address", "last_net", "last_ip_port", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "uptime_success_count", "total_uptime_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "online_score") VALUES (E'\\154\\313\\233\\074\\327\\177\\136\\070\\346\\002', '127.0.0.1:55516', '127.0.0.0', '127.0.0.1:55516', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 0, 5, 0, 5, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 75, 25, false, 1); 475INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "online_score") VALUES (E'\\363\\341\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', '127.0.0.1:55516', '', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 0, 5, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 1, 0, false, 1); 476INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "wallet_features", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "online_score") VALUES (E'\\362\\341\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', '127.0.0.1:55516', '', 0, 4, '', '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 0, 5, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 1, 0, false, 1); 477 478INSERT INTO "users"("id", "full_name", "short_name", "email", "normalized_email", "password_hash", "status", "partner_id", "created_at", "is_professional", "project_limit") VALUES (E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, 'Noahson', 'William', '1email1@mail.test', '1EMAIL1@MAIL.TEST', E'some_readable_hash'::bytea, 1, NULL, '2019-02-14 08:28:24.614594+00', false, 10); 479INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "max_buckets", "partner_id", "owner_id", "created_at") VALUES (E'\\022\\217/\\014\\376!K\\023\\276\\031\\311}m\\236\\205\\300'::bytea, 'ProjectName', 'projects description', 5e11, 5e11, NULL, NULL, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2019-02-14 08:28:24.254934+00'); 480 481INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "max_buckets", "partner_id", "owner_id", "created_at") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea, 'projName1', 'Test project 1', 5e11, 5e11, NULL, NULL, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2019-02-14 08:28:24.636949+00'); 482INSERT INTO "project_members"("member_id", "project_id", "created_at") VALUES (E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea, '2019-02-14 08:28:24.677953+00'); 483INSERT INTO "project_members"("member_id", "project_id", "created_at") VALUES (E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, E'\\022\\217/\\014\\376!K\\023\\276\\031\\311}m\\236\\205\\300'::bytea, '2019-02-13 08:28:24.677953+00'); 484 485INSERT INTO "irreparabledbs" ("segmentpath", "segmentdetail", "pieces_lost_count", "seg_damaged_unix_sec", "repair_attempt_count") VALUES ('\x49616d5365676d656e746b6579696e666f30', '\x49616d5365676d656e7464657461696c696e666f30', 10, 1550159554, 10); 486 487INSERT INTO "registration_tokens" ("secret", "owner_id", "project_limit", "created_at") VALUES (E'\\070\\127\\144\\013\\332\\344\\102\\376\\306\\056\\303\\130\\106\\132\\321\\276\\321\\274\\170\\264\\054\\333\\221\\116\\154\\221\\335\\070\\220\\146\\344\\216'::bytea, null, 1, '2019-02-14 08:28:24.677953+00'); 488 489INSERT INTO "storagenode_bandwidth_rollups" ("storagenode_id", "interval_start", "interval_seconds", "action", "allocated", "settled") VALUES (E'\\006\\223\\250R\\221\\005\\365\\377v>0\\266\\365\\216\\255?\\347\\244\\371?2\\264\\262\\230\\007<\\001\\262\\263\\237\\247n', '2019-03-06 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 3600, 1, 1024, 2024); 490INSERT INTO "storagenode_storage_tallies" VALUES (E'\\3510\\323\\225"~\\036<\\342\\330m\\0253Jhr\\246\\233K\\246#\\2303\\351\\256\\275j\\212UM\\362\\207', '2019-02-14 08:16:57.812849+00', 1000); 491 492INSERT INTO "bucket_bandwidth_rollups" ("bucket_name", "project_id", "interval_start", "interval_seconds", "action", "inline", "allocated", "settled") VALUES (E'testbucket'::bytea, E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea,'2019-03-06 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 3600, 1, 1024, 2024, 3024); 493INSERT INTO "bucket_storage_tallies" ("bucket_name", "project_id", "interval_start", "inline", "remote", "remote_segments_count", "inline_segments_count", "object_count", "metadata_size") VALUES (E'testbucket'::bytea, E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea,'2019-03-06 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 4024, 5024, 0, 0, 0, 0); 494INSERT INTO "bucket_bandwidth_rollups" ("bucket_name", "project_id", "interval_start", "interval_seconds", "action", "inline", "allocated", "settled") VALUES (E'testbucket'::bytea, E'\\170\\160\\157\\370\\274\\366\\113\\364\\272\\235\\301\\243\\321\\102\\321\\136'::bytea,'2019-03-06 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 3600, 1, 1024, 2024, 3024); 495INSERT INTO "bucket_storage_tallies" ("bucket_name", "project_id", "interval_start", "inline", "remote", "remote_segments_count", "inline_segments_count", "object_count", "metadata_size") VALUES (E'testbucket'::bytea, E'\\170\\160\\157\\370\\274\\366\\113\\364\\272\\235\\301\\243\\321\\102\\321\\136'::bytea,'2019-03-06 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 4024, 5024, 0, 0, 0, 0); 496 497INSERT INTO "reset_password_tokens" ("secret", "owner_id", "created_at") VALUES (E'\\070\\127\\144\\013\\332\\344\\102\\376\\306\\056\\303\\130\\106\\132\\321\\276\\321\\274\\170\\264\\054\\333\\221\\116\\154\\221\\335\\070\\220\\146\\344\\216'::bytea, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2019-05-08 08:28:24.677953+00'); 498 499INSERT INTO "api_keys" ("id", "project_id", "head", "name", "secret", "partner_id", "created_at") VALUES (E'\\334/\\302;\\225\\355O\\323\\276f\\247\\354/6\\241\\033'::bytea, E'\\022\\217/\\014\\376!K\\023\\276\\031\\311}m\\236\\205\\300'::bytea, E'\\111\\142\\147\\304\\132\\375\\070\\163\\270\\160\\251\\370\\126\\063\\351\\037\\257\\071\\143\\375\\351\\320\\253\\232\\220\\260\\075\\173\\306\\307\\115\\136'::bytea, 'key 2', E'\\254\\011\\315\\333\\273\\365\\001\\071\\024\\154\\253\\332\\301\\216\\361\\074\\221\\367\\251\\231\\274\\333\\300\\367\\001\\272\\327\\111\\315\\123\\042\\016'::bytea, NULL, '2019-02-14 08:28:24.267934+00'); 500 501INSERT INTO "value_attributions" ("project_id", "bucket_name", "partner_id", "last_updated") VALUES (E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, E''::bytea, E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea,'2019-02-14 08:07:31.028103+00'); 502 503INSERT INTO "user_credits" ("id", "user_id", "offer_id", "referred_by", "credits_earned_in_cents", "credits_used_in_cents", "type", "expires_at", "created_at") VALUES (1, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, 1, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, 200, 0, 'invalid', '2019-10-01 08:28:24.267934+00', '2019-06-01 08:28:24.267934+00'); 504 505INSERT INTO "bucket_metainfos" ("id", "project_id", "name", "partner_id", "created_at", "path_cipher", "default_segment_size", "default_encryption_cipher_suite", "default_encryption_block_size", "default_redundancy_algorithm", "default_redundancy_share_size", "default_redundancy_required_shares", "default_redundancy_repair_shares", "default_redundancy_optimal_shares", "default_redundancy_total_shares") VALUES (E'\\334/\\302;\\225\\355O\\323\\276f\\247\\354/6\\241\\033'::bytea, E'\\022\\217/\\014\\376!K\\023\\276\\031\\311}m\\236\\205\\300'::bytea, E'testbucketuniquename'::bytea, NULL, '2019-06-14 08:28:24.677953+00', 1, 65536, 1, 8192, 1, 4096, 4, 6, 8, 10); 506 507INSERT INTO "pending_audits" ("node_id", "piece_id", "stripe_index", "share_size", "expected_share_hash", "reverify_count", "path") VALUES (E'\\153\\313\\233\\074\\327\\177\\136\\070\\346\\001'::bytea, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, 5, 1024, E'\\070\\127\\144\\013\\332\\344\\102\\376\\306\\056\\303\\130\\106\\132\\321\\276\\321\\274\\170\\264\\054\\333\\221\\116\\154\\221\\335\\070\\220\\146\\344\\216'::bytea, 1, 'not null'); 508 509INSERT INTO "peer_identities" VALUES (E'\\334/\\302;\\225\\355O\\323\\276f\\247\\354/6\\241\\033'::bytea, E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2019-02-14 08:07:31.335028+00'); 510 511INSERT INTO "graceful_exit_progress" ("node_id", "bytes_transferred", "pieces_transferred", "pieces_failed", "updated_at") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', 1000000000000000, 0, 0, '2019-09-12 10:07:31.028103+00'); 512INSERT INTO "graceful_exit_transfer_queue" ("node_id", "path", "piece_num", "durability_ratio", "queued_at", "requested_at", "last_failed_at", "last_failed_code", "failed_count", "finished_at", "order_limit_send_count") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', E'f8419768-5baa-4901-b3ba-62808013ec45/s0/test3/\\240\\243\\223n \\334~b}\\2624)\\250m\\201\\202\\235\\276\\361\\3304\\323\\352\\311\\361\\353;\\326\\311', 8, 1.0, '2019-09-12 10:07:31.028103+00', '2019-09-12 10:07:32.028103+00', null, null, 0, '2019-09-12 10:07:33.028103+00', 0); 513INSERT INTO "graceful_exit_transfer_queue" ("node_id", "path", "piece_num", "durability_ratio", "queued_at", "requested_at", "last_failed_at", "last_failed_code", "failed_count", "finished_at", "order_limit_send_count") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', E'f8419768-5baa-4901-b3ba-62808013ec45/s0/test3/\\240\\243\\223n \\334~b}\\2624)\\250m\\201\\202\\235\\276\\361\\3304\\323\\352\\311\\361\\353;\\326\\312', 8, 1.0, '2019-09-12 10:07:31.028103+00', '2019-09-12 10:07:32.028103+00', null, null, 0, '2019-09-12 10:07:33.028103+00', 0); 514 515INSERT INTO "stripe_customers" ("user_id", "customer_id", "created_at") VALUES (E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, 'stripe_id', '2019-06-01 08:28:24.267934+00'); 516 517INSERT INTO "graceful_exit_transfer_queue" ("node_id", "path", "piece_num", "durability_ratio", "queued_at", "requested_at", "last_failed_at", "last_failed_code", "failed_count", "finished_at", "order_limit_send_count") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', E'f8419768-5baa-4901-b3ba-62808013ec45/s0/test3/\\240\\243\\223n \\334~b}\\2624)\\250m\\201\\202\\235\\276\\361\\3304\\323\\352\\311\\361\\353;\\326\\311', 9, 1.0, '2019-09-12 10:07:31.028103+00', '2019-09-12 10:07:32.028103+00', null, null, 0, '2019-09-12 10:07:33.028103+00', 0); 518INSERT INTO "graceful_exit_transfer_queue" ("node_id", "path", "piece_num", "durability_ratio", "queued_at", "requested_at", "last_failed_at", "last_failed_code", "failed_count", "finished_at", "order_limit_send_count") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', E'f8419768-5baa-4901-b3ba-62808013ec45/s0/test3/\\240\\243\\223n \\334~b}\\2624)\\250m\\201\\202\\235\\276\\361\\3304\\323\\352\\311\\361\\353;\\326\\312', 9, 1.0, '2019-09-12 10:07:31.028103+00', '2019-09-12 10:07:32.028103+00', null, null, 0, '2019-09-12 10:07:33.028103+00', 0); 519 520INSERT INTO "stripecoinpayments_invoice_project_records"("id", "project_id", "storage", "egress", "objects", "period_start", "period_end", "state", "created_at") VALUES (E'\\022\\217/\\014\\376!K\\023\\276\\031\\311}m\\236\\205\\300'::bytea, E'\\021\\217/\\014\\376!K\\023\\276\\031\\311}m\\236\\205\\300'::bytea, 0, 0, 0, '2019-06-01 08:28:24.267934+00', '2019-06-01 08:28:24.267934+00', 0, '2019-06-01 08:28:24.267934+00'); 521 522INSERT INTO "graceful_exit_transfer_queue" ("node_id", "path", "piece_num", "root_piece_id", "durability_ratio", "queued_at", "requested_at", "last_failed_at", "last_failed_code", "failed_count", "finished_at", "order_limit_send_count") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\016', E'f8419768-5baa-4901-b3ba-62808013ec45/s0/test3/\\240\\243\\223n \\334~b}\\2624)\\250m\\201\\202\\235\\276\\361\\3304\\323\\352\\311\\361\\353;\\326\\311', 10, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, 1.0, '2019-09-12 10:07:31.028103+00', '2019-09-12 10:07:32.028103+00', null, null, 0, '2019-09-12 10:07:33.028103+00', 0); 523 524INSERT INTO "stripecoinpayments_tx_conversion_rates" ("tx_id", "rate", "created_at") VALUES ('tx_id', E'\\363\\311\\033w\\222\\303Ci,'::bytea, '2019-06-01 08:28:24.267934+00'); 525 526INSERT INTO "coinpayments_transactions" ("id", "user_id", "address", "amount", "received", "status", "key", "timeout", "created_at") VALUES ('tx_id', E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, 'address', E'\\363\\311\\033w'::bytea, E'\\363\\311\\033w'::bytea, 1, 'key', 60, '2019-06-01 08:28:24.267934+00'); 527 528INSERT INTO "storagenode_bandwidth_rollups" ("storagenode_id", "interval_start", "interval_seconds", "action", "settled") VALUES (E'\\006\\223\\250R\\221\\005\\365\\377v>0\\266\\365\\216\\255?\\347\\244\\371?2\\264\\262\\230\\007<\\001\\262\\263\\237\\247n', '2020-01-11 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 3600, 1, 2024); 529 530INSERT INTO "coupons" ("id", "user_id", "amount", "description", "type", "status", "duration", "created_at") VALUES (E'\\362\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, 50, 'description', 0, 0, 2, '2019-06-01 08:28:24.267934+00'); 531INSERT INTO "coupon_usages" ("coupon_id", "amount", "status", "period") VALUES (E'\\362\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea, 22, 0, '2019-06-01 09:28:24.267934+00'); 532 533INSERT INTO "stripecoinpayments_apply_balance_intents" ("tx_id", "state", "created_at") VALUES ('tx_id', 0, '2019-06-01 08:28:24.267934+00'); 534 535INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "max_buckets", "rate_limit", "partner_id", "owner_id", "created_at") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\347'::bytea, 'projName1', 'Test project 1', 5e11, 5e11, NULL, 2000000, NULL, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2020-01-15 08:28:24.636949+00'); 536 537INSERT INTO "injuredsegments" ("path", "data", "segment_health", "updated_at") VALUES ('0', '\x0a0130120100', 1.0, '2020-09-01 00:00:00.000000+00'); 538INSERT INTO "injuredsegments" ("path", "data", "segment_health", "updated_at") VALUES ('here''s/a/great/path', '\x0a136865726527732f612f67726561742f70617468120a0102030405060708090a', 1.0, '2020-09-01 00:00:00.000000+00'); 539INSERT INTO "injuredsegments" ("path", "data", "segment_health", "updated_at") VALUES ('yet/another/cool/path', '\x0a157965742f616e6f746865722f636f6f6c2f70617468120a0102030405060708090a', 1.0, '2020-09-01 00:00:00.000000+00'); 540INSERT INTO "injuredsegments" ("path", "data", "segment_health", "updated_at") VALUES ('/this/is/a/new/path', '\x0a23736f2f6d616e792f69636f6e69632f70617468732f746f2f63686f6f73652f66726f6d120a0102030405060708090a', 1.0, '2020-09-01 00:00:00.000000+00'); 541INSERT INTO "injuredsegments" ("path", "data", "segment_health", "updated_at") VALUES ('/some/path/1/23/4', '\x0a23736f2f6d618e792f69636f6e69632f70617468732f746f2f63686f6f73652f66726f6d120a0102030405060708090a', 0.2, '2020-09-01 00:00:00.000000+00'); 542 543INSERT INTO "project_bandwidth_rollups"("project_id", "interval_month", egress_allocated) VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\347'::bytea, '2020-04-01', 10000); 544 545INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "max_buckets","rate_limit", "partner_id", "owner_id", "created_at") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\345'::bytea, 'egress101', 'High Bandwidth Project', 5e11, 5e11, NULL, 2000000, NULL, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2020-05-15 08:46:24.000000+00'); 546 547INSERT INTO "storagenode_paystubs"("period", "node_id", "created_at", "codes", "usage_at_rest", "usage_get", "usage_put", "usage_get_repair", "usage_put_repair", "usage_get_audit", "comp_at_rest", "comp_get", "comp_put", "comp_get_repair", "comp_put_repair", "comp_get_audit", "surge_percent", "held", "owed", "disposed", "paid", "distributed") VALUES ('2020-01', '\xf2a3b4c4dfdf7221310382fd5db5aa73e1d227d6df09734ec4e5305000000000', '2020-04-07T20:14:21.479141Z', '', 1327959864508416, 294054066688, 159031363328, 226751, 0, 836608, 2861984, 5881081, 0, 226751, 0, 8, 300, 0, 26909472, 0, 26909472, 0); 548INSERT INTO "nodes"("id", "address", "last_net", "protocol", "type", "email", "wallet", "free_disk", "piece_count", "major", "minor", "patch", "hash", "timestamp", "release","latency_90", "audit_success_count", "total_audit_count", "uptime_success_count", "total_uptime_count", "created_at", "updated_at", "last_contact_success", "last_contact_failure", "contained", "disqualified", "suspended", "audit_reputation_alpha", "audit_reputation_beta", "unknown_audit_reputation_alpha", "unknown_audit_reputation_beta", "exit_success", "unknown_audit_suspended", "offline_suspended", "under_review") VALUES (E'\\153\\313\\233\\074\\327\\255\\136\\070\\346\\001', '127.0.0.1:55516', '', 0, 4, '', '', -1, 0, 0, 1, 0, '', 'epoch', false, 0, 0, 5, 0, 5, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00', 'epoch', 'epoch', false, NULL, NULL, 50, 0, 1, 0, false, '2019-02-14 08:07:31.108963+00', '2019-02-14 08:07:31.108963+00', '2019-02-14 08:07:31.108963+00'); 549 550INSERT INTO "audit_histories" ("node_id", "history") VALUES (E'\\153\\313\\233\\074\\327\\177\\136\\070\\346\\001', '\x0a23736f2f6d616e792f69636f6e69632f70617468732f746f2f63686f6f73652f66726f6d120a0102030405060708090a'); 551 552INSERT INTO "node_api_versions"("id", "api_version", "created_at", "updated_at") VALUES (E'\\153\\313\\233\\074\\327\\177\\136\\070\\346\\001', 1, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00'); 553INSERT INTO "node_api_versions"("id", "api_version", "created_at", "updated_at") VALUES (E'\\006\\223\\250R\\221\\005\\365\\377v>0\\266\\365\\216\\255?\\347\\244\\371?2\\264\\262\\230\\007<\\001\\262\\263\\237\\247n', 2, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00'); 554INSERT INTO "node_api_versions"("id", "api_version", "created_at", "updated_at") VALUES (E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014', 3, '2019-02-14 08:07:31.028103+00', '2019-02-14 08:07:31.108963+00'); 555 556INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "rate_limit", "partner_id", "owner_id", "created_at", "max_buckets") VALUES (E'300\\273|\\342N\\347\\347\\363\\342\\363\\371>+F\\256\\263'::bytea, 'egress102', 'High Bandwidth Project 2', 5e11, 5e11, 2000000, NULL, E'265\\343U\\303\\312\\312\\363\\311\\033w\\222\\303Ci",'::bytea, '2020-05-15 08:46:24.000000+00', 1000); 557INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "rate_limit", "partner_id", "owner_id", "created_at", "max_buckets") VALUES (E'300\\273|\\342N\\347\\347\\363\\342\\363\\371>+F\\255\\244'::bytea, 'egress103', 'High Bandwidth Project 3', 5e11, 5e11, 2000000, NULL, E'265\\343U\\303\\312\\312\\363\\311\\033w\\222\\303Ci",'::bytea, '2020-05-15 08:46:24.000000+00', 1000); 558 559INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "rate_limit", "partner_id", "owner_id", "created_at", "max_buckets") VALUES (E'300\\273|\\342N\\347\\347\\363\\342\\363\\371>+F\\253\\231'::bytea, 'Limit Test 1', 'This project is above the default', 50000000001, 50000000001, 2000000, NULL, E'265\\343U\\303\\312\\312\\363\\311\\033w\\222\\303Ci",'::bytea, '2020-10-14 10:10:10.000000+00', 101); 560INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "rate_limit", "partner_id", "owner_id", "created_at", "max_buckets") VALUES (E'300\\273|\\342N\\347\\347\\363\\342\\363\\371>+F\\252\\230'::bytea, 'Limit Test 2', 'This project is below the default', 5e11, 5e11, 2000000, NULL, E'265\\343U\\303\\312\\312\\363\\311\\033w\\222\\303Ci",'::bytea, '2020-10-14 10:10:11.000000+00', NULL); 561 562INSERT INTO "storagenode_bandwidth_rollups_phase2" ("storagenode_id", "interval_start", "interval_seconds", "action", "allocated", "settled") VALUES (E'\\006\\223\\250R\\221\\005\\365\\377v>0\\266\\365\\216\\255?\\347\\244\\371?2\\264\\262\\230\\007<\\001\\262\\263\\237\\247n', '2019-03-06 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 3600, 1, 1024, 2024); 563 564INSERT INTO "users"("id", "full_name", "short_name", "email", "normalized_email", "password_hash", "status", "partner_id", "created_at", "position", "company_name", "working_on", "company_size", "is_professional", "project_limit") VALUES (E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\205\\311",'::bytea, 'Thierry', 'Berg', '2email2@mail.test', '2EMAIL2@MAIL.TEST', E'some_readable_hash'::bytea, 2, NULL, '2020-05-16 10:28:24.614594+00', 'engineer', 'storj', 'data storage', 55, true, 10); 565 566INSERT INTO "storagenode_bandwidth_rollup_archives" ("storagenode_id", "interval_start", "interval_seconds", "action", "allocated", "settled") VALUES (E'\\006\\223\\250R\\221\\005\\365\\377v>0\\266\\365\\216\\255?\\347\\244\\371?2\\264\\262\\230\\007<\\001\\262\\263\\237\\247n', '2019-03-06 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 3600, 1, 1024, 2024); 567INSERT INTO "bucket_bandwidth_rollup_archives" ("bucket_name", "project_id", "interval_start", "interval_seconds", "action", "inline", "allocated", "settled") VALUES (E'testbucket'::bytea, E'\\170\\160\\157\\370\\274\\366\\113\\364\\272\\235\\301\\243\\321\\102\\321\\136'::bytea,'2019-03-06 08:00:00.000000' AT TIME ZONE current_setting('TIMEZONE'), 3600, 1, 1024, 2024, 3024); 568 569INSERT INTO "storagenode_paystubs"("period", "node_id", "created_at", "codes", "usage_at_rest", "usage_get", "usage_put", "usage_get_repair", "usage_put_repair", "usage_get_audit", "comp_at_rest", "comp_get", "comp_put", "comp_get_repair", "comp_put_repair", "comp_get_audit", "surge_percent", "held", "owed", "disposed", "paid", "distributed") VALUES ('2020-12', '\x1111111111111111111111111111111111111111111111111111111111111111', '2020-04-07T20:14:21.479141Z', '', 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 117); 570INSERT INTO "storagenode_payments"("id", "created_at", "period", "node_id", "amount") VALUES (1, '2020-04-07T20:14:21.479141Z', '2020-12', '\x1111111111111111111111111111111111111111111111111111111111111111', 117); 571 572INSERT INTO "users"("id", "full_name", "short_name", "email", "normalized_email", "password_hash", "status", "partner_id", "created_at", "position", "company_name", "working_on", "company_size", "is_professional", "employee_count", "project_limit") VALUES (E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\205\\312",'::bytea, 'Campbell', 'Wright', '4email4@mail.test', '4EMAIL4@MAIL.TEST', E'some_readable_hash'::bytea, 2, NULL, '2020-07-17 10:28:24.614594+00', 'engineer', 'storj', 'data storage', 82, true, '1-50', 10); 573 574INSERT INTO "coupon_codes" ("id", "name", "amount", "description", "type", "duration", "created_at") VALUES (E'\\362\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014'::bytea, 'STORJ50', 50, '$50 for your first 5 months', 0, 2, '2019-06-01 08:28:24.267934+00'); 575 576-- NEW DATA -- 577