SQLite Forum

create table
Login
Hi, when try to create table syntax error even I change that to other syntax again same error appear near "user_id in line 3 and 10.
here is SQL table.
 
CREATE TABLE transactions (
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 user_id INTEGER NOT NULL,
 name TEXT NOT NULL,
 shares INTEGER NOT NULL,
 price NUMERIC NOT NULL,
 type TEXT NOT NULL,
 symbol TEXT NOT NULL,
 time TIMESTAMP DEFAULT CURRENT_TIMRSTAMP,
 FORIEGN KEY(user_id) REFERENCES users(id)
);