-- 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);