Re: Prevent table errors
Posted by:
Andrzej M
Date: May 16, 2005 05:40AM
OS is Debian Linux 3.0 probably with kernel 2.4.3 (unforunetely I'm not sure), MySql version is 3.23.49. I didn't check error log yet, because I don't have such permission. I'm waiting for mail (hope with logs) from administrator (if he do nothing, I have to do it :| )
This is my table structure:
CREATE TABLE `edu_statystyki` (
`stat_id` bigint(20) unsigned NOT NULL auto_increment,
`stat_tid` bigint(20) unsigned NOT NULL default '0',
`stat_sid` bigint(20) unsigned NOT NULL default '0',
`stat_data` date NOT NULL default '0000-00-00',
`stat_0` bigint(20) unsigned NOT NULL default '0',
`stat_1` bigint(20) unsigned NOT NULL default '0',
`stat_2` bigint(20) unsigned NOT NULL default '0',
`stat_3` bigint(20) unsigned NOT NULL default '0',
`stat_4` bigint(20) unsigned NOT NULL default '0',
`stat_5` bigint(20) unsigned NOT NULL default '0',
`stat_6` bigint(20) unsigned NOT NULL default '0',
`stat_7` bigint(20) unsigned NOT NULL default '0',
`stat_8` bigint(20) unsigned NOT NULL default '0',
`stat_9` bigint(20) unsigned NOT NULL default '0',
`stat_10` bigint(20) unsigned NOT NULL default '0',
`stat_11` bigint(20) unsigned NOT NULL default '0',
`stat_12` bigint(20) unsigned NOT NULL default '0',
`stat_13` bigint(20) unsigned NOT NULL default '0',
`stat_14` bigint(20) unsigned NOT NULL default '0',
`stat_15` bigint(20) unsigned NOT NULL default '0',
`stat_16` bigint(20) unsigned NOT NULL default '0',
`stat_17` bigint(20) unsigned NOT NULL default '0',
`stat_18` bigint(20) unsigned NOT NULL default '0',
`stat_19` bigint(20) unsigned NOT NULL default '0',
`stat_20` bigint(20) unsigned NOT NULL default '0',
`stat_21` bigint(20) unsigned NOT NULL default '0',
`stat_22` bigint(20) unsigned NOT NULL default '0',
`stat_23` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`stat_id`,`stat_tid`,`stat_sid`,`stat_data`),
KEY `stat_data` (`stat_data`)
) TYPE=MyISAM AUTO_INCREMENT=530687 ;