testdb.sh

   1 #!/bin/sh
   2
   3 sqlite3 ./test.db "
   4 create table product (
   5     id          integer not null,
   6     name        varchar(50) not null,
   7     stat        varchar(15) not null,
   8     primary key (id)
   9 );
  10 insert into product values (1, 'hompag', 'active');
  11 insert into product values (2, 'helper', 'active');
  12 insert into product values (3, 'msword', 'stopped');
  13 insert into product values (4, 'msaccess', 'stopped');
  14 "