File: DigestTest-Schema-1.x-SQLite.sql

package info (click to toggle)
libdbix-class-encodedcolumn-perl 0.00013-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 308 kB
  • ctags: 209
  • sloc: perl: 2,723; sql: 36; makefile: 2
file content (51 lines) | stat: -rw-r--r-- 828 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
-- 
-- Created by SQL::Translator::Producer::SQLite
-- Created on Mon May 17 13:22:05 2010
-- 


BEGIN TRANSACTION;

--
-- Table: test_bcrypt
--
CREATE TABLE test_bcrypt (
  id INTEGER PRIMARY KEY NOT NULL,
  bcrypt_1 text,
  bcrypt_2 text
);

--
-- Table: test_pgp
--
CREATE TABLE test_pgp (
  id INTEGER PRIMARY KEY NOT NULL,
  dummy_col char(43) NOT NULL,
  pgp_col_passphrase text,
  pgp_col_key text,
  pgp_col_key_ps text
);

--
-- Table: test_sha
--
CREATE TABLE test_sha (
  id INTEGER PRIMARY KEY NOT NULL,
  dummy_col char(43) NOT NULL,
  sha1_hex char(40),
  sha1_b64 char(27),
  sha256_hex char(64),
  sha256_b64 char(43),
  sha256_b64_salted char(57)
);

--
-- Table: test_whirlpool
--
CREATE TABLE test_whirlpool (
  id INTEGER PRIMARY KEY NOT NULL,
  whirlpool_hex char(128),
  whirlpool_b64 char(86)
);

COMMIT;