sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE employee(empid integer,name varchar(20),title varchar(10), deptid integer, updatedon date);
INSERT INTO "employee" VALUES(101,'John Smith','CEO',3,NULL);
INSERT INTO "employee" VALUES(102,'Raj Reddy','Sysadmin',2,NULL);
INSERT INTO "employee" VALUES(103,'Jason Bourne','Developer',2,NULL);
INSERT INTO "employee" VALUES(104,'Jane Smith','Sales Manager',1,'2015-08-20 16:28:33');
INSERT INTO "employee" VALUES(105,'Rita Patel','DBA',2,NULL);
CREATE TABLE "dept"(deptid integer,name varchar(20),location varchar(10));
INSERT INTO "dept" VALUES(1,'Sales','Los Angeles');
INSERT INTO "dept" VALUES(2,'Technology','San Jose');
INSERT INTO "dept" VALUES(3,'Marketing','Los Angeles');
COMMIT;