From 0547ba1ab3337c382d0c9fca43c97c8f3c7817d7 Mon Sep 17 00:00:00 2001 From: Anton Tananaev Date: Tue, 24 Apr 2012 18:59:31 +0000 Subject: --- default.cfg | 85 ++++++++++++++++++++++++++++++++++++++++++++ nbproject/project.properties | 11 +++--- 2 files changed, 92 insertions(+), 4 deletions(-) create mode 100644 default.cfg diff --git a/default.cfg b/default.cfg new file mode 100644 index 000000000..156ee860c --- /dev/null +++ b/default.cfg @@ -0,0 +1,85 @@ + + + + + + + + org.h2.Driver + jdbc:h2:/home/user/Documents/database + sa + + + + Create database: + CREATE TABLE devices (id INT, imei VARCHAR(16)) + CREATE TABLE positions (device_id INT, time TIMESTAMP, is_valid BOOLEAN, latitude DOUBLE, longitude DOUBLE, speed DOUBLE, course DOUBLE, power DOUBLE) + <--> + + + id - Integer + imei - String + <--> + + SELECT id, imei + FROM devices + + + + device_id - Integer + time - Date + valid - Boolean + latitude - Double + longitude - Double + speed - Double + course - Double + power - Double (NULL for some protocols) + extended_info - String (XML) + <--> + + INSERT INTO positions (device_id, time, is_valid, latitude, longitude, speed, course, power) + VALUES (:device_id, :time, :valid, :latitude, :longitude, :speed, :course, :power) + + + + true + 5000 + 0 + + + true + 5001 + 0 + + + true + 5002 + 0 + + + true + 5003 + 0 + + + true + 5004 + 0 + + + true + 5005 + 0 + + + true + 5006 + 0 + + + true + 5007 + 0 + + + diff --git a/nbproject/project.properties b/nbproject/project.properties index 16f0ddc50..915a3fbef 100644 --- a/nbproject/project.properties +++ b/nbproject/project.properties @@ -26,15 +26,18 @@ dist.jar=${dist.dir}/tracker-server.jar dist.javadoc.dir=${dist.dir}/javadoc endorsed.classpath= excludes= -file.reference.junit-4.10.jar=/home/user/Documents/junit-4.10.jar -file.reference.netty-3.3.1.Final.jar=/home/user/Documents/netty-3.3.1.Final.jar +file.reference.h2-1.3.166.jar=/home/user/Documents/lib/h2-1.3.166.jar +file.reference.junit-4.10.jar=/home/user/Documents/lib/junit-4.10.jar +file.reference.mysql-connector-java-5.1.19-bin.jar=/home/user/Documents/lib/mysql-connector-java-5.1.19-bin.jar +file.reference.netty-3.4.1.Final.jar=/home/user/Documents/lib/netty-3.4.1.Final.jar includes=** jar.archive.disabled=${jnlp.enabled} jar.compress=false jar.index=${jnlp.enabled} javac.classpath=\ - ${libs.MySQLDriver.classpath}:\ - ${file.reference.netty-3.3.1.Final.jar} + ${file.reference.netty-3.4.1.Final.jar}:\ + ${file.reference.mysql-connector-java-5.1.19-bin.jar}:\ + ${file.reference.h2-1.3.166.jar} # Space-separated list of extra javac options javac.compilerargs= javac.deprecation=false -- cgit v1.2.3