Hands-On Microservices with Rust

Database structure and migrations

Let's start by creating the database structure. We need four tables:

• users: Contains users' accounts
• channels: Contains channels created by users
• memberships: Users belonging to a channel
• messages: Messages of users in channels

To add these tables, we will add four migrations to a new project:

cargo new --lib chatcd chatdiesel setupdiesel migration generate create_usersdiesel migration generate create_channelsdiesel migration generate create_membershipsdiesel migration generate create_messages

The preceding commands created these migrations:

00000000000000_diesel_initial_setup2019-01-06-192329_create_users2019-01-06-192333_create_channels2019-01-06-192338_create_memberships2019-01-06-192344_create_messages ...