update-1.0.0.038.sql

来自「jGossip是一个简单而功能强大的Java论坛软件（消息板）」· SQL 代码 · 共 21 行

CREATE TABLE JRF_KEY_KEEPER (
    table_name varchar (255) default NULL,
 	next_key INTEGER NOT NULL,
	constraint xp_last_inserted_id 
	PRIMARY KEY ( table_name,  next_key) )type=innodb ;

INSERT INTO jrf_constants values('enableEmailConfiramtion','N');
INSERT INTO jrf_constants values('periodForConfirmation','48');
INSERT INTO jrf_constants values('user.INVADER1','1');

CREATE TABLE jrf_pending_user (
    user_name varchar(32) NOT NULL,
    user_mail varchar(64) NOT NULL,
    confirm_code varchar(128) NOT NULL,
    intime DATETIME NOT NULL,
    PRIMARY KEY  (user_name,confirm_code),
    index jrf_pending_user_idx (user_name,confirm_code))type=innodb;
  
commit;