Advertisement
Guest User

Untitled

a guest
Jun 16th, 2012
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DESCRIBE pet:
  2. Field Type Null Key Default Extra
  3. id int(11) NO PRI NULL auto_increment
  4. detail longtext NO UNI NULL
  5. sugCat int(11) NO 0
  6. catid int(11) NO MUL NULL
  7. tags text YES NULL
  8. date timestamp NO MUL CURRENT_TIMESTAMP
  9. views int(11) NO 0
  10. downloads int(11) NO 0
  11. delreq int(11) NO 0
  12. country varchar(30) YES US
  13. ownerID varchar(50) YES ABC
  14. supOwnID varchar(50) NO NULL
  15. newdelreq int(11) NO 0
  16. abnorml int(11) NO 0
  17. descrpt text YES NULL
  18. link text YES NULL
  19. bornDt datetime YES NULL
  20.  
  21. DESCRIBE ownrs:
  22. Field Type Null Key Default Extra
  23. id int(11) NO PRI NULL auto_increment
  24. uniqueID varchar(50) NO UNI NULL
  25. password varchar(64) NO NULL
  26. salt varchar(3) YES NULL
  27. question varchar(50) YES NULL
  28. answer varchar(30) YES NULL
  29. email varchar(50) NO NULL
  30. name varchar(30) NO MUL DEF
  31. joindate timestamp NO CURRENT_TIMESTAMP
  32. age int(11) YES NULL
  33. location text YES NULL
  34. contact mediumtext YES NULL
  35. super int(11) NO 0
  36. male int(11) NO 1
  37. catlimit int(11) NO 2
  38. makeWait int(11) NO 0
  39. modOwnr int(11) NO 0
  40.  
  41. DESCRIBE petfb:
  42. Field Type Null Key Default Extra
  43. id int(11) NO PRI NULL auto_increment
  44. petid int(11) NO MUL NULL
  45. feedback int(11) NO MUL NULL
  46. fbdate timestamp NO CURRENT_TIMESTAMP
  47. ownrid varchar(50) NO MUL NULL
  48. ownerid varchar(50) NO MUL NULL
  49. sugownid int(11) NO 0
  50.  
  51. DESCRIBE comments:
  52. Field Type Null Key Default Extra
  53. id int(11) NO PRI NULL auto_increment
  54. comment longtext NO NULL
  55. comDate timestamp NO MUL CURRENT_TIMESTAMP
  56. petid int(11) NO MUL NULL
  57. ownrid varchar(50) NO MUL NULL
  58. likes int(11) NO 0
  59. dislk int(11) NO 0
  60. report int(11) NO 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement