Просмотр архива vkolhoze.com |от tonyresh

DROP TABLE IF EXISTS `jobs_list`;

CREATE TABLE `jobs_list` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `level` int(11) DEFAULT NULL,
 
`status` enum('0','1','2') DEFAULT '0',
  `count` int(11) DEFAULT NULL,
 
 `desc` int(11) default null,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS
`jobs_user`;

CREATE TABLE `jobs_user` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `status`
enum('0','1') DEFAULT '0',
   `prize` int(11) default null,
`count`
int(11) default null,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

ALTER TABLE `kolhoz_user` SET
`jloc0` int(11) default '0';