NobuNobu
nobun****@users*****
2007年 4月 30日 (月) 16:39:36 JST
Index: xoops2jp/html/modules/user/sql/mysql.sql
diff -u /dev/null xoops2jp/html/modules/user/sql/mysql.sql:1.1.4.1
--- /dev/null Mon Apr 30 16:39:36 2007
+++ xoops2jp/html/modules/user/sql/mysql.sql Mon Apr 30 16:39:36 2007
@@ -0,0 +1,19 @@
+CREATE TABLE {prefix}_{dirname}_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 {prefix}_{dirname}_mailjob_link (
+ mailjob_id int(10) NOT NULL default '0',
+ uid mediumint(8) NOT NULL default '0',
+ retry tinyint(3) NOT NULL default '0',
+ message varchar(255) default NULL,
+ PRIMARY KEY (mailjob_id, uid)
+) TYPE=MyISAM;