Podcastindex-org / database

21 stars 6 forks source link

Add example database schema #4

Closed saerdnaer closed 3 years ago

saerdnaer commented 4 years ago

It would be nice if this repo would also contain an example CREATE TABLE sql statement in which the dump can be imported to, e.g.

CREATE TABLE podcasts (
 id bigint,
 title text,
 url text,
 createdon timestamptz,
 link text,
 dead boolean,
 itunes_id bigint,
 original_url text,
 itunes_author text,
 itunes_owner_name text,
 itunes_new_feed_url text,
 explicit boolean,
 image text,
 itunes_type text,
 type int,
 generator text,
 newest_item_pubdate timestamptz,
 oldest_item_pubdate timestamptz,
 update_frequency int,
 language text,
 item_count int,
 PRIMARY KEY (id)
);
datamythology commented 3 years ago

Yes it would! Could Dave either run this command and share here:

"SHOW CREATE podcast" or "DESCRIBE podcast"

daveajones commented 3 years ago

Sure. I'll do that on the next dump and put in the repo.