connect to SAMPLE user wsdemo using wsdemo1

drop table CUSTOMER

drop table CUSTOMERNEWS

CREATE TABLE WSDEMO.CUSTOMER ("USERID" VARCHAR (12)  NOT NULL , "PASSWORD" VARCHAR (12) , "FNAME" VARCHAR (25) , "LNAME" VARCHAR (25) , "BALANCE" INTEGER , "LEVEL" VARCHAR (15), PRIMARY KEY (USERID)  ) 


CREATE TABLE WSDEMO.CUSTOMERNEWS ("TITLE" VARCHAR (80)  NOT NULL , "CONTENT" VARCHAR (1000) , "LEVEL" VARCHAR (15) , PRIMARY KEY (TITLE)  )


echo --- insert into CUSTOMER table ---

INSERT INTO CUSTOMER                                     \
   (userid, password, fname, lname, balance) VALUES           \
   ('johnny', 'johnny', 'Johnny',    'Akerley', 89),            \
   ('bruce', 'bruce', 'Bruce', 'McCarthy',1002),           \
   ('michael', 'michael', 'Michael', 'Muetschard', 107), \
   ('sally', 'sally', 'Sally', 'Picon', 55000),            \
   ('cathy', 'cathy', 'Cathy', 'Lady', 11101),             \
   ('mario', 'mario', 'Mario', 'Lopez', 9999)
 

echo --- insert into NEWS table ---

INSERT INTO CUSTOMERNEWS                                                                                                                                        \
   (title, content, level) VALUES                                                                                                                                 \
   ('New CD Rates for our premium customers', 'Our CD rate is 5.5% for premium customers with an easy rollover.', 'premium'),                                     \
   ('New CD Rates for our basic customers', 'Our CD rate is 2.9% for basic customers with an easy rollover.', 'basic'),                                           \
   ('New CD Rates for our advantage customers', 'Our CD rate is 3.5% for advantage customers with an easy rollover.', 'advantage'),                               \
   ('New CD Rates for our preferred customers', 'Our CD rate is 4.9% for preferred customers with an easy rollover.', 'preferred'),                               \
   ('Free OnLine Banking for our premium customers', 'Premium customers can avail of our free Onlin Banking program.', 'premium'),                                \
   ('Check out our OnLine Banking facility', 'For a low fee you can Bank OnLine using the new web portal.', 'basic'),                                             \
   ('Preferred customers can use our OnLine Banking facility', 'For a dollar a month use Our OnLine Bank.', 'preferred'),                                         \
   ('OnLine Bank is now open', 'Advantage customers can use our OnLine Bank 24 hours a day. Get 5 transactions a month for free.', 'advantage'),                  \
   ('Free checking for the remainder of this year, ', 'Enjoy free checking for the rest of the calendar year as a reward for your loyalty.', 'campaign'),                  \
   ('Upgrade to the next level', 'For the remainder of this year, you will be upgraded to the next level', 'campaign'),                  \
   ('New CD Rates & OnLine Bank is Open', 'Check out our new CD rates which are better than ever. OnLine Bank is now open at www.acmeBank.com.', 'all')


echo --- connect reset ---

connect reset
