---

create table IF NOT EXISTS book (
    id int NOT NULL PRIMARY KEY,
    name varchar NOT NULL,
	avtor varchar not NULL,
	god_izdaniya varchar not NULL ); 
    
INSERT OR IGNORE INTO book (id, name, avtor, god_izdaniya) VALUEs
  ('1', 'Евгений Онегин', 'А.С.Пушкин', '1833'),
  ('2', 'Анна Каренина', 'Л.Н.Толстой', '1873–1877'),
  ('3', 'Лолита','В.В.Набаков', '1955'),
  ('4', 'Ромео и Джульетта', 'Уильям Шекспир', '1597');
        
    
SELECT*FROM book;

CREATE TABLE IF NOT EXISTS book_vivod (
  id int NOT NULL,
  happy_birzday date NOT NULL,
  name varchar NOT NULL,
  PRIMARY KEY (name),	
  FOREIGN KEY (id) REFERENCES happy_birzday (id));
  
  Select*FROM book_vivod;