iframe-proxy | Sunbelt Computer Software

15 lines (13 loc) · 457 Bytes

CREATE SCHEMA IF NOT EXISTS travelcard;
CREATE TABLE IF NOT EXISTS travelcard.travel_account (
    id        SERIAL PRIMARY KEY,
    member_id INT    NOT NULL UNIQUE,
    name      TEXT   NOT NULL,
    balance   INT    NOT NULL DEFAULT 0
INSERT INTO travelcard.travel_account (member_id, name, balance) VALUES
    (19, 'Alice',   1000),
    (23, 'Bob',     2500),
    (31, 'Charlie', 500),
    (42, 'Diana',   7500)
ON CONFLICT (member_id) DO NOTHING;

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

init.sql

Latest commit

History

init.sql

File metadata and controls