diff options
| author | Christian Fowler <spider@viovio.com> | 2009-05-29 16:03:49 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2009-05-29 16:03:49 +0000 |
| commit | f3e15656be2715ba6499e0b9d7d1bfccb6db4d1e (patch) | |
| tree | 4bfe9b67c05fe089670b7e680725f1e2e9e0049a | |
| parent | 079cfb7be5df4bd2b9b76332c15fcc7993835eed (diff) | |
| download | boards-f3e15656be2715ba6499e0b9d7d1bfccb6db4d1e.tar.gz boards-f3e15656be2715ba6499e0b9d7d1bfccb6db4d1e.tar.bz2 boards-f3e15656be2715ba6499e0b9d7d1bfccb6db4d1e.zip | |
add a first pass at sections table and pos column
| -rw-r--r-- | admin/schema_inc.php | 7 | ||||
| -rw-r--r-- | admin/upgrades/1.0.1.php | 37 |
2 files changed, 44 insertions, 0 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index bb23a2a..c7b1ab6 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -16,11 +16,18 @@ $tables = array( migrate_topic_id INT CONSTRAINT ', CONSTRAINT `boards_topics_parent_ref` FOREIGN KEY (`parent_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' ", + 'boards_sections' => " + section_id I4 PRIMARY, + section_title C(255) + ", 'boards' => " board_id I4 PRIMARY, content_id I4 NOTNULL, + section_id I4, + pos I4, migrate_board_id INT CONSTRAINT ', CONSTRAINT `boards_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' + , CONSTRAINT `boards_section_ref` FOREIGN KEY (`section_id`) REFERENCES `".BIT_DB_PREFIX."boards_sections` (`section_id`)' ", 'boards_map' => " board_content_id I4 NOTNULL, diff --git a/admin/upgrades/1.0.1.php b/admin/upgrades/1.0.1.php new file mode 100644 index 0000000..54ba667 --- /dev/null +++ b/admin/upgrades/1.0.1.php @@ -0,0 +1,37 @@ +<?php +/** + * @version $Header: /cvsroot/bitweaver/_bit_boards/admin/upgrades/1.0.1.php,v 1.1 2009/05/29 16:03:49 spiderr Exp $ + */ +global $gBitInstaller; + +$infoHash = array( + 'package' => BOARDS_PKG_NAME, + 'version' => str_replace( '.php', '', basename( __FILE__ )), + 'description' => "Add boards sections and positioning.", + 'post_upgrade' => NULL, +); +$gBitInstaller->registerPackageUpgrade( $infoHash, array( + +array( 'DATADICT' => array( + array( 'CREATE' => array( + 'boards_sections' => " + section_id I4 PRIMARY, + section_title C(255) + ", + )), + // insert new column + array( 'ALTER' => array( + 'boards' => array( + 'section_id' => array( '`section_id`', 'I4' ), + 'pos' => array( '`pos`', 'I4' ), + ))), + array( 'CREATEINDEX' => array( + 'boards_sections_idx' => array( 'boards', 'section_id', array() ), + )), + array( 'CREATESEQUENCE' => array( + 'boards_sections_id_seq', + )), +)), + +)); +?> |