PSPad Freeware Editor

PSPAD Freeware Editor

Brži je od Notepad++, koristim ga paralelno sa Notepad++, Atom i Visual Studio Code.

MORE TIPS:

***

DOWNLOAD

Brzo kreiranje dokumenata ako ste ulogovani na gmail nalog

For a quick way to create a new document, spreadsheet, presentation or drawing save a Chrome bookmark or desktop shortcut with these URLs:

New Google Document: https://docs.google.com/create

New Google Spreadsheet: https://sheets.google.com/create

New Google Presentation: https://slides.google.com/create

New Google Drawing: https://drawings.google.com/create

Instructions to add individually:

1. show the Chrome toolbar (ctrl-shift-b)
2. right-click to Add Folder…
3. drag the blue links above into the new folder, one at a time.

MORE TIPS:

10

If you want to become a machine learning expert

If you want to become a machine learning expert, you have to start with learning Python first.

Here is a step by step guide on what you should do:

Step 1: Basic Python Skills

If you have no knowledge of programming or a related degree, my suggestion is to start with the following free online book(if you’re into books):

• Python The Hard Way, by Zed A. Shaw

If you are not a book reader, you can search for courses online.

Step 2: Foundational Machine Learning Skills

Ok, so don’t worry, you don't need to possess a PhD-level understanding of the theoretical aspects of machine learning in order to practice, in the same manner that not all programmers require a theoretical computer science education in order to be effective coders.

Here are some basic links for you to start:

• Machine Learning - complete course notes
• Machine Learning

Step 3: Scientific Python Packages Overview

Now my guess is that you already started doing some simple Python stuff, so you would know what I’m talking about when I say you’d need to install these packages:

• numpy - mainly useful for its N-dimensional array objects
• pandas - Python data analysis library, including structures such as dataframes
• matplotlib - 2D plotting library producing publication quality figures
• scikit-learn - the machine learning algorithms used for data analysis and data mining tasks

Now that you have learned the basics, you can start doing some sample projects. Once you have finished up these steps you will be ready for getting into some deeper stuff. My understanding is that people will figure out the next steps by the time they get there!

BIT METER 2

http://codebox.org.uk/pages

http://codebox.org.uk/pages/bitmeteros

BitMeter OS is a free, open-source, bandwidth monitor that works on Windows, Linux and Mac OSX. BitMeter OS keeps track of how much you use your internet/network connection, and allows you to view this information either via a web browser, or by using the command line tools.

The Web Interface displays various graphs and charts that show how your internet/network connection has been used over time - online demo available.

The Monitor pane displays a graph that updates once each second, showing you what's happening with your connection right now:

https://codebox.net/pages/bitmeter2

BitMeter 2 is a bandwidth meter - it allows you to visually monitor your internet connection by displaying a scrolling graph that shows your upload and download speed over time. BitMeter is freeware - ie. it is given away completely free of charge, there is no trial period, no time-limited features, no spyware, and no adware, guaranteed.

This is what BitMeter looks like. The different colours on the graph represent your upload and download speeds, the display updates every second, and the current speeds are also displayed numerically in the lower part of the window.

If you want to see historical data you can use the Statistics window to see what's been going on over the last few hours, days or weeks.

10

Task Manager

Windows Task Manager, among other functions, allows you to stop applications and processes that are interfering with the Windows operating system or particular programs and applications. This is particularly pertinent when malware infections are running. You can find them in the Task Manager and stop them then remove them. Often, malware processes that are actively running will not be quarantined by many antivirus programs. What happens if Ctrl+Alt+Del will not work? If you are unable to open Task Manager from the start menu because a virus has locked you out, how do you open it? This article gives you six different ways to ensure access to the Task Manager so that you can stop malware processes and take back control of your PC.

For some time, the familiar three-finger tactic of Ctrl+Alt+Del would bring you directly to Windows Task Manager. That was the case until Windows Vista was born from the Microsoft womb. Now it simply brings up a Windows Security Screen presenting five options, one of which is Windows Task Manager. As stated previously, malware can block this tried and true tactic, though it is reasonable to try this first.

The easiest method for opening Windows Task Manager is to right-click the taskbar and then select Task Manager. This is a two-click method, but you can also create an Automatic HotKey that will bring up the task manager with a single key click. You can download a free utility for this: AutoHotkey download page.

All information is included to create a HotKey for Windows Task Manager, or any other application. The next option is to use the Run command. At the Start Menu, select All Programs and then under Accessories, click the Run command. Type taskmgr and press Enter. The Task Manager opens.

Ctrl+Shift+Esc will bring up the Task Manager as well, at least on most versions of Windows. This is your next bailout.
If all else fails, you can use the lengthy method of browsing to taskmgr.exe. Navigate to C:\Windows\System32\taskmgr.exe. Double click taskmgr.exe and you are in.

Finally, create a desktop shortcut to access Task Manager. Do this in addition to creating a HotKey. That gives you two quick default access methods. Simply right-click on your desktop and select New and then click Shortcut and a window will open. Follow the same path as above: C:\Windows\System32\taskmgr.exe. Click Next and type a name for the shortcut then click Finish to conclude. This will create a desktop icon allowing you to immediately open Windows Task Manager in the event of malware infection or any other reason. I highly recommend this and the HotKey approach. They are the fastest ways to open Task Manager when it is impaired by malware.

Follow these steps and you can’t fail. You will trick any virus and be able to stop malware processes and effectively remove the malware using your antivirus software.

Martin's Comment: Please note that there may be malware that blocks the task manager completely, so that not the access method, but the program itself cannot be opened by the user of the operating system. Your best in such a situation is to scan the system with antivirus software like Avast, Microsoft Security Essentials, AVG or one of the commercial solutions like Kaspersky, Symantec or BitDefender.

https://www.ghacks.net/2011/07/10/what-to-do-when-windows-task-manager-does-not-open/

Use FixWin

Our freeware FixWin, the Windows Doctor, has a lot of such fixes for many such Windows problems. You may download it and use it to fix your problems in a click.

We normally open Task Manager when we want to end applications, check on processes, monitor performance or carry out such system related tasks. To open the Task Manager, we do the following:

1. Right-click the Taskbar and select Task Manager
2. Press Ctrl+Shift+Esc
3. Press Ctrl+Alt+Del and then select Task Manager from the next screen.
4. Type taskmgr in start search and hit Enter to open the Task Manager.

Task Manager is not opening

But it may happen that one fine day you find that your Task Manager will not open. In such a case you will have to find out the reason – whether the Task Manager has been disabled by your Administrator or whether it is due to some other reason.

Task Manager has been disabled by your Administrator

When you try to open the Task Manager, do you get: Task Manager has been disabled by your Administratormessage? If so you can contact your admin with your problem.

Task Manager is not responding due to another reason

But if you are the sole user of the computer and you still get this message or a message like Task Manager is not responding, you can try the following suggestions:

First, open regedit and navigate to the following key:

HKEY_CURRENT_USER\Software\Microsoft\Windows\ CurrentVersion\Policies\System

Here if you find a registry key DisableTaskMgr, simply delete the key, or set its value to 0.

https://www.thewindowsclub.com/task-manager-not-opening-disabled-by-administrator

1. Download sysinternals suite from microsoft technet and unpack.
2. Find and run procexp.exe.
3. Click in Options menu on Replace Task Manager and than Restore Task Manager.
4. Click Ctrl+Alt+Del or on taskbar Run Taskmanager. Settings are restored and MS Taskmanager works fine. Because of my habit I can´t work without sysinternals.

https://superuser.com/questions/271351/cant-open-task-manager

Other things you could try to fix the issue:

1. Malware may prevent opening of Task Manager. So you may want to clear your PC junk files and then run a full or deep scan with your antivirus or security software.

2. Check this post on Folder Options Missing, Task Manager Disabled, Regedit Disabled.

3. Run System File Checker by running sfc /scannow and see if it helps you.

4. Use our free tool FixWin to fix this problem of Task Manager not opening, easily.

5. Try Remove Restrictions Tool or Re-Enable to re-enable your Task Manager.

If all fails, you may have to do a Repair Install Windows 7 or Reset Windows 10. If that is not an option you’d like to consider, you can use Process Explorer from Sysinternals or Customized Task Manager from TechNet to achieve the same purpose.

sfc /scannow

findstr /c:"[SR]" %windir%\logs\cbs\cbs.log >sfcdetails.txt

Napravite sopstveni kompajler i interpreter unutar svoje Lazarus ili Delphi aplikacije

http://wiki.lazarus.freepascal.org/Pascal_Script

http://wiki.lazarus.freepascal.org/Pascal_Script_Examples

Tako je nastao i čuveni Inno Setup Compiler:

https://beogradsko.blogspot.com/p/moj-blog.html

10

Pelles C Compiler, besplatan razvojni sistem u C programskom jeziku, nezavistan od Microsofta

http://www.smorgasbordet.com/pellesc/

http://www.pellesc.de/index.php%3Fpage%3Ddownload

Other C compiler, Orange C Compiler:

http://www.members.tripod.com/~ladsoft/orange_c_compiler.html

---

Sasvim druga varjanta je upotreba super poznatog GCC MING okruženja (ili Cygwin koje je mnogo manje zastupljeno):

https://gcc.gnu.org/

http://www.mingw.org/

ONLY OFFICE, zlatan softver iz zlatnog grada Rige, Latvia

https://www.onlyoffice.com/download-desktop.aspx

Besplatna zamena za Microsoft Word:

Zamena za Microsoft Excel:

Zamena za Microsoft PowerPoint:

Zaboravite Open Office, Libre Office, kineski WPS Kingsoft Office (koji je pun reklama i kineskih bug-ova, a pri copy - paste kopira ponekad kineska slova i tamo gde je UTF-8 nekog drugog jezika). 

Zvezda je rodjena, ovo je najkompatibilniji OFFICE u poredjenju sa Microsoft Office koji smo ikada probali.

Odličan program, odličan posao su uradili programeri iz Rige.
Aplikacija ONLY OFFICE je uradjen kombinacijom C++, HTML-a, JavaScript-a i CSS-a.

OnlyOffice

Developer(s)	Ascensio System SIA
Stable release	9.6.2 / 17 July 2018; 3 months ago
Written in	HTML, JavaScript, C++
Operating system	Windows XP and later, Linux, Mac OS
Available in	21 languages
Type	Office Suite, Project management, Collaboration, CRM, Document Management
License	AGPLv3

Veoma kvalitetan i moderan internet pregledač

https://brave.com/

Probali smo ovaj veoma obećavajući browser (internet pregledač) i veoma je koristan.

Daje mnoštvo informacija o internet saobraćaju, blokiranim i dozvoljenim sadržajima, a ima i razne druge korisne gadžete na raspolaganju, koje još nismo videli u drugim sličnim aplikacijama.

Iza ove aplikacije stoji zavidan i impozantno veliki tim stručnjaka, a sam sajt je veoma profesionalno i grafički uradjen.

Svaka preporuka.

Ukoliko Vi imate da reklamirate neki svoj proizvod ili slične sadržaje, blogove i sajtove slobodno me kontaktirajte.

Biti blogger broj jedan u Srbiji ?

Moram ovih dana da kontaktiram ...

http://www.bloggersnetwork.org.rs/kontakt/

http://www.draganvaragic.com/blog/coca-cola-system-pokrece-akciju-povecanja-kapaciteta-oglasavanja-na-blogovima-u-regionu/

http://mladenstojanovic.net/sponzori/

Pored navedenog važna je procena posećenosti bloga i vidljivost vlasnika bloga na društvenim mrežama (tzv. Social Media Authority). Sve prethodno uzevši u obzir, odabrani su sledeći blogeri po državama:

Srbija

• Maja Petrović, www.vitkigurman.com
• Poznati blog na temu zdrave ishrane i nutricionizma.
• Marija Petrović, http://palachinkablog.com
  Vodi cenjeni kulinarski blog na srpskom i engleskom jeziku.
• Mirjana Mimica, http://mahlat.rs/
  Poznati blog i vidljiv u online zajednici preko aktivnih naloga blogerke na društvenim mrežama.

Crna Gora

• Vladimir Vulić, http://digitalizuj.me/
  Regionalno najpoznatiji bloger u Crnoj Gori.

Makedonija

•  Darko Buldioski, http://komunikacii.net/
  Regionalno najpoznatiji bloger u Makedoniji.

Nakon objavljivanja tekstova blogera, kompanija Coca-Cola System će dodatno promovisati te blog postove preko sopstvenih online resursa, što će direktno uticati na povećanje generalne posećenosti blogova u ovoj mreži.

Ukoliko Vi imate da reklamirate neki svoj proizvod ili slične sadržaje, blogove i sajtove slobodno me kontaktirajte.

---

Pljeskavica, cevapcici, palacinke, torta, reforma, sneokle, minjoni, kobasice, kobasica, kobasicijada, slanina, slaninijada, paprikas, fispaprikas, gulas, gulash, paprikash, cevap, burek, pita, meze, sljivovica, rakija, prepecenica, medovina, komovica, lozovaca, zozovaca, pile, pilici, lidl, majmuni, jaja, kivi, ananas, banane, kafa, kavfe, kuvarica kuvar, kuhinja.

