Yam Code
Sign up
Login
New paste
Home
Trending
Archive
English
English
Tiếng Việt
भारत
Sign up
Login
New Paste
Browse
-- -- PostgreSQL database dump -- -- Dumped from database version 13.1 (Debian 13.1-1.pgdg100+1) -- Dumped by pg_dump version 13.1 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: answers; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE public.answers ( id integer NOT NULL, id_user integer NOT NULL, list_answers jsonb NOT NULL ); ALTER TABLE public.answers OWNER TO root; -- -- Name: answers_id_seq; Type: SEQUENCE; Schema: public; Owner: root -- CREATE SEQUENCE public.answers_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.answers_id_seq OWNER TO root; -- -- Name: answers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root -- ALTER SEQUENCE public.answers_id_seq OWNED BY public.answers.id; -- -- Name: questions; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE public.questions ( id integer NOT NULL, content character varying NOT NULL, value character varying NOT NULL, id_exam integer NOT NULL, correct_answers jsonb DEFAULT '[]'::jsonb NOT NULL, answers_list jsonb DEFAULT '[]'::jsonb NOT NULL, meta jsonb DEFAULT '{}'::jsonb NOT NULL ); ALTER TABLE public.questions OWNER TO root; -- -- Name: question_id_seq; Type: SEQUENCE; Schema: public; Owner: root -- CREATE SEQUENCE public.question_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.question_id_seq OWNER TO root; -- -- Name: question_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root -- ALTER SEQUENCE public.question_id_seq OWNED BY public.questions.id; -- -- Name: users; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE public.users ( id integer NOT NULL, username character varying NOT NULL, password character varying NOT NULL, status integer ); ALTER TABLE public.users OWNER TO root; -- -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: root -- CREATE SEQUENCE public.users_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.users_id_seq OWNER TO root; -- -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root -- ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id; -- -- Name: answers id; Type: DEFAULT; Schema: public; Owner: root -- ALTER TABLE ONLY public.answers ALTER COLUMN id SET DEFAULT nextval('public.answers_id_seq'::regclass); -- -- Name: questions id; Type: DEFAULT; Schema: public; Owner: root -- ALTER TABLE ONLY public.questions ALTER COLUMN id SET DEFAULT nextval('public.question_id_seq'::regclass); -- -- Name: users id; Type: DEFAULT; Schema: public; Owner: root -- ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass); -- -- Data for Name: answers; Type: TABLE DATA; Schema: public; Owner: root -- INSERT INTO public.answers VALUES (2, 3, '[]'), (3, 3, '[]'), (5, 3, '[{"answer": 1, "id_question": 1}, {"answer": 2, "id_question": 2}, {"answer": 2, "id_question": 3}, {"answer": 2, "id_question": 4}, {"answer": 2, "id_question": 5}]'), (6, 3, '[{"answer": 1, "id_question": 1}, {"answer": 2, "id_question": 2}, {"answer": 2, "id_question": 3}, {"answer": 2, "id_question": 4}, {"answer": 2, "id_question": 5}]'), (7, 3, '[{"answer": 1, "id_question": 1}, {"answer": 2, "id_question": 2}, {"answer": 2, "id_question": 3}, {"answer": 2, "id_question": 4}, {"answer": 2, "id_question": 5}]'), (8, 3, '[{"answer": 1, "id_question": 1}, {"answer": 2, "id_question": 2}, {"answer": 2, "id_question": 3}, {"answer": 2, "id_question": 4}, {"answer": 2, "id_question": 5}]'); -- -- Data for Name: questions; Type: TABLE DATA; Schema: public; Owner: root -- INSERT INTO public.questions VALUES (1, 'what''s color is fire ?', '', 1, '[1]', '[{"id": 1, "text": "red"}, {"id": 2, "text": "blue"}]', '{}'), (4, 'what''s color is the cloud ?', '', 1, '[1]', '[[{"id": 1, "text": "white"}, {"id": 2, "text": "blue"}]]', '{}'), (5, 'what''s color of ruby ?', '', 1, '[1]', '[[{"id": 1, "text": "red"}, {"id": 2, "text": "blue"}]]', '{}'), (2, 'what''s color of the sky?', '', 1, '[2]', '[[{"id": 1, "text": "red"}, {"id": 2, "text": "blue"}]]', '{}'), (3, 'what''s color is hope ?', '', 1, '[2]', '[[{"id": 1, "text": "red"}, {"id": 2, "text": "blue"}]]', '{}'); -- -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: root -- INSERT INTO public.users VALUES (1, 'test1', '$2b$04$bVu7n43I1giDqmU7Pvhgd.BZ6k9JVo4GP6qmi3LIlNysprQxjNFzq', NULL), (2, 'test12', '$2b$04$Buot9yVUOCOIfUEVFdGwNOpiRjCg0zxrS49V9nZBnEH4PPIUobG8C', NULL), (4, 'quan123', '$2b$04$q0nveNh.9zPHVBmqs0MfkO.Dm510C9n.uXiuNuRXll1PT/1HqZWaS', NULL), (5, 'test123456', '$2b$04$1Tt2r5lY0.bO8WHvXgdJu.Sl.84bTKGy0AQVr1PWqoBsDuoZJXkWC', NULL), (3, 'quan', '$2b$04$SruE.e1oz2Nwh7Hyqtfw0OQ0e5a0eDh7Ioe4123lt1Rq0j8fMiQc6', NULL), (6, 'test1212', '$2b$04$R26cPGrj9Xke/vVsLm2JZejDxVUe/4BtTjpnA8JGsAmiEcYOOM.Du', 1); -- -- Name: answers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root -- SELECT pg_catalog.setval('public.answers_id_seq', 8, true); -- -- Name: question_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root -- SELECT pg_catalog.setval('public.question_id_seq', 1, false); -- -- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root -- SELECT pg_catalog.setval('public.users_id_seq', 6, true); -- -- Name: answers unique_answers_id; Type: CONSTRAINT; Schema: public; Owner: root -- ALTER TABLE ONLY public.answers ADD CONSTRAINT unique_answers_id UNIQUE (id); -- -- Name: questions unique_question_id; Type: CONSTRAINT; Schema: public; Owner: root -- ALTER TABLE ONLY public.questions ADD CONSTRAINT unique_question_id PRIMARY KEY (id); -- -- Name: users unique_users_id; Type: CONSTRAINT; Schema: public; Owner: root -- ALTER TABLE ONLY public.users ADD CONSTRAINT unique_users_id PRIMARY KEY (id); -- -- PostgreSQL database dump complete --
Paste Settings
Paste Title :
[Optional]
Paste Folder :
[Optional]
Select
Syntax Highlighting :
[Optional]
Select
Markup
CSS
JavaScript
Bash
C
C#
C++
Java
JSON
Lua
Plaintext
C-like
ABAP
ActionScript
Ada
Apache Configuration
APL
AppleScript
Arduino
ARFF
AsciiDoc
6502 Assembly
ASP.NET (C#)
AutoHotKey
AutoIt
Basic
Batch
Bison
Brainfuck
Bro
CoffeeScript
Clojure
Crystal
Content-Security-Policy
CSS Extras
D
Dart
Diff
Django/Jinja2
Docker
Eiffel
Elixir
Elm
ERB
Erlang
F#
Flow
Fortran
GEDCOM
Gherkin
Git
GLSL
GameMaker Language
Go
GraphQL
Groovy
Haml
Handlebars
Haskell
Haxe
HTTP
HTTP Public-Key-Pins
HTTP Strict-Transport-Security
IchigoJam
Icon
Inform 7
INI
IO
J
Jolie
Julia
Keyman
Kotlin
LaTeX
Less
Liquid
Lisp
LiveScript
LOLCODE
Makefile
Markdown
Markup templating
MATLAB
MEL
Mizar
Monkey
N4JS
NASM
nginx
Nim
Nix
NSIS
Objective-C
OCaml
OpenCL
Oz
PARI/GP
Parser
Pascal
Perl
PHP
PHP Extras
PL/SQL
PowerShell
Processing
Prolog
.properties
Protocol Buffers
Pug
Puppet
Pure
Python
Q (kdb+ database)
Qore
R
React JSX
React TSX
Ren'py
Reason
reST (reStructuredText)
Rip
Roboconf
Ruby
Rust
SAS
Sass (Sass)
Sass (Scss)
Scala
Scheme
Smalltalk
Smarty
SQL
Soy (Closure Template)
Stylus
Swift
TAP
Tcl
Textile
Template Toolkit 2
Twig
TypeScript
VB.Net
Velocity
Verilog
VHDL
vim
Visual Basic
WebAssembly
Wiki markup
Xeora
Xojo (REALbasic)
XQuery
YAML
HTML
Paste Expiration :
[Optional]
Never
Self Destroy
10 Minutes
1 Hour
1 Day
1 Week
2 Weeks
1 Month
6 Months
1 Year
Paste Status :
[Optional]
Public
Unlisted
Private (members only)
Password :
[Optional]
Description:
[Optional]
Tags:
[Optional]
Encrypt Paste
(
?
)
Create New Paste
You are currently not logged in, this means you can not edit or delete anything you paste.
Sign Up
or
Login
Site Languages
×
English
Tiếng Việt
भारत