-- 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=#