diff options
| author | Lester Caine <lester@lsces.co.uk> | 2010-05-13 13:14:36 +0000 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2010-05-13 13:14:36 +0000 |
| commit | 6aa4653a5745d096485a68dbe6b73836427a300d (patch) | |
| tree | 314f4a425a4e0b135ae0d97f3224df291524699b /admin | |
| parent | e0266fd7dd95be00496bb177b08683f4c3450cb5 (diff) | |
| download | liberty-6aa4653a5745d096485a68dbe6b73836427a300d.tar.gz liberty-6aa4653a5745d096485a68dbe6b73836427a300d.tar.bz2 liberty-6aa4653a5745d096485a68dbe6b73836427a300d.zip | |
This adds the base table for area tags. I think this is the right way to do things since each image that has tags needs it's own array of tag data, and this can be extracted from the table quickly.
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/upgrades/2.1.5.php | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/admin/upgrades/2.1.5.php b/admin/upgrades/2.1.5.php new file mode 100644 index 0000000..f5d7372 --- /dev/null +++ b/admin/upgrades/2.1.5.php @@ -0,0 +1,39 @@ +<?php +/** + * @version $Header: /cvsroot/bitweaver/_bit_liberty/admin/upgrades/Attic/2.1.5.php,v 1.1 2010/05/13 13:14:36 lsces Exp $ + */ +global $gBitInstaller; + +$infoHash = array( + 'package' => LIBERTY_PKG_NAME, + 'version' => str_replace( '.php', '', basename( __FILE__ )), + 'description' => "This upgrade adds a table for storing area tags for image files.", + 'post_upgrade' => NULL, +); +$gBitInstaller->registerPackageUpgrade( $infoHash, array( + +array( 'DATADICT' => array( + array( 'CREATE' => array( + 'liberty_attachment_tags' => " + comment_id I4 PRIMARY NOTNULL, + attachment_id I4 PRIMARY NOTNULL, + tag_top I4 DEFAULT 0 NOTNULL , + tag_left I4 DEFAULT 0 NOTNULL , + tag_width I4 DEFAULT 100 NOTNULL , + tag_height I4 DEFAULT 100 NOTNULL , + CONSTRAINT ' + , CONSTRAINT `lib_attachment_tag_id_ref` FOREIGN KEY (`attachment_id`) REFERENCES `".BIT_DB_PREFIX."liberty_attachments` (`attachment_id`) + , CONSTRAINT `lib_attachment_tag_cid_ref` FOREIGN KEY (`comment_id`) REFERENCES `".BIT_DB_PREFIX."liberty_comments` (`comment_id`) + ", + )), +)), + +array( 'PHP' => ' + // make sure plugins are up to date. + global $gLibertySystem; + $gLibertySystem->scanAllPlugins(); +' +) + +)); +?> |