zentao/db/update4.0.beta1.sql

ALTER TABLE `zt_testTask` ADD  `pri` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT  '0' AFTER  `owner`;
ALTER TABLE `zt_user` ADD `role` CHAR( 10 ) NOT NULL DEFAULT '' AFTER `password`;
ALTER TABLE `zt_product` CHANGE `QM` `QD` VARCHAR( 30 ) NOT NULL;
ALTER TABLE `zt_project` CHANGE `QM` `QD` VARCHAR( 30 ) NOT NULL DEFAULT '',
CHANGE `RM` `RD` VARCHAR( 30 ) NOT NULL DEFAULT '';
ALTER TABLE `zt_product` CHANGE `RM` `RD` VARCHAR( 30 ) NOT NULL;

CREATE TABLE IF NOT EXISTS `zt_userContact` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `company` mediumint(8) unsigned NOT NULL,
  `account` char(30) NOT NULL,
  `listName` varchar(60) NOT NULL,
  `userList` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;