From da06d70c49742be3fa20e325abb0b4d1f4a0b468 Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Fri, 23 Aug 2013 22:30:33 +0200 Subject: [PATCH] Added missing default values --- wcfsetup/setup/db/install.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 043dccadc7..687a45c11a 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -197,11 +197,11 @@ DROP TABLE IF EXISTS wcf1_category; CREATE TABLE wcf1_category ( categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, objectTypeID INT(10) NOT NULL, - parentCategoryID INT(10) NOT NULL, + parentCategoryID INT(10) NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL, description TEXT, - showOrder INT(10) NOT NULL, - time INT(10) NOT NULL, + showOrder INT(10) NOT NULL DEFAULT 0, + time INT(10) NOT NULL DEFAULT 0, isDisabled TINYINT(1) NOT NULL DEFAULT 0, additionalData TEXT ); -- 2.20.1