Master to 4.2.8
[usit-rt.git] / etc / upgrade / 3.9.8 / schema.mysql
CommitLineData
c33a4027 1DROP TABLE IF EXISTS Classes;
01e3b242
MKG
2CREATE TABLE Classes (
3 id int(11) NOT NULL auto_increment,
4 Name varchar(255) NOT NULL default '',
5 Description varchar(255) NOT NULL default '',
6 SortOrder int(11) NOT NULL default '0',
7 Disabled int(2) NOT NULL default '0',
8 Creator int(11) NOT NULL default '0',
9 Created datetime default NULL,
10 LastUpdatedBy int(11) NOT NULL default '0',
11 LastUpdated datetime default NULL,
12 HotList int(2) NOT NULL default '0',
13 PRIMARY KEY (id)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8;
15
c33a4027 16DROP TABLE IF EXISTS Articles;
01e3b242
MKG
17CREATE TABLE Articles (
18 id int(11) NOT NULL auto_increment,
19 Name varchar(255) NOT NULL default '',
20 Summary varchar(255) NOT NULL default '',
21 SortOrder int(11) NOT NULL default '0',
22 Class int(11) NOT NULL default '0',
23 Parent int(11) NOT NULL default '0',
24 URI varchar(255) character set ascii default NULL,
25 Creator int(11) NOT NULL default '0',
26 Created datetime default NULL,
27 LastUpdatedBy int(11) NOT NULL default '0',
28 LastUpdated datetime default NULL,
29 PRIMARY KEY (id)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
c33a4027 32DROP TABLE IF EXISTS Topics;
01e3b242
MKG
33CREATE TABLE Topics (
34 id int(11) NOT NULL auto_increment,
35 Parent int(11) NOT NULL default '0',
36 Name varchar(255) NOT NULL default '',
37 Description varchar(255) NOT NULL default '',
38 ObjectType varchar(64) character set ascii NOT NULL default '',
39 ObjectId int(11) NOT NULL default '0',
40 PRIMARY KEY (id)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8;
42
c33a4027 43DROP TABLE IF EXISTS ObjectTopics;
01e3b242
MKG
44CREATE TABLE ObjectTopics (
45 id int(11) NOT NULL auto_increment,
46 Topic int(11) NOT NULL default '0',
47 ObjectType varchar(64) character set ascii NOT NULL default '',
48 ObjectId int(11) NOT NULL default '0',
49 PRIMARY KEY (id)
50) ENGINE=InnoDB DEFAULT CHARSET=utf8;
51
c33a4027 52DROP TABLE IF EXISTS ObjectClasses;
01e3b242
MKG
53CREATE TABLE ObjectClasses (
54 id int(11) NOT NULL auto_increment,
55 Class int(11) NOT NULL default '0',
56 ObjectType varchar(255) character set ascii NOT NULL default '',
57 ObjectId int(11) NOT NULL default '0',
58 Creator int(11) NOT NULL default '0',
59 Created datetime default NULL,
60 LastUpdatedBy int(11) NOT NULL default '0',
61 LastUpdated datetime default NULL,
62 PRIMARY KEY (id)
63) ENGINE=InnoDB DEFAULT CHARSET=utf8;