creation.sql

相当板扎,采用贝叶斯公式的垃圾邮件过滤程序

/** 
*  @author  : Shefali Bansal
*  @version : 1.0 
* 
*  Name of the Application         :  creation.sql
*  Creation/Modification History   :  02-Jan-2004
* 
*  Overview of  Package/Sample     : This SQL creates the required objects for the JSP Multimedia Tag 
*  Application. Please execute this script under "SCOTT" schema
*    
*    
**/

DROP TABLE otn_webinar_events;
DROP TABLE otn_webinar_categories;
DROP SEQUENCE events_sequence;

REM ********************************************************************
PROMPT Creating the Oracle interMedia table 'otn_webinar_categories' that 
PROMPT will hold the WEBINAR categories  media content.
REM ********************************************************************

CREATE TABLE OTN_WEBINAR_CATEGORIES (
CATEGORY_ID VARCHAR2(40) PRIMARY KEY,
DESCRIPTION VARCHAR2(400) NOT NULL,
SHORT_DESC  VARCHAR2(60),
IMAGE       ORDSYS.ORDIMAGE );

REM ********************************************************************
PROMPT Creating the Oracle interMedia table 'otn_webinar_events' that 
PROMPT will hold the WEBINAR events content.
REM ********************************************************************

CREATE TABLE OTN_WEBINAR_EVENTS (
EVENT_ID    NUMBER(10) PRIMARY KEY,
DESCRIPTION VARCHAR2(400),
IMAGE       ORDSYS.ORDIMAGE,
AUDIO       ORDSYS.ORDAUDIO,
VIDEO       ORDSYS.ORDVIDEO,
CATEGORY_ID REFERENCES OTN_WEBINAR_CATEGORIES(CATEGORY_ID));

REM ********************************************************************
PROMPT Creating the 'events_sequence' database sequence that will 
PROMPT generate the unique key for 'event_id' field in 'otn_webinar_events' table
REM ********************************************************************

CREATE SEQUENCE events_sequence;

REM ********************************************************************
PROMPT JSP Multimedia Application's objects created !!!
REM ********************************************************************