1-- AUTOGENERATED BY storj.io/dbx 2-- DO NOT EDIT 3CREATE TABLE accounting_rollups ( 4 id bigserial NOT NULL, 5 node_id bytea NOT NULL, 6 start_time timestamp with time zone NOT NULL, 7 put_total bigint NOT NULL, 8 get_total bigint NOT NULL, 9 get_audit_total bigint NOT NULL, 10 get_repair_total bigint NOT NULL, 11 put_repair_total bigint NOT NULL, 12 at_rest_total double precision NOT NULL, 13 PRIMARY KEY ( id ) 14); 15CREATE TABLE accounting_timestamps ( 16 name text NOT NULL, 17 value timestamp with time zone NOT NULL, 18 PRIMARY KEY ( name ) 19); 20CREATE TABLE audit_histories ( 21 node_id bytea NOT NULL, 22 history bytea NOT NULL, 23 PRIMARY KEY ( node_id ) 24); 25CREATE TABLE bucket_bandwidth_rollups ( 26 bucket_name bytea NOT NULL, 27 project_id bytea NOT NULL, 28 interval_start timestamp with time zone NOT NULL, 29 interval_seconds integer NOT NULL, 30 action integer NOT NULL, 31 inline bigint NOT NULL, 32 allocated bigint NOT NULL, 33 settled bigint NOT NULL, 34 PRIMARY KEY ( bucket_name, project_id, interval_start, action ) 35); 36CREATE TABLE bucket_storage_tallies ( 37 bucket_name bytea NOT NULL, 38 project_id bytea NOT NULL, 39 interval_start timestamp with time zone NOT NULL, 40 inline bigint NOT NULL, 41 remote bigint NOT NULL, 42 remote_segments_count integer NOT NULL, 43 inline_segments_count integer NOT NULL, 44 object_count integer NOT NULL, 45 metadata_size bigint NOT NULL, 46 PRIMARY KEY ( bucket_name, project_id, interval_start ) 47); 48CREATE TABLE coinpayments_transactions ( 49 id text NOT NULL, 50 user_id bytea NOT NULL, 51 address text NOT NULL, 52 amount bytea NOT NULL, 53 received bytea NOT NULL, 54 status integer NOT NULL, 55 key text NOT NULL, 56 timeout integer NOT NULL, 57 created_at timestamp with time zone NOT NULL, 58 PRIMARY KEY ( id ) 59); 60CREATE TABLE consumed_serials ( 61 storage_node_id bytea NOT NULL, 62 serial_number bytea NOT NULL, 63 expires_at timestamp with time zone NOT NULL, 64 PRIMARY KEY ( storage_node_id, serial_number ) 65); 66CREATE TABLE coupons ( 67 id bytea NOT NULL, 68 user_id bytea NOT NULL, 69 amount bigint NOT NULL, 70 description text NOT NULL, 71 type integer NOT NULL, 72 status integer NOT NULL, 73 duration bigint NOT NULL, 74 created_at timestamp with time zone NOT NULL, 75 PRIMARY KEY ( id ) 76); 77CREATE TABLE coupon_usages ( 78 coupon_id bytea NOT NULL, 79 amount bigint NOT NULL, 80 status integer NOT NULL, 81 period timestamp with time zone NOT NULL, 82 PRIMARY KEY ( coupon_id, period ) 83); 84CREATE TABLE graceful_exit_progress ( 85 node_id bytea NOT NULL, 86 bytes_transferred bigint NOT NULL, 87 pieces_transferred bigint NOT NULL DEFAULT 0, 88 pieces_failed bigint NOT NULL DEFAULT 0, 89 updated_at timestamp with time zone NOT NULL, 90 PRIMARY KEY ( node_id ) 91); 92CREATE TABLE graceful_exit_transfer_queue ( 93 node_id bytea NOT NULL, 94 path bytea NOT NULL, 95 piece_num integer NOT NULL, 96 root_piece_id bytea, 97 durability_ratio double precision NOT NULL, 98 queued_at timestamp with time zone NOT NULL, 99 requested_at timestamp with time zone, 100 last_failed_at timestamp with time zone, 101 last_failed_code integer, 102 failed_count integer, 103 finished_at timestamp with time zone, 104 order_limit_send_count integer NOT NULL DEFAULT 0, 105 PRIMARY KEY ( node_id, path, piece_num ) 106); 107CREATE TABLE injuredsegments ( 108 path bytea NOT NULL, 109 data bytea NOT NULL, 110 attempted timestamp with time zone, 111 num_healthy_pieces integer NOT NULL DEFAULT 52, 112 PRIMARY KEY ( path ) 113); 114CREATE TABLE irreparabledbs ( 115 segmentpath bytea NOT NULL, 116 segmentdetail bytea NOT NULL, 117 pieces_lost_count bigint NOT NULL, 118 seg_damaged_unix_sec bigint NOT NULL, 119 repair_attempt_count bigint NOT NULL, 120 PRIMARY KEY ( segmentpath ) 121); 122CREATE TABLE nodes ( 123 id bytea NOT NULL, 124 address text NOT NULL DEFAULT '', 125 last_net text NOT NULL, 126 last_ip_port text, 127 protocol integer NOT NULL DEFAULT 0, 128 type integer NOT NULL DEFAULT 0, 129 email text NOT NULL, 130 wallet text NOT NULL, 131 free_disk bigint NOT NULL DEFAULT -1, 132 piece_count bigint NOT NULL DEFAULT 0, 133 major bigint NOT NULL DEFAULT 0, 134 minor bigint NOT NULL DEFAULT 0, 135 patch bigint NOT NULL DEFAULT 0, 136 hash text NOT NULL DEFAULT '', 137 timestamp timestamp with time zone NOT NULL DEFAULT '0001-01-01 00:00:00+00', 138 release boolean NOT NULL DEFAULT false, 139 latency_90 bigint NOT NULL DEFAULT 0, 140 audit_success_count bigint NOT NULL DEFAULT 0, 141 total_audit_count bigint NOT NULL DEFAULT 0, 142 vetted_at timestamp with time zone, 143 uptime_success_count bigint NOT NULL, 144 total_uptime_count bigint NOT NULL, 145 created_at timestamp with time zone NOT NULL DEFAULT current_timestamp, 146 updated_at timestamp with time zone NOT NULL DEFAULT current_timestamp, 147 last_contact_success timestamp with time zone NOT NULL DEFAULT 'epoch', 148 last_contact_failure timestamp with time zone NOT NULL DEFAULT 'epoch', 149 contained boolean NOT NULL DEFAULT false, 150 disqualified timestamp with time zone, 151 suspended timestamp with time zone, 152 unknown_audit_suspended timestamp with time zone, 153 offline_suspended timestamp with time zone, 154 under_review timestamp with time zone, 155 audit_reputation_alpha double precision NOT NULL DEFAULT 1, 156 audit_reputation_beta double precision NOT NULL DEFAULT 0, 157 unknown_audit_reputation_alpha double precision NOT NULL DEFAULT 1, 158 unknown_audit_reputation_beta double precision NOT NULL DEFAULT 0, 159 uptime_reputation_alpha double precision NOT NULL DEFAULT 1, 160 uptime_reputation_beta double precision NOT NULL DEFAULT 0, 161 exit_initiated_at timestamp with time zone, 162 exit_loop_completed_at timestamp with time zone, 163 exit_finished_at timestamp with time zone, 164 exit_success boolean NOT NULL DEFAULT false, 165 PRIMARY KEY ( id ) 166); 167CREATE TABLE node_api_versions ( 168 id bytea NOT NULL, 169 api_version integer NOT NULL, 170 created_at timestamp with time zone NOT NULL, 171 updated_at timestamp with time zone NOT NULL, 172 PRIMARY KEY ( id ) 173); 174CREATE TABLE nodes_offline_times ( 175 node_id bytea NOT NULL, 176 tracked_at timestamp with time zone NOT NULL, 177 seconds integer NOT NULL, 178 PRIMARY KEY ( node_id, tracked_at ) 179); 180CREATE TABLE offers ( 181 id serial NOT NULL, 182 name text NOT NULL, 183 description text NOT NULL, 184 award_credit_in_cents integer NOT NULL DEFAULT 0, 185 invitee_credit_in_cents integer NOT NULL DEFAULT 0, 186 award_credit_duration_days integer, 187 invitee_credit_duration_days integer, 188 redeemable_cap integer, 189 expires_at timestamp with time zone NOT NULL, 190 created_at timestamp with time zone NOT NULL, 191 status integer NOT NULL, 192 type integer NOT NULL, 193 PRIMARY KEY ( id ) 194); 195CREATE TABLE peer_identities ( 196 node_id bytea NOT NULL, 197 leaf_serial_number bytea NOT NULL, 198 chain bytea NOT NULL, 199 updated_at timestamp with time zone NOT NULL, 200 PRIMARY KEY ( node_id ) 201); 202CREATE TABLE pending_audits ( 203 node_id bytea NOT NULL, 204 piece_id bytea NOT NULL, 205 stripe_index bigint NOT NULL, 206 share_size bigint NOT NULL, 207 expected_share_hash bytea NOT NULL, 208 reverify_count bigint NOT NULL, 209 path bytea NOT NULL, 210 PRIMARY KEY ( node_id ) 211); 212CREATE TABLE pending_serial_queue ( 213 storage_node_id bytea NOT NULL, 214 bucket_id bytea NOT NULL, 215 serial_number bytea NOT NULL, 216 action integer NOT NULL, 217 settled bigint NOT NULL, 218 expires_at timestamp with time zone NOT NULL, 219 PRIMARY KEY ( storage_node_id, bucket_id, serial_number ) 220); 221CREATE TABLE projects ( 222 id bytea NOT NULL, 223 name text NOT NULL, 224 description text NOT NULL, 225 usage_limit bigint NOT NULL DEFAULT 0, 226 bandwidth_limit bigint NOT NULL DEFAULT 0, 227 rate_limit integer, 228 max_buckets integer NOT NULL DEFAULT 0, 229 partner_id bytea, 230 owner_id bytea NOT NULL, 231 created_at timestamp with time zone NOT NULL, 232 PRIMARY KEY ( id ) 233); 234CREATE TABLE project_bandwidth_rollups ( 235 project_id bytea NOT NULL, 236 interval_month date NOT NULL, 237 egress_allocated bigint NOT NULL, 238 PRIMARY KEY ( project_id, interval_month ) 239); 240CREATE TABLE registration_tokens ( 241 secret bytea NOT NULL, 242 owner_id bytea, 243 project_limit integer NOT NULL, 244 created_at timestamp with time zone NOT NULL, 245 PRIMARY KEY ( secret ), 246 UNIQUE ( owner_id ) 247); 248CREATE TABLE reported_serials ( 249 expires_at timestamp with time zone NOT NULL, 250 storage_node_id bytea NOT NULL, 251 bucket_id bytea NOT NULL, 252 action integer NOT NULL, 253 serial_number bytea NOT NULL, 254 settled bigint NOT NULL, 255 observed_at timestamp with time zone NOT NULL, 256 PRIMARY KEY ( expires_at, storage_node_id, bucket_id, action, serial_number ) 257); 258CREATE TABLE reset_password_tokens ( 259 secret bytea NOT NULL, 260 owner_id bytea NOT NULL, 261 created_at timestamp with time zone NOT NULL, 262 PRIMARY KEY ( secret ), 263 UNIQUE ( owner_id ) 264); 265CREATE TABLE revocations ( 266 revoked bytea NOT NULL, 267 api_key_id bytea NOT NULL, 268 PRIMARY KEY ( revoked ) 269); 270CREATE TABLE serial_numbers ( 271 id serial NOT NULL, 272 serial_number bytea NOT NULL, 273 bucket_id bytea NOT NULL, 274 expires_at timestamp with time zone NOT NULL, 275 PRIMARY KEY ( id ) 276); 277CREATE TABLE storagenode_bandwidth_rollups ( 278 storagenode_id bytea NOT NULL, 279 interval_start timestamp with time zone NOT NULL, 280 interval_seconds integer NOT NULL, 281 action integer NOT NULL, 282 allocated bigint DEFAULT 0, 283 settled bigint NOT NULL, 284 PRIMARY KEY ( storagenode_id, interval_start, action ) 285); 286CREATE TABLE storagenode_payments ( 287 id bigserial NOT NULL, 288 created_at timestamp with time zone NOT NULL, 289 node_id bytea NOT NULL, 290 period text NOT NULL, 291 amount bigint NOT NULL, 292 receipt text, 293 notes text, 294 PRIMARY KEY ( id ) 295); 296CREATE TABLE storagenode_paystubs ( 297 period text NOT NULL, 298 node_id bytea NOT NULL, 299 created_at timestamp with time zone NOT NULL, 300 codes text NOT NULL, 301 usage_at_rest double precision NOT NULL, 302 usage_get bigint NOT NULL, 303 usage_put bigint NOT NULL, 304 usage_get_repair bigint NOT NULL, 305 usage_put_repair bigint NOT NULL, 306 usage_get_audit bigint NOT NULL, 307 comp_at_rest bigint NOT NULL, 308 comp_get bigint NOT NULL, 309 comp_put bigint NOT NULL, 310 comp_get_repair bigint NOT NULL, 311 comp_put_repair bigint NOT NULL, 312 comp_get_audit bigint NOT NULL, 313 surge_percent bigint NOT NULL, 314 held bigint NOT NULL, 315 owed bigint NOT NULL, 316 disposed bigint NOT NULL, 317 paid bigint NOT NULL, 318 PRIMARY KEY ( period, node_id ) 319); 320CREATE TABLE storagenode_storage_tallies ( 321 node_id bytea NOT NULL, 322 interval_end_time timestamp with time zone NOT NULL, 323 data_total double precision NOT NULL, 324 PRIMARY KEY ( interval_end_time, node_id ) 325); 326CREATE TABLE stripe_customers ( 327 user_id bytea NOT NULL, 328 customer_id text NOT NULL, 329 created_at timestamp with time zone NOT NULL, 330 PRIMARY KEY ( user_id ), 331 UNIQUE ( customer_id ) 332); 333CREATE TABLE stripecoinpayments_invoice_project_records ( 334 id bytea NOT NULL, 335 project_id bytea NOT NULL, 336 storage double precision NOT NULL, 337 egress bigint NOT NULL, 338 objects bigint NOT NULL, 339 period_start timestamp with time zone NOT NULL, 340 period_end timestamp with time zone NOT NULL, 341 state integer NOT NULL, 342 created_at timestamp with time zone NOT NULL, 343 PRIMARY KEY ( id ), 344 UNIQUE ( project_id, period_start, period_end ) 345); 346CREATE TABLE stripecoinpayments_tx_conversion_rates ( 347 tx_id text NOT NULL, 348 rate bytea NOT NULL, 349 created_at timestamp with time zone NOT NULL, 350 PRIMARY KEY ( tx_id ) 351); 352CREATE TABLE users ( 353 id bytea NOT NULL, 354 email text NOT NULL, 355 normalized_email text NOT NULL, 356 full_name text NOT NULL, 357 short_name text, 358 password_hash bytea NOT NULL, 359 status integer NOT NULL, 360 partner_id bytea, 361 created_at timestamp with time zone NOT NULL, 362 project_limit integer NOT NULL DEFAULT 0, 363 PRIMARY KEY ( id ) 364); 365CREATE TABLE value_attributions ( 366 project_id bytea NOT NULL, 367 bucket_name bytea NOT NULL, 368 partner_id bytea NOT NULL, 369 last_updated timestamp with time zone NOT NULL, 370 PRIMARY KEY ( project_id, bucket_name ) 371); 372CREATE TABLE api_keys ( 373 id bytea NOT NULL, 374 project_id bytea NOT NULL REFERENCES projects( id ) ON DELETE CASCADE, 375 head bytea NOT NULL, 376 name text NOT NULL, 377 secret bytea NOT NULL, 378 partner_id bytea, 379 created_at timestamp with time zone NOT NULL, 380 PRIMARY KEY ( id ), 381 UNIQUE ( head ), 382 UNIQUE ( name, project_id ) 383); 384CREATE TABLE bucket_metainfos ( 385 id bytea NOT NULL, 386 project_id bytea NOT NULL REFERENCES projects( id ), 387 name bytea NOT NULL, 388 partner_id bytea, 389 path_cipher integer NOT NULL, 390 created_at timestamp with time zone NOT NULL, 391 default_segment_size integer NOT NULL, 392 default_encryption_cipher_suite integer NOT NULL, 393 default_encryption_block_size integer NOT NULL, 394 default_redundancy_algorithm integer NOT NULL, 395 default_redundancy_share_size integer NOT NULL, 396 default_redundancy_required_shares integer NOT NULL, 397 default_redundancy_repair_shares integer NOT NULL, 398 default_redundancy_optimal_shares integer NOT NULL, 399 default_redundancy_total_shares integer NOT NULL, 400 PRIMARY KEY ( id ), 401 UNIQUE ( name, project_id ), 402 UNIQUE ( project_id, name ) 403); 404CREATE TABLE project_invoice_stamps ( 405 project_id bytea NOT NULL REFERENCES projects( id ) ON DELETE CASCADE, 406 invoice_id bytea NOT NULL, 407 start_date timestamp with time zone NOT NULL, 408 end_date timestamp with time zone NOT NULL, 409 created_at timestamp with time zone NOT NULL, 410 PRIMARY KEY ( project_id, start_date, end_date ), 411 UNIQUE ( invoice_id ) 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 used_serials ( 426 serial_number_id integer NOT NULL REFERENCES serial_numbers( id ) ON DELETE CASCADE, 427 storage_node_id bytea NOT NULL, 428 PRIMARY KEY ( serial_number_id, storage_node_id ) 429); 430CREATE TABLE user_credits ( 431 id serial NOT NULL, 432 user_id bytea NOT NULL REFERENCES users( id ) ON DELETE CASCADE, 433 offer_id integer NOT NULL REFERENCES offers( id ), 434 referred_by bytea REFERENCES users( id ) ON DELETE SET NULL, 435 type text NOT NULL, 436 credits_earned_in_cents integer NOT NULL, 437 credits_used_in_cents integer NOT NULL, 438 expires_at timestamp with time zone NOT NULL, 439 created_at timestamp with time zone NOT NULL, 440 PRIMARY KEY ( id ), 441 UNIQUE ( id, offer_id ) 442); 443CREATE INDEX accounting_rollups_start_time_index ON accounting_rollups ( start_time ); 444CREATE INDEX bucket_bandwidth_rollups_project_id_action_interval_index ON bucket_bandwidth_rollups ( project_id, action, interval_start ); 445CREATE INDEX bucket_bandwidth_rollups_action_interval_project_id_index ON bucket_bandwidth_rollups ( action, interval_start, project_id ); 446CREATE INDEX consumed_serials_expires_at_index ON consumed_serials ( expires_at ); 447CREATE INDEX injuredsegments_attempted_index ON injuredsegments ( attempted ); 448CREATE INDEX injuredsegments_num_healthy_pieces_index ON injuredsegments ( num_healthy_pieces ); 449CREATE INDEX node_last_ip ON nodes ( last_net ); 450CREATE INDEX nodes_offline_times_node_id_index ON nodes_offline_times ( node_id ); 451CREATE UNIQUE INDEX serial_number_index ON serial_numbers ( serial_number ); 452CREATE INDEX serial_numbers_expires_at_index ON serial_numbers ( expires_at ); 453CREATE INDEX storagenode_payments_node_id_period_index ON storagenode_payments ( node_id, period ); 454CREATE INDEX storagenode_paystubs_node_id_index ON storagenode_paystubs ( node_id ); 455CREATE INDEX storagenode_storage_tallies_node_id_index ON storagenode_storage_tallies ( node_id ); 456CREATE UNIQUE INDEX credits_earned_user_id_offer_id ON user_credits ( id, offer_id ); 457 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 (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); 459INSERT 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); 460 461-- MAIN DATA -- 462 463INSERT INTO "accounting_rollups"("id", "node_id", "start_time", "put_total", "get_total", "get_audit_total", "get_repair_total", "put_repair_total", "at_rest_total") VALUES (1, 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', 1000, 2000, 3000, 4000, 0, 5000); 464 465INSERT INTO "accounting_timestamps" VALUES ('LastAtRestTally', '0001-01-01 00:00:00+00'); 466INSERT INTO "accounting_timestamps" VALUES ('LastRollup', '0001-01-01 00:00:00+00'); 467INSERT INTO "accounting_timestamps" VALUES ('LastBandwidthTally', '0001-01-01 00:00:00+00'); 468 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", "uptime_reputation_alpha", "uptime_reputation_beta", "exit_success") 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, 100, 5, false); 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", "uptime_reputation_alpha", "uptime_reputation_beta", "exit_success") 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, 100, 0, false); 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", "uptime_reputation_alpha", "uptime_reputation_beta", "exit_success") 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, 100, 0, false); 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", "uptime_reputation_alpha", "uptime_reputation_beta", "exit_success") 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, 100, 1, false); 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", "uptime_reputation_alpha", "uptime_reputation_beta", "exit_success", "vetted_at") 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, 300, 100, false, '2020-03-18 12:00:00.000000+00'); 474INSERT 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", "uptime_reputation_alpha", "uptime_reputation_beta", "exit_success") 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, 100, 5, false); 475INSERT 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", "uptime_reputation_alpha", "uptime_reputation_beta", "exit_success") 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, 100, 5, false); 476 477INSERT INTO "users"("id", "full_name", "short_name", "email", "normalized_email", "password_hash", "status", "partner_id", "created_at") 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'); 478INSERT INTO "projects"("id", "name", "description", "usage_limit", "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', 0, NULL, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2019-02-14 08:28:24.254934+00'); 479 480INSERT INTO "projects"("id", "name", "description", "usage_limit", "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', 0, NULL, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2019-02-14 08:28:24.636949+00'); 481INSERT 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'); 482INSERT 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'); 483 484INSERT INTO "irreparabledbs" ("segmentpath", "segmentdetail", "pieces_lost_count", "seg_damaged_unix_sec", "repair_attempt_count") VALUES ('\x49616d5365676d656e746b6579696e666f30', '\x49616d5365676d656e7464657461696c696e666f30', 10, 1550159554, 10); 485 486INSERT 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'); 487 488INSERT INTO "serial_numbers" ("id", "serial_number", "bucket_id", "expires_at") VALUES (1, E'0123456701234567'::bytea, E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014/testbucket'::bytea, '2019-03-06 08:28:24.677953+00'); 489INSERT INTO "used_serials" ("serial_number_id", "storage_node_id") VALUES (1, 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'); 490 491INSERT 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); 492INSERT 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); 493 494INSERT 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); 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'\\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); 496INSERT 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); 497INSERT 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); 498 499INSERT 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'); 500 501INSERT 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'); 502 503INSERT INTO "project_invoice_stamps" ("project_id", "invoice_id", "start_date", "end_date", "created_at") VALUES (E'\\022\\217/\\014\\376!K\\023\\276\\031\\311}m\\236\\205\\300'::bytea, E'\\363\\311\\033w\\222\\303,'::bytea, '2019-06-01 08:28:24.267934+00', '2019-06-29 08:28:24.267934+00', '2019-06-01 08:28:24.267934+00'); 504 505INSERT 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'); 506 507INSERT 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'); 508 509INSERT 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); 510 511INSERT 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'); 512 513INSERT 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'); 514 515INSERT 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'); 516INSERT 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); 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\\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); 518 519INSERT 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'); 520 521INSERT 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); 522INSERT 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); 523 524INSERT 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'); 525 526INSERT 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); 527 528INSERT 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'); 529 530INSERT 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'); 531 532INSERT INTO "nodes_offline_times" ("node_id", "tracked_at", "seconds") VALUES (E'\\153\\313\\233\\074\\327\\177\\136\\070\\346\\001'::bytea, '2019-06-01 09:28:24.267934+00', 3600); 533INSERT INTO "nodes_offline_times" ("node_id", "tracked_at", "seconds") VALUES (E'\\153\\313\\233\\074\\327\\177\\136\\070\\346\\001'::bytea, '2017-06-01 09:28:24.267934+00', 100); 534INSERT INTO "nodes_offline_times" ("node_id", "tracked_at", "seconds") 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'::bytea, '2019-06-01 09:28:24.267934+00', 3600); 535 536INSERT 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); 537 538INSERT 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'); 539INSERT 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'); 540 541INSERT INTO "reported_serials" ("expires_at", "storage_node_id", "bucket_id", "action", "serial_number", "settled", "observed_at") VALUES ('2020-01-11 08:00:00.000000+00', 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', E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014/testbucket'::bytea, 1, E'0123456701234567'::bytea, 100, '2020-01-11 08:00:00.000000+00'); 542 543INSERT INTO "stripecoinpayments_apply_balance_intents" ("tx_id", "state", "created_at") VALUES ('tx_id', 0, '2019-06-01 08:28:24.267934+00'); 544 545INSERT INTO "projects"("id", "name", "description", "usage_limit", "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', 0, 2000000, NULL, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2020-01-15 08:28:24.636949+00'); 546 547INSERT INTO "pending_serial_queue" ("storage_node_id", "bucket_id", "serial_number", "action", "settled", "expires_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', E'\\363\\342\\363\\371>+F\\256\\263\\300\\273|\\342N\\347\\014/testbucket'::bytea, E'5123456701234567'::bytea, 1, 100, '2020-01-11 08:00:00.000000+00'); 548 549INSERT INTO "consumed_serials" ("storage_node_id", "serial_number", "expires_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', E'1234567012345678'::bytea, '2020-01-12 08:00:00.000000+00'); 550 551INSERT INTO "injuredsegments" ("path", "data", "num_healthy_pieces") VALUES ('0', '\x0a0130120100', 52); 552INSERT INTO "injuredsegments" ("path", "data", "num_healthy_pieces") VALUES ('here''s/a/great/path', '\x0a136865726527732f612f67726561742f70617468120a0102030405060708090a', 30); 553INSERT INTO "injuredsegments" ("path", "data", "num_healthy_pieces") VALUES ('yet/another/cool/path', '\x0a157965742f616e6f746865722f636f6f6c2f70617468120a0102030405060708090a', 51); 554INSERT INTO "injuredsegments" ("path", "data", "num_healthy_pieces") VALUES ('/this/is/a/new/path', '\x0a23736f2f6d616e792f69636f6e69632f70617468732f746f2f63686f6f73652f66726f6d120a0102030405060708090a', 40); 555 556INSERT 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); 557 558INSERT INTO "projects"("id", "name", "description", "usage_limit", "bandwidth_limit", "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', 0, 0, 2000000, NULL, E'\\363\\311\\033w\\222\\303Ci\\265\\343U\\303\\312\\204",'::bytea, '2020-05-15 08:46:24.000000+00'); 559 560INSERT 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") 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); 561INSERT 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", "uptime_reputation_alpha", "uptime_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, 100, 5, 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'); 562 563INSERT INTO "audit_histories" ("node_id", "history") VALUES (E'\\153\\313\\233\\074\\327\\177\\136\\070\\346\\001', '\x0a23736f2f6d616e792f69636f6e69632f70617468732f746f2f63686f6f73652f66726f6d120a0102030405060708090a'); 564 565INSERT 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'); 566INSERT 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'); 567INSERT 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'); 568 569INSERT 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', 0, 0, 2000000, NULL, E'265\\343U\\303\\312\\312\\363\\311\\033w\\222\\303Ci",'::bytea, '2020-05-15 08:46:24.000000+00', 1000);