update-1.0.0.026.sql

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

CREATE TABLE jrf_skin_params (
  	skinid int(12) NOT NULL ,
  	param_name varchar(128) NOT NULL,
 	param_value varchar(255) NOT NULL ,
  	PRIMARY KEY (skinid, param_name));

CREATE TABLE jrf_skins (
  	skinid int(12) auto_increment NOT NULL ,
  	skin_name varchar(128) NOT NULL,
  	PRIMARY KEY  (skinid));
  	
INSERT INTO jrf_skins values(1,'default');
INSERT INTO jrf_skin_params values(1,'bgColor','FFFFFF');
INSERT INTO jrf_skin_params values(1,'textColor','000000');
INSERT INTO jrf_skin_params values(1,'clmnTitleColor','999999');
INSERT INTO jrf_skin_params values(1,'rowBgDrk','EEEEEE');
INSERT INTO jrf_skin_params values(1,'rowBgLght','FFFFFF');
INSERT INTO jrf_skin_params values(1,'border2','FF8000');
INSERT INTO jrf_skin_params values(1,'border1','AAA9A9');