<?php$query = <<<EOQCREATE TABLE "$db_table"("ID" integer NOT NULL, "TITLE" character varying(255) DEFAULT 'Unknown'::character varying NOT NULL, "AUTHOR" character varying(255) DEFAULT 'Anonymous'::character varying NOT NULL, "DESRIPTION" text NOT NULL, "SYNTAX" character varying(255) NOT NULL, "SHOWNUMBERS" smallint DEFAULT 1 NOT NULL, "DATE" date DEFAULT '2008-07-16'::date NOT NULL, "TIME" time without time zone DEFAULT '00:00:00'::time without time zone NOT NULL, "EDITOF" integer NOT NULL, "EXPIRATION" integer DEFAULT 0 NOT NULL, "IPADDRESS" character varying(255) NOT NULL);ALTER TABLE ONLY "POSTS" ADD CONSTRAINT "POSTS_pkey" PRIMARY KEY ("ID");COMMENT ON TABLE "POSTS" IS 'list of all the current pastebin posts';COMMENT ON COLUMN "POSTS"."ID" IS 'id of the paste';COMMENT ON COLUMN "POSTS"."TITLE" IS 'title of the paste';COMMENT ON COLUMN "POSTS"."AUTHOR" IS 'name of the paste\'s author';COMMENT ON COLUMN "POSTS"."DESRIPTION" IS 'content of the paste';COMMENT ON COLUMN "POSTS"."SYNTAX" IS 'syntax of the paste by which to hightlight';COMMENT ON COLUMN "POSTS"."SHOWNUMBERS" IS 'whether or not to show line numbers for this paste';COMMENT ON COLUMN "POSTS"."DATE" IS 'date the paste was posted';COMMENT ON COLUMN "POSTS"."TIME" IS 'time of day when the paste was posted';COMMENT ON COLUMN "POSTS"."EDITOF" IS 'id of the paste from which this one was edited';COMMENT ON COLUMN "POSTS"."EXPIRATION" IS 'number of minutes after TIME when this paste expires';COMMENT ON COLUMN "POSTS"."IPADDRESS" IS 'ip address of the paste\'s author, used in paste removal';EOQ;?>