CREATE TABLE "tokens" (
"chainId" bigint NOT NULL,
"address" varchar NOT NULL,
"logoURI" varchar,
"name" varchar NOT NULL,
"symbol" varchar NOT NULL,
"decimals" integer NOT NULL,
"priceUSD" varchar,
"marketCapUSD" double precision,
"volumeUSD24H" double precision,
"updatedAt" bigint NOT NULL,
CONSTRAINT "tokens_chainId_address_pk" PRIMARY KEY("chainId","address")
);
--> statement-breakpoint
CREATE INDEX "chainId_idx" ON "tokens" USING btree ("chainId");--> statement-breakpoint
CREATE INDEX "address_idxs" ON "tokens" USING btree ("address");
CREATE TABLE "tokens" (
"chainId" bigint NOT NULL,
"address" varchar NOT NULL,
"logoURI" varchar,
"name" varchar NOT NULL,
"symbol" varchar NOT NULL,
"decimals" integer NOT NULL,
"priceUSD" varchar,
"marketCapUSD" double precision,
"volumeUSD24H" double precision,
"updatedAt" bigint NOT NULL,
CONSTRAINT "tokens_chainId_address_pk" PRIMARY KEY("chainId","address")
);
--> statement-breakpoint
CREATE INDEX "chainId_idx" ON "tokens" USING btree ("chainId");--> statement-breakpoint
CREATE INDEX "address_idxs" ON "tokens" USING btree ("address");