usage.sim

system sh/stop_dnodes.sh
system sh/deploy.sh -n dnode1 -m 192.168.0.1 -i 192.168.0.1
system sh/exec_up.sh -n dnode1 -s start
sql connect

print =============== show accounts

print =============== create account
sql alter account root pass "taosdata" tseries 8000 streams 10 dbs 5 users 5  
sql show accounts
print $data00 $data01 $data02 $data03 $data04 $data05 $data06
if $data00 != root then 
  return -1
endi
if $data02 != 3/5 then 
  return -1
endi
if $data03 != 0/5 then 
  return -1
endi
if $data04 != 0/8000 then 
  return -1
endi
if $data05 != 0/10 then 
  return -1
endi
  
print =============== check usage account
sql create database d1
sql create database d2
sql create database d3
sql create database d4
sql create database d5

sql create table d1.t1 (ts timestamp, i int);
sql create user u1 pass "u1"

sql show accounts
print $data10 $data11 $data12 $data13 $data14 $data15 $data16
if $data00 != root then 
  return -1
endi
if $data02 != 4/5 then 
  return -1
endi
if $data03 != 5/5 then 
  return -1
endi
if $data04 != 1/8000 then 
  return -1
endi
if $data05 != 0/10 then 
  return -1
endi

print =============== check grant
sql_error create database d6