Source for file _db_schema.inc.php

Documentation is available at _db_schema.inc.php

<?php
/**
* This file holds the b2evo database scheme.
*
* @version $Id: _db_schema.inc.php,v 1.19.2.7 2006/11/30 22:49:30 fplanque Exp $
*/
if( !defined('EVO_MAIN_INIT') ) die( 'Please, do not access this page directly.' );
/**
* The b2evo database scheme.
*
* This gets updated through {@link db_delta()} which generates the queries needed to get
* to this scheme.
*
* Please see {@link db_delta()} for things to take care of.
*
* @global array
*/
global $schema_queries;
$schema_queries = array(
'T_groups' => array(
'Creating table for Groups',
"CREATE TABLE T_groups (
grp_ID int(11) NOT NULL auto_increment,
grp_name varchar(50) NOT NULL default '',
grp_perm_admin enum('none','hidden','visible') NOT NULL default 'visible',
grp_perm_blogs enum('user','viewall','editall') NOT NULL default 'user',
grp_perm_stats enum('none','view','edit') NOT NULL default 'none',
grp_perm_spamblacklist enum('none','view','edit') NOT NULL default 'none',
grp_perm_options enum('none','view','edit') NOT NULL default 'none',
grp_perm_users enum('none','view','edit') NOT NULL default 'none',
grp_perm_templates TINYINT NOT NULL DEFAULT 0,
grp_perm_files enum('none','view','add','edit') NOT NULL default 'none',
PRIMARY KEY grp_ID (grp_ID)
)" ),
'T_coll_user_perms' => array(
'Creating table for Blog-User permissions',
"CREATE TABLE T_coll_user_perms (
bloguser_blog_ID int(11) unsigned NOT NULL default 0,
bloguser_user_ID int(11) unsigned NOT NULL default 0,
bloguser_ismember tinyint NOT NULL default 0,
bloguser_perm_poststatuses set('published','deprecated','protected','private','draft') NOT NULL default '',
bloguser_perm_delpost tinyint NOT NULL default 0,
bloguser_perm_comments tinyint NOT NULL default 0,
bloguser_perm_cats tinyint NOT NULL default 0,
bloguser_perm_properties tinyint NOT NULL default 0,
bloguser_perm_media_upload tinyint NOT NULL default 0,
bloguser_perm_media_browse tinyint NOT NULL default 0,
bloguser_perm_media_change tinyint NOT NULL default 0,
PRIMARY KEY bloguser_pk (bloguser_blog_ID,bloguser_user_ID)
)" ),
'T_settings' => array(
'Creating table for Settings',
"CREATE TABLE T_settings (
set_name VARCHAR( 30 ) NOT NULL ,
set_value VARCHAR( 255 ) NULL ,
PRIMARY KEY ( set_name )
)" ),
'T_users' => array(
'Creating table for Users',
"CREATE TABLE T_users (
user_ID int(11) unsigned NOT NULL auto_increment,
user_login varchar(20) NOT NULL,
user_pass CHAR(32) NOT NULL,
user_firstname varchar(50) NULL,
user_lastname varchar(50) NULL,
user_nickname varchar(50) NULL,
user_icq int(11) unsigned NULL,
user_email varchar(255) NOT NULL,
user_url varchar(255) NULL,
user_ip varchar(15) NULL,
user_domain varchar(200) NULL,
user_browser varchar(200) NULL,
dateYMDhour datetime NOT NULL,
user_level int unsigned DEFAULT 0 NOT NULL,
user_aim varchar(50) NULL,
user_msn varchar(100) NULL,
user_yim varchar(50) NULL,
user_locale varchar(20) DEFAULT 'en-EU' NOT NULL,
user_idmode varchar(20) NOT NULL DEFAULT 'login',
user_allow_msgform TINYINT NOT NULL DEFAULT '1',
user_notify tinyint(1) NOT NULL default 1,
user_showonline tinyint(1) NOT NULL default 1,
user_grp_ID int(4) NOT NULL default 1,
user_validated TINYINT(1) NOT NULL DEFAULT 0,
PRIMARY KEY user_ID (user_ID),
UNIQUE user_login (user_login),
KEY user_grp_ID (user_grp_ID)
)" ),
'T_blogs' => array(
'Creating table for Blogs',
"CREATE TABLE T_blogs (
blog_ID int(11) unsigned NOT NULL auto_increment,
blog_shortname varchar(12) NULL default '',
blog_name varchar(50) NOT NULL default '',
blog_tagline varchar(250) NULL default '',
blog_description varchar(250) NULL default '',
blog_longdesc TEXT NULL DEFAULT NULL,
blog_locale VARCHAR(20) NOT NULL DEFAULT 'en-EU',
blog_access_type VARCHAR(10) NOT NULL DEFAULT 'index.php',
blog_siteurl varchar(120) NOT NULL default '',
blog_staticfilename varchar(30) NULL default NULL,
blog_stub VARCHAR(255) NOT NULL DEFAULT 'stub',
blog_urlname VARCHAR(255) NOT NULL DEFAULT 'urlname',
blog_notes TEXT NULL,
blog_keywords tinytext,
blog_allowcomments VARCHAR(20) NOT NULL default 'post_by_post',
blog_allowtrackbacks TINYINT(1) NOT NULL default 1,
blog_allowpingbacks TINYINT(1) NOT NULL default 0,
blog_allowblogcss TINYINT(1) NOT NULL default 1,
blog_allowusercss TINYINT(1) NOT NULL default 1,
blog_pingb2evonet TINYINT(1) NOT NULL default 0,
blog_pingtechnorati TINYINT(1) NOT NULL default 0,
blog_pingweblogs TINYINT(1) NOT NULL default 0,
blog_pingblodotgs TINYINT(1) NOT NULL default 0,
blog_default_skin VARCHAR(30) NOT NULL DEFAULT 'custom',
blog_force_skin TINYINT(1) NOT NULL default 0,
blog_disp_bloglist TINYINT(1) NOT NULL DEFAULT 1,
blog_in_bloglist TINYINT(1) NOT NULL DEFAULT 1,
blog_links_blog_ID INT(11) NULL DEFAULT NULL,
blog_commentsexpire INT(4) NOT NULL DEFAULT 0,
blog_media_location ENUM( 'default', 'subdir', 'custom', 'none' ) DEFAULT 'default' NOT NULL,
blog_media_subdir VARCHAR( 255 ) NULL,
blog_media_fullpath VARCHAR( 255 ) NULL,
blog_media_url VARCHAR( 255 ) NULL,
blog_UID VARCHAR(20),
PRIMARY KEY blog_ID (blog_ID),
UNIQUE KEY blog_urlname (blog_urlname)
)" ),
'T_coll_settings' => array(
'Creating collection settings table',
"CREATE TABLE T_coll_settings (
cset_coll_ID INT(11) UNSIGNED NOT NULL,
cset_name VARCHAR( 30 ) NOT NULL,
cset_value VARCHAR( 255 ) NULL,
PRIMARY KEY ( cset_coll_ID, cset_name )
)" ),
'T_categories' => array(
'Creating table for Categories',
"CREATE TABLE T_categories (
cat_ID int(11) unsigned NOT NULL auto_increment,
cat_parent_ID int(11) unsigned NULL,
cat_name tinytext NOT NULL,
cat_blog_ID int(11) unsigned NOT NULL default 2,
cat_description VARCHAR(250) NULL DEFAULT NULL,
cat_longdesc TEXT NULL DEFAULT NULL,
cat_icon VARCHAR(30) NULL DEFAULT NULL,
PRIMARY KEY cat_ID (cat_ID),
KEY cat_blog_ID (cat_blog_ID),
KEY cat_parent_ID (cat_parent_ID)
)" ),
'T_posts' => array(
'Creating table for Posts',
"CREATE TABLE T_posts (
post_ID int(11) unsigned NOT NULL auto_increment,
post_parent_ID int(11) unsigned NULL,
post_creator_user_ID int(11) unsigned NOT NULL,
post_lastedit_user_ID int(11) unsigned NULL,
post_assigned_user_ID int(11) unsigned NULL,
post_datestart datetime NOT NULL,
post_datedeadline datetime NULL,
post_datecreated datetime NULL,
post_datemodified datetime NOT NULL,
post_status enum('published','deprecated','protected','private','draft') NOT NULL default 'published',
post_pst_ID int(11) unsigned NULL,
post_ptyp_ID int(11) unsigned NULL,
post_locale VARCHAR(20) NOT NULL DEFAULT 'en-EU',
post_content text NULL,
post_title text NOT NULL,
post_urltitle VARCHAR(50) NULL DEFAULT NULL,
post_url VARCHAR(255) NULL DEFAULT NULL,
post_main_cat_ID int(11) unsigned NOT NULL,
post_flags SET( 'pingsdone', 'imported'),
post_views INT(11) UNSIGNED NOT NULL DEFAULT 0,
post_wordcount int(11) default NULL,
post_comment_status ENUM('disabled', 'open', 'closed') NOT NULL DEFAULT 'open',
post_commentsexpire DATETIME DEFAULT NULL,
post_renderers TEXT NOT NULL,
post_priority int(11) unsigned null,
PRIMARY KEY post_ID( post_ID ),
UNIQUE post_urltitle( post_urltitle ),
INDEX post_datestart( post_datestart ),
INDEX post_main_cat_ID( post_main_cat_ID ),
INDEX post_creator_user_ID( post_creator_user_ID ),
INDEX post_status( post_status ),
INDEX post_parent_ID( post_parent_ID ),
INDEX post_assigned_user_ID( post_assigned_user_ID ),
INDEX post_ptyp_ID( post_ptyp_ID ),
INDEX post_pst_ID( post_pst_ID )
)" ),
'T_postcats' => array(
'Creating table for Categories-to-Posts relationships',
"CREATE TABLE T_postcats (
postcat_post_ID int(11) unsigned NOT NULL,
postcat_cat_ID int(11) unsigned NOT NULL,
PRIMARY KEY postcat_pk (postcat_post_ID,postcat_cat_ID),
UNIQUE catpost ( postcat_cat_ID, postcat_post_ID )
)" ),
'T_comments' => array(
'Creating table for Comments',
"CREATE TABLE T_comments (
comment_ID int(11) unsigned NOT NULL auto_increment,
comment_post_ID int(11) unsigned NOT NULL default '0',
comment_type enum('comment','linkback','trackback','pingback') NOT NULL default 'comment',
comment_status ENUM('published', 'deprecated', 'protected', 'private', 'draft') DEFAULT 'published' NOT NULL,
comment_author_ID int unsigned NULL default NULL,
comment_author varchar(100) NULL,
comment_author_email varchar(255) NULL,
comment_author_url varchar(255) NULL,
comment_author_IP varchar(23) NOT NULL default '',
comment_date datetime NOT NULL,
comment_content text NOT NULL,
comment_karma int(11) NOT NULL default '0',
comment_spam_karma TINYINT NULL,
comment_allow_msgform TINYINT NOT NULL DEFAULT '0',
PRIMARY KEY comment_ID (comment_ID),
KEY comment_post_ID (comment_post_ID),
KEY comment_date (comment_date),
KEY comment_type (comment_type)
)" ),
'T_locales' => array(
'Creating table for Locales',
"CREATE TABLE T_locales (
loc_locale varchar(20) NOT NULL default '',
loc_charset varchar(15) NOT NULL default 'iso-8859-1',
loc_datefmt varchar(10) NOT NULL default 'y-m-d',
loc_timefmt varchar(10) NOT NULL default 'H:i:s',
loc_startofweek TINYINT UNSIGNED NOT NULL DEFAULT 1,
loc_name varchar(40) NOT NULL default '',
loc_messages varchar(20) NOT NULL default '',
loc_priority tinyint(4) UNSIGNED NOT NULL default '0',
loc_enabled tinyint(4) NOT NULL default '1',
PRIMARY KEY loc_locale( loc_locale )
) COMMENT='saves available locales'
" ),
'T_antispam' => array(
'Creating table for Antispam Blacklist',
"CREATE TABLE T_antispam (
aspm_ID bigint(11) NOT NULL auto_increment,
aspm_string varchar(80) NOT NULL,
aspm_source enum( 'local','reported','central' ) NOT NULL default 'reported',
PRIMARY KEY aspm_ID (aspm_ID),
UNIQUE aspm_string (aspm_string)
)" ),
'T_sessions' => array(
'Creating table for active sessions',
"CREATE TABLE T_sessions (
sess_ID INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
sess_key CHAR(32) NULL,
sess_lastseen DATETIME NOT NULL,
sess_ipaddress VARCHAR(15) NOT NULL DEFAULT '',
sess_user_ID INT(10) DEFAULT NULL,
sess_data TEXT DEFAULT NULL,
PRIMARY KEY( sess_ID )
)" ),
'T_usersettings' => array(
'Creating user settings table',
"CREATE TABLE T_usersettings (
uset_user_ID INT(11) UNSIGNED NOT NULL,
uset_name VARCHAR( 30 ) NOT NULL,
uset_value VARCHAR( 255 ) NULL,
PRIMARY KEY ( uset_user_ID, uset_name )
)" ),
'T_itemstatuses' => array(
'Creating table for Post Statuses',
"CREATE TABLE T_itemstatuses (
pst_ID int(11) unsigned not null AUTO_INCREMENT,
pst_name varchar(30) not null,
primary key ( pst_ID )
)" ),
'T_itemtypes' => array(
'Creating table for Post Types',
"CREATE TABLE T_itemtypes (
ptyp_ID int(11) unsigned not null AUTO_INCREMENT,
ptyp_name varchar(30) not null,
primary key (ptyp_ID)
)" ),
'T_files' => array(
'Creating table for File Meta Data',
"CREATE TABLE T_files (
file_ID int(11) unsigned not null AUTO_INCREMENT,
file_root_type enum('absolute','user','group','collection') not null default 'absolute',
file_root_ID int(11) unsigned not null default 0,
file_path varchar(255) not null default '',
file_title varchar(255),
file_alt varchar(255),
file_desc text,
primary key (file_ID),
unique file (file_root_type, file_root_ID, file_path)
)" ),
'T_basedomains' => array(
'Creating table for base domains',
"CREATE TABLE T_basedomains (
dom_ID INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
dom_name VARCHAR(250) NOT NULL DEFAULT '',
dom_status ENUM('unknown','whitelist','blacklist') NOT NULL DEFAULT 'unknown',
dom_type ENUM('unknown','normal','searcheng','aggregator') NOT NULL DEFAULT 'unknown',
PRIMARY KEY (dom_ID),
UNIQUE (dom_name)
)" ),
'T_useragents' => array(
'Creating table for user agents',
"CREATE TABLE T_useragents (
agnt_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
agnt_signature VARCHAR(250) NOT NULL,
agnt_type ENUM('rss','robot','browser','unknown') DEFAULT 'unknown' NOT NULL ,
PRIMARY KEY (agnt_ID)
)" ),
'T_hitlog' => array(
'Creating table for Hit-Logs',
"CREATE TABLE T_hitlog (
hit_ID INT(11) NOT NULL AUTO_INCREMENT,
hit_sess_ID INT UNSIGNED,
hit_datetime DATETIME NOT NULL,
hit_uri VARCHAR(250) DEFAULT NULL,
hit_referer_type ENUM('search','blacklist','referer','direct') NOT NULL,
hit_referer VARCHAR(250) DEFAULT NULL,
hit_referer_dom_ID INT UNSIGNED DEFAULT NULL,
hit_blog_ID int(11) UNSIGNED NULL DEFAULT NULL,
hit_remote_addr VARCHAR(40) DEFAULT NULL,
hit_agnt_ID INT UNSIGNED NULL,
PRIMARY KEY (hit_ID),
INDEX hit_datetime ( hit_datetime ),
INDEX hit_blog_ID (hit_blog_ID)
)" ), // TODO: more indexes?
'T_subscriptions' => array(
'Creating table for subscriptions',
"CREATE TABLE T_subscriptions (
sub_coll_ID int(11) unsigned not null,
sub_user_ID int(11) unsigned not null,
sub_items tinyint(1) not null,
sub_comments tinyint(1) not null,
primary key (sub_coll_ID, sub_user_ID)
)" ),
'T_coll_group_perms' => array(
'Creating table for blog-group permissions',
"CREATE TABLE T_coll_group_perms (
bloggroup_blog_ID int(11) unsigned NOT NULL default 0,
bloggroup_group_ID int(11) unsigned NOT NULL default 0,
bloggroup_ismember tinyint NOT NULL default 0,
bloggroup_perm_poststatuses set('published','deprecated','protected','private','draft') NOT NULL default '',
bloggroup_perm_delpost tinyint NOT NULL default 0,
bloggroup_perm_comments tinyint NOT NULL default 0,
bloggroup_perm_cats tinyint NOT NULL default 0,
bloggroup_perm_properties tinyint NOT NULL default 0,
bloggroup_perm_media_upload tinyint NOT NULL default 0,
bloggroup_perm_media_browse tinyint NOT NULL default 0,
bloggroup_perm_media_change tinyint NOT NULL default 0,
PRIMARY KEY bloggroup_pk (bloggroup_blog_ID,bloggroup_group_ID)
)" ),
'T_links' => array(
'Creating table for Post Links',
"CREATE TABLE T_links (
link_ID int(11) unsigned not null AUTO_INCREMENT,
link_datecreated datetime not null,
link_datemodified datetime not null,
link_creator_user_ID int(11) unsigned not null,
link_lastedit_user_ID int(11) unsigned not null,
link_itm_ID int(11) unsigned NOT NULL,
link_dest_itm_ID int(11) unsigned NULL,
link_file_ID int(11) unsigned NULL,
link_ltype_ID int(11) unsigned NOT NULL default 1,
link_external_url VARCHAR(255) NULL,
link_title TEXT NULL,
PRIMARY KEY (link_ID),
INDEX link_itm_ID( link_itm_ID ),
INDEX link_dest_itm_ID (link_dest_itm_ID),
INDEX link_file_ID (link_file_ID)
)" ),
'T_filetypes' => array(
'Creating table for file types',
'CREATE TABLE T_filetypes (
ftyp_ID int(11) unsigned NOT NULL auto_increment,
ftyp_extensions varchar(30) NOT NULL,
ftyp_name varchar(30) NOT NULL,
ftyp_mimetype varchar(50) NOT NULL,
ftyp_icon varchar(20) default NULL,
ftyp_viewtype varchar(10) NOT NULL,
ftyp_allowed tinyint(1) NOT NULL default 0,
PRIMARY KEY (ftyp_ID)
)' ),
'T_plugins' => array(
'Creating plugins table',
"CREATE TABLE T_plugins (
plug_ID INT(11) UNSIGNED NOT NULL auto_increment,
plug_priority TINYINT NOT NULL default 50,
plug_classname VARCHAR(40) NOT NULL default '',
plug_code VARCHAR(32) NULL,
plug_apply_rendering ENUM( 'stealth', 'always', 'opt-out', 'opt-in', 'lazy', 'never' ) NOT NULL DEFAULT 'never',
plug_version VARCHAR(42) NOT NULL default '0',
plug_status ENUM( 'enabled', 'disabled', 'needs_config', 'broken' ) NOT NULL,
plug_spam_weight TINYINT UNSIGNED NOT NULL DEFAULT 1,
PRIMARY KEY ( plug_ID ),
UNIQUE plug_code( plug_code ),
INDEX plug_status( plug_status )
)" ),
'T_pluginsettings' => array(
'Creating plugin settings table',
'CREATE TABLE T_pluginsettings (
pset_plug_ID INT(11) UNSIGNED NOT NULL,
pset_name VARCHAR( 30 ) NOT NULL,
pset_value TEXT NULL,
PRIMARY KEY ( pset_plug_ID, pset_name )
)' ),
'T_pluginusersettings' => array(
'Creating plugin user settings table',
'CREATE TABLE T_pluginusersettings (
puset_plug_ID INT(11) UNSIGNED NOT NULL,
puset_user_ID INT(11) UNSIGNED NOT NULL,
puset_name VARCHAR( 30 ) NOT NULL,
puset_value TEXT NULL,
PRIMARY KEY ( puset_plug_ID, puset_user_ID, puset_name )
)' ),
'T_pluginevents' => array(
'Creating plugin events table',
'CREATE TABLE T_pluginevents(
pevt_plug_ID INT(11) UNSIGNED NOT NULL,
pevt_event VARCHAR(40) NOT NULL,
pevt_enabled TINYINT NOT NULL DEFAULT 1,
PRIMARY KEY( pevt_plug_ID, pevt_event )
)' ),
'T_cron__task' => array(
'Creating cron tasks table',
'CREATE TABLE T_cron__task(
ctsk_ID int(10) unsigned not null AUTO_INCREMENT,
ctsk_start_datetime datetime not null,
ctsk_repeat_after int(10) unsigned,
ctsk_name varchar(50) not null,
ctsk_controller varchar(50) not null,
ctsk_params text,
primary key (ctsk_ID)
)' ),
'T_cron__log' => array(
'Creating cron tasks table',
'CREATE TABLE T_cron__log(
clog_ctsk_ID int(10) unsigned not null,
clog_realstart_datetime datetime not null,
clog_realstop_datetime datetime,
clog_status enum(\'started\',\'finished\',\'error\',\'timeout\') not null default \'started\',
clog_messages text,
primary key (clog_ctsk_ID)
)' ),
);
/**
* Insert/modify data for a given old DB version.
*
* This function should only be used for creating default data of a table.
*
* It gets called on upgrades and new installs alike.
* $old_db_version is 0 for new installs.
*
* @param integer Old database version number (0 for new installs)
*/
function install_insert_default_data( $old_db_version )
{
global $Group_Admins, $Group_Privileged, $Group_Bloggers, $Group_Users;
global $DB;
if( $old_db_version < 8040 )
{ // upgrade to 0.8.7
echo 'Creating default blacklist entries... ';
$query = "INSERT INTO T_antispam(aspm_string) VALUES ".
"('penis-enlargement'), ('online-casino'), ".
"('order-viagra'), ('order-phentermine'), ('order-xenical'), ".
"('order-prophecia'), ('sexy-lingerie'), ('-porn-'), ".
"('-adult-'), ('-tits-'), ('buy-phentermine'), ".
"('order-cheap-pills'), ('buy-xenadrine'), ('xxx'), ".
"('paris-hilton'), ('parishilton'), ('camgirls'), ('adult-models')";
$DB->query( $query );
echo "OK. \n";
}
if( $old_db_version < 8050 )
{ // upgrade to 0.8.9
echo 'Creating default groups... ';
$Group_Admins = new Group(); // COPY !
$Group_Admins->set( 'name', 'Administrators' );
$Group_Admins->set( 'perm_admin', 'visible' );
$Group_Admins->set( 'perm_blogs', 'editall' );
$Group_Admins->set( 'perm_stats', 'edit' );
$Group_Admins->set( 'perm_spamblacklist', 'edit' );
$Group_Admins->set( 'perm_files', 'edit' );
$Group_Admins->set( 'perm_options', 'edit' );
$Group_Admins->set( 'perm_templates', 1 );
$Group_Admins->set( 'perm_users', 'edit' );
$Group_Admins->dbinsert();
$Group_Privileged = new Group(); // COPY !
$Group_Privileged->set( 'name', 'Privileged Bloggers' );
$Group_Privileged->set( 'perm_admin', 'visible' );
$Group_Privileged->set( 'perm_blogs', 'viewall' );
$Group_Privileged->set( 'perm_stats', 'view' );
$Group_Privileged->set( 'perm_spamblacklist', 'edit' );
$Group_Privileged->set( 'perm_files', 'add' );
$Group_Privileged->set( 'perm_options', 'view' );
$Group_Privileged->set( 'perm_templates', 0 );
$Group_Privileged->set( 'perm_users', 'view' );
$Group_Privileged->dbinsert();
$Group_Bloggers = new Group(); // COPY !
$Group_Bloggers->set( 'name', 'Bloggers' );
$Group_Bloggers->set( 'perm_admin', 'visible' );
$Group_Bloggers->set( 'perm_blogs', 'user' );
$Group_Bloggers->set( 'perm_stats', 'none' );
$Group_Bloggers->set( 'perm_spamblacklist', 'view' );
$Group_Bloggers->set( 'perm_files', 'view' );
$Group_Bloggers->set( 'perm_options', 'none' );
$Group_Bloggers->set( 'perm_templates', 0 );
$Group_Bloggers->set( 'perm_users', 'none' );
$Group_Bloggers->dbinsert();
$Group_Users = new Group(); // COPY !
$Group_Users->set( 'name', 'Basic Users' );
$Group_Users->set( 'perm_admin', 'none' );
$Group_Users->set( 'perm_blogs', 'user' );
$Group_Users->set( 'perm_stats', 'none' );
$Group_Users->set( 'perm_spamblacklist', 'none' );
$Group_Users->set( 'perm_files', 'none' );
$Group_Users->set( 'perm_options', 'none' );
$Group_Users->set( 'perm_templates', 0 );
$Group_Users->set( 'perm_users', 'none' );
$Group_Users->dbinsert();
echo "OK. \n";
}
if( $old_db_version < 9000 )
{ // Upgrade to Phoenix-Alpha
echo 'Creating default Post Types... ';
$DB->query( "
INSERT INTO T_itemtypes ( ptyp_ID, ptyp_name )
VALUES ( 1, 'Post' ),
( 2, 'Link' )" );
echo "OK. \n";
}
if( $old_db_version < 9100 )
{ // Upgrade to Phoenix-Beta
echo 'Creating default file types... ';
// Contribs: feel free to add more types here...
$DB->query( "INSERT INTO T_filetypes VALUES
(1, 'gif', 'GIF image', 'image/gif', 'image2.png', 'image', 1),
(2, 'png', 'PNG image', 'image/png', 'image2.png', 'image', 1),
(3, 'jpg', 'JPEG image', 'image/jpeg', 'image2.png', 'image', 1),
(4, 'txt', 'Text file', 'text/plain', 'document.png', 'text', 1),
(5, 'htm html', 'HTML file', 'text/html', 'html.png', 'browser', 0),
(6, 'pdf', 'PDF file', 'application/pdf', 'pdf.png', 'browser', 1),
(7, 'doc', 'Microsoft Word file', 'application/msword', 'doc.gif', 'external', 1),
(8, 'xls', 'Microsoft Excel file', 'application/vnd.ms-excel', 'xls.gif', 'external', 1),
(9, 'ppt', 'Powerpoint', 'application/vnd.ms-powerpoint', 'ppt.gif', 'external', 1),
(10, 'pps', 'Powerpoint slideshow', 'pps', 'pps.gif', 'external', 1),
(11, 'zip', 'Zip archive', 'application/zip', 'zip.gif', 'external', 1),
(12, 'php php3 php4 php5 php6', 'Php files', 'application/x-httpd-php', 'php.gif', 'download', 0),
(13, 'css', 'Cascading Style Sheet', 'text/css', '', 'text', 1)
" );
echo "OK. \n";
echo 'Giving Administrator Group edit perms on files... ';
$DB->query( 'UPDATE T_groups
SET grp_perm_files = "edit"
WHERE grp_ID = 1' );
echo "OK. \n";
echo 'Giving Administrator Group full perms on media for all blogs... ';
$DB->query( 'UPDATE T_coll_group_perms
SET bloggroup_perm_media_upload = 1,
bloggroup_perm_media_browse = 1,
bloggroup_perm_media_change = 1
WHERE bloggroup_group_ID = 1' );
echo "OK. \n";
if( $old_db_version >= 9000 )
{ // Uninstall all ALPHA (potentially incompatible) plugins
echo 'Uninstalling all existing plugins... ';
$DB->query( 'DELETE FROM T_plugins WHERE 1' );
$DB->query( 'DELETE FROM T_pluginevents WHERE 1' );
$DB->query( 'DELETE FROM T_pluginsettings WHERE 1' );
echo "OK. \n";
}
// NOTE: basic plugins get installed separatly for upgrade and install..
}
if( $old_db_version < 9200 )
{
/*
* CONTRIBUTORS: If you need changes and we haven't started a block for next release yet, put them here!
* Then create a new extension block, and increase db version numbers everywhere where needed in this file.
*/
}
}
/*
nolog */
?>

Multilingual multiuser multiblog engine

Source for file _db_schema.inc.php

Packages