oa数据结构-阿里云开发者社区

开发者社区> 云计算> 正文

oa数据结构

简介:

| flow_query_tpl       |
| flow_rule            |
| flow_run             |
| flow_run_data        |
| flow_run_feedback    |
| flow_run_log         |
| flow_run_prcs        |
| flow_sort            |
| flow_timer           |
| flow_type            |
| hrms                 |
| icqcontact_tb        |
| icqmsgs_tb           |
| icqservermsg_tb      |
| interface            |
| ip_rule              |
| linkman              |
| meeting              |
| meeting_equipment    |
| meeting_room         |
| module_priv          |
| mytable              |
| netchat              |
| netdisk              |
| netmeeting           |
| news                 |
| news_comment         |
| notes                |
| notify               |
| oa_source            |
| oa_source_used       |
| oc_log               |
| office_products      |
| office_task          |
| office_transhistory  |
| order_line           |
| picture              |
| plan_type            |
| product              |
| proj_bug             |
| proj_comment         |
| proj_cost            |
| proj_file            |
| proj_file_log        |
| proj_file_sort       |
| proj_forum           |
| proj_priv            |
| proj_project         |
| proj_task            |
| proj_task_log        |
| provider             |
| provider_linkman     |
| rms_file             |
| rms_lend             |
| rms_roll             |
| rms_roll_room        |
| rsa_keypair          |
| sal_data             |
| sal_flow             |
| sal_item             |
| sale_history         |
| sale_manager         |
| score_date           |
| score_flow           |
| score_group          |
| score_item           |
| seal                 |
| seal_keylic          |
| seal_log             |
| secure_key           |
| service              |
| sms                  |
| sms2                 |
| sms2_priv            |
| sms3                 |
| sms_body             |
| supply_history       |
| supply_order         |
| sys_code             |
| sys_function         |
| sys_log              |
| sys_menu             |
| sys_para             |
| task                 |
| train_apply          |
| train_appoint_muster |
| train_assess_data    |
| train_assess_item    |
| train_assess_title   |
| train_courses        |
| train_ctype          |
| train_info           |
| train_mail           |
| train_manager        |
| train_newcourse      |
| train_survey_data    |
| train_survey_item    |
| train_survey_title   |
| train_teachers       |
| train_ttype          |
| uni1                 |
| unit                 |
| url                  |
| user                 |
| user_group           |
| user_map             |
| user_online          |
| user_priv            |
| vehicle              |
| vehicle_maintenance  |
| vehicle_operator     |
| vehicle_usage        |
| versio1              |
| version              |
| vi_flow_run          |
| vi_user              |
| vote_data            |
| vote_item            |
| vote_title           |
| webmail              |
| wiki_ask             |
| wiki_ask_answer      |
| wiki_comment         |
| wiki_info            |
| winexe               |
| word_model           |
| work_detail          |
| work_person          |
| work_plan            |
| zl_file              |
+----------------------+
190 rows in set (0.02 sec)

mysql> select super_pass from sys_para ;
ERROR 1054 (42S22): Unknown column 'super_pass' in 'field list'
mysql> desc super_pass
    -> ;
ERROR 1146 (42S02): Table 'td_oa.super_pass' doesn't exist
mysql> desc supper_pass
    -> ;
ERROR 1146 (42S02): Table 'td_oa.supper_pass' doesn't exist
mysql> select * from sys_para ;
+---------------------------+---------------------------------------------------------------------------------
------------------------------------------------------------+
| PARA_NAME                 | PARA_VALUE
                                                            |
+---------------------------+---------------------------------------------------------------------------------
------------------------------------------------------------+
| SEC_PASS_FLAG             | 0
                                                            |
| SEC_PASS_TIME             | 30
                                                            |
| SEC_PASS_IMG              | 0
                                                            |
| EMAIL_CAPACITY            | 100
                                                            |
| FOLDER_CAPACITY           | 100
                                                            |
| DUTY_INTERVAL_BEFORE1     | 30
                                                            |
| IP_UNLIMITED_USER         |
                                                            |
| DUTY_INTERVAL_AFTER1      | 10
                                                            |
| NO_DUTY_USER              |
                                                            |
| MEETING_OPERATOR          |
                                                            |
| LOCK_TIME                 |
                                                            |
| SEC_RETRY_BAN             | 1
                                                            |
| SEC_RETRY_TIMES           | 3
                                                            |
| SEC_BAN_TIME              | 10
                                                            |
| DUTY_INTERVAL_BEFORE2     | 10
                                                            |
| DUTY_INTERVAL_AFTER2      | 60
                                                            |
| MEDIA_REAL_TYPE           | rm,rmvb,ram,ra,mpa,mpv,mps,m2v,m1v,mpe,mov,smi,
                                                            |
| MEDIA_MS_TYPE             | wmv,asf,mp3,mpg,mpeg,mp4,avi,wmv,wma,wav,dat,
                                                            |
