home | career | drupal | java | mac | mysql | perl | scala | uml | unix  

What this is

This file is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" TM.

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: PostgreSql

-- drop table mvnforumWatch;
-- drop table mvnforumAttachment;

-- drop sequences
-- drop sequence mvnforumWatch_seq;
-- drop sequence mvnforumAttachment_seq;

-- create sequences
create sequence mvnforumWatch_seq;
create sequence mvnforumAttachment_seq;

create table mvnforumWatch
   WatchID                        INT                            not null DEFAULT nextval('mvnforumWatch_seq'),
   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

create index Watch_CategoryID_idx on mvnforumWatch

create index Watch_ForumID_idx on mvnforumWatch

create index Watch_ThreadID_idx on mvnforumWatch

create table mvnforumAttachment
   AttachID                       INT                            not null DEFAULT nextval('mvnforumAttachment_seq'),
   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

create index Attachment_MemberID_idx on mvnforumAttachment

my book on functional programming


new blog posts


Copyright 1998-2019 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.