File: geographic-management.sql

package info (click to toggle)
bandwidthd 2.0.1%2Bcvs20090917-7
  • links: PTS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 1,068 kB
  • ctags: 986
  • sloc: sh: 2,998; ansic: 2,746; php: 1,263; yacc: 216; makefile: 162; 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);