143 |
|
|
144 |
my $where = ''; |
my $where = ''; |
145 |
my @data; |
my @data; |
146 |
if ($host_id && $share_id && $num) { |
if (defined($host_id) && defined($share_id) && defined($num)) { |
147 |
$where = qq{ |
$where = qq{ |
148 |
WHERE |
WHERE |
149 |
hosts.id = ? AND |
hosts.id = ? AND |
310 |
size bigint not null, |
size bigint not null, |
311 |
inc_size bigint not null default -1, |
inc_size bigint not null default -1, |
312 |
inc_deleted boolean default false, |
inc_deleted boolean default false, |
313 |
|
parts integer not null default 1, |
314 |
PRIMARY KEY(id) |
PRIMARY KEY(id) |
315 |
); |
); |
316 |
|
|
343 |
); |
); |
344 |
|
|
345 |
create table archive_burned ( |
create table archive_burned ( |
346 |
archive_id int references archive(id), |
archive_id int references archive(id), |
347 |
date date default now(), |
date timestamp default now(), |
348 |
iso_size int default -1 |
part int not null default 1, |
349 |
|
copy int not null default 1, |
350 |
|
iso_size bigint default -1 |
351 |
); |
); |
352 |
|
|
353 |
}); |
}); |