Minahito
minah****@users*****
2006年 4月 27日 (木) 19:27:50 JST
Index: xoops2jp/html/modules/user/sql/mysql.sql diff -u /dev/null xoops2jp/html/modules/user/sql/mysql.sql:1.1.2.3 --- /dev/null Thu Apr 27 19:27:50 2006 +++ xoops2jp/html/modules/user/sql/mysql.sql Thu Apr 27 19:27:50 2006 @@ -0,0 +1,17 @@ +CREATE TABLE user_mailjob ( + mailjob_id int(10) NOT NULL auto_increment, + title varchar(255) NOT NULL default '', + body text NOT NULL, + from_name varchar(255) default NULL, + from_email varchar(255) default NULL, + is_pm tinyint(1) NOT NULL default '0', + is_mail tinyint(1) NOT NULL default '0', + create_unixtime int(10) NOT NULL default '0', + PRIMARY KEY (mailjob_id) +) TYPE=MyISAM; + +CREATE TABLE user_mailjob_link ( + mailjob_id int(10) NOT NULL default '0', + uid mediumint(8) NOT NULL default '0', + PRIMARY KEY (mailjob_id, uid) +) TYPE=MyISAM;
