Tree [r5] /
History



File Date Author Commit
SQL_dumps 2009-08-24 xxx39 [r5]
PMain.bpr 2009-08-19 xxx39 [r2]
PMain.cpp 2009-08-19 xxx39 [r2]
PMain.exe 2009-08-24 xxx39 [r5]
PMain.ilc 2009-08-24 xxx39 [r5]
PMain.ild 2009-08-24 xxx39 [r5]
PMain.ilf 2009-08-24 xxx39 [r5]
PMain.ils 2009-08-24 xxx39 [r5]
PMain.obj 2009-08-19 xxx39 [r2]
PMain.res 2009-08-19 xxx39 [r2]
PMain.tds 2009-08-19 xxx39 [r2]
PMain.todo 2009-08-19 xxx39 [r2]
PMain_compressed.exe 2009-08-19 xxx39 [r2]
Storehouse.ico 2009-08-19 xxx39 [r2]
UAddCurrency.cpp 2009-08-21 xxx39 [r4]
UAddCurrency.ddp 2009-08-19 xxx39 [r2]
UAddCurrency.dfm 2009-08-19 xxx39 [r2]
UAddCurrency.h 2009-08-19 xxx39 [r2]
UAddCurrency.obj 2009-08-21 xxx39 [r4]
UAddCurrency.~cpp 2009-08-21 xxx39 [r4]
UAddCurrency.~ddp 2009-08-21 xxx39 [r4]
UAddCurrency.~dfm 2009-08-21 xxx39 [r4]
UAddCurrency.~h 2009-08-21 xxx39 [r4]
UAddNewGood.cpp 2009-08-21 xxx39 [r4]
UAddNewGood.ddp 2009-08-19 xxx39 [r2]
UAddNewGood.dfm 2009-08-19 xxx39 [r2]
UAddNewGood.h 2009-08-19 xxx39 [r2]
UAddNewGood.obj 2009-08-21 xxx39 [r4]
UAddNewGood.~cpp 2009-08-21 xxx39 [r4]
UAddNewGood.~ddp 2009-08-21 xxx39 [r4]
UAddNewGood.~dfm 2009-08-21 xxx39 [r4]
UAddNewGood.~h 2009-08-21 xxx39 [r4]
UBathedGoods.cpp 2009-08-21 xxx39 [r4]
UBathedGoods.ddp 2009-08-19 xxx39 [r2]
UBathedGoods.dfm 2009-08-19 xxx39 [r2]
UBathedGoods.h 2009-08-19 xxx39 [r2]
UBathedGoods.obj 2009-08-21 xxx39 [r4]
UBathedGoods.~cpp 2009-08-21 xxx39 [r4]
UBathedGoods.~ddp 2009-08-21 xxx39 [r4]
UBathedGoods.~dfm 2009-08-21 xxx39 [r4]
UBathedGoods.~h 2009-08-21 xxx39 [r4]
UConnection.cpp 2009-08-21 xxx39 [r4]
UConnection.ddp 2009-08-19 xxx39 [r2]
UConnection.dfm 2009-08-19 xxx39 [r2]
UConnection.h 2009-08-19 xxx39 [r2]
UConnection.obj 2009-08-21 xxx39 [r4]
UConnection.~cpp 2009-08-21 xxx39 [r4]
UConnection.~ddp 2009-08-21 xxx39 [r4]
UConnection.~dfm 2009-08-21 xxx39 [r4]
UConnection.~h 2009-08-21 xxx39 [r4]
UCurrency.cpp 2009-08-21 xxx39 [r4]
UCurrency.ddp 2009-08-19 xxx39 [r2]
UCurrency.dfm 2009-08-19 xxx39 [r2]
UCurrency.h 2009-08-19 xxx39 [r2]
UCurrency.obj 2009-08-21 xxx39 [r4]
UCurrency.~cpp 2009-08-21 xxx39 [r4]
UCurrency.~ddp 2009-08-21 xxx39 [r4]
UCurrency.~dfm 2009-08-21 xxx39 [r4]
UCurrency.~h 2009-08-21 xxx39 [r4]
UDayReport.cpp 2009-08-21 xxx39 [r4]
UDayReport.ddp 2009-08-19 xxx39 [r2]
UDayReport.dfm 2009-08-19 xxx39 [r2]
UDayReport.h 2009-08-19 xxx39 [r2]
UDayReport.obj 2009-08-21 xxx39 [r4]
UDayReport.~cpp 2009-08-21 xxx39 [r4]
UDayReport.~ddp 2009-08-21 xxx39 [r4]
UDayReport.~dfm 2009-08-21 xxx39 [r4]
UDayReport.~h 2009-08-21 xxx39 [r4]
UEditBathedGoods.cpp 2009-08-21 xxx39 [r4]
UEditBathedGoods.ddp 2009-08-19 xxx39 [r2]
UEditBathedGoods.dfm 2009-08-19 xxx39 [r2]
UEditBathedGoods.h 2009-08-19 xxx39 [r2]
UEditBathedGoods.obj 2009-08-21 xxx39 [r4]
UEditBathedGoods.~cpp 2009-08-21 xxx39 [r4]
UEditBathedGoods.~ddp 2009-08-21 xxx39 [r4]
UEditBathedGoods.~dfm 2009-08-21 xxx39 [r4]
UEditBathedGoods.~h 2009-08-21 xxx39 [r4]
UEditCategory.cpp 2009-08-21 xxx39 [r4]
UEditCategory.ddp 2009-08-19 xxx39 [r2]
UEditCategory.dfm 2009-08-19 xxx39 [r2]
UEditCategory.h 2009-08-19 xxx39 [r2]
UEditCategory.obj 2009-08-21 xxx39 [r4]
UEditCategory.~cpp 2009-08-21 xxx39 [r4]
UEditCategory.~ddp 2009-08-21 xxx39 [r4]
UEditCategory.~dfm 2009-08-21 xxx39 [r4]
UEditCategory.~h 2009-08-21 xxx39 [r4]
UEditGood.cpp 2009-08-21 xxx39 [r4]
UEditGood.ddp 2009-08-19 xxx39 [r2]
UEditGood.dfm 2009-08-19 xxx39 [r2]
UEditGood.h 2009-08-19 xxx39 [r2]
UEditGood.obj 2009-08-21 xxx39 [r4]
UEditGood.~cpp 2009-08-21 xxx39 [r4]
UEditGood.~ddp 2009-08-21 xxx39 [r4]
UEditGood.~dfm 2009-08-21 xxx39 [r4]
UEditGood.~h 2009-08-21 xxx39 [r4]
UEditSaledGood.cpp 2009-08-21 xxx39 [r4]
UEditSaledGood.ddp 2009-08-19 xxx39 [r2]
UEditSaledGood.dfm 2009-08-19 xxx39 [r2]
UEditSaledGood.h 2009-08-19 xxx39 [r2]
UEditSaledGood.obj 2009-08-21 xxx39 [r4]
UEditSaledGood.~cpp 2009-08-21 xxx39 [r4]
UEditSaledGood.~ddp 2009-08-21 xxx39 [r4]
UEditSaledGood.~dfm 2009-08-21 xxx39 [r4]
UEditSaledGood.~h 2009-08-21 xxx39 [r4]
UInvoiceCreate.cpp 2009-08-21 xxx39 [r4]
UInvoiceCreate.ddp 2009-08-19 xxx39 [r2]
UInvoiceCreate.dfm 2009-08-19 xxx39 [r2]
UInvoiceCreate.h 2009-08-19 xxx39 [r2]
UInvoiceCreate.obj 2009-08-21 xxx39 [r4]
UInvoiceCreate.~cpp 2009-08-21 xxx39 [r4]
UInvoiceCreate.~ddp 2009-08-21 xxx39 [r4]
UInvoiceCreate.~dfm 2009-08-21 xxx39 [r4]
UInvoiceCreate.~h 2009-08-21 xxx39 [r4]
UMain.cpp 2009-08-21 xxx39 [r4]
UMain.ddp 2009-08-19 xxx39 [r2]
UMain.dfm 2009-08-24 xxx39 [r5]
UMain.h 2009-08-19 xxx39 [r2]
UMain.obj 2009-08-21 xxx39 [r4]
UMain.~cpp 2009-08-24 xxx39 [r5]
UMain.~ddp 2009-08-21 xxx39 [r4]
UMain.~dfm 2009-08-24 xxx39 [r5]
UMain.~h 2009-08-21 xxx39 [r4]
UNecessitiesAmount.cpp 2009-08-21 xxx39 [r4]
UNecessitiesAmount.ddp 2009-08-19 xxx39 [r2]
UNecessitiesAmount.dfm 2009-08-19 xxx39 [r2]
UNecessitiesAmount.h 2009-08-19 xxx39 [r2]
UNecessitiesAmount.obj 2009-08-21 xxx39 [r4]
UNecessitiesAmount.~cpp 2009-08-21 xxx39 [r4]
UNecessitiesAmount.~ddp 2009-08-21 xxx39 [r4]
UNecessitiesAmount.~dfm 2009-08-21 xxx39 [r4]
UNecessitiesAmount.~h 2009-08-21 xxx39 [r4]
UNewCategory.cpp 2009-08-21 xxx39 [r4]
UNewCategory.ddp 2009-08-19 xxx39 [r2]
UNewCategory.dfm 2009-08-19 xxx39 [r2]
UNewCategory.h 2009-08-19 xxx39 [r2]
UNewCategory.obj 2009-08-21 xxx39 [r4]
UNewCategory.~cpp 2009-08-21 xxx39 [r4]
UNewCategory.~ddp 2009-08-21 xxx39 [r4]
UNewCategory.~dfm 2009-08-21 xxx39 [r4]
UNewCategory.~h 2009-08-21 xxx39 [r4]
UPriceList.cpp 2009-08-21 xxx39 [r4]
UPriceList.ddp 2009-08-19 xxx39 [r2]
UPriceList.dfm 2009-08-19 xxx39 [r2]
UPriceList.h 2009-08-19 xxx39 [r2]
UPriceList.obj 2009-08-21 xxx39 [r4]
UPriceList.~cpp 2009-08-21 xxx39 [r4]
UPriceList.~ddp 2009-08-21 xxx39 [r4]
UPriceList.~dfm 2009-08-21 xxx39 [r4]
UPriceList.~h 2009-08-21 xxx39 [r4]
UProducersAction.cpp 2009-08-21 xxx39 [r4]
UProducersAction.ddp 2009-08-19 xxx39 [r2]
UProducersAction.dfm 2009-08-19 xxx39 [r2]
UProducersAction.h 2009-08-19 xxx39 [r2]
UProducersAction.obj 2009-08-21 xxx39 [r4]
UProducersAction.~cpp 2009-08-21 xxx39 [r4]
UProducersAction.~ddp 2009-08-21 xxx39 [r4]
UProducersAction.~dfm 2009-08-21 xxx39 [r4]
UProducersAction.~h 2009-08-21 xxx39 [r4]
USaledGoods.cpp 2009-08-24 xxx39 [r5]
USaledGoods.ddp 2009-08-19 xxx39 [r2]
USaledGoods.dfm 2009-08-19 xxx39 [r2]
USaledGoods.h 2009-08-19 xxx39 [r2]
USaledGoods.obj 2009-08-24 xxx39 [r5]
USaledGoods.~cpp 2009-08-24 xxx39 [r5]
USaledGoods.~ddp 2009-08-21 xxx39 [r4]
USaledGoods.~dfm 2009-08-21 xxx39 [r4]
USaledGoods.~h 2009-08-21 xxx39 [r4]
USupplierAction.cpp 2009-08-21 xxx39 [r4]
USupplierAction.ddp 2009-08-19 xxx39 [r2]
USupplierAction.dfm 2009-08-19 xxx39 [r2]
USupplierAction.h 2009-08-19 xxx39 [r2]
USupplierAction.obj 2009-08-21 xxx39 [r4]
USupplierAction.~cpp 2009-08-21 xxx39 [r4]
USupplierAction.~ddp 2009-08-21 xxx39 [r4]
USupplierAction.~dfm 2009-08-21 xxx39 [r4]
USupplierAction.~h 2009-08-21 xxx39 [r4]
UWholesaleBuyerAction.cpp 2009-08-21 xxx39 [r4]
UWholesaleBuyerAction.ddp 2009-08-19 xxx39 [r2]
UWholesaleBuyerAction.dfm 2009-08-19 xxx39 [r2]
UWholesaleBuyerAction.h 2009-08-19 xxx39 [r2]
UWholesaleBuyerAction.obj 2009-08-21 xxx39 [r4]
UWholesaleBuyerAction.~cpp 2009-08-21 xxx39 [r4]
UWholesaleBuyerAction.~ddp 2009-08-21 xxx39 [r4]
UWholesaleBuyerAction.~dfm 2009-08-21 xxx39 [r4]
UWholesaleBuyerAction.~h 2009-08-21 xxx39 [r4]
comerr32.dll 2009-08-19 xxx39 [r2]
gssapi32.dll 2009-08-19 xxx39 [r2]
k5sprt32.dll 2009-08-19 xxx39 [r2]
krb5_32.dll 2009-08-19 xxx39 [r2]
libeay32.dll 2009-08-19 xxx39 [r2]
libiconv-2.dll 2009-08-19 xxx39 [r2]
libintl-2.dll 2009-08-19 xxx39 [r2]
libintl-8.dll 2009-08-19 xxx39 [r2]
libpq.dll 2009-08-19 xxx39 [r2]
libpq81.dll 2009-08-19 xxx39 [r2]
readme.txt 2009-08-24 xxx39 [r5]
readme.txt.bak 2009-08-19 xxx39 [r3]
ssleay32.dll 2009-08-19 xxx39 [r1]
storehouse.ini 2009-08-19 xxx39 [r2]
update_goods_remainder.sql 2009-08-24 xxx39 [r5]

Read Me

Проект по складскому учёту. База данных на PostgreSQL, представления будут "*_view", функции "function_*", последовательности "sequence_*".
---------------------
После установки сервера PostgreSQL необходимо инициализировать базу данных командой:
psql.exe -U postgres -h 192.168.225.2 -f E:\storehouse.sql "template1"
Где, psql.exe - программа работы с СУБД PostgreSQL, -U postgres - подключиться под пользователем postgres, -h 192.168.225.2 - IP адрес хоста на котором крутится PostgreSQL, -f E:\storehouse.sql - путь к дампу базы данных, "template1" - временная база данных к которой производится подключение в процессе создания таблиц из дампа. Прочитать как устанавливать СУБД PostgreSQL на Windows XP можно здесь. Советую ставить PostgreSQL на FreeBSD, ну или на Linux. Если хотите запустить Storehouse по сети то в файле pg_hba.conf (находится в среди файлов настройки сервера PostgreSQL) нужно прописать следующее:
host all all 192.168.225.1/32 md5
Где, 192.168.225.1 - это IP адрес клиентской машины на котором запущен Storehouse. Пишите пожелания на e-mail:charlz_klug[at]mail.ru, по возможности буду прикручивать дополнительные вещи к программе.
-------------------------
Команда для восстановления содержимого сервера:
C:\Program Files\PostgreSQL\8.3\bin>psql.exe -U postgres -h 192.168.20.6 -f  e:\Documents\Projects\storehouse\server_full_dump_20090710.sql "template1"
-------------------------
Команда для бэкапа схемы SQL сервера:
C:\Program Files\PostgreSQL\8.3\bin>pg_dump.exe -f e:\Documents\Projects\storehouse\SQL_dumps\20090820_server_schema_dump.sql -Fp -C -D -s -h 192.168.20.6 -U postgres "storehouse"
---------------------------
Команда для бэкапа всего SQL сервера:
C:\Program Files\PostgreSQL\8.3\bin>pg_dumpall.exe -f e:\Documents\Projects\storehouse\SQL_dumps\20090820_server_full_dump.sql -c -D -h 192.168.20.6 -U postgres