ALTER TABLE telp_custraxi
ADD COLUMN note_telp TEXT NULL AFTER buat_penawaran;

ALTER TABLE telp_custbisman
ADD COLUMN note_telp TEXT NULL AFTER buat_penawaran;

=====================ALAMAT====================
CREATE TABLE customer_alamat (
    idalamat INT AUTO_INCREMENT PRIMARY KEY,
    idcustomer VARCHAR(20),
    alamat TEXT,
    kota VARCHAR(50)
);

CREATE TABLE customeb_alamat (
    idalamat INT AUTO_INCREMENT PRIMARY KEY,
    idcustomer VARCHAR(20),
    alamat TEXT,
    kota VARCHAR(50)
);

INSERT INTO customer_alamat
(
    idcustomer,
    alamat,
    kota
)
SELECT
    idcustomer,
    alamat,
    kota
FROM customer;

INSERT INTO customer_alamat
(
    idcustomer,
    nama_lokasi,
    alamat,
    kota
)
SELECT
    idcustomer,
    alamat,
    kota
FROM customer;