summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--BitArticle.php64
-rw-r--r--BitArticleTopic.php24
-rw-r--r--BitArticleType.php18
-rw-r--r--admin/schema_inc.php34
4 files changed, 70 insertions, 70 deletions
diff --git a/BitArticle.php b/BitArticle.php
index d6bf6ca..0d32245 100644
--- a/BitArticle.php
+++ b/BitArticle.php
@@ -1,6 +1,6 @@
<?php
/**
- * @version $Header: /cvsroot/bitweaver/_bit_articles/BitArticle.php,v 1.52 2006/01/31 10:21:11 squareing Exp $
+ * @version $Header: /cvsroot/bitweaver/_bit_articles/BitArticle.php,v 1.53 2006/01/31 20:16:24 bitweaver Exp $
* @package article
*
* Copyright( c )2004 bitweaver.org
@@ -9,14 +9,14 @@
* All Rights Reserved. See copyright.txt for details and a complete list of authors.
* Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details
*
- * $Id: BitArticle.php,v 1.52 2006/01/31 10:21:11 squareing Exp $
+ * $Id: BitArticle.php,v 1.53 2006/01/31 20:16:24 bitweaver Exp $
*
* Article class is used when accessing BitArticles. It is based on TikiSample
* and builds on core bitweaver functionality, such as the Liberty CMS engine.
*
* created 2004/8/15
* @author wolffy <wolff_borg@yahoo.com.au>
- * @version $Revision: 1.52 $ $Date: 2006/01/31 10:21:11 $ $Author: squareing $
+ * @version $Revision: 1.53 $ $Date: 2006/01/31 20:16:24 $ $Author: bitweaver $
*/
/**
@@ -87,19 +87,19 @@ class BitArticle extends LibertyAttachable {
// This is a significant performance optimization
$lookupColumn = @$this->verifyId( $this->mArticleId ) ? 'article_id' : 'content_id';
$lookupId = @$this->verifyId( $this->mArticleId ) ? $this->mArticleId : $this->mContentId;
- $query = "SELECT ta.*, tc.*, tatype.*, tatopic.*, " .
+ $query = "SELECT a.*, tc.*, atype.*, atopic.*, " .
"uue.`login` AS `modifier_user`, uue.`real_name` AS `modifier_real_name`, " .
"uuc.`login` AS `creator_user`, uuc.`real_name` AS `creator_real_name` ," .
"tf.`storage_path` as `image_storage_path` " .
- "FROM `".BIT_DB_PREFIX."tiki_articles` ta " .
- "LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_article_types` tatype ON( tatype.`article_type_id` = ta.`article_type_id` )".
- "LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_article_topics` tatopic ON( tatopic.`topic_id` = ta.`topic_id` )".
- "INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id` = ta.`content_id` )" .
+ "FROM `".BIT_DB_PREFIX."articles` a " .
+ "LEFT OUTER JOIN `".BIT_DB_PREFIX."article_types` atype ON( atype.`article_type_id` = a.`article_type_id` )".
+ "LEFT OUTER JOIN `".BIT_DB_PREFIX."article_topics` atopic ON( atopic.`topic_id` = a.`topic_id` )".
+ "INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id` = a.`content_id` )" .
"LEFT JOIN `".BIT_DB_PREFIX."users_users` uue ON( uue.`user_id` = tc.`modifier_user_id` )" .
"LEFT JOIN `".BIT_DB_PREFIX."users_users` uuc ON( uuc.`user_id` = tc.`user_id` )" .
- "LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_attachments` tat ON( tat.`attachment_id` = ta.`image_attachment_id` )" .
+ "LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_attachments` tat ON( tat.`attachment_id` = a.`image_attachment_id` )" .
"LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_files` tf ON( tf.`file_id` = tat.`foreign_id` )" .
- "WHERE ta.`$lookupColumn`=?";
+ "WHERE a.`$lookupColumn`=?";
$result = $this->mDb->query( $query, array( $lookupId ) );
global $gBitSystem;
@@ -157,7 +157,7 @@ class BitArticle extends LibertyAttachable {
function store( &$pParamHash ) {
global $gBitSystem;
if( $this->verify( $pParamHash )&& LibertyAttachable::store( $pParamHash ) ) {
- $table = BIT_DB_PREFIX."tiki_articles";
+ $table = BIT_DB_PREFIX."articles";
$this->mDb->StartTrans();
if( $this->isValid() ) {
@@ -169,7 +169,7 @@ class BitArticle extends LibertyAttachable {
// if pParamHash['article_id'] is set, someone is requesting a particular article_id. Use with caution!
$pParamHash['article_store']['article_id'] = $pParamHash['article_id'];
} else {
- $pParamHash['article_store']['article_id'] = $this->mDb->GenID( 'tiki_articles_article_id_seq' );
+ $pParamHash['article_store']['article_id'] = $this->mDb->GenID( 'articles_article_id_seq' );
}
$this->mArticleId = $pParamHash['article_store']['article_id'];
$result = $this->mDb->associateInsert( $table, $pParamHash['article_store'] );
@@ -449,9 +449,9 @@ class BitArticle extends LibertyAttachable {
if( @$this->verifyId( $data['image_attachment_id'] ) ) {
$data['image_attachment_id'] = ( int )$data['image_attachment_id'];
$query = "SELECT tf.storage_path AS image_storage_path
- FROM `".BIT_DB_PREFIX."tiki_attachments` ta
- LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_files` tf ON( tf.file_id = ta.foreign_id )
- WHERE ta.attachment_id=?";
+ FROM `".BIT_DB_PREFIX."tiki_attachments` a
+ LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_files` tf ON( tf.file_id = a.foreign_id )
+ WHERE a.attachment_id=?";
$data['image_storage_path'] = $this->mDb->getOne( $query, array( $data['image_attachment_id'] ) );
$data['image_url'] = BitArticle::getImageUrl( $data );
}
@@ -554,7 +554,7 @@ class BitArticle extends LibertyAttachable {
$ret = FALSE;
if( $this->isValid() ) {
$this->mDb->StartTrans();
- $query = "DELETE FROM `".BIT_DB_PREFIX."tiki_articles` WHERE `content_id` = ?";
+ $query = "DELETE FROM `".BIT_DB_PREFIX."articles` WHERE `content_id` = ?";
$result = $this->mDb->query( $query, array( $this->mContentId ) );
// remove article image if it exists
$this->expungeImage();
@@ -614,17 +614,17 @@ class BitArticle extends LibertyAttachable {
}
if( @$this->verifyId( $pParamHash['status_id'] ) ) {
- $mid .= ( empty( $mid ) ? " WHERE " : " AND " )." ta.`status_id` = ? ";
+ $mid .= ( empty( $mid ) ? " WHERE " : " AND " )." a.`status_id` = ? ";
$bindvars[] = ( int )$pParamHash['status_id'];
}
if( @$this->verifyId( $pParamHash['type_id'] ) ) {
- $mid .= ( empty( $mid ) ? " WHERE " : " AND " )." ta.`article_type_id` = ? ";
+ $mid .= ( empty( $mid ) ? " WHERE " : " AND " )." a.`article_type_id` = ? ";
$bindvars[] = ( int )$pParamHash['type_id'];
}
if( @$this->verifyId( $pParamHash['topic_id'] ) ) {
- $mid .= ( empty( $mid ) ? " WHERE " : " AND " )." ta.`topic_id` = ? ";
+ $mid .= ( empty( $mid ) ? " WHERE " : " AND " )." a.`topic_id` = ? ";
$bindvars[] = ( int )$pParamHash['topic_id'];
} elseif( !empty( $pParamHash['topic'] ) ) {
$mid .= ( empty( $mid ) ? " WHERE " : " AND " )." UPPER( top.`topic_name` ) = ? ";
@@ -637,26 +637,26 @@ class BitArticle extends LibertyAttachable {
// someone better at SQL please get this working without an additional db call - xing
if( empty( $pParamHash['show_expired'] ) ) {
$timestamp = $gBitSystem->getUTCTime();
- $mid .= ( empty( $mid ) ? " WHERE " : " AND " )." ta.`publish_date` < ? AND ta.`expire_date` > ? ";
+ $mid .= ( empty( $mid ) ? " WHERE " : " AND " )." a.`publish_date` < ? AND a.`expire_date` > ? ";
$bindvars[] = ( int )$timestamp;
$bindvars[] = ( int )$timestamp;
}
- $query = "SELECT ta.*, tc.*, top.*, type.*, tas.`status_name`,
+ $query = "SELECT a.*, tc.*, top.*, type.*, astatus.`status_name`,
tf.`storage_path` as `image_storage_path`
- FROM `".BIT_DB_PREFIX."tiki_articles` ta
- INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id` = ta.`content_id` )
- INNER JOIN `".BIT_DB_PREFIX."tiki_article_status` tas ON( tas.`status_id` = ta.`status_id` )
- LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_article_topics` top ON( top.`topic_id` = ta.`topic_id` )
- LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_article_types` type ON( type.`article_type_id` = ta.`article_type_id` )
- LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_attachments` tat ON( tat.`attachment_id` = ta.`image_attachment_id` )
+ FROM `".BIT_DB_PREFIX."articles` a
+ INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id` = a.`content_id` )
+ INNER JOIN `".BIT_DB_PREFIX."article_status` astatus ON( astatus.`status_id` = a.`status_id` )
+ LEFT OUTER JOIN `".BIT_DB_PREFIX."article_topics` top ON( top.`topic_id` = a.`topic_id` )
+ LEFT OUTER JOIN `".BIT_DB_PREFIX."article_types` type ON( type.`article_type_id` = a.`article_type_id` )
+ LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_attachments` tat ON( tat.`attachment_id` = a.`image_attachment_id` )
LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_files` tf ON( tf.`file_id` = tat.`foreign_id` )
".( !empty( $mid ) ? $mid.' AND ' : ' WHERE ' )." tc.`content_type_guid` = '".BITARTICLE_CONTENT_TYPE_GUID."'
ORDER BY ".$this->mDb->convert_sortmode( $pParamHash['sort_mode'] );
- $query_cant = "SELECT COUNT( * )FROM `".BIT_DB_PREFIX."tiki_articles` ta
- INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id` = ta.`content_id` )
- LEFT OUTER JOIN `".BIT_DB_PREFIX."tiki_article_topics` top ON( top.`topic_id` = ta.`topic_id` )
+ $query_cant = "SELECT COUNT( * )FROM `".BIT_DB_PREFIX."articles` a
+ INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id` = a.`content_id` )
+ LEFT OUTER JOIN `".BIT_DB_PREFIX."article_topics` top ON( top.`topic_id` = a.`topic_id` )
".( !empty( $mid )? $mid.' AND ' : ' WHERE ' )." tc.`content_type_guid` = '".BITARTICLE_CONTENT_TYPE_GUID."'";
$result = $this->mDb->query( $query, $bindvars, $pParamHash['max_records'], $pParamHash['offset'] );
@@ -730,7 +730,7 @@ class BitArticle extends LibertyAttachable {
**/
function getStatusList() {
global $gBitSystem;
- $query = "SELECT * FROM `".BIT_DB_PREFIX."tiki_article_status`";
+ $query = "SELECT * FROM `".BIT_DB_PREFIX."article_status`";
$result = $gBitSystem->mDb->query( $query );
return $result->getRows();
}
@@ -755,7 +755,7 @@ class BitArticle extends LibertyAttachable {
}
if( @$this->verifyId( $pArticleId ) ) {
- $sql = "UPDATE `".BIT_DB_PREFIX."tiki_articles` SET `status_id` = ? WHERE `article_id` = ?";
+ $sql = "UPDATE `".BIT_DB_PREFIX."articles` SET `status_id` = ? WHERE `article_id` = ?";
$rs = $this->mDb->query( $sql, array( $pStatusId, $pArticleId ));
return $pStatusId;
}
diff --git a/BitArticleTopic.php b/BitArticleTopic.php
index 514010b..6d84290 100644
--- a/BitArticleTopic.php
+++ b/BitArticleTopic.php
@@ -1,6 +1,6 @@
<?php
/**
- * @version $Header: /cvsroot/bitweaver/_bit_articles/BitArticleTopic.php,v 1.18 2006/01/25 23:40:29 lsces Exp $
+ * @version $Header: /cvsroot/bitweaver/_bit_articles/BitArticleTopic.php,v 1.19 2006/01/31 20:16:24 bitweaver Exp $
* @package article
*/
@@ -40,7 +40,7 @@ class BitArticleTopic extends BitBase {
$bindVars = array((@$this->verifyId($iParamHash['topic_id']) ? (int)$iParamHash['topic_id'] : ($this->mTopicId ? $this->mTopicId : $iParamHash['topic_name'])) );
$sql = "SELECT at.*".
- "FROM `".BIT_DB_PREFIX."tiki_article_topics` at ".
+ "FROM `".BIT_DB_PREFIX."article_topics` at ".
$whereSQL;
$this->mInfo = $this->mDb->getRow($sql, $bindVars);
$this->mTopicId = $this->mInfo['topic_id'];
@@ -98,7 +98,7 @@ class BitArticleTopic extends BitBase {
if ($this->verify($iParamHash)) {
if (!$iParamHash['topic_id']) {
- $topicId = $this->mDb->GenID('tiki_article_topics_t_id_seq');
+ $topicId = $this->mDb->GenID('article_topics_t_id_seq');
} else {
$topicId = $this->mTopicId;
}
@@ -126,10 +126,10 @@ class BitArticleTopic extends BitBase {
}
if( $iParamHash['topic_id'] ) {
- $this->mDb->associateUpdate( BIT_DB_PREFIX."tiki_article_topics", $iParamHash, array( 'name' => 'topic_id', 'value'=> $iParamHash['topic_id'] ) );
+ $this->mDb->associateUpdate( BIT_DB_PREFIX."article_topics", $iParamHash, array( 'name' => 'topic_id', 'value'=> $iParamHash['topic_id'] ) );
} else {
$iParamHash['topic_id'] = $topicId;
- $this->mDb->associateInsert( BIT_DB_PREFIX."tiki_article_topics", $iParamHash );
+ $this->mDb->associateInsert( BIT_DB_PREFIX."article_topics", $iParamHash );
}
}
$this->mTopicId = $iParamHash['topic_id'];
@@ -175,7 +175,7 @@ class BitArticleTopic extends BitBase {
}
$query = "SELECT tat.*
- FROM `".BIT_DB_PREFIX."tiki_article_topics` tat
+ FROM `".BIT_DB_PREFIX."article_topics` tat
$where ORDER BY tat.`topic_name`";
$result = $gBitSystem->mDb->query( $query, array() );
@@ -183,7 +183,7 @@ class BitArticleTopic extends BitBase {
$ret = array();
while( $res = $result->fetchRow() ) {
- $res["num_articles"] = $gBitSystem->mDb->getOne( "SELECT COUNT(*) FROM `".BIT_DB_PREFIX."tiki_articles` WHERE `topic_id`= ?", array( $res["topic_id"] ) );
+ $res["num_articles"] = $gBitSystem->mDb->getOne( "SELECT COUNT(*) FROM `".BIT_DB_PREFIX."articles` WHERE `topic_id`= ?", array( $res["topic_id"] ) );
if( $res['has_topic_image'] == 'y' ) {
$res['topic_image_url'] = BitArticleTopic::getTopicImageStorageUrl( $res['topic_id'] );
}
@@ -199,7 +199,7 @@ class BitArticleTopic extends BitBase {
if( file_exists($this->getTopicImageStoragePath() ) ) {
@unlink( $this->getTopicImageStoragePath() );
}
- $sql = "UPDATE `".BIT_DB_PREFIX."tiki_article_topics` SET `has_topic_image` = 'n' WHERE `topic_id` = ?";
+ $sql = "UPDATE `".BIT_DB_PREFIX."article_topics` SET `has_topic_image` = 'n' WHERE `topic_id` = ?";
$rs = $this->mDb->query($sql, array($this->mTopicId));
$this->mInfo['has_topic_image'] = 'n';
}
@@ -214,7 +214,7 @@ class BitArticleTopic extends BitBase {
}
function setActivation($iIsActive = FALSE) {
- $sql = "UPDATE `".BIT_DB_PREFIX."tiki_article_topics` SET `active` = '".($iIsActive ? 'y' : 'n')."' WHERE `topic_id` = ?";
+ $sql = "UPDATE `".BIT_DB_PREFIX."article_topics` SET `active` = '".($iIsActive ? 'y' : 'n')."' WHERE `topic_id` = ?";
$rs = $this->mDb->query($sql, array($this->mTopicId));
$this->mInfo['active'] = ($iIsActive ? 'y' : 'n');
}
@@ -224,7 +224,7 @@ class BitArticleTopic extends BitBase {
return NULL;
}
- $sql = "SELECT `article_id` FROM `".BIT_DB_PREFIX."tiki_articles` WHERE `topic_id` = ?";
+ $sql = "SELECT `article_id` FROM `".BIT_DB_PREFIX."articles` WHERE `topic_id` = ?";
$rs = $this->mDb->query($sql, array($this->mTopicId));
$ret = array();
@@ -248,11 +248,11 @@ class BitArticleTopic extends BitBase {
$topicArticles[$articleCount]->expunge();
}
} else {
- $sql = "UPDATE `".BIT_DB_PREFIX."tiki_articles` SET `topic_id` = ? WHERE `topic_id` = ?";
+ $sql = "UPDATE `".BIT_DB_PREFIX."articles` SET `topic_id` = ? WHERE `topic_id` = ?";
$rs = $this->mDb->query($sql, array(NULL, $this->mTopicId));
}
- $sql = "DELETE FROM `".BIT_DB_PREFIX."tiki_article_topics` WHERE `topic_id` = ?";
+ $sql = "DELETE FROM `".BIT_DB_PREFIX."article_topics` WHERE `topic_id` = ?";
$rs = $this->mDb->query($sql, array($this->mTopicId));
}
}
diff --git a/BitArticleType.php b/BitArticleType.php
index 8fd569a..dd91e8d 100644
--- a/BitArticleType.php
+++ b/BitArticleType.php
@@ -1,6 +1,6 @@
<?php
/**
- * @version $Header: /cvsroot/bitweaver/_bit_articles/BitArticleType.php,v 1.12 2006/01/26 14:56:29 squareing Exp $
+ * @version $Header: /cvsroot/bitweaver/_bit_articles/BitArticleType.php,v 1.13 2006/01/31 20:16:24 bitweaver Exp $
* @package article
*/
@@ -37,10 +37,10 @@ class BitArticleType extends BitBase
}
if ($this->mTypeId) {
- $sql = "SELECT * FROM `".BIT_DB_PREFIX."tiki_article_types` WHERE `article_type_id` = ?";
+ $sql = "SELECT * FROM `".BIT_DB_PREFIX."article_types` WHERE `article_type_id` = ?";
if( $ret = $this->mDb->getRow( $sql, array( $this->mTypeId ) ) ) {
- $ret['num_articles'] = $this->mDb->getOne('SELECT COUNT(*) FROM `'.BIT_DB_PREFIX.'tiki_articles` WHERE `article_type_id` = ?', array($ret['article_type_id']));
+ $ret['num_articles'] = $this->mDb->getOne('SELECT COUNT(*) FROM `'.BIT_DB_PREFIX.'articles` WHERE `article_type_id` = ?', array($ret['article_type_id']));
}
}
$this->mInfo = $ret;
@@ -98,7 +98,7 @@ class BitArticleType extends BitBase
if ($this->verify($iParamHash)) {
if (!$iParamHash['article_type_id']) {
if (empty($this->mTopicId)) {
- $typeId = $this->mDb->GenID('tiki_article_types_a_t_id_seq');
+ $typeId = $this->mDb->GenID('article_types_a_t_id_seq');
} else {
$typeId = $this->mTopicId;
}
@@ -107,10 +107,10 @@ class BitArticleType extends BitBase
}
if ($iParamHash['article_type_id']) {
- $this->mDb->associateUpdate(BIT_DB_PREFIX."tiki_article_types", $iParamHash, array('name' => 'article_type_id', 'value'=> $iParamHash['article_type_id']));
+ $this->mDb->associateUpdate(BIT_DB_PREFIX."article_types", $iParamHash, array('name' => 'article_type_id', 'value'=> $iParamHash['article_type_id']));
} else {
$iParamHash['article_type_id'] = $typeId;
- $this->mDb->associateInsert(BIT_DB_PREFIX."tiki_article_types", $iParamHash);
+ $this->mDb->associateInsert(BIT_DB_PREFIX."article_types", $iParamHash);
}
}
$this->mTypeId = $iParamHash['article_type_id'];
@@ -128,19 +128,19 @@ class BitArticleType extends BitBase
$iTypeId = (int)($iTypeId);
}
- $sql = "DELETE FROM `".BIT_DB_PREFIX."tiki_article_types` WHERE `article_type_id` = ?";
+ $sql = "DELETE FROM `".BIT_DB_PREFIX."article_types` WHERE `article_type_id` = ?";
$rs = $this->mDb->query($sql, array($iTypeId));
}
function getTypeList() {
global $gBitSystem;
- $query = "SELECT * FROM `" . BIT_DB_PREFIX . "tiki_article_types`";
+ $query = "SELECT * FROM `" . BIT_DB_PREFIX . "article_types`";
$result = $gBitSystem->mDb->query( $query, array() );
$ret = array();
while ( $res = $result->fetchRow() ) {
- $res['article_cnt'] = $gBitSystem->mDb->getOne( "select count(*) from `" . BIT_DB_PREFIX . "tiki_articles` where `article_type_id` = ?", array( $res['article_type_id'] ) );
+ $res['article_cnt'] = $gBitSystem->mDb->getOne( "select count(*) from `" . BIT_DB_PREFIX . "articles` where `article_type_id` = ?", array( $res['article_type_id'] ) );
$ret[] = $res;
}
diff --git a/admin/schema_inc.php b/admin/schema_inc.php
index 7dcc1d1..2cbe94b 100644
--- a/admin/schema_inc.php
+++ b/admin/schema_inc.php
@@ -6,7 +6,7 @@
// replaced type_name with article_type_id
$tables = array(
- 'tiki_articles' => "
+ 'articles' => "
article_id I4 AUTO PRIMARY,
content_id I4 NOTNULL,
description X,
@@ -21,12 +21,12 @@ $tables = array(
status_id I4
",
- 'tiki_article_status' => "
+ 'article_status' => "
status_id I4 PRIMARY,
status_name C(64)
",
- 'tiki_article_types' => "
+ 'article_types' => "
article_type_id I4 AUTO PRIMARY,
type_name C(50),
use_ratings C(1),
@@ -45,9 +45,9 @@ $tables = array(
comment_can_rate_article C(1)
",
- // tiki_topics renamed to tiki_article_topics
+ // tiki_topics renamed to article_topics
// name renamed to topic_name
- 'tiki_article_topics' => "
+ 'article_topics' => "
topic_id I4 AUTO PRIMARY,
topic_name C(40),
has_topic_image C(1),
@@ -74,9 +74,9 @@ $gBitInstaller->registerPackageInfo( ARTICLES_PKG_DIR, array(
// these sequences are automatically generated, but Firebird prefers they exist
$sequences = array (
- 'tiki_article_topics_t_id_seq' => array( 'start' => 1 ),
- 'tiki_article_types_a_t_id_seq' => array( 'start' => 1 ),
- 'tiki_articles_article_id_seq' => array( 'start' => 1 ),
+ 'article_topics_t_id_seq' => array( 'start' => 1 ),
+ 'article_types_a_t_id_seq' => array( 'start' => 1 ),
+ 'articles_article_id_seq' => array( 'start' => 1 ),
);
$gBitInstaller->registerSchemaSequences( ARTICLES_PKG_NAME, $sequences );
@@ -85,15 +85,15 @@ $gBitInstaller->registerSchemaSequences( ARTICLES_PKG_NAME, $sequences );
// $gBitInstaller->registerSchemaIndexes( ARTICLES_PKG_DIR, $indices );
$gBitInstaller->registerSchemaDefault( ARTICLES_PKG_DIR, array(
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_types` (`type_name`) VALUES ('Article')",
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_types` (`type_name`, `use_ratings`) VALUES ('Review','y')",
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_types` (`type_name`, `show_post_expire`) VALUES ('Event','n')",
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_types` (`type_name`, `show_post_expire`,`heading_only`,`allow_comments`) VALUES ('Classified','n','y','n')",
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_status` (`status_id`, `status_name`) VALUES ( 0, 'Denied') ",
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_status` (`status_id`, `status_name`) VALUES (100, 'Draft') ",
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_status` (`status_id`, `status_name`) VALUES (200, 'Pending Approval') ",
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_status` (`status_id`, `status_name`) VALUES (300, 'Approved') ",
- "INSERT INTO `".BIT_DB_PREFIX."tiki_article_status` (`status_id`, `status_name`) VALUES (400, 'Retired') "
+ "INSERT INTO `".BIT_DB_PREFIX."article_types` (`type_name`) VALUES ('Article')",
+ "INSERT INTO `".BIT_DB_PREFIX."article_types` (`type_name`, `use_ratings`) VALUES ('Review','y')",
+ "INSERT INTO `".BIT_DB_PREFIX."article_types` (`type_name`, `show_post_expire`) VALUES ('Event','n')",
+ "INSERT INTO `".BIT_DB_PREFIX."article_types` (`type_name`, `show_post_expire`,`heading_only`,`allow_comments`) VALUES ('Classified','n','y','n')",
+ "INSERT INTO `".BIT_DB_PREFIX."article_status` (`status_id`, `status_name`) VALUES ( 0, 'Denied') ",
+ "INSERT INTO `".BIT_DB_PREFIX."article_status` (`status_id`, `status_name`) VALUES (100, 'Draft') ",
+ "INSERT INTO `".BIT_DB_PREFIX."article_status` (`status_id`, `status_name`) VALUES (200, 'Pending Approval') ",
+ "INSERT INTO `".BIT_DB_PREFIX."article_status` (`status_id`, `status_name`) VALUES (300, 'Approved') ",
+ "INSERT INTO `".BIT_DB_PREFIX."article_status` (`status_id`, `status_name`) VALUES (400, 'Retired') "
) );
// ### Default UserPermissions
generated by cgit v1.3 (git 2.53.0) at 2026-07-02 05:53:59 +0000