Created At: 2026-11-18T04:10:21Z Completed At: 2026-11-18T04:10:22Z Command exited with code 0. Command output: -- -- PostgreSQL database dump -- \restrict rAcwZ0M2ajKc5M9TlSchBePiwhQzCguZ1nr62MJcIdJS5m5iBx6Jnhcm7kyyXWV -- Dumped from database version 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) -- Dumped by pg_dump version 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'SQL_ASCII'; 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: admin_actions; Type: TABLE; Schema: public; Owner: aadharbot -- CREATE TABLE public.admin_actions ( id integer NOT NULL, performer_id bigint NOT NULL, performer_name character varying(255), performer_role character varying(50) NOT NULL, action_type character varying(100) NOT NULL, target_id bigint, details text, created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP ); ALTER TABLE public.admin_actions OWNER TO aadharbot; -- -- Name: admin_actions_id_seq; Type: SEQUENCE; Schema: public; Owner: aadharbot -- CREATE SEQUENCE public.admin_actions_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.admin_actions_id_seq OWNER TO aadharbot; -- -- Name: admin_actions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aadharbot -- ALTER SEQUENCE public.admin_actions_id_seq OWNED BY public.admin_actions.id; -- -- Name: searches; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.searches ( id integer NOT NULL, telegram_id bigint, search_type character varying(50), name character varying(255), mobile_number character varying(20), eid character varying(50), aadhaar_number character varying(20), pdf_password character varying(50), pdf_base64 text, created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP ); ALTER TABLE public.searches OWNER TO postgres; -- -- Name: searches_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.searches_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.searches_id_seq OWNER TO postgres; -- -- Name: searches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.searches_id_seq OWNED BY public.searches.id; -- -- Name: successful_payments; Type: TABLE; Schema: public; Owner: aadharbot -- CREATE TABLE public.successful_payments ( id integer NOT NULL, user_id bigint NOT NULL, order_id character varying(255), serial_number character varying(255), amount double precision DEFAULT 0, plan_type character varying(100), utr character varying(255), created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP ); ALTER TABLE public.successful_payments OWNER TO aadharbot; -- -- Name: successful_payments_id_seq; Type: SEQUENCE; Schema: public; Owner: aadharbot -- CREATE SEQUENCE public.successful_payments_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.successful_payments_id_seq OWNER TO aadharbot; -- -- Name: successful_payments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aadharbot -- ALTER SEQUENCE public.successful_payments_id_seq OWNED BY public.successful_payments.id; -- -- Name: user_subscriptions; Type: TABLE; Schema: public; Owner: aadharbot -- CREATE TABLE public.user_subscriptions ( id integer NOT NULL, telegram_id bigint, plan_name character varying(100), duration character varying(100), days integer, amount character varying(50), payment_method character varying(100), order_id character varying(100), started_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP, expires_at timestamp without time zone, status character varying(50) DEFAULT 'ACTIVE'::character varying, created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP ); ALTER TABLE public.user_subscriptions OWNER TO aadharbot; -- -- Name: user_subscriptions_id_seq; Type: SEQUENCE; Schema: public; Owner: aadharbot -- CREATE SEQUENCE public.user_subscriptions_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.user_subscriptions_id_seq OWNER TO aadharbot; -- -- Name: user_subscriptions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aadharbot -- ALTER SEQUENCE public.user_subscriptions_id_seq OWNED BY public.user_subscriptions.id; -- -- Name: users; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.users ( id integer NOT NULL, name character varying(255) DEFAULT ''::character varying NOT NULL, email character varying(255), telegram_id bigint, password character varying(255), credits integer DEFAULT 0, subscription_end timestamp without time zone, plan_type character varying(50) DEFAULT 'credits'::character varying, plan_expires_at timestamp without time zone, thread_id integer, is_retailer boolean DEFAULT false, is_admin boolean DEFAULT false, total_referrals integer DEFAULT 0, referral_earnings double precision DEFAULT 0, referred_by bigint, referral_code character varying(100), created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP, updated_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP, plan_started_at timestamp without time zone, last_free_search_date character varying(10), subscription_duration character varying(100), subscription_payment_method character varying(100), subscription_amount character varying(50), role character varying(20) DEFAULT 'user'::character varying ); ALTER TABLE public.users OWNER TO postgres; -- -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.users_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.users_id_seq OWNER TO postgres; -- -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id; -- -- Name: admin_actions id; Type: DEFAULT; Schema: public; Owner: aadharbot -- ALTER TABLE ONLY public.admin_actions ALTER COLUMN id SET DEFAULT nextval('public.admin_actions_id_seq'::regclass); -- -- Name: searches id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.searches ALTER COLUMN id SET DEFAULT nextval('public.searches_id_seq'::regclass); -- -- Name: successful_payments id; Type: DEFAULT; Schema: public; Owner: aadharbot -- ALTER TABLE ONLY public.successful_payments ALTER COLUMN id SET DEFAULT nextval('public.successful_payments_id_seq'::regclass); -- -- Name: user_subscriptions id; Type: DEFAULT; Schema: public; Owner: aadharbot -- ALTER TABLE ONLY public.user_subscriptions ALTER COLUMN id SET DEFAULT nextval('public.user_subscriptions_id_seq'::regclass); -- -- Name: users id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass); -- -- Name: admin_actions admin_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: aadharbot -- ALTER TABLE ONLY public.admin_actions ADD CONSTRAINT admin_actions_pkey PRIMARY KEY (id); -- -- Name: searches searches_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.searches ADD CONSTRAINT searches_pkey PRIMARY KEY (id); -- -- Name: successful_payments successful_payments_order_id_key; Type: CONSTRAINT; Schema: public; Owner: aadharbot -- ALTER TABLE ONLY public.successful_payments ADD CONSTRAINT successful_payments_order_id_key UNIQUE (order_id); -- -- Name: successful_payments successful_payments_pkey; Type: CONSTRAINT; Schema: public; Owner: aadharbot -- ALTER TABLE ONLY public.successful_payments ADD CONSTRAINT successful_payments_pkey PRIMARY KEY (id); -- -- Name: user_subscriptions user_subscriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: aadharbot -- ALTER TABLE ONLY public.user_subscriptions ADD CONSTRAINT user_subscriptions_pkey PRIMARY KEY (id); -- -- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_email_key UNIQUE (email); -- -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_pkey PRIMARY KEY (id); -- -- Name: users users_telegram_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_telegram_id_key UNIQUE (telegram_id); -- -- Name: idx_admin_actions_created_at; Type: INDEX; Schema: public; Owner: aadharbot -- CREATE INDEX idx_admin_actions_created_at ON public.admin_actions USING btree (created_at DESC); -- -- PostgreSQL database dump complete -- \unrestrict rAcwZ0M2ajKc5M9TlSchBePiwhQzCguZ1nr62MJcIdJS5m5iBx6Jnhcm7kyyXWV