Skip to content

Instantly share code, notes, and snippets.

@steamraven
Created June 7, 2011 15:52
Show Gist options
  • Save steamraven/1012537 to your computer and use it in GitHub Desktop.
Save steamraven/1012537 to your computer and use it in GitHub Desktop.
Filez file logging schema
CREATE TABLE "fz_file_log"
(
"id" serial NOT NULL,
"file_id" numeric(20,0) NOT NULL,
"logged_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
"ip" inet NOT NULL,
"log_type" character varying NOT NULL,
"uid" character varying,
"guest_id" numeric(20,0),
"file_name" character varying(100),
"file_size" integer DEFAULT 0,
"invite_user", integer,
"invite_email", character varying(50),
"forward_ips", character varying(100),
PRIMARY KEY ("id")
) ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment