diff options
| -rwxr-xr-x | bin/check-db-structure | 23 | ||||
| -rw-r--r-- | misc/database-layout.dump | 84 |
2 files changed, 107 insertions, 0 deletions
diff --git a/bin/check-db-structure b/bin/check-db-structure index 3b85756..5f7d9c2 100755 --- a/bin/check-db-structure +++ b/bin/check-db-structure @@ -5,6 +5,8 @@ # shellcheck source=../conf/default.conf . "${0%/*}/../conf/default.conf" +# stored functions + # shellcheck disable=SC2016 { printf 'SELECT `proc`.`name` FROM `mysql`.`proc` WHERE `proc`.`Db`="buildmaster"' | \ @@ -18,6 +20,9 @@ s/ \(SELECT\|FROM\|\(LEFT \|RIGHT \)\?JOIN\|ON\|WHERE\) /\n\t\1 /g s/(SELECT/(\nSELECT/g ' + +# table headers + # shellcheck disable=SC2016 { printf 'SHOW TABLES' | \ @@ -31,3 +36,21 @@ s/ AUTO_INCREMENT=[0-9]\+ / /g s/^ /\t/ ' + +# content of "constant" tables +mysqldump --skip-lock-tables 'buildmaster' \ + 'architectures' \ + 'dependency_types' \ + 'email_actions' \ + 'fail_reasons' \ + 'git_repositories' \ + 'repositories' \ + 'repository_moves' \ + 'repository_stabilities' \ + 'repository_stability_relations' \ + 'upstream_repositories' | \ + grep '^INSERT ' | \ + sed ' + s/),(/),\n (/g + s/VALUES (/VALUES\n (/g + ' diff --git a/misc/database-layout.dump b/misc/database-layout.dump index dc0b537..27bbf36 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -601,3 +601,87 @@ upstream_repositories CREATE TABLE `upstream_repositories` ( KEY `git_repository` (`git_repository`), CONSTRAINT `upstream_repositories_ibfk_1` FOREIGN KEY (`git_repository`) REFERENCES `git_repositories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +INSERT INTO `architectures` VALUES + (1,'any'), + (2,'i686'); +INSERT INTO `dependency_types` VALUES + (2,'run','',''), + (3,'check','\0','\0'), + (4,'link','\0',''), + (5,'make','','\0'); +INSERT INTO `email_actions` VALUES + (2,'block'), + (5,'copy-to-build-support'), + (4,'schedule'), + (1,'stabilize'), + (3,'unblock'); +INSERT INTO `fail_reasons` VALUES + (1,'build()','==> ERROR: A failure occurred in build()\\.',0), + (2,'source','==> ERROR: Could not download sources\\.',1), + (3,'package-cache','.*error: failed to commit transaction (invalid or corrupted pack',2), + (4,'prepare()','==> ERROR: A failure occurred in prepare()\\.',2), + (5,'package()','==> ERROR: A failure occurred in package\\(_\\S\\+\\)\\?()\\.',3), + (6,'check()','==> ERROR: A failure occurred in check()\\.',4), + (7,'dependencies','==> ERROR: \'pacman\' failed to install missing dependencies\\.',1), + (8,'run-as-root','==> ERROR: Running makepkg as root is not allowed as it can caus',1), + (9,'unknown','.*',100); +INSERT INTO `git_repositories` VALUES + (1,'packages','git://git.archlinux.org/svntogit/packages.git','/home/slave/packages64','7806279e6d3b35afd7be9b49f59b459cef51cb00'), + (2,'community','git://git.archlinux.org/svntogit/community.git','/home/slave/community64','5369c9cd66063d9a10ce540d733dfbb285dbcf2b'), + (3,'archlinux32','https://github.com/archlinux32/packages.git','/home/slave/packages32','3d5ece893f85808c4b1a63df306e21d5fd97659e'); +INSERT INTO `repositories` VALUES + (1,'core',1,'',2), + (2,'extra',1,'',2), + (3,'community',1,'',2), + (4,'build-support',4,'',2), + (5,'testing',2,'',2), + (6,'community-testing',2,'',2), + (7,'staging',3,'',2), + (8,'community-staging',3,'',2), + (9,'build-list',5,'\0',1), + (10,'deletion-list',6,'\0',1), + (11,'to-be-decided',7,'\0',1); +INSERT INTO `repository_moves` VALUES + (1,6,3,3), + (2,6,3,4), + (3,8,6,3), + (4,8,6,4), + (5,5,1,1), + (6,5,2,2), + (8,7,5,1), + (9,7,5,2), + (10,9,7,1), + (11,9,7,2), + (12,9,8,3), + (13,9,8,4); +INSERT INTO `repository_stabilities` VALUES + (1,'stable','Packages: Stable'), + (2,'testing','Packages: Testing'), + (3,'staging',NULL), + (4,'standalone',NULL), + (5,'unbuilt','Packages: Build-list'), + (6,'forbidden',NULL), + (7,'virtual',NULL); +INSERT INTO `repository_stability_relations` VALUES + (16,1,1), + (7,1,2), + (5,1,3), + (24,1,4), + (8,1,5), + (1,1,6), + (17,2,2), + (6,2,3), + (26,2,4), + (10,2,5), + (3,2,6), + (18,3,3), + (25,3,4), + (9,3,5), + (2,3,6), + (23,4,4), + (4,5,6); +INSERT INTO `upstream_repositories` VALUES + (4,'community',2), + (1,'core',1), + (2,'extra',1), + (3,'multilib',2); |