Commits

dloy committed dd26bb4

reset current mysql file def

Comments (0)

Files changed (2)

fixity-src/src/main/sql/current.db.110520.sql

+DROP TABLE IF EXISTS `fixity_item`;
+CREATE TABLE `fixity_item` (
+  `itemkey` bigint NOT NULL AUTO_INCREMENT,
+  `url` varchar(511) NOT NULL,
+  `source` enum('merritt','file','web')
+        NOT NULL,
+  `size` bigint(20) DEFAULT NULL,
+  `type` enum('ADLER-32','CRC-32','MD2','MD5','SHA-1','SHA-256','SHA-384','SHA-512') DEFAULT NULL,
+  `value` varchar(255) DEFAULT NULL,
+  `status` enum('verified','unverified','size-mismatch','digest-mismatch','system-unavailable','processing')
+        NOT NULL DEFAULT 'unverified',
+  `verified` timestamp NULL,
+  `lastsize` bigint(20) NULL,
+  `lastvalue` varchar(255) DEFAULT NULL,
+  `note` text,
+  `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
+  `modified` timestamp NULL,
+  PRIMARY KEY (`itemkey`),
+  KEY `url` (`url`),
+  KEY `status` (`status`),
+  KEY `verified` (`verified`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `fixity_context`;
+CREATE TABLE `fixity_context` (
+  `contextkey` bigint NOT NULL AUTO_INCREMENT,
+  `itemkey` bigint NOT NULL,
+  `context` varchar(255) NOT NULL,
+  PRIMARY KEY (`contextkey`),
+  KEY `context` (`context`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `fixity_history`;
+CREATE TABLE `fixity_history` (
+  `historykey` bigint NOT NULL AUTO_INCREMENT,
+  `itemkey` bigint NOT NULL,
+  `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
+  `subject` varchar(255) DEFAULT NULL,
+  `note` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`historykey`),
+  KEY `subject` (`subject`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+
+INSERT INTO `fixity_item` (`url`, `context`, `source`, `type`, `value`, `size`)
+  VALUES (
+  'https://confluence.ucop.edu/download/attachments/20250670/testG23.xls',
+  '|node=10|objectid=12345-abcde|version=3|fileid=fptr109.xls|',
+  'web',
+  'SHA-256',
+  'be18adbda20306f18bc2c725e3c3e9efe6fb3d5da933ba7c62184a4f3c373820',
+  '21504'
+);
+
+INSERT INTO `fixity_item` (`url`, `context`, `source`, `type`, `value`, `size`)
+  VALUES (
+  'https://confluence.ucop.edu/download/attachments/20250670/testG27.xls',
+  '|fileid=testG27.xls|',
+  'web',
+  'MD5',
+  '9ef33b30e80ef01a0e8ae2488ed68aab',
+  '18944'
+);
+
+INSERT INTO `fixity_item` (`url`, `context`, `source`, `type`, `value`, `size`)
+  VALUES (
+  'https://confluence.ucop.edu/download/attachments/20250670/testG27.xls',
+  '|bad size|',
+  'web',
+  'MD5',
+  '9ef33b30e80ef01a0e8ae2488ed68aab',
+  '18945'
+);
+
+INSERT INTO `fixity_item` (`url`, `context`, `source`, `type`, `value`, `size`)
+  VALUES (
+  'https://confluence.ucop.edu/download/attachments/20250670/testG27.xls',
+  '|bad checksum|',
+  'web',
+  'MD5',
+  'fff33b30e80ef01a0e8ae2488ed68aab',
+  '18944'
+);
+
+
+INSERT INTO `fixity_item` (`url`, `source`)
+  VALUES (
+  'http://localhost:28080/storage/fixity/10/12345-abcde/3/fptr109.xls?t=anvl',
+  'merritt'
+);
+
+
+INSERT INTO `fixity_history` (`itemkey`, `subject`, `note`)
+  VALUES (
+  '2',
+  'add',
+  'validated'
+);

fixity-src/src/main/sql/current.db.sql

   PRIMARY KEY (`contextkey`),
   KEY `context` (`context`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-DROP TABLE IF EXISTS `fixity_history`;
-CREATE TABLE `fixity_history` (
-  `historykey` bigint NOT NULL AUTO_INCREMENT,
-  `itemkey` bigint NOT NULL,
-  `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
-  `subject` varchar(255) DEFAULT NULL,
-  `note` varchar(255) DEFAULT NULL,
-  PRIMARY KEY (`historykey`),
-  KEY `subject` (`subject`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-
-
-INSERT INTO `fixity_item` (`url`, `context`, `source`, `type`, `value`, `size`)
-  VALUES (
-  'https://confluence.ucop.edu/download/attachments/20250670/testG23.xls',
-  '|node=10|objectid=12345-abcde|version=3|fileid=fptr109.xls|',
-  'web',
-  'SHA-256',
-  'be18adbda20306f18bc2c725e3c3e9efe6fb3d5da933ba7c62184a4f3c373820',
-  '21504'
-);
-
-INSERT INTO `fixity_item` (`url`, `context`, `source`, `type`, `value`, `size`)
-  VALUES (
-  'https://confluence.ucop.edu/download/attachments/20250670/testG27.xls',
-  '|fileid=testG27.xls|',
-  'web',
-  'MD5',
-  '9ef33b30e80ef01a0e8ae2488ed68aab',
-  '18944'
-);
-
-INSERT INTO `fixity_item` (`url`, `context`, `source`, `type`, `value`, `size`)
-  VALUES (
-  'https://confluence.ucop.edu/download/attachments/20250670/testG27.xls',
-  '|bad size|',
-  'web',
-  'MD5',
-  '9ef33b30e80ef01a0e8ae2488ed68aab',
-  '18945'
-);
-
-INSERT INTO `fixity_item` (`url`, `context`, `source`, `type`, `value`, `size`)
-  VALUES (
-  'https://confluence.ucop.edu/download/attachments/20250670/testG27.xls',
-  '|bad checksum|',
-  'web',
-  'MD5',
-  'fff33b30e80ef01a0e8ae2488ed68aab',
-  '18944'
-);
-
-
-INSERT INTO `fixity_item` (`url`, `source`)
-  VALUES (
-  'http://localhost:28080/storage/fixity/10/12345-abcde/3/fptr109.xls?t=anvl',
-  'merritt'
-);
-
-
-INSERT INTO `fixity_history` (`itemkey`, `subject`, `note`)
-  VALUES (
-  '2',
-  'add',
-  'validated'
-);
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.