You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
'year' column is missing in SQL statement for creating 'budgets' table.
Corrected SQL statement:
CREATE TABLE IF NOT EXISTS budgets (
id serial PRIMARY KEY,
name TEXT NOT NULL,
amount REAL,
year INTEGER NOT NULL,
user_id INTEGER NOT NULL,
CONSTRAINT budgets_user_id_fkey FOREIGN KEY (user_id)
REFERENCES users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
);
'year' column is missing in SQL statement for creating 'budgets' table.
Corrected SQL statement:
CREATE TABLE IF NOT EXISTS budgets (
id serial PRIMARY KEY,
name TEXT NOT NULL,
amount REAL,
year INTEGER NOT NULL,
user_id INTEGER NOT NULL,
CONSTRAINT budgets_user_id_fkey FOREIGN KEY (user_id)
REFERENCES users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
);
Bug Source:
https://github.com/eddyharrington/Tendie-Tracker/blob/master/dbCreateStatements-Postgres.txt
The text was updated successfully, but these errors were encountered: