[sqlite] Moving data from one table to a new table

[jose isaias cabrera]

Greetings!

I have this table,

CREATE TABLE OpenJobs (
                      id primary key,
                      login,
                      cust,
                      proj,
                      bdate date,
                      edate date,
                      pm,
                      lang,
                      notes,
                      status);


and I want to move all the data there to this new table,

CREATE TABLE LSOpenJobs (
                      id primary key,
                      login,
                      cust,
                      proj,
                      bdate date,
                      edate date,
                      pm,
                      lang,
                      vendor,
                      notes,
                      status);


I know I can write a subrouting to do this, but is there an easier way to do 
this from within SQLite?  Or the better question would be, can I add more 
columns to an already existing table?  If there are answers to both questions, 
will someone point me to where I can get the answers?  Or answer them?  Thanks.

josé