Changeset 429 for trunk/sql/updates/426.php
- Timestamp:
- Apr 8, 2010, 8:31:45 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/updates/426.php
r426 r429 20 20 $Lines[] = 'ALTER TABLE `'.$Group['TablePrefix'].'` ADD `CompleteParts` INT NOT NULL AFTER `Complete`;'; 21 21 $Lines[] = 'ALTER TABLE `'.$Group['TablePrefix'].'` ADD `ModifyTime` DATETIME NOT NULL;'; 22 $Lines[] = 'ALTER TABLE `'.$Group['TablePrefix'].'` INDEX ( `ModifyTime` );';22 $Lines[] = 'ALTER TABLE `'.$Group['TablePrefix'].'` ADD INDEX ( `ModifyTime` );'; 23 23 $Lines[] = 'UPDATE `'.$Group['TablePrefix'].'` SET `ModifyTime` = NOW();'; 24 24 $Lines[] = 'UPDATE `'.$Group['TablePrefix'].'` SET `CompleteParts` = '.((1 << $Group['ItemsCount']) - 1).' WHERE `Complete`=1;';
Note:
See TracChangeset
for help on using the changeset viewer.