CREATE TABLE masterbarang_pending
(
    Barcode VARCHAR(50) NOT NULL,
    NamaBarang VARCHAR(255) NOT NULL,

    UserInput VARCHAR(50) NOT NULL,
    TanggalInput DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,

    Status VARCHAR(20) NOT NULL DEFAULT 'PENDING',

    UserApprove VARCHAR(50) DEFAULT NULL,
    TanggalApprove DATETIME DEFAULT NULL,

    CatatanAdmin VARCHAR(255) DEFAULT NULL,

    SumberInput VARCHAR(10) NOT NULL DEFAULT 'VOICE',

    AudioFile VARCHAR(255) DEFAULT NULL,
    FotoFile VARCHAR(255) DEFAULT NULL,

    PRIMARY KEY (Barcode),

    KEY IDX_STATUS (Status),
    KEY IDX_TANGGALINPUT (TanggalInput),
    KEY IDX_USERINPUT (UserInput)

) ENGINE=InnoDB
  DEFAULT CHARSET=latin1;
  
  SELECT *
FROM masterbarang_pending
LIMIT 1;

INSERT INTO masterbarang_pending
(
    Barcode,
    NamaBarang,
    UserInput
)
VALUES
(
    '1234567890',
    'TEST BARANG PENDING',
    'BOWO'
);