[Openupload-svn-update] SF.net SVN: openupload:[55] trunk/sql/mysql/1_structure.sql

[<ts...@us...>]

Revision: 55
          http://openupload.svn.sourceforge.net/openupload/?rev=55&view=rev
Author:   tsdogs
Date:     2008-10-22 18:38:55 +0000 (Wed, 22 Oct 2008)

Log Message:
-----------
fix structure bug

Modified Paths:
--------------
    trunk/sql/mysql/1_structure.sql

Modified: trunk/sql/mysql/1_structure.sql
===================================================================
--- trunk/sql/mysql/1_structure.sql	2008-10-22 18:38:27 UTC (rev 54)
+++ trunk/sql/mysql/1_structure.sql	2008-10-22 18:38:55 UTC (rev 55)
@@ -130,7 +130,7 @@
   `id` int(11) NOT NULL auto_increment,
   `plugin` varchar(100) NOT NULL,
   `group_id` varchar(100) NOT NULL,
-  `option` varchar(100) NOT NULL,
+  `name` varchar(100) NOT NULL,
   `value` text,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
@@ -149,8 +149,8 @@
   `group_id` varchar(50) NOT NULL default 'unregistered',
   `email` varchar(250) NOT NULL,
   `lang` varchar(10) NOT NULL default 'en',
-  `reg_date` datetime NOT NULL default now(),
-  `regid` varchar(50) NOT NULL default 'en',
+  `reg_date` datetime NOT NULL,
+  `regid` varchar(50) NOT NULL default '',
   `active` tinyint(3) unsigned NOT NULL default '1',
   PRIMARY KEY  (`id`),
   UNIQUE KEY `login` (`login`)


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.