Wiki source code of CheckIndexesSQL

Last modified by Administrator on 2010/09/24 19:35
Content · Comments (0) · Annotations (0) · Attachments (0) · History · Information
Hide line numbers
 1: create index xwd_name on xwikidoc (xwd_name);
 2: create index xwd_fullname on xwikidoc (xwd_fullname);
 3: create index xwd_web on xwikidoc (xwd_web);
 4: create index xwo_name on xwikiobjects (xwo_name);  
 5: create index xwl_value on xwikilongs (xwl_value);
 6: create index xwi_value on xwikiintegers (xwi_value);
 7: create index xws_value on xwikistrings (xws_value);
 8: create index xwl_value on xwikilargestrings (xwl_value(50));
 9: create index xwo_classname on xwikiobjects (xwo_classname);
10: create index xwd_creation_date on xwikidoc (xwd_creation_date);
11: create index xwd_date on xwikidoc (xwd_date);
12: create index xwd_content_update_date on xwikidoc (xwd_content_update_date);
13: create index xwd_content_author on xwikidoc (xwd_content_author);
14: create index xwd_author on xwikidoc (xwd_author);
15: create index xwd_creator on xwikidoc (xwd_creator);
16: create index xwd_language on xwikidoc (xwd_language);
17: create index xwd_default_language on xwikidoc (xwd_default_language);
18: create index xwd_title on xwikidoc (xwd_title);
19: create index xwd_parent on xwikidoc (xwd_parent(50));
20: create index xwd_class_xml on xwikidoc (xwd_class_xml(20));
21: create index xwr_isdiff on xwikircs(xwr_isdiff);
22: create index xws_name on xwikistatsdoc (XWS_NAME);
23: create index xws_number on xwikistatsdoc (XWS_NUMBER);
24: create index xws_classname on xwikistatsdoc (XWS_CLASSNAME);
25: create index xws_action on xwikistatsdoc (XWS_ACTION);
26: create index xws_page_views on xwikistatsdoc (XWS_PAGE_VIEWS);
27: create index xws_unique_visitors on xwikistatsdoc (XWS_UNIQUE_VISITORS);
28: create index xws_period on xwikistatsdoc (XWS_PERIOD);
29: create index xws_visits on xwikistatsdoc (XWS_VISITS);
30: create index xwr_number on xwikistatsreferer (XWR_NUMBER);
31: create index xwr_name on xwikistatsreferer (XWR_NAME);
32: create index xwr_classname on xwikistatsreferer (XWR_CLASSNAME);
33: create index xwr_referer on xwikistatsreferer (XWR_REFERER(50));
34: create index xwr_page_views on xwikistatsreferer (XWR_PAGE_VIEWS);
35: create index xwr_period on xwikistatsreferer (XWR_PERIOD);
36: create index xwv_start_date on xwikistatsvisit (XWV_START_DATE);
37: create index xwv_name on xwikistatsvisit (XWV_NAME);
38: create index xwv_page_views on xwikistatsvisit (XWV_PAGE_VIEWS);
39: create index xwv_page_saves on xwikistatsvisit (XWV_PAGE_SAVES);
40: create index xwv_downloads on xwikistatsvisit (XWV_DOWNLOADS);
41: create index xwv_end_date on xwikistatsvisit (XWV_END_DATE);
42: create index xwv_ip on xwikistatsvisit (XWV_IP);
43: create index xwv_user_agent on xwikistatsvisit (XWV_USER_AGENT(255));
44: create index xwv_cookie on xwikistatsvisit (XWV_COOKIE(255));
45: create index xwv_unique_id on xwikistatsvisit (XWV_UNIQUE_ID);
46: create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME);
47: create index xwv_number on xwikistatsvisit (XWV_NUMBER);
48: create index ase_requestid on  activitystream_events (ase_requestid(200));
49: create index ase_stream on  activitystream_events (ase_stream);
50: create index ase_date on  activitystream_events (ase_date);
51: create index ase_priority on  activitystream_events (ase_priority);
52: create index ase_type on  activitystream_events (ase_type);
53: create index ase_application on  activitystream_events (ase_application);
54: create index ase_user on  activitystream_events (ase_user);
55: create index ase_wiki on  activitystream_events (ase_wiki);
56: create index ase_space on  activitystream_events (ase_space);
57: create index ase_page on  activitystream_events (ase_page);
58: create index ase_param1 on  activitystream_events (ase_param1(200));
59: create index ase_param2 on  activitystream_events (ase_param2(200));
60: create index ase_param3 on  activitystream_events (ase_param3(200));
61: create index ase_param4 on  activitystream_events (ase_param4(200));
62: create index ase_param5 on  activitystream_events (ase_param5(200));
63: create index xdd_fullname1 on xwikirecyclebin (xdd_fullname);
64: create index xdd_language on xwikirecyclebin (xdd_language);
65: create index xdd_date on xwikirecyclebin (xdd_date);
66: create index xdd_deleter on xwikirecyclebin (xdd_deleter);
67: create index xda_docid1 on xwikiattrecyclebin (xda_docid);
68: create index xda_doc_name on xwikiattrecyclebin (xda_doc_name);
69: create index xda_filename on xwikiattrecyclebin (xda_filename);
70: create index xda_date on xwikiattrecyclebin (xda_date);
71: create index xda_deleter on xwikiattrecyclebin (xda_deleter);