-- Table: film_yedek -- DROP TABLE film_yedek; CREATE TABLE film_yedek ( film_id INTEGER, title CHARACTER VARYING( 255 ), description TEXT, release_year YEAR, language_id SMALLINT, rental_duration SMALLINT, rental_rate NUMERIC( 4,2 ), length SMALLINT, replacement_cost NUMERIC( 5,2 ), rating mpaa_rating, last_update TIMESTAMP WITHOUT TIME ZONE, special_features TEXT[], fulltext tsvector, "ID" BIGSERIAL NOT NULL, CONSTRAINT "PK_filmYedek" PRIMARY KEY ( "ID" ) WITH ( FILLFACTOR = 90 ), CONSTRAINT "FK_FilID" FOREIGN KEY ( film_id ) REFERENCES film ( film_id ) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE ) WITH ( FILLFACTOR = 90, OIDS = FALSE ) TABLESPACE "bigData"; ALTER TABLE film_yedek OWNER TO postgres;
-- Index: "IDX_Title" -- DROP INDEX "IDX_Title"; CREATE INDEX "IDX_Title" ON film_yedek USING btree (title COLLATE pg_catalog."default"); -- Index: "IDX_relaseYear" -- DROP INDEX "IDX_relaseYear"; CREATE INDEX "IDX_relaseYear" ON film_yedek USING btree (release_year);
