informatica:linux:bbdd:sqlite
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
informatica:linux:bbdd:sqlite [2015/08/20 13:26] – javi | informatica:linux:bbdd:sqlite [2015/08/20 13:37] (current) – javi | ||
---|---|---|---|
Line 23: | Line 23: | ||
sqlite3 / | sqlite3 / | ||
+ | < | ||
+ | DROP TABLE IF EXISTS RADIO; | ||
+ | |||
+ | CREATE TABLE RADIO ( | ||
+ | id TEXT NOT NULL PRIMARY KEY, | ||
+ | name TEXT NOT NULL, | ||
+ | description TEXT, | ||
+ | url TEXT NOT NULL, | ||
+ | longitude REAL, | ||
+ | latitude REAL, | ||
+ | altitude REAL | ||
+ | ); | ||
+ | |||
+ | INSERT INTO " | ||
+ | </ |
informatica/linux/bbdd/sqlite.1440077165.txt.gz · Last modified: 2015/08/20 13:26 by javi