monke market

Create Table SQL

CREATE TABLE tblCrypto(
    pmkCurrencyId INT AUTO_INCREMENT PRIMARY KEY,
    fldCurrency VARCHAR(30),
    fldCap VARCHAR(20),
    fldPrice FLOAT,
    fldChange FLOAT
)

INSERT INTO tblCrypto
(fldCurrency, fldCap, fldPrice, fldChange)
VALUES
('Bitcoin', '$927 billion', 49162.8, -14.27),
('Ethereum', '$496 billion', 4182.12, -2.80),
('Dogecoin', '$22.7 billion', 0.1716, -16.49),
('SHIBA INU', '$19.6 billion', 0.0000357, -8.58)

CREATE TABLE tblPurchases(
    pmkCurrencyId INT AUTO_INCREMENT PRIMARY KEY,
    fldFirstName VARCHAR(30),
    fldLastName VARCHAR(30),
    fldEmail VARCHAR(40),
    fldNFTChoice VARCHAR(30),
    fldRecipient VARCHAR(10),
    fldCreditCardNum VARCHAR(20),
    fldCvv INT,
    fldExpirationDate VARCHAR(10),
    fldHappiness BOOLEAN,
    fldReceiveEmails BOOLEAN,
    fldTerms BOOLEAN,
    fldComments TEXT
)