Vizster DB schema

Because there were some requests for it (It seems I have at least one reader!), this is the schema I use for the Vizster DB.
Not all fields have to be filled, and there are some fields in there that are never used (I added a id to both tables, which isn’t necessary for the program). I think the only important fields are the uid1 and uid2 in the graph table, and the uid and name table in the profiles table. The other fields have to be there tho.
The picture isn’t taken from the photourl field, but hardcoded in the application to a different location (on the hard drive), based on the users uid.

CREATE TABLE `graph` (
  `id` int(11) NOT NULL auto_increment,
  `uid1` int(10) unsigned NOT NULL,
  `uid2` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
)
-- Table structure for table `profiles`

CREATE TABLE `profiles` (
  `id` int(11) NOT NULL auto_increment,
  `uid` tinytext NOT NULL,
  `name` tinytext NOT NULL,
  `nfriends` int(11) NOT NULL,
  `location` tinytext NOT NULL,
  `age` tinytext NOT NULL,
  `gender` tinytext NOT NULL,
  `status` tinytext NOT NULL,
  `interested_in` tinytext NOT NULL,
  `preference` tinytext NOT NULL,
  `hometown` tinytext NOT NULL,
  `occupation` tinytext NOT NULL,
  `interests` tinytext NOT NULL,
  `music` tinytext NOT NULL,
  `books` tinytext NOT NULL,
  `tvshows` tinytext NOT NULL,
  `movies` tinytext NOT NULL,
  `membersince` tinytext NOT NULL,
  `lastlogin` tinytext NOT NULL,
  `lastmod` tinytext NOT NULL,
  `about` tinytext NOT NULL,
  `want_to_meet` tinytext NOT NULL,
  `photourl` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
)