|
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_postgresql.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: postgreSQL -- drop table mvnforumMessage; -- drop table mvnforumMessageStatistics; -- drop table mvnforumPmAttachment; -- drop table mvnforumPmAttachMessage; -- -- drop sequences -- -- drop sequence mvnforumMessage_seq; -- drop sequence mvnforumPmAttachment_seq; -- -- create sequences -- create sequence mvnforumMessage_seq; create sequence mvnforumPmAttachment_seq; CREATE TABLE mvnforumMessage ( MessageID INT not null DEFAULT nextval('mvnforumMessage_seq'), 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 TEXT 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, primary key (MessageID) ); 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 not null DEFAULT nextval('mvnforumPmAttachment_seq'), MemberID INT not null, PmAttachFilename VARCHAR(250) not null, PmAttachFileSize INT not null, PmAttachMimeType VARCHAR(70) not null, PmAttachDesc TEXT 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, primary key (PmAttachID) ); 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 FolderStatus INT ; ALTER TABLE mvnforumMessageFolder ALTER FolderStatus SET DEFAULT 0 ; UPDATE mvnforumMessageFolder SET FolderStatus = 0 ; ALTER TABLE mvnforumMessageFolder ALTER FolderStatus SET NOT NULL ; ALTER TABLE mvnforumMessageFolder ADD FolderOption INT ; ALTER TABLE mvnforumMessageFolder ALTER FolderOption SET DEFAULT 0 ; UPDATE mvnforumMessageFolder SET FolderOption = 0 ; ALTER TABLE mvnforumMessageFolder ALTER FolderOption SET NOT NULL ; ALTER TABLE mvnforumMessageFolder ADD FolderType INT ; ALTER TABLE mvnforumMessageFolder ALTER FolderType SET DEFAULT 0 ; UPDATE mvnforumMessageFolder SET FolderType = 0 ; ALTER TABLE mvnforumMessageFolder ALTER FolderType SET NOT NULL ; ALTER TABLE mvnforumThread ADD ThreadAttachCount INT ; ALTER TABLE mvnforumThread ALTER ThreadAttachCount SET DEFAULT 0 ; UPDATE mvnforumThread SET ThreadAttachCount = 0 ; ALTER TABLE mvnforumThread ALTER ThreadAttachCount SET NOT NULL ; --ALTER TABLE mvnforumAttachment CHANGE AttachDesc AttachDesc TEXT NOT NULL ; --ALTER TABLE mvnforumMember CHANGE MemberPassword MemberPassword VARCHAR(200) NOT NULL ; ALTER TABLE mvnforumMember ADD MemberExpireDate TIMESTAMP ; UPDATE mvnforumMember SET MemberExpireDate = MemberCreationDate ; ALTER TABLE mvnforumMember ALTER 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.