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
|
-- modified from schema.mysql by Niko Tyni <ntyni@debian.org>
CREATE TABLE FM_Classes (
id INTEGER PRIMARY KEY,
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,
HotList int(2) NOT NULL DEFAULT 0
) ;
CREATE TABLE FM_Articles (
id INTEGER PRIMARY KEY,
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
) ;
CREATE TABLE FM_Topics (
id INTEGER PRIMARY KEY,
Parent integer NOT NULL DEFAULT 0,
Name varchar(255) NOT NULL DEFAULT '',
Description varchar(255) NOT NULL DEFAULT '',
ObjectType varchar(64) NOT NULL DEFAULT '',
ObjectId integer NOT NULL
) ;
CREATE TABLE FM_ObjectTopics (
id INTEGER PRIMARY KEY,
Topic integer NOT NULL,
ObjectType varchar(64) NOT NULL DEFAULT '',
ObjectId integer NOT NULL
) ;
|
