corrected schema file
use transactions with shared connections
superadmin can create subscription