85 lines
4.8 KiB
SQL
85 lines
4.8 KiB
SQL
|
||
CREATE TABLE shop_auto (
|
||
id serial NOT NULL PRIMARY KEY,
|
||
name text DEFAULT ''::text NOT NULL,
|
||
price numeric(20,0) DEFAULT '999999999999'::bigint NOT NULL
|
||
);
|
||
CREATE UNIQUE INDEX shop_auto_uindex ON shop_auto(id);
|
||
|
||
CREATE TABLE shop_business (
|
||
id serial NOT NULL PRIMARY KEY ,
|
||
name text DEFAULT ''::text NOT NULL,
|
||
price numeric(20,0) DEFAULT 999999999 NOT NULL,
|
||
income numeric(20,0) DEFAULT 0 NOT NULL
|
||
);
|
||
CREATE UNIQUE INDEX shop_business_uindex ON shop_business(id);
|
||
|
||
CREATE TABLE shop_maid (
|
||
id serial NOT NULL PRIMARY KEY,
|
||
name text DEFAULT ''::text NOT NULL,
|
||
price numeric(20,0) DEFAULT 0 NOT NULL,
|
||
income numeric(20,0) DEFAULT 0 NOT NULL
|
||
);
|
||
CREATE UNIQUE INDEX shop_maid_uindex ON shop_maid(id);
|
||
|
||
CREATE TABLE shop_miner (
|
||
id serial NOT NULL,
|
||
name text DEFAULT ''::text NOT NULL,
|
||
price numeric(20,0) DEFAULT 1 NOT NULL,
|
||
income numeric(20,6) DEFAULT 1 NOT NULL
|
||
);
|
||
CREATE UNIQUE INDEX shop_miner_uindex ON shop_miner(id);
|
||
|
||
BEGIN TRANSACTION;
|
||
INSERT INTO shop_auto VALUES (1, 'Москвич 412', 40000);
|
||
INSERT INTO shop_auto VALUES (2, 'ВАЗ 2105', 100000);
|
||
INSERT INTO shop_auto VALUES (3, 'Nissan Skyline GT-R R32', 225000);
|
||
INSERT INTO shop_auto VALUES (4, 'Toyota AE86 Sprinter Trueno', 450000);
|
||
INSERT INTO shop_auto VALUES (5, 'Toyota Mark II X90 Tourer V', 800000);
|
||
INSERT INTO shop_auto VALUES (6, 'Mazda RX-7 FD3S', 1200000);
|
||
INSERT INTO shop_auto VALUES (7, 'Mitsubishi Lancer Evolution X', 1650000);
|
||
INSERT INTO shop_auto VALUES (8, 'Subaru Impreza WRX STI II', 1875000);
|
||
|
||
INSERT INTO shop_business VALUES (1, 'Стенд с лимонадом', 200000, 1500);
|
||
INSERT INTO shop_business VALUES (2, 'Союзпечать', 1000000, 7000);
|
||
INSERT INTO shop_business VALUES (3, 'Маленький магазин вещей из Китая', 2500000, 17500);
|
||
INSERT INTO shop_business VALUES (4, 'Ларёк с шаурмой', 3000000, 21000);
|
||
INSERT INTO shop_business VALUES (5, 'Магазин тофу', 5000000, 35000);
|
||
INSERT INTO shop_business VALUES (6, 'Соц. сеть', 10000000, 70000);
|
||
INSERT INTO shop_business VALUES (7, 'Продажа машин из Японии', 20000000, 140000);
|
||
INSERT INTO shop_business VALUES (8, 'Автосервис', 40000000, 280000);
|
||
INSERT INTO shop_business VALUES (9, 'Компания по разработке игр', 100000000, 700000);
|
||
INSERT INTO shop_business VALUES (10, 'Аниме студия', 250000000, 1725000);
|
||
INSERT INTO shop_business VALUES (11, 'Сеть магазинов', 500000000, 3500000);
|
||
INSERT INTO shop_business VALUES (12, 'Сеть заводов', 1000000000, 7000000);
|
||
INSERT INTO shop_business VALUES (13, 'Автосалон', 10000000000, 70000000);
|
||
INSERT INTO shop_business VALUES (14, 'Бренд электроники', 50000000000, 350000000);
|
||
INSERT INTO shop_business VALUES (15, 'Автомобильная марка', 100000000000, 700000000);
|
||
|
||
INSERT INTO shop_maid VALUES (1, 'Кавайная горничная', 50, 7500);
|
||
INSERT INTO shop_maid VALUES (2, 'Кавайная в кружеве', 100, 15000);
|
||
INSERT INTO shop_maid VALUES (3, 'Тору', 250, 30000);
|
||
INSERT INTO shop_maid VALUES (4, 'Лоли горничные', 500, 52500);
|
||
INSERT INTO shop_maid VALUES (5, 'Рам и Рем', 2000, 150000);
|
||
INSERT INTO shop_maid VALUES (6, 'Неко-горничная', 4500, 225000);
|
||
|
||
INSERT INTO shop_miner VALUES (1, 'Старый ПК', 20000, 0.000001);
|
||
INSERT INTO shop_miner VALUES (2, 'Новый ПК', 120000, 0.000005);
|
||
INSERT INTO shop_miner VALUES (3, 'Маленький майнер', 250000, 0.000010);
|
||
INSERT INTO shop_miner VALUES (4, 'Средний майнер', 600000, 0.000025);
|
||
INSERT INTO shop_miner VALUES (5, 'Большой майнер', 1000000, 0.000050);
|
||
INSERT INTO shop_miner VALUES (6, 'Огромный майнер', 2500000, 0.000100);
|
||
INSERT INTO shop_miner VALUES (7, 'Маленькая ферма майнеров', 10000000, 0.000500);
|
||
INSERT INTO shop_miner VALUES (8, 'Средняя ферма майнкеров', 100000000, 0.005000);
|
||
INSERT INTO shop_miner VALUES (9, 'Большая ферма майнеров', 500000000, 0.025000);
|
||
INSERT INTO shop_miner VALUES (10, 'Огромная ферма майнеров', 5000000000, 0.250000);
|
||
INSERT INTO shop_miner VALUES (11, 'Гигантская ферма майнеров', 10000000000, 0.500000);
|
||
INSERT INTO shop_miner VALUES (12, 'Комната майнеров', 25000000000, 1.000000);
|
||
INSERT INTO shop_miner VALUES (13, 'Этаж с майнерми', 100000000000, 5.000000);
|
||
INSERT INTO shop_miner VALUES (14, 'Небоскреб майнеров', 250000000000, 10.000000);
|
||
|
||
ALTER SEQUENCE shop_auto_id_seq RESTART WITH 9;
|
||
ALTER SEQUENCE shop_business_id_seq RESTART WITH 16;
|
||
ALTER SEQUENCE shop_maid_id_seq RESTART WITH 7;
|
||
ALTER SEQUENCE shop_miner_id_seq RESTART WITH 15;
|
||
COMMIT TRANSACTION; |