TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Configure base settings when creating new database.

Open tiagocaus opened this issue 2 years ago • 0 comments

How to configure some base settings. So whenever a new database is created and new tables already come with these definitions.

Example. When creating a new database, it already comes with these settings:

ENGINE=InnoDB
DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci

Now relevant to the tables:

First column:

`id` int(10) unsigned NOT NULL AUTO_INCREMENT UNIQUE KEY `id` (`id`)

The last two columns:

`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),

tiagocaus avatar Apr 06 '23 12:04 tiagocaus