APPUSERNAME = "appmanager@admin.com"
APPUSERPASS = "dgfg876jhgjjhg7tgjhg"
APPNAME = "App Manager knexjs"
APPSKU = "appmanagerknexjs"
PORT = 2000
DBHOST = 'localhost'
DBUSER = 'root'
DBPASS = '' 
DBNAME = "appmanagerknexjs"


DBHOST = 'localhost'
DBUSER = 'root'
DBPASS = 'Dhruti@321??' 
DBNAME = "appmanager"


npm run database
npm run table
npm run dev

--------------------------------------------------------------------------
                                Database
--------------------------------------------------------------------------

1) user
    - id = auto-increment
    - name = string ( 100 )
    - email = string (200)
    - password = string (20)
    - role = string ( 20 )
    - updated_at = timestemp 
    - created_at = timestemp

2 ) category
    - id = auto-increment
    - name = string ( 100 )
    - catsetting = longtext
    - updated_at = timestemp 
    - created_at = timestemp

3) application
    - id = auto-increment
    - package = text
    - serverkey = text
    - topic = text
    - developer = string ( 50 )
    - is_vpn = string ( 20 )
    - category = string ( 20 )
    - logo = text
    - setting_key = string ( 200 )
    - setting_iv = string ( 200 )
    - api_url = text
    - settingdata = longtext
    - status = string ( 30 ) ( developing, testing, progress, live, rejected, remove )
    - updated_at = timestemp 
    - created_at = timestemp

4) adminlog 
    - id = auto-increment
    - user = string ( 100 )
    - task = string ( 250 )
    - url - test
    - updated_at = timestemp 
    - created_at = timestemp

5) adminsetting
    - id = auto-increment
    - settingkey = string ( 200 )
    - settingvalue = logtext
    - updated_at = timestemp 
    - created_at = timestemp

6) adminnotification
    - id = auto-increment
    - msg = longtext
    - view = text
    - updated_at = timestemp 
    - created_at = timestemp

6) loginlog
    - id = auto-increment
    - ipaddress = string (100)
    - user = string ( 200 )
    - updated_at = timestemp 
    - created_at = timestemp