Minahito
minah****@users*****
2006年 1月 10日 (火) 08:33:43 JST
Index: xoops2jp/html/modules/user/sql/mysql.sql diff -u /dev/null xoops2jp/html/modules/user/sql/mysql.sql:1.1.2.1 --- /dev/null Tue Jan 10 08:33:43 2006 +++ xoops2jp/html/modules/user/sql/mysql.sql Tue Jan 10 08:33:42 2006 @@ -0,0 +1,23 @@ +CREATE TABLE user_mailjob ( + `id` int(10) NOT NULL auto_increment, + `lastlogin` int(10) default NULL, + `lastlogin_flag` tinyint(1) NOT NULL default '0', + `mailok` tinyint(1) NOT NULL default '0', + `activeuser` tinyint(1) NOT NULL default '0', + `registdate` int(10) default '0', + `registdate_flag` tinyint(1) NOT NULL default '0', + `sender` varchar(255) default NULL, + `email` varchar(255) default NULL, + `subject` varchar(255) NOT NULL default '', + `body` text NOT NULL, + `by_pm` tinyint(1) NOT NULL default '0', + `by_email` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`id`) +) TYPE=MyISAM; + +CREATE TABLE user_mailjob_link ( + `lid` int(10) NOT NULL auto_increment, + `id` int(10) NOT NULL default '0', + `uid` mediumint(8) NOT NULL default '0', + PRIMARY KEY (`lid`) +) TYPE=MyISAM;
