Advertisement
Guest User

Untitled

a guest
May 5th, 2016
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.58 KB | None | 0 0
  1. mysql> select * from applications;
  2. +----------------+---------------+---------+------------------------------+---------------------+---------------------+---------------------+
  3. | id_application | id_restaurant | id_pack | name | start_date | end_date | valid_until_date |
  4. +----------------+---------------+---------+------------------------------+---------------------+---------------------+---------------------+
  5. | 1 | 1 | 2 | starterPack+AcademiadelGusto | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-08-01 00:00:01 |
  6. | 2 | 2 | 1 | starterPackBlackCornel | 2015-12-03 17:20:26 | 2015-07-12 00:00:00 | 2015-09-12 00:00:01 |
  7. | 3 | 3 | 3 | premiumPackQueen | 2015-07-02 00:00:00 | 2015-08-22 00:00:00 | 2015-10-12 00:00:01 |
  8. +----------------+---------------+---------+------------------------------+---------------------+---------------------+---------------------+
  9. 3 rows in set (0.00 sec)
  10.  
  11.  
  12. mysql> select * from employees;
  13. +-------------+--------------------+---------------+----------+-----------+----------------------------------+--------------+-----------------------+
  14. | id_employee | name | cnp | id_card | income | email | phone_number | address |
  15. +-------------+--------------------+---------------+----------+-----------+----------------------------------+--------------+-----------------------+
  16. | 1 | Osmara Bin Landrei | 1970320385592 | VX325432 | 0.0000 | osmarabinlandrei@allah.akhbar | 0700000000 | |
  17. | 2 | Mustafan Ahmihai | 1970326385593 | VX576890 | 9999.0000 | olarescutefan@gmail.com | 0769696969 | Strada Prostiei, nr.0 |
  18. | 3 | Al Valexeida | 1970314385569 | VX532830 | 1000.0000 | ihackzueverynight@hackerville.vl | 0350201529 | Nu se stie niciodata |
  19. +-------------+--------------------+---------------+----------+-----------+----------------------------------+--------------+-----------------------+
  20. 3 rows in set (0.00 sec)
  21.  
  22. mysql> select * from events;
  23. +----------+---------------------+-------------------+-------------------------------------------------------------+
  24. | id_event | name | location | description |
  25. +----------+---------------------+-------------------+-------------------------------------------------------------+
  26. | 1 | Eveniment fara nume | Locatie fara nume | O descriere intersanta |
  27. | 2 | Eveniment cu nume | Locatie cu nume | O descriere neintersanta |
  28. | 3 | DataCon | Bucuresti | Eveniment pentru dezvoltarea cunostiintelor de baze de date |
  29. +----------+---------------------+-------------------+-------------------------------------------------------------+
  30. 3 rows in set (0.00 sec)
  31.  
  32. mysql> select * from events_list;
  33. +---------+-------------+----------+
  34. | id_list | id_employee | id_event |
  35. +---------+-------------+----------+
  36. | 1 | 1 | 1 |
  37. | 2 | 2 | 2 |
  38. | 3 | 3 | 2 |
  39. | 4 | 1 | 3 |
  40. | 5 | 2 | 3 |
  41. | 6 | 3 | 3 |
  42. +---------+-------------+----------+
  43. 6 rows in set (0.00 sec)
  44.  
  45. mysql> select * from packs_type;
  46. +--------------+--------------+--------------+----------------+-------------+------------+------------+
  47. | id_pack_type | pack_name | display_menu | online_payment | call_waiter | book_table | statistics |
  48. +--------------+--------------+--------------+----------------+-------------+------------+------------+
  49. | 1 | StarterPack | 1 | 0 | 0 | 0 | 0 |
  50. | 2 | StarterPack+ | 1 | 0 | 1 | 1 | 0 |
  51. | 3 | Premium | 1 | 1 | 1 | 1 | 1 |
  52. +--------------+--------------+--------------+----------------+-------------+------------+------------+
  53. 3 rows in set (0.00 sec)
  54.  
  55. mysql> select * from restaurants
  56. -> ;
  57. +---------------+--------------------+------------------------------+-------------------------------+--------------+
  58. | id_restaurant | name | email | address | phone_number |
  59. +---------------+--------------------+------------------------------+-------------------------------+--------------+
  60. | 1 | Academia del Gusto | academia_del_gusto@yahoo.com | Str. Regina Maria, nr. 69 | 0721782921 |
  61. | 2 | Black Cornel | cornelu_negru@gmail.com | Str. Calea lui Traian, nr 112 | 0721121121 |
  62. | 3 | Queen | regina_frumi74@yahoo.com | Str. Carol 1, nr.314 | 0731220155 |
  63. +---------------+--------------------+------------------------------+-------------------------------+--------------+
  64. 3 rows in set (0.00 sec)
  65.  
  66.  
  67. mysql> select * from tasks;
  68. +---------+-------------+----------------+----------------+---------------------+---------------------+-----------------+
  69. | id_task | id_employee | id_application | name | start_date | end_date | coding_language |
  70. +---------+-------------+----------------+----------------+---------------------+---------------------+-----------------+
  71. | 1 | 1 | 1 | facut meniu | 2015-07-04 23:23:23 | 2015-12-03 23:23:24 | c++ |
  72. | 2 | 2 | 1 | chemat chelner | 2015-10-03 01:02:03 | 2015-12-02 01:02:04 | java |
  73. | 3 | 2 | 2 | design | 2015-06-09 12:12:12 | 2015-09-06 12:12:13 | photoshop |
  74. | 4 | 1 | 1 | facut meniu | 2015-07-04 23:23:23 | 2015-12-03 23:23:24 | c++ |
  75. | 5 | 2 | 1 | chemat chelner | 2015-10-03 01:02:03 | 2015-12-02 01:02:04 | java |
  76. | 6 | 2 | 2 | design | 2015-06-09 12:12:12 | 2015-09-06 12:12:13 | photoshop |
  77. | 7 | 3 | 2 | facut meniu | 2015-05-01 13:13:13 | 2015-10-06 14:14:14 | java |
  78. | 8 | 3 | 3 | design | 2015-01-05 12:12:12 | 2015-06-09 19:19:19 | paint |
  79. +---------+-------------+----------------+----------------+---------------------+---------------------+-----------------+
  80. 8 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement