-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathupdate_sequences.sql
More file actions
52 lines (52 loc) · 2.98 KB
/
update_sequences.sql
File metadata and controls
52 lines (52 loc) · 2.98 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
alter sequence phpgw_camp_company_seq restart with 1;
--alter sequence phpgw_camp_master_seq restart with 100;
--alter sequence phpgw_camp_master_task_seq restart with 200;
--alter sequence phpgw_camp_user_seq restart with 1;
alter sequence seq_global_codes restart with 2000;
alter sequence seq_phpgw_accounts restart with 200;
alter sequence seq_phpgw_addressbook restart with 500000;
alter sequence seq_phpgw_addressbook_accounts restart with 1000;
alter sequence seq_phpgw_addressbook_alternate restart with 2000;
--alter sequence seq_phpgw_addressbook_extra_history restart with 500000;
alter sequence seq_phpgw_addressbook_favorite restart with 1000;
--alter sequence seq_phpgw_addressbook_field restart with 100;
alter sequence seq_phpgw_addressbook_financial restart with 10000;
alter sequence seq_phpgw_addressbook_group restart with 500;
alter sequence seq_phpgw_addressbook_group_arg restart with 500;
alter sequence seq_phpgw_addressbook_history restart with 500000;
alter sequence seq_phpgw_addressbook_photo restart with 100;
alter sequence seq_phpgw_addressbook_specialday restart with 1000;
alter sequence seq_phpgw_applications restart with 100;
alter sequence seq_phpgw_bookmarks restart with 1;
alter sequence seq_phpgw_cal restart with 75000;
alter sequence seq_phpgw_cal_holidays restart with 50;
--alter sequence seq_phpgw_camp restart with 100;
--alter sequence seq_phpgw_camp_master restart with 1;
--alter sequence seq_phpgw_camp_master_task restart with 1;
--alter sequence seq_phpgw_camp_sess restart with 500;
alter sequence seq_phpgw_campaign restart with 500;
alter sequence seq_phpgw_campaign_approval restart with 1000;
alter sequence seq_phpgw_campaign_client_tasks restart with 10000;
alter sequence seq_phpgw_campaign_clients restart with 1000;
alter sequence seq_phpgw_campaign_doc_mgmt restart with 1000;
alter sequence seq_phpgw_campaign_master restart with 200;
alter sequence seq_phpgw_campaign_master_docs restart with 100;
alter sequence seq_phpgw_campaign_tasks restart with 5000;
alter sequence seq_phpgw_categories restart with 200;
--alter sequence seq_phpgw_comic restart with 1;
--alter sequence seq_phpgw_comic_data restart with 1;
--alter sequence seq_phpgw_custom_fields restart with 500;
--alter sequence seq_phpgw_custom_tabs restart with 10;
alter sequence seq_phpgw_docworker_docs restart with 5000;
alter sequence seq_phpgw_email_tracker restart with 500000;
alter sequence seq_phpgw_emailadmin restart with 100;
alter sequence seq_phpgw_history_log restart with 100;
alter sequence seq_phpgw_hobbies restart with 500;
alter sequence seq_phpgw_hooks restart with 2000;
alter sequence seq_phpgw_infolog restart with 200000;
alter sequence seq_phpgw_infolog_history restart with 500000;
alter sequence seq_phpgw_links restart with 200000;
alter sequence seq_phpgw_postoffice_addr_assoc restart with 20000000;
alter sequence seq_phpgw_postoffice_cache restart with 10000000;
alter sequence seq_phpgw_postoffice_outofoffice restart with 5000;
alter sequence seq_phpgw_relation restart with 4000;