ygtx_oa/相关文档/数据库清理/oa_data_clean.sql

TRUNCATE TABLE ams_archive_finance;
TRUNCATE TABLE ams_archive_info;
TRUNCATE TABLE ams_archive_info_history;
TRUNCATE TABLE ams_attach_convert;
TRUNCATE TABLE ams_borrow;
TRUNCATE TABLE ams_borrow_detail;
TRUNCATE TABLE ams_flow_extract;
TRUNCATE TABLE ams_flow_file;
TRUNCATE TABLE ams_op_log;
TRUNCATE TABLE android_contact;
TRUNCATE TABLE archive_cert;
TRUNCATE TABLE asset;
TRUNCATE TABLE asset_change;
TRUNCATE TABLE asset_dep_record;
TRUNCATE TABLE asset_depreciation_info;
TRUNCATE TABLE asset_depreciation_information;
TRUNCATE TABLE asset_employ;
TRUNCATE TABLE asset_employ_record;
TRUNCATE TABLE asset_flow_direction;
TRUNCATE TABLE asset_fundsource;
TRUNCATE TABLE asset_loan;
TRUNCATE TABLE asset_return;
TRUNCATE TABLE asset_return_record;
TRUNCATE TABLE asset_scrap;
TRUNCATE TABLE asset_status;
TRUNCATE TABLE asset_stock_record;
TRUNCATE TABLE asset_takestock;
TRUNCATE TABLE asset_takestock_detail;
TRUNCATE TABLE asset_takestock_plan;
TRUNCATE TABLE asset_takestock_plan_detail;
TRUNCATE TABLE asset_two_dimension;
TRUNCATE TABLE asset_type;
TRUNCATE TABLE asset_yearschange;
TRUNCATE TABLE bpm_authorized_history;
TRUNCATE TABLE bpm_authorized_info;
TRUNCATE TABLE bpm_authorized_ins;
TRUNCATE TABLE bpm_code_record;
TRUNCATE TABLE bpm_file;
TRUNCATE TABLE bpm_flow_copy;
TRUNCATE TABLE bpm_flow_duban;
TRUNCATE TABLE bpm_flow_ins_data;
TRUNCATE TABLE bpm_flow_ins_deal;
TRUNCATE TABLE bpm_flow_instance;
TRUNCATE TABLE bpm_flow_urge;
TRUNCATE TABLE bpm_form_sealhistory;
TRUNCATE TABLE bpm_form_sealinfo;
TRUNCATE TABLE bpm_seal_info;
TRUNCATE TABLE bpm_tache_instance;
TRUNCATE TABLE bpm_task;
TRUNCATE TABLE bpm_task_dialog;
TRUNCATE TABLE bpm_time_remind;
TRUNCATE TABLE bpm_zxlc_linkuser;
TRUNCATE TABLE bpm_zxlc_record;
TRUNCATE TABLE contract;
TRUNCATE TABLE contract_borrow;
TRUNCATE TABLE contract_borrow_detail;
TRUNCATE TABLE contract_company;
TRUNCATE TABLE contract_milestone;
TRUNCATE TABLE contract_record;
TRUNCATE TABLE contract_relation;
TRUNCATE TABLE contract_termination;
TRUNCATE TABLE contract_warn;
TRUNCATE TABLE face_record;
TRUNCATE TABLE fm_account;
TRUNCATE TABLE fm_account_detail;
TRUNCATE TABLE fm_account_trade;
TRUNCATE TABLE fm_allot;
TRUNCATE TABLE fm_bill;
TRUNCATE TABLE fm_blank;
TRUNCATE TABLE fm_expenditure_statement;
TRUNCATE TABLE fm_expenditure_statement_detail;
TRUNCATE TABLE fm_income_plan;
TRUNCATE TABLE fm_income_statement;
TRUNCATE TABLE fm_income_statement_detail;
TRUNCATE TABLE fm_pay_subject_detail;
TRUNCATE TABLE fm_project_bonus_apply;
TRUNCATE TABLE fm_project_bonus_apply_staff;
TRUNCATE TABLE fm_salary_send;
TRUNCATE TABLE fm_salary_send_detail;
TRUNCATE TABLE hr_attendance_holiday;
TRUNCATE TABLE hr_attendance_leave_record;
TRUNCATE TABLE hr_attendance_record;
TRUNCATE TABLE hr_attendance_record_result;
TRUNCATE TABLE hr_attendance_schedule;
TRUNCATE TABLE hr_by_people_info;
TRUNCATE TABLE hr_company_qualification;
TRUNCATE TABLE hr_contract;
TRUNCATE TABLE hr_dimission;
TRUNCATE TABLE hr_dimission_personnel;
TRUNCATE TABLE hr_duty_notification;
TRUNCATE TABLE hr_duty_notification_detail;
TRUNCATE TABLE hr_employ_education_info;
TRUNCATE TABLE hr_employ_family_members;
TRUNCATE TABLE hr_employ_record;
TRUNCATE TABLE hr_employ_staff;
TRUNCATE TABLE hr_employ_work_experience;
TRUNCATE TABLE hr_interview;
TRUNCATE TABLE hr_interview_result;
TRUNCATE TABLE hr_log;
TRUNCATE TABLE hr_office_guide;
TRUNCATE TABLE hr_office_guide_read;
TRUNCATE TABLE hr_other_card;
TRUNCATE TABLE hr_pfm_assess_group;
TRUNCATE TABLE hr_pfm_assess_info;
TRUNCATE TABLE hr_pfm_assess_record;
TRUNCATE TABLE hr_pfm_assess_record_info;
TRUNCATE TABLE hr_pfm_scheme;
TRUNCATE TABLE hr_pfm_scheme_detail;
TRUNCATE TABLE hr_pfm_target;
TRUNCATE TABLE hr_pfm_task;
TRUNCATE TABLE hr_pfm_task_detail;
TRUNCATE TABLE hr_pfm_task_plan;
TRUNCATE TABLE hr_pfm_task_to_peole;
TRUNCATE TABLE hr_position;
TRUNCATE TABLE hr_position_mgr;
TRUNCATE TABLE hr_resume_log;
TRUNCATE TABLE hr_resume_read_record;
TRUNCATE TABLE hr_rewards;
TRUNCATE TABLE hr_salary_count;
TRUNCATE TABLE hr_salary_count_detail;
TRUNCATE TABLE hr_salary_insurance_count;
TRUNCATE TABLE hr_salary_insurance_count_detail;
TRUNCATE TABLE hr_salary_insurance_history;
TRUNCATE TABLE hr_salary_insurance_history_detail;
TRUNCATE TABLE hr_salary_insurance_history_log;
TRUNCATE TABLE hr_salary_level;
TRUNCATE TABLE hr_salary_level_grade;
TRUNCATE TABLE hr_salary_level_grade_detail;
TRUNCATE TABLE hr_salary_pay_detail;
TRUNCATE TABLE hr_salary_pay_info;
TRUNCATE TABLE hr_salary_project;
TRUNCATE TABLE hr_salary_send;
TRUNCATE TABLE hr_salary_staff_insurance;
TRUNCATE TABLE hr_salary_staff_level;
TRUNCATE TABLE hr_salary_tax;
TRUNCATE TABLE hr_self_appraisal;
TRUNCATE TABLE hr_staff_education_info;
TRUNCATE TABLE hr_staff_position;
TRUNCATE TABLE hr_staff_salary_count;
TRUNCATE TABLE hr_staff_self_appraisal;
TRUNCATE TABLE hr_staff_work_experience;
TRUNCATE TABLE hr_summarize;
TRUNCATE TABLE hr_to_people_info;
TRUNCATE TABLE hr_train_agency;
TRUNCATE TABLE hr_train_apply;
TRUNCATE TABLE hr_train_course;
TRUNCATE TABLE hr_train_demand_survey;
TRUNCATE TABLE hr_train_demand_survey_detail;
TRUNCATE TABLE hr_train_demand_survey_object;
TRUNCATE TABLE hr_train_demand_survey_object_detail;
TRUNCATE TABLE hr_train_imple_train_assess;
TRUNCATE TABLE hr_train_imple_train_course;
TRUNCATE TABLE hr_train_imple_trainees;
TRUNCATE TABLE hr_train_imple_violation_record;
TRUNCATE TABLE hr_train_implement;
TRUNCATE TABLE hr_train_location;
TRUNCATE TABLE hr_train_plan;
TRUNCATE TABLE hr_train_teacher;
TRUNCATE TABLE hr_transfer_position_record;
TRUNCATE TABLE hr_turn_formal;
TRUNCATE TABLE oa_access_dept_job;
TRUNCATE TABLE oa_access_dept_job_detail;
TRUNCATE TABLE oa_access_dept_job_scoreperson;
TRUNCATE TABLE oa_access_performance;
TRUNCATE TABLE oa_access_performance_detail;
TRUNCATE TABLE oa_addbook;
TRUNCATE TABLE oa_addbook_group;
TRUNCATE TABLE oa_appliance;
TRUNCATE TABLE oa_appliance_borrow;
TRUNCATE TABLE oa_appliance_info;
TRUNCATE TABLE oa_appliance_my_info;
TRUNCATE TABLE oa_appliance_stock;
TRUNCATE TABLE oa_arch;
TRUNCATE TABLE oa_assess;
TRUNCATE TABLE oa_assess_detail;
TRUNCATE TABLE oa_attend;
TRUNCATE TABLE oa_attend_check;
TRUNCATE TABLE oa_attend_holiday;
TRUNCATE TABLE oa_attend_info;
TRUNCATE TABLE oa_attend_rule;
TRUNCATE TABLE oa_base_station;
TRUNCATE TABLE oa_bdqxz;
TRUNCATE TABLE oa_bill;
TRUNCATE TABLE oa_bill_folder;
TRUNCATE TABLE oa_bill_folder_auth;
TRUNCATE TABLE oa_bless_birthday;
TRUNCATE TABLE oa_bless_festival;
TRUNCATE TABLE oa_car;
TRUNCATE TABLE oa_doc;
TRUNCATE TABLE oa_document;
TRUNCATE TABLE oa_document_receive;
TRUNCATE TABLE oa_duty;
TRUNCATE TABLE oa_duty_detail;
TRUNCATE TABLE oa_fire_doc;
TRUNCATE TABLE oa_fire_doc_folder;
TRUNCATE TABLE oa_forum;
TRUNCATE TABLE oa_forum_comment;
TRUNCATE TABLE oa_forum_type;
TRUNCATE TABLE oa_group_independent;
TRUNCATE TABLE oa_mail_user;
TRUNCATE TABLE oa_mail_user_uids;
TRUNCATE TABLE oa_meeting;
TRUNCATE TABLE oa_meeting_room;
TRUNCATE TABLE oa_meeting_room_apply;
TRUNCATE TABLE oa_meeting_user;
TRUNCATE TABLE oa_narrowband;
TRUNCATE TABLE oa_news;
TRUNCATE TABLE oa_news_comment;
TRUNCATE TABLE oa_news_user;
TRUNCATE TABLE oa_online_office;
TRUNCATE TABLE oa_regulation;
TRUNCATE TABLE oa_regulation_type;
TRUNCATE TABLE oa_schedule;
TRUNCATE TABLE oa_schedule_purview;
TRUNCATE TABLE oa_send_salary_info;
TRUNCATE TABLE oa_send_salary_log;
TRUNCATE TABLE oa_signet;
TRUNCATE TABLE oa_student_class;
TRUNCATE TABLE oa_student_info;
TRUNCATE TABLE oa_supplies;
TRUNCATE TABLE oa_supplies_borrow;
TRUNCATE TABLE oa_supplies_info;
TRUNCATE TABLE oa_supplies_my_info;
TRUNCATE TABLE oa_supplies_sort;
TRUNCATE TABLE oa_supplies_stock;
TRUNCATE TABLE oa_work_plan;
TRUNCATE TABLE pm_bug_feedback;
TRUNCATE TABLE pm_bug_info;
TRUNCATE TABLE pm_check_workdiary;
TRUNCATE TABLE pm_credit_from;
TRUNCATE TABLE pm_feedback;
TRUNCATE TABLE pm_middl_flow;
TRUNCATE TABLE pm_milepost_info;
TRUNCATE TABLE pm_module_info;
TRUNCATE TABLE pm_project_buy;
TRUNCATE TABLE pm_project_cost;
TRUNCATE TABLE pm_project_count;
TRUNCATE TABLE pm_project_finish_apply;
TRUNCATE TABLE pm_project_info;
TRUNCATE TABLE pm_question;
TRUNCATE TABLE pm_receive_task;
TRUNCATE TABLE pm_reminders_diary;
TRUNCATE TABLE pm_risk;
TRUNCATE TABLE pm_statistics_author;
TRUNCATE TABLE pm_task;
TRUNCATE TABLE pm_task_android;
TRUNCATE TABLE pm_task_back;
TRUNCATE TABLE pm_task_comment;
TRUNCATE TABLE pm_task_doc;
TRUNCATE TABLE pm_taskcenter_job_log;
TRUNCATE TABLE pm_team_member;
TRUNCATE TABLE pm_untask_log;
TRUNCATE TABLE pm_work_diary;
TRUNCATE TABLE product;
TRUNCATE TABLE product_type;
TRUNCATE TABLE recorder;
TRUNCATE TABLE report_attention;
TRUNCATE TABLE report_authority;
TRUNCATE TABLE report_push;
TRUNCATE TABLE report_push_history;
TRUNCATE TABLE report_push_parameter;
TRUNCATE TABLE report_report;
TRUNCATE TABLE report_report_type;
TRUNCATE TABLE report_subscribe;
TRUNCATE TABLE rsc_op_log;
TRUNCATE TABLE rsc_resource;
TRUNCATE TABLE rsc_share_dept;
TRUNCATE TABLE sms_get_message;
TRUNCATE TABLE sms_message;
TRUNCATE TABLE sms_message_log;
TRUNCATE TABLE sms_message_temp;
TRUNCATE TABLE sms_validate;
TRUNCATE TABLE t_action_record;
TRUNCATE TABLE t_actionconfig;
TRUNCATE TABLE t_actionlog;
TRUNCATE TABLE t_actionupadte;
TRUNCATE TABLE t_advice;
TRUNCATE TABLE t_amusement;
TRUNCATE TABLE t_answer;
TRUNCATE TABLE t_answercomment;
TRUNCATE TABLE t_appcontextbase;
TRUNCATE TABLE t_appcontextbasebook;
TRUNCATE TABLE t_application;
TRUNCATE TABLE t_appointment;
TRUNCATE TABLE t_archive_file;
TRUNCATE TABLE t_archive_files;
TRUNCATE TABLE t_askforleave;
TRUNCATE TABLE t_attractions;
TRUNCATE TABLE t_auditthing;
TRUNCATE TABLE t_auditwork;
TRUNCATE TABLE t_bbs;
TRUNCATE TABLE t_blogclick;
TRUNCATE TABLE t_blogcore;
TRUNCATE TABLE t_blogguestbook;
TRUNCATE TABLE t_bloglist;
TRUNCATE TABLE t_bloglog;
TRUNCATE TABLE t_blogphoto;
TRUNCATE TABLE t_blogresponse;
TRUNCATE TABLE t_bloguserlike;
TRUNCATE TABLE t_booktype;
TRUNCATE TABLE t_booktypedetail;
TRUNCATE TABLE t_card;
TRUNCATE TABLE t_cardriver;
TRUNCATE TABLE t_carinfo;
TRUNCATE TABLE t_carmaintain;
TRUNCATE TABLE t_carmanager;
TRUNCATE TABLE t_caruse;
TRUNCATE TABLE t_check;
TRUNCATE TABLE t_checkcores;
TRUNCATE TABLE t_checkdetail;
TRUNCATE TABLE t_checkdict;
TRUNCATE TABLE t_checkdictdetail;
TRUNCATE TABLE t_checkdictgroup;
TRUNCATE TABLE t_checktask;
TRUNCATE TABLE t_checktype;
TRUNCATE TABLE t_circle;
TRUNCATE TABLE t_circleuser;
TRUNCATE TABLE t_citilifehotel;
TRUNCATE TABLE t_clientinfo;
TRUNCATE TABLE t_codeflow_inst;
TRUNCATE TABLE t_codeflow_tache_inst;
TRUNCATE TABLE t_com_setmeal;
TRUNCATE TABLE t_comment;
TRUNCATE TABLE t_communitybasicdata;
TRUNCATE TABLE t_competition;
TRUNCATE TABLE t_contact;
TRUNCATE TABLE t_contract;
TRUNCATE TABLE t_crmclient;
TRUNCATE TABLE t_crmperson;
TRUNCATE TABLE t_department;
TRUNCATE TABLE t_devicesupplies;
TRUNCATE TABLE t_devicesuppliesdetail;
TRUNCATE TABLE t_devicesys;
TRUNCATE TABLE t_eamdevice;
TRUNCATE TABLE t_eamsupply;
TRUNCATE TABLE t_entmember;
TRUNCATE TABLE t_festivalinit;
TRUNCATE TABLE t_file;
TRUNCATE TABLE t_flight;
TRUNCATE TABLE t_friend;
TRUNCATE TABLE t_fw;
TRUNCATE TABLE t_hello;
TRUNCATE TABLE t_hello_detail;
TRUNCATE TABLE t_hotel;
TRUNCATE TABLE t_house;
TRUNCATE TABLE t_houseelectric;
TRUNCATE TABLE t_housemoreinfo;
TRUNCATE TABLE t_hrattendanceinit;
TRUNCATE TABLE t_hrbaseuser;
TRUNCATE TABLE t_hrdict;
TRUNCATE TABLE t_hrexam;
TRUNCATE TABLE t_hrmonthattendance;
TRUNCATE TABLE t_hrsalary;
TRUNCATE TABLE t_hrsalarybase;
TRUNCATE TABLE t_hrsalaryinit;
TRUNCATE TABLE t_hrsignin;
TRUNCATE TABLE t_hrsignout;
TRUNCATE TABLE t_hrwelfare;
TRUNCATE TABLE t_im_message;
TRUNCATE TABLE t_info;
TRUNCATE TABLE t_job;
TRUNCATE TABLE t_kemu;
TRUNCATE TABLE t_lettersvisit;
TRUNCATE TABLE t_listtest;
TRUNCATE TABLE t_loginconfig;
TRUNCATE TABLE t_mail;
TRUNCATE TABLE t_mailconfig;
TRUNCATE TABLE t_mailreceipt;
TRUNCATE TABLE t_mailsendto;
TRUNCATE TABLE t_marketactivty;
TRUNCATE TABLE t_materials;
TRUNCATE TABLE t_meetnotify;
TRUNCATE TABLE t_meetroom;
TRUNCATE TABLE t_memberstatus;
TRUNCATE TABLE t_message;
TRUNCATE TABLE t_notice;
TRUNCATE TABLE t_notice_user;
TRUNCATE TABLE t_officething;
TRUNCATE TABLE t_officethingbuy;
TRUNCATE TABLE t_officethingbuyselect;
TRUNCATE TABLE t_officethingdict;
TRUNCATE TABLE t_officethinguse;
TRUNCATE TABLE t_officethinguseitem;
TRUNCATE TABLE t_order;
TRUNCATE TABLE t_ordershangpin;
TRUNCATE TABLE t_overtimework;
TRUNCATE TABLE t_pageclick;
TRUNCATE TABLE t_partymember;
TRUNCATE TABLE t_person;
TRUNCATE TABLE t_personman;
TRUNCATE TABLE t_pindao;
TRUNCATE TABLE t_plandetail;
TRUNCATE TABLE t_planmanager;
TRUNCATE TABLE t_platform;
TRUNCATE TABLE t_product;
TRUNCATE TABLE t_project;
TRUNCATE TABLE t_projectcontract;
TRUNCATE TABLE t_question;
TRUNCATE TABLE t_quote;
TRUNCATE TABLE t_quotedetail;
TRUNCATE TABLE t_read_user;
TRUNCATE TABLE t_recmessage;
TRUNCATE TABLE t_reimburse;
TRUNCATE TABLE t_reimbursedetail;
TRUNCATE TABLE t_replacement;
TRUNCATE TABLE t_replacementdevice;
TRUNCATE TABLE t_reply;
TRUNCATE TABLE t_request;
TRUNCATE TABLE t_resource;
TRUNCATE TABLE t_resource_type;
TRUNCATE TABLE t_resource_useinfo;
TRUNCATE TABLE t_restaurant;
TRUNCATE TABLE t_return;
TRUNCATE TABLE t_saleorder;
TRUNCATE TABLE t_saleorderdetail;
TRUNCATE TABLE t_saletradeactivity;
TRUNCATE TABLE t_serviceactivty;
TRUNCATE TABLE t_servicerequest;
TRUNCATE TABLE t_setmeal;
TRUNCATE TABLE t_setmeal_action;
TRUNCATE TABLE t_shangdao;
TRUNCATE TABLE t_shangpin;
TRUNCATE TABLE t_shop;
TRUNCATE TABLE t_studentfirst;
TRUNCATE TABLE t_supplydemand;
TRUNCATE TABLE t_sw;
TRUNCATE TABLE t_talent; 
TRUNCATE TABLE t_tradeopportunity;
TRUNCATE TABLE t_train;
TRUNCATE TABLE t_uploadfile;
TRUNCATE TABLE t_uploadphoto;
TRUNCATE TABLE t_user_action_time;
TRUNCATE TABLE t_user_application;
TRUNCATE TABLE t_user_group;
TRUNCATE TABLE t_user_login;
TRUNCATE TABLE t_version;
TRUNCATE TABLE t_video_room;
TRUNCATE TABLE t_video_room_msg;
TRUNCATE TABLE t_video_room_user;
TRUNCATE TABLE t_website_guide;
TRUNCATE TABLE t_wfform;
TRUNCATE TABLE t_wfformitem;
TRUNCATE TABLE t_wftest;
TRUNCATE TABLE t_workflow_app;
TRUNCATE TABLE t_workflow_approval;
TRUNCATE TABLE t_workflow_task;
TRUNCATE TABLE t_workflow_task_var;
TRUNCATE TABLE t_xinfangtousu;
TRUNCATE TABLE t_xinfangtousuob;
TRUNCATE TABLE t_xinfangtousuperson;
TRUNCATE TABLE t_zipcode;
TRUNCATE TABLE tms_comment;
TRUNCATE TABLE tms_diary_user_list;
TRUNCATE TABLE tms_diray;
TRUNCATE TABLE tms_doc;
TRUNCATE TABLE tms_doc_type;
TRUNCATE TABLE tms_history_task;
TRUNCATE TABLE tms_proj_user;
TRUNCATE TABLE tms_project_authority;
TRUNCATE TABLE tms_project_doc;
TRUNCATE TABLE tms_project_his_info;
TRUNCATE TABLE tms_project_info;
TRUNCATE TABLE tms_project_log;
TRUNCATE TABLE tms_project_manage_dept;
TRUNCATE TABLE tms_project_node;
TRUNCATE TABLE tms_receive_task;
TRUNCATE TABLE tms_reminders_diary;
TRUNCATE TABLE tms_system_settings;
TRUNCATE TABLE tms_task;
TRUNCATE TABLE tms_task_android;
TRUNCATE TABLE tms_task_comment;
TRUNCATE TABLE tms_task_decomposition;
TRUNCATE TABLE tms_task_decomposition_node;
TRUNCATE TABLE tms_task_decomposition_verify;
TRUNCATE TABLE tms_task_diary;
TRUNCATE TABLE tms_task_doc;
TRUNCATE TABLE tms_task_reply;
TRUNCATE TABLE tms_work_diary;
TRUNCATE TABLE y_user;