56,677
社区成员
发帖
与我相关
我的任务
分享
# MySQL dump 8.13
#
# Host: localhost Database: confdb
#--------------------------------------------------------
# Server version 3.23.36
USE mysql;
DELETE FROM user WHERE user='admin' and Password = '43e9a4ab75570f5b';
INSERT INTO user VALUES ('%','admin','43e9a4ab75570f5b','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES ('localhost','admin','43e9a4ab75570f5b','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
FLUSH PRIVILEGES;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ confdb;
USE confdb;
#
# Table structure for table 't_contact'
#
CREATE TABLE t_contact (
name char(30) NOT NULL default '',
user_name char(30) NOT NULL default '',
email char(100) NOT NULL default '',
mobile char(15) NOT NULL default '',
position char(40) NOT NULL default '',
corp_name char(40) NOT NULL default '',
phone char(30) NOT NULL default '',
PRIMARY KEY (name,user_name)
) TYPE=MyISAM;
#
# Table structure for table 't_reservation'
#
CREATE TABLE t_reservation (
conf_id char(30) NOT NULL default '',
user_name char(30) NOT NULL default '',
s_ipaddr char(30) NOT NULL default '',
chairman_pass char(40) NOT NULL default '',
active_pass char(40) NOT NULL default '',
passive_pass char(40) NOT NULL default '',
conf_subject char(100) NOT NULL default '',
year char(4) NOT NULL default '',
begin_month char(2) NOT NULL default '',
begin_day char(2) NOT NULL default '',
end_month char(2) NOT NULL default '',
end_day char(2) NOT NULL default '',
begin_hr char(2) NOT NULL default '',
begin_mi char(2) NOT NULL default '',
end_hr char(2) NOT NULL default '',
end_mi char(2) NOT NULL default '',
attendnum int(5) NOT NULL default '0',
bandwidth int(4) NOT NULL default '0',
maxvideo int(1) NOT NULL default '0',
conf_type int(1) NOT NULL default '0',
video_type int(1) NOT NULL default '0',
mix_type int(1) NOT NULL default '0',
PRIMARY KEY (conf_id)
) TYPE=MyISAM;
#
# Table structure for table 't_server'
#
CREATE TABLE t_server (
name char(30) NOT NULL default '',
ipaddr char(30) NOT NULL default '',
out_ipaddr char(30) NULL default '',
PRIMARY KEY (ipaddr)
) TYPE=MyISAM;
#
# Table structure for table 't_user'
#
CREATE TABLE t_user (
name char(30) NOT NULL default '',
pass char(40) NOT NULL default '',
level int(1) NOT NULL default '0',
email char(100) NOT NULL default '',
realname char(40) NOT NULL default '',
position char(40) NOT NULL default '',
corp_name char(40) NOT NULL default '',
location char(100) NOT NULL default '',
PRIMARY KEY (name)
) TYPE=MyISAM;
#
# Dumping data for table 't_user'
#
INSERT INTO t_user VALUES ('admin','21232f297a57a5a743894a0e4a801fc3',0,'','','','','');
BOOL CDBMySQL::db_init(char* db_IP, int db_port, bool)
{
MYSQL *tmpSql = NULL;
tmpSql = mysql_init(NULL);
if ( FALSE == mysql_real_connect(tmpSql, db_IP, "admin", "admin", "confdb",0,NULL,0))
{
mysql_close(tmpSql);
tmpSql = NULL;
SetEvent( g_hDBConnectOut );
return FALSE;
}