Create Database

[DaDarkWizard]

Create Database

• [x] Initialize database on MySQL server
• [x] Create table to store users
• • [x] Column for souls, id, username
• [x] Create table to store messages
• • [x] Column for message text, userid, messageid

Create Entity Framework Database

• [ ] Create DbContext
• [ ] Create entity for users
• [ ] Create entity for messages

[DaDarkWizard]

create table users(
id int not null,
username nvarchar(255) not null,
souls int not null,
primary key(id)
);

[DaDarkWizard]

create table messages(
id int not null,
userid int not null,
username nvarchar(255) not null,
primary key(id)
);

[DaDarkWizard]

create user 'adventurer'@'%' identified by 'soulsearching';

[DaDarkWizard]

grant all on darkstrolls.* to 'adventurer'@'%';