upstream/mercurial-mirror Files · hgext/infinitepush/schema.sql

branchmap: explicitly warm+write all subsets of the branchmap caches...

branchmap: explicitly warm+write all subsets of the branchmap caches 'full' claims it will warm all of the caches that are known about, but this was not the case - it did not actually warm the branchmap caches for subsets that we haven't requested, or for subsets that are still considered "valid". By explicitly writing them to disk, we can force the subsets for ex: "served" to be written ("immutable" and "base"), making it cheaper to calculate "served" the next time it needs to be updated. Differential Revision: https://phab.mercurial-scm.org/D6710

Pulkit Goyal - - Load All Authors

File last commit:

r37204:03ff17a4 default


                r42940:cdf0e952

default

Download file

             schema.sql
        
                    33 lines
            
             | 1.1 KiB
            
                | text/x-sql
            
             |
                TransactSqlLexer
            
             / hgext / infinitepush / schema.sql
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Pulkit Goyal
    
infinitepush: move the extension to core from fb-hgext...

              r37204
            
      CREATE TABLE `bookmarkstonode` (

        `node` varbinary(64) NOT NULL,

        `bookmark` varbinary(512) NOT NULL,

        `reponame` varbinary(255) NOT NULL,

        PRIMARY KEY (`reponame`,`bookmark`)

      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      CREATE TABLE `bundles` (

        `bundle` varbinary(512) NOT NULL,

        `reponame` varbinary(255) NOT NULL,

        PRIMARY KEY (`bundle`,`reponame`)

      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      CREATE TABLE `nodestobundle` (

        `node` varbinary(64) NOT NULL,

        `bundle` varbinary(512) NOT NULL,

        `reponame` varbinary(255) NOT NULL,

        PRIMARY KEY (`node`,`reponame`)

      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      CREATE TABLE `nodesmetadata` (

        `node` varbinary(64) NOT NULL,

        `message` mediumblob NOT NULL,

        `p1` varbinary(64) NOT NULL,

        `p2` varbinary(64) DEFAULT NULL,

        `author` varbinary(255) NOT NULL,

        `committer` varbinary(255) DEFAULT NULL,

        `author_date` bigint(20) NOT NULL,

        `committer_date` bigint(20) DEFAULT NULL,

        `reponame` varbinary(255) NOT NULL,

        `optional_json_metadata` mediumblob,

        PRIMARY KEY (`reponame`,`node`)

      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

Pulkit Goyal infinitepush: move the extension to core from fb-hgext...	r37204	CREATE TABLE `bookmarkstonode` (
		`node` varbinary(64) NOT NULL,
		`bookmark` varbinary(512) NOT NULL,
		`reponame` varbinary(255) NOT NULL,
		PRIMARY KEY (`reponame`,`bookmark`)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8;

		CREATE TABLE `bundles` (
		`bundle` varbinary(512) NOT NULL,
		`reponame` varbinary(255) NOT NULL,
		PRIMARY KEY (`bundle`,`reponame`)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8;

		CREATE TABLE `nodestobundle` (
		`node` varbinary(64) NOT NULL,
		`bundle` varbinary(512) NOT NULL,
		`reponame` varbinary(255) NOT NULL,
		PRIMARY KEY (`node`,`reponame`)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8;

		CREATE TABLE `nodesmetadata` (
		`node` varbinary(64) NOT NULL,
		`message` mediumblob NOT NULL,
		`p1` varbinary(64) NOT NULL,
		`p2` varbinary(64) DEFAULT NULL,
		`author` varbinary(255) NOT NULL,
		`committer` varbinary(255) DEFAULT NULL,
		`author_date` bigint(20) NOT NULL,
		`committer_date` bigint(20) DEFAULT NULL,
		`reponame` varbinary(255) NOT NULL,
		`optional_json_metadata` mediumblob,
		PRIMARY KEY (`reponame`,`node`)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8;