commit aff073a416b760c209576925b47c21da8d1db3ba
parent f6df69188b1befe424b9af5e3a35d918c197e099
Author: Kyle Milz <kyle@getaddrinfo.net>
Date: Sun, 15 May 2016 14:49:02 -0600
database: add type to column and remove owner from new_list_item
Diffstat:
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/server/SL/Database.pm b/server/SL/Database.pm
@@ -85,7 +85,7 @@ sub create_tables {
name text,
owner integer,
status int not null default 0,
- quantity,
+ quantity int,
created int not null,
last_updated int not null,
foreign key(list) references lists(num),
@@ -196,7 +196,7 @@ sub prepare_stmt_handles {
$sql = 'select * from list_data where list = ?';
$self->{get_list_items} = $dbh->prepare($sql);
- $sql = 'insert into list_data (list, name, quantity, status, owner, last_updated) values (?, ?, ?, ?, ?, ?)';
+ $sql = 'insert into list_data (list, name, quantity, created, last_updated) values (?, ?, ?, ?, ?)';
$self->{new_list_item} = $dbh->prepare($sql);
}