#!/bin/bash
# mkusers.sh
# L. J. Jaeckel
# CS210 -- Linux Administration
# February 17, 2011
#
# Create SQLite database: cs210class.db
# Create table: users
# Insert records for the class.

sqlite3 cs210class.db << SQLSCRIPT
  CREATE TABLE users (
      username  char(32) NOT NULL PRIMARY KEY,
      lastname  char(32),
      firstname char(32)
      );

  INSERT INTO users (username, firstname, lastname) VALUES ('profdkp', 'Dale', 'Phillips');
  INSERT INTO users (username, firstname, lastname) VALUES ('anetp', 'Anet', 'Police');
  INSERT INTO users (username, firstname, lastname) VALUES ('aquigley', 'Andrew', 'Quigley');
  INSERT INTO users (username, firstname, lastname) VALUES ('brasudo', 'Octavio', 'Hernandez');
  INSERT INTO users (username, firstname, lastname) VALUES ('brazils', 'Sean', 'Brazil');
  INSERT INTO users (username, firstname, lastname) VALUES ('camery', 'Claudia', 'Mery');
  INSERT INTO users (username, firstname, lastname) VALUES ('doggie', 'Jay', 'Jaeckel');
  INSERT INTO users (username, firstname, lastname) VALUES ('ejamn', 'Elesh', 'Jamnadas');
  INSERT INTO users (username, firstname, lastname) VALUES ('ericg', 'Eric', 'Greenberg');
  INSERT INTO users (username, firstname, lastname) VALUES ('kewl', 'Andrew', 'Burton');
  INSERT INTO users (username, firstname, lastname) VALUES ('javargas', 'Jesus', 'Vargas');
  INSERT INTO users (username, firstname, lastname) VALUES ('jnicklas', 'Judson', 'Nicklas');
  INSERT INTO users (username, firstname, lastname) VALUES ('mencinas', 'Margarita', 'Encinas');
  INSERT INTO users (username, firstname, lastname) VALUES ('rrawers', 'Robert', 'Rawers');
  INSERT INTO users (username, firstname, lastname) VALUES ('zerocnc', 'Richard', 'Neal');
SQLSCRIPT