INSERT INTO STREET (STREETCD, STREETNM) VALUES (8,

МОСКОВСКОЕ ШОССЕ УЛИЦА);

INSERT INTO STREET (STREETCD, STREETNM) VALUES (4, ТАТАРСКАЯ

УЛИЦА);

INSERT INTO STREET (STREETCD, STREETNM) VALUES (5, ГАГАРИНА

УЛИЦА);

INSERT INTO STREET (STREETCD, STREETNM) VALUES (1, ЦИОЛКОВСКОГО УЛИЦА);

INSERT INTO STREET (STREETCD, STREETNM) VALUES (2, НОВАЯ

УЛИЦА);

COMMIT WORK;

/i /

/* Insert SERVICES */

/i /

INSERT INTO SERVICES (GAZSERVICECD, GAZSERVICENM) VALUES (1,

Доставка газа);

INSERT INTO SERVICES (GAZSERVICECD, GAZSERVICENM) VALUES (2,

Заявочный ремонт ГО);

COMMIT WORK;

/i /

/* Insert DISREPAIR */

/щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл I rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 I

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (1, Засорилась водогрейная колонка);

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (2, Не горит

АГВ);

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (3, Течет из водогрейной колонки);

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (4, Неисправна печная горелка);

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (5, Неисправен газовый счетчик);

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (6, Плохое поступление газа на горелку плиты);

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (7, Туго поворачивается пробка крана плиты);

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (8, При закрытии краника горелка плиты не гаснет);

INSERT INTO DISREPAIR (FAILURRECD, FAILURENM) VALUES (12, Неизвестна);

COMMIT WORK;

/* Insert EXECUTOR */

rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 I

INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (1,

СТАРОДУБЦЕВ Е.М.);

INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (2, БУЛГАКОВ

Т.И.);

INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (3, ШУБИН В.Г.); INSERT INTO EXECUTOR (eXECUTORCD, FIo) VALUES (4, ШЛЮКОВ

М.К.);

INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (5, ШКОЛЬНИКОВ С.М.);

COMMIT WORK;

/щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл щЯл I rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 I

/* Insert ABONENT */

rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 I

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (005488, 3, 4, 1, АКСЕНОВ С.А., 556893);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (115705, 3, 1, 82, МИЩЕНКО Е.В., 769975);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (015527, 3, 1, 65, КОНЮХОВ В.С., 761699);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (443690, 7, 5, 1, ТУЛУПОВА М.И., 214833);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (136159, 7, 39, 1, СВИРИНА З.А., 350003);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (443069, 4, 51, 55, СТАРОДУБЦЕВ Е.В., 683014);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (136160, 4, 9, 15, ШМАКОВ С.В., 982222);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (126112, 4, 7, 11, МАРКОВА В.П., 683301);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (136169, 4, 7, 13, ДЕНИСОВА Е.К., 680305);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (080613, 8, 35, 11, ЛУКАШИНА Р.М., 254417);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (080047, 8, 39, 36, ШУБИНА Т.П., 257842);

INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO,

FIO, PHONE) VALUES (080270, 6, 35, 6, ТИМОШКИНА Н.Г., 321002);

COMMIT WORK;

rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 I

/* Insert NACHISLSUMMA */

rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 I

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (19, 005488, 2, 58.7, 12, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (2, 005488, 2, 46, 12, 2000);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (3, 005488, 2, 56, 4, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (4, 115705, 2, 40, 1, 2000);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (5, 115705, 2, 250, 9, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (13, 136160, 2, 20, 5, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (1, 136160, 2, 56, 1, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (15, 136169, 2, 20, 5, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (7, 080047, 2, 80, 10, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (8, 080047, 2, 80, 10, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (9, 080270, 2, 46, 12, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (10, 080613, 2, 56, 6, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (11, 115705, 2, 250, 9, 2000);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (12, 115705, 2, 58.7, 8, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (16, 136169, 2, 58.7, 11, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (17, 443069, 2, 80, 9, 2001);