Open tiagocaus opened 1 year ago
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(),
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:
Now relevant to the tables:
First column:
The last two columns: