-- YOUSEF RABAH
-- March 27, 2004 

-- Phone Database for Speech Application
-- Contains sql for adding [people(first name, last name, phone number) these are
-- all added through another application, which in turn gets this information from an Automatic Speech
-- Recognition system (sphinx) and stored in this database] The database will also be used to send and 
-- recieve info to application and thus to user. The database also contains adding  city, street, as 
-- well as comments (although these will not be added to DB via voice   
 



DROP TABLE people;
CREATE TABLE people (  pid		integer,
                       first_name	varchar(20),
                       last_name	varchar(20),
                       phone_num      	varchar(12) UNIQUE,
		       city		varchar(15),
                       PRIMARY KEY (pid));