-
-
Save ruckus/951e417e7098fdf987d4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ pg_restore -l 2011110708_batch_api_production.dump.sql | |
; | |
; Archive created at Mon Nov 7 08:00:02 2011 | |
; dbname: batch_api_production | |
; TOC Entries: 217 | |
; Compression: -1 | |
; Dump Version: 1.12-0 | |
; Format: CUSTOM | |
; Integer: 4 bytes | |
; Offset: 8 bytes | |
; Dumped from database version: 9.1.1 | |
; Dumped by pg_dump version: 9.1.0 | |
; | |
; | |
; Selected TOC Entries: | |
; | |
2143; 1262 17065 DATABASE - batch_api_production batch | |
6; 2615 2200 SCHEMA - public postgres | |
2144; 0 0 COMMENT - SCHEMA public postgres | |
2145; 0 0 ACL - public postgres | |
210; 3079 11643 EXTENSION - plpgsql | |
2146; 0 0 COMMENT - EXTENSION plpgsql | |
222; 1255 19724 FUNCTION public crc32(text) batch | |
161; 1259 17066 TABLE public album_links batch | |
162; 1259 17069 SEQUENCE public album_links_id_seq batch | |
2147; 0 0 SEQUENCE OWNED BY public album_links_id_seq batch | |
2148; 0 0 SEQUENCE SET public album_links_id_seq batch | |
163; 1259 17071 TABLE public album_members batch | |
164; 1259 17074 SEQUENCE public album_members_id_seq batch | |
2149; 0 0 SEQUENCE OWNED BY public album_members_id_seq batch | |
2150; 0 0 SEQUENCE SET public album_members_id_seq batch | |
165; 1259 17076 TABLE public album_photo_comments batch | |
166; 1259 17082 SEQUENCE public album_photo_comments_id_seq batch | |
2151; 0 0 SEQUENCE OWNED BY public album_photo_comments_id_seq batch | |
2152; 0 0 SEQUENCE SET public album_photo_comments_id_seq batch | |
167; 1259 17084 TABLE public album_photo_likes batch | |
168; 1259 17087 SEQUENCE public album_photo_likes_id_seq batch | |
2153; 0 0 SEQUENCE OWNED BY public album_photo_likes_id_seq batch | |
2154; 0 0 SEQUENCE SET public album_photo_likes_id_seq batch | |
169; 1259 17089 TABLE public album_photos batch | |
170; 1259 17094 SEQUENCE public album_photos_id_seq batch | |
2155; 0 0 SEQUENCE OWNED BY public album_photos_id_seq batch | |
2156; 0 0 SEQUENCE SET public album_photos_id_seq batch | |
171; 1259 17096 TABLE public album_share_tweets batch | |
172; 1259 17099 SEQUENCE public album_share_tweets_id_seq batch | |
2157; 0 0 SEQUENCE OWNED BY public album_share_tweets_id_seq batch | |
2158; 0 0 SEQUENCE SET public album_share_tweets_id_seq batch | |
173; 1259 17101 TABLE public albums batch | |
174; 1259 17106 SEQUENCE public albums_id_seq batch | |
2159; 0 0 SEQUENCE OWNED BY public albums_id_seq batch | |
2160; 0 0 SEQUENCE SET public albums_id_seq batch | |
175; 1259 17108 TABLE public email_notification_settings batch | |
176; 1259 17114 SEQUENCE public email_notification_settings_id_seq batch | |
2161; 0 0 SEQUENCE OWNED BY public email_notification_settings_id_seq batch | |
2162; 0 0 SEQUENCE SET public email_notification_settings_id_seq batch | |
177; 1259 17116 TABLE public external_users batch | |
178; 1259 17120 SEQUENCE public external_users_id_seq batch | |
2163; 0 0 SEQUENCE OWNED BY public external_users_id_seq batch | |
2164; 0 0 SEQUENCE SET public external_users_id_seq batch | |
179; 1259 17122 TABLE public facebook_friends batch | |
180; 1259 17125 SEQUENCE public facebook_friends_id_seq batch | |
2165; 0 0 SEQUENCE OWNED BY public facebook_friends_id_seq batch | |
2166; 0 0 SEQUENCE SET public facebook_friends_id_seq batch | |
209; 1259 17383 TABLE public facebook_links batch | |
208; 1259 17381 SEQUENCE public facebook_links_id_seq batch | |
2167; 0 0 SEQUENCE OWNED BY public facebook_links_id_seq batch | |
2168; 0 0 SEQUENCE SET public facebook_links_id_seq batch | |
207; 1259 17370 TABLE public facebook_wall_posts batch | |
206; 1259 17368 SEQUENCE public facebook_wall_posts_id_seq batch | |
2169; 0 0 SEQUENCE OWNED BY public facebook_wall_posts_id_seq batch | |
2170; 0 0 SEQUENCE SET public facebook_wall_posts_id_seq batch | |
181; 1259 17135 TABLE public oauths batch | |
182; 1259 17141 SEQUENCE public oauths_id_seq batch | |
2171; 0 0 SEQUENCE OWNED BY public oauths_id_seq batch | |
2172; 0 0 SEQUENCE SET public oauths_id_seq batch | |
183; 1259 17143 TABLE public photo_exifs batch | |
184; 1259 17149 SEQUENCE public photo_exifs_id_seq batch | |
2173; 0 0 SEQUENCE OWNED BY public photo_exifs_id_seq batch | |
2174; 0 0 SEQUENCE SET public photo_exifs_id_seq batch | |
185; 1259 17151 TABLE public photo_metadata batch | |
186; 1259 17160 SEQUENCE public photo_metadata_id_seq batch | |
2175; 0 0 SEQUENCE OWNED BY public photo_metadata_id_seq batch | |
2176; 0 0 SEQUENCE SET public photo_metadata_id_seq batch | |
187; 1259 17162 TABLE public photo_tags batch | |
188; 1259 17167 SEQUENCE public photo_tags_id_seq batch | |
2177; 0 0 SEQUENCE OWNED BY public photo_tags_id_seq batch | |
2178; 0 0 SEQUENCE SET public photo_tags_id_seq batch | |
189; 1259 17169 TABLE public photos batch | |
190; 1259 17180 SEQUENCE public photos_id_seq batch | |
2179; 0 0 SEQUENCE OWNED BY public photos_id_seq batch | |
2180; 0 0 SEQUENCE SET public photos_id_seq batch | |
191; 1259 17182 TABLE public roles batch | |
192; 1259 17185 SEQUENCE public roles_id_seq batch | |
2181; 0 0 SEQUENCE OWNED BY public roles_id_seq batch | |
2182; 0 0 SEQUENCE SET public roles_id_seq batch | |
193; 1259 17187 TABLE public schema_migrations batch | |
194; 1259 17190 TABLE public social_connections batch | |
195; 1259 17196 SEQUENCE public social_connections_id_seq batch | |
2183; 0 0 SEQUENCE OWNED BY public social_connections_id_seq batch | |
2184; 0 0 SEQUENCE SET public social_connections_id_seq batch | |
196; 1259 17198 TABLE public user_avatars batch | |
197; 1259 17204 SEQUENCE public user_avatars_id_seq batch | |
2185; 0 0 SEQUENCE OWNED BY public user_avatars_id_seq batch | |
2186; 0 0 SEQUENCE SET public user_avatars_id_seq batch | |
198; 1259 17206 TABLE public user_devices batch | |
199; 1259 17219 SEQUENCE public user_devices_id_seq batch | |
2187; 0 0 SEQUENCE OWNED BY public user_devices_id_seq batch | |
2188; 0 0 SEQUENCE SET public user_devices_id_seq batch | |
200; 1259 17221 TABLE public user_roles batch | |
201; 1259 17224 SEQUENCE public user_roles_id_seq batch | |
2189; 0 0 SEQUENCE OWNED BY public user_roles_id_seq batch | |
2190; 0 0 SEQUENCE SET public user_roles_id_seq batch | |
202; 1259 17226 TABLE public user_sessions batch | |
203; 1259 17229 SEQUENCE public user_sessions_id_seq batch | |
2191; 0 0 SEQUENCE OWNED BY public user_sessions_id_seq batch | |
2192; 0 0 SEQUENCE SET public user_sessions_id_seq batch | |
204; 1259 17231 TABLE public users batch | |
205; 1259 17238 SEQUENCE public users_id_seq batch | |
2193; 0 0 SEQUENCE OWNED BY public users_id_seq batch | |
2194; 0 0 SEQUENCE SET public users_id_seq batch | |
1979; 2604 17240 DEFAULT public id batch | |
1980; 2604 17241 DEFAULT public id batch | |
1981; 2604 17242 DEFAULT public id batch | |
1983; 2604 17243 DEFAULT public id batch | |
1986; 2604 17244 DEFAULT public id batch | |
1987; 2604 17245 DEFAULT public id batch | |
1990; 2604 17246 DEFAULT public id batch | |
1994; 2604 17247 DEFAULT public id batch | |
1996; 2604 17248 DEFAULT public id batch | |
1997; 2604 17249 DEFAULT public id batch | |
2029; 2604 17386 DEFAULT public id batch | |
2028; 2604 17373 DEFAULT public id batch | |
1998; 2604 17251 DEFAULT public id batch | |
1999; 2604 17252 DEFAULT public id batch | |
2003; 2604 17253 DEFAULT public id batch | |
2006; 2604 17254 DEFAULT public id batch | |
2012; 2604 17255 DEFAULT public id batch | |
2013; 2604 17256 DEFAULT public id batch | |
2014; 2604 17257 DEFAULT public id batch | |
2015; 2604 17258 DEFAULT public id batch | |
2023; 2604 17259 DEFAULT public id batch | |
2024; 2604 17260 DEFAULT public id batch | |
2025; 2604 17261 DEFAULT public id batch | |
2027; 2604 17262 DEFAULT public id batch | |
2116; 0 17066 TABLE DATA public album_links batch | |
2117; 0 17071 TABLE DATA public album_members batch | |
2118; 0 17076 TABLE DATA public album_photo_comments batch | |
2119; 0 17084 TABLE DATA public album_photo_likes batch | |
2120; 0 17089 TABLE DATA public album_photos batch | |
2121; 0 17096 TABLE DATA public album_share_tweets batch | |
2122; 0 17101 TABLE DATA public albums batch | |
2123; 0 17108 TABLE DATA public email_notification_settings batch | |
2124; 0 17116 TABLE DATA public external_users batch | |
2125; 0 17122 TABLE DATA public facebook_friends batch | |
2140; 0 17383 TABLE DATA public facebook_links batch | |
2139; 0 17370 TABLE DATA public facebook_wall_posts batch | |
2126; 0 17135 TABLE DATA public oauths batch | |
2127; 0 17143 TABLE DATA public photo_exifs batch | |
2128; 0 17151 TABLE DATA public photo_metadata batch | |
2129; 0 17162 TABLE DATA public photo_tags batch | |
2130; 0 17169 TABLE DATA public photos batch | |
2131; 0 17182 TABLE DATA public roles batch | |
2132; 0 17187 TABLE DATA public schema_migrations batch | |
2133; 0 17190 TABLE DATA public social_connections batch | |
2134; 0 17198 TABLE DATA public user_avatars batch | |
2135; 0 17206 TABLE DATA public user_devices batch | |
2136; 0 17221 TABLE DATA public user_roles batch | |
2137; 0 17226 TABLE DATA public user_sessions batch | |
2138; 0 17231 TABLE DATA public users batch | |
2031; 2606 17264 CONSTRAINT public album_links_pkey batch | |
2035; 2606 17266 CONSTRAINT public album_members_pkey batch | |
2040; 2606 17268 CONSTRAINT public album_photo_comments_pkey batch | |
2044; 2606 17270 CONSTRAINT public album_photo_likes_pkey batch | |
2048; 2606 17272 CONSTRAINT public album_photos_pkey batch | |
2052; 2606 17274 CONSTRAINT public album_share_tweets_pkey batch | |
2056; 2606 17276 CONSTRAINT public albums_pkey batch | |
2060; 2606 17278 CONSTRAINT public email_notification_settings_pkey batch | |
2063; 2606 17280 CONSTRAINT public external_users_pkey batch | |
2067; 2606 17282 CONSTRAINT public facebook_friends_pkey batch | |
2112; 2606 17388 CONSTRAINT public facebook_links_pkey batch | |
2108; 2606 17378 CONSTRAINT public facebook_wall_posts_pkey batch | |
2071; 2606 17286 CONSTRAINT public oauths_pkey batch | |
2074; 2606 17288 CONSTRAINT public photo_exifs_pkey batch | |
2077; 2606 17290 CONSTRAINT public photo_metadata_pkey batch | |
2082; 2606 17292 CONSTRAINT public photo_tags_pkey batch | |
2086; 2606 17294 CONSTRAINT public photos_pkey batch | |
2088; 2606 17296 CONSTRAINT public roles_pkey batch | |
2092; 2606 17298 CONSTRAINT public social_connections_pkey batch | |
2094; 2606 17300 CONSTRAINT public user_avatars_pkey batch | |
2097; 2606 17302 CONSTRAINT public user_devices_pkey batch | |
2099; 2606 17304 CONSTRAINT public user_roles_pkey batch | |
2103; 2606 17306 CONSTRAINT public user_sessions_pkey batch | |
2106; 2606 17308 CONSTRAINT public users_pkey batch | |
2032; 1259 17309 INDEX public index_album_links_on_album_id batch | |
2033; 1259 17310 INDEX public index_album_links_on_token_and_album_id batch | |
2036; 1259 17311 INDEX public index_album_members_on_album_id batch | |
2037; 1259 17312 INDEX public index_album_members_on_type batch | |
2038; 1259 17313 INDEX public index_album_members_on_user_id_and_album_id batch | |
2041; 1259 17314 INDEX public index_album_photo_comments_on_album_id_and_photo_id batch | |
2042; 1259 17315 INDEX public index_album_photo_comments_on_uuid batch | |
2045; 1259 17316 INDEX public index_album_photo_likes_on_album_id_and_photo_id batch | |
2046; 1259 17317 INDEX public index_album_photo_likes_on_uuid batch | |
2049; 1259 17318 INDEX public index_album_photos_on_album_id_and_photo_id batch | |
2050; 1259 17319 INDEX public index_album_photos_on_photo_id batch | |
2053; 1259 17320 INDEX public index_album_share_tweets_on_album_id batch | |
2054; 1259 17392 INDEX public index_album_share_tweets_on_token batch | |
2057; 1259 17321 INDEX public index_albums_on_user_id batch | |
2058; 1259 17322 INDEX public index_albums_on_uuid batch | |
2061; 1259 17323 INDEX public index_email_notification_settings_on_user_id batch | |
2064; 1259 17324 INDEX public index_external_users_on_external_id_and_type batch | |
2065; 1259 17325 INDEX public index_external_users_on_user_id batch | |
2068; 1259 17326 INDEX public index_facebook_friends_on_user_id_and_friend_id batch | |
2113; 1259 17389 INDEX public index_facebook_links_on_album_id batch | |
2114; 1259 17391 INDEX public index_facebook_links_on_token batch | |
2115; 1259 17390 INDEX public index_facebook_links_on_user_id batch | |
2109; 1259 17379 INDEX public index_facebook_wall_posts_on_album_id batch | |
2110; 1259 17655 INDEX public index_facebook_wall_posts_on_token batch | |
2069; 1259 17328 INDEX public index_oauths_on_external_user_id_and_type batch | |
2072; 1259 17329 INDEX public index_photo_exifs_on_photo_id batch | |
2075; 1259 17330 INDEX public index_photo_metadata_on_photo_id batch | |
2078; 1259 17331 INDEX public index_photo_tags_on_album_id_and_photo_id batch | |
2079; 1259 17332 INDEX public index_photo_tags_on_photo_id batch | |
2080; 1259 17333 INDEX public index_photo_tags_on_uuid batch | |
2083; 1259 17334 INDEX public index_photos_on_user_id batch | |
2084; 1259 17335 INDEX public index_photos_on_uuid batch | |
2090; 1259 17336 INDEX public index_social_connections_on_user_id_and_source batch | |
2095; 1259 17337 INDEX public index_user_devices_on_user_id_and_udid batch | |
2100; 1259 17338 INDEX public index_user_sessions_on_oauth_token batch | |
2101; 1259 17339 INDEX public index_user_sessions_on_user_id batch | |
2104; 1259 17340 INDEX public index_users_on_uuid batch | |
2089; 1259 17341 INDEX public unique_schema_migrations batch |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment