! __.PKGDEF 0 0 0 644 11648 ` go object linux amd64 go1.22.2 GOAMD64=v1 X:regabiwrappers,regabiargs,coverageredesign,allocheaders,exectracer2 build id "qyLwAifxnNZD3OQeUzgt/u2JE9qp69XBdcuLsMFJS" $$B u ,7FLamy| (-=DU]u|P '+168<AFKTZdluxy BUZmrv} !$*-8DPW^ckps{ "-:?CKPSVZqz~R_dinsx}*4>KXhr| % H R _ i z    ) 2 ; D M V ] u { & ) , 2 9 5 8 > D K Q W ] c i o v |     $ ' - 3 9 ? E K Q W ] c i o u { RY`cjqw} !(VW;u= > !!#!/!:!B!r!!!###$$$($$$$$$$$$$$$$%%%% %(%0%8%@%H%P%X%`%|%sqlite3embederrorsunsafeinternal/reflectlitereflectliteinternal/goarchgoarchinternal/unsafeheaderunsafeheaderinternal/abiabiruntimeinternal/cpucpuinternal/goexperimentgoexperimentruntime/internal/atomicatomicruntime/internal/mathmathruntime/internal/syssysinternal/goosgoosinternal/coverage/rtcovrtcovinternal/bytealgbytealginternal/godebugsgodebugsruntime/internal/syscallsyscallinternal/chacha8randchacha8randiosyncsync/atomicinternal/raceraceio/fsfstimeinternal/itoaitoainternal/oserroroserrorunicode/utf8utf8pathsortmath/bitsbitsslicescmpgithub.com/owasp-amass/asset-db/migrations/sqlite3/root/go/pkg/mod/github.com/owasp-amass/asset-db@v0.3.3/migrations/sqlite3/embed.go$GOROOT/src/embed/embed.gofilesnamedatahashbuiltinbyteNamefSizeModTime$GOROOT/src/time/time.gowallextloc$GOROOT/src/time/zoneinfo.gozoneoffsetisDSTtxwhenindexisstdisutczoneTransextendcacheStartcacheEndcacheZonegetlStringlookupsecstartendlookupFirstZonefirstZoneUsedlookupNameunixokLocationesc:esc:esc:$GOROOT/src/time/format.gotGoStringFormatlayoutAppendFormatbappendFormat$GOROOT/src/time/format_rfc3339.goappendFormatRFC3339nanosappendStrictRFC3339errornsecunixSecaddSecdsetLocstripMonosetMonommonoAfteruBeforeCompareEqualIsZeroabslocabsDateyearmonthMonthdayYearDayWeekdayISOWeekweekClockhourminHourMinuteSecondNanosecondYearDayAddformatbufNanosecondsMicrosecondsMillisecondsSecondsMinutesHoursTruncateRoundAbsDurationesc:SubAddDateyearsmonthsdaysdatefullydayUTCLocalInZoneZoneBoundsUnixUnixMilliUnixMicroUnixNanoMarshalBinaryUnmarshalBinaryGobEncodeGobDecodeMarshalJSONUnmarshalJSONMarshalTextUnmarshalTextIsDSTTimeesc:IsDirSysanyType$GOROOT/src/io/fs/fs.goIsRegularPermFileModeInfoModeFileInfofilereadDirdirOpenCloseReadStatFileReadDirDirEntryReadFileFSesc:Migrationssqlite3Migrations      8 9:EIgo8              ! "#"$$%%&&'(' )*) ++ !!  ,-,./.010223 !34546" 677???#@cJR#s#;<=>    FGH <JMSTUV! , - .  <KL345 NOPQ:;<<  !!!!!!!********((((((((      D* *(**(**(**(*        ]DabA\Ccd                mnpq WW VVVVUU  Uos qm]A\b oo occ ``  g g     ZBh<ijkeru !    !    ) #2 $,AB C  D TUVWXY^_efYg      %Yh(ijklm)+n,-p.q/r012t34[5u6v7wx8H9y:z;{|<}~<K=?AFcG\]HI=JKLMNOPQRS;   %  & 5 & 5# -9>>># >.>6> !"#$"%&'"()*+,-./0"12"3454647849:;<=&>72:;?@7!AB.C7D7EBF7GHI@7 J7KL7M7# 7N7O7P7Q7R7S'TU4TVW7"X7.Y78Z[ @7*AB7C7@\7] ^    _  *` !  a  b  c  = $>7  d  e $f  g  "  h  "  i  "  j  "  k  l (  m n op -  q  r $  s t ou '  v  w &  x y oz +  {  | &  } ~ o +        'T $    'T ! WX "Y#Z$[<K\]L^%_&`'ab[[[[gg g g   ' 4@GR&$ ,9E29Y{>Yw@YwBCE{  )  ! ""(% ZY{[\]     `lTt\efLJ"$&efd<>G  GN>fedBDjlnpr2t$v%x z|~&BEEELAA? G98?,,*E=Fdef=MKK dbf`h^pn   _3P $$ _go_.o 0 0 0 644 5786 ` go object linux amd64 go1.22.2 GOAMD64=v1 X:regabiwrappers,regabiargs,coverageredesign,allocheaders,exectracer2 build id "qyLwAifxnNZD3OQeUzgt/u2JE9qp69XBdcuLsMFJS" ! go120ld_3PH+U ~ , embedgithub.com/owasp-amass/asset-db/migrations/sqlite3.Migrationsgithub.com/owasp-amass/asset-db/migrations/sqlite3.sqlite3Migrationsgclocals·g2BeySu+wFnoycgXfElmcg==/root/go/pkg/mod/github.com/owasp-amass/asset-db@v0.3.3/migrations/sqlite3/embed.gotype:embed.FSgo:info.embed.FSgo:cuinfo.producer.github.com/owasp-amass/asset-db/migrations/sqlite3go:cuinfo.packagename.github.com/owasp-amass/asset-db/migrations/sqlite3github.com/owasp-amass/asset-db/migrations/sqlite3..inittaskembed..inittaskgithub.com/owasp-amass/asset-db/migrations/sqlite3.sqlite3Migrations.filesgo:string."001_schema_init.sql"go:string..gostring.664.Hyk97LY2iBQFFiSLbYS76Q==go:string."002_add_last_seen.sql"go:string..gostring.153.KoAtuLScrpw1c2NBppvqSg==go:string."003_relations_last_seen.sql"go:string..gostring.159.AMl9uOcmu3CVUReFUO7bVA==go:string."004_assets_indexes.sql"go:string..gostring.643.lX8pYKJTwdHzIZ+GrSX8HQ==go:string."005_relations_indexes.sql"go:string..gostring.211.caCCWw3C5N7yZgD5aRrIDg==$GOROOT/src/embed/embed.go$GOROOT/src/time/time.go$GOROOT/src/time/zoneinfo.go$GOROOT/src/time/format.go$GOROOT/src/time/format_rfc3339.go$GOROOT/src/io/fs/fs.go`z5T``8SGay"=e<D` UJP``` d````0!0 ':0a"0%0"ExHS`` dhA| X?XWVS4ъ`)\A*N7T]>Cզ,kCT$g5ubhw]Te`s=i=2\&(UoA7m}+ؖFMӏyJ]Sί[bx308/؁>-9Ydp~X}Qx5!&C`UGF{28&|8[|8Ӣ|͕ mu +q+A [HP(HXx     &?G^  &H github.com/owasp-amass/asset-db/migrations/sqlite3.sqlite3Migrations )=6$m*-5scAJ}&pQPT)`S!%q[ fi  Ugithub.com/owasp-amass/asset-db/migrations/sqlite3.Migrations ~r0 001_schema_init.sql-- +migrate Up -- see https://www.sqlite.org/foreignkeys.html#fk_enable about enabling foreign keys PRAGMA foreign_keys = ON; CREATE TABLE IF NOT EXISTS assets( id INTEGER PRIMARY KEY, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, type TEXT, content TEXT); CREATE TABLE IF NOT EXISTS relations( id INTEGER PRIMARY KEY, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, type TEXT, from_asset_id INTEGER, to_asset_id INTEGER, FOREIGN KEY(from_asset_id) REFERENCES assets(id) ON DELETE CASCADE, FOREIGN KEY(to_asset_id) REFERENCES assets(id) ON DELETE CASCADE); -- +migrate Down DROP TABLE relations; DROP TABLE assets; 002_add_last_seen.sql-- +migrate Up ALTER TABLE assets ADD COLUMN last_seen DATETIME DEFAULT CURRENT_TIMESTAMP; -- +migrate Down ALTER TABLE assets DROP COLUMN last_seen; 003_relations_last_seen.sql-- +migrate Up ALTER TABLE relations ADD COLUMN last_seen DATETIME DEFAULT CURRENT_TIMESTAMP; -- +migrate Down ALTER TABLE relations DROP COLUMN last_seen; 004_assets_indexes.sql-- +migrate Up -- Index the `name` field of the `content` jsonb when type is `FQDN` -- Assumes the pg_trgm extension is created in the database CREATE INDEX idx_fqdn_content_name ON assets (content->>'name' COLLATE NOCASE) WHERE type = 'FQDN'; -- Index assets.type CREATE INDEX idx_assets_type ON assets (type); -- Index created_at CREATE INDEX idx_as_created_at ON assets (created_at); -- Index last_seen CREATE INDEX idx_as_last_seen ON assets (last_seen); -- +migrate Down -- drop all the indexes we just created DROP INDEX idx_fqdn_content_name; DROP INDEX idx_assets_type; DROP INDEX idx_as_created_at; DROP INDEX idx_as_last_seen;005_relations_indexes.sql-- +migrate Up CREATE INDEX idx_rel_created_at ON relations (created_at); CREATE INDEX idx_rel_last_seen ON relations (last_seen); -- +migrate Down DROP INDEX idx_rel_created_at; DROP INDEX idx_rel_last_seen;regabisqlite3