Release bumped to "gts4".

[tac_plus.git] / tac_plus.sql

diff --git a/tac_plus.sql b/tac_plus.sql
index 46003af..41caeea 100644 (file)
--- a/tac_plus.sql
+++ b/tac_plus.sql
@@ -5,10 +5,10 @@ CREATE DATABASE tacacs;
 USE tacacs;
 
 # id table fields are:
-# name | surname | usern | tel | address 
+# name | surname | usern | tel | address
 # name : Real name
 # surname : Surname
-# usern : Account name 
+# usern : Account name
 # tel: Tel number
 # address: Address
 
@@ -18,11 +18,11 @@ CREATE TABLE id ( name char(40) NOT NULL, surname char(40) NOT NULL,usern char(1
 # usern | passwd | exp_time | time_limit | lck
 # usern : Account name
 # passwd : usern password
-# exp_time : Expire date 
+# exp_time : Expire date
 # time_limit : Time limiting
-# lck : Adminstrative lock 
+# lck : Adminstrative lock
 
-CREATE TABLE auth( usern CHAR(15) NOT NULL, passwd CHAR(15) NOT NULL, exp_time TIMESTAMP(8) NOT NULL ,time_limit CHAR(30) DEFAULT "*",lck ENUM("T","F") DEFAULT "F",PRIMARY KEY(usern) ); 
+CREATE TABLE auth( usern CHAR(15) NOT NULL, passwd CHAR(15) NOT NULL, exp_time TIMESTAMP(8) NOT NULL ,time_limit CHAR(30) DEFAULT "*",lck ENUM("T","F") DEFAULT "F",PRIMARY KEY(usern) );
 
 # acct tables fields are:
 # usern | s_name | c_name | elapsed_time | bytes_in | bytes_out | fin_t
@@ -33,5 +33,5 @@ CREATE TABLE auth( usern CHAR(15) NOT NULL, passwd CHAR(15) NOT NULL, exp_time T
 # bytes_in : Incoming bytes to port
 # bytes_out : Outgoing bytes from port
 # fin_t :  When the accounting is finished
- 
+
 CREATE TABLE acct( usern CHAR(15) NOT NULL, s_name CHAR(30) NOT NULL, c_name CHAR(30) NOT NULL, elapsed_time INT NOT NULL, bytes_in INT DEFAULT 0, bytes_out INT  DEFAULT 0,fin_t TIMESTAMP(14) NOT NULL,INDEX acct_index(usern(10)));