1 files changed, 36 insertions, 2 deletions
diff --git a/database/database.mysql b/database/database.mysql
index e5cdab7a3..10f3ff9dc 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -282,13 +282,13 @@ CREATE TABLE node (
   uid int(10) NOT NULL default '0',
   status int(4) NOT NULL default '1',
   created int(11) NOT NULL default '0',
+  changed int(11) NOT NULL default '0',
   comment int(2) NOT NULL default '0',
   promote int(2) NOT NULL default '0',
   moderate int(2) NOT NULL default '0',
   users longtext NOT NULL,
   teaser longtext NOT NULL,
   body longtext NOT NULL,
-  changed int(11) NOT NULL default '0',
   revisions longtext NOT NULL,
   static int(2) NOT NULL default '0',
   PRIMARY KEY  (nid),
@@ -313,6 +313,38 @@ CREATE TABLE page (
 ) TYPE=MyISAM;
 
 --
+-- Table structure for table 'profile_fields'
+--
+
+CREATE TABLE profile_fields (
+  fid int(10) NOT NULL auto_increment,
+  title varchar(255) default NULL,
+  name varchar(128) default NULL,
+  explanation TEXT default NULL,
+  category varchar(255) default NULL,
+  type varchar(128) default NULL,
+  weight tinyint(1) DEFAULT '0' NOT NULL,
+  overview tinyint(1) DEFAULT '0' NOT NULL,
+  options text,
+  KEY category (category),
+  UNIQUE KEY name (name),
+  PRIMARY KEY (fid)
+);
+
+--
+-- Table structure for table 'profile_values'
+--
+
+CREATE TABLE profile_values (
+  fid int(11) unsigned default '0',
+  uid int(11) unsigned default '0',
+  value text,
+  KEY uid (uid),
+  KEY fid (fid)
+);
+
+
+--
 -- Table structure for table 'url_alias'
 --
 
@@ -514,10 +546,12 @@ CREATE TABLE users (
   threshold tinyint(1) default '0',
   theme varchar(255) NOT NULL default '',
   signature varchar(255) NOT NULL default '',
-  timestamp int(11) NOT NULL default '0',
+  created int(11) NOT NULL default '0',
+  changed int(11) NOT NULL default '0',
   status tinyint(4) NOT NULL default '0',
   timezone varchar(8) default NULL,
   language char(2) NOT NULL default '',
+  picture varchar(255) NOT NULL DEFAULT '',
   init varchar(64) default '',
   data longtext,
   rid int(10) unsigned NOT NULL default '0',