File: create.sql

package info (click to toggle)
xtradius 1.2.1-beta2-6
  • links: PTS
  • area: main
  • in suites: lenny, squeeze
  • size: 1,256 kB
  • ctags: 921
  • sloc: ansic: 10,183; perl: 733; sh: 267; makefile: 148; sql: 21
file content (26 lines) | stat: -rw-r--r-- 519 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
# Script to construct 'login' & 'logout' table within 'accounting' database.
#
#
CREATE TABLE login(
login char(15),
start_record TIMESTAMP(14),
session_id char(255) NOT NULL,
PRIMARY KEY (start_record)
);

CREATE TABLE logout (
login char(15),
input_packets int(10),
output_packets int(10),
duration int (5),
ip_address char(15),
end_record TIMESTAMP(14),
session_id char(255) NOT NULL,
PRIMARY KEY (end_record)
);

CREATE TABLE users(
login char(15),
passwd char(14),
PRIMARY KEY (login)
);