-- Alter F.0.0.2 Limitni dug
--
-- Definition for table klijenti_uplate : 
--

CREATE TABLE [dbo].[klijenti_uplate] (
  [id] bigint IDENTITY(1, 1) NOT NULL,
  [sifra] nchar(40) COLLATE Croatian_CI_AI CONSTRAINT [DF_klijenti_uplate_sifra] DEFAULT '' NOT NULL,
  [opis_klienta] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [datum_uplate] datetime DEFAULT 0 NOT NULL,
  [datum_unosa] datetime DEFAULT 0 NOT NULL,
  [pla_id] nvarchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pla_1] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pla_2] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pla_3] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pla_sif_val] nvarchar(5) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pla_iznos_uplate] decimal(18, 2) DEFAULT 0 NOT NULL,
  [pla_iban] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_1] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_2] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_3] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_iban] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_model] nvarchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_poziv_broj] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_sifra_namjene] nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_opis_1] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_opis_2] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [pri_opis_3] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [datum_izvrsenja] datetime DEFAULT 0 NOT NULL,
  [int_1] int DEFAULT 0 NOT NULL,
  [int_2] int DEFAULT 0 NOT NULL,
  [iznos_1] decimal(18, 2) DEFAULT 0 NOT NULL,
  [iznos_2] decimal(18, 5) DEFAULT 0 NOT NULL,
  [datum_1] datetime DEFAULT 0 NOT NULL,
  [note_1] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [note_2] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [status] nvarchar(1) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL
)
ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [klijenti_trosenje_idx] ON [dbo].[klijenti_trosenje]
  ([sifra])
GO


--
-- Definition for table klijenti_trosenje : 
--

CREATE TABLE [dbo].[klijenti_trosenje] (
  [id] bigint IDENTITY(1, 1) NOT NULL,
  [sifra] nchar(40) COLLATE Croatian_CI_AI CONSTRAINT [DF_klijenti_trosenje_sifra] DEFAULT '' NOT NULL,
  [opis_klienta] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [iznos_raspoloziv] decimal(18, 2) DEFAULT 0 NOT NULL,
  [dozvoljen_dug] decimal(18, 2) DEFAULT 0 NOT NULL,
  [promjena_datum] datetime DEFAULT 0 NOT NULL,
  [promjena_vrijeme] datetime DEFAULT 0 NOT NULL,
  [datum_vrijeme_vrijedi] datetime DEFAULT 0 NOT NULL,
  [iznos_dnevni_limit] decimal(18, 2) DEFAULT 0 NOT NULL,
  [jednom_dnevno] nvarchar(2) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [osoba_odgovorna] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [osoba_email] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [osoba_adresa] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [osoba_mjesto] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [int_1] int DEFAULT 0 NOT NULL,
  [int_2] int DEFAULT 0 NOT NULL,
  [iznos_1] decimal(18, 2) DEFAULT 0 NOT NULL,
  [iznos_2] decimal(18, 5) DEFAULT 0 NOT NULL,
  [datum_1] datetime DEFAULT 0 NOT NULL,
  [note_1] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [note_2] nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
  [status] nvarchar(1) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL
)
ON [PRIMARY]
GO