Tables Check - back

Script File Download

Script started on Fri 22 Sep 2017 03:44:55 PM EDT
pi:~/public_html/coursework/isc496/assignments/a4> sqlite3 translate.db

SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> .schema
CREATE TABLE english (id INTEGER PRIMARY KEY, lexeme VARCHAR (255) NOT NULL);
CREATE TABLE french (id INTEGER PRIMARY KEY, lexeme VARCHAR (255) NOT NULL);
CREATE TABLE translate (id INTEGER PRIMARY KEY, en INTEGER NOT NULL, fr INTEGER NOT NULL, FOREIGN KEY(en) REFERENCES english(id), FOREIGN KEY(fr) REFERENCES french(id));
sqlite> select * from english;
sqlite> .quit
pi:~/public_html/coursework/isc496/assignments/a4> exit

exit

Script done on Fri 22 Sep 2017 03:45:32 PM EDT