--This script was created by Peter Ping Liu to show students some simple application that they can do in the future.
-- The file name is user.sql
--Make sure to log in as php/php before you use or run it.  See class notes on how to create the php user and grant privileges to php user.

--The SQL script can be executed if you use the following SQL command.

--@C:\Users\pliu\Documents\PingLiu\web\php\course\Project\user.sql
--Of course, if you want to use it,you will have to change the path to fit in your computer.

drop table user_table;

create table user_table (
id number (8) not null, 
first_name varchar2(15),
last_name varchar2(15),
user_name varchar2(15),
password varchar2(15));

insert into user_table values
(1, 'London', 'Donovan', 'ldonovan','myhero');

--add one more record in the table
insert into user_table values
(2, 'Tim', 'Howard', 'thoward','mygoalie#1');

commit;
