/
mysql-4_3.sql
45 lines (41 loc) · 1.33 KB
/
mysql-4_3.sql
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
alter database character set utf8 collate utf8_general_ci;
create table orbeon_form_definition (
created timestamp(6),
last_modified timestamp(6),
username varchar(255),
app varchar(255),
form varchar(255),
deleted char(1) not null,
xml mediumtext
) engine = InnoDB;
create table orbeon_form_definition_attach (
created timestamp(6),
last_modified timestamp(6),
username varchar(255),
app varchar(255),
form varchar(255),
deleted char(1) not null,
file_name varchar(255),
file_content longblob
) engine = InnoDB;
create table orbeon_form_data (
created timestamp(6),
last_modified timestamp(6),
username varchar(255),
app varchar(255),
form varchar(255),
document_id varchar(255),
deleted char(1) not null,
xml mediumtext
) engine = InnoDB;
create table orbeon_form_data_attach (
created timestamp(6),
last_modified timestamp(6),
username varchar(255),
app varchar(255),
form varchar(255),
document_id varchar(255),
deleted char(1) not null,
file_name varchar(255),
file_content longblob
) engine = InnoDB;