     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 (

/* rebuild all tables from scratch */
DROP TABLE IF EXISTS canvas_user;
DROP TABLE IF EXISTS canvas_usermembership;
DROP TABLE IF EXISTS canvas_screenshot;
DROP TABLE IF EXISTS canvas_rating;
DROP TABLE IF EXISTS canvas_arch;
DROP TABLE IF EXISTS canvas_package_ratings;
DROP TABLE IF EXISTS canvas_package_screenshots;
DROP TABLE IF EXISTS canvas_package;
DROP TABLE IF EXISTS canvas_repository;
DROP TABLE IF EXISTS canvas_comment;
DROP TABLE IF EXISTS canvas_template_ratings;


CREATE TABLE canvas_rating (
    id            integer       NOT NULL  PRIMARY KEY  AUTO_INCREMENT,
    user_id       integer       NOT NULL  REFERENCES canvas_user(id),
    description   text,
    value         float         NOT NULL
);
