#7 Feature table is not created properly

[jakesrt8]

The install.php does not create the serverId row for the feature table. Took me a while to figure this out. So for new users this makes it so we cannot add features.

if (isset($_GET["updateFeatureTable"])) {
    $alter = $db->query("ALTER TABLE feature ADD serverId INT NOT NULL DEFAULT '1' AFTER id");
} else {
    $create = $db->query("CREATE TABLE IF NOT EXISTS feature (
                  id int(11) NOT NULL AUTO_INCREMENT,
                  `name` varchar(40) NOT NULL,
                  alias varchar(40) NOT NULL,
                  PRIMARY KEY (id)
                ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;");
}

[jakesrt8]

I think Calendar has the same issue but not sure it is as important:

if (isset($_GET["removeCalendarId"])) {
    $alter = $db->query("ALTER TABLE calendar DROP id");
    $alter = $db->query("ALTER TABLE calendar DROP PRIMARY KEY, ADD PRIMARY KEY(datetime)");
} else {
    $create = $db->query("CREATE TABLE IF NOT EXISTS calendar (
                  id int(11) NOT NULL AUTO_INCREMENT,
                  `datetime` datetime NOT NULL,
                  UNIQUE KEY id (id)
                ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;");
}

[Stefan Gassner]

thanks for your information - i fixed both problems and will upload the next version 2.1 within the next days.