Massage ContentMirror Tables for Django
by
plone.org Administrator
—
last modified
Feb 22, 2009 07:55 AM
Run this against your postgresql database to add ID fields that are needed by Django.
contentmirror_massage_for_django.sql
—
SQL code,
2 kB (2252 bytes)
File contents
CREATE SEQUENCE atbtreefolder_id_seq;
ALTER TABLE atbtreefolder ADD id INT UNIQUE;
ALTER TABLE atbtreefolder ALTER COLUMN id SET DEFAULT NEXTVAL('atbtreefolder_id_seq');
UPDATE atbtreefolder SET id = NEXTVAL('atbtreefolder_id_seq');
CREATE SEQUENCE atdocument_id_seq;
ALTER TABLE atdocument ADD id INT UNIQUE;
ALTER TABLE atdocument ALTER COLUMN id SET DEFAULT NEXTVAL('atdocument_id_seq');
UPDATE atdocument SET id = NEXTVAL('atdocument_id_seq');
CREATE SEQUENCE atevent_id_seq;
ALTER TABLE atevent ADD id INT UNIQUE;
ALTER TABLE atevent ALTER COLUMN id SET DEFAULT NEXTVAL('atevent_id_seq');
UPDATE atevent SET id = NEXTVAL('atevent_id_seq');
CREATE SEQUENCE atfavorite_id_seq;
ALTER TABLE atfavorite ADD id INT UNIQUE;
ALTER TABLE atfavorite ALTER COLUMN id SET DEFAULT NEXTVAL('atfavorite_id_seq');
UPDATE atfavorite SET id = NEXTVAL('atfavorite_id_seq');
CREATE SEQUENCE atfile_id_seq;
ALTER TABLE atfile ADD id INT UNIQUE;
ALTER TABLE atfile ALTER COLUMN id SET DEFAULT NEXTVAL('atfile_id_seq');
UPDATE atfile SET id = NEXTVAL('atfile_id_seq');
CREATE SEQUENCE atfolder_id_seq;
ALTER TABLE atfolder ADD id INT UNIQUE;
ALTER TABLE atfolder ALTER COLUMN id SET DEFAULT NEXTVAL('atfolder_id_seq');
UPDATE atfolder SET id = NEXTVAL('atfolder_id_seq');
CREATE SEQUENCE atimage_id_seq;
ALTER TABLE atimage ADD id INT UNIQUE;
ALTER TABLE atimage ALTER COLUMN id SET DEFAULT NEXTVAL('atimage_id_seq');
UPDATE atimage SET id = NEXTVAL('atimage_id_seq');
CREATE SEQUENCE atlink_id_seq;
ALTER TABLE atlink ADD id INT UNIQUE;
ALTER TABLE atlink ALTER COLUMN id SET DEFAULT NEXTVAL('atlink_id_seq');
UPDATE atlink SET id = NEXTVAL('atlink_id_seq');
CREATE SEQUENCE atnewsitem_id_seq;
ALTER TABLE atnewsitem ADD id INT UNIQUE;
ALTER TABLE atnewsitem ALTER COLUMN id SET DEFAULT NEXTVAL('atnewsitem_id_seq');
UPDATE atnewsitem SET id = NEXTVAL('atnewsitem_id_seq');
CREATE SEQUENCE files_id_seq;
ALTER TABLE files ADD id INT UNIQUE;
ALTER TABLE files ALTER COLUMN id SET DEFAULT NEXTVAL('files_id_seq');
UPDATE files SET id = NEXTVAL('files_id_seq');
CREATE SEQUENCE relations_id_seq;
ALTER TABLE relations ADD id INT UNIQUE;
ALTER TABLE relations ALTER COLUMN id SET DEFAULT NEXTVAL('relations_id_seq');
UPDATE relations SET id = NEXTVAL('relations_id_seq');
