Context Navigation

← Previous Ticket
Next Ticket →

Ticket #19 (closed 优化: 已处理)

Last modified 12 years ago

数据库自动初始化

Reported by:	qinhongyuan	Owned by:	qinhongyuan
Priority:	重要的（3）	Milestone:
Component:	核心模块	Version:
Keywords:	数据库自动初始化	Cc:
Due Date:	01/11/2012

Description

为开发数据库提供最基本的数据，使开发环境能够正常运行，同时减少数据库空间压力

Change History

comment:1 Changed 14 years ago by qinhongyuan

第一次导表

Sec_acl
Sec_function
Sec_log_detail
Sec_role
Sec_role_function
Sec_session
Bbs6_usergroup
Bbs6_usergroup_item
Bbs6_user_rights
Bbs6_forumdetail
Bbs6_forum
Bbs6_domain_prop
Bbs6_domain_prop_item
Bbs6_config_items
Bbs6_configgroup
Bbs6_configgroup_item

comment:2 Changed 14 years ago by qinhongyuan

第二次导表

bbs6_htmlblock

Last edited 14 years ago by qinhongyuan (previous) (diff)

comment:3 Changed 14 years ago by qinhongyuan

清空用户表即可（oracle）
管理员需要在前台登录完以后才能在后台登陆

comment:4 Changed 14 years ago by qinhongyuan

还需要表

   bbs6_forum_index

comment:5 Changed 14 years ago by qinhongyuan

comment:6 Changed 14 years ago by qinhongyuan

mysql初始化管理员数据

insert into `bbs6_forum_admin` (`forumid`, `userid`, `usergroupid`, `createat`, `createbyid`, `logid`) values('1','826717','10','2012-07-04 16:07:17','826717','1');

#各网的application都不一样的，请注意
insert into `sec_acl` (`resource_id`, `role_id`, `user_id`, `application`, `account_id`) values('ROOT','12','24300','bbs6','826717');

Last edited 14 years ago by qinhongyuan (previous) (diff)

comment:7 Changed 14 years ago by qinhongyuan

oracle 初始化数据

Insert into BBS6_USER (USERID,NAME,CREATEAT,NICKNAME,POSTCOUNT,PICKCOUNT,SCORE,CONTRIBUTION,TOPICCOUNT,LASTPOSTAT,LOCKED,SIGNSTATUS,VIEWSIGN,HINTMESSAGE,PROPNUM,PROPSTR,MEDALS,MAXADMINROLE,EXSCORE1,EXSCORE2,EXSCORE3,EXSCORE4,EXSCORE5,ACTIVED,VIP) values (826717,'fit10',to_timestamp('01-4月 -12','DD-MON-RR HH.MI.SSXFF AM'),'fit10',3,0,19,18,3,to_timestamp('04-7月 -12','DD-MON-RR HH.MI.SSXFF AM'),0,0,1,0,null,null,null,'站长',0,0,0,0,0,0,null);

comment:8 Changed 14 years ago by kuangjuhuan

电脑网数据库初始化：

oracle初始化管理员数据:

insert into `sec_acl` (`resource_id`, `role_id`, `user_id`, `application`, `account_id`) values('ROOT','12','24300','itbbs','826717');
insert into SEC_ROLE (ID,NAME,DESCRIPTION,RANK,APPLICATION,DISPLAY_ORDER) values (12,'站长','前台管理角色，管理论坛前台所有功能',0,'itbbs',0);

oracle，需要导入itbbs、soft、cafe三个库，否则会报ORA-00942: table or view does not exist或者PL/SQL: could not find program unit being called: "BBS6_IT_APP.PKG_SCORE"等错误。
oracle初始化数据：
需要导入数据：
bbs6_user表：

Insert into BBS6_USER (USERID,NAME,CREATEAT,NICKNAME,POSTCOUNT,PICKCOUNT,SCORE,CONTRIBUTION,TOPICCOUNT,LASTPOSTAT,LOCKED,SIGNSTATUS,VIEWSIGN,HINTMESSAGE,PROPNUM,PROPSTR,MEDALS,MAXADMINROLE,EXSCORE1,EXSCORE2,EXSCORE3,EXSCORE4,EXSCORE5,ACTIVED,VIP) values (826717,'fit10',to_timestamp('01-4月 -12','DD-MON-RR HH.MI.SSXFF AM'),'fit10',3,0,19,18,3,to_timestamp('04-7月 -12','DD-MON-RR HH.MI.SSXFF AM'),0,0,1,0,null,null,null,'站长',0,0,0,0,0,0,null);

