SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table languages( id int not null primary key, "isoCode" varchar not null, name varchar ); create table currencies( id int not null primary key, "isoCode" varchar not null, name varchar, sign varchar, "signPosition" varchar, separator varchar, "dateFormat" varchar, "isActive" boolean default true, "createdAt" timestamp without time zone not null default now(), "updatedAt" timestamp without time zone not null default now() ); create table users( id integer not null GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, name varchar, balance numeric(19,2) not null default '0'::numeric, "bonusBalance" numeric(19,2) not null default '0'::numeric, login varchar not null, password varchar not null, geo varchar not null default 'Bangladesh'::character varying, banned boolean not null default false, birthday timestamp without time zone, "createdAt" timestamp without time zone not null default now(), "updatedAt" timestamp without time zone not null default now(), "favoriteGamesIds" text[] default '{}'::text[], "currencyCode" varchar not null, "languageId" int not null, "sumBet" numeric(19,2) not null default '0'::numeric, "sumDeposit" numeric(19,2) not null default '0'::numeric, "currencyId" int, "clickId" varchar, "utmMedium" varchar, "utmSource" varchar, "utmCampaign" varchar, "mailingSubscription" boolean not null default true, "firstDeposit" boolean not null default false, "firstIp" varchar, "lastIp" varchar ); ALTER TABLE "users" ADD CONSTRAINT fk_language_user FOREIGN KEY("languageId") REFERENCES languages(id); ALTER TABLE "users" ADD CONSTRAINT fk_currency_user FOREIGN KEY("currencyId") REFERENCES currencies(id); insert into languages(id, "isoCode") values(1, 'en'); insert into currencies(id, "isoCode") values(1, 'USD'); insert into users(login, password, "currencyId", "currencyCode", "languageId") values('mr.rodion_oa@mail.ru', '1234', 1, 'USD', 1); select * from users; ALTER TABLE "users" DROP COLUMN "sumBet"; ALTER TABLE "users" DROP COLUMN "sumDeposit"; create table "users-meta"( userId int not null primary key, GGR numeric(19,2) not null default '0'::numeric, sumDeposit numeric(19,2) not null default '0'::numeric, sumWithdraw numeric(19,2) not null default '0'::numeric, sumBet numeric(19,2) not null default '0'::numeric, sumBetWin numeric(19,2) not null default '0'::numeric ); ALTER TABLE "users-meta" ADD CONSTRAINT fk_user_user_meta FOREIGN KEY(userId) REFERENCES "users"(id); create index user_meta_sum_deposit_index on "users-meta" (sumDeposit); select * from users;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear