OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
conf
/
dbupgrade_tool
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
02/03/2023 08:07:15 AM
rwxr-xr-x
📄
cubottable.sh
7.35 KB
02/03/2023 07:34:22 AM
rwxr-xr-x
📄
data.sql
26.07 KB
02/03/2023 07:34:22 AM
rwxr-xr-x
📄
upgrade_demo_tkml_20160418.sql
56.15 KB
02/03/2023 07:34:22 AM
rw-r--r--
📄
upgrade_tkml_20160418.sql
25.29 KB
02/03/2023 07:34:22 AM
rwxr-xr-x
📄
writesql.awk
2.73 KB
02/03/2023 07:34:22 AM
rwxr-xr-x
Editing: upgrade_demo_tkml_20160418.sql
Close
-- **************************************** FOR TABLE :addr_list **************************************** -- -- Converting [ ] ==> [ al_to_bcc tinyint(1) YES NULL ] alter table addr_list add column al_to_bcc tinyint(1) ; -- **************************************** FOR TABLE :ad_host_list **************************************** -- -- **************************************** FOR TABLE :alert **************************************** -- -- Converting [ alert_name char(20) YES NULL ] ==> [ alert_name char(64) YES NULL ] alter table alert change column alert_name alert_name char(64) ; -- **************************************** FOR TABLE :alert_action **************************************** -- -- **************************************** FOR TABLE :alert_addr **************************************** -- -- **************************************** FOR TABLE :alert_conditions **************************************** -- -- **************************************** FOR TABLE :alert_details **************************************** -- -- **************************************** FOR TABLE :alert_event **************************************** -- -- Converting [ ] ==> [ ae_notify_ts int(11) YES NULL ] alter table alert_event add column ae_notify_ts int(11) ; -- **************************************** FOR TABLE :alert_evt_dtls **************************************** -- -- **************************************** FOR TABLE :alert_report **************************************** -- -- **************************************** FOR TABLE :cache_hits **************************************** -- -- **************************************** FOR TABLE :connector_frequency **************************************** -- -- **************************************** FOR TABLE :connector_run **************************************** -- -- **************************************** FOR TABLE :ctrl_btn_info **************************************** -- alter table ctrl_btn_info drop column btn_lang; -- **************************************** FOR TABLE :cuberrors **************************************** -- -- Converting [ err_msg char(255) YES NULL ] ==> [ err_msg char(254) YES NULL ] alter table cuberrors change column err_msg err_msg char(254) ; alter table cuberrors drop column err_lang; -- **************************************** FOR TABLE :cubnotes **************************************** -- -- **************************************** FOR TABLE :cubot_access **************************************** -- -- **************************************** FOR TABLE :cubot_help **************************************** -- -- **************************************** FOR TABLE :cubot_menu **************************************** -- alter table cubot_menu drop column cm_lang; -- **************************************** FOR TABLE :dash_access **************************************** -- -- **************************************** FOR TABLE :dash_folder **************************************** -- -- **************************************** FOR TABLE :data_dyfilter **************************************** -- -- **************************************** FOR TABLE :data_modifier **************************************** -- -- **************************************** FOR TABLE :data_series **************************************** -- -- Converting [ ds_menu_idval char(30) YES NULL ] ==> [ ds_menu_idval char(64) YES NULL ] alter table data_series change column ds_menu_idval ds_menu_idval char(64) ; -- **************************************** FOR TABLE :data_seriesids **************************************** -- -- **************************************** FOR TABLE :data_seriesvals **************************************** -- -- **************************************** FOR TABLE :datatemplate_details **************************************** -- -- **************************************** FOR TABLE :datatemplate_information **************************************** -- -- **************************************** FOR TABLE :datatemplate_users **************************************** -- -- **************************************** FOR TABLE :data_xy **************************************** -- -- Converting [ xy_xval char(30) YES NULL ] ==> [ xy_xval char(64) YES NULL ] alter table data_xy change column xy_xval xy_xval char(64) ; -- Converting [ xy_xval2 char(30) YES NULL ] ==> [ xy_xval2 char(64) YES NULL ] alter table data_xy change column xy_xval2 xy_xval2 char(64) ; -- Converting [ xy_xval3 char(30) YES NULL ] ==> [ xy_xval3 char(64) YES NULL ] alter table data_xy change column xy_xval3 xy_xval3 char(64) ; -- Converting [ xy_xval4 char(30) YES NULL ] ==> [ xy_xval4 char(64) YES NULL ] alter table data_xy change column xy_xval4 xy_xval4 char(64) ; -- Converting [ xy_xval5 char(30) YES NULL ] ==> [ xy_xval5 char(64) YES NULL ] alter table data_xy change column xy_xval5 xy_xval5 char(64) ; -- Converting [ xy_xval6 char(30) YES NULL ] ==> [ xy_xval6 char(64) YES NULL ] alter table data_xy change column xy_xval6 xy_xval6 char(64) ; -- Converting [ xy_xval7 char(30) YES NULL ] ==> [ xy_xval7 char(64) YES NULL ] alter table data_xy change column xy_xval7 xy_xval7 char(64) ; -- **************************************** FOR TABLE :data_xy_incr **************************************** -- -- Converting [ xy_xval char(30) YES NULL ] ==> [ xy_xval char(64) YES NULL ] alter table data_xy_incr change column xy_xval xy_xval char(64) ; -- Converting [ xy_xval2 char(30) YES NULL ] ==> [ xy_xval2 char(64) YES NULL ] alter table data_xy_incr change column xy_xval2 xy_xval2 char(64) ; -- Converting [ xy_xval3 char(30) YES NULL ] ==> [ xy_xval3 char(64) YES NULL ] alter table data_xy_incr change column xy_xval3 xy_xval3 char(64) ; -- Converting [ xy_xval4 char(30) YES NULL ] ==> [ xy_xval4 char(64) YES NULL ] alter table data_xy_incr change column xy_xval4 xy_xval4 char(64) ; -- Converting [ xy_xval5 char(30) YES NULL ] ==> [ xy_xval5 char(64) YES NULL ] alter table data_xy_incr change column xy_xval5 xy_xval5 char(64) ; -- Converting [ xy_xval6 char(30) YES NULL ] ==> [ xy_xval6 char(64) YES NULL ] alter table data_xy_incr change column xy_xval6 xy_xval6 char(64) ; -- Converting [ xy_xval7 char(30) YES NULL ] ==> [ xy_xval7 char(64) YES NULL ] alter table data_xy_incr change column xy_xval7 xy_xval7 char(64) ; -- **************************************** FOR TABLE :db_schema **************************************** -- -- **************************************** FOR TABLE :details_filter **************************************** -- -- **************************************** FOR TABLE :dim_group **************************************** -- -- Converting [ dg_value char(30) YES NULL ] ==> [ dg_value char(64) YES NULL ] alter table dim_group change column dg_value dg_value char(64) ; -- **************************************** FOR TABLE :display_type **************************************** -- -- **************************************** FOR TABLE :domain_list **************************************** -- -- **************************************** FOR TABLE :ds_stat **************************************** -- -- Converting [ ] ==> [ dt_xycount int(11) YES NULL ] alter table ds_stat add column dt_xycount int(11) ; -- Converting [ ] ==> [ dt_updatedby char(8) YES NULL ] alter table ds_stat add column dt_updatedby char(8) ; -- Converting [ ] ==> [ dt_select_sttime int(11) YES NULL ] alter table ds_stat add column dt_select_sttime int(11) ; -- Converting [ ] ==> [ dt_insert_sttime int(11) YES NULL ] alter table ds_stat add column dt_insert_sttime int(11) ; -- **************************************** FOR TABLE :dynamicfilter_query **************************************** -- -- **************************************** FOR TABLE :edash_pageinfo **************************************** -- -- **************************************** FOR TABLE :edash_svcs **************************************** -- -- **************************************** FOR TABLE :etl_columnmaster **************************************** -- -- **************************************** FOR TABLE :etl_col_validation **************************************** -- -- **************************************** FOR TABLE :etl_col_xform **************************************** -- -- **************************************** FOR TABLE :etl_conffile **************************************** -- -- **************************************** FOR TABLE :etl_dbstore **************************************** -- -- **************************************** FOR TABLE :etl_desttable_details **************************************** -- -- **************************************** FOR TABLE :etl_fmaster **************************************** -- -- **************************************** FOR TABLE :etl_fmetadata **************************************** -- -- **************************************** FOR TABLE :etl_fstore **************************************** -- -- **************************************** FOR TABLE :etl_logs **************************************** -- -- **************************************** FOR TABLE :etl_mysqldatatype **************************************** -- -- Converting [ ] ==> [ emd_type_dbtype char(16) NO mysql ] alter table etl_mysqldatatype add column emd_type_dbtype char(16) NOT NULL DEFAULT 'mysql' ; -- **************************************** FOR TABLE :etl_patchdetail **************************************** -- -- **************************************** FOR TABLE :etl_prcs_info **************************************** -- -- **************************************** FOR TABLE :etl_prcs_master **************************************** -- -- **************************************** FOR TABLE :etl_proctaskdetail **************************************** -- -- **************************************** FOR TABLE :etl_querydetails **************************************** -- -- **************************************** FOR TABLE :etl_querytaskdetail **************************************** -- -- **************************************** FOR TABLE :etl_repository **************************************** -- -- **************************************** FOR TABLE :etl_sqlkeyword **************************************** -- -- **************************************** FOR TABLE :etl_srctable_details **************************************** -- -- **************************************** FOR TABLE :etl_stginfo **************************************** -- -- **************************************** FOR TABLE :etl_store **************************************** -- -- **************************************** FOR TABLE :etl_strpermission **************************************** -- -- Converting [ esp_strtext varchar(255) YES NULL ] ==> [ esp_strtext text YES NULL ] alter table etl_strpermission change column esp_strtext esp_strtext text ; -- Converting [ esp_storeid varchar(255) YES NULL ] ==> [ esp_storeid text YES NULL ] alter table etl_strpermission change column esp_storeid esp_storeid text ; -- **************************************** FOR TABLE :etl_tablekeys **************************************** -- -- **************************************** FOR TABLE :etl_tablemapping **************************************** -- -- **************************************** FOR TABLE :etl_tablemaster **************************************** -- -- **************************************** FOR TABLE :etl_tasklog **************************************** -- -- Converting [ etl_sysprcsid int(11) YES -1 ] ==> [ etl_sysprcsid int(8) YES -1 ] alter table etl_tasklog change column etl_sysprcsid etl_sysprcsid int(8) DEFAULT '-1' ; -- **************************************** FOR TABLE :etl_taskmaster **************************************** -- -- **************************************** FOR TABLE :etl_taskvalidate **************************************** -- -- **************************************** FOR TABLE :etl_upload **************************************** -- -- **************************************** FOR TABLE :etl_validrule **************************************** -- -- **************************************** FOR TABLE :etl_wfcondition **************************************** -- -- **************************************** FOR TABLE :etl_wfdetail **************************************** -- -- **************************************** FOR TABLE :etl_wfmaster **************************************** -- -- **************************************** FOR TABLE :etl_xformfunction **************************************** -- -- **************************************** FOR TABLE :feedback **************************************** -- -- **************************************** FOR TABLE :filter_details **************************************** -- -- Converting [ fd_value char(30) YES NULL ] ==> [ fd_value char(64) YES NULL ] alter table filter_details change column fd_value fd_value char(64) ; -- **************************************** FOR TABLE :filter_header **************************************** -- -- **************************************** FOR TABLE :folder_access **************************************** -- -- Converting [ ] ==> [ fa_userid int(11) NO PRI 0 ] alter table folder_access add column fa_userid int(11) PRIMARY KEY NOT NULL DEFAULT '0' ; -- Converting [ ] ==> [ fa_isgrp char(1) YES N ] alter table folder_access add column fa_isgrp char(1) DEFAULT 'N' ; -- Converting [ ] ==> [ fa_access int(11) YES NULL ] alter table folder_access add column fa_access int(11) ; alter table folder_access drop column fa_user; alter table folder_access drop column fa_group; alter table folder_access drop column fa_other; -- **************************************** FOR TABLE :folder_categories **************************************** -- -- Converting [ fc_name char(25) YES NULL ] ==> [ fc_name char(20) YES NULL ] alter table folder_categories change column fc_name fc_name char(20) ; alter table folder_categories drop column fc_lang; -- **************************************** FOR TABLE :folder_id_seq **************************************** -- -- **************************************** FOR TABLE :folder_link **************************************** -- -- **************************************** FOR TABLE :folder_log **************************************** -- -- **************************************** FOR TABLE :folder_properties **************************************** -- -- **************************************** FOR TABLE :folder_tree **************************************** -- -- Converting [ ft_name char(32) YES NULL ] ==> [ ft_name char(64) YES NULL ] alter table folder_tree change column ft_name ft_name char(64) ; -- **************************************** FOR TABLE :graph_access **************************************** -- -- **************************************** FOR TABLE :graph_custom **************************************** -- -- **************************************** FOR TABLE :graph_def **************************************** -- -- Converting [ gf_user_title char(30) YES NULL ] ==> [ gf_user_title char(64) YES NULL ] alter table graph_def change column gf_user_title gf_user_title char(64) ; -- **************************************** FOR TABLE :graph_drill **************************************** -- -- **************************************** FOR TABLE :graph_notes **************************************** -- -- **************************************** FOR TABLE :graph_props **************************************** -- -- **************************************** FOR TABLE :graph_series **************************************** -- -- Converting [ ] ==> [ gs_series_flt_oper char(3) YES 88 ] alter table graph_series add column gs_series_flt_oper char(3) DEFAULT '88' ; -- Converting [ ] ==> [ gs_series_selvalue1 double YES 0 ] alter table graph_series add column gs_series_selvalue1 double DEFAULT '0' ; -- Converting [ ] ==> [ gs_series_selvalue2 double YES 0 ] alter table graph_series add column gs_series_selvalue2 double DEFAULT '0' ; -- **************************************** FOR TABLE :graph_status **************************************** -- -- **************************************** FOR TABLE :graph_type **************************************** -- -- **************************************** FOR TABLE :group_roles **************************************** -- -- Converting [ gr_role char(10) NO PRI ] ==> [ gr_role char(16) NO PRI ] alter table group_roles change column gr_role gr_role char(16) PRIMARY KEY NOT NULL ; -- **************************************** FOR TABLE :groups **************************************** -- -- **************************************** FOR TABLE :install_params **************************************** -- -- **************************************** FOR TABLE :login_connects **************************************** -- -- Converting [ ] ==> [ lc_logoutpage char(254) YES NULL ] alter table login_connects add column lc_logoutpage char(254) ; -- **************************************** FOR TABLE :login_conn_id **************************************** -- -- **************************************** FOR TABLE :login_history **************************************** -- -- **************************************** FOR TABLE :login_passwd **************************************** -- -- **************************************** FOR TABLE :login_reminder **************************************** -- -- **************************************** FOR TABLE :login_tree **************************************** -- -- Converting [ lt_role char(10) YES NULL ] ==> [ lt_role char(16) YES NULL ] alter table login_tree change column lt_role lt_role char(16) ; -- **************************************** FOR TABLE :login_users **************************************** -- -- Converting [ lu_cubot_login int(1) YES 1 ] ==> [ lu_cubot_login int(1) YES 0 ] alter table login_users change column lu_cubot_login lu_cubot_login int(1) DEFAULT '0' ; -- Converting [ ] ==> [ lu_accessfrom char(255) YES NULL ] alter table login_users add column lu_accessfrom char(255) ; alter table login_users drop column lu_analyse; -- **************************************** FOR TABLE :login_user_seq **************************************** -- -- **************************************** FOR TABLE :map_coords **************************************** -- -- **************************************** FOR TABLE :menu_dtls **************************************** -- -- Converting [ md_table char(30) YES NULL ] ==> [ md_table char(64) YES NULL ] alter table menu_dtls change column md_table md_table char(64) ; -- Converting [ md_desc char(25) YES NULL ] ==> [ md_desc char(128) YES NULL ] alter table menu_dtls change column md_desc md_desc char(128) ; alter table menu_dtls drop column md_forAnalyse; alter table menu_dtls drop column md_metagrp; alter table menu_dtls drop column md_order; -- **************************************** FOR TABLE :menu_dtls_bkup **************************************** -- -- Converting [ ] ==> [ md_notes char(255) YES NULL ] alter table menu_dtls_bkup add column md_notes char(255) ; -- **************************************** FOR TABLE :menu_groups **************************************** -- -- **************************************** FOR TABLE :menu_hierarchy **************************************** -- -- **************************************** FOR TABLE :menu_maps **************************************** -- -- **************************************** FOR TABLE :menu_trees **************************************** -- -- Converting [ mt_role char(10) YES NULL ] ==> [ mt_role char(16) YES NULL ] alter table menu_trees change column mt_role mt_role char(16) ; -- **************************************** FOR TABLE :menu_trees_bkup **************************************** -- -- **************************************** FOR TABLE :meta_data **************************************** -- -- Converting [ md_format char(16) YES NULL ] ==> [ md_format char(16) NO nf ] alter table meta_data change column md_format md_format char(16) NOT NULL DEFAULT 'nf' ; -- **************************************** FOR TABLE :meta_group **************************************** -- -- **************************************** FOR TABLE :meta_template **************************************** -- -- Converting [ mt_column char(128) NO ] ==> [ mt_column char(200) YES NULL ] alter table meta_template change column mt_column mt_column char(200) ; -- **************************************** FOR TABLE :notify_addr **************************************** -- -- **************************************** FOR TABLE :notify_attach **************************************** -- -- **************************************** FOR TABLE :notify_info **************************************** -- -- Converting [ ni_create_user_id varchar(16) YES NULL ] ==> [ ni_create_user_id char(16) YES NULL ] alter table notify_info change column ni_create_user_id ni_create_user_id char(16) ; -- Converting [ ni_subject varchar(50) YES NULL ] ==> [ ni_subject char(50) YES NULL ] alter table notify_info change column ni_subject ni_subject char(50) ; -- Converting [ ni_message_info varchar(50) YES NULL ] ==> [ ni_message_info char(50) YES NULL ] alter table notify_info change column ni_message_info ni_message_info char(50) ; -- **************************************** FOR TABLE :notify_report **************************************** -- -- **************************************** FOR TABLE :notify_sch **************************************** -- -- **************************************** FOR TABLE :operator_master **************************************** -- -- **************************************** FOR TABLE :oper_params **************************************** -- -- **************************************** FOR TABLE :pass_history **************************************** -- -- **************************************** FOR TABLE :prefs_info **************************************** -- -- **************************************** FOR TABLE :prefs_values **************************************** -- alter table prefs_values drop column pv_lang; -- **************************************** FOR TABLE :rd_app_access **************************************** -- -- **************************************** FOR TABLE :rd_codes **************************************** -- -- Converting [ cd_short_desc char(254) YES NULL ] ==> [ cd_short_desc char(30) YES NULL ] alter table rd_codes change column cd_short_desc cd_short_desc char(30) ; -- Converting [ cd_desc char(254) YES NULL ] ==> [ cd_desc char(30) YES NULL ] alter table rd_codes change column cd_desc cd_desc char(30) ; alter table rd_codes drop column cd_lang; -- **************************************** FOR TABLE :regen_incrcnt **************************************** -- -- **************************************** FOR TABLE :report_display **************************************** -- -- Converting [ rpd_hrefval char(255) YES ] ==> [ rpd_hrefval char(254) YES NULL ] alter table report_display change column rpd_hrefval rpd_hrefval char(254) ; -- **************************************** FOR TABLE :report_disptopx **************************************** -- -- **************************************** FOR TABLE :report_search **************************************** -- -- **************************************** FOR TABLE :report_template **************************************** -- -- **************************************** FOR TABLE :search_params **************************************** -- -- **************************************** FOR TABLE :series_seq **************************************** -- -- **************************************** FOR TABLE :session_props **************************************** -- -- **************************************** FOR TABLE :sort_order **************************************** -- -- Converting [ so_xval char(30) NO PRI ] ==> [ so_xval char(64) NO PRI ] alter table sort_order change column so_xval so_xval char(64) PRIMARY KEY NOT NULL ; -- **************************************** FOR TABLE :star_incr **************************************** -- -- **************************************** FOR TABLE :star_star **************************************** -- -- Converting [ ss_val char(30) NO PRI ] ==> [ ss_val char(64) NO PRI ] alter table star_star change column ss_val ss_val char(64) PRIMARY KEY NOT NULL ; -- Converting [ ] ==> [ ss_timecol char(30) YES NULL ] alter table star_star add column ss_timecol char(30) ; -- **************************************** FOR TABLE :table_joins **************************************** -- -- **************************************** FOR TABLE :table_list **************************************** -- -- **************************************** FOR TABLE :table_syns **************************************** -- -- **************************************** FOR TABLE :template_group **************************************** -- -- **************************************** FOR TABLE :tgt_dist **************************************** -- -- **************************************** FOR TABLE :tgt_hdrinfo **************************************** -- -- **************************************** FOR TABLE :time **************************************** -- -- Converting [ val int(11) YES NULL ] ==> [ val int(11) NO PRI 0 ] alter table time change column val val int(11) PRIMARY KEY NOT NULL DEFAULT '0' ; -- Converting [ ] ==> [ day tinyint(4) YES NULL ] alter table time add column day tinyint(4) ; -- **************************************** FOR TABLE :trn_cub_response **************************************** -- -- **************************************** FOR TABLE :user_access **************************************** -- -- **************************************** FOR TABLE :user_content **************************************** -- -- **************************************** FOR TABLE :user_groups **************************************** -- -- **************************************** FOR TABLE :user_mtree **************************************** -- -- **************************************** FOR TABLE :user_settings **************************************** -- -- Now Putting Static Data -- DROP TABLE IF EXISTS `install_params`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `install_params` ( `ip_id` int(11) NOT NULL DEFAULT '0', `ip_name` char(30) NOT NULL DEFAULT '', `ip_val` char(30) DEFAULT NULL, `ip_grp_id` int(11) DEFAULT NULL, PRIMARY KEY (`ip_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `install_params` VALUES (12,'Measure Selection input','Checkbox',0),(10,'View Report Details','Y',0),(20,'Set Targets','N',0),(4,'Graph Type','B',2),(3,'Graph Units','1',2),(2,'Graph Layout','1',2),(21,'Measure rows,colums','4,4',0),(27,'Top n rows on report','10',0),(13,' Email id from','cubmail',0),(14,'Last Notify Time','',NULL),(15,' Email Option','Y',0),(18,'Minimum Query time','0',0),(19,'Maximum Query time','600',0),(1,'Ask Generate Graph ?','Y',2),(16,'Status Low Tresh','95',2),(17,'Status High Tresh','98',2),(7,'Fact Record Limit','50000',0),(0,'Cubot Version','10.0.3.3.702',0),(32,'Minimum Password length','3',1),(33,'Maximum Password length','20',1),(34,'Password age in days','60000',1),(35,'Password Attempts','10',1),(36,'Cubot Security','U',0),(37,'Password History','5',1),(39,'Hide Data on Computation','Y',3),(40,'Scale Tresh','10',0),(38,'Inactive Account','180',1),(43,'Validate Ip','N',NULL),(41,'Login Limit','8',0),(42,'Alerts','Y',4),(45,'Default Login','A',3),(29,'Show Total','Y',2),(28,'Show Grand Total','Y',2),(51,'Cubot Date Format','%Y/%m/%d',0),(47,'Report Name Per Page','50',0),(48,'Default Report Validity','45',0),(6,'Keep Analyse','Y',3),(8,'Stats On','1',2),(9,'Stats Threshold','10000',2),(11,'Details Xl On','N',2),(23,'Stale Cache On','5',0),(24,'Graph Textrows','200',2),(44,'Use Time Clause','Y',0),(50,'User Defined Homepage','/VBox/VBox.html',0),(52,' ETL Option','Y',0),(55,'Report Access Level','0',2),(31,'Show Generated Title','Y',2),(30,'Default Login Page Option','45',1),(49,'Default Spreadsheet Option','XL',3),(22,'Max Subseries','255',2),(57,'Rows in Cubot Log','200',1),(56,'Default Details Distinct','N',0),(58,'Running Average Frequencies','7,3',2),(59,'Enquiry Report','Y',5),(60,'Maximum filter numbers','50',0),(62,'Show Subtitle','Y',2),(53,'No of Reports','10',0),(63,'User Can Define Measures','Y',3),(64,'User Defined Locale','en_US.UTF-8',0),(65,'Download Option In Detail Repo','N',2),(68,'OLAP Date Format','Y',0),(67,'Passwd managment scheme','1',1),(69,'Enable Transformation','Y',0),(71,'Show Legal Page','N',1),(73,'Top-x Across All Dimension','Y',2),(76,'Number of rows Alert-Report','500',4),(75,'Cumulate Data Till','1',2),(77,'Show Login-Filters in Analyse','N',0),(74,'Enable DB Manager','Y',0),(79,'Add Description','Y',0),(80,'Set logout page','',0),(82,'Year Month Format','%Y-%m',0),(84,'Highlight Positive/Negative Nu','X',0),(85,'Grand Total Position','F',0),(83,'Page Print Orientation','-U -C bh -W b',0),(86,'Series Prefix','1',0),(87,'Template Directory','/home/cubot/templates/',0),(70,'Language','English',0),(89,'Precision of Computed Data','4',2),(90,'Show Disclaimer','N',0),(54,'Default Rows in Dashboard','5',3),(91,'Enable Forecast Option','0',3),(92,'Notify password reset','1',0); DROP TABLE IF EXISTS `ctrl_btn_info`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ctrl_btn_info` ( `btn_code_id` int(11) NOT NULL DEFAULT '0', `btn_info` char(254) DEFAULT NULL, PRIMARY KEY (`btn_code_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `ctrl_btn_info` VALUES (1,'After selecting dimensions and measures, Generate report Automatically, as Preview or only when GO button is pressed.'),(2,'Set default report layout. Top X is used to pick the best X items in a list report.'),(3,'Set default value format.'),(4,'Set default view for reports and graphs. This setting can be changed dynamically while creating a report at runtime.'),(6,'Check if you want CUBOT to remember the last report you were working on.'),(30,'Set default page after log-in.'),(49,'Select default spreadsheet application to export data to.'),(45,'Set Default Login Mode.'),(55,'Access permision on report.'),(31,'Check this box if you want to see system generated report titles.'),(0,'Current Cubot Version.'),(7,'Allows to set number of detail records.'),(8,'Stats ON'),(9,'Allows to set Stats threshold.'),(10,'Allows you to view Report details.'),(11,'Allows to set details XL ON.'),(12,'Measure style in analyze page by default checkbox.'),(13,'Allows to set email id of administrator.'),(14,''),(15,'Allows you to enable Email option for user.'),(16,'Allows to set status low threshold limit.'),(17,'Allows to set status high threshold limit.'),(18,'Allows you to set Query minimum time in milliseconds.'),(19,'Allows you to set Query maximum time in milliseconds.'),(20,'Allows you to enable Target tab in user mode.'),(21,'Allows you to set measure in rows & columns for example 3,4 .'),(22,'Allows to set Maximum Subseries.'),(23,'Allows to set Stale cache days.'),(24,'Allows to set number of rows to be displayed in text report.'),(27,'Allows you to set max top values in Top X of report.'),(28,'Allows to set grant total of generated report.'),(29,'Allows to set total of generated report.'),(32,'Allows you to set minimum length of password to be used by user.'),(33,'Allows you to set maximum length of password to be used by user.'),(34,'Allows you to set expiry days for password.'),(35,'Allows you to set number of attempt by user for wrong password.'),(36,'using Unix Security for this CUBOT.'),(37,'Allows you to set number of password used in past.'),(38,'Allows you to set number of inactive accounts.'),(39,'Allows you to hide computated data column.'),(40,'Allows to set threshold limit.'),(41,'Allows to set ETL Log limit that should be displayed on screen.'),(42,'Allows you to add Alert tab.'),(44,'Allows you to set Time clause option in CUBOT.'),(47,'Allows to set number Report Per Page in user analysis.'),(48,'Allows to set Default Report Validity(in days).'),(50,'Allows you to set your own customized home page.'),(51,'Allows to set Cubot Date format.'),(52,'Allows you to set ETL tab option.'),(58,'Allow you to enter the running average frequencies separated by commas. Ex:7,3'),(57,'Allows you \nto set the number of rows in ETL logs'),(59,'Allows youto view the Enquiry Screens.'),(60,'Allows you to set Maximum number of filter'),(62,'Check this box if you want to see system generated report subtitles.'),(53,'Allows you to set the number of reports to view under Latest Reports folder in Reports tab'),(63,'Allows users to define measures'),(64,'Allow user to set locale. Useful while exporting report to excel'),(65,'Download option in detail reports'),(68,'Yes:(YY/mm/dd), No:(YY-mm-dd).Select according date calender format'),(69,'Enable Transformation'),(71,'Show Legal Page'),(67,'Login password will be Authenticated useing this machenism'),(73,'Top-x Across All Dimension or Grouped by Dimension'),(76,'Number of rows Alert-Report'),(75,'Cumulate data till available data/till period'),(77,'Show Login-Filters in dimension listing in Analyse'),(74,'Enable DB Manager'),(79,'Add Note to change Item'),(80,'set logout page'),(82,'Allow you to set the year month format'),(83,'Printing orientation (Landscape/Portrait)'),(84,'Highlight Positive OR Negative Measure Values'),(85,'Set Grand Total Position'),(86,'Series Prefix(Show/Hide)'),(70,'Language'),(89,'Precision of Computed Data'),(90,'Show Disclaimer'),(54,'Number of rows in a report to be displayed on dashboard. If you select a number larger than can be accommodated in a dashboard pane, a scrollbar will appear.'); DROP TABLE IF EXISTS `rd_codes`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `rd_codes` ( `cd_code_type` char(15) NOT NULL DEFAULT '', `cd_code_id` int(11) NOT NULL DEFAULT '0', `cd_short_desc` char(30) DEFAULT NULL, `cd_desc` char(30) DEFAULT NULL, PRIMARY KEY (`cd_code_type`,`cd_code_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `rd_codes` VALUES ('ADMIN_ROLE',1,'Users','User Admin'),('ADMIN_ROLE',2,'Schema','Schema Admin'),('ADMIN_ROLE',4,'Filter','Admin Filters'),('ADMIN_ROLE',8,'Items','Admin Items'),('ADMIN_ROLE',16,'System','Admin System'),('ADMIN_ROLE',32,'Password','Reset Password'),('ADMIN_ROLE',128,'Groups','Group Admin'),('USER_PREFS',1,'Ask Generate Graph','Generate Report'),('USER_PREFS',2,'Graph Layout','Preferred layout'),('USER_PREFS',3,'Graph Units','Show values as'),('USER_PREFS',4,'Graph Type','Report view'),('USER_PREFS',6,'Keep Analysis','Remember last report'),('USER_PREFS',30,'Default Page','Show page after login'),('ADMIN_ROLE',256,'ETL','Configure Cubot ETL'),('ADMIN_ROLE',512,'Admin(Read Only)','Admin Read only'),('INSTALL_PARAMS',0,'Cubot Settings','cubot settings'),('INSTALL_PARAMS',1,'Login Settings','login settings'),('INSTALL_PARAMS',2,'Graph Settings','graph settings'),('INSTALL_PARAMS',3,'User Settings','user settings'),('INSTALL_PARAMS',4,'Alert Settings','alert settings'),('INSTALL_PARAMS',5,'Enquiry Settings','Enquiry Settings'),('USER_PREFS',45,'Default Login','Set default login'),('FEEDBACK',46,'Feedback Option',NULL),('USER_PREFS',49,'Open Spreadsheet','Spreadsheet application'),('USER_PREFS',55,'Report Access','Access of reports'),('ADMIN_ROLE',2048,'Metadata','Admin Metadata'),('USER_PREFS',58,'Running frequencies','Running frequencies'),('ADMIN_ROLE',4096,'Execute Process','Access to process tab of ETL'),('USER_PREFS',64,'User Locale','User Locale Setting'),('USER_PREFS',51,'Cubot Date Format','Cubot Date Format'),('ADMIN_ROLE',8192,'ETL Operation','User Store Permission'),('USER_PREFS',73,'Top-x Mode','Top-x Mode'),('USER_PREFS',76,'Number of rows Alert-Report','Number of rows Alert-Report'),('USER_PREFS',77,'Show Login-Filters in Analyse','Show Login-Filters in Analyse'),('USER_PREFS',83,'Orientation','Page Orientation'),('USER_PREFS',84,'Highlight Positive/Negative Nu','Highlight Positive OR Negative'),('USER_PREFS',85,'Grand Total Position','Set Grand Total Position in Ta'),('USER_PREFS',86,'Series Prefix','Series Prefix...'),('USER_PREFS',70,'Language...','Language'),('USER_PREFS',89,'Precision of Computed Data','Precision of Computed Data'),('USER_PREFS',54,'No of Repots on Dashboard','Number of rows'); DROP TABLE IF EXISTS `prefs_values`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `prefs_values` ( `pv_no` int(11) NOT NULL DEFAULT '0', `pv_id` int(11) NOT NULL DEFAULT '0', `pv_showval` char(32) DEFAULT NULL, `pv_val` char(20) NOT NULL DEFAULT '', PRIMARY KEY (`pv_no`,`pv_id`,`pv_val`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `prefs_values` VALUES (1,1,'GO Button','Y'),(2,1,'Automatic','N'),(3,2,'Normal','1'),(4,2,'Crosstab','2'),(5,2,'T\nop X','3'),(6,3,'Actuals','1'),(7,3,'Thousands','1000'),(8,3,'Millions','1000000'),(9,3,'Percent','100'),(10,4,'Stacked Bar\n','A'),(11,4,'Bar','B'),(12,4,'Line','L'),(13,4,'Pie','P'),(14,4,'Text Report','T'),(15,6,'Check to Keep Analyze','Y'),(16,6,'Check to Keep Analyze','N'),(17,30,'Dashboard','5'),(18,30,'Reports','10'),(19,30,'Analyze','15'),(20,30,'Preferences','30'),(21,45,'Admin','A'),(22,45,'User','U'),(23,1,'Preview','P'),(24,46,'General','5'),(25,46,'Support','4'),(26,46,'Usability\n','3'),(27,46,'Functionality','2'),(28,46,'Features','1'),(29,49,'OpenOffice','O'),(30,49,'Multipage','M'),(31,49,'MS Excel\n','XL'),(34,30,'Alert','20'),(35,30,'Targets','25'),(36,55,'Group View','1'),(37,55,'Group Edit','3'),(38,55,'All Edit','15'),(39,55,'All View','5'),(40,55,'User View And Edit','0'),(41,31,'','Y'),(42,0,'7.2','7.2'),(43,8,'Stats ON','1'),(44,12,'Checkbox','Checkbox'),(45,36,'Unix','U'),(51,51,'YY/MM/DD','%% y/%% m/%% d'),(50,51,'MM/DD/YYYY','%% m/%% d/%% Y'),(49,51,'MM/DD/YY','%% m/%% d/%% y'),(48,51,'MM/DD/YYYY','%% d/%% m/%% y'),(0,62,'','Y'),(56,63,'Check for User Define Measures','N'),(55,63,'Check for User Define Measures','Y'),(59,64,'Japanese','ja_JP.UTF-8'),(58,64,'Dutch','de_DE.UTF-8'),(57,64,'English','en_US.UTF-8'),(60,68,'','Y'),(61,67,'Cubot','1'),(68,75,'Till Available Data','1'),(62,67,'Active Directory','2'),(63,73,'Top-x Across All Dimension','Y'),(70,77,'Show Login-Filters in Analyse','Y'),(69,75,'Till Period','2'),(71,82,'Jan-2010','%% b-%% Y'),(46,51,'DD/MON/YYYY','%% d/%% m/%% Y'),(72,82,'Jan-10','%% b-%% y'),(73,82,'January-2010','%% B-%% Y'),(74,82,'2010-01','%% Y-%% m'),(52,51,'YYYY/MM/DD','%% Y/%% m/%% d'),(70,83,'Landscape','-L -U -C bh -W b'),(71,83,'Portrait','-U -C bh -W b'),(75,84,'Do Not Highlight','X'),(76,84,'Highlight Negative Nums','N'),(77,84,'Highlight Positive Nums','P'),(78,85,'Header','H'),(79,85,'Footer','F'),(80,85,'Both','B'),(81,86,'Show','1'),(82,86,'Hide','0'),(83,70,'English','English'),(84,70,'Japanese','Japanese'),(85,89,'0','0'),(86,89,'1','1'),(87,89,'2','2'),(88,89,'3','3'),(89,89,'4','4'),(90,90,'Check for Admin can set Disclaim','N'),(91,90,'Check for Admin can set Disclaim','Y'),(54,5,'2','2'),(90,84,'Highlight Maximum Values','M'),(91,30,'VBox','45'); DROP TABLE IF EXISTS `prefs_info`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `prefs_info` ( `pi_seq` int(11) DEFAULT NULL, `pi_id` int(11) NOT NULL DEFAULT '0', `pi_reptype` char(24) DEFAULT NULL, `pi_access` char(2) DEFAULT NULL, PRIMARY KEY (`pi_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `prefs_info` VALUES (1,1,'combobox','U'),(1,2,'combobox','U'),(1,3,'combobox','U'),(1,4,'combobox','U'),(3,6,'checkbox','U'),(1,30,'combobox','U'),(3,31,'checkbox','U'),(1,45,'combobox','U'),(1,46,'combobox','U'),(1,49,'combobox','U'),(1,55,'combobox','U'),(1,0,'combobox','A'),(2,7,'textbox','A'),(1,8,'combobox','A'),(2,9,'textbox','A'),(3,10,'checkbox','A'),(3,11,'checkbox','A'),(1,12,'combobox','A'),(2,13,'textbox','A'),(2,14,'textbox','A'),(3,15,'checkbox','A'),(2,16,'textbox','A'),(2,17,'textbox','A'),(2,18,'textbox','A'),(2,19,'textbox','A'),(3,20,'checkbox','A'),(2,21,'textbox','A'),(2,22,'textbox','A'),(2,23,'textbox','A'),(2,24,'textbox','A'),(2,27,'textbox','A'),(3,28,'checkbox','A'),(3,29,'checkbox','A'),(2,32,'textbox','A'),(2,33,'textbox','A'),(2,34,'textbox','A'),(2,35,'textbox','A'),(1,36,'combobox','A'),(2,37,'textbox','A'),(2,38,'textbox','A'),(3,39,'checkbox','A'),(2,40,'textbox','A'),(2,41,'textbox','A'),(3,42,'checkbox','A'),(3,43,'checkbox','A'),(3,44,'checkbox','A'),(2,47,'textbox','A'),(2,48,'textbox','A'),(2,50,'textbox','A'),(1,51,'combobox','U'),(3,52,'checkbox','A'),(2,58,'textbox','U'),(3,59,'checkbox','U'),(2,60,'textbox','A'),(2,57,'textbox','A'),(4,62,'checkbox','U'),(2,53,'textbox','A'),(3,63,'checkbox','A'),(1,64,'combobox','U'),(1,65,'checkbox','A'),(3,68,'checkbox','A'),(3,69,'checkbox','A'),(3,71,'checkbox','A'),(1,67,'combobox','A'),(1,73,'checkbox','A'),(1,76,'textbox','U'),(1,75,'combobox','A'),(1,77,'checkbox','A'),(3,74,'checkbox','A'),(3,79,'checkbox','A'),(2,80,'textbox','A'),(1,82,'combobox','A'),(1,83,'combobox','U'),(1,84,'combobox','U'),(1,85,'combobox','U'),(1,86,'combobox','U'),(1,70,'combobox','U'),(1,89,'combobox','U'),(4,90,'checkbox','A'),(2,54,'textbox','U'),(1,92,'checkbox','A'); DROP TABLE IF EXISTS `edash_svcs`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `edash_svcs` ( `svcname` char(20) NOT NULL DEFAULT '', `servtier` int(11) DEFAULT NULL, `server` int(11) DEFAULT NULL, `svcnum` int(11) DEFAULT NULL, PRIMARY KEY (`svcname`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `edash_svcs` VALUES ('home.rx',20,22,1),('login.rx',20,22,2),('logout.rx',20,22,3),('admmain.rx',20,24,1),('texpand.rx',20,23,11),('mselect.rx',20,23,12),('menu.rx',20,23,4),('main.rx',20,23,1),('ctxt.rx',20,23,14),('displaygraph.rx',10,11,2),('multiapp.rx',20,23,13),('menucat.rx',20,23,15),('gengraph.rx',20,23,16),('drill.rx',20,23,17),('top.rx',20,23,2),('showcats.rx',20,23,18),('dispbtn.rx',20,23,19),('bot.rx',20,23,6),('mainmenu.rx',20,23,20),('analyse.rx',20,23,21),('reports.rx',20,23,22),('foldmenu.rx',20,23,23),('reportlist.rx',20,23,24),('dashmenu.rx',20,23,25),('dispdash.rx',20,23,26),('foldadd.rx',20,23,27),('dashadd.rx',20,23,28),('menuclrctl.rx',20,23,29),('clearmenu.rx',20,23,30),('menu1.rx',20,23,31),('graphctl.rx',10,11,3),('userctl.rx',20,23,33),('save.rx',20,23,34),('dispgraph.rx',20,23,35),('filter.rx',20,23,36),('dograph.rx',20,23,37),('systab.rx',20,23,38),('sysmenu.rx',20,23,39),('formchgpass.rx',20,23,40),('chgpass.rx',20,23,41),('formfeedback.rx',20,23,42),('feedback.rx',20,23,43),('deldash.rx',20,23,44),('delfold.rx',20,23,45),('admmenu.rx',20,24,2),('admcfg.rx',20,24,40),('admuser.rx',20,24,4),('admcfglist.rx',20,24,36),('admcfgform.rx',20,24,38),('admupdtcfg.rx',20,24,39),('admuserlist.rx',20,24,7),('admuserform.rx',20,24,11),('admupdtuser.rx',20,24,9),('admschema.rx',20,24,5),('admsys.rx',20,24,6),('admjoinlist.rx',20,24,15),('admdojoin.rx',20,24,16),('admjoinform.rx',20,24,17),('admupdtjoin.rx',20,24,18),('admsysmenu.rx',20,24,19),('admfrmchgpas.rx',20,24,20),('admchgpas.rx',20,24,21),('admmsg.rx',20,24,22),('admtablist.rx',20,24,23),('userfilter.rx',20,23,46),('newgraph.rx',10,11,1),('graphaction.rx',10,11,4),('target.rx',10,11,5),('browser.rx',20,22,4),('dashboard.rx',20,23,47),('uisavegraph.rx',10,11,6),('actsavegraph.rx',10,11,7),('dosavegraph.rx',10,11,8),('resetgraph.rx',10,11,9),('factrecs.rx',20,23,49),('factdtls.rx',20,23,48),('admupdttab.rx',20,24,24),('admfrmresetpas.rx',20,24,25),('admresetpas.rx',20,24,26),('admfrmip.rx',20,24,27),('admfrmfb.rx',20,24,29),('dispdetails.rx',20,23,50),('dtlmenu.rx',20,23,51),('showdetails.rx',20,23,52),('spreadsheet.rx',10,11,10),('admgroup.rx',20,24,30),('gcustomctl.rx',10,11,11),('admgrouplist.rx',20,24,31),('admgroupform.rx',20,24,33),('admupdtgroup.rx',20,24,34),('admgrouplist1.rx',20,24,35),('admuserlist1.rx',20,24,8),('mailoption.rx',20,23,50),('mailupdt.rx',20,23,51),('admuserfilter.rx',20,24,12),('admcfglist1.rx',20,24,41),('admgroupfilter.rx',20,24,13),('userprefs.rx',20,23,53),('etlmain.rx',20,13,3),('etlmenu.rx',20,13,2),('admetlconf.rx',20,13,9),('admetlconflist.rx',20,13,10),('admetlconfwork.rx',20,13,11),('admetlwork.rx',20,13,8),('admmetadata.rx',20,24,48),('reportsearch.rx',20,23,54),('alert.rx',20,23,55),('admmeta.rx',20,24,50),('admmetalist.rx',20,24,49),('search.rx',20,22,5),('preview.rx',20,24,51),('udmsrserv.rx',20,23,56),('dashset.rx',20,23,57),('targets.rx',20,23,58),('tgtreportlist.rx',20,23,60),('tgtreports.rx',20,23,59),('rxxml.rx',10,11,12),('m_logout.rx',20,23,61),('admetlprocupdt.rx',20,13,6),('admetlmenu.rx',20,13,7),('admetlform.rx',20,13,4),('admetl.rx',20,13,1),('pdfreport.rx',10,11,13),('portal.rx',20,23,62),('cubui.rx',20,24,55); DROP TABLE IF EXISTS `cubot_help`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `cubot_help` ( `ch_id` char(16) DEFAULT NULL, `ch_page` char(16) DEFAULT NULL, `help_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`help_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `cubot_help` VALUES ('MAIN_HELP','help.html',0),('MAIN_HELP','help.html',1),('MAIN_HELP','help.html',2),('MAIN_HELP','help.html',3),('MAIN_HELP','help.html',4),('MAIN_HELP','help.html',5),('MAIN_HELP','help.html',6); DROP TABLE IF EXISTS `cuberrors`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `cuberrors` ( `err_id` int(11) NOT NULL DEFAULT '0', `err_msg` char(254) DEFAULT NULL, PRIMARY KEY (`err_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `cuberrors` VALUES (5106,'Destination store is not selected'),(5103,'Task name is a mandatory field'),(5102,'Enter task name'),(5052,'Duplicate process name'),(5051,'Name is a mandatory field'),(5046,'Invalid filemask name'),(5045,'Table name should not be more than 64 characters'),(5043,'Column does not exist for the table.'),(5042,'Duplicate column name.'),(1,'Operation successfully completed.'),(5036,'Invalid select query syntax. Missing SELECT/FROM keyword'),(0,'Unknown Error!'),(5035,'Select column to index.'),(5034,'Select atleast one column for primary key.'),(5033,'Mask name and Mask format field cannot be empty.'),(5030,'Directory path can not be blank.'),(5028,'Not a valid format.'),(6051,'Please select source and destiantion tables'),(6052,'Table does not exist.'),(6054,'Value deleted from the table.'),(6055,'This column already exists.'),(6058,'Data in fact and dimension table is not consistent'),(6059,'Source table and Destination table can not be same.'),(6060,'Table name is a mandatory field'),(6061,'Please select table type.'),(6062,'Please enter valid table name.'),(6063,'Field name is a required field'),(6001,'Enter a valid Username and Password.'),(6012,'Password too short in length.'),(6013,'Password too long.'),(6014,'This account has been blocked due to excessive incorrect login attempts. Contact CUBOT system administrator to activate.'),(6015,'This account has been expired. Contact CUBOT system administrator to activate.'),(6016,'Change the password.'),(6018,'Username and password do not match'),(6019,'Select table type.'),(5026,'Field can not be blank.'),(5025,'Query name and SQL query fields cannot be blank.'),(5024,'Mapname cannot blank.'),(5023,'Select atleast one table from the list.'),(5022,'Select DSN.'),(5017,'Unable to save.'),(5016,'Enter only alphanumerics.'),(5015,'Field cannot be blank.'),(6020,'This account has been disabled. Please contact CUBOT system administrator.'),(6021,'This User ID has been expired'),(2007,'Select flag color.'),(2008,'At least one one condition is required to save.'),(2006,'Click on Add to save the condition.'),(7001,'Enter user ID'),(7002,'Select user ID to copy'),(7003,'Enter valid user ID'),(7004,'User ID already exists'),(7005,'Group Roles is mandatory field'),(7006,'Choose atleast one admin role to enable Read Only Admin'),(7007,'Admin user cannot be deleted'),(7008,'Cannot delete currently signed in user.'),(7009,'User ID cannot exceed 16 characters'),(7011,'Enter valid date'),(7021,'Group cannot be deleted as admin belongs to this group'),(7022,'Group belongs to currently logged in user, Cannot be deleted'),(7023,'Group name is required field'),(7024,'Group name must not exceed 16 characters'),(7025,'Group Description must not exceed 30 characters'),(7026,'Duplicate Group Name.'),(7030,'Enter Group description'),(7041,'Name is a required field'),(7042,'Column name is a required field'),(7043,'Menu item id already exists'),(7044,'Enter suffix'),(7045,'Enter time column'),(7046,'Enter the table name'),(7047,'ID is a required field'),(7048,'Please enter a number'),(7049,'Enter valid ID'),(7050,'This item is already available at the top of the list'),(7051,'This item is already available at the end of the list'),(7027,'Enter valid group name'),(7028,'Enter filter value or select values from the list'),(7029,'Enter filter value'),(2051,'Invalid measure name.'),(2009,'Invalid Formula. Check the formula items'),(2000,'Only alphanumerics are permitted for alert name'),(2001,'Enter alert description'),(2002,'Enter alert name'),(2003,'Enter valid characters in alert description'),(2004,'No criteria is selected'),(2005,'Enter formula in text area'),(5053,'Process is a required field'),(5054,'Enter valid characters in name field'),(6064,'Column does not exist'),(6065,'Select different tables'),(6066,'Please select a table from Table-1 and Table-2'),(6067,'Please select a column from Column-1 and Column-2'),(6068,'Join already exists'),(7010,'No report selected for required option'),(2010,'Dash folder already exists'),(6069,'Graphserver not running'),(6070,'Please select a table.'),(7052,'Invalid name'),(5002,'Invalid store IP address.'),(5001,'Store name is required field'),(5037,'Column Name can not be empty'),(5057,'Invalid file name.'),(5222,'File not found'),(7054,'No Id Found'),(5020,'Workflow name is a required field'),(7012,'Enter a valid category name'),(5055,'No database name'),(5056,'Database system not selected'),(5047,'Connection to database failed'),(7013,'Enter valid phone number'),(7014,'Enter valid email id'),(7016,'Select system also to view feedback'),(5206,'Can not process file.'),(7015,'Selection of ETL is mandatory to enable Execute Process'),(7055,'Table has more than 255 columns'),(7053,'Dupliacte Id Found'),(7056,'Update Note with minimum of 10 Characters'),(6071,'Column of master table(column-2) doesn\'t have Primary Key or Unique Index'),(6024,'Permission Denied'); DROP TABLE IF EXISTS `time`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `time` ( `val` int(11) NOT NULL DEFAULT '0', `year` int(11) DEFAULT NULL, `quarter` char(10) DEFAULT NULL, `month` char(10) DEFAULT NULL, `yrmth` char(12) DEFAULT NULL, `week` char(10) DEFAULT NULL, `day` tinyint(4) DEFAULT NULL, `dayofweek` char(10) DEFAULT NULL, `hour` int(11) DEFAULT NULL, `finyr` char(10) DEFAULT NULL, `finmth` char(10) DEFAULT NULL, `finqtr` char(12) DEFAULT NULL, PRIMARY KEY (`val`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; INSERT INTO `time` VALUES (1,2005,'Qtr-1','JAN','2008-01','0',1,'Sunday',NULL,'2003-04','APR','Qtr-1'),(2,2006,'Qtr-2','FEB','2008-02','1',2,'Monday',1,'2004-05','MAY','Qtr-2'),(3,2007,'Qtr-3','MAR','2008-03','2',3,'Tuesday',2,'2005-06','JUN','Qtr-3'),(4,2008,'Qtr-4','APR','2008-04','3',4,'Wednesday',3,'2006-07','JUL','Qtr-4'),(5,2009,NULL,'MAY','2008-05','4',5,'Thursday',4,'2007-08','AUG',NULL),(6,2010,NULL,'JUN','2008-06','5',6,'Friday',5,'2008-09','SEP',NULL),(7,2011,NULL,'JULY','2008-07','6',7,'Saturday',6,'2009-10','OCT',NULL),(8,2012,NULL,'AUG','2008-08','7',8,NULL,7,'2010-11','NOV',NULL),(9,2013,NULL,'SEP','2008-09','8',9,NULL,8,NULL,'DEC',NULL),(10,2014,NULL,'OCT','2008-10','9',10,NULL,9,NULL,'JAN',NULL),(11,2015,NULL,'NOV','2008-11','10',11,NULL,10,NULL,'FEB',NULL),(12,2016,NULL,'DEC','2008-12','11',12,NULL,11,NULL,'MAR',NULL),(13,NULL,NULL,NULL,'2009-01','12',13,NULL,12,NULL,NULL,NULL),(14,NULL,NULL,NULL,'2009-02','13',14,NULL,13,NULL,NULL,NULL),(15,NULL,NULL,NULL,'2009-03','14',15,NULL,14,NULL,NULL,NULL),(16,NULL,NULL,NULL,'2009-04','15',16,NULL,15,NULL,NULL,NULL),(17,NULL,NULL,NULL,'2009-05','16',17,NULL,16,NULL,NULL,NULL),(18,NULL,NULL,NULL,'2009-06','17',18,NULL,17,NULL,NULL,NULL),(19,NULL,NULL,NULL,'2009-07','18',19,NULL,18,NULL,NULL,NULL),(20,NULL,NULL,NULL,'2009-08','19',20,NULL,19,NULL,NULL,NULL),(21,NULL,NULL,NULL,'2009-09','20',21,NULL,20,NULL,NULL,NULL),(22,NULL,NULL,NULL,'2009-10','21',22,NULL,21,NULL,NULL,NULL),(23,NULL,NULL,NULL,'2009-11','22',23,NULL,22,NULL,NULL,NULL),(24,NULL,NULL,NULL,'2009-12','23',24,NULL,23,NULL,NULL,NULL),(25,NULL,NULL,NULL,'2010-01','24',25,NULL,NULL,NULL,NULL,NULL),(26,NULL,NULL,NULL,'2010-02','25',26,NULL,NULL,NULL,NULL,NULL),(27,NULL,NULL,NULL,'2010-03','26',27,NULL,NULL,NULL,NULL,NULL),(28,NULL,NULL,NULL,'2010-04','27',28,NULL,NULL,NULL,NULL,NULL),(29,NULL,NULL,NULL,'2010-05','28',29,NULL,NULL,NULL,NULL,NULL),(30,NULL,NULL,NULL,'2010-06','29',30,NULL,NULL,NULL,NULL,NULL),(31,NULL,NULL,NULL,'2010-07','30',31,NULL,NULL,NULL,NULL,NULL),(32,NULL,NULL,NULL,'2010-08','31',NULL,NULL,NULL,NULL,NULL,NULL),(33,NULL,NULL,NULL,'2010-09','32',NULL,NULL,NULL,NULL,NULL,NULL),(34,NULL,NULL,NULL,'2010-10','33',NULL,NULL,NULL,NULL,NULL,NULL),(35,NULL,NULL,NULL,'2010-11','34',NULL,NULL,NULL,NULL,NULL,NULL),(36,NULL,NULL,NULL,'2010-12','35',NULL,NULL,NULL,NULL,NULL,NULL),(37,NULL,NULL,NULL,'2011-01','36',NULL,NULL,NULL,NULL,NULL,NULL),(38,NULL,NULL,NULL,'2011-02','37',NULL,NULL,NULL,NULL,NULL,NULL),(39,NULL,NULL,NULL,'2011-03','38',NULL,NULL,NULL,NULL,NULL,NULL),(40,NULL,NULL,NULL,'2011-04','39',NULL,NULL,NULL,NULL,NULL,NULL),(41,NULL,NULL,NULL,'2011-05','40',NULL,NULL,NULL,NULL,NULL,NULL),(42,NULL,NULL,NULL,'2011-06','41',NULL,NULL,NULL,NULL,NULL,NULL),(44,NULL,NULL,NULL,NULL,'43',NULL,NULL,NULL,NULL,NULL,NULL),(45,NULL,NULL,NULL,'2011-09','44',NULL,NULL,NULL,NULL,NULL,NULL),(46,NULL,NULL,NULL,'2011-10','45',NULL,NULL,NULL,NULL,NULL,NULL),(47,NULL,NULL,NULL,'2011-11','46',NULL,NULL,NULL,NULL,NULL,NULL),(48,NULL,NULL,NULL,'2011-12','47',NULL,NULL,NULL,NULL,NULL,NULL),(49,NULL,NULL,NULL,'2012-01','48',NULL,NULL,NULL,NULL,NULL,NULL),(50,NULL,NULL,NULL,'2012-02','49',NULL,NULL,NULL,NULL,NULL,NULL),(51,NULL,NULL,NULL,'2012-03','50',NULL,NULL,NULL,NULL,NULL,NULL),(52,NULL,NULL,NULL,'2012-04','51',NULL,NULL,NULL,NULL,NULL,NULL),(43,NULL,NULL,NULL,'2011-07','42',NULL,NULL,NULL,NULL,NULL,NULL),(53,NULL,NULL,NULL,'2012-05','52',NULL,NULL,NULL,NULL,NULL,NULL),(54,NULL,NULL,NULL,'2012-06',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,NULL,NULL,NULL,'2012-07',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,NULL,NULL,NULL,'2012-08',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,NULL,NULL,NULL,'2012-09',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,NULL,NULL,NULL,'2012-10',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,NULL,NULL,NULL,'2012-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,NULL,NULL,NULL,'2012-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,NULL,NULL,NULL,'2013-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,NULL,NULL,NULL,'2013-02',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,NULL,NULL,NULL,'2013-03',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,NULL,NULL,NULL,'2013-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,NULL,NULL,NULL,'2013-05',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,NULL,NULL,NULL,'2013-06',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,NULL,NULL,NULL,'2013-07',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,NULL,NULL,NULL,'2013-08',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,NULL,NULL,NULL,'2013-09',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,NULL,NULL,NULL,'2013-10',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,NULL,NULL,NULL,'2013-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,NULL,NULL,NULL,'2013-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL);