#!/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