X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/1c962161585180f8a9f963d05a2a87b78a5a37a5..32acd0caf0385a9fb7014af70d1a0ad438191dd7:/mysql.sql diff --git a/mysql.sql b/mysql.sql index fb2ebe17..5dd41e06 100644 --- a/mysql.sql +++ b/mysql.sql @@ -91,7 +91,7 @@ CREATE TABLE `tt_users` ( `role_id` int(11) default NULL, # role id `client_id` int(11) default NULL, # client id for "client" user role `rate` float(6,2) NOT NULL default '0.00', # default hourly rate - `quota_percent` float(6,2) default NULL, # percent of time quota + `quota_percent` float(6,2) NOT NULL default '100.00', # percent of time quota `email` varchar(100) default NULL, # user email `created` datetime default NULL, # creation timestamp `created_ip` varchar(45) default NULL, # creator ip @@ -489,4 +489,4 @@ CREATE TABLE `tt_site_config` ( PRIMARY KEY (`param_name`) ); -INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.34', now()); # TODO: change when structure changes. +INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.36', now()); # TODO: change when structure changes.