Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UUID CHAR(36) CHARACTER SET ascii -- or pack into BINARY(16)
- country_code CHAR(2) CHARACTER SET ascii
- ip_address CHAR(39) CHARACTER SET ascii -- or pack into BINARY(16)
- phone VARCHAR(20) CHARACTER SET ascii -- probably enough to handle extension
- postal_code VARCHAR(20) CHARACTER SET ascii -- (not 'zip_code') (don't know the max
- city VARCHAR(100) -- This Russian town needs 91:
- Poselok Uchebnogo Khozyaystva Srednego Professionalno-Tekhnicheskoye Uchilishche Nomer Odin
- country VARCHAR(50) -- probably enough
- name VARCHAR(64) -- probably adequate; more than some government agencies allow
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement