<commit_before>INSERT INTO dbo.tbl_Rank(RankName, RankWeight, Term)
  VALUES (' ', 1, 1),
          ('', 2, 2),
          (' ', 3, 3),
          ('', 4, 3),
          ('', 5, 5),
          (' ', 6, 1),
          ('', 7, 2),
          (' ', 8, 3),
          ('', 9, 3),
          ('', 10, 4),
          ('', 11, 5);

GO

INSERT INTO dbo.tbl_Service (ServiceName, ServiceShortName, ServiceGroupId)
  VALUES (' ', '', 100),
        ('   ', '',200),
        ('  ', '',300),
        (' ', '', 400),
        ('- ', '', 500),
        (' ', '',600),
        ('    ', '',700),
        ('- ', '',800),
        ('  ', NULL, 801),
        (' ', NULL, 802),
        ('   ', NULL, 803),
        ('- ', NULL, 804);

GO

INSERT INTO dbo.tbl_Post (PostName, ServiceID, PostWeight)
  VALUES ('. ', 1, 1),	-- 
        ('.  ', 1, 2),
        ('.  ', 1, 2),
        ('.  ', 1, 2),
        ('. . ', 1, 3),
        (' ', 1, 4),
        (' . ', 2, 1),	--   
        (' . ', 2, 2),
        ('. . ', 3, 1),	--  
        (' ', 3, 2),
        ('', 3, 3),
        ('', 4, 1),	-- 
        ('  . ', 4, 2),
        ('-', 4, 3),
        ('-', 4, 4),
        ('', 5, 1),	--- 
        (' ', 5, 2),
        ('-', 5, 3),
        ('-', 5, 4),
        ('', 6, 1),	-- 
        ('-', 6, 2),
        (' ', 6, 3),
        (' -', 6, 4),
        ('-', 6, 5),
        ('', 7, 1),	-- .   
        ('', 7, 2),
        (' ', 7, 3),
        (' --.', 7, 4),
        ('', 8, 1),	--- 
        ('-', 9, 1), --  
        (' -', 10, 1),	-- 
        ('-', 10, 2),
        ('', 11, 1),	--   
        (' ', 11, 2),
        ('-', 11, 3),
        (' ', 12, 1),	--- 
        (' -', 12, 2),
        ('-', 12, 3),
        (' -', 12, 4),
        ('-', 12, 5)
GO

INSERT INTO dbo.tbl_Address(City, Area, DetailedAddress, ZipCode) 
  VALUES ('', '', '. , .23, . 2', '222333'),
         ('', '', '. , .21, .5', '215345'),
         ('', '', '. , .3, .93', '241562'),
         ('', '', '. , .11, .51', '235561'),
         ('', '', '. , .5, .4', '213312'),
         ('', '', '. , .77, .13', '238093'),
         ('', '', '. , .32, .54', '215432');

GO

INSERT INTO dbo.tbl_Passport(PassportNumber, PassportOrganization)
  VALUES ('HB7865463', ' '),
	 ('HB2495463', ' '),
	 ('HB7852456', ' '),
	 ('HB3893042', ' '),
	 ('HB1354675', ' '),
	 ('HB7353223', ' '),
	 ('HB5418228', ' ');


GO

INSERT INTO dbo.tbl_Employee(EmployeeFirstname, EmployeeLastname, EmployeeMiddlename, BirthDate, PassportID, AddressID, RetirementDate, Description)
  VALUES ('', '', '', '1974-10-01', 1, 1, NULL, NULL),
	('', '', '', '1975-02-04', 2, 2, NULL, NULL),
	('', '', '', '1969-01-04', 3, 3, NULL, NULL),
	('', '', '', '1974-04-06', 4, 4, NULL, NULL),
	('', '', '', '1981-04-03', 5, 5, NULL, NULL),
	('', '', '', '1983-04-06', 6, 6, NULL, NULL),
	('', '', '', '1979-09-03', 7, 7, NULL, NULL);

GO

INSERT INTO dbo.tbl_Location(LocationName, Address, Description)
VALUES (' ', ' 59', ''),
	(' ', ' 4', ''),
	(' ', ' 5', ''),
	(' ', ' 25', '');

GO

INSERT INTO dbo.tbl_MESAchievement (EmployeeID, LocationID, StartDate, FinishDate, PostID, RankID, Description)<commit_msg>Added records to the sql filling script.<commit_after>INSERT INTO dbo.tbl_Rank(RankName, RankWeight, Term)
  VALUES (' ', 1, 1),
          ('', 2, 2),
          (' ', 3, 3),
          ('', 4, 3),
          ('', 5, 5),
          (' ', 6, 1),
          ('', 7, 2),
          (' ', 8, 3),
          ('', 9, 3),
          ('', 10, 4),
          ('', 11, 5);

GO

INSERT INTO dbo.tbl_Service (ServiceName, ServiceShortName, ServiceGroupId)
  VALUES (' ', '', 100),
        ('   ', '',200),
        ('  ', '',300),
        (' ', '', 400),
        ('- ', '', 500),
        (' ', '',600),
        ('    ', '',700),
        ('- ', '',800),
        ('  ', NULL, 801),
        (' ', NULL, 802),
        ('   ', NULL, 803),
        ('- ', NULL, 804);

