Create database UserLogin;
USE UserLogin;
Create table dohod2005
(ID int(11) auto_increment primary key not null,
INN char(13) not null,
NameORG char(20) not null,
ID_D2005 int(11) not null,
NameRab char(25) not null);
Create table dohmes
(ID int(11) auto_increment primary key,
ID_D2005 int(11) not null,
Nommes char(2) default ‘01’ not null,
Summes int(11) not null,
Koddoh int(11) not null);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (1,’7107547812’,’Perspectiva’, 7223,’Peterson’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (2,’7107547812’,’Perspectiva’, 7226,’Jaramush’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (3,’7107547812’,’Perspectiva’, 7231,’Sabler’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (4,’45623411225’,’BlackNoise’, 7267,’Peterson’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (5,’45623411225’,’BlackNoise’, 8001,’Karlson’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (6,’45623411225’,’BlackNoise’, 8011,’Svenson’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (7,’45623411225’,’BlackNoise’, 8061,’Shneerson’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (8,’680987345515’,’Modos’, 1002,’Navuhodonosor’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (9,’680987345515’,’Modos’, 1012,’Plumkin’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (10,’680987345515’,’Modos’, 1014,’Solomonson’);
Insert dohod2005(ID, INN, NameORG, ID_D2005, NameRab)
values (11,’680987345515’,’Modos’, 1035,’Shulmanson’);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (1,7223,’01’,1000,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (2,7223,’02’,1100,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (3,7231,’03’,1200,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (4,7231,’03’,200,2200);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (5,7267,’04’,1300,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (6,7267,’05’,1400,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (7,7226,’01’,500,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (8,7226,’02’,600,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (9,8001,’03’,700,2500);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (10,1012,’04’,800,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (11,1012,’05’,900,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (12,8011,’08’,2900,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (13,8011,’02’,2800,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (14,1002,’02’,290,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (15,1002,’05’,190,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (16,1014,’02’,1200,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (17,1014,’03’,1400,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (18,1014,’04’,1600,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (19,1014,’06’,1800,2000);
Insert dohmes(ID, ID_D2005, nommes, summes, koddoh)
values (20,1035,’07’,1800,2200);
