opensips/scripts/mysql/lcr-create.sql

changeset 17
733187d496d0
parent 16
c5c55937e44c
equal deleted inserted replaced
0:fedc5d2da14f 1:f701873fe1ec
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

mercurial