GCPhone base.sql import error

[CardinalDesign]

Hey everyone, thanks in advance for any help or ideas.

GCPhone is working flawlessly on my server, however, during installation I had an error importing the base.sql file - duplicate column name "phone_number" in table "users". I was previously using esx_phone which I've since removed in favour of GCPhone, which I believe may be causing this issue.

I've tried removing the line ALTER TABLE "users" ADD COLUMN "phone_number" VARCHAR(10) NULL; from the base.sql file (which solves the SQL error while trying to import) but then gives me another issue. After removing this line, new players joining the server don't seem to be getting assigned information such as a phone number, which would usually appear in the GCPhone settings app. They can't make/receive calls and the server console will spit back errors due to incorrect SQL queries being sent.

I'm certain the player info is being generated by the various resources, but I think removing the line above in the base.sql file is now causing problems when new players join the server. I've been scratching my head a bit as to how I might fix this, so all help is appreciated.

Attached is a screenshot example of some of the SQL errors relating to the phone number field.