1.3.2.sql 543 B

123456789101112131415
  1. ALTER TABLE `extcontras_money` ADD `date_payment` date DEFAULT NULL AFTER `summ_payment`;
  2. CREATE TABLE IF NOT EXISTS `wh_salesreports` (
  3. `id` int(11) NOT NULL AUTO_INCREMENT,
  4. `name` varchar(255) NOT NULL,
  5. PRIMARY KEY (`id`)
  6. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
  7. CREATE TABLE IF NOT EXISTS `wh_salesitems` (
  8. `id` int(11) NOT NULL AUTO_INCREMENT,
  9. `reportid` int(11) NOT NULL,
  10. `itemtypeid` int(11) NOT NULL,
  11. PRIMARY KEY (`id`),
  12. KEY `reportid` (`reportid`)
  13. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;