contact_info
Contact information for the individual users.
It's split out from the main 'users' table to keep that schema simpler.
CREATE TABLE contact_info ( identifier INTEGER NOT NULL PRIMARY KEY, address1 VARCHAR(100), address2 VARCHAR(100), city VARCHAR(100), zipcode VARCHAR(10), state INTEGER REFERENCES state(identifier), country INTEGER REFERENCES country(identifier), phone VARCHAR(40), email VARCHAR(150), url VARCHAR(150) );
None.
Version 2.5
Still in use
= Version 2.5 =
CREATE TABLE contact_info ( identifier INTEGER NOT NULL PRIMARY KEY, address1 VARCHAR(100), address2 VARCHAR(100), city VARCHAR(100), zipcode VARCHAR(10), state INTEGER REFERENCES state(identifier), country INTEGER REFERENCES country(identifier), phone VARCHAR(40), email VARCHAR(150), url VARCHAR(150) );
= Version 2.5 =
INSERT INTO contact_info VALUES (1, '', '', '', '', NULL, NULL, '', '', '');