本文整理汇总了PHP中PHPWS_DB::createTable方法的典型用法代码示例。如果您正苦于以下问题：PHP PHPWS_DB::createTable方法的具体用法？PHP PHPWS_DB::createTable怎么用？PHP PHPWS_DB::createTable使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PHPWS_DB的用法示例。
在下文中一共展示了PHPWS_DB::createTable方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: filecabinet_update
//.........这里部分代码省略.........
1.1.0 changes
--------------
+ Fixed authorized check when unpinning folders
+ Images can now be linked to other pages.
+ Resized images can now be linked to their parent image.
+ Clip option moved outside edit_folder permissions when viewing images.
+ Added writable directory check before allowing new folders to be
created.
+ Fixed some error messages in File_Common.
+ Commented out ext variable in File_Common. Doesn\'t appear to be in
use.
+ Created setDirectory function for File_Common. Assures trailing
forward slash on directory name.
+ Removed itemname variable from Document_Manager
+ Added ability to classify uploaded files.
+ New folder class - Multimedia
+ Multimedia files can be clipped and pasted via SmartTags.
</pre>
';
case version_compare($version, '1.2.0', '<'):
$content[] = '<pre>';
$files = array('img/no_image.png', 'conf/config.php', 'conf/video_types.php', 'conf/embedded.php', 'javascript/folder_contents/head.js', 'javascript/clear_image/head.js', 'javascript/clear_image/body.js', 'javascript/pick_image/head.js', 'templates/image_folders.tpl', 'templates/settings.tpl', 'templates/style.css', 'templates/image_view.tpl', 'templates/multimedia_view.tpl', 'templates/style.css', 'img/video_generic.png', 'templates/image_edit.tpl', 'conf/error.php');
fc_updatefiles($files, $content);
if (!PHPWS_Boost::inBranch()) {
$content[] = file_get_contents(PHPWS_SOURCE_DIR . 'mod/filecabinet/boost/changes/1_2_0.txt');
}
$content[] = '</pre>';
case version_compare($version, '1.2.1', '<'):
$content[] = '<pre>';
if (!PHPWS_DB::isTable('filecabinet_pins')) {
$db = new PHPWS_DB('filecabinet_pins');
$db->addValue('key_id', 'int not null default 0');
$db->addValue('folder_id', 'int not null default 0');
if (PHPWS_Error::logIfError($db->createTable())) {
$content[] = 'Failed to create filecabinet_pins table.</pre>';
return false;
}
$content[] = '--- Created filecabinet_pins table.';
}
$files = array('templates/settings.tpl');
fc_updatefiles($files, $content);
if (!PHPWS_Boost::inBranch()) {
$content[] = file_get_contents(PHPWS_SOURCE_DIR . 'mod/filecabinet/boost/changes/1_2_1.txt');
}
$content[] = '</pre>';
case version_compare($version, '1.2.2', '<'):
$content[] = '<pre>';
$files = array('templates/image_edit.tpl');
fc_updatefiles($files, $content);
if (!PHPWS_Boost::inBranch()) {
$content[] = file_get_contents(PHPWS_SOURCE_DIR . 'mod/filecabinet/boost/changes/1_2_2.txt');
}
$content[] = '</pre>';
case version_compare($version, '1.3.0', '<'):
$content[] = '<pre>';
$db = new PHPWS_DB('folders');
if (!$db->isTableColumn('module_created')) {
if (PHPWS_Error::logIfError($db->addTableColumn('module_created', 'varchar(40) default null'))) {
$content[] = '--- Could not create column module_created on folders table.</pre>';
return false;
} else {
$content[] = '--- Created module_created column on folders table.';
}
}
$db = new PHPWS_DB('multimedia');
$result = $db->addTableColumn('thumbnail', 'varchar(255) not null');示例2: createPermissionTable
public static function createPermissionTable($module, $permissions = NULL)
{
$tableName = Users_Permission::getPermissionTableName($module);
$columnSetting = 'smallint NOT NULL default \'0\'';
if (PHPWS_DB::isTable($tableName)) {
return PHPWS_Error::get(USER_ERR_PERM_TABLE, 'users', 'createPermissionTable', 'Table Name: ' . $tableName);
}
$DB = new PHPWS_DB($tableName);
$columns['group_id'] = 'int NOT NULL default \'0\'';
$columns['permission_level'] = 'smallint NOT NULL default \'0\'';
if (isset($permissions)) {
foreach ($permissions as $permission => $description) {
$columns[$permission] =& $columnSetting;
}
}
$DB->addValue($columns);
return $DB->createTable();
}