Re: Accountability with MySQL

>>I am designing a simple accountability system so all the partners can >> have >> direct access to it by intranet. >> >> I was designing the data model, and came up with this: >> >> CREATE TABLE `moviments` ( >> `moviment_id` int(20) NOT NULL auto_increment, >> `moviment_date` date NOT NULL def

Re: Accountability with MySQL

Hi Martijn, well about the date default value being invalid, well it´s working here in my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with this... About the business logic I was thinking about showing the current month by default, and if the user wants he can select diferent d

Accountability with MySQL

I am designing a simple accountability system so all the partners can have direct access to it by intranet. I was designing the data model, and came up with this: CREATE TABLE `moviments` ( `moviment_id` int(20) NOT NULL auto_increment, `moviment_date` date NOT NULL default '-00-00', `m