File: create.sql

package info (click to toggle)
xtradius 1.1-pre2-1
  • links: PTS
  • area: main
  • in suites: woody
  • size: 880 kB
  • ctags: 803
  • sloc: ansic: 8,719; perl: 651; sh: 219; makefile: 116; 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)
);