LinuxÏ´´½¨Êý¾Ý¿â±í£¨sqlite3£©µÄ½Å±¾

±¾ÎÄÒÔÊý¾Ý¿âÖеÄÊý¾Ý±íUserInfoΪʵÀýչʾÊý¾Ý¿â±íµÄ´´½¨¼°Êý¾Ý¼Ç¼µÄ¼Èë¡£
#!/bin/sh
#variables definition
#database location
db=/conf/db
#
#create table userInfo
#name: User name
#passwd: Password
#Privilege: User privilege -- Administrator:0 Operator:1
#
echo "create table UserInfo(name varchar(30) not null primary key, passwd varchar(8) not null, privilege int not null);" \
| /usr/local/bin/sqlite3 $db
echo "insert into UserInfo values('admin', 'access', 0);" | /usr/local/bin/sqlite3 $db
echo "insert into UserInfo values('user', 'access', 1);" | /usr/local/bin/sqlite3 $db