onetforums_mysql_5_0_rc1_to_5_0.sql

来自「Onet Forums 是一套基于 FastJsp、FastJdbc 等Java」· SQL 代码 · 共 30 行

/**
  * Database script upgrading from onet forums 5.0RC1 to 5.0
  * MYSQL script
  * Creation Date:2007/1/25
  */
CREATE TABLE onetForumThreadComx (
	threadID BIGINT NOT NULL,
	objectID BIGINT NOT NULL,
	objectType INTEGER NOT NULL,
	comxType INTEGER NOT NULL,
	showValue INTEGER NOT NULL,
	lastOrdered BIGINT NOT NULL,
	CONSTRAINT onet_pk_fotcx PRIMARY KEY(threadID,objectID,objectType,comxType)
);

CREATE TABLE onetLayoutProp (
	objectID BIGINT NOT NULL,
	propName VARCHAR (150) NOT NULL,
	propValue TEXT NOT NULL,
	CONSTRAINT onet_pk_lppr PRIMARY KEY (objectID,propName)
);

DELETE FROM onetProperty WHERE propName LIKE 'advertise%';

DELETE FROM onetStyleProp;
DELETE FROM onetStyle;
DELETE FROM onetSkinProp;
DELETE FROM onetSkin;
DELETE FROM onetLayout;
DELETE FROM onetProperty WHERE propName = 'system.skins.initialized';