CREATE DATABASE iiabmdb20230821;
RENAME TABLE iiabmdb.not_test_experiment TO iiabmdb20230821.not_test_experiment,
iiabmdb.not_test_result TO iiabmdb20230821.not_test_result,
iiabmdb.not_test_sample TO iiabmdb20230821.not_test_sample,
iiabmdb.test_experiment TO iiabmdb20230821.test_experiment,
iiabmdb.test_result TO iiabmdb20230821.test_result,
iiabmdb.test_sample TO iiabmdb20230821.test_sample;
RENAME TABLE iiabmdb.with_exp_experiment TO iiabmdb20230821.with_exp_experiment,
iiabmdb.with_exp_result TO iiabmdb20230821.with_exp_result,
iiabmdb.with_exp_sample TO iiabmdb20230821.with_exp_sample,
iiabmdb.without_exp_experiment TO iiabmdb20230821.without_exp_experiment,
iiabmdb.without_exp_result TO iiabmdb20230821.without_exp_result,
iiabmdb.without_exp_sample TO iiabmdb20230821.without_exp_sample;