KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am getting following output on debugger. I am not sure what syntax is missing. The SQL code is: CREATE TABLE weeks(Week_Id INTEGER PRIMARY KEY, Day TEXT, Start_Time Text, End_Time Text, Break_Time Text ); CREATE TABLE projects(Project_Id INTEGER PRIMARY KEY, Name TEXT, Description Text, Client_Name Text, Location Text ); CREATE TABLE timesheets(Timesheet_Id INTEGER PRIMARY KEY, Project_Id INTEGER, FOREIGN KEY (Project_Id) REFERENCES projects (Project_Id), Week_Id INTEGER, FOREIGN KEY (Week_Id) REFERENCES weeks (Week_Id)); The error boils down to: 12-09 12:34:20.782: E/SQLiteLog(6490): (1) near "Week_Id": syntax error
Tags (comma-separated)
Save Edits
Cancel