Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE weapons (
    id SERIAL PRIMARY KEY,
    name TEXT,
    type TEXT,
    min_dmg INT,
    max_dmg INT,
    weight INT
);
INSERT INTO weapons (
    name,
    type,
    min_dmg,
    max_dmg,
    weight
) VALUES 
('fork', 'broadsword', '4', '16', '10'),
('spoon', 'heavy-mace', '1', '4', '10');
2 rows affected

SELECT * FROM weapons;


id
name
type
min_dmg
max_dmg
weight


1
fork
broadsword
4
16
10

2
spoon
heavy-mace
1
4
10