summaryrefslogtreecommitdiffstats
path: root/apis/update.inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'apis/update.inc.php')
-rw-r--r--apis/update.inc.php273
1 files changed, 0 insertions, 273 deletions
diff --git a/apis/update.inc.php b/apis/update.inc.php
index e7ecc6bd..d3262eb3 100644
--- a/apis/update.inc.php
+++ b/apis/update.inc.php
@@ -56,277 +56,4 @@ if ($list === false) {
Message::addSuccess('db-update-done');
if (tableExists('eventlog'))
EventLog::info("Database updated to version $currentVersion");
-DefaultData::populate();
Util::redirect('index.php?do=Main');
-
-////////////////
-
-function tableHasColumn($table, $column)
-{
- $table = preg_replace('/\W/', '', $table);
- $column = preg_replace('/\W/', '', $column);
- $res = Database::simpleQuery("DESCRIBE `$table`", array(), true);
- if ($res !== false) {
- while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
- if ((is_array($column) && in_array($row['Field'], $column)) || (is_string($column) && $row['Field'] === $column))
- return true;
- }
- }
- return false;
-}
-
-function tableDropColumn($table, $column)
-{
- $table = preg_replace('/\W/', '', $table);
- $column = preg_replace('/\W/', '', $column);
- $res = Database::simpleQuery("DESCRIBE `$table`", array(), true);
- if ($res !== false) {
- while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
- if ((is_array($column) && in_array($row['Field'], $column)) || (is_string($column) && $row['Field'] === $column))
- Database::exec("ALTER TABLE `$table` DROP `{$row['Field']}`");
- }
- }
-}
-
-function tableExists($table)
-{
- $res = Database::simpleQuery("SHOW TABLES", array(), true);
- while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
- if ($row['Tables_in_openslx'] === $table)
- return true;
- }
- return false;
-}
-
-// The update functions. Number at the end refers to current version, the function will update to the next version
-// #######################
-// ##### 2014-05-28
-// Add dateline field to property table
-
-function update_1()
-{
- if (!tableHasColumn('property', 'dateline')) {
- Database::exec("ALTER TABLE `property` ADD `dateline` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `name` , ADD INDEX ( `dateline` )");
- } else {
- Database::exec("ALTER TABLE `property` CHANGE `dateline` `dateline` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'");
- }
- return true;
-}
-
-// #######################
-// ##### 2014-06-05
-// Add 'news' table to database schema
-function update_2()
-{
- if (!tableExists('news')) {
- // create table
- Database::exec("CREATE TABLE IF NOT EXISTS `news` (
- `newsid` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `dateline` int(10) unsigned NOT NULL,
- `title` varchar(200) DEFAULT NULL,
- `content` text,
- PRIMARY KEY (`newsid`),
- KEY `dateline` (`dateline`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- ");
- }
- return true;
-}
-
-// #######################
-// ##### 2014-08-18
-// Remove setting descriptions from DB, put into json files now
-function update_3()
-{
- tableDropColumn('setting', array('de', 'en', 'pt', 'description'));
- tableDropColumn('cat_setting', array('de', 'en', 'pt', 'name'));
- return true;
-}
-
-// #######################
-// ##### 2014-08-18
-// Remove description column from permission table, add eventlog table
-function update_4()
-{
- tableDropColumn('permission', 'description');
- if (!tableExists('eventlog')) {
- // create table
- Database::exec("CREATE TABLE IF NOT EXISTS `eventlog` (
- `logid` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `dateline` int(10) unsigned NOT NULL,
- `logtypeid` varchar(30) NOT NULL,
- `description` varchar(255) NOT NULL,
- PRIMARY KEY (`logid`),
- KEY `dateline` (`dateline`),
- KEY `logtypeid` (`logtypeid`,`dateline`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ");
- }
- return true;
-}
-
-// #######################
-// ##### 2014-08-18
-// Add details column to eventlog table, add callback table
-function update_5()
-{
- if (!tableHasColumn('eventlog', 'extra'))
- Database::exec("ALTER TABLE `eventlog` ADD `extra` TEXT NOT NULL");
- if (!tableHasColumn('user', 'lasteventid'))
- Database::exec("ALTER TABLE `user` ADD `lasteventid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'");
- if (!tableExists('callback')) {
- Database::exec("CREATE TABLE IF NOT EXISTS `callback` (
- `taskid` varchar(40) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
- `dateline` int(10) unsigned NOT NULL,
- `cbfunction` varchar(16) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
- PRIMARY KEY (`taskid`,`cbfunction`),
- KEY `dateline` (`dateline`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- ");
- }
- return true;
-}
-
-// #######################
-// ##### 2014-12-04
-// Add displayvalue column to setting_*
-function update_6()
-{
- foreach (array('setting_global', 'setting_distro') as $table) {
- if (!tableHasColumn($table, 'displayvalue')) {
- Database::exec("ALTER TABLE $table ADD `displayvalue` TEXT NOT NULL");
- Database::exec("UPDATE $table SET displayvalue = value");
- }
- }
- return true;
-}
-
-// #######################
-// ##### 2014-12-12
-// Rename config modules
-function update_7()
-{
- Database::exec("UPDATE configtgz_module SET moduletype = 'Branding' WHERE moduletype = 'BRANDING'");
- Database::exec("UPDATE configtgz_module SET moduletype = 'AdAuth' WHERE moduletype = 'AD_AUTH'");
- Database::exec("UPDATE configtgz_module SET moduletype = 'CustomModule' WHERE moduletype = 'custom'");
- return true;
-}
-
-// #######################
-// ##### 2015-01-16
-// Extend config module db table, add argument feature to callbacks
-function update_8()
-{
- tableDropColumn('configtgz_module', 'haschanged');
- if (!tableHasColumn('configtgz_module', 'version'))
- Database::exec("ALTER TABLE `configtgz_module` ADD `version` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'");
- if (!tableHasColumn('configtgz_module', 'status'))
- Database::exec("ALTER TABLE `configtgz_module` ADD `status` ENUM( 'OK', 'MISSING', 'OUTDATED' ) NOT NULL DEFAULT 'MISSING'");
- if (!tableHasColumn('callback', 'args'))
- Database::exec("ALTER TABLE `callback` ADD `args` TEXT NOT NULL DEFAULT ''");
- if (!tableHasColumn('configtgz', 'status'))
- Database::exec("ALTER TABLE `configtgz` ADD `status` ENUM( 'OK', 'OUTDATED', 'MISSING' ) NOT NULL DEFAULT 'MISSING'");
- return true;
-}
-
-// #######################
-// ##### 2015-05-21
-// Add statistics table, for logging of session length and idle times
-function update_9()
-{
- Database::exec("CREATE TABLE IF NOT EXISTS `statistic` (
- `logid` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `dateline` int(10) unsigned NOT NULL,
- `typeid` varchar(30) NOT NULL,
- `clientip` varchar(40) NOT NULL,
- `username` varchar(30) NOT NULL,
- `data` varchar(255) NOT NULL,
- PRIMARY KEY (`logid`),
- KEY `dateline` (`dateline`),
- KEY `logtypeid` (`typeid`,`dateline`),
- KEY `clientip` (`clientip`,`dateline`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8");
- return true;
-}
-
-// #######################
-// ##### 2015-12-21
-// Add machine uuid column to statistics table
-function update_10()
-{
- if (!tableHasColumn('statistic', 'machineuuid')) {
- Database::exec('ALTER TABLE statistic'
- . ' ADD COLUMN `machineuuid` varchar(36) CHARACTER SET ascii DEFAULT NULL AFTER clientip,'
- . ' ADD INDEX `machineuuid` (`machineuuid`,`dateline`)');
- }
- Database::exec("CREATE TABLE IF NOT EXISTS `machine` (
- `machineuuid` char(36) CHARACTER SET ascii NOT NULL,
- `locationid` int(11) DEFAULT NULL,
- `macaddr` char(17) CHARACTER SET ascii NOT NULL,
- `clientip` varchar(45) CHARACTER SET ascii NOT NULL,
- `firstseen` int(10) unsigned NOT NULL,
- `lastseen` int(10) unsigned NOT NULL,
- `logintime` int(10) unsigned NOT NULL,
- `position` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `lastboot` int(10) unsigned NOT NULL,
- `realcores` smallint(5) unsigned NOT NULL,
- `mbram` int(10) unsigned NOT NULL,
- `kvmstate` enum('UNKNOWN','UNSUPPORTED','DISABLED','ENABLED') NOT NULL,
- `cpumodel` varchar(120) NOT NULL,
- `systemmodel` varchar(120) NOT NULL DEFAULT '',
- `id44mb` int(10) unsigned NOT NULL,
- `badsectors` int(10) unsigned NOT NULL,
- `data` mediumtext NOT NULL,
- `hostname` varchar(200) NOT NULL DEFAULT '',
- `notes` text,
- PRIMARY KEY (`machineuuid`),
- KEY `macaddr` (`macaddr`),
- KEY `clientip` (`clientip`),
- KEY `realcores` (`realcores`),
- KEY `mbram` (`mbram`),
- KEY `kvmstate` (`kvmstate`),
- KEY `id44mb` (`id44mb`),
- KEY `locationid` (`locationid`),
- KEY `lastseen` (`lastseen`),
- KEY `cpumodel` (`cpumodel`),
- KEY `systemmodel` (`systemmodel`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8");
- return true;
-}
-
-function update_11()
-{
- if (tableHasColumn('machine', 'roomid')) {
- Database::exec("ALTER TABLE `machine` CHANGE `roomid` `locationid` INT(11) DEFAULT NULL");
- }
- Database::exec("CREATE TABLE IF NOT EXISTS `setting_location` (
- `locationid` int(11) NOT NULL,
- `setting` varchar(28) NOT NULL,
- `value` text NOT NULL,
- `displayvalue` text NOT NULL,
- PRIMARY KEY (`locationid`,`setting`),
- KEY `setting` (`setting`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8");
- Database::exec("CREATE TABLE IF NOT EXISTS `location` (
- `locationid` int(11) NOT NULL AUTO_INCREMENT,
- `parentlocationid` int(11) NOT NULL,
- `locationname` varchar(100) NOT NULL,
- PRIMARY KEY (`locationid`),
- KEY `locationname` (`locationname`),
- KEY `parentlocationid` (`parentlocationid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
- Database::exec("CREATE TABLE IF NOT EXISTS `subnet` (
- `subnetid` int(11) NOT NULL AUTO_INCREMENT,
- `startaddr` decimal(39,0) unsigned NOT NULL,
- `endaddr` decimal(39,0) unsigned NOT NULL,
- `locationid` int(11) NOT NULL,
- PRIMARY KEY (`subnetid`),
- KEY `startaddr` (`startaddr`,`endaddr`),
- KEY `locationid` (`locationid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
- return true;
-}
-
-// TODO: Remove setting_distro, setting, cat_setting
-// TODO: Add toggle column to setting_global
-// TODO: Add pciid table \ No newline at end of file
generated by cgit v1.2.3-55-g7522 (git 2.39.0) at 2024-11-21 19:05:17 +0100