public
Description: Django backend code for sshkeys.net
Homepage: http://sshkeys.net/
Clone URL: git://github.com/cjb/sshkeys.git
Chris Ball (author)
Sun Sep 14 23:35:44 -0700 2008
commit  b29888ce9cc8658ba3591bfbf79bd158241eda37
tree    ef60b1542c13de0f275de48c49978c163175f2ba
parent  770f89363707b87bcb91775e8c97eb84f8bf857e
sshkeys / sshkeys.db
100644 130 lines (130 sloc) 44.032 kb
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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
SQLite format 3@ ! 
!fvdR@+}hSD2 ~f/ delete_addresskey!/ change_addresskey ) add_addresskey'
delete_sshkey'
change_sshkey!
add_sshkey) delete_address) change_address# add_address#delete_site#change_siteadd_site)delete_session)change_session#add_session1delete_contenttype1change_contenttype+add_contenttype+delete_logentry+change_logentry%add_logentry )delete_message )change_message #add_message
#delete_user #change_useradd_user%delete_group%change_groupadd_group/delete_permission/change_permission)add_permission 
 tt   -sAAcjbchris@printf.netsha1$d35c1$c88255b592fdfcfb8cd992191de07ac0de63f23b2008-09-14 23:43:07.5213842008-09-03 11:39:58.692440
