databasetables

CREATE TABLE  users` (
  `uid` int(10) unsigned NOT NULL default '0' COMMENT 'Primary Key: Unique user ID.',
  `name` varchar(60) NOT NULL default '' COMMENT 'Unique user name.',
  `pass` varchar(128) NOT NULL default '' COMMENT 'User’s password (hashed).',
  `mail` varchar(254) default '' COMMENT 'User’s e-mail address.',
  `theme` varchar(255) NOT NULL default '' COMMENT 'User’s default theme.',
  `signature` varchar(255) NOT NULL default '' COMMENT 'User’s signature.',
  `signature_format` varchar(255) default NULL COMMENT 'The filter_format.format of the signature.',
  `created` int(11) NOT NULL default '0' COMMENT 'Timestamp for when user was created.',
  `access` int(11) NOT NULL default '0' COMMENT 'Timestamp for previous time user accessed the site.',
  `login` int(11) NOT NULL default '0' COMMENT 'Timestamp for user’s last login.',
  `status` tinyint(4) NOT NULL default '0' COMMENT 'Whether the user is active(1) or blocked(0).',
  `timezone` varchar(32) default NULL COMMENT 'User’s time zone.',
  `language` varchar(12) NOT NULL default '' COMMENT 'User’s default language.',
  `picture` int(11) NOT NULL default '0' COMMENT 'Foreign key: file_managed.fid of user’s picture.',
  `init` varchar(254) default '' COMMENT 'E-mail address used for initial account creation.',
  `data` longblob COMMENT 'A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future...',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `name` (`name`),
  KEY `access` (`access`),
  KEY `created` (`created`),
  KEY `mail` (`mail`)
)

CREATE TABLE  `profile` (
  `pid` int(11) NOT NULL auto_increment COMMENT 'Primary Key: Unique profile item ID.',
  `type` varchar(32) NOT NULL default '' COMMENT 'The profile_type.type of this profile.',
  `uid` int(10) unsigned default NULL COMMENT 'The users.uid of the associated user.',
  `label` varchar(255) NOT NULL default '' COMMENT 'A human-readable label for this profile.',
  `created` int(11) default NULL COMMENT 'The Unix timestamp when the profile was created.',
  `changed` int(11) default NULL COMMENT 'The Unix timestamp when the profile was most recently saved.',
  PRIMARY KEY  (`pid`),
  KEY `uid` (`uid`)
)

CREATE TABLE  `field_revision_field_city` (
  `entity_type` varchar(128) NOT NULL default '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL default '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL default '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL default '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_city_value` varchar(255) default NULL,
  `field_city_format` varchar(255) default NULL,
  PRIMARY KEY  (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_city_format` (`field_city_format`)
)

CREATE TABLE  `options` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `key` varchar(45) NOT NULL,
  `index` varchar(45) NOT NULL default '',
  `value` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
)