API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 25th, 2017
118
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.35 KB | None | 0 0
raw download clone embed print report
  1. username usernick password expiration acl mod_time s_nickname company fname lname address1 address2 address3 city state zip country phone_day mv_shipmode b_nickname b_fname b_lname b_company b_address1 b_address2 b_address3 b_city b_state b_zip b_country b_phone p_nickname email fax phone_night address_book accounts preferences carts owner file_acl db_acl mail_list credit_limit inactive dealer price_level updated created
  2.  
  3. Database userdb userdb.txt __SQLDSN__
  4. Database userdb DEFAULT_TYPE varchar(255)
  5. Database userdb COLUMN_DEF "username=varchar(64) NOT NULL PRIMARY KEY"
  6. Database userdb COLUMN_DEF "usernick=varchar(64) NOT NULL"
  7. Database userdb COLUMN_DEF "password=varchar(64) NOT NULL"
  8. Database userdb COLUMN_DEF "expiration=varchar(32)"
  9. Database userdb COLUMN_DEF "accounts=BLOB"
  10. Database userdb COLUMN_DEF "acl=text"
  11. Database userdb COLUMN_DEF "address1=varchar(64)"
  12. Database userdb COLUMN_DEF "address2=varchar(64)"
  13. Database userdb COLUMN_DEF "address3=varchar(64)"
  14. Database userdb COLUMN_DEF "address_book=BLOB"
  15. Database userdb COLUMN_DEF "b_address1=varchar(64)"
  16. Database userdb COLUMN_DEF "b_address2=varchar(64)"
  17. Database userdb COLUMN_DEF "b_address3=varchar(64)"
  18. Database userdb COLUMN_DEF "b_city=varchar(30)"
  19. Database userdb COLUMN_DEF "b_company=varchar(64)"
  20. Database userdb COLUMN_DEF "b_country=varchar(10)"
  21. Database userdb COLUMN_DEF "b_fname=varchar(30)"
  22. Database userdb COLUMN_DEF "b_lname=varchar(30)"
  23. Database userdb COLUMN_DEF "b_nickname=text"
  24. Database userdb COLUMN_DEF "b_phone=varchar(30)"
  25. Database userdb COLUMN_DEF "b_state=varchar(10)"
  26. Database userdb COLUMN_DEF "b_zip=varchar(10)"
  27. Database userdb COLUMN_DEF "carts=BLOB"
  28. Database userdb COLUMN_DEF "city=varchar(30)"
  29. Database userdb COLUMN_DEF "company=varchar(64)"
  30. Database userdb COLUMN_DEF "country=varchar(10)"
  31. Database userdb COLUMN_DEF "created=varchar(32)"
  32. Database userdb COLUMN_DEF "credit_limit=varchar(16)"
  33. Database userdb COLUMN_DEF "db_acl=BLOB"
  34. Database userdb COLUMN_DEF "dealer=varchar(32)"
  35. Database userdb COLUMN_DEF "email=varchar(42)"
  36. Database userdb COLUMN_DEF "fax=varchar(30)"
  37. Database userdb COLUMN_DEF "file_acl=BLOB"
  38. Database userdb COLUMN_DEF "fname=varchar(30)"
  39. Database userdb COLUMN_DEF "inactive=varchar(8)"
  40. Database userdb COLUMN_DEF "lname=varchar(30)"
  41. Database userdb COLUMN_DEF "mail_list=text"
  42. Database userdb COLUMN_DEF "mod_time=timestamp"
  43. Database userdb COLUMN_DEF "mv_shipmode=varchar(255)"
  44. Database userdb COLUMN_DEF "owner=varchar(20)"
  45. Database userdb COLUMN_DEF "p_nickname=text"
  46. Database userdb COLUMN_DEF "phone_day=varchar(30)"
  47. Database userdb COLUMN_DEF "phone_night=varchar(30)"
  48. Database userdb COLUMN_DEF "price_level=varchar(30)"
  49. Database userdb COLUMN_DEF "preferences=BLOB"
  50. Database userdb COLUMN_DEF "s_nickname=text"
  51. Database userdb COLUMN_DEF "state=varchar(20)"
  52. Database userdb COLUMN_DEF "updated=varchar(32)"
  53. Database userdb COLUMN_DEF "zip=varchar(10)"
  54. Database userdb PREFER_NULL mod_time
  55. Database userdb INDEX "UNIQUE usernick"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!