Changeset 443 for wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Pg.pm

Timestamp:

06/22/08 13:24:31 (4 years ago)

Author:

dom

Message:

roll back deletion flag stuff for now; need to think more about best way
to do it

Files:

• wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Pg.pm (modified) (3 diffs)

wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Pg.pm

@@ -152 +152 @@
   modified  timestamp without time zone    default NULL,
   moderate  boolean      NOT NULL default '0',
-  deleted   boolean      NOT NULL default '0',
   CONSTRAINT pk_id PRIMARY KEY (id)
 )
 |, qq|
 CREATE UNIQUE INDEX node_name ON node (name)
-|, qq|
-CREATE INDEX node_deleted_index ON node (deleted)
 | ],
 
@@ -169 +166 @@
   comment   text         NOT NULL default '',
   moderated boolean      NOT NULL default '1',
-  deleted   boolean      NOT NULL default '0',
   verified  timestamp without time zone    default NULL,
   CONSTRAINT pk_node_id PRIMARY KEY (node_id,version),
   CONSTRAINT fk_node_id FOREIGN KEY (node_id) REFERENCES node (id)
 )
-|, qq|
-CREATE INDEX content_deleted_index ON content (deleted)
 | ],
 
@@ -260 +254 @@
 
 '9_to_10' => [ qq|
-ALTER TABLE node ADD COLUMN deleted boolean;
-UPDATE node SET deleted = '0';
-ALTER TABLE node ALTER COLUMN deleted SET DEFAULT '0';
-ALTER TABLE node ALTER COLUMN deleted SET NOT NULL;
-CREATE INDEX node_deleted_index ON node (deleted);
-|, qq|
-ALTER TABLE content ADD COLUMN deleted boolean;
-UPDATE content SET deleted = '0';
-ALTER TABLE content ALTER COLUMN deleted SET DEFAULT '0';
-ALTER TABLE content ALTER COLUMN deleted SET NOT NULL;
-CREATE INDEX content_deleted_index ON content (deleted);
-|, qq|
-ALTER TABLE internal_links ADD COLUMN deleted boolean;
-UPDATE internal_links SET deleted = '0';
-ALTER TABLE internal_links ALTER COLUMN deleted SET DEFAULT '0';
-ALTER TABLE internal_links ALTER COLUMN deleted SET NOT NULL;
-CREATE INDEX internal_links_deleted_index ON internal_links (deleted);
-|, qq|
-ALTER TABLE metadata ADD COLUMN deleted boolean;
-UPDATE metadata SET deleted = '0';
-ALTER TABLE metadata ALTER COLUMN deleted SET DEFAULT '0';
-ALTER TABLE metadata ALTER COLUMN deleted SET NOT NULL;
-CREATE INDEX metadata_deleted_index ON metadata (deleted);
-|, qq|
 ALTER TABLE content ADD COLUMN verified timestamp without time zone default NULL;
 |, qq|