wordpress、dedecms和discuz的数据库表结构及其配置文件

mysql> use wp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

mysql> exit;

mysql> exit;

mysql> exit;
其中以pre_ucenter开头的表是ucenter数据库用的，其他的pre_开头的表都是discuz程序自己用的。附discuz的配置文件。

3.1config_global.php
<?php
$_config = array();

// —————————- CONFIG DB —————————– //
$_config[‘db’][‘1’][‘dbhost’] = ‘localhost’;
$_config[‘db’][‘1’][‘dbuser’] = ‘root’;
$_config[‘db’][‘1’][‘dbpw’] = ‘gogogo’;
$_config[‘db’][‘1’][‘dbcharset’] = ‘utf8’;
$_config[‘db’][‘1’][‘pconnect’] = ‘0’;
$_config[‘db’][‘1’][‘dbname’] = ‘discuz’;
$_config[‘db’][‘1’][‘tablepre’] = ‘pre_’;
$_config[‘db’][‘slave’] = ”;
$_config[‘db’][‘common’][‘slave_except_table’] = ”;

// ————————– CONFIG MEMORY ————————— //
$_config[‘memory’][‘prefix’] = ‘q2QrEN_’;
$_config[‘memory’][‘redis’][‘server’] = ”;
$_config[‘memory’][‘redis’][‘port’] = 6379;
$_config[‘memory’][‘redis’][‘pconnect’] = 1;
$_config[‘memory’][‘redis’][‘timeout’] = ‘0’;
$_config[‘memory’][‘redis’][‘requirepass’] = ”;
$_config[‘memory’][‘redis’][‘serializer’] = 1;
$_config[‘memory’][‘memcache’][‘server’] = ”;
$_config[‘memory’][‘memcache’][‘port’] = 11211;
$_config[‘memory’][‘memcache’][‘pconnect’] = 1;
$_config[‘memory’][‘memcache’][‘timeout’] = 1;
$_config[‘memory’][‘apc’] = 1;
$_config[‘memory’][‘xcache’] = 1;
$_config[‘memory’][‘eaccelerator’] = 1;
$_config[‘memory’][‘wincache’] = 1;

// ————————– CONFIG SERVER ————————— //
$_config[‘server’][‘id’] = 1;

// ————————- CONFIG DOWNLOAD ————————– //
$_config[‘download’][‘readmod’] = 2;
$_config[‘download’][‘xsendfile’][‘type’] = ‘0’;
$_config[‘download’][‘xsendfile’][‘dir’] = ‘/down/’;

// ————————– CONFIG OUTPUT ————————— //
$_config[‘output’][‘charset’] = ‘utf-8’;
$_config[‘output’][‘forceheader’] = 1;
$_config[‘output’][‘gzip’] = ‘0’;
$_config[‘output’][‘tplrefresh’] = 1;
$_config[‘output’][‘language’] = ‘zh_cn’;
$_config[‘output’][‘staticurl’] = ‘static/’;
$_config[‘output’][‘ajaxvalidate’] = ‘0’;
$_config[‘output’][‘iecompatible’] = ‘0’;

// ————————– CONFIG COOKIE ————————— //
$_config[‘cookie’][‘cookiepre’] = ‘GHqP_’;
$_config[‘cookie’][‘cookiedomain’] = ”;
$_config[‘cookie’][‘cookiepath’] = ‘/’;

// ————————- CONFIG SECURITY ————————– //
$_config[‘security’][‘authkey’] = ‘0b6a75xqRIY7AF47’;
$_config[‘security’][‘urlxssdefend’] = 1;
$_config[‘security’][‘attackevasive’] = ‘0’;
$_config[‘security’][‘querysafe’][‘status’] = 1;
$_config[‘security’][‘querysafe’][‘dfunction’][‘0’] = ‘load_file’;
$_config[‘security’][‘querysafe’][‘dfunction’][‘1’] = ‘hex’;
$_config[‘security’][‘querysafe’][‘dfunction’][‘2’] = ‘substring’;
$_config[‘security’][‘querysafe’][‘dfunction’][‘3’] = ‘if’;
$_config[‘security’][‘querysafe’][‘dfunction’][‘4’] = ‘ord’;
$_config[‘security’][‘querysafe’][‘dfunction’][‘5’] = ‘char’;
$_config[‘security’][‘querysafe’][‘daction’][‘0’] = ‘@’;
$_config[‘security’][‘querysafe’][‘daction’][‘1’] = ‘intooutfile’;
$_config[‘security’][‘querysafe’][‘daction’][‘2’] = ‘intodumpfile’;
$_config[‘security’][‘querysafe’][‘daction’][‘3’] = ‘unionselect’;
$_config[‘security’][‘querysafe’][‘daction’][‘4’] = ‘(select’;
$_config[‘security’][‘querysafe’][‘daction’][‘5’] = ‘unionall’;
$_config[‘security’][‘querysafe’][‘daction’][‘6’] = ‘uniondistinct’;
$_config[‘security’][‘querysafe’][‘dnote’][‘0’] = ‘/*’;
$_config[‘security’][‘querysafe’][‘dnote’][‘1’] = ‘*/’;
$_config[‘security’][‘querysafe’][‘dnote’][‘2’] = ‘#’;
$_config[‘security’][‘querysafe’][‘dnote’][‘3’] = ‘–‘;
$_config[‘security’][‘querysafe’][‘dnote’][‘4’] = ‘”‘;
$_config[‘security’][‘querysafe’][‘dlikehex’] = 1;
$_config[‘security’][‘querysafe’][‘afullnote’] = ‘0’;

// ————————– CONFIG ADMINCP ————————– //
// ——– Founders: $_config[‘admincp’][‘founder’] = ‘1,2,3’; ——— //
$_config[‘admincp’][‘founder’] = ‘1’;
$_config[‘admincp’][‘forcesecques’] = ‘0’;
$_config[‘admincp’][‘checkip’] = 1;
$_config[‘admincp’][‘runquery’] = ‘0’;
$_config[‘admincp’][‘dbimport’] = 1;

// ————————– CONFIG REMOTE ————————— //
$_config[‘remote’][‘on’] = ‘0’;
$_config[‘remote’][‘dir’] = ‘remote’;
$_config[‘remote’][‘appkey’] = ’62cf0b3c3e6a4c9468e7216839721d8e’;
$_config[‘remote’][‘cron’] = ‘0’;

// ————————— CONFIG INPUT ————————— //
$_config[‘input’][‘compatible’] = 1;
// ——————- THE END ——————– //

3.2config_ucenter.php
<?php
define(‘UC_CONNECT’, ‘mysql’);

define(‘UC_DBHOST’, ‘localhost’);
define(‘UC_DBUSER’, ‘root’);
define(‘UC_DBPW’, ‘gogogo’);
define(‘UC_DBNAME’, ‘discuz’);
define(‘UC_DBCHARSET’, ‘utf8’);
define(‘UC_DBTABLEPRE’, ‘`discuz`.pre_ucenter_’);
define(‘UC_DBCONNECT’, 0);

define(‘UC_CHARSET’, ‘utf-8’);
define(‘UC_KEY’, ‘yef1zdP3O7B4r0L14ap2o80941f83cTdJ5Bedf97x1ten5D0ZcN6t263ufXay77d’);
define(‘UC_API’, ‘http://localhost/discuz/uc_server’);
define(‘UC_APPID’, ‘1’);
define(‘UC_IP’, ”);
define(‘UC_PPP’, 20);
?>