Shell Programming and Scripting

i have the following create table definition ,the shell script has to search for the first column name of the create table definition in the file and explicitly add primary index (first column name) at the end i.e before ";"

it has to search through all the files (say 20 files) and has to modifiy as per the above requirement
Could anyone please help me

Before modification:

create table t_surya
(service_number varchar(15) character set LATIN not casespecific not null
,exch_id char(4) character set LATIN not casespecific not null
,lar_account_number varchar(15) character set LATIN not casespecific not null
,lar_acct_id integer
,lar_owning_cost_ctr smallint
,lar_cust_type char(1) character set LATIN not casespecific
,lar_plan_cd varchar(4) character set LATIN not casespecific
,ld_plan_cd varchar(4) character set LATIN not casespecific
,lar_date_of_birth date format 'YYYY-MM-DD'
,lar_account_name_1 varchar(100) character set LATIN not casespecific
,lar_account_name_2 varchar(100) character set LATIN not casespecific
,lar_bill_cycle_freq_cd char(1) character set LATIN not casespecific
,lar_ar_account_no integer
,dsl_cust_id integer
,dsl_acct_id integer
,dsl_cust_type_id byteint
,dsl_serv_type varchar(10) character set LATIN not casespecific
,dsl_serv_status char(1) character set LATIN not casespecific
,dsl_date_of_birth date format 'YYYY-MM-DD'
,dsl_cust_name varchar(100) character set LATIN not casespecific
,bundle_flag char(1) character set LATIN not casespecific
,fnn_eligibility_flag char(1) character set LATIN not casespecific
,reject_rsn_cd varchar(50) character set LATIN not casespecific)
;

After Modification:

create set table t_surya
(service_number varchar(15) character set LATIN not casespecific not null
,exch_id char(4) character set LATIN not casespecific not null
,lar_account_number varchar(15) character set LATIN not casespecific not null
,lar_acct_id integer
,lar_owning_cost_ctr smallint
,lar_cust_type char(1) character set LATIN not casespecific
,lar_plan_cd varchar(4) character set LATIN not casespecific
,ld_plan_cd varchar(4) character set LATIN not casespecific
,lar_date_of_birth date format 'YYYY-MM-DD'
,lar_account_name_1 varchar(100) character set LATIN not casespecific
,lar_account_name_2 varchar(100) character set LATIN not casespecific
,lar_bill_cycle_freq_cd char(1) character set LATIN not casespecific
,lar_ar_account_no integer
,dsl_cust_id integer
,dsl_acct_id integer
,dsl_cust_type_id byteint
,dsl_serv_type varchar(10) character set LATIN not casespecific
,dsl_serv_status char(1) character set LATIN not casespecific
,dsl_date_of_birth date format 'YYYY-MM-DD'
,dsl_cust_name varchar(100) character set LATIN not casespecific
,bundle_flag char(1) character set LATIN not casespecific
,fnn_eligibility_flag char(1) character set LATIN not casespecific
,reject_rsn_cd varchar(50) character set LATIN not casespecific)
primary index (service_number)
;

With awk:

Code:

awk 'NR==1{$1=$1 " set"}
/;/{print "primary index (service_number)"}1' file