CREATE TABLE IF NOT EXISTS app_users(id text PRIMARY KEY,password text NOT NULL,role text DEFAULT 'user',created_at timestamptz DEFAULT now());
CREATE TABLE IF NOT EXISTS app_daily(user_id text NOT NULL,date text NOT NULL,data jsonb NOT NULL,updated_at timestamptz DEFAULT now(),PRIMARY KEY(user_id,date));
CREATE TABLE IF NOT EXISTS app_warehouse(id bigserial PRIMARY KEY,user_id text NOT NULL,date text NOT NULL,name text NOT NULL,spec text NOT NULL,qty int NOT NULL,time text NOT NULL,created_at timestamptz DEFAULT now());
CREATE TABLE IF NOT EXISTS app_history(user_id text NOT NULL,icon text,text text,time text,date text,created_at timestamptz DEFAULT now());