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
|
CREATE TABLE FM_Classes (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(255) NOT NULL DEFAULT '',
Description varchar(255) NOT NULL DEFAULT '',
SortOrder integer NOT NULL DEFAULT 0,
Disabled int(2) not null default '0',
Creator integer NOT NULL DEFAULT 0,
Created DATETIME NULL,
LastUpdatedBy integer NOT NULL DEFAULT 0,
LastUpdated DATETIME NULL,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE FM_ClassCustomFields (
id INTEGER NOT NULL AUTO_INCREMENT,
Class integer not NULL,
CustomField integer not NULL,
Creator integer NOT NULL DEFAULT 0,
Created DATETIME NULL,
SortOrder int(2) not null default '0',
LastUpdatedBy integer NOT NULL DEFAULT 0,
LastUpdated DATETIME NULL,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE FM_CustomFields (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(200) NOT NULL DEFAULT '',
Type varchar(200) NOT NULL DEFAULT '',
Description varchar(200) NOT NULL DEFAULT '',
SortOrder integer NOT NULL DEFAULT 0,
Creator integer NOT NULL DEFAULT 0,
Created DATETIME NULL,
LastUpdatedBy integer NOT NULL DEFAULT 0,
LastUpdated DATETIME NULL,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE FM_Articles (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(255) NOT NULL DEFAULT '',
Summary varchar(255) NOT NULL DEFAULT '',
SortOrder integer NOT NULL DEFAULT 0,
Class integer NOT NULL DEFAULT 0,
Parent integer NOT NULL DEFAULT 0,
URI varchar(255),
Creator integer NOT NULL DEFAULT 0,
Created DATETIME NULL,
LastUpdatedBy integer NOT NULL DEFAULT 0,
LastUpdated DATETIME NULL,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE FM_CustomFieldValues (
id INTEGER NOT NULL AUTO_INCREMENT,
CustomField int NOT NULL,
Name varchar(255) NOT NULL DEFAULT '',
Description varchar(255) NOT NULL DEFAULT '',
SortOrder integer NOT NULL DEFAULT 0,
Creator integer NOT NULL DEFAULT 0,
Created DATETIME NULL,
LastUpdatedBy integer NOT NULL DEFAULT 0,
LastUpdated DATETIME NULL,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE FM_ArticleCFValues (
id INTEGER NOT NULL AUTO_INCREMENT,
Article int NOT NULL,
CustomField int NOT NULL,
Content text,
Creator integer NOT NULL DEFAULT 0,
Created DATETIME NULL,
LastUpdatedBy integer NOT NULL DEFAULT 0,
LastUpdated DATETIME NULL,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE FM_Transactions (
id INTEGER NOT NULL AUTO_INCREMENT,
Article integer NOT NULL DEFAULT 0,
ChangeLog text NOT NULL DEFAULT '',
Type varchar(64) NOT NULL DEFAULT '',
Field varchar(64) NOT NULL DEFAULT '',
OldContent text NOT NULL DEFAULT '',
NewContent text NOT NULL DEFAULT '',
Creator integer NOT NULL DEFAULT 0,
Created DATETIME NULL,
PRIMARY KEY (id)
) TYPE=InnoDB;
|
