[geeklog-cvs] Geeklog-2/sql create.sql,1.1.1.1,1.2

[tony at iowaoutdoors.org]

Update of /var/cvs/Geeklog-2/sql
In directory www:/tmp/cvs-serv31161

Modified Files:
	create.sql 
Log Message:
Minor changes to gl2_user.
----------------------------------------------------------------------


Index: create.sql
===================================================================
RCS file: /var/cvs/Geeklog-2/sql/create.sql,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** create.sql	17 Dec 2004 23:35:47 -0000	1.1.1.1
--- create.sql	18 Dec 2004 06:57:57 -0000	1.2
***************
*** 56,62 ****
    user_id int unsigned NOT NULL auto_increment,
    registration_date datetime NOT NULL,
    profile_views mediumint unsigned NOT NULL DEFAULT 0,
    items_per_page tinyint unsigned NOT NULL DEFAULT 10,
!   language_id int unsigned NOT NULL,
    timezone_id mediumint unsigned NOT NULL,
    user_name varchar(50) NOT NULL,
--- 56,63 ----
    user_id int unsigned NOT NULL auto_increment,
    registration_date datetime NOT NULL,
+   theme varchar(50) NOT NULL DEFAULT 'default',
    profile_views mediumint unsigned NOT NULL DEFAULT 0,
    items_per_page tinyint unsigned NOT NULL DEFAULT 10,
!   locale_id int unsigned NOT NULL,
    timezone_id mediumint unsigned NOT NULL,
    user_name varchar(50) NOT NULL,
***************
*** 86,90 ****
    INDEX (date_format_id),
    FOREIGN KEY (date_format_id) REFERENCES gl2_list_of_values(lov_id),
!   INDEX (timezone_id) REFERENCES gl2_timezone(timezone_id)
  ) TYPE=INNODB;
  
--- 87,94 ----
    INDEX (date_format_id),
    FOREIGN KEY (date_format_id) REFERENCES gl2_list_of_values(lov_id),
!   INDEX (timezone_id),
!   FOREIGN KEY (timezone_id) REFERENCES gl2_timezone(timezone_id),
!   INDEX (locale_id),
!   FOREIGN KEY (locale_id) REFERENcES gl2_list_of_values(lov_id),
  ) TYPE=INNODB;