#!/bin/bash -u
# dbcreate
# Author: M.T. Carrasco Benitez
# 2011-08-24
#
# How to view the content the "db.sqlite"
# Install SQLite Manager for Firefox
#   https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager
#
# Type the command line:
#   sqlite3 -line db.sqlite 'select * from example ;'

DB=db.sqlite
rm -f $DB

sqlite3 $DB <<EOF
create table example (
   date    text
 , creator text
 , version text
) ;
insert into example
        ( date         , creator                 , version )
 values ( '2011-08-24' , 'M.T. Carrasco Benitez' , '1'     ) ;
EOF

exit 0
##