Advertisement
Guest User

database numedionline

a guest
Dec 1st, 2015
252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.46 KB | None | 0 0
  1. Database: numedionline
  2. [13 tables]
  3. +-----------------+
  4. | banner |
  5. | categories |
  6. | essays |
  7. | essaysOLD |
  8. | essays_ref |
  9. | giornale |
  10. | news |
  11. | sessions |
  12. | users |
  13. | usersOLD |
  14. | users_mail_send |
  15. | users_temp |
  16. | variables |
  17. +-----------------+
  18. #######################################
  19. Database: numedionline
  20. Table: users
  21. [20 columns]
  22. +----------------+---------------------------------------+
  23. | Column | Type |
  24. +----------------+---------------------------------------+
  25. | actdate | date |
  26. | address | varchar(255) |
  27. | birthdate | date |
  28. | cap | varchar(8) |
  29. | citta | varchar(64) |
  30. | date_payment | date |
  31. | email | varchar(64) |
  32. | fax | varchar(16) |
  33. | lastlogin | timestamp |
  34. | lastname | varchar(64) |
  35. | messaggio | text |
  36. | name | varchar(32) |
  37. | password | varchar(32) |
  38. | payment | varchar(32) |
  39. | prov | char(2) |
  40. | regdate | date |
  41. | role | enum('guest','user','editor','admin') |
  42. | status_payment | tinyint(4) |
  43. | tel | varchar(16) |
  44. | uid | bigint(20) unsigned |
  45. +----------------+---------------------------------------+
  46. ###########################################################
  47. Database: numedionline
  48. Table: users
  49. [8 entries]
  50. +------------+-----------------------------------------------+------------------------+------------+---------+----------+---------+----------------+-----------------------+----------------+-------------+
  51. | name | password | address | birthdate | cap | citta | payment | status_payment | email | fax | tel |
  52. +------------+-----------------------------------------------+------------------------+------------+---------+----------+---------+----------------+-----------------------+----------------+-------------+
  53. | Mario | c04d0e167590e841c9fb67c9821bd605 | <blank> | 0000-00-00 | <blank> | <blank> | <blank> | 0 | direttore | <blank> | <blank> |
  54. | Gino | 7a5912882dbc24eda5c5f9fb46e474eb | Via Adolfo Venturi, 24 | 1960-10-08 | 162 | Roma | paypal | 0 | g.santini | 68607721 | 68600674 |
  55. | <blank> | 74f4ca4a2d7a66421ad2e1f8fa96444e | <blank> | 0000-00-00 | <blank> | <blank> | <blank> | 0 | admintest | <blank> | <blank> |
  56. | Alessandro | d1e50ba7c383ec4d36100d279334b781 | <blank> | 0000-00-00 | <blank> | <blank> | <blank> | 0 | a.ginevri@starfarm.it | <blank> | <blank> |
  57. | Fabrizio | 2cbd7533297e88b22132db62804ef12f | via De Pinedo 1 | 0000-00-00 | 43 | Ciampino | banca | 0 | fabser1968@gmail.com | 12312312312312 | 123123123 |
  58. | Maurizio | 79a204c83205b228f58b9becf65708bc | <blank> | 0000-00-00 | <blank> | <blank> | <blank> | 0 | m.colantoni | <blank> | <blank> |
  59. | Davide | 33fc3dbd51a8b38a38b1b85b6a76b42b (test13) | Via Olof Palme, 6 | 0000-00-00 | 44124 | Ferrara | paypal | 0 | info@willyweb.it | 0532 001122 | 0532 000000 |
  60. | Davide | e807f1fcf82d132f9bb018ca6738a19f (1234567890) | Via Olof Palme, 6 | 0000-00-00 | 44124 | Ferrara | paypal | 0 | test | 0532 001122 | 0532 000000 |
  61. +------------+-----------------------------------------------+------------------------+------------+---------+----------+---------+----------------+-----------------------+----------------+-------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement