github twitter email rss
SQL
0001 Jun 1
One minute read

SQL

Gui interface

http://www.sqlfiddle.com/

http://sqliteman.com
http://sqlitebrowser.sourceforge.net
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

http://www.mysql.com/products/workbench/
http://menial.co.uk/software/base/
http://www.sequelpro.com/

libs

http://unqlite.org/
http://en.wikipedia.org/wiki/LevelDB

create table songs (
song_id SERIAL PRIMARY KEY,
song_name TEXT UNIQUE NOT NULL,
playback_count SERIAL 
);


create table radio_log (
song_id REFERENCES songs,
PRIMARY KEY song_id,
played TIMESTAMP
);

TRUNCATE TABLE  `execution_log`
TRUNCATE TABLE  `log`

ALTER TABLE  `log` DROP FOREIGN KEY  `log_ibfk_1` ;

TRUNCATE TABLE  `songs`

ALTER TABLE  `log` ADD FOREIGN KEY (  `song_id` ) REFERENCES  `somafm_groovesalad`.`songs` (
`id`
) ON DELETE RESTRICT ON UPDATE CASCADE ;

Back to posts


comments powered by Disqus