Advertisement
Guest User

Untitled

a guest
Jul 25th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. UUID CHAR(36) CHARACTER SET ascii -- or pack into BINARY(16)
  2. country_code CHAR(2) CHARACTER SET ascii
  3. ip_address CHAR(39) CHARACTER SET ascii -- or pack into BINARY(16)
  4. phone VARCHAR(20) CHARACTER SET ascii -- probably enough to handle extension
  5. postal_code VARCHAR(20) CHARACTER SET ascii -- (not 'zip_code') (don't know the max
  6.  
  7. city VARCHAR(100) -- This Russian town needs 91:
  8. Poselok Uchebnogo Khozyaystva Srednego Professionalno-Tekhnicheskoye Uchilishche Nomer Odin
  9. country VARCHAR(50) -- probably enough
  10. name VARCHAR(64) -- probably adequate; more than some government agencies allow
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement