Hi,
For anybody who found that the timecard tables were missing when they tried to enable the timecard feature, here's how to add them from the command line:
Type:
mysql
Paste the following two commands into mysql:
CREATE TABLE timecard (
ID int(
default NULL auto_increment,
users varchar(255) default NULL,
datum varchar(10) default NULL,
projekt varchar(20) default NULL,
anfang varchar(4) default NULL,
ende varchar(4) default NULL,
out_begin varchar(4) default NULL,
out_end varchar(4) default NULL,
out_begin2 varchar(4) default NULL,
out_end2 varchar(4) default NULL,
note varchar(40) default NULL,
div1 varchar(40) default NULL,
div2 varchar(40) default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;
CREATE TABLE timeproj (
ID int(
default NULL auto_increment,
users int(4) default NULL,
projekt int(4) default NULL,
datum varchar(10) default NULL,
h int(2) default NULL,
m int(2) default NULL,
kat varchar(255) default NULL,
note varchar(40) default NULL,
ext int(2) default NULL,
div1 varchar(40) default NULL,
div2 varchar(40) default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;
Type:
quit
And viola! Timecards should now work.
Regards,
Luke