-
Notifications
You must be signed in to change notification settings - Fork 0
/
bluebox_restore.list
138 lines (138 loc) · 8.24 KB
/
bluebox_restore.list
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
;
; Archive created at 2024-09-03 10:06:44 EDT
; dbname: bluebox_dev
; TOC Entries: 128
; Compression: gzip
; Dump Version: 1.15-0
; Format: CUSTOM
; Integer: 4 bytes
; Offset: 8 bytes
; Dumped from database version: 16.0 (Debian 16.0-1.pgdg110+1)
; Dumped by pg_dump version: 16.4 (Ubuntu 16.4-1.pgdg20.04+1)
;
;
; Selected TOC Entries:
;
9; 2615 1125476 SCHEMA - bluebox postgres
11; 2615 1171737 SCHEMA - topology postgres
4544; 0 0 COMMENT - SCHEMA topology postgres
2; 3079 1125478 EXTENSION - pg_stat_statements
4545; 0 0 COMMENT - EXTENSION pg_stat_statements
3; 3079 1125509 EXTENSION - pg_trgm
4546; 0 0 COMMENT - EXTENSION pg_trgm
4; 3079 1125590 EXTENSION - postgis
4547; 0 0 COMMENT - EXTENSION postgis
1738; 1247 1126671 TYPE public mpaa_rating postgres
1741; 1247 1126684 DOMAIN public year postgres
577; 1255 1126686 PROCEDURE bluebox add_new_inventory() postgres
978; 1255 1126687 PROCEDURE bluebox complete_recent_rentals(interval, integer) postgres
601; 1255 1126688 PROCEDURE bluebox generate_individual_rental(integer) postgres
270; 1255 1126689 PROCEDURE bluebox generate_new_rentals(interval, real, real, integer) postgres
301; 1255 1126691 PROCEDURE bluebox generate_rental_history(timestamp with time zone, timestamp with time zone, numeric, double precision) postgres
288; 1255 1126693 PROCEDURE bluebox insert_payments(date) postgres
903; 1255 1126694 PROCEDURE bluebox insert_single_payment(integer) postgres
810; 1255 1126695 PROCEDURE bluebox move_cast_and_crew() postgres
461; 1255 1126696 PROCEDURE bluebox update_movie_rating() postgres
562; 1255 1126697 FUNCTION public _group_concat(text, text) postgres
584; 1255 1126698 FUNCTION public film_in_stock(integer, integer) postgres
638; 1255 1126699 FUNCTION public film_not_in_stock(integer, integer) postgres
1028; 1255 1126700 FUNCTION public get_customer_balance(integer, timestamp with time zone) postgres
879; 1255 1126701 FUNCTION public get_inventory() postgres
591; 1255 1126702 FUNCTION public inventory_held_by_customer(integer) postgres
701; 1255 1126703 FUNCTION public inventory_in_stock(integer) postgres
563; 1255 1126704 FUNCTION public last_day(timestamp with time zone) postgres
322; 1255 1126705 FUNCTION public last_updated() postgres
702; 1255 1126706 FUNCTION public random_between(numeric, numeric, integer) postgres
1834; 1255 1126711 AGGREGATE public group_concat(text) postgres
228; 1259 1126712 TABLE bluebox customer postgres
229; 1259 1126720 TABLE bluebox film postgres
230; 1259 1126726 TABLE bluebox film_cast postgres
231; 1259 1126731 TABLE bluebox film_crew postgres
232; 1259 1126736 TABLE bluebox film_genre postgres
233; 1259 1126741 TABLE bluebox film_production_company postgres
234; 1259 1126744 SEQUENCE bluebox genre_genre_id_seq postgres
235; 1259 1126745 TABLE bluebox holiday postgres
236; 1259 1126750 SEQUENCE bluebox inventory_inventory_id_seq postgres
237; 1259 1126751 TABLE bluebox inventory postgres
238; 1259 1126756 SEQUENCE bluebox language_language_id_seq postgres
239; 1259 1126757 TABLE bluebox language postgres
240; 1259 1126762 SEQUENCE bluebox payment_payment_id_seq postgres
241; 1259 1126763 TABLE bluebox payment postgres
242; 1259 1126767 TABLE bluebox person postgres
243; 1259 1126772 SEQUENCE bluebox person_person_id_seq postgres
244; 1259 1126773 TABLE bluebox production_company postgres
245; 1259 1126778 TABLE bluebox release_type postgres
246; 1259 1126783 TABLE bluebox rental postgres
247; 1259 1126789 SEQUENCE bluebox rental_rental_id_seq1 postgres
248; 1259 1126790 SEQUENCE bluebox staff_staff_id_seq postgres
249; 1259 1126791 TABLE bluebox staff postgres
250; 1259 1126799 TABLE bluebox store postgres
251; 1259 1126804 TABLE bluebox zip_code_info postgres
4513; 0 1126712 TABLE DATA bluebox customer postgres
4514; 0 1126720 TABLE DATA bluebox film postgres
4515; 0 1126726 TABLE DATA bluebox film_cast postgres
4516; 0 1126731 TABLE DATA bluebox film_crew postgres
4517; 0 1126736 TABLE DATA bluebox film_genre postgres
4518; 0 1126741 TABLE DATA bluebox film_production_company postgres
4520; 0 1126745 TABLE DATA bluebox holiday postgres
4522; 0 1126751 TABLE DATA bluebox inventory postgres
4524; 0 1126757 TABLE DATA bluebox language postgres
;4526; 0 1126763 TABLE DATA bluebox payment postgres
4527; 0 1126767 TABLE DATA bluebox person postgres
4529; 0 1126773 TABLE DATA bluebox production_company postgres
4530; 0 1126778 TABLE DATA bluebox release_type postgres
;4531; 0 1126783 TABLE DATA bluebox rental postgres
4534; 0 1126791 TABLE DATA bluebox staff postgres
4535; 0 1126799 TABLE DATA bluebox store postgres
4536; 0 1126804 TABLE DATA bluebox zip_code_info postgres
4289; 0 1125908 TABLE DATA public spatial_ref_sys postgres
4548; 0 0 SEQUENCE SET bluebox genre_genre_id_seq postgres
4549; 0 0 SEQUENCE SET bluebox inventory_inventory_id_seq postgres
4550; 0 0 SEQUENCE SET bluebox language_language_id_seq postgres
4551; 0 0 SEQUENCE SET bluebox payment_payment_id_seq postgres
4552; 0 0 SEQUENCE SET bluebox person_person_id_seq postgres
4553; 0 0 SEQUENCE SET bluebox rental_rental_id_seq1 postgres
4554; 0 0 SEQUENCE SET bluebox staff_staff_id_seq postgres
4307; 2606 1131171 CONSTRAINT bluebox customer customer_pkey postgres
4314; 2606 1131173 CONSTRAINT bluebox film_cast film_cast_pk postgres
4317; 2606 1131175 CONSTRAINT bluebox film_crew film_crew_pk postgres
4311; 2606 1131177 CONSTRAINT bluebox film film_pkey postgres
4321; 2606 1131179 CONSTRAINT bluebox film_production_company film_production_company_pk postgres
4319; 2606 1131181 CONSTRAINT bluebox film_genre genre_pkey postgres
4324; 2606 1131183 CONSTRAINT bluebox inventory inventory_pk postgres
4327; 2606 1131185 CONSTRAINT bluebox payment payment_bak_pkey postgres
4330; 2606 1131201 CONSTRAINT bluebox person person_pkey postgres
4332; 2606 1131203 CONSTRAINT bluebox production_company production_company_pkey postgres
4334; 2606 1131205 CONSTRAINT bluebox release_type release_type_pkey postgres
4339; 2606 1131207 CONSTRAINT bluebox rental rental_pkey postgres
4344; 2606 1131217 CONSTRAINT bluebox store store_pkey postgres
4347; 2606 1131219 CONSTRAINT bluebox zip_code_info zip_code_info_pk postgres
4308; 1259 1131232 INDEX bluebox film_film_genre_ids_idx postgres
4309; 1259 1131233 INDEX bluebox film_fulltext_idx postgres
4315; 1259 1131234 INDEX bluebox film_person_id_film_id_idx postgres
4335; 1259 1131235 INDEX bluebox idx_rental_rental_date_brin postgres
4312; 1259 1131236 INDEX bluebox idx_title_trgm postgres
4322; 1259 1131237 INDEX bluebox inventory_film_id_idx postgres
4325; 1259 1131238 INDEX bluebox inventory_store_id_idx postgres
4328; 1259 1131239 INDEX bluebox payment_rental_id_amount_idx postgres
4336; 1259 1131240 INDEX bluebox rental_customer_id_idx postgres
4337; 1259 1131241 INDEX bluebox rental_inventory_id_idx postgres
4340; 1259 1131242 INDEX bluebox rental_rental_period_idx postgres
4341; 1259 1173112 INDEX bluebox rental_rental_period_upper_null postgres
4342; 1259 1171731 INDEX bluebox rental_store_id_idx postgres
4345; 1259 1131254 INDEX bluebox us_postal_code_geog_gix postgres
4348; 2606 1131257 FK CONSTRAINT bluebox customer customer_store_id_fkey postgres
4349; 2606 1131262 FK CONSTRAINT bluebox customer customer_zip_code_fkey postgres
4350; 2606 1131267 FK CONSTRAINT bluebox film_cast film_cast_film_id_fkey postgres
4351; 2606 1131272 FK CONSTRAINT bluebox film_cast film_cast_person_id_fkey postgres
4352; 2606 1131277 FK CONSTRAINT bluebox film_crew film_crew_film_id_fkey postgres
4353; 2606 1131282 FK CONSTRAINT bluebox film_crew film_crew_person_id_fkey postgres
4354; 2606 1131287 FK CONSTRAINT bluebox film_production_company film_production_company_film_id_fkey postgres
4355; 2606 1131292 FK CONSTRAINT bluebox film_production_company film_production_company_production_company_id_fkey postgres
4356; 2606 1131297 FK CONSTRAINT bluebox inventory inventory_film_id_fkey postgres
4357; 2606 1131302 FK CONSTRAINT bluebox inventory inventory_store_id_fkkey postgres
4358; 2606 1131307 FK CONSTRAINT bluebox payment payment_customer_id_fkey postgres
4359; 2606 1131312 FK CONSTRAINT bluebox payment payment_rental_id_fkey postgres
4360; 2606 1131317 FK CONSTRAINT bluebox rental rental_customer_id_fkey postgres
4361; 2606 1131322 FK CONSTRAINT bluebox rental rental_inventory_id_fkey postgres
4362; 2606 1131327 FK CONSTRAINT bluebox store store_zip_code_fkey postgres