init.sql

Free business support system developed entirely in Sybase s PowerBuilder

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%
% SOHO 98 CROATIAN VERSION
%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%


%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
% LANGUAGES
insert into reflex_lang ( lang_id, lang_name )
values (385, 'Hrvatski');

commit;

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
% MODULES 
% Contact Management System
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (1, 385, 'Partneri', 'CMS');

% BILLS
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (2, 385, 'Ulazni ra鑥ni', 'BILLS');

% INVOICE
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (3, 385, 'Izlazni ra鑥ni', 'INVOICE');

% BANK REPORT
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (4, 385, 'Bankovni izvodi', 'BANKREP');

% STOCK
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (5, 385, 'Skladi歵e', 'CMS');

% STOCKIN
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (6, 385, 'Primke', 'STOCKIN');

% STOCKOUT
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (7, 385, 'Otpremnice', 'STOCKOUT');

% WORDPROC
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (8, 385, 'Tekst procesor', 'WORDPROC');

% CATALOG
insert into reflex_module (module_id, lang_id, module_name, module_idn )
values (9, 385, 'Katalog roba i usluga', 'CAT');



% CYCLONE
%%%%%%%%%%% ZAJEDNILKE STAVKE %%%%%%%%%%%%%%%%%
insert into reflex_user (user_id, lang_id, user_name) values (0, 385,'NULTI KORISNIK');

insert into reflex_tip (lang_id, tip_id, tip_module, tip_text) values (385,1,'Poruka dana:','??? ...');

insert into cat_taxgroup (tgrp_id, tgrp_percent, tgrp_desc) values(1,22.00,'PDV');

insert into idset_installation (installation_id) values (1);
insert into idset_set (set_id, installation_id,set_name) values(1,1,'Broj ra鑥na/godina');
insert into idset_defaults (default_name, installation_id,default_valuen) values('tgrp_id',1,1);

insert into cat_qtypes (qtypes_qtype, qtypes_name) values ('kom','Komad')
insert into cat_qtypes (qtypes_qtype, qtypes_name) values ('kg','Kilogram')
insert into cat_qtypes (qtypes_qtype, qtypes_name) values ('lit','Litra')
insert into cat_qtypes (qtypes_qtype, qtypes_name) values ('set','Set')
insert into cat_qtypes (qtypes_qtype, qtypes_name) values ('pak','Paket')
%%%%%%%%%%% ZAJEDNILKE STAVKE %%%%%%%%%%%%%%%%%

%%%%%%%%%%% CYCLONE %%%%%%%%%%%%%%%%%
insert into idset_counter (counter_id, installation_id, counter_name, counter_count) values (1,1,'Izlazni ra鑥ni',0);
insert into idset_counter (counter_id, installation_id, counter_name, counter_count) values (2,1,'Bankovni izvodi',0);

insert into inv_paytype (paytype_id, paytype_type) values (1,'Bezgotovinsko');
insert into inv_paytype (paytype_id, paytype_type) values (2,'萫k');
insert into inv_paytype (paytype_id, paytype_type) values (3,'Kartica');
insert into inv_paytype (paytype_id, paytype_type) values (4,'Gotovina');
insert into inv_type (set_id,type_id,type_name) values (1,1,'Izlazni ra鑥n');

insert into cms_phtype (phtype_id, phtype_name) values (1,'Telefon');
insert into cms_phtype (phtype_id, phtype_name) values (2,'Fax');

insert into cms_master(master_id, user_id, master_name1) values(0,0,'MALOPRODAJA');
%%%%%%%%%%% CYCLONE %%%%%%%%%%%%%%%%%

%%%%%%%%%%% ANDREJ %%%%%%%%%%%%%%%%%
Insert Into cat_group (grp_id, grp_name, grp_desc, grp_sub)
Values (0, 'Glavna grupa','',-1);

Insert Into reflex_usrgrp (usrgrp_id, usrgrp_name, usrgrp_desc, usrgrp_set, usrgrp_subgrp)
Values (0,'Glavna grupa','',null,-1);

Insert Into reflex_usrgrp (usrgrp_id, usrgrp_name, usrgrp_desc, usrgrp_set, usrgrp_subgrp)
Values (1,'Administratori','Administratori',null,0);

Insert Into reflex_usrgrp (usrgrp_id, usrgrp_name, usrgrp_desc, usrgrp_set, usrgrp_subgrp)
Values (2,'Korisnici','Korisnici',null,0);

Insert Into Idset_defaults (default_name, installation_id, default_values, default_desc)
Values ('catalog_qty',1,'kom','Default Value for Catalog Qtype');

Insert Into Idset_defaults (default_name, installation_id, default_valuen, default_desc)
Values ('catalog_taxgroup',1,0,'Default Value for Catalog TaxGroup');

Insert Into Stock_warehouse (warehouse_id, warehouse_name, warehouse_desc)
Values (1,'Default Warehouse','Good giving default warehouse');

Insert Into Stock_doctype (doctype_id, set_id, doctype_name, doctype_desc)
Values (1,1,'PRIMKA','Ono sto zaprima robu na ljager');

Insert Into Stock_doctype (doctype_id, set_id, doctype_name, doctype_desc)
Values (2,1,'OTPREMNICA','Ono sto mice robu sa ljager');

Insert Into Stock_doctype (doctype_id, set_id, doctype_name, doctype_desc)
Values (3,1,'POVRATNICA','Vrati mi se, vrati...');

Insert Into Stock_doctype (doctype_id, set_id, doctype_name, doctype_desc)
Values (4,1,'INVENTURA','Prste k sebi...');
%%%%%%%%%%% ANDREJ %%%%%%%%%%%%%%%%%

commit;