Multiple sql statement

[arunaseva]

Hi,

How can I add multiple sql statement with one endpoint (sqlite)?

queries/mayim_mockup_origin.sql:

DROP TABLE IF EXISTS origin;

CREATE TABLE origin (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        hostname VARCHAR,
        fqdn VARCHAR
);

INSERT INTO origin (hostname, fqdn) VALUES ('pc01', 'pc01.example.com');
INSERT INTO origin (hostname, fqdn) VALUES ('pc02', 'pc02.example.com');

What do you suggest? How is it possible?

I got this error message "You can only execute one statement at a time."

Thanks, Adam