Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select * from applications;
- +----------------+---------------+---------+------------------------------+---------------------+---------------------+---------------------+
- | id_application | id_restaurant | id_pack | name | start_date | end_date | valid_until_date |
- +----------------+---------------+---------+------------------------------+---------------------+---------------------+---------------------+
- | 1 | 1 | 2 | starterPack+AcademiadelGusto | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-08-01 00:00:01 |
- | 2 | 2 | 1 | starterPackBlackCornel | 2015-12-03 17:20:26 | 2015-07-12 00:00:00 | 2015-09-12 00:00:01 |
- | 3 | 3 | 3 | premiumPackQueen | 2015-07-02 00:00:00 | 2015-08-22 00:00:00 | 2015-10-12 00:00:01 |
- +----------------+---------------+---------+------------------------------+---------------------+---------------------+---------------------+
- 3 rows in set (0.00 sec)
- mysql> select * from employees;
- +-------------+--------------------+---------------+----------+-----------+----------------------------------+--------------+-----------------------+
- | id_employee | name | cnp | id_card | income | email | phone_number | address |
- +-------------+--------------------+---------------+----------+-----------+----------------------------------+--------------+-----------------------+
- | 1 | Osmara Bin Landrei | 1970320385592 | VX325432 | 0.0000 | osmarabinlandrei@allah.akhbar | 0700000000 | |
- | 2 | Mustafan Ahmihai | 1970326385593 | VX576890 | 9999.0000 | olarescutefan@gmail.com | 0769696969 | Strada Prostiei, nr.0 |
- | 3 | Al Valexeida | 1970314385569 | VX532830 | 1000.0000 | ihackzueverynight@hackerville.vl | 0350201529 | Nu se stie niciodata |
- +-------------+--------------------+---------------+----------+-----------+----------------------------------+--------------+-----------------------+
- 3 rows in set (0.00 sec)
- mysql> select * from events;
- +----------+---------------------+-------------------+-------------------------------------------------------------+
- | id_event | name | location | description |
- +----------+---------------------+-------------------+-------------------------------------------------------------+
- | 1 | Eveniment fara nume | Locatie fara nume | O descriere intersanta |
- | 2 | Eveniment cu nume | Locatie cu nume | O descriere neintersanta |
- | 3 | DataCon | Bucuresti | Eveniment pentru dezvoltarea cunostiintelor de baze de date |
- +----------+---------------------+-------------------+-------------------------------------------------------------+
- 3 rows in set (0.00 sec)
- mysql> select * from events_list;
- +---------+-------------+----------+
- | id_list | id_employee | id_event |
- +---------+-------------+----------+
- | 1 | 1 | 1 |
- | 2 | 2 | 2 |
- | 3 | 3 | 2 |
- | 4 | 1 | 3 |
- | 5 | 2 | 3 |
- | 6 | 3 | 3 |
- +---------+-------------+----------+
- 6 rows in set (0.00 sec)
- mysql> select * from packs_type;
- +--------------+--------------+--------------+----------------+-------------+------------+------------+
- | id_pack_type | pack_name | display_menu | online_payment | call_waiter | book_table | statistics |
- +--------------+--------------+--------------+----------------+-------------+------------+------------+
- | 1 | StarterPack | 1 | 0 | 0 | 0 | 0 |
- | 2 | StarterPack+ | 1 | 0 | 1 | 1 | 0 |
- | 3 | Premium | 1 | 1 | 1 | 1 | 1 |
- +--------------+--------------+--------------+----------------+-------------+------------+------------+
- 3 rows in set (0.00 sec)
- mysql> select * from restaurants
- -> ;
- +---------------+--------------------+------------------------------+-------------------------------+--------------+
- | id_restaurant | name | email | address | phone_number |
- +---------------+--------------------+------------------------------+-------------------------------+--------------+
- | 1 | Academia del Gusto | academia_del_gusto@yahoo.com | Str. Regina Maria, nr. 69 | 0721782921 |
- | 2 | Black Cornel | cornelu_negru@gmail.com | Str. Calea lui Traian, nr 112 | 0721121121 |
- | 3 | Queen | regina_frumi74@yahoo.com | Str. Carol 1, nr.314 | 0731220155 |
- +---------------+--------------------+------------------------------+-------------------------------+--------------+
- 3 rows in set (0.00 sec)
- mysql> select * from tasks;
- +---------+-------------+----------------+----------------+---------------------+---------------------+-----------------+
- | id_task | id_employee | id_application | name | start_date | end_date | coding_language |
- +---------+-------------+----------------+----------------+---------------------+---------------------+-----------------+
- | 1 | 1 | 1 | facut meniu | 2015-07-04 23:23:23 | 2015-12-03 23:23:24 | c++ |
- | 2 | 2 | 1 | chemat chelner | 2015-10-03 01:02:03 | 2015-12-02 01:02:04 | java |
- | 3 | 2 | 2 | design | 2015-06-09 12:12:12 | 2015-09-06 12:12:13 | photoshop |
- | 4 | 1 | 1 | facut meniu | 2015-07-04 23:23:23 | 2015-12-03 23:23:24 | c++ |
- | 5 | 2 | 1 | chemat chelner | 2015-10-03 01:02:03 | 2015-12-02 01:02:04 | java |
- | 6 | 2 | 2 | design | 2015-06-09 12:12:12 | 2015-09-06 12:12:13 | photoshop |
- | 7 | 3 | 2 | facut meniu | 2015-05-01 13:13:13 | 2015-10-06 14:14:14 | java |
- | 8 | 3 | 3 | design | 2015-01-05 12:12:12 | 2015-06-09 19:19:19 | paint |
- +---------+-------------+----------------+----------------+---------------------+---------------------+-----------------+
- 8 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement