{"action":"created","issue":{"url":"https://api.github.com/repos/elgame/sanjorge/issues/34","labels_url":"https://api.github.com/repos/elgame/sanjorge/issues/34/labels{/name}","comments_url":"https://api.github.com/repos/elgame/sanjorge/issues/34/comments","events_url":"https://api.github.com/repos/elgame/sanjorge/issues/34/events","html_url":"https://github.com/elgame/sanjorge/issues/34","id":100638725,"number":34,"title":"SQL 2","user":{"login":"elgame","id":1078720,"avatar_url":"https://avatars.githubusercontent.com/u/1078720?v=3","gravatar_id":"","url":"https://api.github.com/users/elgame","html_url":"https://github.com/elgame","followers_url":"https://api.github.com/users/elgame/followers","following_url":"https://api.github.com/users/elgame/following{/other_user}","gists_url":"https://api.github.com/users/elgame/gists{/gist_id}","starred_url":"https://api.github.com/users/elgame/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elgame/subscriptions","organizations_url":"https://api.github.com/users/elgame/orgs","repos_url":"https://api.github.com/users/elgame/repos","events_url":"https://api.github.com/users/elgame/events{/privacy}","received_events_url":"https://api.github.com/users/elgame/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-12T21:23:07Z","updated_at":"2015-09-21T17:09:47Z","closed_at":null,"body":"- [x] privilegios para validar las empresas\r\n```sql\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('Permiso empresas', 0, FALSE, 'empresas/', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('EMPAQUE SAN JORGE', 382, FALSE, '2', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('GOMEZ GUDIÑO SPR', 382, FALSE, '3', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('RAUL JORGE GOMEZ', 382, FALSE, '4', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('VIANEY ROCIO GUDIÑO', 382, FALSE, '5', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('FRANCIS VIANEY GOMEZ', 382, FALSE, '6', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('ORO VERDE SA', 382, FALSE, '7', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('INMOBILIARIA VILLAS', 382, FALSE, '8', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('ESTELA TOSCANO GONZALEZ', 382, FALSE, '9', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('MARIA JOSE GOMEZ GUDIÑO', 382, FALSE, '10', '', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('BODEGA DE GUADALAJARA', 382, FALSE, '11', '', FALSE);\r\n\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('Utilerias', 0, TRUE, 'utilerias/', 'wrench', FALSE);\r\nINSERT INTO \"privilegios\"( \"nombre\", \"id_padre\", \"mostrar_menu\", \"url_accion\", \"url_icono\", \"target_blank\") VALUES ('Borra todo', 393, FALSE, 'utilerias/drop_all/', 'trash', FALSE);\r\n```\r\n- [x] hacer super usuario a programas para drop all files\r\n"},"comment":{"url":"https://api.github.com/repos/elgame/sanjorge/issues/comments/142045124","html_url":"https://github.com/elgame/sanjorge/issues/34#issuecomment-142045124","issue_url":"https://api.github.com/repos/elgame/sanjorge/issues/34","id":142045124,"user":{"login":"elgame","id":1078720,"avatar_url":"https://avatars.githubusercontent.com/u/1078720?v=3","gravatar_id":"","url":"https://api.github.com/users/elgame","html_url":"https://github.com/elgame","followers_url":"https://api.github.com/users/elgame/followers","following_url":"https://api.github.com/users/elgame/following{/other_user}","gists_url":"https://api.github.com/users/elgame/gists{/gist_id}","starred_url":"https://api.github.com/users/elgame/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elgame/subscriptions","organizations_url":"https://api.github.com/users/elgame/orgs","repos_url":"https://api.github.com/users/elgame/repos","events_url":"https://api.github.com/users/elgame/events{/privacy}","received_events_url":"https://api.github.com/users/elgame/received_events","type":"User","site_admin":false},"created_at":"2015-09-21T17:09:46Z","updated_at":"2015-09-21T17:09:46Z","body":"- [ ] catalogo productores\r\n```sql\r\n\r\nCREATE TABLE otros.productor\r\n(\r\n  id_productor bigserial NOT NULL,\r\n  id_empresa integer NOT NULL DEFAULT 2,\r\n  nombre_fiscal character varying(140) NOT NULL,\r\n  calle character varying(60),\r\n  no_exterior character varying(7),\r\n  no_interior character varying(7),\r\n  colonia character varying(60),\r\n  localidad character varying(45),\r\n  municipio character varying(45),\r\n  estado character varying(45),\r\n  pais character varying(25) DEFAULT 'MEXICO'::character varying,\r\n  cp character varying(10),\r\n  telefono character varying(15),\r\n  celular character varying(20),\r\n  email text,\r\n  status character varying(15) DEFAULT 'ac'::character varying, -- Corresponde al status ac:activo o e:eliminado\r\n  cuenta_cpi character varying(12), -- cuenta afectable del contpaqi\r\n  parcela character varying(20), -- RENTADA O PROPIA\r\n  ejido_parcela character varying(150),\r\n  tipo character varying(20) NOT NULL,\r\n  CONSTRAINT productor_pkey PRIMARY KEY (id_productor),\r\n  CONSTRAINT productor_id_empresa_fkey FOREIGN KEY (id_empresa)\r\n      REFERENCES empresas (id_empresa) MATCH SIMPLE\r\n      ON UPDATE CASCADE ON DELETE CASCADE\r\n)\r\nWITH (\r\n  OIDS=FALSE\r\n);\r\nALTER TABLE otros.productor\r\n  OWNER TO programa;\r\nCOMMENT ON COLUMN otros.productor.status IS 'Corresponde al status ac:activo o e:eliminado';\r\nCOMMENT ON COLUMN otros.productor.cuenta_cpi IS 'cuenta afectable del contpaqi';\r\nCOMMENT ON COLUMN otros.productor.parcela IS 'RENTADA O PROPIA';\r\n```"}}