| TOP_MENU_NUM              | 5
                                                            |
| SMS_REMIND                | 1,2,3,4,5,6,7,8,9,11,12,13,14,15,16,17,18,19,20,||1,2,3,4,5,6,7,40,41,8,9,11,12,
13,14,15,16,17,18,19,20,22,30,31,32,33,35,34,42,37,43,44,45 |
| SEC_PASS_MIN              | 6
                                                            |
| SEC_PASS_MAX              | 20
                                                            |
| SEC_PASS_SAFE             | 1
                                                            |
| SEC_USER_MEM              | 1
                                                            |
| STATUS_TEXT_MARQUEE       | 60
                                                            |
| SEC_KEY_USER              | 1
                                                            |
| LOGIN_KEY                 | 0
                                                            |
| HRMS_OPEN_FIELDS          |
                                                            |
| SEC_USE_RTX               | 0
                                                            |
| SEC_SHOW_IP               | 1
                                                            |
| SEC_ON_STATUS             | 1
                                                            |
| FLOW_REMIND_TIME          | 2007-11-16 14:46:34
                                                            |
| DESKTOP_SELF_DEFINE       | POS,WIDTH,LINES,SCROLL,EXPAND,
                                                            |
| DESKTOP_LEFT_WIDTH        | 65
                                                            |
| MENU_DISPLAY              |
                                                            |
| MENU_EXPAND_SINGLE        | 1
                                                            |
| SEC_INIT_PASS             | 0
                                                            |
| SEC_OC_MARK               | 0
                                                            |
| NOTIFY_AUDITING_SINGLE    | 1
                                                            |
| NOTIFY_AUDITING_ALL       | bailiu,
                                                            |
| NOTIFY_AUDITING_PART      |
                                                            |
| RETIRE_AGE                | 60,55
                                                            |
| PAGE_BAR_SIZE             | a:0:{}
                                                            |
| SEC_OC_REVISION           | 0
                                                            |
| ONLINE_VIEW               | 1
                                                            |
| IM_WINDOW_CAPTION         | OA精灵
                                                            |
| ORG_UPDATE                | 2010-03-16 17:25:53
                                                            |
| MYTABLE_BKGROUND          | 500
                                                            |
| SUPER_PASS                | $1$9o/.cT4.$v.sAv8AasyiRCv1zeu8kU0
                                                            |
| LOG_OUT_TEXT              | 离开OA ……
                                                            |
| NOTIFY_TOP_DAYS           |
                                                            |
| NOTIFY_AUDITING_EXCEPTION | bailiu,
                                                            |
| FLOW_REMIND_BEFORE        | 15m
                                                            |
| FLOW_REMIND_AFTER         | 1d
                                                            |
| SEAL_FROM                 | 1
                                                            |
| WORD_SEAL                 | 0
                                                            |
| VMEET_NEW_PRIV            | admin,
                                                            |
| LOGIN_SECURE_KEY          | 0
                                                            |
| LOGIN_RSA_PASS            | 0
                                                            |
| TASK_SVC_VERSION          | 20090716
                                                            |
| BACKUP_DATABASES          | TD_OA,
                                                            |
| MIIBEIAN                  |
                                                            |
| LOGIN_USE_DOMAIN          | 0
                                                            |
| DOMAIN_SYNC_CONFIG        | a:3:{s:8:\"DISABLED\";s:1:\"0\";s:9:\"USER_PRIV\";s:1:\"0\";s:9:\"NOT_LOGIN\";s:
1:\"0\";}                                                   |
| ADDRESS_SHOW_FIELDS       | PSN_NO,PSN_NAME,DEPT_NAME,TEL_NO_DEPT,MOBIL_NO,OICQ_NO,|排序号,姓名,单位名称,工
作电话,手机,QQ号码,                                          |
| IM_SVC_VERSION            | 20090907
                                                            |
+---------------------------+---------------------------------------------------------------------------------
------------------------------------------------------------+
66 rows in set (0.00 sec)

mysql> select SUPER_PASS from sys_para ;
ERROR 1054 (42S22): Unknown column 'SUPER_PASS' in 'field list'
mysql> desc sys_para;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| PARA_NAME  | varchar(200) | NO   | PRI |         |       |
| PARA_VALUE | text         | NO   |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> update sys_para set para_value='$1$UM..Nj..$2EU3Hqj76TpoUA614VeiG1' where PARA_NAME='SUPER_PASS';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql>










本文转自 jxwpx 51CTO博客,原文链接:http://blog.51cto.com/jxwpx/284528,如需转载请自行联系原作者

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
云计算
使用钉钉扫一扫加入圈子
+ 订阅

时时分享云计算技术内容,助您降低 IT 成本,提升运维效率,使您更专注于核心业务创新。

其他文章