File: geographic-management.sql

package info (click to toggle)
bandwidthd 2.0.1%2Bcvs20090917-4.1
  • links: PTS
  • area: main
  • in suites: squeeze
  • size: 1,064 kB
  • ctags: 560
  • sloc: sh: 13,357; ansic: 2,743; php: 1,235; yacc: 216; makefile: 160; lex: 36; sql: 27
file content (18 lines) | stat: -rwxr-xr-x 352 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
create table groups (
	group_id serial,
	name varchar,
	color varchar);
CREATE TABLE locations ( 
	id serial PRIMARY KEY, 
	name varchar, 
	group_id int default 0,
	latitude varchar,
	longitude varchar );
CREATE TABLE links_ignorelist (
	sensor_id int );
CREATE TABLE slices (
	id serial,
	sensor_id int,
	direction float,
	angle float,
	radius float);