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

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

@@ -121 +121 @@
   text      mediumtext   NOT NULL default '',
   modified  datetime     default NULL,
-  moderate  boolean      NOT NULL default '0',
-  deleted   boolean      NOT NULL default '0'
+  moderate  boolean      NOT NULL default '0'
 ) 
 |, qq|
 CREATE UNIQUE INDEX node_name ON node (name)
-|, qq|
-CREATE INDEX node_deleted_index ON node (deleted)
 | ],
         content => [ qq|
@@ -137 +134 @@
   comment   mediumtext   NOT NULL default '',
   moderated boolean      NOT NULL default '1',
-  deleted   boolean      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|
@@ -148 +142 @@
   link_from varchar(200) NOT NULL default '',
   link_to   varchar(200) NOT NULL default '',
-  deleted   boolean      NOT NULL default '0',
   PRIMARY KEY (link_from, link_to)
 ) 
-|, qq|
-CREATE INDEX internal_links_deleted_index ON internal_links (deleted)
 | ],
         metadata => [ qq|
@@ -159 +150 @@
   version        integer      NOT NULL default 0,
   metadata_type  varchar(200) NOT NULL DEFAULT '',
-  metadata_value mediumtext   NOT NULL DEFAULT '',
-  deleted        boolean      NOT NULL DEFAULT '0'
+  metadata_value mediumtext   NOT NULL DEFAULT ''
 ) 
-|, qq|
-CREATE INDEX metadata_deleted_index ON metadata (deleted)
 | ] 
     },