OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
conf
/
install
/
dbupgrade_tool
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
02/03/2023 07:34:22 AM
rwxr-xr-x
📄
a.sh
85 bytes
02/03/2023 07:34:18 AM
rw-r--r--
📄
cubottable.sh
7.35 KB
02/03/2023 07:34:18 AM
rwxr-xr-x
📄
data.sql
26.07 KB
02/03/2023 07:34:18 AM
rw-r--r--
📄
upgrade_crbt_20140919.sql
0 bytes
02/03/2023 07:34:18 AM
rw-r--r--
📄
upgrade_sampledb_20140919.sql
9.5 KB
02/03/2023 07:34:18 AM
rw-r--r--
📄
writesql.awk
2.73 KB
02/03/2023 07:34:18 AM
rw-r--r--
Editing: data.sql
Close
-- -- Table structure for table `time` -- -- -- Dumping data for table `time` -- LOCK TABLES `time` WRITE; /*!40000 ALTER TABLE `time` DISABLE KEYS */; INSERT IGNORE INTO `time` VALUES (1,NULL,'Qtr-1','JAN','0','Monday',1,'2003-04','Qtr-1','JAN',NULL),(2,NULL,'Qtr-2','FEB','1','Tuesday',2,'2004-05','Qtr-2','FEB',NULL),(3,NULL,'Qtr-3','MAR','2','Wednesday',3,'2005-06','Qtr-3','MAR',NULL),(4,NULL,'Qtr-4','APR','3','Thursday',4,'2006-07','Qtr-4','APR',NULL),(5,NULL,NULL,'MAY','4','Friday',5,'2007-08',NULL,'MAY',NULL),(6,NULL,NULL,'JUN','5','Saturday',6,NULL,NULL,'JUN',NULL),(7,2003,NULL,'JUL','6','Sunday',7,NULL,NULL,'JUL',NULL),(8,2004,NULL,'AUG','7','',8,NULL,NULL,'AUG',NULL),(9,2005,NULL,'SEP','8','',9,NULL,NULL,'SEP',NULL),(10,2006,NULL,'OCT','9','',10,NULL,NULL,'OCT',NULL),(11,2007,NULL,'NOV','10','',11,NULL,NULL,'NOV',NULL),(12,2008,NULL,'DEC','11','',12,NULL,NULL,'DEC',NULL),(13,NULL,NULL,'','12','',13,NULL,NULL,'',NULL),(14,NULL,NULL,NULL,'13',NULL,14,NULL,NULL,NULL,NULL),(15,NULL,NULL,NULL,'14',NULL,15,NULL,NULL,NULL,NULL),(16,NULL,NULL,NULL,'15',NULL,16,NULL,NULL,NULL,NULL),(17,NULL,NULL,NULL,'16',NULL,17,NULL,NULL,NULL,NULL),(18,NULL,NULL,NULL,'17',NULL,18,NULL,NULL,NULL,NULL),(19,NULL,NULL,NULL,'18',NULL,19,NULL,NULL,NULL,NULL),(20,NULL,NULL,NULL,'19',NULL,20,NULL,NULL,NULL,NULL),(21,NULL,NULL,NULL,'20',NULL,21,NULL,NULL,NULL,NULL),(22,NULL,NULL,NULL,'21',NULL,22,NULL,NULL,NULL,NULL),(23,NULL,NULL,NULL,'22',NULL,23,NULL,NULL,NULL,NULL),(24,NULL,NULL,NULL,'23',NULL,NULL,NULL,NULL,NULL,NULL),(25,NULL,NULL,NULL,'24',NULL,NULL,NULL,NULL,NULL,NULL),(26,NULL,NULL,NULL,'25',NULL,NULL,NULL,NULL,NULL,NULL),(27,NULL,NULL,NULL,'26',NULL,NULL,NULL,NULL,NULL,NULL),(28,NULL,NULL,NULL,'27',NULL,NULL,NULL,NULL,NULL,NULL),(29,NULL,NULL,NULL,'28',NULL,NULL,NULL,NULL,NULL,NULL),(30,NULL,NULL,NULL,'29',NULL,NULL,NULL,NULL,NULL,NULL),(31,NULL,NULL,NULL,'30',NULL,NULL,NULL,NULL,NULL,NULL),(32,NULL,NULL,NULL,'31',NULL,NULL,NULL,NULL,NULL,NULL),(33,NULL,NULL,NULL,'32',NULL,NULL,NULL,NULL,NULL,NULL),(34,NULL,NULL,NULL,'33',NULL,NULL,NULL,NULL,NULL,NULL),(35,NULL,NULL,NULL,'34',NULL,NULL,NULL,NULL,NULL,NULL),(36,NULL,NULL,NULL,'35',NULL,NULL,NULL,NULL,NULL,NULL),(37,NULL,NULL,NULL,'36',NULL,NULL,NULL,NULL,NULL,NULL),(38,NULL,NULL,NULL,'37',NULL,NULL,NULL,NULL,NULL,NULL),(39,NULL,NULL,NULL,'38',NULL,NULL,NULL,NULL,NULL,NULL),(40,NULL,NULL,NULL,'39',NULL,NULL,NULL,NULL,NULL,NULL),(41,NULL,NULL,NULL,'40',NULL,NULL,NULL,NULL,NULL,NULL),(42,NULL,NULL,NULL,'41',NULL,NULL,NULL,NULL,NULL,NULL),(44,NULL,NULL,NULL,'43',NULL,NULL,NULL,NULL,NULL,NULL),(43,NULL,NULL,NULL,'42',NULL,NULL,NULL,NULL,NULL,NULL),(45,NULL,NULL,NULL,'44',NULL,NULL,NULL,NULL,NULL,NULL),(46,NULL,NULL,NULL,'45',NULL,NULL,NULL,NULL,NULL,NULL),(47,NULL,NULL,NULL,'46',NULL,NULL,NULL,NULL,NULL,NULL),(48,NULL,NULL,NULL,'47',NULL,NULL,NULL,NULL,NULL,NULL),(49,NULL,NULL,NULL,'48',NULL,NULL,NULL,NULL,NULL,NULL),(50,NULL,NULL,NULL,'49',NULL,NULL,NULL,NULL,NULL,NULL),(51,NULL,NULL,NULL,'50',NULL,NULL,NULL,NULL,NULL,NULL),(52,NULL,NULL,NULL,'51',NULL,NULL,NULL,NULL,NULL,NULL),(0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL),(53,NULL,NULL,NULL,'52',NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `time` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cuberrors` -- DROP TABLE IF EXISTS `cuberrors`; 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; -- -- Dumping data for table `cuberrors` -- LOCK TABLES `cuberrors` WRITE; /*!40000 ALTER TABLE `cuberrors` DISABLE KEYS */; INSERT INTO `cuberrors` VALUES (5110,' Please choose only one table.'),(5109,'Task name already exists.'),(5108,' Please choose only one table.'),(5107,' Please select at least one table from source or destination.or from both.'),(5106,' Destination store is not selected.'),(5105,'Source is a required field'),(5104,' No store groups are defined.'),(5103,'Task name is a required field'),(5102,' Please enter the name for the task.'),(5101,'Please choose a task type.'),(5052,'Duplicate process name'),(5051,'Name is a required field'),(5046,'Invalid Filemask name'),(5045,'Tablename cannot be more than 64 characters'),(5044,'Incorrect sql sytax.database table not affected.'),(5043,'Column does not exist for this table.'),(5042,'Duplicate column name.'),(1,'Operation successfully completed.'),(5038,'Table not exist.'),(5036,'Invalid select query syntax. Missing SELECT/FROM keyword'),(0,'Unknown Error!'),(5035,'Select column for index.'),(5034,'Select atleast one column for primary key.'),(5033,' Mask name and Mask format field cannot be blank.'),(5032,' Duplicate mappings check again.'),(5031,' Space not allowed in name.'),(5030,' Directory path cannot 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.'),(6056,'Database table joins are proper.'),(6057,'Some data are not present in master table.'),(6058,'Data in fact and dimension table is not consistent'),(6059,'Source table and Destination table cannot be same.'),(6060,'Table name is a required field'),(6061,'Please select table type.'),(6062,'Please enter valid table name.'),(6063,'Field name is a required field'),(6001,'Username and password are mandatory fields'),(6012,'Password too short in length.'),(6013,'Password too long.'),(6014,'Account blocked due to excessive incorrect login attempts. Contact Cubot administrator'),(6015,'Account is expired. Please contact Cubot administrator.'),(6016,'Please change the password.'),(6017,'Only alphanumeric characters are allowed in password.'),(6018,'Username and password do not match'),(6019,'Please select table type.'),(5027,' Press refresh before going to next page.'),(5026,' Field cannot blank.'),(5025,' Query name and Sql query fields cannot be blank.'),(5024,' Mapname cannot blank.'),(5023,' Select atleast one table from list.'),(5022,' Select dsn.'),(5019,' Either the command is absent or not found in path or the module is missing.'),(5018,' Duplicate store group name.'),(5017,' Unable to save.'),(5016,'Please enter alphanumerics'),(5015,' Field cannot be empty.'),(6020,'Account has been disabled. Please contact administrator.'),(6021,'User ID has Expired'),(2007,'Please select flag color.'),(2008,'Please add at least one condition to save.'),(2006,'Click on Add to add the condition before saving.'),(7001,'Please enter user id'),(7002,'Select user id to copy'),(7003,'Please enter valid user id'),(7004,'User id already exists'),(7005,'Group Roles is mandatory field'),(7006,'Please choose atleast one admin role to enable Read Only Admin'),(7007,'User admin cannot be deleted'),(7008,'Cannot delete the currently signed in user.'),(7009,'User id cannot exceed the 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,'Please enter group name'),(7024,'Group name cannot exceed the 16 characters'),(7025,'Group Description can be maximum of 30 character'),(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,'Please enter suffix'),(7045,'Please enter time column'),(7046,'Please enter the table name'),(7047,'ID is a required field'),(7048,'Please enter a number'),(7049,'Please 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,'Please enter valid group name'),(7028,'Please enter filter value or select any value from the list'),(7029,'Please enter filter value'),(2051,'Invalid Measure Name.'),(2009,'Invalid Formula. Please check the formula items'),(2000,'Plese enter alert name'),(2001,'Plese enter alert description'),(2002,'Plese enter valid characters in alert name'),(2003,'Plese enter valid characters in alert description'),(2004,'No criteria is selected'),(2005,'Please enter formula in text area'),(5053,'Process is a required field'),(5054,'Please Enter valid characters in Name field'),(6064,'Column not present'),(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 exist'),(7061,'Select one group'),(7062,'Please select parameter'),(7063,'Please enter valid ip value'),(7010,'No report selected for required option'),(2010,'Dash folder already exist'),(6069,'Graphserver not running'),(6070,'Please select a table.'),(7052,'Invalid name'),(5014,' Invalid table name.'),(5013,' Unable to get information for store. Contact Cubot administrator.'),(5012,' Duplicate Store Name.'),(5011,' <B>Invalid field name</B>(Could be duplicate) or <b>Invalid field width</b>(Could be Zero)'),(5010,' Duplicate field name or field width is zero.'),(5009,' Store deletion failed.'),(5008,' Cannpt add store. Check if store name already exists.'),(5007,' Path field cannot be empty.'),(5006,' Either the filename or format are not given.'),(5005,' Field separator not defined.'),(5004,' Either DSN or Database Name missing.'),(5003,' Store name cannot be blank.'),(5002,'Invalid store IP address.'),(5001,'Store name is a required field'),(5111,' Low memory.'),(5112,' Failed to allocate memory.'),(5113,'Command field is empty.'),(5200,'Invalid workflow name.'),(5057,'Invalid file name.'),(5222,'File not found'),(5223,'Duplicate Work flow name'),(5020,'Workflow name is a required field'),(7012,'Invalid Report Category Name'),(5055,'No database name'),(5056,'Database system not selected'),(5047,'Connection to database failed'),(7013,'Please enter valid phone number'),(7014,'Please enter valid email id'),(7015,'Selection of ETL is mandatory to enable Execute process.'),(7016,'Select System also to view feedback'),(5206,'Can not process file.'),(7055,'Table has more than 255 columns'); /*!40000 ALTER TABLE `cuberrors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cubot_help` -- DROP TABLE IF EXISTS `cubot_help`; 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; -- -- Dumping data for table `cubot_help` -- LOCK TABLES `cubot_help` WRITE; /*!40000 ALTER TABLE `cubot_help` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `cubot_help` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `edash_svcs` -- DROP TABLE IF EXISTS `edash_svcs`; 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; -- -- Dumping data for table `edash_svcs` -- LOCK TABLES `edash_svcs` WRITE; /*!40000 ALTER TABLE `edash_svcs` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `edash_svcs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `prefs_info` -- DROP TABLE IF EXISTS `prefs_info`; 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; -- -- Dumping data for table `prefs_info` -- LOCK TABLES `prefs_info` WRITE; /*!40000 ALTER TABLE `prefs_info` DISABLE KEYS */; INSERT INTO `prefs_info` VALUES (1,1,'combobox','U'),(1,2,'combobox','U'),(1,3,'combobox','U'),(1,4,'combobox','U'),(1,5,'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'),(2,54,'textbox','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','A'),(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'); /*!40000 ALTER TABLE `prefs_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `prefs_values` -- DROP TABLE IF EXISTS `prefs_values`; 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; -- -- Dumping data for table `prefs_values` -- LOCK TABLES `prefs_values` WRITE; /*!40000 ALTER TABLE `prefs_values` DISABLE KEYS */; 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','0'),(18,30,'Reports','1'),(19,30,'Analyze','2'),(20,30,'Preferences','5'),(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'),(32,5,'9','9'),(33,5,'4','4'),(34,30,'Alert','3'),(35,30,'Targets','4'),(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'),(46,51,'DD/MM/YYYY','%% d/%% b/%% Y'),(47,51,'DD/Month/YY','%% d/%% B/%% y'),(48,51,'DD/MM\n/YY','%% d/%% b/%% y'),(49,51,'MM/DD/YY','%% b/%% d/%% y'),(50,51,'MM/DD/YYYY','%% b/%% d/%% Y'),(51,51,'YY/MM/DD','%% y/%%\n b/%% d'),(52,51,'YYYY/MM/DD','%% Y/%% b/%% d'),(0,62,'','Y'),(53,5,'1','1'),(54,5,'2','2'),(55,63,'Check for User Define Measures','Y'),(56,63,'Check for User Define Measures','N'),(57,64,'English','en_US.UTF-8'),(58,64,'Dutch','de_DE.UTF-8'),(59,64,'Japanese','ja_JP.UTF-8'); /*!40000 ALTER TABLE `prefs_values` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rd_codes` -- DROP TABLE IF EXISTS `rd_codes`; 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; -- -- Dumping data for table `rd_codes` -- LOCK TABLES `rd_codes` WRITE; /*!40000 ALTER TABLE `rd_codes` DISABLE KEYS */; 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',64,'Feedback','View User Feedback'),('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',5,'No of Reports in Dashboard','Panes per dashboard'),('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',54,'No of Repots on Dashboard','Number of rows'),('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'); /*!40000 ALTER TABLE `rd_codes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ctrl_btn_info` -- DROP TABLE IF EXISTS `ctrl_btn_info`; 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; -- -- Dumping data for table `ctrl_btn_info` -- LOCK TABLES `ctrl_btn_info` WRITE; /*!40000 ALTER TABLE `ctrl_btn_info` DISABLE KEYS */; INSERT INTO `ctrl_btn_info` VALUES (1,'After selecting dimensions and measures, Generate report Automatically, as Preview or only when GO button is pressed.'),(5,'Set the maximum number of reports or graphs per dashboard. For enhanced clarity, select 4.'),(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.'),(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.'),(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'); /*!40000 ALTER TABLE `ctrl_btn_info` ENABLE KEYS */; UNLOCK TABLES; -- Dumping data for table `install_params` INSERT IGNORE 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','3,4',0),(27,'Top n rows on report','10',0),(5,'No of Dashboard','4',3),(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','500',0),(0,'Cubot Version','7.2',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','N',4),(45,'Default Login','A',3),(29,'Show Total','Y',2),(28,'Show Grand Total','Y',2),(51,'Cubot Date Format','%d/%b/%Y',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','myhome1.html',0),(52,' ETL Option','Y',0),(55,'Report Access Level','0',2),(31,'Show Generated Title','Y',2),(30,'Default Login Page Option','1',1),(49,'Default Spreadsheet Option','XL',3),(54,'Default Rows in Dashboard','5',3),(22,'Max Subseries','25',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','N',2),(53,'No of Reports','10',0),(63,'User Can Define Measures','N',3),(64,'User Defined Locale','en_US.UTF-8',0);