hakobox/database/migrations/20250412193502_file.sql
2025-04-21 17:59:57 -03:00

36 lines
793 B
SQL

-- +goose Up
-- Diff code generated with pgModeler (PostgreSQL Database Modeler)
-- pgModeler version: 1.2.0-alpha1
-- Diff date: 2025-04-12 16:39:19
-- Source model: dev1
-- Database: dev1
-- PostgreSQL version: 17.0
-- [ Diff summary ]
-- Dropped objects: 1
-- Created objects: 1
-- Changed objects: 0
SET search_path=public,pg_catalog;
-- ddl-end --
-- [ Dropped objects ] --
DROP TABLE IF EXISTS public.usuario CASCADE;
-- ddl-end --
-- [ Created objects ] --
-- object: public.file | type: TABLE --
-- DROP TABLE IF EXISTS public.file CASCADE;
CREATE TABLE public.file (
id uuid NOT NULL,
name varchar(256) NOT NULL,
size integer NOT NULL,
created_at timestamp NOT NULL,
CONSTRAINT file_pk PRIMARY KEY (id)
);
-- ddl-end --
ALTER TABLE public.file OWNER TO dev;
-- ddl-end --