create table trabajadores 
(
  id_trabajadores int primary key auto_increment,
  nombre varchar (50),
  usuario int (4),
  contrasena int (4),
  fecha_inscripcion date,
  tel int not null,
  direccion varchar (100),
  puesto varchar (50),
   sueldo int not null
  );
  
  
  create table libro
(
id_libro int primary key AUTO_INCREMENT,
nombre varchar (50),
escritor varchar (50),
edicion int not null,
estado varchar (20),
precio int not null,
sector varchar (1)
);


insert into clientes 
(nombre,apellido,fecha_inscripcion,tel,direccion,membrecia)values 
("carmen","aguilar","2025-01-15",48533472,"santa cruz","1"),
("maria","rodas","2025-02-15",505678,"barberena","2"),
("jose","veliz","2025-03-15",60723578,"cuilapa","2"),
("maria","reyes","2025-06-15",60890757,"cuilapa","1"),
("emanuel","barrientos","2025-03-16",60788090,"santa cruz naranjo","3");

insert into trabajdores 
(nombre,usuario,contrasena,tel,direccion,puesto,sueldo)VALUES
("juan",1438,1234,38109077,"santa cruz","administrador",2500),
("ana",1676,1487,16768518,"don gregorio","secretaria",3000),
("lucia",1785,1593,85243103,"potrerillo","conserje",1000),
("gabriel",1647, 1024,45639820,"teocinte","recepcionista",4000),
("roberto",1820,1520,40094403,"el naranjo","gerente",8000);