· 6 years ago · May 28, 2019, 10:24 PM
1Executing (default): CREATE TABLE IF NOT EXISTS "public"."person" ("id" BIGSERIAL , "name" VARCHAR(255) NOT NULL, "gender" INTEGER, "photo_url" VARCHAR(255), "birthdate" DATE, "deathdate" DATE, "biography" TEXT, "popularity" REAL, PRIMARY KEY ("id"));
2Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'person' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
3Executing (default): DROP TABLE IF EXISTS "public"."genre" CASCADE;
4Executing (default): CREATE TABLE IF NOT EXISTS "public"."genre" ("id" SERIAL , "name" VARCHAR(255) NOT NULL UNIQUE, PRIMARY KEY ("id"));
5Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'genre' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
6Executing (default): DROP TABLE IF EXISTS "public"."country" CASCADE;
7Executing (default): CREATE TABLE IF NOT EXISTS "public"."country" ("id" BIGSERIAL , "name" VARCHAR(255) NOT NULL UNIQUE, PRIMARY KEY ("id"));
8Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'country' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
9Executing (default): DROP TABLE IF EXISTS "public"."friend" CASCADE;
10Executing (default): CREATE TABLE IF NOT EXISTS "public"."friend" ("userlogin" VARCHAR(255) , "friendlogin" VARCHAR(255) , "statusid_status" VARCHAR(255), PRIMARY KEY ("userlogin","friendlogin"));
11Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'friend' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
12Executing (default): DROP TABLE IF EXISTS "public"."users" CASCADE;
13Executing (default): CREATE TABLE IF NOT EXISTS "public"."users" ("id" UUID , "firstname" VARCHAR(255), "lastname" VARCHAR(255), "email" VARCHAR(255) NOT NULL UNIQUE, "password" VARCHAR(255), "picture" VARCHAR(255), "external_id" VARCHAR(255), "token" VARCHAR(255), "created_at" TIMESTAMP WITH TIME ZONE NOT NULL, "updated_at" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
14Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'users' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
15Executing (default): DROP TABLE IF EXISTS "public"."status" CASCADE;
16Executing (default): CREATE TABLE IF NOT EXISTS "public"."status" ("id_status" VARCHAR(255), "name" VARCHAR(255) NOT NULL UNIQUE);
17Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'status' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
18Executing (default): DROP TABLE IF EXISTS "public"."movie" CASCADE;
19Executing (default): CREATE TABLE IF NOT EXISTS "public"."movie" ("id" BIGSERIAL , "title" VARCHAR(255) NOT NULL UNIQUE, "poster_url" VARCHAR(255), "release_date" TIMESTAMP WITH TIME ZONE, "description" VARCHAR(255), "budget" BIGINT, "revenue" BIGINT, "runtime" INTEGER, "popularity" REAL, "external_rating" REAL, "external_vote_count" INTEGER, PRIMARY KEY ("id"));
20Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'movie' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
21Executing (default): DROP TABLE IF EXISTS "public"."similar_movie" CASCADE;
22Executing (default): CREATE TABLE IF NOT EXISTS "public"."similar_movie" ("id" BIGSERIAL , "movie_id" BIGINT REFERENCES "public"."movie" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "similar_movie_id" BIGINT, PRIMARY KEY ("id"));
23Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'similar_movie' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
24Executing (default): DROP TABLE IF EXISTS "public"."cast" CASCADE;
25Executing (default): CREATE TABLE IF NOT EXISTS "public"."cast" ("cast_id" BIGSERIAL , "character" VARCHAR(255), "order" INTEGER, "person_id" BIGINT REFERENCES "public"."person" ("id") ON DELETE SET NULL ON UPDATE CASCADE, "movie_id" BIGINT REFERENCES "public"."movie" ("id") ON DELETE SET NULL ON UPDATE CASCADE, PRIMARY KEY ("cast_id"));
26Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'cast' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
27Executing (default): DROP TABLE IF EXISTS "public"."crew" CASCADE;
28Executing (default): CREATE TABLE IF NOT EXISTS "public"."crew" ("crew_id" BIGSERIAL , "movie_id" BIGINT REFERENCES "public"."movie" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "person_id" BIGINT REFERENCES "public"."person" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "job" VARCHAR(255) NOT NULL, "department" VARCHAR(255), PRIMARY KEY ("crew_id"));
29Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'crew' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
30Executing (default): DROP TABLE IF EXISTS "public"."production_company" CASCADE;
31Executing (default): CREATE TABLE IF NOT EXISTS "public"."production_company" ("id" SERIAL , "name" VARCHAR(255) NOT NULL, PRIMARY KEY ("id"));
32Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'production_company' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
33Executing (default): DROP TABLE IF EXISTS "public"."rating" CASCADE;
34Executing (default): CREATE TABLE IF NOT EXISTS "public"."rating" ("id" BIGSERIAL , "rate" BIGINT NOT NULL, "is_favourite" BOOLEAN, "movie_id" BIGINT REFERENCES "public"."movie" ("id") ON DELETE NO ACTION ON UPDATE CASCADE, "user_id" UUID REFERENCES "public"."users" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "created_at" TIMESTAMP WITH TIME ZONE NOT NULL, "updated_at" TIMESTAMP WITH TIME ZONE NOT NULL, UNIQUE ("movie_id", "user_id"), PRIMARY KEY ("id"));
35Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'rating' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
36Executing (default): DROP TABLE IF EXISTS "public"."genres_movies" CASCADE;
37Executing (default): CREATE TABLE IF NOT EXISTS "public"."genres_movies" ("genre_id" INTEGER REFERENCES "public"."genre" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "movie_id" BIGINT REFERENCES "public"."movie" ("id") ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY ("genre_id","movie_id"));
38Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'genres_movies' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
39Executing (default): DROP TABLE IF EXISTS "public"."countries_movies" CASCADE;
40Executing (default): CREATE TABLE IF NOT EXISTS "public"."countries_movies" ("country_id" BIGINT REFERENCES "public"."country" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "movie_id" BIGINT REFERENCES "public"."movie" ("id") ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY ("country_id","movie_id"));
41Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'countries_movies' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
42Executing (default): DROP TABLE IF EXISTS "public"."productions_movies" CASCADE;
43Executing (default): CREATE TABLE IF NOT EXISTS "public"."productions_movies" ("created_at" TIMESTAMP WITH TIME ZONE NOT NULL, "updated_at" TIMESTAMP WITH TIME ZONE NOT NULL, "production_company_id" INTEGER REFERENCES "public"."production_company" ("id") ON DELETE CASCADE ON UPDATE CASCADE, "movie_id" BIGINT REFERENCES "public"."movie" ("id") ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY ("production_company_id","movie_id"));
44Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'productions_movies' AND s.oid = t.relnamespace AND s.nspname = 'public' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;