Sistem.SirketOlustur — ERPGOLD Wiki

Tip: STORED PROCEDURE · Şema: Sistem · Modül: MOD-SISTEM · Temizlik sınıfı: UNUSED_HIGH_CONFIDENCE (kategori E, güven 95) · Kapsam: ERPGOLD_CORE / ALL
Kullanım haritası (13.09.2026)

Kategori	F — MANUAL REVIEW · `F-POSSIBLE_JOB_OR_MANUAL_TOOL`
Güven	50
Gerekçe	Referanssız yordam: SQL Agent job / bakım aracı / kurulum betiği olabilir; msdb kontrol edilemedi (Express: Agent yok; üretim Standard). ERPGOLD kodunda, DB içi rapor/tasarım SQL'inde (V2 demo), dinamik SQL kalıplarında, tetikleyici/FK/computed/cross-db bağlarında ve gerekli nesnelerin bağımlılık grafında referans yok
Dinamik SQL	Bu modül dinamik SQL kuruyor (EXEC/sp_executesql) — bağımlılıkları metadata’da eksik olabilir
Bkz. Database Usage Map · Manual Review. Hiçbir DB değişikliği yapılmadı; SAFETY > CLEANUP.
Temizlik kanıtı

Kontrol	Sonuç
app	NO
report	NO
config	NO
dynamic	NO
db_in	NO
db_out	YES
trigger	NO
fk	NO
computed	NO
crossdb	NO
runtime	UNKNOWN
external	NO
Gerekçe: Hiçbir kaynakta referans bulunamadı
KB-v1 gövdesi (2026-09-10 · kısmi kod kapsamı — kaynağı kadar güvenilir)

Tür: PROCEDURE (P) · Modül: MOD-SISTEM · Uzunluk: 36 satır
Özet

Yeni şirket kurulumu — AifaDev/Design dışındaki tüm tabloları TRUNCATE eder, veritabanını küçültür, sonra yeni Şirket/Şube/ADMIN kullanıcısı/Administrator yetki grubunu oluşturur. Yıkıcı kurulum aracıdır.
Parametreler

#	Parametre	Tip	Çıktı
1	@Sirket	nvarchar
2	@SubeAdi	nvarchar
Bağımlılıklar (bu nesne → hedef)

İlişki	Hedef	Tip
WRITES	Sistem.Sirketler	TABLE
WRITES	Sistem.Subeler	TABLE
WRITES	Sistem.UserDetails	TABLE
WRITES	Sistem.UserGroup	TABLE
WRITES	Sistem.Users	TABLE
İlgili iş kuralları

Tüm iş tablolarını TRUNCATE eder, DBCC SHRINK yapar, ardından Sirketler/Subeler/Users(ADMIN)/UserDetails/UserGroup ekler (Sistem.SirketOlustur.md)
ADMIN kullanıcısının parolası koda gömülü sabittir — [REDACTED_SECRET] (Sistem.SirketOlustur.md)
Şube eklenince Sistem.CreateKasa tetikleyicisi ANAKASA açar (Sistem.CreateKasa.md)
SQL tanımı (AS-IMPLEMENTED, örnek DB)

CREATE Proc [Sistem].[SirketOlustur](@Sirket Nvarchar(MAx),@SubeAdi Nvarchar(MAx))
as

declare @tblname nvarchar(max) 
declare tbl_cursor cursor for select S.name + '.' + T.name as Name from sys.tables T Left Join sys.schemas S on T.schema_id =S.schema_id Where S.Name<>'AifaDev' And S.Name<>'Design'  Order By S.Name,T.Name 
open tbl_cursor
fetch next from tbl_cursor into @tblname
while @@FETCH_STATUS = 0
begin
Declare @Query nvarchar(max)='truncate table ' + @tblname
    exec (@Query) 
Print @Query
    fetch next from tbl_cursor into @tblname
end 
close tbl_cursor
deallocate tbl_cursor 

DECLARE @dbName VARCHAR(50)=DB_NAME()
DECLARE @logName VARCHAR(50)=''
SELECT @logName = name FROM sys.master_files WHERE database_id = db_id() AND type = 1

