-- Demo sqlite script
-- Provided by Anthony Vogelaar, Perth Scotland
-- rev 0.10  2024-08-06  initial release

-- # $ sqlite3 test_s.db < test.sql

DROP TABLE IF EXISTS data;
CREATE TABLE data (
    id      INTEGER     PRIMARY KEY,
    akey    VARCHAR(16) NOT NULL,
    avalue  INTEGER     NOT NULL);
INSERT INTO data (akey, avalue) VALUES
    ('a1', 1),
    ('a2', 1),
    ('a3', 1),
    ('a4', 1),
    ('a5', 1);

SELECT * FROM data;
