- result r = E_SUCCESS;
- Database db;
- String createQuery;
-
- if (File::IsFileExist(PACKAGE_DATABASE_FILE_NAME) == true)
- {
- SysLog(NID_APP, ".app-package.db is already existed!");
- return r;
- }
-
- r = db.Construct(PACKAGE_DATABASE_FILE_NAME, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.Construct is failed. [%s]", GetErrorMessage(r));
-
- // PkgInfo
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS PkgInfo"
- "( UNIQUE_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
- "PKG_ID TEXT,"
- "PKG_SECRET TEXT,"
- "PKG_VERSION TEXT,"
- "PKG_TYPE TEXT,"
- "PKG_MIMETYPE TEXT,"
- "PKG_APIVERSION TEXT,"
- "PKG_NAME TEXT,"
- "PKG_VENDOR TEXT,"
- "PKG_DESCRIPTION TEXT,"
- "PKG_URL TEXT,"
- "PKG_CID TEXT,"
- "PKG_READONLY_SIZE INTEGER,"
- "PKG_DATA_SIZE INTEGER,"
- "PKG_PARENT_ID TEXT,"
- "PKG_ATTRIBUTE INTEGER,"
- "PKG_ROOTPATH TEXT,"
- "PKG_STORAGE_TYPE INTEGER,"
- "PKG_INSTALLATION_DATE TEXT,"
- "PKG_STATE INTEGER,"
- "PKG_INITIATOR INTEGER )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // PkgPrivileges
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS PkgPrivileges"
- "( ID INTEGER,"
- "PRIVILEGES TEXT,"
- "HMAC_PPRIVILEGES TEXT,"
- "CERTIFICATE_TYPE INTEGER )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // PkgIntegrity
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS PkgIntegrity"
- "( ID INTEGER,"
- "HMAC_APPID TEXT,"
- "HMAC_APPSECRET TEXT,"
- "HMAC_HTB TEXT,"
- "SLOT_NUM INTEGER )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // AppInfo
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS AppInfo"
- "( UNIQUE_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
- "ID INTEGER,"
- "APP_NAME TEXT,"
- "APP_TYPE TEXT,"
- "APP_DEFAULT TEXT,"
- "APP_MAINMENU_ICON TEXT,"
- "APP_SETTING_ICON TEXT,"
- "APP_TICKER_ICON TEXT,"
- "APP_QUICKPANEL_ICON TEXT,"
- "APP_LAUNCHIMAGE_ICON TEXT,"
- "APP_FEATURE INTEGER,"
- "PACKAGE_NAME TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // Notification
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS Notification"
- "( ID INTEGER,"
- "NAME TEXT,"
- "VALUE TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // AppFeature
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS AppFeature"
- "( ID INTEGER,"
- "NAME TEXT,"
- "VALUE TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // LaunchCondition
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS LaunchCondition"
- "( ID INTEGER,"
- "NAME TEXT,"
- "VALUE TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // DataControl
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS DataControl"
- "( ID INTEGER,"
- "PROVIDER_ID TEXT,"
- "TYPE TEXT,"
- "ACCESS TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // Capability
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS Capability"
- "( ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
- "OPERATION_ID TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // ResolutionUriScheme
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS ResolutionUriScheme"
- "( ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
- "URI_SCHEME TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // ResolutionMimeType
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS ResolutionMimeType"
- "( ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
- "MIME_TYPE TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // AppControl
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS AppControl"
- "( ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
- "PROVIDER_ID TEXT,"
- "CATEGORY TEXT )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();
-
- // AppInfoLookup
- createQuery.Format(1024, L"CREATE TABLE IF NOT EXISTS AppInfoLookup"
- "( AppInfoID INTEGER,"
- "CapabilityID INTEGER,"
- "ResolutionUriSchemeID INTEGER,"
- "ResolutionMimeTypeID INTEGER,"
- "AppControlID INTEGER )");
- r = db.ExecuteSql(createQuery, true);
- SysTryReturn(NID_APP, r == E_SUCCESS, r, r, "MakePackageDb: db.ExecuteSql is failed. [%s]", GetErrorMessage(r));
- createQuery.Clear();