 create table contracts(
 id int not null auto_increment, 
 id_company int not null, 
 contract varchar(25), 
 term date, 
 primary key(id), 
 foreign key(id_company) referenses company(id));
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
INSERT INTO `contracts` VALUES (1,'1','arenda','2024-06-11'),(2,'2','pokupka','2024-08-22'),(3,'3','postavka','2024-09-11');
CREATE TABLE `company` (
  `id` int(11) NOT NULL,
  `company_name` varchar(25),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
INSERT INTO `company` VALUES (1,'Cisco'),(2,'Avanguard'),(3,'Telesistems'),(4,'NskService');