github.com/drud/ddev@v1.21.5-alpha1.0.20230226034409-94fcc4b94453/pkg/ddevapp/testdata/TestDdevAllDatabases/postgres/users.sql (about) 1 -- 2 -- PostgreSQL database dump 3 -- 4 5 -- Dumped from database version 9.6.24 6 -- Dumped by pg_dump version 9.6.24 7 8 SET statement_timeout = 0; 9 SET lock_timeout = 0; 10 SET idle_in_transaction_session_timeout = 0; 11 SET client_encoding = 'UTF8'; 12 SET standard_conforming_strings = on; 13 SELECT pg_catalog.set_config('search_path', '', false); 14 SET check_function_bodies = false; 15 SET xmloption = content; 16 SET client_min_messages = warning; 17 SET row_security = off; 18 19 SET default_tablespace = ''; 20 21 SET default_with_oids = false; 22 23 -- 24 -- Name: users; Type: TABLE; Schema: public; Owner: db 25 -- 26 27 CREATE TABLE public.users ( 28 uid bigint DEFAULT 0 NOT NULL, 29 name character varying(60) DEFAULT ''::character varying NOT NULL, 30 pass character varying(128) DEFAULT ''::character varying NOT NULL, 31 mail character varying(254) DEFAULT ''::character varying, 32 theme character varying(255) DEFAULT ''::character varying NOT NULL, 33 signature character varying(255) DEFAULT ''::character varying NOT NULL, 34 signature_format character varying(255), 35 created integer DEFAULT 0 NOT NULL, 36 changed integer DEFAULT 0 NOT NULL, 37 access integer DEFAULT 0 NOT NULL, 38 login integer DEFAULT 0 NOT NULL, 39 status smallint DEFAULT 0 NOT NULL, 40 timezone character varying(32), 41 language character varying(12) DEFAULT ''::character varying NOT NULL, 42 picture integer DEFAULT 0 NOT NULL, 43 init character varying(254) DEFAULT ''::character varying, 44 data bytea, 45 CONSTRAINT users_uid_check CHECK ((uid >= 0)) 46 ); 47 48 49 ALTER TABLE public.users OWNER TO db; 50 51 -- 52 -- Name: TABLE users; Type: COMMENT; Schema: public; Owner: db 53 -- 54 55 COMMENT ON TABLE public.users IS 'Stores user data.'; 56 57 58 -- 59 -- Name: COLUMN users.uid; Type: COMMENT; Schema: public; Owner: db 60 -- 61 62 COMMENT ON COLUMN public.users.uid IS 'Primary Key: Unique user ID.'; 63 64 65 -- 66 -- Name: COLUMN users.name; Type: COMMENT; Schema: public; Owner: db 67 -- 68 69 COMMENT ON COLUMN public.users.name IS 'Unique user name.'; 70 71 72 -- 73 -- Name: COLUMN users.pass; Type: COMMENT; Schema: public; Owner: db 74 -- 75 76 COMMENT ON COLUMN public.users.pass IS 'User''s password (hashed).'; 77 78 79 -- 80 -- Name: COLUMN users.mail; Type: COMMENT; Schema: public; Owner: db 81 -- 82 83 COMMENT ON COLUMN public.users.mail IS 'User''s e-mail address.'; 84 85 86 -- 87 -- Name: COLUMN users.theme; Type: COMMENT; Schema: public; Owner: db 88 -- 89 90 COMMENT ON COLUMN public.users.theme IS 'User''s default theme.'; 91 92 93 -- 94 -- Name: COLUMN users.signature; Type: COMMENT; Schema: public; Owner: db 95 -- 96 97 COMMENT ON COLUMN public.users.signature IS 'User''s signature.'; 98 99 100 -- 101 -- Name: COLUMN users.signature_format; Type: COMMENT; Schema: public; Owner: db 102 -- 103 104 COMMENT ON COLUMN public.users.signature_format IS 'The filter_format.format of the signature.'; 105 106 107 -- 108 -- Name: COLUMN users.created; Type: COMMENT; Schema: public; Owner: db 109 -- 110 111 COMMENT ON COLUMN public.users.created IS 'Timestamp for when user was created.'; 112 113 114 -- 115 -- Name: COLUMN users.changed; Type: COMMENT; Schema: public; Owner: db 116 -- 117 118 COMMENT ON COLUMN public.users.changed IS 'Timestamp for when user was changed.'; 119 120 121 -- 122 -- Name: COLUMN users.access; Type: COMMENT; Schema: public; Owner: db 123 -- 124 125 COMMENT ON COLUMN public.users.access IS 'Timestamp for previous time user accessed the site.'; 126 127 128 -- 129 -- Name: COLUMN users.login; Type: COMMENT; Schema: public; Owner: db 130 -- 131 132 COMMENT ON COLUMN public.users.login IS 'Timestamp for user''s last login.'; 133 134 135 -- 136 -- Name: COLUMN users.status; Type: COMMENT; Schema: public; Owner: db 137 -- 138 139 COMMENT ON COLUMN public.users.status IS 'Whether the user is active(1) or blocked(0).'; 140 141 142 -- 143 -- Name: COLUMN users.timezone; Type: COMMENT; Schema: public; Owner: db 144 -- 145 146 COMMENT ON COLUMN public.users.timezone IS 'User''s time zone.'; 147 148 149 -- 150 -- Name: COLUMN users.language; Type: COMMENT; Schema: public; Owner: db 151 -- 152 153 COMMENT ON COLUMN public.users.language IS 'User''s default language.'; 154 155 156 -- 157 -- Name: COLUMN users.picture; Type: COMMENT; Schema: public; Owner: db 158 -- 159 160 COMMENT ON COLUMN public.users.picture IS 'Foreign key: file_managed.fid of user''s picture.'; 161 162 163 -- 164 -- Name: COLUMN users.init; Type: COMMENT; Schema: public; Owner: db 165 -- 166 167 COMMENT ON COLUMN public.users.init IS 'E-mail address used for initial account creation.'; 168 169 170 -- 171 -- Name: COLUMN users.data; Type: COMMENT; Schema: public; Owner: db 172 -- 173 174 COMMENT ON COLUMN public.users.data IS 'A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future version of Drupal.'; 175 176 177 -- 178 -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: db 179 -- 180 181 COPY public.users (uid, name, pass, mail, theme, signature, signature_format, created, changed, access, login, status, timezone, language, picture, init, data) FROM stdin; 182 0 \N 0 0 0 0 0 \N 0 \N 183 1 admin $S$DNcYx6Inh./nX3YGehhp3cSg0pH9ZtqeAlqqwGjThoNsa9UXPlyh admin@example.com \N 1644002730 1644002786 1644003023 1644002786 1 America/Los_Angeles 0 admin@example.com \\x623a303b 184 \. 185 186 187 -- 188 -- Name: users users_name_key; Type: CONSTRAINT; Schema: public; Owner: db 189 -- 190 191 ALTER TABLE ONLY public.users 192 ADD CONSTRAINT users_name_key UNIQUE (name); 193 194 195 -- 196 -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: db 197 -- 198 199 ALTER TABLE ONLY public.users 200 ADD CONSTRAINT users_pkey PRIMARY KEY (uid); 201 202 203 -- 204 -- Name: users_access_idx; Type: INDEX; Schema: public; Owner: db 205 -- 206 207 CREATE INDEX users_access_idx ON public.users USING btree (access); 208 209 210 -- 211 -- Name: users_changed_idx; Type: INDEX; Schema: public; Owner: db 212 -- 213 214 CREATE INDEX users_changed_idx ON public.users USING btree (changed); 215 216 217 -- 218 -- Name: users_created_idx; Type: INDEX; Schema: public; Owner: db 219 -- 220 221 CREATE INDEX users_created_idx ON public.users USING btree (created); 222 223 224 -- 225 -- Name: users_mail_idx; Type: INDEX; Schema: public; Owner: db 226 -- 227 228 CREATE INDEX users_mail_idx ON public.users USING btree (mail); 229 230 231 -- 232 -- Name: users_picture_idx; Type: INDEX; Schema: public; Owner: db 233 -- 234 235 CREATE INDEX users_picture_idx ON public.users USING btree (picture); 236 237 238 -- 239 -- PostgreSQL database dump complete 240 -- 241