USE STORM; # # Table structure for table `chknet_dev` # CREATE TABLE chknet_dev ( id int(3) NOT NULL auto_increment, name varchar(20) NOT NULL default '', hostname varchar(30) NOT NULL default '', grp int(3) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id_2 (id), KEY id (id) ) TYPE=MyISAM; # # Table structure for table `chknet_grp` # CREATE TABLE chknet_grp ( id int(3) NOT NULL auto_increment, name varchar(20) NOT NULL default '', ordr int(3) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id_2 (id), KEY id (id) ) TYPE=MyISAM; # # Table structure for table `chknet_settings` # CREATE TABLE chknet_settings ( function char(30) NOT NULL default '', value char(30) NOT NULL default '', PRIMARY KEY (function), UNIQUE KEY function_2 (function), KEY function (function) ) TYPE=MyISAM; # # Dumping data for table `chknet_settings` # INSERT INTO chknet_settings VALUES ('pingpath', '/usr/bin/fping'); INSERT INTO chknet_settings VALUES ('pingoptions', '-qa'); INSERT INTO chknet_settings VALUES ('refresh', '20'); INSERT INTO chknet_settings VALUES ('failcolour', '#FF0000'); INSERT INTO chknet_settings VALUES ('okcolour', '#33FF33'); INSERT INTO chknet_settings VALUES ('pingtype', 'unixfping'); # -------------------------------------------------------- # # Dumping data for table `settings` # INSERT INTO settings VALUES ('daysSinceDay', '1'); INSERT INTO settings VALUES ('daysSinceMon', '9'); # -------------------------------------------------------- # # Table structure for table `users` # ALTER TABLE users ADD COLUMN `chknet` int(1) NOT NULL default '0' AFTER CartMan; UPDATE users SET chknet = '3' WHERE username = 'admin'; # # Set permissions on new tables # GRANT SELECT, UPDATE, INSERT, DELETE ON STORM.chknet_dev TO admin@localhost; GRANT SELECT, UPDATE, INSERT, DELETE ON STORM.chknew_grp TO admin@localhost; GRANT SELECT, UPDATE ON STORM.chknet_settings TO admin@localhost; GRANT SELECT ON STORM.chknet_dev TO ict@localhost; GRANT SELECT ON STORM.chknet_grp TO ict@localhost; GRANT SELECT ON STORM.chknet_settings TO ict@localhost;