Changeset 443 for wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/MySQL.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/MySQL.pm (modified) (5 diffs)

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

@@ -131 +131 @@
   modified  datetime     default NULL,
   moderate  bool         NOT NULL default '0',
-  deleted   bool         NOT NULL default '0',
   PRIMARY KEY (id)
 )
 |, qq|
 CREATE UNIQUE INDEX node_name ON node (name)
-|, qq|
-CREATE INDEX node_deleted_index ON node (deleted)
 | ],
 
@@ -148 +145 @@
   comment   mediumtext   NOT NULL default '',
   moderated bool         NOT NULL default '1',
-  deleted   bool         NOT NULL DEFAULT '0',
   verified  datetime     default NULL,
   PRIMARY KEY (node_id, version)
 )
-|, qq|
-CREATE INDEX content_deleted_index ON content (deleted)
 | ],
         internal_links => [ qq|
@@ -159 +153 @@
   link_from varchar(200) NOT NULL default '',
   link_to   varchar(200) NOT NULL default '',
-  deleted   bool         NOT NULL default '0',
   PRIMARY KEY (link_from, link_to)
 )
-|, qq|
-CREATE INDEX internal_links_deleted_index ON internal_links (deleted)
 | ],
         metadata => [ qq|
@@ -170 +161 @@
   version        int(10)      NOT NULL default 0,
   metadata_type  varchar(200) NOT NULL DEFAULT '',
-  metadata_value mediumtext   NOT NULL DEFAULT '',
-  deleted        bool         NOT NULL DEFAULT '0'
+  metadata_value mediumtext   NOT NULL DEFAULT ''
 )
 |, qq|
 CREATE INDEX metadata_index ON metadata(node_id, version, metadata_type, metadata_value(10))
-|, qq|
-CREATE INDEX metadata_deleted_index ON metadata (deleted)
 | ]
     },
@@ -192 +180 @@
 '9_to_10' => [ qq|
 CREATE UNIQUE INDEX node_name ON node (name)
-|, qq|
-ALTER TABLE node ADD COLUMN deleted boolean
-|, qq|
-UPDATE node SET deleted = '0'
-|, qq|
-ALTER TABLE node MODIFY COLUMN deleted bool NOT NULL DEFAULT '0'
-|, qq|
-CREATE INDEX node_deleted_index ON node (deleted)
-|, qq|
-ALTER TABLE content ADD COLUMN deleted boolean
-|, qq|
-UPDATE content SET deleted = '0'
-|, qq|
-ALTER TABLE content MODIFY COLUMN deleted bool NOT NULL DEFAULT '0'
-|, qq|
-CREATE INDEX content_deleted_index ON content (deleted)
-|, qq|
-ALTER TABLE internal_links ADD COLUMN deleted boolean
-|, qq|
-UPDATE internal_links SET deleted = '0'
-|, qq|
-ALTER TABLE internal_links MODIFY COLUMN deleted bool NOT NULL DEFAULT '0'
-|, qq|
-CREATE INDEX internal_links_deleted_index ON internal_links (deleted)
-|, qq|
-ALTER TABLE metadata ADD COLUMN deleted boolean
-|, qq|
-UPDATE metadata SET deleted = '0'
-|, qq|
-ALTER TABLE metadata MODIFY COLUMN deleted bool NOT NULL DEFAULT '0'
-|, qq|
-CREATE INDEX metadata_deleted_index ON metadata (deleted)
 |, qq|
 ALTER TABLE content ADD COLUMN verified datetime default NULL