schema.sql


1
2
3
4
5
6
7
8
9

DROP TABLE IF EXISTS Prices;
CREATE TABLE IF NOT EXISTS Prices (
    Id INTEGER PRIMARY KEY NOT NULL,
    CompanyName VARCHAR(32) NOT NULL,
    ProductName TEXT NOT NULL,
    Price REAL NOT NULL,
    AccessDate TEXT NOT NULL,
    Picture TEXT
);