Newer
Older
jetty / schema.sql
Mark George on 29 Oct 2021 469 bytes Various improvements
CREATE TABLE USERS(
    USERNAME VARCHAR NOT NULL PRIMARY KEY,
    PASSWORD VARCHAR NOT NULL,
    NAME VARCHAR NOT NULL,
    CREDIT_CARD VARCHAR
);

INSERT INTO USERS(USERNAME, PASSWORD, NAME, CREDIT_CARD)
VALUES
('admin', 'cn3cG2pQBhdYsn6AbX', 'Administrator', NULL),
('fred', 'derf', 'Frederick', 'Visa,4367322176856339,3/20,794'),
('homer', 'doh', 'Homer', 'Visa,4779866477763533,8/19,343'),
('sally', 'petr0lhe4d', 'Sally', 'Mastercard,6556432454327654,12/18,177');