--
-- Selected TOC Entries:
--
\connect - kiko
DROP INDEX "surveys_id_key";
DROP INDEX "projects_id_key";
DROP TABLE "surveys";
DROP SEQUENCE "surveys_id_seq";
DROP TABLE "projects";
DROP SEQUENCE "projects_id_seq";
--
-- TOC Entry ID 2 (OID 27429)
--
-- Name: projects_id_seq Type: SEQUENCE Owner: kiko
--

CREATE SEQUENCE "projects_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 27429)
--
-- Name: projects_id_seq Type: ACL Owner: 
--

REVOKE ALL on "projects_id_seq" from PUBLIC;
GRANT ALL on "projects_id_seq" to "nobody";
GRANT ALL on "projects_id_seq" to "kiko";

--
-- TOC Entry ID 6 (OID 27448)
--
-- Name: projects Type: TABLE Owner: kiko
--

CREATE TABLE "projects" (
	"id" integer DEFAULT nextval('"projects_id_seq"'::text) NOT NULL,
	"name" character varying UNIQUE,
	"url" character varying,
	"admin" character varying,
	"ctime" datetime DEFAULT now()
);

--
-- TOC Entry ID 7 (OID 27448)
--
-- Name: projects Type: ACL Owner: 
--

REVOKE ALL on "projects" from PUBLIC;
GRANT ALL on "projects" to "nobody";
GRANT ALL on "projects" to "kiko";

--
-- TOC Entry ID 4 (OID 27482)
--
-- Name: surveys_id_seq Type: SEQUENCE Owner: kiko
--

CREATE SEQUENCE "surveys_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 5 (OID 27482)
--
-- Name: surveys_id_seq Type: ACL Owner: 
--

REVOKE ALL on "surveys_id_seq" from PUBLIC;
GRANT ALL on "surveys_id_seq" to "nobody";
GRANT ALL on "surveys_id_seq" to "kiko";

--
-- TOC Entry ID 8 (OID 27501)
--
-- Name: surveys Type: TABLE Owner: kiko
--

CREATE TABLE "surveys" (
	"id" integer DEFAULT nextval('"surveys_id_seq"'::text) NOT NULL,
	"project" integer UNIQUE,
	"private" boolean DEFAULT false,
	"code" integer,
	"answers" integer[] ,
	"others" character varying[] ,
	"comments" character varying[] ,
	"ctime" datetime DEFAULT now(),
	"utime" datetime
);

--
-- TOC Entry ID 9 (OID 27501)
--
-- Name: surveys Type: ACL Owner: 
--

REVOKE ALL on "surveys" from PUBLIC;
GRANT ALL on "surveys" to "nobody";
GRANT ALL on "surveys" to "kiko";

--
-- TOC Entry ID 10 (OID 27448)
--
-- Name: "projects_id_key" Type: INDEX Owner: kiko
--

CREATE UNIQUE INDEX "projects_id_key" on "projects" using btree ( "id" "int4_ops" );

--
-- TOC Entry ID 11 (OID 27501)
--
-- Name: "surveys_id_key" Type: INDEX Owner: kiko
--

CREATE UNIQUE INDEX "surveys_id_key" on "surveys" using btree ( "id" "int4_ops" );