---

***

NASTAVAK ... SLEDI ... -------------odje--------->>>>>>

Biznis na internetu WooCommerce

https://woocommerce.com/posts/woocommerce-requires-wordpress-account/

Ву комерц + Вордпресс 

Ву комерц ради слично као Вордпресс, па ако знате да радите у Вордпрессу, знаћете да уређујете стране и у Ву комерцу. Ву комерц је идеалан за електронске продавнице које се у све већем броју отварају на виртуелном тржишту Србије.

MORE TIPS:

https://sourceforge.net/projects/alphaos/files/

Probajte AlphaOS, s obzirom na autora koji je poznat kao kreator Slax-a, ovaj live distro je nastao od A linuxa.

Алфа ОС

Алфа ОС је једноставан и минималистички лајв ЦД линукс који је настао на Арк платформи, а један од аутора је и чувени Tomáš Matějíček, који је направио предивни Слакс лајв Цд линукс.

То све пуно обећава, тако да нећете погрешити ако почнете да користите овај оперативни систем као додатну брзу замену за гломазни Виндовс, при чему не морате да га се одричете.

Као и све лајв линукс дистрибуције и ова функционише без ангажовања хард диска, тако да је главни оперативни систем који користите апсолутно сигуран, а Алфа ОС не морате да инсталирате, једноставно га бутујете и користите, а после рестарта уколико није убачен његов ЦД бутује се нормално Виндовс матични ОС.

Куриозитет Алфа ОС оперативног система је да се учитава у простор у РАМ меморији који износи симболично минорних 70 мегабајта, при чему цео оперативни систем на ЦД-у заузима само 200 мегабајта, па може да стане на Мини ЦД.

Ukoliko Vi imate da reklamirate neki svoj proizvod ili slične sadržaje, blogove i sajtove slobodno me kontaktirajte.

AlphaOS is a simple and minimalistic Linux distribution for the x86-64 architecture, built using Linux Live Kit set of scripts developed by Tomáš Matějíček, the developer of the popular Slax Linux distribution. But, unlike Slax, alphaOS is based on Arch Linux and uses pacman as the default package manager. This operating system features highly configurable and lightweight Openbox window manager. Modular by design, alphaOS makes it easy to add desired functionality.

Features

• Standard iso image in about 200 MB
• Full access to additional software packages from Arch Linux
• Openbox window manager
• Lightweight, on boot uses only 70MB of RAM
• *
• 
  

Java is to JavaScript what Car is to Carpet

Why Use JavaScript If It Cannot Be Relied On?

As I just mentioned, just because it may not always be available doesn’t mean that JavaScript
shouldn’t be used at all. It should simply not be the only means of user interaction.
The merits of using JavaScript are
• Less server interaction: You can validate user input before sending the page off to the
server. This saves server traffic, which means saving money.
• Immediate feedback to the visitors: They don’t have to wait for a page reload to see if
they have forgotten to enter something
• Automated fixing of minor errors: For example, if you have a database system that
expects a date in the format dd-mm-yyyy and the visitor enters it in the form dd/mm/yyyy,
a clever JavaScript script could change this minor mistake prior to sending the form to the
server. If that was the only mistake the visitor made, you can save her an error message—
thus making it less frustrating to use the site.
• Increased usability by allowing visitors to change and interact with the user interface
without reloading the page: For example, by collapsing and expanding sections of the
page or offering extra options for visitors with JavaScript. A classic example of this would
be select boxes that allow immediate filtering, such as only showing the available destinations
for a certain airport, without making you reload the page and wait for the result.
• Increased interactivity: You can create interfaces that react when the user hovers over
them with a mouse or activates them via the keyboard. This is partly possible with CSS
and HTML as well, but JavaScript offers you a lot wider—and more widely supported—
range of options.
• Richer interfaces: If your users allow for it, you can use JavaScript to include such items
as drag-and-drop components and sliders—something that originally was only possible
in thick client applications your users had to install, such as Java applets or browser
plug-ins like Flash.
• Lightweight environment: Instead of downloading a large file like a Java applet or a
Flash movie, scripts are small in file size and get cached (held in memory) once they
have been loaded. JavaScript also uses the browser controls for functionality rather than
its own user interfaces like Flash or Java applets do. This makes it easier for users, as they
already know these controls and how to use them. Modern Flash and Macromedia Flex
applications do have the option to stream media and—being vector based—are visually
scalable, something JavaScript and HTML controls aren’t. On the other hand, they
require the plug-in to be installed.

