|
What this is
Other links
The source code-- $Header: /cvsroot/mvnforum/mvnforum/sql/upgrade/1_0_0_rc3_to_1_0_0_rc4/mvnForum_update_hsqldb_1.7.2.sql,v 1.7 2005/01/27 09:27:34 minhnn Exp $ -- $Author: minhnn $ -- $Revision: 1.7 $ -- $Date: 2005/01/27 09:27:34 $ -- -- This script is used to upgrade mvnForum from RC2/RC3 to RC4 -- This script creates 3 new table : mvnforumMessage -- mvnforumMessageStatistics -- mvnforumPmAttachment -- mvnforumPmAttachMessage -- -- Database: hsqldb 1.7.2 -- drop table mvnforumMessage; -- drop table mvnforumMessageStatistics; -- drop table mvnforumPmAttachment; -- drop table mvnforumPmAttachMessage; CREATE TABLE mvnforumMessage ( MessageID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1), FolderName VARCHAR(30) not null, MemberID INT not null, MessageSenderID INT not null, MessageSenderName VARCHAR(30) not null, MessageToList VARCHAR(250) not null, MessageCcList VARCHAR(250), MessageBccList VARCHAR(250), MessageTopic VARCHAR(250) not null, MessageBody LONGVARCHAR not null, MessageType INT not null, MessageOption INT not null, MessageStatus INT not null, MessageReadStatus INT not null, MessageNotify INT not null, MessageIcon VARCHAR(10) not null, MessageAttachCount INT not null, MessageIP VARCHAR(20) not null, MessageCreationDate TIMESTAMP not null ); CREATE INDEX Message_1_idx on mvnforumMessage ( FolderName, MemberID ); CREATE INDEX Message_2_idx on mvnforumMessage ( MessageSenderID ); CREATE TABLE mvnforumMessageStatistics ( FromID INT not null, ToID INT not null, MessageCreationDate TIMESTAMP not null, MessageAttachCount INT not null, MessageType INT not null, MessageOption INT not null, MessageStatus INT not null ); CREATE INDEX MessageStatistics_1_idx on mvnforumMessageStatistics ( FromID ); CREATE INDEX MessageStatistics_2_idx on mvnforumMessageStatistics ( ToID ); CREATE TABLE mvnforumPmAttachment ( PmAttachID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1), MemberID INT not null, PmAttachFilename VARCHAR(250) not null, PmAttachFileSize INT not null, PmAttachMimeType VARCHAR(70) not null, PmAttachDesc LONGVARCHAR not null, PmAttachCreationIP VARCHAR(20) not null, PmAttachCreationDate TIMESTAMP not null, PmAttachModifiedDate TIMESTAMP not null, PmAttachDownloadCount INT not null, PmAttachOption INT not null, PmAttachStatus INT not null ); CREATE INDEX PmAttachment_1_idx on mvnforumPmAttachment ( MemberID ); CREATE TABLE mvnforumPmAttachMessage ( MessageID INT not null, PmAttachID INT not null, RelationType INT not null, RelationOption INT not null, RelationStatus INT not null, primary key (MessageID, PmAttachID) ); UPDATE mvnforumMessageFolder SET FolderOrder = 2 WHERE FolderName = 'Sent'; ALTER TABLE mvnforumMessageFolder ADD COLUMN FolderStatus INT DEFAULT 0 NOT NULL BEFORE FolderCreationDate; ALTER TABLE mvnforumMessageFolder ADD COLUMN FolderOption INT DEFAULT 0 NOT NULL BEFORE FolderCreationDate; ALTER TABLE mvnforumMessageFolder ADD COLUMN FolderType INT DEFAULT 0 NOT NULL BEFORE FolderCreationDate; ALTER TABLE mvnforumThread ADD COLUMN ThreadAttachCount INT DEFAULT 0 NOT NULL ; -- ALTER TABLE mvnforumAttachment CHANGE AttachDesc AttachDesc LONGVARCHAR NOT NULL ; -- ALTER TABLE mvnforumMember CHANGE MemberPassword MemberPassword VARCHAR(200) NOT NULL ; ALTER TABLE mvnforumMember ADD COLUMN MemberExpireDate DATETIME BEFORE MemberLastLogon ; UPDATE mvnforumMember SET MemberExpireDate = MemberCreationDate ; -- ALTER TABLE mvnforumMember ALTER COLUMN MemberExpireDate SET NOT NULL ; |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.