|
What this is
Other links
The source code-- This script is used to upgrade mvnForum from beta3 to rc1 -- This sql script creates 2 new table : mvnforumWatch and mvnforumAttachment -- -- Database: JDBC -- drop table mvnforumWatch; -- drop table mvnforumAttachment; create table mvnforumWatch ( WatchID INT not null AUTO_INCREMENT, MemberID INT not null, CategoryID INT not null, ForumID INT not null, ThreadID INT not null, WatchType INT not null, WatchOption INT not null, WatchStatus INT not null, WatchCreationDate TIMESTAMP not null, WatchLastSentDate TIMESTAMP not null, WatchEndDate TIMESTAMP not null, primary key (WatchID), unique (MemberID, CategoryID, ForumID, ThreadID) ); create index Watch_MemberID_idx on mvnforumWatch ( MemberID ); create index Watch_CategoryID_idx on mvnforumWatch ( CategoryID ); create index Watch_ForumID_idx on mvnforumWatch ( ForumID ); create index Watch_ThreadID_idx on mvnforumWatch ( ThreadID ); create table mvnforumAttachment ( AttachID INT not null AUTO_INCREMENT, PostID INT not null, MemberID INT not null, AttachFilename VARCHAR(250) not null, AttachFileSize INT not null, AttachMimeType VARCHAR(70) not null, AttachDesc VARCHAR(250) not null, AttachCreationIP VARCHAR(20) not null, AttachCreationDate TIMESTAMP not null, AttachModifiedDate TIMESTAMP not null, AttachDownloadCount INT not null, AttachOption INT not null, AttachStatus INT not null, primary key (AttachID) ); create index Attachment_PostID_idx on mvnforumAttachment ( PostID ); create index Attachment_MemberID_idx on mvnforumAttachment ( MemberID ); |
... 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.