wget http://www.sqlite.org/sqlite-3.6.16.tar.gz
TAR-ZXVF sqlite-3.6.16.tar.gz
CD sqlite-3.6.16
./configure
Make;make Install
Ln-s/usr/local/bin/sqlite3/usr/bin/sqlite
[Email protected] ipsecmc]# sqliteuser.db
SQLite version 3.6.16
Enter '. Help ' for instructions
Enter SQL statements terminated with a ";"
Sqlite>
Sqlite>. Tables
P2pvpn_client
Sqlite> SELECT * fromp2pvpn_client;
group001|test001|123456
group001|test002|123456
group001|test003|123456
group001|test004|123456
group001|test005|123456
group002|test001|123456
group002|test002|123456
group002|test003|123456
group002|test004|123456
group002|test005|123456 Sqlite>. Schema
CREATE TABLE P2pvpn_client (
GroupName varchar (+) NULL,
Username varchar (+) NULL,
Password varchar (+) NULL);Sqlite>INSERT INTO "p2pvpn_client" values ("group001", "test006", "123456");
Sqlite>select * fromp2pvpn_client;
group001|test001|123456
group001|test002|123456< BR style= "LINE-HEIGHT:25PX;" >GROUP001|TEST003|123456
group001|test004|123456
group002|test001|123456
group002|test003|123456
group002|test005|123456
< Span style= "color: #ff0000; line-height:25px; " >GROUP001|TEST006|123456
sqlite>
sqlite>. Exit
