Skip to content

Instantly share code, notes, and snippets.

@bongbongco

bongbongco/techcontent.db

Last active October 15, 2016 05:09
Show Gist options
  • Save bongbongco/aefabe27e4ce52b4c4126fd3d410a79e to your computer and use it in GitHub Desktop.
Save bongbongco/aefabe27e4ce52b4c4126fd3d410a79e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
techcontent.db
/*
techcontents
title
site
url
platform
siteRating
pageRating
state
searchDate
decideDate
limitDate
*/
create database techcontent;
use techcontent;
create table contents (title VARCHAR(100), site VARCHAR(30), url VARCHAR(100), platform VARCHAR(10), siteRating INT(10), state VARCHAR(15), searchDate DATE, decideDate DATE, limitDate DATE, PRIMARY KEY (url));
describe contents;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment