1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
CREATE SEQUENCE FM_Classes_seq;
CREATE TABLE FM_Classes (
id NUMBER(11,0)
CONSTRAINT FM_Classes_key PRIMARY KEY,
Name varchar2(255) DEFAULT '' NOT NULL,
Description varchar2(255) DEFAULT '',
SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
Disabled NUMBER(11,0) DEFAULT 0 NOT NULL,
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE
);
CREATE SEQUENCE FM_ClassCustomFields_seq;
CREATE TABLE FM_ClassCustomFields (
id NUMBER(11,0)
CONSTRAINT FM_ClassCustomFields_key PRIMARY KEY,
Class NUMBER(11,0) NOT NULL,
CustomField NUMBER(11,0) NOT NULL,
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE
);
CREATE SEQUENCE FM_CustomFields_seq;
CREATE TABLE FM_CustomFields (
id NUMBER(11,0)
CONSTRAINT FM_CustomFields_key PRIMARY KEY,
Name varchar2(200) DEFAULT '' NOT NULL,
Type varchar2(200) DEFAULT '' NOT NULL,
Description varchar2(200) DEFAULT '' NOT NULL,
SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE
);
CREATE SEQUENCE FM_Articles_seq;
CREATE TABLE FM_Articles (
id NUMBER(11,0)
CONSTRAINT FM_Articles_key PRIMARY KEY,
Name varchar2(255) DEFAULT '' NOT NULL,
Summary varchar2(255) DEFAULT '' NOT NULL,
SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
Class NUMBER(11,0) DEFAULT 0 NOT NULL,
Parent NUMBER(11,0) DEFAULT 0 NOT NULL,
URI varchar2(255),
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE
);
CREATE SEQUENCE FM_CustomFieldValues_seq;
CREATE TABLE FM_CustomFieldValues (
id NUMBER(11,0)
CONSTRAINT FM_CustomFieldValues_key PRIMARY KEY,
CustomField NUMBER(11,0) NOT NULL,
Name varchar2(255) DEFAULT '' NOT NULL,
Description varchar2(255) DEFAULT '',
SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE
);
CREATE SEQUENCE FM_ArticleCFValues_seq;
CREATE TABLE FM_ArticleCFValues (
id NUMBER(11,0)
CONSTRAINT FM_ArticleCFValues_key PRIMARY KEY,
Article NUMBER(11,0) NOT NULL,
CustomField NUMBER(11,0) NOT NULL,
Content CLOB,
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE
);
CREATE SEQUENCE FM_Transactions_seq;
CREATE TABLE FM_Transactions (
id NUMBER(11,0)
CONSTRAINT FM_Transactions_key PRIMARY KEY,
Article NUMBER(11,0) DEFAULT 0 NOT NULL,
ChangeLog CLOB DEFAULT EMPTY_CLOB(),
Type varchar2(64) DEFAULT '' NOT NULL,
Field varchar2(64) DEFAULT '' NOT NULL,
OldContent CLOB DEFAULT EMPTY_CLOB() NOT NULL,
NewContent CLOB DEFAULT EMPTY_CLOB() NOT NULL,
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE
);
|
