-- Name: lime_users; Type: TABLE; Schema: public; Owner: - CREATE TABLE lime_users ( -- Name: lime_users_uid_seq; Type: SEQUENCE; Schema: public; Owner: - CREATE SEQUENCE lime_users_uid_seq -- Name: lime_users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - ALTER SEQUENCE lime_users_uid_seq OWNED BY lime_users.uid; -- Name: lime_users uid; Type: DEFAULT; Schema: public; Owner: - ALTER TABLE ONLY lime_users ALTER COLUMN uid SET DEFAULT nextval('lime_users_uid_seq'::regclass); -- Data for Name: lime_users; Type: TABLE DATA; Schema: public; Owner: - COPY lime_users (uid, users_name, password, full_name, parent_id, lang, email, htmleditormode, templateeditormode, questionselectormode, one_time_pw, dateformat, created, modified) FROM stdin; -- Name: lime_users_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: - SELECT pg_catalog.setval('lime_users_uid_seq', 2, true); -- Name: lime_users lime_users_pkey; Type: CONSTRAINT; Schema: public; Owner: - ALTER TABLE ONLY lime_users ADD CONSTRAINT lime_users_pkey PRIMARY KEY (uid); CREATE UNIQUE INDEX lime_idx1_users ON lime_users USING btree (users_name); CREATE INDEX lime_idx2_users ON lime_users USING btree (email);

-- Name: lime_map_tutorial_users; Type: TABLE; Schema: public; Owner: - CREATE TABLE lime_map_tutorial_users ( -- Name: lime_users; Type: TABLE; Schema: public; Owner: - CREATE TABLE lime_users ( users_name character varying(64) DEFAULT ''::character varying NOT NULL, -- Name: lime_users_uid_seq; Type: SEQUENCE; Schema: public; Owner: - CREATE SEQUENCE lime_users_uid_seq -- Name: lime_users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - ALTER SEQUENCE lime_users_uid_seq OWNED BY lime_users.uid; -- Name: lime_users uid; Type: DEFAULT; Schema: public; Owner: - ALTER TABLE ONLY lime_users ALTER COLUMN uid SET DEFAULT nextval('lime_users_uid_seq'::regclass); -- Data for Name: lime_map_tutorial_users; Type: TABLE DATA; Schema: public; Owner: - COPY lime_map_tutorial_users (tid, uid, taken) FROM stdin; 7 1 \N 7 tokens Survey participant settings Participant settings Set additional options for survey participants users fontawesome updatesurveylocalesettings editLocalSettings_main_view /admin/survey/subview/accordion/_tokens_panel surveylocale read \N _tabTokens en-GB 0 1 2019-09-23 12:55:29 02019-09-23 12:55:29 0 27 3 \N 5 cpdb Central participant database Central participant database Central participant database users fontawesome admin/participants/sa/displayParticipants tokens read {"render": {"link": {}}} en-GB 1 1 2019-09-23 12:55:29 0 2019-09-23 12:55:29 0 -- Data for Name: lime_users; Type: TABLE DATA; Schema: public; Owner: - COPY lime_users (uid, users_name, password, full_name, parent_id, lang, email, htmleditormode, templateeditormode, questionselectormode, one_time_pw, dateformat, created, modified) FROM stdin; -- Name: lime_users_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: - SELECT pg_catalog.setval('lime_users_uid_seq', 2, true); -- Name: lime_map_tutorial_users lime_map_tutorial_users_pk; Type: CONSTRAINT; Schema: public; Owner: - ALTER TABLE ONLY lime_map_tutorial_users ADD CONSTRAINT lime_map_tutorial_users_pk PRIMARY KEY (uid, tid); -- Name: lime_users lime_users_pkey; Type: CONSTRAINT; Schema: public; Owner: - ALTER TABLE ONLY lime_users ADD CONSTRAINT lime_users_pkey PRIMARY KEY (uid); -- Name: lime_idx1_users; Type: INDEX; Schema: public; Owner: - CREATE UNIQUE INDEX lime_idx1_users ON lime_users USING btree (users_name); -- Name: lime_idx2_users; Type: INDEX; Schema: public; Owner: - CREATE INDEX lime_idx2_users ON lime_users USING btree (email);

698698 1 1 Demo Name N \N \N demo.name@domain.com N G N fruity en N N N Y 3 N N NN N 2019-10-21 09:09:50 0 N N N Y Y N N N N demo.name@domain.com \N 15 Y B N X\N N \N \N \N \N \N Y Y 0 0 N N \N \N 2 Demo $2y$10$2kasgEz5ZgtPq0RQ26q6u.Z1ZjpcbP9CiNlE64jJbEL.Pst/AVJm. demo name 1 auto demo.name@domain.com default default default \N 1 2019-10-21 09:10:44.808071 \N

public | lime_users | table | limesurvey (46 rows) limesurvey=# \d lime_users Table "public.lime_users" Column | Type | Modifiers ----------------------+-----------------------------+---------------------------------------------------------- uid | integer | not null default nextval('lime_users_uid_seq'::regclass) users_name | character varying(64) | not null default ''::character varying password | text | not null full_name | character varying(50) | not null parent_id | integer | not null lang | character varying(20) | email | character varying(192) | htmleditormode | character varying(7) | default 'default'::character varying templateeditormode | character varying(7) | not null default 'default'::character varying questionselectormode | character varying(7) | not null default 'default'::character varying one_time_pw | text | dateformat | integer | not null default 1 created | timestamp without time zone | modified | timestamp without time zone | Indexes: "lime_users_pkey" PRIMARY KEY, btree (uid) "lime_idx1_users" UNIQUE, btree (users_name) "lime_idx2_users" btree (email) limesurvey=#