--cjenici,dnevni_racuni,stavke_dokumenata,stavke_narudzbe
--	char szRoba[32];
--	char szRobaDuzi[122];
--
ALTER TABLE [dbo].[dnevni_racuni]
DROP CONSTRAINT [DF_dnevni_racuni_roba_1]
GO

ALTER TABLE [dbo].[dnevni_racuni]
ALTER COLUMN [roba] char(30) COLLATE Croatian_CI_AI NOT NULL
GO

ALTER TABLE [dbo].[dnevni_racuni]
ADD CONSTRAINT [DF_dnevni_racuni_roba_1] DEFAULT ' ' FOR [roba]
GO
--
ALTER TABLE [dbo].[dnevni_racuni]
DROP CONSTRAINT [DF_dnevni_racuni_roba_duzi_naziv_1]
GO

ALTER TABLE [dbo].[dnevni_racuni]
ALTER COLUMN [roba_duzi_naziv] char(120) COLLATE Croatian_CI_AI NOT NULL
GO

ALTER TABLE [dbo].[dnevni_racuni]
ADD CONSTRAINT [DF_dnevni_racuni_roba_duzi_naziv_1] DEFAULT ' ' FOR [roba_duzi_naziv]
GO
--
ALTER TABLE [dbo].[stavke_narudzbe]
DROP CONSTRAINT [DF_stavke_narudzbe_roba_1]
GO

ALTER TABLE [dbo].[stavke_narudzbe]
ALTER COLUMN [roba] char(30) COLLATE Croatian_CI_AI NOT NULL
GO

ALTER TABLE [dbo].[stavke_narudzbe]
ADD CONSTRAINT [DF_stavke_narudzbe_roba_1] DEFAULT ' ' FOR [roba]
GO
--
ALTER TABLE [dbo].[stavke_narudzbe]
DROP CONSTRAINT [DF_stavke_narudzbe_roba_duzi_naziv_1]
GO

ALTER TABLE [dbo].[stavke_narudzbe]
ALTER COLUMN [roba_duzi_naziv] char(120) COLLATE Croatian_CI_AI NOT NULL
GO

ALTER TABLE [dbo].[stavke_narudzbe]
ADD CONSTRAINT [DF_stavke_narudzbe_roba_duzi_naziv_1] DEFAULT ' ' FOR [roba_duzi_naziv]
GO
--
ALTER TABLE [dbo].[stavke_dokumenata]
DROP CONSTRAINT [DF_stavke_dokumenata_roba_1]
GO

ALTER TABLE [dbo].[stavke_dokumenata]
ALTER COLUMN [roba] char(30) COLLATE Croatian_CI_AI NOT NULL
GO

ALTER TABLE [dbo].[stavke_dokumenata]
ADD CONSTRAINT [DF_stavke_dokumenata_roba_1] DEFAULT ' ' FOR [roba]
GO
--
ALTER TABLE [dbo].[stavke_dokumenata]
DROP CONSTRAINT [DF_stavke_dokumenata_roba_duzi_naziv_1]
GO

ALTER TABLE [dbo].[stavke_dokumenata]
ALTER COLUMN [roba_duzi_naziv] char(120) COLLATE Croatian_CI_AI NOT NULL
GO

ALTER TABLE [dbo].[stavke_dokumenata]
ADD CONSTRAINT [DF_stavke_dokumenata_roba_duzi_naziv_1] DEFAULT ' ' FOR [roba_duzi_naziv]
GO
--
ALTER TABLE [dbo].[cjenici]
DROP CONSTRAINT [DF_cjenici_roba]
GO

DROP INDEX [IX_cjenici_2] ON [dbo].[cjenici]
GO

ALTER TABLE [dbo].[cjenici]
ALTER COLUMN [roba] char(30) COLLATE Croatian_CI_AI NOT NULL
GO

ALTER TABLE [dbo].[cjenici]
ADD CONSTRAINT [DF_cjenici_roba] DEFAULT ' ' FOR [roba]
GO

CREATE NONCLUSTERED INDEX [IX_cjenici_2] ON [dbo].[cjenici]
  ([sifra_blagajne], [roba])
WITH (
  PAD_INDEX = OFF,
  FILLFACTOR = 90,
  DROP_EXISTING = OFF,
  STATISTICS_NORECOMPUTE = OFF,
  SORT_IN_TEMPDB = OFF,
  ONLINE = OFF,
  ALLOW_ROW_LOCKS = ON,
  ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
--
ALTER TABLE [dbo].[cjenici]
DROP CONSTRAINT [DF_cjenici_roba_duzi_naziv]
GO

ALTER TABLE [dbo].[cjenici]
ALTER COLUMN [roba_duzi_naziv] char(120) COLLATE Croatian_CI_AI NOT NULL
GO

ALTER TABLE [dbo].[cjenici]
ADD CONSTRAINT [DF_cjenici_roba_duzi_naziv] DEFAULT ' ' FOR [roba_duzi_naziv]
GO
--