Show
Ignore:
Timestamp:
05/26/08 19:44:26 (4 years ago)
Author:
dom
Message:

Move to new schema version 10, including some missing indexes
and support for deletion flags and verified flags. Note that
the code using these columns has not yet been written (closes #25, #34).

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • wiki-toolkit/trunk/t/400_upgrade.t

    r440 r441  
    1515INSERT INTO content VALUES (2, 1, 'More content', 'now', 'no comment')|, qq| 
    1616INSERT INTO metadata VALUES (1, 1, 'foo', 'bar')|, qq| 
    17 INSERT INTO metadata VALUES (2, 1, 'baz', 'quux')| ] 
     17INSERT INTO metadata VALUES (2, 1, 'baz', 'quux')| ], 
     18    9 => [ qq| 
     19INSERT INTO node (id, name, version, text, modified) VALUES (1, 'Test node 1', 1, 'Some content', 'now')|, qq| 
     20INSERT INTO node (id, name, version, text, modified) VALUES (2, 'Test node 2', 1, 'More content', 'now')|, qq| 
     21INSERT INTO content (node_id, version, text, modified, comment) VALUES (1, 1, 'Some content', 'now', 'no comment')|, qq| 
     22INSERT INTO content (node_id, version, text, modified, comment) VALUES (2, 1, 'More content', 'now', 'no comment')|, qq| 
     23INSERT INTO metadata VALUES (1, 1, 'foo', 'bar')|, qq| 
     24INSERT INTO metadata VALUES (2, 1, 'baz', 'quux')| ], 
    1825}; 
    1926