-- Convert schema '/home/sergio/OwlcodeAds/script/../dbicdh/_source/deploy/-1/001-auto.yml' to '/home/sergio/OwlcodeAds/script/../dbicdh/_source/deploy/0/001-auto.yml':;

;
BEGIN;

;
CREATE TABLE "users" (
  "uuid" uuid NOT NULL,
  "username" text NOT NULL,
  "name" text NOT NULL,
  "surname" text NOT NULL,
  "encrypted_password" text NOT NULL,
  "email" text NOT NULL,
  "verified" boolean NOT NULL,
  "verification_token" text,
  "register_date" timestamp DEFAULT NOW() NOT NULL,
  "last_activity" timestamp DEFAULT NOW() NOT NULL,
  PRIMARY KEY ("uuid"),
  CONSTRAINT "unique_constraint_email" UNIQUE ("email"),
  CONSTRAINT "unique_constraint_username" UNIQUE ("username")
);

;

COMMIT;

