Make Quasar Case insensitive (Postgresql)

This is based on ubuntu, debian etc and postgresql 9.1.3. should work with other versions too.You'll need to have postgresql-contrib installed for this to workfirst run on your quasar database

CREATE EXTENSION citext;

then run this on your quasar database.

ALTER TABLE gltx_item ALTER "number" TYPE citext;
ALTER TABLE item_plu ALTER "number" TYPE citext;
ALTER TABLE item_num ALTER "number" TYPE citext;
ALTER TABLE account ALTER "name" TYPE citext;
ALTER TABLE account ALTER "number" TYPE citext;
ALTER TABLE account_type ALTER "name" TYPE citext;
ALTER TABLE adjust_reason ALTER "name" TYPE citext;
ALTER TABLE adjust_reason ALTER "number" TYPE citext;
ALTER TABLE charge ALTER "name" TYPE citext;
ALTER TABLE cheque ALTER "name" TYPE citext;
ALTER TABLE cin_item ALTER "number" TYPE citext;
ALTER TABLE cin_return ALTER "number" TYPE citext;
ALTER TABLE cinr_item ALTER "number" TYPE citext;
ALTER TABLE consign_in ALTER "number" TYPE citext;
ALTER TABLE consign_out ALTER "number" TYPE citext;
ALTER TABLE cout_item ALTER "number" TYPE citext;
ALTER TABLE cout_return ALTER "number" TYPE citext;
ALTER TABLE coutr_item ALTER "number" TYPE citext;
ALTER TABLE customer ALTER "name" TYPE citext;
ALTER TABLE customer ALTER "number" TYPE citext;
ALTER TABLE customer_refs ALTER "ref_name" TYPE citext;
ALTER TABLE customer_type ALTER "name" TYPE citext;
ALTER TABLE dept ALTER "name" TYPE citext;
ALTER TABLE dept ALTER "number" TYPE citext;
ALTER TABLE discount ALTER "name" TYPE citext;
ALTER TABLE employee ALTER "name" TYPE citext;
ALTER TABLE employee ALTER "number" TYPE citext;
ALTER TABLE expense ALTER "name" TYPE citext;
ALTER TABLE expense ALTER "number" TYPE citext;
ALTER TABLE extra_values ALTER "data_value" TYPE citext;
ALTER TABLE gltx ALTER "number" TYPE citext;
ALTER TABLE gltx_refs ALTER "ref_name" TYPE citext;
ALTER TABLE gltx_refs ALTER "ref_data" TYPE citext;
ALTER TABLE groups ALTER "name" TYPE citext;
ALTER TABLE i_s_extra ALTER "extra_name" TYPE citext;
ALTER TABLE i_s_extra ALTER "extra_value" TYPE citext;
ALTER TABLE item_build ALTER "number" TYPE citext;
ALTER TABLE location ALTER "name" TYPE citext;
ALTER TABLE pat_group ALTER "name" TYPE citext;
ALTER TABLE pat_group ALTER "number" TYPE citext;
ALTER TABLE porder ALTER "number" TYPE citext;
ALTER TABLE porder_item ALTER "number" TYPE citext;
ALTER TABLE price_batch_item ALTER "number" TYPE citext;
ALTER TABLE price_zone ALTER "name" TYPE citext;
ALTER TABLE price_zone ALTER "number" TYPE citext;
ALTER TABLE promo_batch ALTER "number" TYPE citext;
ALTER TABLE promo_batch_item ALTER "number" TYPE citext;
ALTER TABLE quote_item ALTER "number" TYPE citext;
ALTER TABLE slip_item ALTER "number" TYPE citext;
ALTER TABLE sorder_item ALTER "number" TYPE citext;
ALTER TABLE station ALTER "name" TYPE citext;
ALTER TABLE station ALTER "number" TYPE citext;
ALTER TABLE store ALTER "name" TYPE citext;
ALTER TABLE store ALTER "number" TYPE citext;
ALTER TABLE subdept ALTER "name" TYPE citext;
ALTER TABLE subdept ALTER "number" TYPE citext;
ALTER TABLE tax ALTER "name" TYPE citext;
ALTER TABLE tax ALTER "number" TYPE citext;
ALTER TABLE tender ALTER "name" TYPE citext;
ALTER TABLE term ALTER "name" TYPE citext;
ALTER TABLE vendor ALTER "name" TYPE citext;
ALTER TABLE vendor ALTER "number" TYPE citext;