source: src/db/create.sql@ 11407

Last change on this file since 11407 was 8968, checked in by dennisw, 14 years ago

csv_to_db.php - vars aanpassen voor gebruik
create.sql - db en tbl aangepast voor gemak

  • Property svn:eol-style set to native
  • Property svn:keywords set to Date Revision
  • Property svn:mime-type set to text/plain
File size: 257 bytes
Line 
1CREATE TABLE `db`.`tbl` (
2 `latitude` double(9,7) NOT NULL,
3 `longitude` double(9,7) NOT NULL,
4 `ssid` varchar(45) NOT NULL,
5 `mac` varchar(45) NOT NULL,
6 `encryption` tinyint(4) NOT NULL,
7 `ID` int(11) NOT NULL AUTO_INCREMENT,
8 PRIMARY KEY (`ID`)
9);
Note: See TracBrowser for help on using the repository browser.