update-1.0.0.037.sql

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

alter table jrf_forum modify column forumid int(12) NOT NULL;
alter table jrf_group modify column groupid int(12) NOT NULL;
alter table jrf_message modify column id int(12) NOT NULL;
alter table jrf_thread modify column threadid int(12) NOT NULL;
alter table jrf_user modify column id int(12) NOT NULL;
alter table jrf_whois modify column id int(12) NOT NULL;
alter table jrf_skins modify column skinid int(12) NOT NULL;

alter table jrf_forum type=innodb;
alter table jrf_message type=innodb;
alter table jrf_subscribe type=innodb;
alter table jrf_thread type=innodb;
alter table jrf_mod type=innodb;

create index forum_group on jrf_forum(groupid);
create index message_thread on jrf_message(threadid);
create index thread on jrf_subscribe(threadid);
create index thread_forum on jrf_thread(forumid);
create index mod_forum on jrf_mod(forum_id);

alter table jrf_forum add constraint fk_forum_group foreign key (groupid) references jrf_group(groupid) on delete set null;
alter table jrf_message add constraint fk_message_thread foreign key (threadid) references jrf_thread(threadid) on delete set null;
alter table jrf_subscribe add constraint fk_thread foreign key(threadid) references jrf_thread(threadid) on delete cascade;
alter table jrf_thread add constraint fk_thread_forum foreign key(forumid) references jrf_forum(forumid) on delete set null;
alter table jrf_mod add constraint fk_mod_forum foreign key(forum_id) references jrf_forum(forumid) on delete set null;

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 ;

select @INIT_ID:=(max(forumid)+10) from JRF_FORUM;
INSERT INTO JRF_KEY_KEEPER VALUES ('jrf_forum', @INIT_ID);
select @INIT_ID:=(max(groupid)+10) from JRF_GROUP;
INSERT INTO JRF_KEY_KEEPER VALUES ('jrf_group', @INIT_ID);
select @INIT_ID:=(max(id)+10) from JRF_MESSAGE;
INSERT INTO JRF_KEY_KEEPER VALUES ('jrf_message', @INIT_ID);
select @INIT_ID:=(max(threadid)+10) from JRF_THREAD;
INSERT INTO JRF_KEY_KEEPER VALUES ('jrf_thread',  @INIT_ID);
delete from JRF_WHOIS;
INSERT INTO JRF_KEY_KEEPER VALUES ('jrf_whois',  10);
select @INIT_ID:=(max(id)+10) from JRF_USER;
INSERT INTO JRF_KEY_KEEPER VALUES ('jrf_user',  @INIT_ID);

commit;

INSERT INTO jrf_constants values('enableEmailConfiramtion','N');
INSERT INTO jrf_constants values('periodForConfirmation','48');