1 CREATE SEQUENCE Classes_seq;
4 CONSTRAINT Classes_key PRIMARY KEY,
5 Name varchar2(255) DEFAULT '',
6 Description varchar2(255) DEFAULT '',
7 SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
8 Disabled NUMBER(11,0) DEFAULT 0 NOT NULL,
9 Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
11 LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
13 HotList NUMBER(11,0) DEFAULT 0 NOT NULL
16 CREATE SEQUENCE Articles_seq;
17 CREATE TABLE Articles (
19 CONSTRAINT Articles_key PRIMARY KEY,
20 Name varchar2(255) DEFAULT '',
21 Summary varchar2(255) DEFAULT '',
22 SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
23 Class NUMBER(11,0) DEFAULT 0 NOT NULL,
24 Parent NUMBER(11,0) DEFAULT 0 NOT NULL,
26 Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
28 LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
33 CREATE SEQUENCE Topics_seq;
36 CONSTRAINT Topics_key PRIMARY KEY,
37 Parent NUMBER(11,0) DEFAULT 0 NOT NULL,
38 Name varchar2(255) DEFAULT '',
39 Description varchar2(255) DEFAULT '',
40 ObjectType varchar2(64) DEFAULT '' NOT NULL,
41 ObjectId NUMBER(11,0) NOT NULL
45 CREATE SEQUENCE ObjectTopics_seq;
46 CREATE TABLE ObjectTopics (
48 CONSTRAINT ObjectTopics_key PRIMARY KEY,
49 Topic NUMBER(11,0) NOT NULL,
50 ObjectType varchar2(64) DEFAULT '' NOT NULL,
51 ObjectId NUMBER(11,0) NOT NULL
54 CREATE SEQUENCE ObjectClasses_seq;
55 CREATE TABLE ObjectClasses (
57 CONSTRAINT ObjectClasses_key PRIMARY KEY,
58 Class NUMBER(11,0) NOT NULL,
59 ObjectType varchar2(255) DEFAULT '' NOT NULL,
60 ObjectId NUMBER(11,0) NOT NULL,
61 Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
63 LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,