-
Notifications
You must be signed in to change notification settings - Fork 0
demo.db.postgres.sql
Johan Abbors edited this page Jan 14, 2017
·
2 revisions
BEGIN TRANSACTION;
CREATE TABLE kados.userlog (
"id" bigserial PRIMARY KEY,
"user_id" INTEGER NOT NULL,
"datetime" timestamp without time zone NOT NULL,
"request" TEXT NOT NULL,
"response" TEXT NOT NULL,
"ip" TEXT NOT NULL DEFAULT '0.0.0.0'
);
ALTER TABLE kados.userlog
OWNER TO kados;
CREATE TABLE kados.user (
"id" bigserial PRIMARY KEY,
"username" TEXT NOT NULL,
"password" TEXT NOT NULL,
"log" INTEGER NOT NULL DEFAULT '0'
);
ALTER TABLE kados.user
OWNER TO kados;
INSERT INTO kados.user (id,username,password,log) VALUES (1,'kolibre','kolibre',1);
CREATE TABLE kados.category (
"id" bigserial PRIMARY KEY,
"name" TEXT NOT NULL
);
ALTER TABLE kados.category
OWNER TO kados;
INSERT INTO kados.category (id,name) VALUES (1,'BOOK');
INSERT INTO kados.category (id,name) VALUES (2,'MAGAZINE');
INSERT INTO kados.category (id,name) VALUES (3,'NEWSPAPER');
INSERT INTO kados.category (id,name) VALUES (4,'OTHER');
CREATE TABLE kados.daisyformat (
"id" bigserial PRIMARY KEY,
"format" TEXT NOT NULL
);
ALTER TABLE kados.daisyformat
OWNER TO kados;
INSERT INTO kados.daisyformat (id,format) VALUES (1,'Daisy 2.02');
INSERT INTO kados.daisyformat (id,format) VALUES (2,'ANSI/NISO Z39.86-2005');
INSERT INTO kados.daisyformat (id,format) VALUES (3,'PDTB2');
CREATE TABLE kados.content (
"id" bigserial PRIMARY KEY,
"category_id" INTEGER NOT NULL,
"daisyformat_id" INTEGER NOT NULL,
"title" TEXT NOT NULL,
"date" timestamp without time zone NOT NULL,
--FOREIGN KEY("category_id") REFERENCES "category"("id") ON DELETE SET NULL ON UPDATE SET NULL,
CONSTRAINT nalp_content_category_association_category_id_fkey FOREIGN KEY ("category_id")
REFERENCES kados."category" ("id") MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE,
--FOREIGN KEY("daisyformat_id") REFERENCES "daisyformat"("id") ON DELETE SET NULL ON UPDATE SET NULL
CONSTRAINT nalp_content_daisyformat_association_daisyformat_id_fkey FOREIGN KEY ("daisyformat_id")
REFERENCES kados."daisyformat" ("id") MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE
);
ALTER TABLE kados.content
OWNER TO kados;
INSERT INTO kados.content (id,category_id,daisyformat_id,title,date) VALUES (1,1,1,'A light Man','2009-06-22 00:00:00');
INSERT INTO kados.content (id,category_id,daisyformat_id,title,date) VALUES (2,1,2,'Are you ready?','2009-04-26 00:00:00');
INSERT INTO kados.content (id,category_id,daisyformat_id,title,date) VALUES (3,1,1,'Climbing the Highest Mountain','2003-05-08 00:00:00');
CREATE TABLE kados.contentlist (
"id" bigserial PRIMARY KEY,
"name" TEXT NOT NULL
);
ALTER TABLE kados.contentlist
OWNER TO kados;
INSERT INTO kados.contentlist (id,name) VALUES (1,'new');
INSERT INTO kados.contentlist (id,name) VALUES (2,'issued');
INSERT INTO kados.contentlist (id,name) VALUES (3,'expired');
INSERT INTO kados.contentlist (id,name) VALUES (4,'returned');
CREATE TABLE kados.usercontent (
"id" bigserial PRIMARY KEY,
"user_id" bigserial NOT NULL,
"content_id" INTEGER NOT NULL,
"contentlist_id" INTEGER NOT NULL,
"return" INTEGER NOT NULL,
"returned" INTEGER NOT NULL DEFAULT '1',
"return_at" timestamp without time zone DEFAULT NULL,
"updated_at" timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
--FOREIGN KEY("user_id") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE SET NULL,
CONSTRAINT nalp_usercontent_user_association_user_id_fkey FOREIGN KEY ("user_id")
REFERENCES kados."user" ("id") MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE,
--FOREIGN KEY("content_id") REFERENCES "content"("id") ON DELETE SET NULL ON UPDATE SET NULL,
CONSTRAINT nalp_usercontent_usercontent_content_content_id_fkey FOREIGN KEY ("content_id")
REFERENCES kados."content" ("id") MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE,
--FOREIGN KEY("contentlist_id") REFERENCES "contentlist"("id") ON DELETE SET NULL ON UPDATE SET NULL
CONSTRAINT nalp_usercontent_contentlist_association_contentlist_id_fkey FOREIGN KEY ("contentlist_id")
REFERENCES kados."contentlist" ("id") MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE
);
ALTER TABLE kados.usercontent
OWNER TO kados;
INSERT INTO kados.usercontent (id,user_id,content_id,contentlist_id,return,returned,return_at,updated_at) VALUES (1,1,1,4,1,1,'2016-12-18 17:26:37','2016-11-18 17:26:33');
INSERT INTO kados.usercontent (id,user_id,content_id,contentlist_id,return,returned,return_at,updated_at) VALUES (2,1,2,4,1,1,'2016-12-18 17:26:36','2016-11-18 17:26:34');
INSERT INTO kados.usercontent (id,user_id,content_id,contentlist_id,return,returned,return_at,updated_at) VALUES (3,1,3,4,1,1,'2016-12-18 17:26:36','2016-11-18 17:26:35');
CREATE TABLE kados.contentresource (
"id" bigserial PRIMARY KEY,
"content_id" INTEGER NOT NULL DEFAULT '0',
"filename" TEXT NOT NULL DEFAULT '',
"bytes" INTEGER NOT NULL DEFAULT '0',
"mimetype" TEXT NOT NULL DEFAULT 'unknown',
--FOREIGN KEY("content_id") REFERENCES "content"("id") ON DELETE SET NULL ON UPDATE SET NULL
CONSTRAINT nalp_contentresource_content_association_content_id_fkey FOREIGN KEY ("content_id")
REFERENCES kados."content" ("id") MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE
);
ALTER TABLE kados.contentresource
OWNER TO kados;
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (1,1,'01_A_light_Man.mp3',45531,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (2,1,'02_Epigraph.mp3',176822,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (3,1,'03_April_4th_1857.mp3',1540205,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (4,1,'04_7th_.mp3',1204845,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (5,1,'05_D_the_14th_.mp3',8934948,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (6,1,'06_19th_.mp3',2863908,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (7,1,'07_22d_.mp3',4464640,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (8,1,'08_26th_.mp3',1939748,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (9,1,'09_May_3d_.mp3',1940662,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (10,1,'10_8th_.mp3',2005028,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (11,1,'11_13th_.mp3',741302,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (12,1,'12_18th_.mp3',691565,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (13,1,'13_20th_.mp3',2834468,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (14,1,'14_21st_.mp3',1639497,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (15,1,'15_22d_.mp3',451657,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (16,1,'16_23d_.mp3',4836205,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (17,1,'17_24th_.mp3',348342,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (18,1,'er_book_info.xml',1108,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (19,1,'icth0001.smil',1086,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (20,1,'icth0002.smil',2128,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (21,1,'icth0003.smil',6888,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (22,1,'icth0004.smil',4667,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (23,1,'icth0005.smil',27641,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (24,1,'icth0006.smil',10464,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (25,1,'icth0007.smil',12533,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (26,1,'icth0008.smil',6417,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (27,1,'icth0009.smil',6967,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (28,1,'icth000a.smil',6154,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (29,1,'icth000b.smil',2248,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (30,1,'icth000c.smil',2417,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (31,1,'icth000d.smil',7990,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (32,1,'icth000e.smil',5311,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (33,1,'icth000f.smil',2517,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (34,1,'icth0010.smil',17455,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (35,1,'icth0011.smil',2217,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (36,1,'master.smil',1866,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (37,1,'ncc.html',5759,'text/html');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (38,1,'smil10.dtd',7496,'text/html');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (39,1,'xhtml-lat1.ent',11789,'text/html');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (40,1,'xhtml-special.ent',4144,'text/html');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (41,1,'xhtml-symbol.ent',14127,'text/html');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (42,1,'xhtml1-transitional.dtd',33441,'text/html');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (43,2,'AreYouReadyV3.xml',89235,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (44,2,'dtbookbasic.css',12801,'text/x-c');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (45,2,'image1.jpg',6168,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (46,2,'image11.jpg',5586,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (47,2,'image12.jpg',4826,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (48,2,'image13.jpg',12586,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (49,2,'image14.jpg',17587,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (50,2,'image2.jpg',8577,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (51,2,'image3.jpg',5981,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (52,2,'image4.jpg',4720,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (53,2,'image5.jpg',6589,'image/jpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (54,2,'speechgen.ncx',18280,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (55,2,'speechgen.opf',8897,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (56,2,'speechgen0001.mp3',32757,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (57,2,'speechgen0001.smil',882,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (58,2,'speechgen0002.mp3',215823,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (59,2,'speechgen0002.smil',2716,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (60,2,'speechgen0003.mp3',285257,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (61,2,'speechgen0003.smil',5457,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (62,2,'speechgen0004.mp3',228832,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (63,2,'speechgen0004.smil',1477,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (64,2,'speechgen0005.mp3',1865456,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (65,2,'speechgen0005.smil',10463,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (66,2,'speechgen0006.mp3',735399,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (67,2,'speechgen0006.smil',4470,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (68,2,'speechgen0007.mp3',105482,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (69,2,'speechgen0007.smil',1438,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (70,2,'speechgen0008.mp3',95294,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (71,2,'speechgen0008.smil',1491,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (72,2,'speechgen0009.mp3',794801,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (73,2,'speechgen0009.smil',7443,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (74,2,'speechgen0010.mp3',258299,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (75,2,'speechgen0010.smil',2873,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (76,2,'speechgen0011.mp3',249835,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (77,2,'speechgen0011.smil',2192,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (78,2,'speechgen0012.mp3',225071,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (79,2,'speechgen0012.smil',2285,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (80,2,'speechgen0013.mp3',1677374,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (81,2,'speechgen0013.smil',11510,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (82,2,'speechgen0014.mp3',372872,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (83,2,'speechgen0014.smil',2480,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (84,2,'speechgen0015.mp3',439327,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (85,2,'speechgen0015.smil',3243,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (86,2,'speechgen0016.mp3',121469,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (87,2,'speechgen0016.smil',1691,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (88,2,'speechgen0017.mp3',2289110,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (89,2,'speechgen0017.smil',17070,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (90,2,'speechgen0018.mp3',1220493,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (91,2,'speechgen0018.smil',9825,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (92,2,'speechgen0019.mp3',181185,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (93,2,'speechgen0019.smil',1640,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (94,2,'speechgen0020.mp3',1113756,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (95,2,'speechgen0020.smil',7023,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (96,2,'speechgen0021.mp3',446694,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (97,2,'speechgen0021.smil',3453,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (98,2,'speechgen0022.mp3',191216,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (99,2,'speechgen0022.smil',1492,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (100,2,'speechgen0023.mp3',1083977,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (101,2,'speechgen0023.smil',6373,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (102,2,'speechgen0024.mp3',354690,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (103,2,'speechgen0024.smil',2690,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (104,2,'speechgen0025.mp3',193410,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (105,2,'speechgen0025.smil',1835,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (106,2,'speechgen0026.mp3',112222,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (107,2,'speechgen0026.smil',1493,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (108,2,'speechgen0027.mp3',605466,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (109,2,'speechgen0027.smil',4580,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (110,2,'speechgen0028.mp3',136516,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (111,2,'speechgen0028.smil',1430,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (112,2,'speechgen0029.mp3',92943,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (113,2,'speechgen0029.smil',1439,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (114,2,'speechgen0030.mp3',112535,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (115,2,'speechgen0030.smil',1493,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (116,2,'speechgen0031.mp3',1319863,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (117,2,'speechgen0031.smil',10153,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (118,2,'speechgen0032.mp3',584150,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (119,2,'speechgen0032.smil',5658,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (120,2,'speechgen0033.mp3',256104,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (121,2,'speechgen0033.smil',1850,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (122,2,'speechgen0034.mp3',284630,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (123,2,'speechgen0034.smil',2480,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (124,2,'tpbnarrator.res',9458,'text/html');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (125,2,'tpbnarrator_res.mp3',117656,'application/octet-stream');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (126,3,'ncconlydemo.html',3642,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (127,3,'bagw0008.smil',2714,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (128,3,'bagw0017.mp3',124760,'audio/mpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (129,3,'bagw0019.mp3',180558,'audio/mpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (130,3,'bagw0006.smil',2765,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (131,3,'bagw001B.mp3',285570,'audio/mpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (132,3,'bagw0014.mp3',391836,'audio/mpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (133,3,'bagw0007.smil',1567,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (134,3,'bagw0018.mp3',65515,'audio/mpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (135,3,'bagw001A.mp3',129776,'audio/mpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (136,3,'bagw0005.smil',1130,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (137,3,'master.smil',1196,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (138,3,'bagw0003.smil',2419,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (139,3,'ncc.html',4296,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (140,3,'bagw0002.smil',1334,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (141,3,'narrator_1.css',5204,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (142,3,'default_1.css',5053,'text/plain');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (143,3,'bagw001C.mp3',451552,'audio/mpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (144,3,'bagw0001.smil',1728,'application/xml');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (145,3,'bagw001D.mp3',335882,'audio/mpeg');
INSERT INTO kados.contentresource (id,content_id,filename,bytes,mimetype) VALUES (146,3,'bagw0004.smil',3047,'application/xml');
CREATE TABLE kados.contentmetadata (
"id" bigserial PRIMARY KEY,
"content_id" INTEGER NOT NULL ,
"key" TEXT NOT NULL,
"value" TEXT NOT NULL,
--FOREIGN KEY("content_id") REFERENCES "content"("id") ON DELETE SET NULL ON UPDATE SET NULL
CONSTRAINT nalp_contentmetadata_content_association_content_id_fkey FOREIGN KEY ("content_id")
REFERENCES kados."content" ("id") MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE
);
ALTER TABLE kados.contentmetadata
OWNER TO kados;
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (1,1,'dc:creator','Henry James');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (2,1,'dc:date','2009-06-22');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (3,1,'dc:format','Daisy 2.02');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (4,1,'dc:identifier','Unknown');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (5,1,'dc:language','en');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (6,1,'dc:publisher','DC');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (7,1,'dc:source','The galaxy vol. 8 no. 1 (July 1869), pages 49-68');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (8,1,'dc:subject','Relationships, betrayal');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (9,1,'dc:title','A light Man');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (10,1,'ncc:charset','utf-8');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (11,1,'ncc:depth','1');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (12,1,'ncc:files','36');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (13,1,'ncc:footnotes','0');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (14,1,'ncc:generator','EasePublisher 2.13 Build 163 # 044FS2212172434');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (15,1,'ncc:kbytesize','35930');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (16,1,'ncc:maxpagenormal','26');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (17,1,'ncc:multimediatype','audioNcc');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (18,1,'ncc:narrator','OM');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (19,1,'ncc:pagefront','0');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (20,1,'ncc:pagenormal','26');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (21,1,'ncc:pagespecial','0');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (22,1,'ncc:prodnotes','0');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (23,1,'ncc:setinfo','1 of 1');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (24,1,'ncc:sidebars','0');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (25,1,'ncc:sourcedate','2009-07-18');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (26,1,'ncc:sourceedition','1.');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (27,1,'ncc:sourcepublisher','The galaxy vol. 8 no. 1 (July 1869), pages 49-68');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (28,1,'ncc:sourcerights','Gutenberg project');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (29,1,'ncc:sourcetitle','A light man');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (30,1,'ncc:tocitems','43');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (31,1,'ncc:totaltime','01:27:15');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (32,1,'prod:ep_update','');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (33,1,'prod:last_used_id','');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (34,2,'dc:creator','WikiHow');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (35,2,'dc:date','2009-04-26');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (36,2,'dc:format','ANSI/NIZO Z39.86-2005');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (37,2,'dc:identifier','5078727220897727718');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (38,2,'dc:language','en-IN');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (39,2,'dc:publisher','DAISY India');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (40,2,'dc:subject','A Short Manual for Disaster Management');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (41,2,'dc:title','ARE YOU READY?');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (42,3,'dc:title','Climbing the Highest Mountain');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (43,3,'dc:creator','Per Sennels');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (44,3,'dc:date','2003-05-08');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (45,3,'dc:format','Daisy 2.02');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (46,3,'dc:identifier','skipdemo-amsterdam');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (47,3,'dc:language','en');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (48,3,'dc:publisher','DAISY Consortium');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (49,3,'dc:subject','Mountains');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (50,3,'ncc:pagefront','0');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (51,3,'ncc:pagenormal','8');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (52,3,'ncc:pagespecial','0');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (53,3,'ncc:setinfo','1 of 1');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (54,3,'ncc:depth','3');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (55,3,'ncc:maxpagenormal','8');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (56,3,'ncc:multimediatype','audioNcc');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (57,3,'ncc:narrator','Joan Dahm-Simonsen');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (58,3,'ncc:producer','Huseby kompetansesenter');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (59,3,'ncc:generator','Skippability Tweaker 0.1.53');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (60,3,'ncc:sidebars','4');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (61,3,'ncc:prodnotes','2');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (62,3,'ncc:footnotes','1');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (63,3,'ncc:totaltime','00:05:27');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (64,3,'ncc:charset','windows-1252');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (65,3,'ncc:files','20');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (66,3,'ncc:kbytesize','1975');
INSERT INTO kados.contentmetadata (id,content_id,key,value) VALUES (67,3,'ncc:tocitems','23');
CREATE TABLE kados.contentaudio (
"id" bigserial PRIMARY KEY,
"content_id" INTEGER NOT NULL,
"size" INTEGER NOT NULL,
"length" INTEGER NOT NULL,
--FOREIGN KEY("content_id") REFERENCES "content"("id") ON DELETE SET NULL ON UPDATE SET NULL
CONSTRAINT nalp_contentaudio_content_association_content_id_fkey FOREIGN KEY ("content_id")
REFERENCES kados."content" ("id") MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE
);
ALTER TABLE kados.contentaudio
OWNER TO kados;
INSERT INTO kados.contentaudio (id,content_id,size,length) VALUES (1,1,44724,6315);
INSERT INTO kados.contentaudio (id,content_id,size,length) VALUES (2,2,16139,5201);
INSERT INTO kados.contentaudio (id,content_id,size,length) VALUES (3,3,20335,1945);
CREATE INDEX index_foreignkey_userlog_user ON kados.userlog (user_id);
CREATE INDEX index_foreignkey_usercontent_user ON kados.usercontent (user_id);
CREATE INDEX index_foreignkey_usercontent_contentlist ON kados.usercontent (contentlist_id);
CREATE INDEX index_foreignkey_usercontent_content ON kados.usercontent (content_id);
CREATE INDEX index_foreignkey_contentresource_content ON kados.contentresource (content_id);
CREATE INDEX index_foreignkey_contentmetadata_content ON kados.contentmetadata (content_id);
CREATE INDEX index_foreignkey_contentaudio_content ON kados.contentaudio (content_id);
CREATE INDEX index_foreignkey_content_daisyformat ON kados.content (daisyformat_id);
CREATE INDEX index_foreignkey_content_category ON kados.content (category_id);
COMMIT;