Архиватор снимков неба над Томском панорамной камерой http://tomsk-sky.blindage.org/
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 

101 lines
2.5 KiB

  1. --
  2. -- PostgreSQL database dump
  3. --
  4. -- Dumped from database version 11.1 (Debian 11.1-1.pgdg90+1)
  5. -- Dumped by pg_dump version 11.0 (Ubuntu 11.0-1.pgdg18.04+2)
  6. SET statement_timeout = 0;
  7. SET lock_timeout = 0;
  8. SET idle_in_transaction_session_timeout = 0;
  9. SET client_encoding = 'UTF8';
  10. SET standard_conforming_strings = on;
  11. SELECT pg_catalog.set_config('search_path', '', false);
  12. SET check_function_bodies = false;
  13. SET client_min_messages = warning;
  14. SET row_security = off;
  15. SET default_tablespace = '';
  16. SET default_with_oids = false;
  17. --
  18. -- Name: pictures; Type: TABLE; Schema: public; Owner: postgres
  19. --
  20. CREATE TABLE public.pictures (
  21. id integer NOT NULL,
  22. filename character varying NOT NULL,
  23. photo_timestamp timestamp without time zone NOT NULL,
  24. precipitation boolean DEFAULT false NOT NULL,
  25. comment text NOT NULL
  26. );
  27. ALTER TABLE public.pictures OWNER TO postgres;
  28. --
  29. -- Name: pictures_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
  30. --
  31. CREATE SEQUENCE public.pictures_id_seq
  32. AS integer
  33. START WITH 1
  34. INCREMENT BY 1
  35. NO MINVALUE
  36. NO MAXVALUE
  37. CACHE 1;
  38. ALTER TABLE public.pictures_id_seq OWNER TO postgres;
  39. --
  40. -- Name: pictures_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
  41. --
  42. ALTER SEQUENCE public.pictures_id_seq OWNED BY public.pictures.id;
  43. --
  44. -- Name: pictures id; Type: DEFAULT; Schema: public; Owner: postgres
  45. --
  46. ALTER TABLE ONLY public.pictures ALTER COLUMN id SET DEFAULT nextval('public.pictures_id_seq'::regclass);
  47. --
  48. -- Data for Name: pictures; Type: TABLE DATA; Schema: public; Owner: postgres
  49. --
  50. COPY public.pictures (id, filename, photo_timestamp, precipitation, comment) FROM stdin;
  51. 4 1546718369.jpg 2019-01-05 19:59:29 f Дата съемки: 06.01.2019\nВремя съемки: 02:58:37 UTC+7\nДиафрагма: f/4\nВыдержка: 25\nЧувствительность: ISO-320\nExpN: 500\nЦветовая температура: 5500К\nОсадки: Осадков нет\nТемпература фoтометра: 19.81°C
  52. \.
  53. --
  54. -- Name: pictures_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
  55. --
  56. SELECT pg_catalog.setval('public.pictures_id_seq', 4, true);
  57. --
  58. -- Name: pictures pictures_pk; Type: CONSTRAINT; Schema: public; Owner: postgres
  59. --
  60. ALTER TABLE ONLY public.pictures
  61. ADD CONSTRAINT pictures_pk PRIMARY KEY (id);
  62. --
  63. -- Name: pictures_photo_timestamp_idx; Type: INDEX; Schema: public; Owner: postgres
  64. --
  65. CREATE INDEX pictures_photo_timestamp_idx ON public.pictures USING btree (photo_timestamp);
  66. --
  67. -- PostgreSQL database dump complete
  68. --