-
Notifications
You must be signed in to change notification settings - Fork 32
/
Copy pathdata.sql
282 lines (282 loc) · 28.1 KB
/
data.sql
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
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
BEGIN TRANSACTION;
CREATE TABLE "auth_group" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(80) NOT NULL UNIQUE);
INSERT INTO auth_group VALUES(1,'Librarians');
CREATE TABLE "auth_group_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "group_id" integer NOT NULL REFERENCES "auth_group" ("id"), "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"), UNIQUE ("group_id", "permission_id"));
INSERT INTO auth_group_permissions VALUES(1,1,28);
INSERT INTO auth_group_permissions VALUES(2,1,19);
INSERT INTO auth_group_permissions VALUES(3,1,20);
INSERT INTO auth_group_permissions VALUES(4,1,22);
INSERT INTO auth_group_permissions VALUES(5,1,25);
CREATE TABLE "auth_permission" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(50) NOT NULL, "content_type_id" integer NOT NULL REFERENCES "django_content_type" ("id"), "codename" varchar(100) NOT NULL, UNIQUE ("content_type_id", "codename"));
INSERT INTO auth_permission VALUES(1,'Can add log entry',1,'add_logentry');
INSERT INTO auth_permission VALUES(2,'Can change log entry',1,'change_logentry');
INSERT INTO auth_permission VALUES(3,'Can delete log entry',1,'delete_logentry');
INSERT INTO auth_permission VALUES(4,'Can add permission',2,'add_permission');
INSERT INTO auth_permission VALUES(5,'Can change permission',2,'change_permission');
INSERT INTO auth_permission VALUES(6,'Can delete permission',2,'delete_permission');
INSERT INTO auth_permission VALUES(7,'Can add group',3,'add_group');
INSERT INTO auth_permission VALUES(8,'Can change group',3,'change_group');
INSERT INTO auth_permission VALUES(9,'Can delete group',3,'delete_group');
INSERT INTO auth_permission VALUES(10,'Can add user',4,'add_user');
INSERT INTO auth_permission VALUES(11,'Can change user',4,'change_user');
INSERT INTO auth_permission VALUES(12,'Can delete user',4,'delete_user');
INSERT INTO auth_permission VALUES(13,'Can add content type',5,'add_contenttype');
INSERT INTO auth_permission VALUES(14,'Can change content type',5,'change_contenttype');
INSERT INTO auth_permission VALUES(15,'Can delete content type',5,'delete_contenttype');
INSERT INTO auth_permission VALUES(16,'Can add session',6,'add_session');
INSERT INTO auth_permission VALUES(17,'Can change session',6,'change_session');
INSERT INTO auth_permission VALUES(18,'Can delete session',6,'delete_session');
INSERT INTO auth_permission VALUES(19,'Can add book',7,'add_book');
INSERT INTO auth_permission VALUES(20,'Can change book',7,'change_book');
INSERT INTO auth_permission VALUES(21,'Can delete book',7,'delete_book');
INSERT INTO auth_permission VALUES(22,'Can add lend periods',8,'add_lendperiods');
INSERT INTO auth_permission VALUES(23,'Can change lend periods',8,'change_lendperiods');
INSERT INTO auth_permission VALUES(24,'Can delete lend periods',8,'delete_lendperiods');
INSERT INTO auth_permission VALUES(25,'Can add publisher',9,'add_publisher');
INSERT INTO auth_permission VALUES(26,'Can change publisher',9,'change_publisher');
INSERT INTO auth_permission VALUES(27,'Can delete publisher',9,'delete_publisher');
INSERT INTO auth_permission VALUES(28,'Can add author',10,'add_author');
INSERT INTO auth_permission VALUES(29,'Can change author',10,'change_author');
INSERT INTO auth_permission VALUES(30,'Can delete author',10,'delete_author');
INSERT INTO auth_permission VALUES(31,'Can add user profile',11,'add_userprofile');
INSERT INTO auth_permission VALUES(32,'Can change user profile',11,'change_userprofile');
INSERT INTO auth_permission VALUES(33,'Can delete user profile',11,'delete_userprofile');
INSERT INTO auth_permission VALUES(34,'Can add Quotation',12,'add_quotationfrombook');
INSERT INTO auth_permission VALUES(35,'Can change Quotation',12,'change_quotationfrombook');
INSERT INTO auth_permission VALUES(36,'Can delete Quotation',12,'delete_quotationfrombook');
INSERT INTO auth_permission VALUES(37,'Can add user',13,'add_user');
INSERT INTO auth_permission VALUES(38,'Can change user',13,'change_user');
INSERT INTO auth_permission VALUES(39,'Can delete user',13,'delete_user');
INSERT INTO auth_permission VALUES(40,'Can add OAuth token',14,'add_oauthtoken');
INSERT INTO auth_permission VALUES(41,'Can change OAuth token',14,'change_oauthtoken');
INSERT INTO auth_permission VALUES(42,'Can delete OAuth token',14,'delete_oauthtoken');
CREATE TABLE "auth_user" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "password" varchar(128) NOT NULL, "last_login" datetime NOT NULL, "is_superuser" bool NOT NULL, "username" varchar(30) NOT NULL UNIQUE, "first_name" varchar(30) NOT NULL, "last_name" varchar(30) NOT NULL, "email" varchar(75) NOT NULL, "is_staff" bool NOT NULL, "is_active" bool NOT NULL, "date_joined" datetime NOT NULL);
INSERT INTO auth_user VALUES(1,'pbkdf2_sha256$12000$72SIz2cZFZQJ$ZNZv9ygwUwu8VdBP/OfReI64diEggPQNsVHwKgZXkuc=','2015-01-01 17:34:39.288632',1,'potan','Tomasz','Potanski','[email protected]',1,1,'2014-11-26 08:57:01');
INSERT INTO auth_user VALUES(4,'pbkdf2_sha256$12000$Dj6JKxDJNSzm$CEzMz+5Suon7V7Hl1i2z+515AON3PSTLywbxVu6A1M0=','2014-12-28 16:50:28.911124',0,'user1','Joanna','Binkowska','[email protected]',0,1,'2014-12-18 12:44:26');
INSERT INTO auth_user VALUES(5,'pbkdf2_sha256$12000$fRjiz2ujAyHk$OTRcGIZsmuRozxqVSxD/mHL8PRNnyKvXwZiSK9qCqIM=','2015-01-01 20:19:47.390861',0,'assistant','John','Smith','[email protected]',0,1,'2014-12-27 16:21:21');
INSERT INTO auth_user VALUES(7,'pbkdf2_sha256$12000$RC1sumyksWDY$8GHPDhz+VmEhMWKIK88KanaVg7sJfMCpcqE2e6yS+Jk=','2014-12-29 23:57:00.102954',0,'Arkadiusz_1375943392708267','Arkadiusz','Głowacki','',0,1,'2014-12-29 23:42:08.067524');
CREATE TABLE "auth_user_groups" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" integer NOT NULL REFERENCES "auth_user" ("id"), "group_id" integer NOT NULL REFERENCES "auth_group" ("id"), UNIQUE ("user_id", "group_id"));
INSERT INTO auth_user_groups VALUES(3,5,1);
CREATE TABLE "auth_user_user_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" integer NOT NULL REFERENCES "auth_user" ("id"), "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"), UNIQUE ("user_id", "permission_id"));
CREATE TABLE "django_admin_log" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "action_time" datetime NOT NULL, "object_id" text NULL, "object_repr" varchar(200) NOT NULL, "action_flag" smallint unsigned NOT NULL, "change_message" text NOT NULL, "content_type_id" integer NULL REFERENCES "django_content_type" ("id"), "user_id" integer NOT NULL REFERENCES "auth_user" ("id"));
INSERT INTO django_admin_log VALUES(1,'2014-12-18 11:07:02.909524',1,'Author object',1,'',10,1);
INSERT INTO django_admin_log VALUES(2,'2014-12-18 11:07:17.562323',2,'Author object',1,'',10,1);
INSERT INTO django_admin_log VALUES(3,'2014-12-18 11:07:41.550869',3,'Author object',1,'',10,1);
INSERT INTO django_admin_log VALUES(4,'2014-12-18 11:07:58.066359',4,'Author object',1,'',10,1);
INSERT INTO django_admin_log VALUES(5,'2014-12-18 11:44:02.179435',1,'LendPeriods object',1,'',8,1);
INSERT INTO django_admin_log VALUES(6,'2014-12-18 11:44:11.393029',2,'LendPeriods object',1,'',8,1);
INSERT INTO django_admin_log VALUES(7,'2014-12-18 11:44:16.579852',3,'LendPeriods object',1,'',8,1);
INSERT INTO django_admin_log VALUES(8,'2014-12-18 11:44:24.369815',4,'LendPeriods object',1,'',8,1);
INSERT INTO django_admin_log VALUES(9,'2014-12-18 11:44:57.651760',1,'Publisher object',1,'',9,1);
INSERT INTO django_admin_log VALUES(10,'2014-12-18 11:45:09.977578',2,'Publisher object',1,'',9,1);
INSERT INTO django_admin_log VALUES(11,'2014-12-18 11:45:20.268462',3,'Publisher object',1,'',9,1);
INSERT INTO django_admin_log VALUES(12,'2014-12-18 11:45:40.006041',4,'Publisher object',1,'',9,1);
INSERT INTO django_admin_log VALUES(13,'2014-12-18 12:04:03.741511',1,'Book: Brave New World',1,'',7,1);
INSERT INTO django_admin_log VALUES(14,'2014-12-18 12:05:13.708630',2,'Book: Dive Into Python 3',1,'',7,1);
INSERT INTO django_admin_log VALUES(15,'2014-12-18 12:06:25.202693',3,'Book: The Master and Margarita',1,'',7,1);
INSERT INTO django_admin_log VALUES(16,'2014-12-18 12:06:59.920519',4,'Book: Animal Farm',1,'',7,1);
INSERT INTO django_admin_log VALUES(17,'2014-12-18 12:13:06.931459',1,'potan',2,'Changed email.',4,1);
INSERT INTO django_admin_log VALUES(18,'2014-12-18 12:37:14.249093',1,'[email protected]',2,'Changed username.',4,1);
INSERT INTO django_admin_log VALUES(19,'2014-12-18 12:37:33.261418',2,'eugen',3,'',4,1);
INSERT INTO django_admin_log VALUES(20,'2014-12-18 12:45:01.172911',1,'potan',2,'Changed username.',4,1);
INSERT INTO django_admin_log VALUES(21,'2014-12-18 12:47:20.538286',3,'[email protected]',3,'',4,1);
INSERT INTO django_admin_log VALUES(22,'2014-12-18 18:41:36.257185',5,'Already lent',1,'',8,1);
INSERT INTO django_admin_log VALUES(23,'2014-12-18 18:42:05.081183',1,'Book: Brave New World',2,'Changed lend_period and lend_by.',7,1);
INSERT INTO django_admin_log VALUES(24,'2014-12-18 21:06:55.378351',5,'Already lent',3,'',8,1);
INSERT INTO django_admin_log VALUES(25,'2014-12-18 21:09:04.360830',2,'Book: Dive Into Python 3',2,'No fields changed.',7,1);
INSERT INTO django_admin_log VALUES(26,'2014-12-18 21:11:18.031915',5,'Book: Animal Farm',1,'',7,1);
INSERT INTO django_admin_log VALUES(27,'2014-12-18 21:12:42.812177',6,'Book: Brave New World',1,'',7,1);
INSERT INTO django_admin_log VALUES(28,'2014-12-18 21:14:08.048236',7,'Book: The Master and Margarita',1,'',7,1);
INSERT INTO django_admin_log VALUES(29,'2014-12-18 22:01:15.150289',2,'User profile: potan, ',2,'Changed friends.',11,1);
INSERT INTO django_admin_log VALUES(30,'2014-12-18 22:01:19.297070',2,'User profile: potan, ',2,'No fields changed.',11,1);
INSERT INTO django_admin_log VALUES(31,'2014-12-18 22:01:23.413266',1,'User profile: ala, a a',2,'No fields changed.',11,1);
INSERT INTO django_admin_log VALUES(32,'2014-12-25 20:17:38.922821',5,'Book: Animal Farm',2,'Changed lend_by.',7,1);
INSERT INTO django_admin_log VALUES(33,'2014-12-25 20:17:47.365234',2,'Book: Dive Into Python 3',2,'Changed lend_by.',7,1);
INSERT INTO django_admin_log VALUES(34,'2014-12-26 13:26:22.116186',5,'Publisher: Martino Fine Books',1,'',9,1);
INSERT INTO django_admin_log VALUES(35,'2014-12-26 13:27:31.167287',5,'Author: Herbert Wells',1,'',10,1);
INSERT INTO django_admin_log VALUES(36,'2014-12-26 13:27:48.614296',8,'Book: The time machine',1,'',7,1);
INSERT INTO django_admin_log VALUES(37,'2014-12-26 13:29:03.483326',6,'Publisher: Sterling',1,'',9,1);
INSERT INTO django_admin_log VALUES(38,'2014-12-26 13:29:19.691782',6,'Author: Napoleon Hill',1,'',10,1);
INSERT INTO django_admin_log VALUES(39,'2014-12-26 13:29:31.125566',9,'Book: Outwitting the devil',1,'',7,1);
INSERT INTO django_admin_log VALUES(40,'2014-12-26 13:30:18.432092',7,'Publisher: Capstone',1,'',9,1);
INSERT INTO django_admin_log VALUES(41,'2014-12-26 13:30:49.293965',10,'Book: Think and Grow Rich',1,'',7,1);
INSERT INTO django_admin_log VALUES(42,'2014-12-27 13:54:20.360568',1,'potan',2,'Changed first_name and last_name.',4,1);
INSERT INTO django_admin_log VALUES(43,'2014-12-27 13:54:38.930884',2,'User profile: potan, imie nazwisko',2,'Changed mobile and website.',11,1);
INSERT INTO django_admin_log VALUES(44,'2014-12-27 14:12:52.182892',4,'ala',2,'Changed first_name, last_name and email.',4,1);
INSERT INTO django_admin_log VALUES(45,'2014-12-27 14:21:30.889143',1,'User profile: ala, fna lna',2,'Changed fb_name.',11,1);
INSERT INTO django_admin_log VALUES(46,'2014-12-27 14:35:41.447117',1,'quotation: Dictionaries...',1,'',12,1);
INSERT INTO django_admin_log VALUES(47,'2014-12-27 14:36:05.163083',2,'quotation: del lets you...',1,'',12,1);
INSERT INTO django_admin_log VALUES(48,'2014-12-27 15:31:51.083531',7,'Book: The Master and Margarita',2,'Changed lend_from.',7,1);
INSERT INTO django_admin_log VALUES(49,'2014-12-27 16:25:17.735258',1,'Librarians',1,'',3,1);
INSERT INTO django_admin_log VALUES(50,'2014-12-28 00:12:20.356253',1,'Librarians',2,'Changed permissions.',3,1);
INSERT INTO django_admin_log VALUES(51,'2014-12-28 00:13:01.503827',5,'bigboss',2,'Changed groups.',4,1);
INSERT INTO django_admin_log VALUES(52,'2014-12-28 16:36:48.454535',5,'assistant',2,'Changed username, first_name and last_name.',4,1);
INSERT INTO django_admin_log VALUES(53,'2014-12-28 16:37:22.878489',4,'user1',2,'Changed username, first_name and last_name.',4,1);
INSERT INTO django_admin_log VALUES(54,'2014-12-28 16:37:45.961547',1,'potan',2,'Changed email.',4,1);
INSERT INTO django_admin_log VALUES(55,'2014-12-28 16:37:59.541053',1,'potan',2,'Changed first_name and last_name.',4,1);
INSERT INTO django_admin_log VALUES(56,'2014-12-28 16:38:40.789987',5,'assistant',2,'Changed email.',4,1);
INSERT INTO django_admin_log VALUES(57,'2014-12-29 14:36:36.135757',11,'Book: test',1,'',7,1);
INSERT INTO django_admin_log VALUES(58,'2014-12-29 23:05:01.117680',6,1375943392708267,3,'',4,1);
INSERT INTO django_admin_log VALUES(59,'2015-01-01 17:51:30.432190',17,'Author: ee eee',1,'',10,1);
CREATE TABLE "django_content_type" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(100) NOT NULL, "app_label" varchar(100) NOT NULL, "model" varchar(100) NOT NULL, UNIQUE ("app_label", "model"));
INSERT INTO django_content_type VALUES(1,'log entry','admin','logentry');
INSERT INTO django_content_type VALUES(2,'permission','auth','permission');
INSERT INTO django_content_type VALUES(3,'group','auth','group');
INSERT INTO django_content_type VALUES(4,'user','auth','user');
INSERT INTO django_content_type VALUES(5,'content type','contenttypes','contenttype');
INSERT INTO django_content_type VALUES(6,'session','sessions','session');
INSERT INTO django_content_type VALUES(7,'book','library_app','book');
INSERT INTO django_content_type VALUES(8,'lend periods','library_app','lendperiods');
INSERT INTO django_content_type VALUES(9,'publisher','library_app','publisher');
INSERT INTO django_content_type VALUES(10,'author','library_app','author');
INSERT INTO django_content_type VALUES(11,'user profile','library_app','userprofile');
INSERT INTO django_content_type VALUES(12,'Quotation','library_app','quotationfrombook');
INSERT INTO django_content_type VALUES(13,'user','fandjango','user');
INSERT INTO django_content_type VALUES(14,'OAuth token','fandjango','oauthtoken');
CREATE TABLE "django_migrations" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "app" varchar(255) NOT NULL, "name" varchar(255) NOT NULL, "applied" datetime NOT NULL);
INSERT INTO django_migrations VALUES(1,'contenttypes','0001_initial','2014-11-26 08:56:13.445594');
INSERT INTO django_migrations VALUES(2,'auth','0001_initial','2014-11-26 08:56:13.691214');
INSERT INTO django_migrations VALUES(3,'admin','0001_initial','2014-11-26 08:56:13.980948');
INSERT INTO django_migrations VALUES(4,'sessions','0001_initial','2014-11-26 08:56:14.248413');
INSERT INTO django_migrations VALUES(5,'library_app','0001_initial','2014-12-16 13:00:56.684812');
INSERT INTO django_migrations VALUES(6,'library_app','0002_auto_20141218_1051','2014-12-18 10:51:47.024954');
INSERT INTO django_migrations VALUES(7,'library_app','0003_auto_20141218_1200','2014-12-18 12:00:23.823715');
INSERT INTO django_migrations VALUES(8,'library_app','0004_quotationfrombook','2014-12-27 14:33:36.369764');
INSERT INTO django_migrations VALUES(9,'library_app','0005_auto_20141229_1907','2014-12-29 19:07:55.233913');
CREATE TABLE "django_session" ("session_key" varchar(40) NOT NULL PRIMARY KEY, "session_data" text NOT NULL, "expire_date" datetime NOT NULL);
INSERT INTO django_session VALUES('ejjgd6r9wsp7oojohtlpmgxl6wdpd1rl','MjViYTMzN2JlZjhlMmZhNzI0NzcxNWJjMTkzOTIyMTZiY2NiNmQ3ZDp7fQ==','2014-12-10 08:59:11.813485');
INSERT INTO django_session VALUES('e59dd3tk4b1xfqo585mnu6i8dq3en47y','YjY3ZjAzNWFlZDE5MjEyZWM1NGMwY2Y1YzM2ZDYzNGVmNmM3NWIzYTp7Il9hdXRoX3VzZXJfaGFzaCI6IjllNzEyNTIyMjZmYjUzMTIxYjcwZTUxOGU5YWU2NDMyMGY5YmRmNWEiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOjF9','2015-01-08 19:00:58.349162');
INSERT INTO django_session VALUES('5wvxe5br7owfp86rp7dgcvwpprgasths','ZjY5ODk2OGNiZTBjOTNiZDc3MmJjM2QzODIwNWMyYjk4NDUwZmJkZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjliMWY3YTgyNjFlMTg1YjM5MmM0ZGZhNmQ0NWE0MDEwZjU4YzdhNDkiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOjF9','2015-01-10 13:07:06.982241');
INSERT INTO django_session VALUES('fh5ml9mqdbgd713inux2q7js8tunqlrd','ZjY5ODk2OGNiZTBjOTNiZDc3MmJjM2QzODIwNWMyYjk4NDUwZmJkZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjliMWY3YTgyNjFlMTg1YjM5MmM0ZGZhNmQ0NWE0MDEwZjU4YzdhNDkiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOjF9','2015-01-11 14:05:31.579031');
INSERT INTO django_session VALUES('o7txras2bhzhnfki3g5gxqydsp8t67is','NDIwZGRlZjdhYThkMzEwZmQ4ODk1Mzk1MmU3Y2M1MDZhZWEzY2QyYTp7Il9hdXRoX3VzZXJfaGFzaCI6IjMxMzdmMWExODE4MjMzOGUwODY3NDEwOWUwOTE0NmEwMDk4MTFkNDYiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJsaWJyYXJ5X2FwcC5hdXRoX2JhY2tlbmQuUGFzc3dvcmRsZXNzQXV0aEJhY2tlbmQiLCJfYXV0aF91c2VyX2lkIjo3fQ==','2015-01-12 23:57:00.215015');
INSERT INTO django_session VALUES('cewv5u0q5jzn64qksspwecenmx8ozj33','MjViYTMzN2JlZjhlMmZhNzI0NzcxNWJjMTkzOTIyMTZiY2NiNmQ3ZDp7fQ==','2015-01-14 00:02:42.262086');
INSERT INTO django_session VALUES('o8ha1chwpgr4nlofsqxcsu6ddvwqkgbe','NWFjZDc0YmIxYzU5OTI4MDZjY2Q4ZTM2MDJmYTQ2ODYzM2U0OWIwOTp7Il9hdXRoX3VzZXJfaGFzaCI6IjBjYzA5MTY2ZjY1ZjRhYjc1YjU4N2Y1M2MxNzU0MjQwN2ZhYmI5MmMiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOjV9','2015-01-15 20:19:47.547011');
CREATE TABLE "fandjango_oauthtoken" (
"id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"token" text NOT NULL,
"issued_at" datetime NOT NULL,
"expires_at" datetime
);
INSERT INTO fandjango_oauthtoken VALUES(3,'CAANymIYL3dkBAM0RruSZCKfbPwBtO9WbjBFRCcgvqzbakpZAEVYnRP92TdDZBspHSC1Xt6vNdkpWnUfzbIVEoNu1aaQRTZCXOSKscKUFjG1ca6cZBylBR1PHdSX7ZB9RoML71e3DTvUw9ioLaf2NFNG1LYspCXPTw7cqmg9ZBLYPUfeNDEUHcPK3Jc67KIEDdiRaZC6IZAoimeFA6tMDFYh03','2014-12-29 23:43:46.014723','2015-02-27 22:14:27.014735');
CREATE TABLE "fandjango_user" (
"id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"facebook_id" bigint NOT NULL UNIQUE,
"facebook_username" varchar(255),
"first_name" varchar(255),
"middle_name" varchar(255),
"last_name" varchar(255),
"birthday" date,
"email" varchar(255),
"locale" varchar(255),
"gender" varchar(255),
"authorized" bool NOT NULL,
"oauth_token_id" integer NOT NULL UNIQUE,
"created_at" datetime NOT NULL,
"last_seen_at" datetime NOT NULL,
"extra_data" text NOT NULL
);
INSERT INTO fandjango_user VALUES(1,1375943392708267,NULL,'Arkadiusz',NULL,'Glowacki',NULL,NULL,'en_US','female',1,3,'2014-12-29 22:14:34.033831','2014-12-30 00:13:04.186505','{"first_name": "Arkadiusz", "last_name": "Glowacki", "verified": true, "name": "Arkadiusz Glowacki", "locale": "en_US", "gender": "female", "updated_time": "2014-12-29T23:40:20+0000", "link": "https://www.facebook.com/app_scoped_user_id/1375943392708267/", "timezone": 1, "id": "1375943392708267"}');
CREATE TABLE "library_app_author" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(100) NOT NULL, "surname" varchar(100) NOT NULL, "date_of_birth" date NOT NULL);
INSERT INTO library_app_author VALUES(1,'Aldous','Huxley','2014-12-18');
INSERT INTO library_app_author VALUES(2,'Mark','Pilgrim','2014-12-18');
INSERT INTO library_app_author VALUES(3,'Mikhail','Bulgakov','2014-12-18');
INSERT INTO library_app_author VALUES(4,'George','Orwell','2014-12-18');
INSERT INTO library_app_author VALUES(5,'Herbert','Wells','2014-12-26');
INSERT INTO library_app_author VALUES(6,'Napoleon','Hill','2014-12-26');
INSERT INTO library_app_author VALUES(7,'testName','testSurnae','2001-01-01');
INSERT INTO library_app_author VALUES(8,'aaa','bbb','2003-02-03');
INSERT INTO library_app_author VALUES(9,'rrr','rrrr','2004-04-04');
INSERT INTO library_app_author VALUES(10,'vv','vv','2005-05-05');
INSERT INTO library_app_author VALUES(11,'vvRRRR','vv','2005-05-05');
INSERT INTO library_app_author VALUES(12,'testName2','testSurnae','2001-01-01');
INSERT INTO library_app_author VALUES(13,'testName3','testSurnae3','2001-01-01');
INSERT INTO library_app_author VALUES(14,'ann','nas','2002-02-07');
INSERT INTO library_app_author VALUES(17,'ee','eee','2015-01-01');
CREATE TABLE "library_app_book" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" varchar(200) NOT NULL, "ISBN" varchar(200) NOT NULL, "page_amount" integer NOT NULL, "author_id" integer NOT NULL REFERENCES "library_app_author" ("id"), "lend_by_id" integer NULL REFERENCES "library_app_userprofile" ("id"), "lend_period_id" integer NOT NULL REFERENCES "library_app_lendperiods" ("id"), "publisher_id" integer NOT NULL REFERENCES "library_app_publisher" ("id"), "lend_from" date NULL);
INSERT INTO library_app_book VALUES(2,'Dive Into Python 3','978-1430224150',360,2,3,4,2,'2014-12-28');
INSERT INTO library_app_book VALUES(5,'Animal Farm2','978-1502492791',46,4,1,3,4,'2014-12-28');
INSERT INTO library_app_book VALUES(6,'Brave New World','978-0060850524',288,1,NULL,4,1,NULL);
INSERT INTO library_app_book VALUES(7,'The Master and Margarita','978-0679760801',384,3,3,3,3,'2014-12-28');
INSERT INTO library_app_book VALUES(8,'The time machine','978-1614271970',80,5,NULL,1,5,NULL);
INSERT INTO library_app_book VALUES(9,'Outwitting the devil','978-1454900672',288,6,2,3,6,'2014-12-28');
INSERT INTO library_app_book VALUES(10,'Think and Grow Rich','978-1906465599',388,6,NULL,3,7,NULL);
CREATE TABLE "library_app_lendperiods" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(50) NOT NULL, "days_amount" integer NOT NULL);
INSERT INTO library_app_lendperiods VALUES(1,'week',7);
INSERT INTO library_app_lendperiods VALUES(2,'two weeks',14);
INSERT INTO library_app_lendperiods VALUES(3,'month',31);
INSERT INTO library_app_lendperiods VALUES(4,'two months',62);
CREATE TABLE "library_app_publisher" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(100) NOT NULL);
INSERT INTO library_app_publisher VALUES(1,'Harper Perennial Modern Classics');
INSERT INTO library_app_publisher VALUES(2,'Apress');
INSERT INTO library_app_publisher VALUES(3,'Vintage');
INSERT INTO library_app_publisher VALUES(4,'CreateSpace Independent Publishing Platform');
INSERT INTO library_app_publisher VALUES(5,'Martino Fine Books');
INSERT INTO library_app_publisher VALUES(6,'Sterling');
INSERT INTO library_app_publisher VALUES(7,'Capstone');
CREATE TABLE "library_app_quotationfrombook" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "quotation" varchar(600) NOT NULL, "creation_date" date NOT NULL, "user_id" integer NOT NULL REFERENCES "auth_user" ("id"), "book_id" integer NOT NULL REFERENCES "library_app_book" ("id"));
INSERT INTO library_app_quotationfrombook VALUES(1,'Dictionaries have no concept of order among elements. It is incorrect to say that the elements are “out of order”','2014-12-27',1,2);
INSERT INTO library_app_quotationfrombook VALUES(2,'del lets you delete individual items from a dictionary by key. ','2014-12-27',1,2);
INSERT INTO library_app_quotationfrombook VALUES(3,'Everything will turn out right, the world is built on that.','2014-12-27',1,7);
INSERT INTO library_app_quotationfrombook VALUES(4,'Words can be like X-rays if you use them properly -- they’ll go through anything. You read and you’re pierced.','2014-12-28',5,6);
INSERT INTO library_app_quotationfrombook VALUES(5,'One believes things because one has been conditioned to believe them.','2014-12-28',5,6);
INSERT INTO library_app_quotationfrombook VALUES(6,'Ending is better than mending.','2014-12-28',5,6);
INSERT INTO library_app_quotationfrombook VALUES(7,'A love of nature keeps no factories busy.','2014-12-28',5,6);
INSERT INTO library_app_quotationfrombook VALUES(8,'Four legs good, two legs bad.','2014-12-28',4,5);
INSERT INTO library_app_quotationfrombook VALUES(9,'Man is the only creature that consumes without producing','2014-12-28',4,5);
INSERT INTO library_app_quotationfrombook VALUES(10,'Surely, comrades, you don''t want Jones back?','2014-12-28',4,5);
INSERT INTO library_app_quotationfrombook VALUES(11,'The capacity to surmount failure without being discouraged is the chief asset of every person who attains outstanding success in any calling.','2014-12-28',1,9);
INSERT INTO library_app_quotationfrombook VALUES(12,'Remember that your dominating thoughts attract,
through a definite law of nature, by the shortest and most
convenient route, their physical counterpart. Be careful what
your thoughts dwell upon.','2014-12-28',1,9);
CREATE TABLE "library_app_userprofile" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "mobile" varchar(15) NULL, "fb_name" varchar(60) NULL, "join_date" date NOT NULL, "user_id" integer NOT NULL UNIQUE REFERENCES "auth_user" ("id"), "website" varchar(50) NULL);
INSERT INTO library_app_userprofile VALUES(1,'','moj_fejs','2014-12-18',4,'');
INSERT INTO library_app_userprofile VALUES(2,'telefon...','','2014-12-18',1,'stronkal');
INSERT INTO library_app_userprofile VALUES(3,NULL,NULL,'2014-12-27',5,NULL);
INSERT INTO library_app_userprofile VALUES(5,NULL,NULL,'2014-12-29',7,NULL);
CREATE TABLE "library_app_userprofile_friends" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "from_userprofile_id" integer NOT NULL REFERENCES "library_app_userprofile" ("id"), "to_userprofile_id" integer NOT NULL REFERENCES "library_app_userprofile" ("id"), UNIQUE ("from_userprofile_id", "to_userprofile_id"));
INSERT INTO library_app_userprofile_friends VALUES(9,1,2);
INSERT INTO library_app_userprofile_friends VALUES(10,2,1);
INSERT INTO library_app_userprofile_friends VALUES(13,3,2);
INSERT INTO library_app_userprofile_friends VALUES(14,2,3);
INSERT INTO library_app_userprofile_friends VALUES(15,3,1);
INSERT INTO library_app_userprofile_friends VALUES(16,1,3);
INSERT INTO library_app_userprofile_friends VALUES(17,5,2);
INSERT INTO library_app_userprofile_friends VALUES(18,2,5);
CREATE TABLE sqlite_sequence(name,seq);
INSERT INTO sqlite_sequence VALUES('django_content_type',14);
INSERT INTO sqlite_sequence VALUES('django_migrations',9);
INSERT INTO sqlite_sequence VALUES('auth_permission',42);
INSERT INTO sqlite_sequence VALUES('auth_user',7);
INSERT INTO sqlite_sequence VALUES('library_app_userprofile',5);
INSERT INTO sqlite_sequence VALUES('library_app_author',17);
INSERT INTO sqlite_sequence VALUES('django_admin_log',59);
INSERT INTO sqlite_sequence VALUES('library_app_lendperiods',6);
INSERT INTO sqlite_sequence VALUES('library_app_publisher',9);
INSERT INTO sqlite_sequence VALUES('library_app_book',12);
INSERT INTO sqlite_sequence VALUES('library_app_userprofile_friends',18);
INSERT INTO sqlite_sequence VALUES('auth_group',1);
INSERT INTO sqlite_sequence VALUES('auth_group_permissions',5);
INSERT INTO sqlite_sequence VALUES('auth_user_groups',3);
INSERT INTO sqlite_sequence VALUES('library_app_quotationfrombook',12);
INSERT INTO sqlite_sequence VALUES('fandjango_oauthtoken',3);
INSERT INTO sqlite_sequence VALUES('fandjango_user',1);
CREATE INDEX auth_group_permissions_0e939a4f ON "auth_group_permissions" ("group_id");
CREATE INDEX auth_group_permissions_8373b171 ON "auth_group_permissions" ("permission_id");
CREATE INDEX auth_permission_417f1b1c ON "auth_permission" ("content_type_id");
CREATE INDEX auth_user_groups_0e939a4f ON "auth_user_groups" ("group_id");
CREATE INDEX auth_user_groups_e8701ad4 ON "auth_user_groups" ("user_id");
CREATE INDEX auth_user_user_permissions_8373b171 ON "auth_user_user_permissions" ("permission_id");
CREATE INDEX auth_user_user_permissions_e8701ad4 ON "auth_user_user_permissions" ("user_id");
CREATE INDEX django_admin_log_417f1b1c ON "django_admin_log" ("content_type_id");
CREATE INDEX django_admin_log_e8701ad4 ON "django_admin_log" ("user_id");
CREATE INDEX django_session_de54fa62 ON "django_session" ("expire_date");
CREATE INDEX library_app_book_2604cbea ON "library_app_book" ("publisher_id");
CREATE INDEX library_app_book_4f331e2f ON "library_app_book" ("author_id");
CREATE INDEX library_app_book_848b62fc ON "library_app_book" ("lend_period_id");
CREATE INDEX library_app_book_fa35e1ef ON "library_app_book" ("lend_by_id");
CREATE INDEX library_app_quotationfrombook_0a4572cc ON "library_app_quotationfrombook" ("book_id");
CREATE INDEX library_app_quotationfrombook_e8701ad4 ON "library_app_quotationfrombook" ("user_id");
CREATE INDEX library_app_userprofile_friends_257192e2 ON "library_app_userprofile_friends" ("to_userprofile_id");
CREATE INDEX library_app_userprofile_friends_6c3c534c ON "library_app_userprofile_friends" ("from_userprofile_id");
COMMIT;