Dusk #634

Quote:

---

Originally Posted by hc747 [Only registered and activated users can see links. Click Here To Register...]

Yikes. Why would you use username as the primary key? Use a numeric PK with username as an (unique) attribute of the player table. Something akin to this would be much better imo.
[Only registered and activated users can see links. Click Here To Register...]

Code:

---

create table if not exists dusk.item_container
(
    id int auto_increment
        primary key,
    type varchar(50) not null,
    constraint item_container_type_uindex
        unique (type)
);


create table if not exists dusk.player
(
    id int auto_increment
        primary key,
    username varchar(12) not null,
    constraint player_username_uindex
        unique (username)
);


create table if not exists dusk.player_item_container
(
    player_id int not null,
    item_container_id int not null,
    tab int default 0 not null,
    slot int not null,
    item_id int not null,
    item_amount int not null,
    primary key (player_id, item_container_id, tab, slot),
    constraint player_item_container_item_container_id_fk
        foreign key (item_container_id) references dusk.item_container (id),
    constraint player_item_container_player_id_fk
        foreign key (player_id) references dusk.player (id)
);


create index player_item_container_item_id_index
    on dusk.player_item_container (item_id);

---

Regardless, really like this project. Best of luck.

---

That was the initial concept, it's been reworked since then.
Thanks for the valuable feedback, it goes miles.
rep++

good luck!

We will be gifting discord nitro passes monthly starting November. I suggest you join. [Only registered and activated users can see links. Click Here To Register...][Only registered and activated users can see links. Click Here To Register...] for the link :)

Good luck

November 4th, 2020 - Client Plugins & Social Introduction

[Only registered and activated users can see links. Click Here To Register...]

Best of luck!

For those of you who aren't registered on our forums, here's a preview of what the client will look like

[Only registered and activated users can see links. Click Here To Register...]

Quote:

---

Originally Posted by Tyluur [Only registered and activated users can see links. Click Here To Register...]

For those of you who aren't registered on our forums, here's a preview of what the client will look like

[Only registered and activated users can see links. Click Here To Register...]

---

keep up the good work man love it

Progressing on the launcher

[Only registered and activated users can see links. Click Here To Register...]

why is the logo the same as everyone elses jfc