Add new column to the DB

Support
1

i have already created the .sql file with the following code {
ALTER TABLE ip_invoices
ADD invoice_type_id TINYINT(2) NOT NULL DEFAULT ‘1’
AFTER client_id ;
}
but i need to run the Query to add the COLUMN to the DB ! . is there a Parameter i need to run in the URL or how should i do it ? or i can only add the Column from phpmyadmin directly

i’m using v1.5.10.

Thank you All!!

2

Hi @mohamad-hejazi07,

To do this correctly please the the below Query

ALTER TABLE `ip_invoices` ADD 'invoice_type_id' decimal(10,2) NOT NULL AFTER `client_id`;