Christian Heilmann

Foreword by Simon Willison,

Technology Development at Yahoo!

***

There has never been a more exciting time to learn JavaScript. It may be a cliché, but it’s
certainly true. After years spent banished in a wilderness of browser wars and false promises,
JavaScript has finally emerged as an essential part of any web developer’s toolbox. No longer
just a vehicle for ads and annoyances, it is now a valuable component of the next generation of
web applications.

What has caused this sudden rush of interest? The first reason is purely practical: browser
improvements have finally made it viable to write cross-browser JavaScript with some certainty
that it will actually work. The second is more revolutionary: Ajax, an old technique with a new
name that enables client-side code to communicate directly with a server without refreshing
the whole page. This simple ability has thrown web application development wide open,
enabling new, innovative interfaces and dramatically altering user expectations of how web
interfaces can behave.

This adoption has been helped by the growing realization that JavaScript is not a toy
language. 

Despite its numerous warts, beneath its deceptively simple exterior lie a host of
powerful features not seen in many mainstream languages: closures, prototypal inheritance,
and extensive support for the functional programming style. That such a flexible language is
now installed on hundreds of millions of computers is a cause for celebration in itself.

Just because you can do something doesn’t mean that you should. Not all browsers are
born equal, and accessibility (both for people and for alternative devices) remains an essential
aspect of developing for the Web. Understanding the issues and techniques around progressive
enhancement is an important part of the JavaScript learning curve.

The set of challenges posed by JavaScript development is huge.

Browsers frequently deviate from what standard specifications there are, and pseudostandards
are common and frequently unavoidable.

Ambitious new applications are uncovering browser bugs that have laid dormant for years.

The complexity of those applications is itself a problem, introducing new problems related to
maintaining large code bases.

Thankfully, the global JavaScript community has risen to the challenge. A wealth of
code and resources awaits the intrepid developer, but the value of this treasure trove can be
unlocked only through a solid understanding of the underlying platform. This book will provide
you with that knowledge.

As a long-standing teacher and leader in that community, Christian is the ideal guide to
this intricate world. This book comprises accumulated wisdom obtainable only through years
of experience.

Christian will teach you to apply JavaScript tastefully, responsibly, and elegantly in a way
that will delight your users and impress your peers.

Simon Willison

Technology Development at Yahoo!

The different layers of web development

• The behavior layer: Is executed on the client and defines how different elements behave

when the user interacts with them (JavaScript or ActionScript for Flash sites).

• The presentation layer: Is displayed on the client and is the look of the web page (CSS,

imagery).

• The structure layer: Is converted or displayed by the user agent. This is the markup

defining what a certain text or media is (XHTML).

• The content layer: Is stored on the server and consists of all the text, images, and multimedia

content that are used on the site (XML, database, media assets).

• The business logic layer (or back end): Runs on the server and determines what is done

with incoming data and what gets returned to the user.

PREDIVAN ODLOMAK IZ KNJIGE:


Beginning JavaScript
with DOM Scripting
and Ajax
From Novice to Professional
■ ■ ■
Christian Heilmann

Ono što mnogi previde je da JavaScript funkcioniše prvenstveno na klijentskom kompjuteru u browseru, ali mnogi ne znaju da postoji verzija ovog jezika koja radi na serveru i u poslednje vreme su ovi programeri posebno traženi (Vue, REACTJS, Angular...)

Ukoliko Vi imate da reklamirate neki svoj proizvod ili slične sadržaje, blogove, knjige i sajtove slobodno me kontaktirajte.

---

***

MySQl, Excel, SQlite

26 slova engleskih
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z

CREATE TABLE excel (
A VARCHAR(40),
B VARCHAR(40),
C VARCHAR(40),
D VARCHAR(40),
E VARCHAR(40),
F VARCHAR(40),
G VARCHAR(40),
H VARCHAR(40),
I VARCHAR(40),
J VARCHAR(40),
K VARCHAR(40),
L VARCHAR(40),
M VARCHAR(40),
N VARCHAR(40),
O VARCHAR(40),
P VARCHAR(40),
Q VARCHAR(40),
R VARCHAR(40),
S VARCHAR(40),
T VARCHAR(40),
U VARCHAR(40),
V VARCHAR(40),
W VARCHAR(40),
X VARCHAR(40),
Y VARCHAR(40),
Z VARCHAR(40)
);

studenti.db
Select * FROM isplata where iznos>0
rb, oznaka, ime, adresa, iznos, broj_racuna