bbs6_keygen表:

Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_pi_rule_group_product',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_pi_forum_product',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_contribution_log',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_favorite',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_forum',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_grade_log',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_htmlblock',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_iplock',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_keyword',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_lock',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_log',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_medal',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_medal_log',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_pi_forum',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_pi_rule',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_pi_rule_group',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_post',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_report',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_score_log',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_top',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_topic',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_vote_item',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_vote_result',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_attachment',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_activity',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_activity_item',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_outside_top',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_rest',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_app',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_recommendations_cms',1000);
Insert into BBS6_KEYGEN (TABLE_NAME,LAST_USED_ID) values ('bbs6_recommendations_user',1000);

Last edited 14 years ago by kuangjuhuan (previous) (diff)

comment:9 Changed 14 years ago by kuangjuhuan

现在电脑网新的测试库地址：

mysql：

    <database jndi-name="jdbc/itbbs">
            <driver 
                user="bbs_it_app" password="bbs_it_app" 
                url="jdbc:mysql://192.168.75.100:3306/bbs_it_app_test?useUnicode=true&amp;characterEncoding=GBK&amp;zeroDateTimeBehavior=convertToNull" 
                type="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"/>
    </database>

oracle：

       <database>
           <jndi-name>jdbc/itbbsUser</jndi-name>
           <driver type="oracle.jdbc.pool.OracleConnectionPoolDataSource">
             <url>jdbc:oracle:thin:@192.168.75.100:1521:testdb</url>
             <user>bbs6_it_app</user>
             <password>bbs6_it_app</password>
            </driver>
        </database>

另外，soft和cafe的用户名和密码是：
bbs6_soft_app/bbs6_soft_app
bbs6_cafe_app/bbs6_cafe_app

comment:10 Changed 14 years ago by qinhongyuan

由于基础数据是线上的，那domain_prop的数据需要改成我们测试环境的。。。

comment:11 Changed 14 years ago by dingjianyong

家居网新测试库地址：
mysql：

<database jndi-name="jdbc/bbs6">
     <driver user="bbs_app" 
             password="bbs_app" 
             url="jdbc:mysql://192.168.75.100/bbs6_house_app_test?useUnicode=true&amp;characterEncoding=GBK&amp;zeroDateTimeBehavior=convertToNull"    
             type="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"/>
</database>

oracle:

<database>
        <jndi-name>jdbc/bbs6User</jndi-name>
        <driver type="oracle.jdbc.pool.OracleConnectionPoolDataSource">
        <url>jdbc:oracle:thin:@192.168.75.100:1521:testdb</url>
        <user>housebbs6_test</user>
        <password>housebbs6_test</password>
        </driver>
</database>

亲子网新测试库地址：
mysql：

<database jndi-name="jdbc/bbs6">
   <driver  user="bbs_app" 
	    password="bbs_app"
            url="jdbc:mysql://192.168.75.100/bbs6_kids_app_test?useUnicode=true&amp;characterEncoding=GBK&amp;zeroDateTimeBehavior=convertToNull" 
            type="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"/>
</database>

oracle：

<database>
       <jndi-name>jdbc/bbs6User</jndi-name>
       <driver type="oracle.jdbc.pool.OracleConnectionPoolDataSource">
       <url>jdbc:oracle:thin:@192.168.75.100:1521:testdb</url>
       <user>kidsbbs6_test</user>
       <password>kidsbbs6_test</password>
       </driver>
</database>

女性网新测试库地址：
mysql：

<database jndi-name="jdbc/bbs6">
       <driver  user="bbs_lady_app" 
	        password="bbs_lady_app"
                url="jdbc:mysql://192.168.75.100/bbs_lady_app_test?useUnicode=true&amp;characterEncoding=GBK&amp;zeroDateTimeBehavior=convertToNull" 
                type="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"/>
        </database>

oracle：

<database>
       <jndi-name>jdbc/bbs6User</jndi-name>
       <driver type="oracle.jdbc.pool.OracleConnectionPoolDataSource">
       <url>jdbc:oracle:thin:@192.168.75.100:1521:testdb</url>
       <user>ladybbs6_test</user>
       <password>ladybbs6_test</password>
       </driver>
</database>

Last edited 14 years ago by dingjianyong (previous) (diff)

comment:12 Changed 12 years ago by dingjianyong

Cc qinhongyuan, wanganning removed
Status changed from new to closed
Resolution set to 已处理

Note: See TracTickets for help on using tickets.

Download in other formats: