Can someone tell me where the syntax error is? Says 'Error creating table error: syntax error at or near "("'
CREATE TABLE IF NOT EXISTS users (
id SERIAL PRIMARY KEY,
username VARCHAR(16) UNIQUE,
premium BOOLEAN,
region place,
steam_id INTEGER UNIQUE,
gold NUMERIC,
gems NUMERIC,
boss_slayer BOOLEAN,
chaos_slayer BOOLEAN,
party TEXT[],
guild_id SERIAL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN_KEY(guild_id) REFERENCES guilds(id)
);
CREATE TABLE IF NOT EXISTS guilds (
id SERIAL PRIMARY KEY,
owner_id SERIAL references users(id),
title VARCHAR(32) UNIQUE,
short VARCHAR(5) UNIQUE,
gold NUMERIC,
members SERIAL[],
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN_KEY(members) REFERENCES users(id)
);