cjb 0o3++Stableauth_permissionauth_permissionCREATE TABLE "auth_permission" (
    "id" integer NOT NULL PRIMARY KEY,
    "name" varchar(50) NOT NULL,
    "content_type_id" integer NOT NULL,
    "codename" varchar(100) NOT NULL,
    UNIQUE ("content_type_id", "codename")
)=Q+indexsqlite_autoindex_auth_permission_1auth_permission !!ctableauth_groupauth_groupCREATE TABLE "auth_group" (
    "id" integer NOT NULL PRIMARY KEY,
    "name" varchar(80) NOT NULL UNIQUE
)3G!indexsqlite_autoindex_auth_group_1auth_groupJctableauth_userauth_userCREATE TABLE "auth_user" (
    "id" integer NOT NULL PRIMARY KEY,
    "username" varchar(30) NOT NULL UNIQUE,
    "first_name" varchar(30) NOT NULL,
    "last_name" varchar(30) NOT NULL,
    "email" varchar(75) NOT NULL,
    "password" varchar(128) NOT NULL,
    "is_staff" bool NOT NULL,
    "is_active" bool NOT NULL,
    "is_superuser" bool NOT NULL,
    "last_login" datetime NOT NULL,
    "date_joined" datetime NOT NULL
) ^^Y1Eindexsqlite_autoindex_auth_user_1auth_userE%%Mtableauth_messageauth_message
CREATE TABLE "auth_message" (
    "id" integer NOT NULL PRIMARY KEY,
    "user_id" integer NOT NULL REFERENCES "auth_user" ("id"),
    "message" text NOT NULL
)--Ytabledjango_admin_logdjango_admin_log CREATE TABLE "django_admin_log" (
    "id" integer NOT NULL PRIMARY KEY,
    "action_time" datetime NOT NULL,
    "user_id" integer NOT NULL REFERENCES "auth_user" ("id"),
    "content_type_id" integer NULL,
    "object_id" text NULL,
    "object_repr" varchar(200) NOT NULL,
    "action_flag" smallint unsigned NOT NULL,
    "change_message" text NOT NULL
) 33Ctabledjango_content_typedjango_content_type CREATE TABLE "django_content_type" (
    "id" integer NOT NULL PRIMARY KEY,
    "name" varchar(100) NOT NULL,
    "app_label" varchar(100) NOT NULL,
    "model" varchar(100) NOT NULL,
    UNIQUE ("app_label", "model")
) #The address key "chriseThe ssh key "ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEApMvZ3/GapkDakpFLwja+ayEvhrJBxFnYkZixNzaNmGM0JT3VH9hyPe5QJEnd8WrwEx4GJuOTYmUoEqeZt4UEznCzztgYnXzY9NG4QeAxyDSlxOG3RMQgtg7Kw6VZo+HeOLKQ/6gThe*OThe address key "chris-sshkeys@printf.net / ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEApMvZ3/GapkDakpFLwja+ayEvhrJBxFnYkZixNzaNmGM0JT3VH9hyPe5QJEnd8WrwEx4GJuOTYmUoEqeZt4UEznCzztgYnXzY9NG4QeAxyDSlxOG3RMQgtg7Kw6VZo+HeOLKQ/cg67ACxT9Jj5y6EOx/vg3C8nsSmKNnUphdf6vE= cjb@lexis" was deleted successfully.+* Y<( #!address keykeysaddresskey
ssh keykeyssshkey addresskeysaddresssitesitessitesessionsessionssession(%%#content typecontenttypescontenttypelog entryadminlogentrymessageauthmessageuserauthusergroupauthgroup!!permissionauthpermission
5Y5Iyj!keysaddresskey keyssshkey
keysaddress sitessitesessionssession%#contenttypescontenttypeadminlogentryauthmessage authuserauthgroup!authpermission ~ wAb074b6b7a218d48e92df145d1ejMcAb074b6b7a218d48e92df145d1e283d9dgAJ9cQEoVRJfYXV0aF91c2VyX2JhY2tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k
cy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEESwF1Ljc2NTZmNWM1N2IyMDYxOTkyOWQ5
MWZjNTFiYTVlNjMz
2008-09-28 23:43:07.723016sMwAdf45b1e1aa8841144ba91285931fb56dgAJ9cQEuYzYxMzBjNDE3ZjM0NjNkYzQ0MzBmYTExMzRmYWM4ZWY=
2008-09-17 11:41:56.911259 +/pE
Y3indexsqlite_autoindex_django_content_type_1django_content_type D ))Ctabledjango_sessiondjango_sessionCREATE TABLE "django_session" (
    "session_key" varchar(40) NOT NULL PRIMARY KEY,
    "session_data" text NOT NULL,
    "expire_date" datetime NOT NULL
); O)indexsqlite_autoindex_django_session_1django_session, ##tabledjango_sitedjango_siteCREATE TABLE "django_site" (
    "id" integer NOT NULL PRIMARY KEY,
    "domain" varchar(100) NOT NULL,
    "name" varchar(50) NOT NULL
)%%atablekeys_addresskeys_addressCREATE TABLE "keys_address" (
    "id" integer NOT NULL PRIMARY KEY,
    "address" varchar(255) NOT NULL
) ##atablekeys_sshkeykeys_sshkeyCREATE TABLE "keys_sshkey" (
    "id" integer NOT NULL PRIMARY KEY,
    "keytext" varchar(1024) NOT NULL
)
$Mb074b6b7a218d48e92df145d1e283d9d%b3e4e480545c25b6c02a7f225006ae3d$Mdf45b1e1aa8841144ba91285931fb56d ##example.comexample.com rr=chris-sshkeys@printf.net1michael@laptop.org/cscott@laptop.org;crschmidt@crschmidt.net)cjb@laptop.org-chris@printf.net)('& O.\!OgA]A2008-09-15 01:04:53.2705367666be522efb06580c311dbeb0d40b8a84565ce92008-09-15 01:04:53.270547g A]A2008-09-15 01:04:53.379177c3ef97a16a1a19f818987ee3948aa5fa064a50122008-09-15 01:04:53.379185gA]A2008-09-14 19:27:49.05541927718781a86aae817f165452097a2c163c0e80d12008-09-14 19:27:49.055432gA]A2008-09-09 17:49:59.92221043c94fb4addca35870b4f8eca487f5f7277439a92008-09-09 17:49:59.957121gA]A2008-09-08 15:31:04.490783fec8be03e7cb962361cfeec5df667fc8fd1dc14b2008-09-08 15:31:04.499832gA]A2008-09-08 15:13:57.304729dbedcdb37de3220f910d4fb1275073be5a88d3d22008-09-08 15:13:57.324492gA]A2008-09-03 11:48:11.628599382be7ff080f34c6d10daa609d6ef57a4a5a95b32008-09-03 11:48:11.628610gA]A2008-09-03 11:45:17.022201cfbc3bb84f32e0f0d9a50d4872aeebbc5bc8880e2008-09-03 11:45:17.022213gA]A2008-09-03 11:40:37.949621759257080fd1d903410224eedd31cc621362f5452008-09-03 11:40:37.949632 t++9tablekeys_addresskeykeys_addresskeyCREATE TABLE "keys_addresskey" (
    "id" integer NOT NULL PRIMARY KEY,
    "address_id" integer NOT NULL REFERENCES "keys_address" ("id"),
    "sshkey_id" integer NOT NULL REFERENCES "keys_sshkey" ("id"),
    "date_added" datetime NOT NULL,
    "verified" bool NOT NULL,
    "token" varchar(40) NOT NULL,
    "token_sent" datetime NOT NULL
)<99tableauth_group_permissionsauth_group_permissionsCREATE TABLE "auth_group_permissions" (
    "id" integer NOT NULL PRIMARY KEY,
    "group_id" integer NOT NULL REFERENCES "auth_group" ("id"),
    "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"),
    UNIQUE ("group_id", "permission_id")
)K_9indexsqlite_autoindex_auth_group_permissions_1auth_group_permissions 
 
 \\w--ctableauth_user_groupsauth_user_groupsCREATE TABLE "auth_user_groups" (
    "id" integer NOT NULL PRIMARY KEY,
    "user_id" integer NOT NULL REFERENCES "auth_user" ("id"),
    "group_id" integer NOT NULL REFERENCES "auth_group" ("id"),
    UNIQUE ("user_id", "group_id")
)?S-indexsqlite_autoindex_auth_user_groups_1auth_user_groupsEAAtableauth_user_user_permissionsauth_user_user_permissionsCREATE TABLE "auth_user_user_permissions" (
    "id" integer NOT NULL PRIMARY KEY,
    "user_id" integer NOT NULL REFERENCES "auth_user" ("id"),
    "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"),
    UNIQUE ("user_id", "permission_id")
) 
 H|^:lDm<jH +#Can add address add_address +#Can delete sitedelete_site +#Can change sitechange_site%Can add siteadd_site&1)Can delete sessiondelete_session&1)Can change sessionchange_session +#Can add sessionadd_session/;1Can delete content typedelete_contenttype/;1Can change content typechange_contenttype)5+Can add content typeadd_contenttype)5+Can delete log entrydelete_logentry)5+Can change log entrychange_logentry# /%Can add log entryadd_logentry& 1)Can delete messagedelete_message& 1)Can change messagechange_message
