diff options
| author | me_desk <me_desk@fb96df88-216d-11de-830c-f3023f12d8ac> | 2012-08-11 22:41:18 +0000 |
|---|---|---|
| committer | me_desk <me_desk@fb96df88-216d-11de-830c-f3023f12d8ac> | 2012-08-11 22:41:18 +0000 |
| commit | 3104531aef12be27b6d493c012fc4244b14002b9 (patch) | |
| tree | a34d5287146db7abd697dcfdda0f2494f47c711f /pica-registrar/db_schema.sql | |
| parent | e4c6dc91e60c6e2d67bdc33fc5512711979b224f (diff) | |
| download | pica-pica-3104531aef12be27b6d493c012fc4244b14002b9.tar.gz pica-pica-3104531aef12be27b6d493c012fc4244b14002b9.zip | |
pica-registrar stores info about signed certificates in mysql database
git-svn-id: svn://localhost/project_picapica/trunk@161 fb96df88-216d-11de-830c-f3023f12d8ac
Diffstat (limited to 'pica-registrar/db_schema.sql')
| -rw-r--r-- | pica-registrar/db_schema.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/pica-registrar/db_schema.sql b/pica-registrar/db_schema.sql new file mode 100644 index 0000000..1921bf0 --- /dev/null +++ b/pica-registrar/db_schema.sql @@ -0,0 +1,11 @@ +create table registrations +( +id int unsigned PRIMARY KEY, +t datetime NOT NULL, +ip_addr int unsigned NOT NULL, +name varchar(64) CHARACTER SET utf8 NOT NULL, +req_pem varchar(4096) NOT NULL, +cert_pem varchar(4096) NOT NULL +) + +ENGINE = InnoDB; |