View file Daily tasks/user_job.sql

CREATE TABLE IF NOT EXISTS `user_job` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `time_active` int(11) DEFAULT '0',
  `files` int(11) DEFAULT '0',
  `photo` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `notes` int(11) DEFAULT '0',
  `type` varchar(128) DEFAULT 'job',
  `time_days` int(11) DEFAULT '0',
  `days` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

ALTER TABLE `gallery_foto` ADD `time` int(1) default '0';