="UPDATE ispalata SET oznaka = 1, ime='"&C2&"', iznos='"&F2&"', broj_racuna='"&E2&"' WHERE rb=1;"

="UPDATE isplata SET oznaka = '"&A2&"', ime='"&C2&"', iznos='"&F2&"', broj_racuna='"&E2&"' WHERE rb=1;"


="UPDATE isplata SET oznaka = '"&A6&"', ime='"&B6&"', iznos='"&G6&"', broj_racuna='"&F6&"', adresa='"&C6&"' WHERE rb=1;"

="UPDATE isplata SET oznaka = '"&A2&"-"&B2&"', ime='"&C2&"', iznos='"&J2&"', broj_racuna='"&H2&"' WHERE rb=1;"



xxx-xxxxxxxx-xx



="INSERT INTO table_name VALUES('"&A1&"','"&B1&"','"&C1&"')"

INSERT INTO tbl_sample(first_name, last_name) VALUES('ime','prezime');


tbl_sample(first_name, last_name

CREATE TABLE IF NOT EXISTS eksel2 (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  c01 text NULL,
  c02 text NULL,
  c03 text NULL,
  c04 text NULL,
  c05 text NULL,
  c06 text NULL,
  c07 text NULL,
  c08 text NULL,
  c09 text NULL,
  c10 text NULL,
  c11 text NULL,
  c12 text NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;




INSERT INTO eksel2(c01,c02,c03,c04,c05,c06,c07,c08,c09,c10,c11,c12) VALUES('1','2','3','4','5','6','7','8','9','10','11','12');


SQLite...:


CREATE TABLE `godisnji` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`ime` VARCHAR(40),
`jmbg` VARCHAR(13),
`po_osnovu_doprinosa_na_radu` INTEGER,
`po_osnovu_strucne_spreme` INTEGER,
`po_osnovu_godina_rada` INTEGER,
`po_osnovu_uslova_rada` INTEGER,
`po_osnovu_brige_o_deci` INTEGER,
`broj_maloletnih` INTEGER,
`broj_dece_do_14god` INTEGER,
`adresa` VARCHAR(80),
`telefon` VARCHAR(40),
`napomena` VARCHAR(80),
`datum_donosenja_resenja` VARCHAR(10),
`ukupno` INTEGER
);



CREATE TABLE `putnik` (
`oznaka` TEXT,
`ime` TEXT,
`ADRESA` TEXT,
`RODITELJ` TEXT,
`JMBG` TEXT,
`SKOLA` TEXT,
`GRAD` TEXT,
`relacija` INTEGER,
`naziv_relacije` TEXT,
`prvi_mesec` INTEGER,
`drugi_mesec` INTEGER,
`iznos` REAL,
`broj_racuna` TEXT,
`procenat` INTEGER,
`prvi_iznos` REAL,
`drugi_iznos` REAL
);


CREATE TABLE `osnovna_sredstva` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`naziv` VARCHAR(80),
`inventarski_broj` VARCHAR(20),
`serijski_broj` VARCHAR(80),
`model` VARCHAR(40),
`windows_key` VARCHAR(80),
`opis` VARCHAR(2000),
`sadrzaj` VARCHAR(2000),
`napomena` VARCHAR(200),
`vrednost` REAL,
`amortizacija` REAL,
`datum` VARCHAR(20),
`proizvodjac` VARCHAR(80),
`javna_nabavka` VARCHAR(200),
`revers` VARCHAR(200),
`trebovanje` VARCHAR(200),
`odgovorna_osoba` VARCHAR(60),
`storno` VARCHAR(40)
);



CREATE TABLE `finansije-glavna-knjiga` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`naslov` VARCHAR(80),
    `duguje` REAL,
    `potrazuje` REAL,
    `saldo` REAL,
`konto` VARCHAR(20),
`partner-kupac-dobavljac` VARCHAR(40),
`napomena` VARCHAR(1000),
`datum` VARCHAR(10),
`storno` VARCHAR(10)

);

CREATE TABLE `kontni-plan` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`sifra-konta` VARCHAR(20),

`naziv-konta` VARCHAR(80)

);

CREATE TABLE `partner` (
`rb` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`sifra-partnera` VARCHAR(40),

`naziv-partnera` VARCHAR(80)

);

PRIMER praćenja sopstvenih troškova u prodavnici:

https://sr.wikipedia.org/sr-el/Dvojno_knjigovodstvo

http://informax.serveftp.com/progtools.asp