|
Last change
on this file since 9bc0e68 was
9bc0e68,
checked in by Blacklight <blacklight@…>, 9 years ago
|
- Обновлены дамп пустой базы и патчи
|
-
Property mode set to
100644
|
|
File size:
689 bytes
|
| Line | |
|---|
| 1 | ALTER TABLE `doc_kassa` CHANGE `firm_id` `firm_id` INT NULL DEFAULT NULL; |
|---|
| 2 | ALTER TABLE `doc_sklady` ENGINE = InnoDB; |
|---|
| 3 | ALTER TABLE `doc_vars` ENGINE = InnoDB; |
|---|
| 4 | ALTER TABLE `doc_sklady` ADD FOREIGN KEY ( `firm_id` ) REFERENCES `doc_vars` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ; |
|---|
| 5 | ALTER TABLE `doc_vars` ADD `firm_bank_lock` SMALLINT NOT NULL COMMENT 'Работать только со своими банками'; |
|---|
| 6 | ALTER TABLE `doc_vars` ADD `firm_till_lock` SMALLINT NOT NULL COMMENT 'Работать только со своими кассами'; |
|---|
| 7 | UPDATE `doc_kassa` SET `firm_id`=null WHERE `firm_id`=0; |
|---|
| 8 | |
|---|
| 9 | TRUNCATE `db_version`; |
|---|
| 10 | INSERT INTO `db_version` (`version`) VALUES (725); |
|---|
| 11 | |
|---|
| 12 | |
|---|
Note: See
TracBrowser
for help on using the repository browser.
