Guest User

Untitled

a guest
Jun 2nd, 2018
529
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.78 KB | None | 0 0
  1. INSERT INTO `administrador` (`id_administrador`, `nombre`, `apellido`, `correo`, `nivel`, `pw`)
  2. VALUES
  3. (1, 'Ernesto', 'sierra', 'ernespee@gmail.com', 1, '123');
  4. INSERT INTO `administrador` (`id_administrador`, `nombre`, `apellido`, `correo`, `nivel`, `pw`)
  5. VALUES
  6. (2, 'Josue', 'Alas', 'josuealas701@gmail.com', 1, '123');
  7. INSERT INTO `administrador` (`id_administrador`, `nombre`, `apellido`, `correo`, `nivel`, `pw`)
  8. VALUES
  9. (3, 'Meyli', 'Yudira', 'meyli@gmail.com', 1, '123');
  10. INSERT INTO `administrador` (`id_administrador`, `nombre`, `apellido`, `correo`, `nivel`, `pw`)
  11. VALUES
  12. (4, 'Diego', 'Lopez', 'Diego@gmail.com', 1, '123'),(5, 'Irvin', 'Adiel', 'irvin@gmail.com', 1, '123');
  13.  
  14. SELECT * FROM administrador
  15. SELECT * FROM car
  16. INSERT INTO `car` (`id_car`, `id_service_car`, `cantidacar`, `id_payment_id_car`, `costo_car`)
  17. VALUES
  18. (22, 54, 1, 65, 1300);
  19.  
  20. INSERT INTO `divisas` (`id_divisas`, `name_divisa`, `simbolo_divisa`)
  21. VALUES
  22. (1, 'dolar', '$'),
  23. (2, 'euros', '€'),
  24. (3, 'libra', '£');
  25. SELECT * FROM divisas
  26.  
  27. INSERT INTO `empresa` (`id_empresa`, `name_empresa`, `tel_empresa`, `rif_empresa`, `dir_empresa`, `id_admin_id_empresa`, `logo_empresa`) VALUES
  28. (1, 'Compucenter', '2440-4344', 'j-21545412-0', 'Boulevar 76 Ahuchapan, Santa ana ', 1, 'logoc3.png');
  29. SELECT * FROM empresa
  30.  
  31. INSERT INTO `ingresos` (`id_ingreso`, `id_service_id_ingreso`, `fecha_ingreso`, `id_proveedor_id_ingreso`, `cantida_movimiento`, `motivo`)
  32. VALUES
  33. (40, 54, '2017-10-21 02:00:00', 1, 3, 'nuevo ingreso a la cuenta');
  34. SELECT * FROM ingresos
  35.  
  36. INSERT INTO `payments` (`id_payments`, `state_payment`, `date_payment`, `id_user_id_payments`, `id_accounts_id_payments`, `date_pago`)
  37. VALUES
  38. (65, 'aceptado', '2017-10-22 00:10:45', 8, 10, '2017-10-22 01:10:30');
  39. SELECT * FROM payments
  40.  
  41. INSERT INTO `proveedor` (`id_proveedor`, `nombre_proveedor`, `telefono_proveedor`, `correo`) VALUES
  42. (1, 'Microsoft', '2233-5544', 'microsoft@microsoft.com'),
  43. (2, 'no a aplica', '0426-1454751', 'popotas@popotas.com');
  44. SELECT * FROM proveedor
  45.  
  46. INSERT INTO `saldo` (`id_saldo`, `cantida_saldo`, `id_saldo_id_accounts`, `id_divisa_id_saldo`)
  47. VALUES
  48. (1, 18, 10, 1),
  49. (2, 10, 10, 2),
  50. (3, 25, 11, 3),
  51. (4, 5, 11, 2);
  52. SELECT * FROM saldo
  53.  
  54. INSERT INTO `service` (`id_service`, `name_service`, `price_service`, `date_ven_service`, `info_service`, `cantida`, `date_registro_pro`, `tipo_producto`, `imagen`, `costo`, `state_service`) VALUES
  55. (54, 'maus', 1300, '0000-00-00 00:00:00', 'mejora su visualizacion', 3, '2017-10-22 00:10:50', 'servicio ', 'producto_heavydeveloperstext.pngsistemaphp', 1200, 0);
  56. SELECT * FROM service
  57.  
  58. INSERT INTO `user` (`id_user`, `name_user`, `last_name_user`, `mail_user`, `phone_user`, `ci_user`, `pw_user`, `direccion`, `id_admin_id_user`) VALUES
  59. (8, 'yon', 'cacadsd', 'y@y.com', 424762061, '23134135', '123456', 'calle 12 carrera 9-10', 1);
  60. SELECT * FROM USER
Add Comment
Please, Sign In to add comment