# SQL hints
INSERT INTO umfragen (id, obct_id, name, created) 
SELECT OBCT_ID, PRIT_NAME, OBCT_CREATED from MC2_OBCT_OBJECT inner join MC2_PRIT_PROJECT_ITEM on MC2_OBCT_OBJECT.obct_id = MC2_PRIT_PROJECT_ITEM.proj_id where MC2_OBCT_OBJECT.obct_subtype = 5 order by obct_id  DESC

## check the size of a DB table
SELECT
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 ) AS `Size (KB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "kulibri_local"
ORDER BY
  (DATA_LENGTH + INDEX_LENGTH)
DESC;


# 10-Apr-2021
ALTER TABLE `dbs1102359`.`users` ADD COLUMN `locale` VARCHAR(2) NOT NULL DEFAULT 'de' AFTER `password`;


# 08-Jul-2021

2 columns added to the participant table
-  $table->string('comment', 1000)->nullable();
-  $table->smallInteger('guests')->default(0);

ALTER TABLE `kulibri_local`.`participants` ADD COLUMN `comment` VARCHAR(1000) AFTER `name`,
ADD COLUMN `guests` SMALLINT(6)  NOT NULL DEFAULT 0 AFTER `comment`;

ALTER TABLE `dbs1102359`.`participants` ADD COLUMN `choice` smallint(6) SIGNED NOT NULL DEFAULT '-1' AFTER `name`;