Przerabiamy linkage - 2

START TRANSACTION;
DELETE FROM tbl_diff_fields d WHERE NOT EXISTS (SELECT 1 FROM tbl_linkage l WHERE l.fld_linkage_id = d.fld_linkage_id LIMIT 1);
DELETE FROM tbl_mmedia d WHERE NOT EXISTS (SELECT 1 FROM tbl_linkage l WHERE l.fld_linkage_id = d.fld_linkage_id LIMIT 1);
DELETE FROM tbl_special_fields d WHERE NOT EXISTS (SELECT 1 FROM tbl_linkage l WHERE l.fld_linkage_id = d.fld_linkage_id LIMIT 1);
commit;

START TRANSACTION;
CREATE TEMP SEQUENCE serial START 1;
ALTER TABLE tbl_linkage ADD COLUMN fld_linkage_int BIGINT;
UPDATE tbl_linkage SET fld_linkage_int = NEXTVAL('serial');

UPDATE tbl_diff_fields x SET fld_linkage_id = (SELECT CAST(fld_linkage_int AS text) FROM tbl_linkage y WHERE y.fld_linkage_id = x.fld_linkage_id LIMIT 1);
UPDATE tbl_mmedia x SET fld_linkage_id = (SELECT CAST(fld_linkage_int AS text)  FROM tbl_linkage y WHERE y.fld_linkage_id = x.fld_linkage_id LIMIT 1);
UPDATE tbl_special_fields x SET fld_linkage_id = (SELECT CAST(fld_linkage_int AS text)  FROM tbl_linkage y WHERE y.fld_linkage_id = x.fld_linkage_id LIMIT 1);

ALTER TABLE tbl_linkage DROP CONSTRAINT tbl_linkage_pkey;
ALTER TABLE tbl_linkage DROP COLUMN fld_linkage_id;
ALTER TABLE tbl_linkage RENAME COLUMN fld_linkage_int TO fld_linkage_id;
ALTER TABLE tbl_linkage ADD PRIMARY KEY (fld_linkage_id);

ALTER TABLE tbl_diff_fields  DROP CONSTRAINT tbl_diff_fields_pkey;
DROP INDEX idx_tbl_special_fields_fld_linkage_id;

ALTER TABLE tbl_diff_fields ALTER COLUMN fld_linkage_id TYPE BIGINT USING CAST(fld_linkage_id AS BIGINT);
ALTER TABLE tbl_mmedia ALTER COLUMN fld_linkage_id TYPE BIGINT USING CAST(fld_linkage_id AS BIGINT);
ALTER TABLE tbl_special_fields ALTER COLUMN fld_linkage_id TYPE BIGINT USING CAST(fld_linkage_id AS BIGINT);

ALTER TABLE tbl_diff_fields ADD PRIMARY KEY (fld_linkage_id, fld_level);
CREATE INDEX idx_tbl_special_fields_fld_linkage_id ON tbl_special_fields (fld_linkage_id);