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

     1  /* Database created using mysql for tests - query_test */
     2  DROP TABLE pages;
     3  CREATE TABLE pages (
     4      id integer NOT NULL PRIMARY KEY AUTO_INCREMENT,
     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  insert into pages VALUES(1,'Title 1.','test 1 text','keywords1',100,NOW(),NOW(),'test.example.com','');
    16  insert into pages VALUES(2,'Title 2','test 2 text','keywords 2',100,NOW(),NOW(),'test.example.com','');
    17  insert into pages VALUES(3,'Title 3 here','test 3 text','keywords,3',100,NOW(),NOW(),'test.example.com','');