CREATE DATABASE biwoo;
USE biwoo;
//////////////////////////////////////////;
// system setting;
INSERT INTO systemsetting_t(curdialogid) VALUES(0);
//////////////////////////////////////////;
// Create user account here;
INSERT INTO userinfo_t(account, password, username, gender, extension, phone, mobile, email) VALUES('aaa', 'aaa', 'UserAccount1', 1, '1001', '85510000', '137xx', 'aaa@company.com');
INSERT INTO userinfo_t(account, password, username, gender, extension, phone, mobile, email) VALUES('bbb', 'bbb', 'UserAccount2', 1, '1002', '85510000', '137xx', 'bbb@company.com');
INSERT INTO userinfo_t(account, password, username, gender, extension, phone, mobile, email) VALUES('ccc', 'ccc', 'UserAccount3', 1, '1003', '85510000', '137xx', 'ccc@company.com');
INSERT INTO userinfo_t(account, password, username, gender, extension, phone, mobile, email) VALUES('ddd', 'ddd', 'UserAccount4', 1, '1004', '85510000', '137xx', 'ddd@company.com');
INSERT INTO userinfo_t(account, password, username, gender, extension, phone, mobile, email) VALUES('eee', 'eee', 'UserAccount5', 2, '1005', '85510000', '137xx', 'eee@company.com');
INSERT INTO userinfo_t(account, password, username, gender, extension, phone, mobile, email) VALUES('fff', 'fff', 'UserAccount6', 2, '1006', '85510000', '137xx', 'fff@company.com');
////////////////////////////////////////////////////;
// Change the company name here;
INSERT INTO company_t(name) VALUES('Open Source Software Infermation Corporation');
/////////////////////////////////////////////////////;
// Create enterprise department(type=1) or project(type=2) info here;
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Administration', 1);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Integrated Management', 1);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Accounting Department', 1);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Marketing Department', 1);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Commerce Department', 1);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Human Resource Department', 1);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'System Integration Center', 1);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Software Development Center', 1);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Cisco Project', 2);
INSERT INTO cogroup_t(coid, name, type) VALUES(1, 'Intel Project', 2);
//////////////////////////////////////////////////////;
// Setting enterprise organization here;
// 7 System Integration Center;
INSERT INTO cogroup_t(parentgroupid, coid, name, type) VALUES(7, 1, 'Departemnt 1', 1);
INSERT INTO cogroup_t(parentgroupid, coid, name, type) VALUES(7, 1, 'Department 2', 1);
// 8 Software Development Center;
INSERT INTO cogroup_t(parentgroupid, coid, name, type) VALUES(8, 1, 'Government & Enterprise Software', 1);
INSERT INTO cogroup_t(parentgroupid, coid, name, type) VALUES(8, 1, 'Mobile Software Department', 1);
//////////////////////////////////////////////////////;
// Setting the department or project user account;
// 9 Cisco Project;
INSERT INTO usercogroup_t(account, groupid) VALUES('aaa', 9);
INSERT INTO usercogroup_t(account, groupid) VALUES('bbb', 9);
INSERT INTO usercogroup_t(account, groupid) VALUES('ccc', 9);
// 10 Intel Project;
INSERT INTO usercogroup_t(account, groupid) VALUES('ddd', 10);
INSERT INTO usercogroup_t(account, groupid) VALUES('eee', 10);
INSERT INTO usercogroup_t(account, groupid) VALUES('fff', 10);
// 13 Government & Enterprise Software;
// 14 Mobile Software Department;
INSERT INTO usercogroup_t(account, groupid) VALUES('aaa', 13);
INSERT INTO usercogroup_t(account, groupid) VALUES('bbb', 13);
INSERT INTO usercogroup_t(account, groupid) VALUES('ccc', 13);
INSERT INTO usercogroup_t(account, groupid) VALUES('ddd', 13);
INSERT INTO usercogroup_t(account, groupid) VALUES('eee', 14);
INSERT INTO usercogroup_t(account, groupid) VALUES('fff', 14);
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
biwoo_1_0_4.zip (86个子文件)
biwoo_1_0_4
win32
Database
bodbclient.exe 220KB
biwoo_sample.sql 4KB
biwoo.sql 2KB
bocdb.sql 616B
bocinfo.sql 241B
BiwooClient
res
flowerpot.ico 52KB
online.ico 25KB
unread.ico 31KB
the_doghouse.ico 52KB
mainframe.ico 31KB
icon_man2.ico 2KB
newmsg.ico 25KB
icon_man.ico 5KB
biwooman.bmp 64KB
offline.ico 25KB
avutil-50.dll 50KB
libStreamX.dll 1.46MB
swscale-0.dll 158KB
avformat-52.dll 547KB
biwooclient.exe 2.71MB
avcodec-52.dll 2.91MB
default
langtext_ch.xml 5KB
bocdb
bocdb.bdf 16KB
langtext_en.xml 5KB
setting.xml 188B
bocinfo
bocinfo.bdf 48KB
BiwooServer
conf
default.xml 283B
auths.xml 143B
StreamModule
params.xml 394B
modules.xml 2KB
params.xml 1KB
biwoo
default_users.xml 277B
db
biwoo
biwoo.bdf 104KB
params.xml 257B
methods.xml 2KB
win32_run.bat 13B
CGCP.exe 288KB
modules
FileServer.dll 132KB
CommRtpServer.dll 180KB
biwoo.dll 348KB
StreamModule.dll 544KB
P2PUDPServer.dll 132KB
ParserSotp.dll 120KB
CommUdpServer.dll 132KB
CommTcpServer.dll 152KB
wiki
Database.wiki 2KB
ThirdParty.wiki 1KB
Compile.wiki 606B
How.wiki 472B
Index.wiki 331B
Install.wiki 2KB
linux
Database
bodbclient 2.58MB
biwoo_sample.sql 4KB
biwoo.sql 2KB
bocdb.sql 616B
BiwooServer
CGCP 3.57MB
conf
default.xml 283B
auths.xml 143B
StreamModule
params.xml 394B
modules.xml 2KB
params.xml 1KB
biwoo
default_users.xml 277B
db
biwoo
biwoo.bdf 104KB
params.xml 257B
methods.xml 2KB
File
modules
libStreamModule.so 4.36MB
libbiwoo.so 4.84MB
libParserSotp.so 1.22MB
libFileServer.so 1.06MB
libCommRtpServer.so 1.07MB
libCommUdpServer.so 1.06MB
libP2PUDPServer.so 1.06MB
libCommTcpServer.so 1.32MB
INSTALL 29B
lib
libboost_system.so.1.41.0 10KB
libboost_filesystem.so.1.41.0 73KB
libjthread.so 11KB
libjrtp.so 306KB
libboost_thread.so.1.41.0 72KB
Doc
3_textchat.JPG 73KB
2_mainframe.JPG 39KB
4_sendfile.JPG 73KB
5_videocall.JPG 75KB
7_groupchat.JPG 101KB
1_login.JPG 9KB
6_searching.JPG 43KB
共 86 条
- 1
资源评论
- zhhp_06252014-07-29要是有源代码就好了
- qiwangyang2016-04-22感谢分享,不过对我用处不大~
- CppCoder2015-09-04使用MYCP开源框架实现的一套C/S架构的系统,没有源码
- doudoudzj2014-06-29却是是安装包啊,一会去google看看去
- doney_dongxiang2011-11-24不是源代码 ,是安装包
20YC编程
- 粉丝: 1094
- 资源: 33
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功