8 uri_scheme TINYINT UNSIGNED, |
8 uri_scheme TINYINT UNSIGNED, |
9 transport TINYINT UNSIGNED, |
9 transport TINYINT UNSIGNED, |
10 strip TINYINT UNSIGNED, |
10 strip TINYINT UNSIGNED, |
11 tag CHAR(16) DEFAULT NULL, |
11 tag CHAR(16) DEFAULT NULL, |
12 flags INT UNSIGNED DEFAULT 0 NOT NULL, |
12 flags INT UNSIGNED DEFAULT 0 NOT NULL, |
|
13 user CHAR(16) DEFAULT NULL, |
|
14 realm CHAR(16) DEFAULT NULL, |
|
15 passwd CHAR(16) DEFAULT NULL, |
13 CONSTRAINT gw_name_idx UNIQUE (gw_name) |
16 CONSTRAINT gw_name_idx UNIQUE (gw_name) |
14 ) ENGINE=MyISAM; |
17 ) ENGINE=MyISAM; |
15 |
18 |
16 CREATE INDEX grp_id_idx ON gw (grp_id); |
19 CREATE INDEX grp_id_idx ON gw (grp_id); |
17 |
20 |