CREATE TABLE content (
    id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
    alias nvarchar(254) NOT NULL,
    content ntext
);

CREATE UNIQUE INDEX content_alias ON content (alias);

INSERT INTO [content] ([alias],[content]) VALUES ('home','Content of the home page');
INSERT INTO [content] ([alias],[content]) VALUES ('download','Content of the download page');
INSERT INTO [content] ([alias],[content]) VALUES ('buy','Content of the buy page');
INSERT INTO [content] ([alias],[content]) VALUES ('support','Content of the support page');
