1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-- Deploy data_bag_items
BEGIN;
CREATE TABLE data_bag_items (
id int not null auto_increment,
name varchar(255) not null,
orig_name varchar(255) not null,
data_bag_id int not null,
raw_data blob,
created_at datetime not null,
updated_at datetime not null,
primary key(id),
FOREIGN KEY(data_bag_id)
REFERENCES data_bags(id)
ON DELETE RESTRICT,
unique key(data_bag_id, name),
unique key(data_bag_id, orig_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
COMMIT;
|
