I am attempting to manipulate the code so that each account has an associated Type. To do so, I need to update the database. I currently have this:
if (CURRENT_DATABASE_VERSION == '0.8.6') { // Insert queries here required to update to DB version 0.8.7 mysqli_query($mysqli, "ALTER TABLE `accounts` ADD `account_type`int(6)DEFAULTNULL AFTER `account_notes`");
// Then, update the database to the next sequential version mysqli_query($mysqli, "UPDATE `settings` SET `config_current_database_version` = '0.8.7'"); }
and
DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts` (
`account_id`int(11) NOT NULL AUTO_INCREMENT,
`account_name`varchar(200) NOT NULL,
`opening_balance`decimal(15,2) NOT NULLDEFAULT0.00,
`account_currency_code`varchar(200) NOT NULL,
`account_notes`textDEFAULTNULL,
`account_type`int(6) NOT NULL,
Changes here
`account_created_at` datetime NOT NULLDEFAULTcurrent_timestamp(),
`account_updated_at` datetimeDEFAULTNULL ON UPDATE current_timestamp(),
`account_archived_at` datetimeDEFAULTNULL,
PRIMARY KEY(`account_id`)
) ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
I go to /post.php?update_db and get a confirmation that the database was updated, but i do not see it.