DBCC SHRINKDATABASE(@dbName,1 )
Print @dbName + ' Temizlendi.!'
DBCC SHRINKFILE(@logName,1)
Print @dbName + '_Log Temizlendi.!'



INSERT INTO Sistem.Sirketler(Kodu,Aciklama,UserId) Values(@Sirket,@Sirket + ' SIRKETI' ,0)
INSERT INTO Sistem.Subeler(OwnerId,Kodu,Aciklama,BilancoBirimId,Sermaye,SermayeBirimId ,SubeGrubu,SubeTuru,SubeTipi ,SirketId ,UserId ) 
Values(0,@SubeAdi, @SubeAdi + ' SUBESI',1,0,1,'GENEL','TICARI BIRIM','GENEL',1,0)
INSERT INTO Sistem.Users (RefNo,SirketId,UserName,Password ,Email ,Gsm ,UserId ,PersonelId,IsActive ) 
Values(Upper(NEWID()),1,'ADMIN','[REDACTED_SECRET]','','',0,0,1)
INSERT INTO Sistem.UserDetails(UserId ,SubeId,GroupId ,KasaId,IsLocked) Values(1,1,1,1,0)
INSERT INTO Sistem.UserGroup(SirketId,GroupName,Permission,UserId ) values(1,'Administrator','084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101059084114117101124065105102097032068101118101108111112101114032083116117100105111059068101118101108111112101114032084111111108115059083113108032083101114118101114124065105102097032068101118101108111112101114032083116117100105111059068101118101108111112101114032084111111108115059070111114109032068101115105103110101114124065105102097032068101118101108111112101114032083116117100105111059068101118101108111112101114032084111111108115059068097115104098111097114100032068101115105103110101114124065105102097032068101118101108111112101114032083116117100105111059068101118101108111112101114032084111111108115059082105098098111110032068101115105103110101114124065105102097032068101118101108111112101114032083116117100105111059068101118101108111112101114032084111111108115059080111112117112032071114105100032068101115105103110124065105102097032068101118101108111112101114032083116117100105111059068101118101108111112101114032084111111108115059082101112111114116032068101115105103110101114124065105102097032068101118101108111112101114032083116117100105111059083101114118105099101115059065103101110116032083101114118105099101115124065105102097032068101118101108111112101114032083116117100105111059083101114118105099101115059067111110116114111108108101114032083101114118105099101115124065105102097032068101118101108111112101114032083116117100105111059083101114118105099101115059086097108105100097116111114032083101114118105099101115124065105102097032068101118101108111112101114032083116117100105111059083101114118105099101115059065099099111117110116032067111110116114111108032083101114118105099101115124068111118105122032070097116117114097059070097116117114097032084097110253109108097114253059077252254116101114105032075097114116108097114253124068111118105122032070097116117114097059070097116117114097032084097110253109108097114253059070097116117114097032221254108101109108101114105124068111118105122032070097116117114097059070097116117114097032084097110253109108097114253059072097114099097109097032070105254108101114105124068111118105122032070097116117114097059070097116117114097032084097110253109108097114253059077097100101110032083116111107108097114105124068111118105122032070097116117114097059070097116117114097032084097110253109108097114253059078097107105116032083116111107108097114253124068111118105122032070097116117114097059070097116117114097032084097110253109108097114253059071117110032083111110117032082097112111114117124070111114109108097114059068101110101116105109032070111114109108097114253059076105109105116032065254253109253124070111114109108097114059068101110101116105109032070111114109108097114253059066097107105121101032068101118105114032072253122253124070111114109108097114059068101110101116105109032070111114109108097114253059068101110101116105109032077252116097098097107097116124070111114109108097114059068101110101116105109032070111114109108097114253059075097116101103111114105108101114124070111114109108097114059071101110101108032070111114109108097114059221115116105104098097114097116032070111114109117124070111114109108097114059071101110101108032070111114109108097114059078097107105116032080108097110108097109097124070111114109108097114059071101110101108032070111114109108097114059066105114105109032078097107105116032084097108101112032070111114109117124070111114109108097114059071101110101108032070111114109108097114059065110097075097115097032070111114109117124070111114109108097114059071101110101108032070111114109108097114059085115116032076105109105116124070111114109108097114059071101110101108032070111114109108097114059073115116097116105115116105107032075111100108097114105124072101115097112032089111110101116105109105059065121097114108097114059075117114032071105114105115032069107114097110253124072101115097112032089111110101116105109105059065121097114108097114059083105115116101109032089101110105108101124072101115097112032089111110101116105109105059065121097114108097114059071117110099101108108101254116105114109101108101114105032068101110101116108101124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059067097114105032221254108101109108101114124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059072101115097112108097114124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059077097115116101114124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059070097116117114097108097114124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059080114111102111114109097124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059084114097110115102101114108101114124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059071101108101110032075117116117115117124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059071105100101110032075117116117115117124072101115097112032089111110101116105109105059067097114105032072101115097112108097114059065110108253107032070105121097116108097114124072101115097112032089111110101116105109105059068111118105122032070097116117114097059083101114105032070097116117114097032075101115105109105124072101115097112032089111110101116105109105059068111118105122032070097116117114097059083101114105032070097116117114097032089097122100253114124072101115097112032089111110101116105109105059077101115097106108097254109097059070097099101098111111107032067104097116124072101115097112032089111110101116105109105059077101115097106108097254109097059083107121112101032067104097116124072101115097112032089111110101116105109105059077101115097106108097254109097059069082080032067104097116124072101115097112032089111110101116105109105059079102102105099101059065105087111114100032068111099117109101110116124072101115097112032089111110101116105109105059079102102105099101059065105069120099101108032068111099117109101110116124072101115097112032089111110101116105109105059079102102105099101059065105080100102032086105101119101114124072101115097112032089111110101116105109105059079102102105099101059065105073110116101114110101116032066114111119115101114124072101115097112032089111110101116105109105059079102102105099101059072101115097112032077097107105110097115253124072101115097112032089111110101116105109105059079102102105099101059084097107118105109124072101115097112032089111110101116105109105059082097112111114059077097114103105110032067111110116114111108124072101115097112032089111110101116105109105059082097112111114059080111122105115121111110124072101115097112032089111110101116105109105059082097112111114059066105108097110099111032082097112111114117124072101115097112032089111110101116105109105059082097112111114059080097116114111110032066105108097110099111115117124072101115097112032089111110101116105109105059082097112111114059080105110032075111100117124072101115097112032089111110101116105109105059083116111107108097114059077097100101110032083116111107032076105115116101115105124072101115097112032089111110101116105109105059083116111107108097114059078097107105116032083116111107032076105115116101115105124072101115097112032089111110101116105109105059083116111107108097114059084097107111122032083116111107032076105115116101115105124072101115097112032089111110101116105109105059083116111107108097114059077111100101108032083116111107108097114253124072101115097112032089111110101116105109105059083116111107108097114059080253114108097110116097032083116111107108097114253124072101115097112032089111110101116105109105059083116111107108097114059071101110101108032083116111107108097114124072101115097112032089111110101116105109105059083116111107108097114059084097115032083116111107108097114253124072101115097112032089111110101116105109105059083116111107108097114059069109116105097032083116111107108097114105124072101115097112032089111110101116105109105059083116111107108097114059084097107111122032083111110117231032071105114105254105124072101115097112032089111110101116105109105059083116111107108097114059084097107111122032075111110116114111108032076105115116101115105124072101115097112032089111110101116105109105059083116111107108097114059084097107111122032083117032084097114116253115253124072101115097112032089111110101116105109105059084104101109097059084101109097032083101099105109105124072101115097112032089111110101116105109105059084104101109097059082101110107032068101240105254116105114124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059079114103097110105122097115121111110108097114124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059221254032071101108105254116105114109101032084097107105112032083105115116101109105124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059071246114101118032084097107105112032083105115116101109105124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059084097108101112032084097107105112032083105115116101109105124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059079110097121032084097107105112032083105115116101109105124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059066097110107097032084097110253109108097109097124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059065108116253110032084111112108097109097032079112101114097115121111110108097114105124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059065108116253110032084111112108097109097032073115108101109108101114105124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059083097116253110032065108109097032084097108101112108101114105124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059070105121097116032065114097254116253114109097124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059083097116253110032065108109097032083105112097114105254108101114105124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059083097116253110032065108109097032070097116117114097108097114253124079112101114097115121111110108097114059079112101114097115121111110101108032070097097108105121101116108101114059083097116253110097108109097032079110097121032071114117098108097114253124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059080101114115111110101108032075097114116108097114253124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059080101114115111110101108032073122105110032076105115116101115105124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059090105109109101116032076105115116101115105124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059080101114115111110101108032084097108101112032076105115116101115105124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059077097097115032076105115116101115105124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059080101114115111110101108032084097110253109108097109097032083105115116101109105124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059083071075032077101115108101107105032075111100108097114124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059083071075032067253107253115032075111100108097114253124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059073083075085082032067253107253115032075111100108097114253124080101114115111110101108032089111110101116105109105059080101114115111110101108032084097110253109108097114253059083071075032071114117112032075111100108097114253124082097112111114108097114059068097115104098111097114100059069109116105097032083116111107032065110097108105122032082097112111114117124082097112111114108097114059068097115104098111097114100059078097107105116032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059066097107105121101032065114116253254032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059066097107105121101032075111110116114111108032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059073115108101109032071111114109101121101110032067097114105032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059076111103032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059076111103105110032082097112111114124082097112111114108097114059068101110101116105109032082097112111114108097114253059065107116105102032080097115105102032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059067105114111032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059080111122105115121111110032084097107105112032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059084097107111122032068101240105254105107108105107032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059071101110105254032066097107105121101032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059067097114105032076105109105116032075111110116114111108032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059067097114105032068246107252109097110032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059084097107111122032075097114032082097112111114117032124082097112111114108097114059068101110101116105109032082097112111114108097114253059083252112104101108105032221115108101109108101114124082097112111114108097114059068101110101116105109032082097112111114108097114253059077097115116101114032068246107252109097110032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059075097116101103111114105108101114124082097112111114108097114059068101110101116105109032082097112111114108097114253059221115116105104098097114097116032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059071114117112032221231105032077252116097098097107097116032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059077252254116101114105032077252116097098097107097116032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059066097107105121101032068101118105114032072253122253124082097112111114108097114059068101110101116105109032082097112111114108097114253059066097110107097032071252110032083111110117032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059084097114105104108105032077252254116101114105032076105115116101115105124082097112111114108097114059068101110101116105109032082097112111114108097114253059089101110105032072101115097112032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059077097115116101114032072101115097112032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059077097115116101114032072101115097112032082097112111114117032050124082097112111114108097114059068101110101116105109032082097112111114108097114253059071101110101108032077097100101110032083116111107108097114253124082097112111114108097114059068101110101116105109032082097112111114108097114253059069120116114097032076105109105116032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059071101110101108032071105100101114032082097112111114117124082097112111114108097114059068101110101116105109032082097112111114108097114253059066097110107097032221254108101109032075111110116114111108032082097112111114117124082097112111114108097114059071101110101108032082097112111114108097114059072101115097112032066097107105121101032082097112111114117124082097112111114108097114059071101110101108032082097112111114108097114059073115108101109032075111110116114111108032082097112111114117124082097112111114108097114059071101110101108032082097112111114108097114059071101108105114032047071105100101114032075111110116114111108032082097112111114117124082097112111114108097114059071101110101108032082097112111114108097114059080097116114111110032066105108097110099111115117124082097112111114108097114059071101110101108032082097112111114108097114059086097100101108105032075097114032082097112111114117124082097112111114108097114059071101110101108032082097112111114108097114059069109116105097032082097112111114117124082097112111114108097114059071101110101108032082097112111114108097114059075097121110097107032075117108108097110253109032084097098108111115117124082097112111114108097114059071101110101108032082097112111114108097114059067097114105032072101115097112032069120116114101115105124082097112111114108097114059071101110101108032082097112111114108097114059069109116105097032083116111107108097114253124082097112111114108097114059071101110101108032082097112111114108097114059070105110097110115032066097107105121101032082097112111114117124082097112111114108097114059071101110101108032082097112111114108097114059078097107105116032083116111107032076105115116101115105124082097112111114108097114059071101110101108032082097112111114108097114059069109116105097032066105108097110099111124082097112111114108097114059071101110101108032082097112111114108097114059084097107111122032070097114107032082097112111114117124082097112111114108097114059071101110101108032082097112111114108097114059070097116117114097032082097112111114117124083105112097114105115032089111110101116105109105059083105112097114105115032073115108101109108101114105059083105112097114105254032071105114105254105124083105112097114105115032089111110101116105109105059083105112097114105115032073115108101109108101114105059085114101116105109032083105112097114105115108101114105124083105112097114105115032089111110101116105109105059083105112097114105115032073115108101109108101114105059077111100101108032075097116097108111103108097114253124083105112097114105115032089111110101116105109105059084097110253109108097109097108097114059077111100101108032075097114116108097114253124083105112097114105115032089111110101116105109105059084097110253109108097109097108097114059080097114099097032075097114116108097114253124083105112097114105115032089111110101116105109105059084097110253109108097109097108097114059075097108253112032075097114116108097114253124083105112097114105115032089111110101116105109105059084097110253109108097109097108097114059082101099101116101108101114124084097110253109108097109097108097114059083105115116101109059083101116116105110103115124084097110253109108097109097108097114059083105115116101109059067111110102105103117114097115121111110124084097110253109108097109097108097114059083105115116101109059065107116097114253109124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059077097115116101114032072101115097112108097114124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059069120112101114032084097110253109108097109097124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059065121097114032069118105032084097110253109108097109097124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059080114111106101032084097110253109108097109097124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059083105114107101116032084097110253109108097109097124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059083117098101032084097110253109108097109097124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059075097115097032084097110253109108097109097124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059066105114105109032076105115116101115105124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059086097100101108105032073115108101109032075111100108097114105124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059077105122097110032076105115116101115105124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059080097114105116101032084097110253109108097109097124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059065110108253107032070105121097116032084097110253109108097114253124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059075117108108097110253099253032084097110253109108097109097124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059075117108108097110253099253032071114117112108097114253124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059084097107118105109032075097116101103111114105108101114105124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059083117098101032068117114117109032073122108101109101124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059083105108109101032079110097121108097114253124084097110253109108097109097108097114059083105115116101109032084097110105109108097114105059080105110032075111100108097114253124084097110253109108097109097108097114059083116111107032084097110105109108097114105059077097100101110032083116111107032084097110105109108097109097124084097110253109108097109097108097114059083116111107032084097110105109108097114105059078097107105116032083116111107032084097110105109108097109097124084097110253109108097109097108097114059083116111107032084097110105109108097114105059077111100101108032084097110105109108097109097124084097110253109108097109097108097114059083116111107032084097110105109108097114105059071101110101108032083116111107032084097110253109108097109097124084097110253109108097109097108097114059083116111107032084097110105109108097114105059084097115032083116111107032084097110105109108097109097124084097110253109108097109097108097114059083116111107032084097110105109108097114105059080253114108097110116097032083116111107032084097110105109108097109097124084097110253109108097109097108097114059083116111107032084097110105109108097114105059069109116105097032084097110105109108097109097124084097110253109108097109097108097114059083116111107032084097110105109108097114105059086097114121097110116108097114124084097110253109108097109097108097114059083116111107032084097110105109108097114105059072105122109101116032084097110253109108097109097124' ,1)
Kaynaklar

SRC-DB-MODULES — sys.sql_modules tanımı (salt okunur); gizli sabitler [REDACTED_SECRET] ile değiştirildi.
Bilinmeyenler

Hangi sürümde eklendiği: created DB tarihi bir kurulumun tarihidir, ürün sürümü değil (GAP-VERSION-02).