GO

INSERT INTO dbo.tbl_Post (PostName, ServiceID, PostWeight)
  VALUES ('. ', 1, 1),	-- 
        ('.  ', 1, 2),
        ('.  ', 1, 2),
        ('.  ', 1, 2),
        ('. . ', 1, 3),
        (' ', 1, 4),
        (' . ', 2, 1),	--   
        (' . ', 2, 2),
        ('. . ', 3, 1),	--  
        (' ', 3, 2),
        ('', 3, 3),
        ('', 4, 1),	-- 
        ('  . ', 4, 2),
        ('-', 4, 3),
        ('-', 4, 4),
        ('', 5, 1),	--- 
        (' ', 5, 2),
        ('-', 5, 3),
        ('-', 5, 4),
        ('', 6, 1),	-- 
        ('-', 6, 2),
        (' ', 6, 3),
        (' -', 6, 4),
        ('-', 6, 5),
        ('', 7, 1),	-- .   
        ('', 7, 2),
        (' ', 7, 3),
        (' --.', 7, 4),
        ('', 8, 1),	--- 
        ('-', 9, 1), --  
        (' -', 10, 1),	-- 
        ('-', 10, 2),
        ('', 11, 1),	--   
        (' ', 11, 2),
        ('-', 11, 3),
        (' ', 12, 1),	--- 
        (' -', 12, 2),
        ('-', 12, 3),
        (' -', 12, 4),
        ('-', 12, 5)
GO

INSERT INTO dbo.tbl_Address(City, Area, DetailedAddress, ZipCode) 
  VALUES ('', '', '. , .23, . 2', '222333'),
         ('', '', '. , .21, .5', '215345'),
         ('', '', '. , .3, .93', '241562'),
         ('', '', '. , .11, .51', '235561'),
         ('', '', '. , .5, .4', '213312'),
         ('', '', '. , .77, .89', '238093'),
         ('', '', '. , .23, .75', '289754'),
         ('', '', '. , .34, .55', '235086'),
         ('', '', '.  , .43, .13', '241043'),
         ('', '', '. , .41, .141', '453988'),
         ('', '', '. , .42, .34', '209283'),
         ('', '', '. , .55, .4', '298774'),
         ('', '', '. , .1, .15', '294855'),
         ('', '', '. , .32, .54', '215432');

GO

INSERT INTO dbo.tbl_Passport(PassportNumber, PassportOrganization)
  VALUES ('HB7865463', ' '),
	 ('HB2495463', ' '),
	 ('HB7852456', ' '),
	 ('HB3893042', ' '),
	 ('HB1354675', ' '),
	 ('HB7353223', ' '),
	 ('HB8288383', ' '),
	 ('HB7737228', ' '),
	 ('HB8984857', ' '),
	 ('HB1786232', ' '),
	 ('HB4788524', ' '),
	 ('HB3664234', ' '),
	 ('HB8304983', ' '),
	 ('HB8263567', ' ');


GO

INSERT INTO dbo.tbl_Employee(EmployeeFirstname, EmployeeLastname, EmployeeMiddlename, BirthDate, PassportID, AddressID, RetirementDate, Description)
  VALUES ('', '', '', '1974-10-01', 1, 1, NULL, NULL),
	('', '', '', '1975-02-04', 2, 2, NULL, NULL),
	('', '', '', '1969-01-04', 3, 3, NULL, NULL),
	('', '', '', '1974-04-06', 4, 4, NULL, NULL),
	('', '', '', '1981-04-03', 5, 5, NULL, NULL),
	('', '', '', '1983-04-06', 6, 6, NULL, NULL),
	('', '', '', '1981-03-11', 7, 7, NULL, NULL),
	('', '', '', '1984-11-09', 8, 8, NULL, NULL),
	('', '', '', '1983-04-06', 9, 9, NULL, NULL),
	('', '', '', '1989-04-03', 10, 10, NULL, NULL),
	('', '', '', '1991-04-08', 11, 11, NULL, NULL),
	('', '', '', '1987-05-01', 12, 12, NULL, NULL),
	('', '', '', '1980-12-06', 13, 13, NULL, NULL),
	('', '', '', '1979-09-03', 14, 14, NULL, NULL);

GO

INSERT INTO dbo.tbl_Location(LocationName, Address, Description)
VALUES (' ', ' 59', ''),
	('  15', ' 59', ''),
	('  7', ' 59', ''),
	('  3', ' 59', ''),
	('  11', ' 59', ''),
	('  1', ' 59', '');

GO

INSERT INTO dbo.tbl_MESAchievement (EmployeeID, LocationID, StartDate, FinishDate, PostID, RankID, Description)
{'fraction_non_alphanumeric': 0.3171043293115685, 'fraction_numerical': 0.12647267565649398, 'mean_word_length': 1.6598716496791242, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1075363', 'n_tokens_mistral': 3474, 'n_tokens_neox': 2660, 'n_words': 577}