text: /**
   * Database schema required by user module.
   *
   */
  
  drop table if exists "menu";
  drop table if exists "user";
  
  create table "menu"
  (
      "id" serial NOT NULL PRIMARY KEY,
      "name" varchar(128),
      "parent" integer,
      "route" varchar(256),
      "order" integer,
      "data"   bytea,
      foreign key ("parent") references "menu"("id")  ON DELETE SET NULL ON UPDATE CASCADE
  );
  
  create table "user"
  (
      "id" serial NOT NULL PRIMARY KEY,
      "username" varchar(32) NOT NULL,
      "auth_key" varchar(32) NOT NULL,
      "password_hash" varchar(256) NOT NULL,
      "password_reset_token" varchar(256),
      "email" varchar(256) NOT NULL,
      "status" integer not null default 10,
      "created_at" integer not null,
      "updated_at" integer not null
  );
  