+#Can add messageadd_message +#Can delete userdelete_user +#Can change userchange_user%Can add useradd_user"-%Can delete groupdelete_group"-%Can change groupchange_group'Can add groupadd_group,7/Can delete permissiondelete_permission,7/Can change permissionchange_permission&1)Can add permissionadd_permission hA-!9/Can delete address key delete_addresskey- 9/Can change address key change_addresskey'3)Can add address key add_addresskey%1'Can delete ssh key
delete_sshkey%1'Can change ssh key
change_sshkey+!Can add ssh key
add_sshkey&1)Can delete address delete_address&1)Can change address change_address
!:|vpjd^XRLF@: !  


      
 
 &?+#indexkeys_addresskey_sshkey_idkeys_addresskey%CREATE INDEX "keys_addresskey_sshkey_id" ON "keys_addresskey" ("sshkey_id")A+'indexkeys_addresskey_address_idkeys_addresskey$CREATE INDEX "keys_addresskey_address_id" ON "keys_addresskey" ("address_id")M-?indexdjango_admin_log_content_type_iddjango_admin_log#CREATE INDEX "django_admin_log_content_type_id" ON "django_admin_log" ("content_type_id")~=-indexdjango_admin_log_user_iddjango_admin_log"CREATE INDEX "django_admin_log_user_id" ON "django_admin_log" ("user_id")SgAindexsqlite_autoindex_auth_user_user_permissions_1auth_user_user_permissionsK+;indexauth_permission_content_type_idauth_permissionCREATE INDEX "auth_permission_content_type_id" ON "auth_permission" ("content_type_id")n5%indexauth_message_user_idauth_message CREATE INDEX "auth_message_user_id" ON "auth_message" ("user_id")

  
  
 
  {{9ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAuIabpSe85Xq8nGMpXUW6/MtU9ot3hCCFzLSGc9+5l4b9mTwJMcVe7njsbT14rGfq3lNwuaBKRNqbk2L48iRn/3/1duwn/oB1vDWC0+/OqKCqH2/Lw9mDHmM1NCHwv3MaGlMKWNttGdg5zvG0YFROe6zT3nSDNwT5g88ck0oOWu/5sku5ooTgNiXhP8o2/y0fIHenWgyEXzkHRqyJAIC+8KzfN9u/VChabI9iVKvwlSfpC3a4sh+nXVr2yAII0VlZ1eZVU+NO1R5v4RN6K9S6ZIqb1QViVp55g5ML8FaZeMYgpg2vW+fB0waxSYfZ629F+mghcygs718Qm7qd2jIP1w== crschmidt@crschmidt.net
eOssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEA3nNXOon+mjptjbZ+dYbYEMQH1ZW9xurECCBWZQPM32c49rJmLyIqgAfNSYQE1wgxIvxiJqmwh/8ji0ZQikPqJYtOUZ3+nKBdwpyRVK7B0/gtU098rssIeTANyadjsjfOIMVoIkfHuLbMb25b471TX9+xNw7X4anPtNbQb2CB6IM= chris@printf.net bIssh-dss AAAAB3NzaC1kc3MAAACBAOk0cgJv+4IZvwIHrDafTQSyq5Zz4rgR2T5pcGTxDHYJjTrlo8pos6t2sH1quJdkj9m55UyypbMzjh5ctPc9Nj4d2DEcfOdcfLpO1i1Q0xrsB94vBaIkyq5ltCCkY5FfxOe2sGT0F78hb/SwEZbvQoTQwMrHeSXlkcR8+n23o80vAAAAFQCtTM/R/PiV0p55Hkv4cnkYVKx7kQAAAIEAxBoy8jry01CqyZYhsZDyS0TCwSnAkUeMy2y2LDNplYa1OaCUR91qTEJS1rvDNdYxySd/8yF4CEd6IUe80PEO17PtmIO3sDCSlGtGyRPWgMCK0D1APIdN2QvHWQHfSbiWZifk3PVxLLyQli5Gkp95F4fzG69n4jaHCz0Di3lqpxoAAACAJEvh0XhdjNayKJaofzI0IsNZIesit2whsEAyXq3J+gqGfUDIFBsllCSsCmzqcez8ikb3v+nndxVxwn7nmU+fd0/hNP8nyqp26kumy5PwRuRRlP3E5VJD49alKyts3PYhHm8Rei+EBHL322Yw+Ujawr4b6aft069l6PEU0L6h0aA= cscott@laptop.org pessh-dss AAAAB3NzaC1kc3MAAACBAOk0cgJv+4IZvwIHrDafTQSyq5Zz4rgR2T5pcGTxDHYJjTrlo8po
s6t2sH1quJdkj9m55UyypbMzjh5ctPc9Nj4d2DEcfOdcfLpO1i1Q0xrsB94vBaIkyq5ltCCkY5FfxOe2
sGT0F78hb/SwEZbvQoTQwMrHeSXlkcR8+n23o80vAAAAFQCtTM/R/PiV0p55Hkv4cnkYVKx7kQAAAIEA
xBoy8jry01CqyZYhsZDyS0TCwSnAkUeMy2y2LDNplYa1OaCUR91qTEJS1rvDNdYxySd/8yF4CEd6IUe8
0PEO17PtmIO3sDCSlGtGyRPWgMCK0D1APIdN2QvHWQHfSbiWZifk3PVxLLyQli5Gkp95F4fzG69n4jaH
Cz0Di3lqpxoAAACAJEvh0XhdjNayKJaofzI0IsNZIesit2whsEAyXq3J+gqGfUDIFBsllCSsCmzqcez8
ikb3v+nndxVxwn7nmU+fd0/hNP8nyqp26kumy5PwRuRRlP3E5VJD49alKyts3PYhHm8Rei+EBHL322Yw
+Ujawr4b6aft069l6PEU0L6h0aA= cscott@laptop.org_Cssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEArZedYvRSttI/4TuiRO6xFtdlDKLeSlBHqF3kPfYbDeIbjXPgKFEJUMO+QWw5WJhNeVGkyqV6eHCT/PCiyRzZoB3wfgWalZShSRBPNsYbZJS93b+vuIfS+mrPcGB7BbcsLy49OILC6SaYY7dgcvmpEDabSYVX+78yzyhcy2I3Q0= mstone@sage=ssh-rsa foo
ssh-rsa bar 22jYssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEA3nNXOon+mjptjbZ+dYbYEMQH1ZW9xurECCBWZQPM32c49rJmLyIqgAfNSYQE1wgxIvxiJqmwh/8ji0ZQikPqJYtOUZ3+nKBdwpyRVK7B0/gtU098rssIeTANyadjsjfOIMVoIkfHuLbMb25b471TX9+xNw7X4anPtNbQb2CB6IM= cjb@beta.netcraft.com^Assh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEApMvZ3/GapkDakpFLwja+ayEvhrJBxFnYkZixNzaNmGM0JT3VH9hyPe5QJEnd8WrwEx4GJuOTYmUoEqeZt4UEznCzztgYnXzY9NG4QeAxyDSlxOG3RMQgtg7Kw6VZo+HeOLKQ/cg67ACxT9Jj5y6EOx/vg3C8nsSmKNnUphdf6vE= cjb@lexis 
s
A 2008-09-15 00:56:27.947534 Nonechris-sshkeys@printf.net / ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEA3nNXOon+mjptjbZ+dYbYEMQH1ZW9xurECCBWZQPM32c49rJmLyIqgAfNSYQE1wgxIvxiJqmwh/8ji0ZQikPqJYtOUZ3+nKBdwpyRVK7B0/gtU098rssIeTANyadjsjfOIMVoIkfHus
A 2008-09-14 23:44:57.817640
Nonessh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEApMvZ3/GapkDakpFLwja+ayEvhrJBxFnYkZixNzaNmGM0JT3VH9hyPe5QJEnd8WrwEx4GJuOTYmUoEqeZt4UEznCzztgYnXzY9NG4QeAxyDSlxOG3RMQgtg7Kw6VZo+HeOLKQ/cg67ACxT9Jj5y6EOx/vg3C8nsSmKNnUB A= 2008-09-14 23:44:34.635949 Nonechris-sshkeys@printf.nets
A 2008-09-14 23:44:24.512301 Nonechris-sshkeys@printf.net / ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEApMvZ3/GapkDakpFLwja+ayEvhrJBxFnYkZixNzaNmGM0JT3VH9hyPe5QJEnd8WrwEx4GJuOTYmUoEqeZt4UEznCzztgYnXzY9NG4QeAxyDSlxOG3RMQgtg7Kw6VZo+HeOLKQ/cg67 

s
A 2008-09-15 00:56:34.847888 Nonechris-sshkeys@printf.net / ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEApMvZ3/GapkDakpFLwja+ayEvhrJBxFnYkZixNzaNmGM0JT3VH9hyPe5QJEnd8WrwEx4GJuOTYmUoEqeZt4UEznCzztgYnXzY9NG4QeAxyDSlxOG3RMQgtg7Kw6VZo+HeOLKQ/cg67