CREATE TABLE users (id INT UNSIGNED NOT NULL AUTO_INCREMENT, ign VARCHAR(100), email VARCHAR(255) NOT NULL, password VARCHAR(100) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id));
CREATE TABLE items(id INT UNSIGNED NOT NULL AUTO_INCREMENT,name VARCHAR(255) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY fk_purchase_id (purchase_id));
CREATE TABLE transaction (id INT UNSIGNED NOT NULL AUTO_INCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY fk_user_id (user_id), KEY fk_item_id (item_id));
CREATE TABLE purchase (id INT UNSIGNED NOT NULL AUTO_INCREMENT, price FLOAT NOT NULL DEFAULT 0, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id));
What I have tried:
CREATE TABLE users (id INT UNSIGNED NOT NULL AUTO_INCREMENT, ign VARCHAR(100), email VARCHAR(255) NOT NULL, password VARCHAR(100) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id));
CREATE TABLE items(id INT UNSIGNED NOT NULL AUTO_INCREMENT,name VARCHAR(255) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY fk_purchase_id (purchase_id));
CREATE TABLE transaction (id INT UNSIGNED NOT NULL AUTO_INCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY fk_user_id (user_id), KEY fk_item_id (item_id));
CREATE TABLE purchase (id INT UNSIGNED NOT NULL AUTO_INCREMENT, price FLOAT NOT NULL DEFAULT 0, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id));