     summary       text,
     license       varchar(256),
     url           varchar(256)
+);
+
+CREATE TABLE canvas_packagedetails (
+    id            integer       NOT NULL  PRIMARY KEY  AUTO_INCREMENT,
+    package_id    integer       NOT NULL  REFERENCES canvas_package(id),
+    arch_id       integer       NOT NULL  REFERENCES canvas_arch(id),
+    version       varchar(64),
+    rel           varchar(64)
 );
 
 CREATE TABLE canvas_repository (


    /* default action is set to INSTALLED only */
    action        integer       NOT NULL DEFAULT 1
)
;
CREATE TABLE canvas_templaterepository (
    id            integer       NOT NULL PRIMARY KEY  AUTO_INCREMENT,
    template_id   integer       NOT NULL REFERENCES canvas_template(id),

    enabled       bool          NOT NULL DEFAULT TRUE,
    cost          integer       NOT NULL DEFAULT 1000,
    gpg_check     bool          NOT NULL DEFAULT TRUE
);

CREATE TABLE canvas_machine (
    id            integer       NOT NULL PRIMARY KEY  AUTO_INCREMENT,
    user_id       integer       NOT NULL REFERENCES canvas_user(id),
    template_id   integer       NOT NULL REFERENCES canvas_template(id),
    name          varchar(256)  NOT NULL,
    description   text
);

COMMIT;
