github.com/fragmenta/query@v1.5.3/tests/query_test_sqlite.sql (about)

     1  /* Database created using sqlite for tests - query_test */
     2  DROP TABLE pages;
     3  CREATE TABLE pages (
     4      id integer NOT NULL PRIMARY KEY,
     5      title text,
     6      text text,
     7      keywords text,
     8      status integer,
     9      created_at timestamp NOT NULL,
    10      updated_at timestamp NOT NULL,
    11      url text,
    12      summary text
    13  );
    14  
    15  
    16  insert into pages VALUES(1,'Title 1.','test 1 text','keywords1',100,'2013-03-18 12:18:50.447 +0000','2013-03-18 12:18:50.447 +0000','test.example.com','');
    17  insert into pages VALUES(2,'Title 2','test 2 text','keywords 2',100,'2013-03-18 12:18:50.447 +0000','2013-03-18 12:18:50.447 +0000','test.example.com','');
    18  insert into pages VALUES(3,'Title 3 here','test 3 text','keywords,3',100,'2013-03-18 12:18:50.447 +0000','2013-03-18 12:18:50.447 +0000','test.example.com','');