1 /*

     2 * Copyright (c) 2008-2009 Nokia Corporation and/or its subsidiary(-ies).

     3 * All rights reserved.

     4 * This component and the accompanying materials are made available

     5 * under the terms of "Eclipse Public License v1.0"

     6 * which accompanies this distribution, and is available

     7 * at the URL "http://www.eclipse.org/legal/epl-v10.html".

     8 *

     9 * Initial Contributors:

    10 * Nokia Corporation - initial contribution.

    11 *

    12 * Contributors:

    13 *

    14 * Description:  javastoragetables

    15 *

    16 */

    17 

    18 

    19 #ifndef JAVASTORAGETABLES_H

    20 #define JAVASTORAGETABLES_H

    21 

    22 namespace java

    23 {

    24 namespace storage

    25 {

    26 

    27 const char APPLICATION_PACKAGE[] = "CREATE TABLE APPLICATION_PACKAGE ( \

    28 ID VARCHAR(12) PRIMARY KEY, PACKAGE_NAME VARCHAR(50), VENDOR VARCHAR(50), \

    29 VERSION VARCHAR(10), ROOT_PATH VARCHAR(256), MEDIA_ID INT(10), \

    30 INITIAL_SIZE INT(15), JAD_PATH VARCHAR(256), JAR_PATH VARCHAR(256), \

    31 JAD_URL VARCHAR, JAR_URL VARCHAR, ACCESS_POINT VARCHAR(256), CONTENT_INFO INT(2), \

    32 CONTENT_ID VARCHAR(256));";

    33 

    34 const char APPLICATION[] = "CREATE TABLE APPLICATION ( ID VARCHAR(12) \

    35 PRIMARY KEY, PACKAGE_ID VARCHAR(12), NAME VARCHAR(50), MAIN_CLASS VARCHAR(50), \

    36 AUTORUN INT(2));";

    37 

    38 const char APPLICATION_PACKAGE_ATTRIBUTES[] = "CREATE TABLE \

    39 APPLICATION_PACKAGE_ATTRIBUTES ( ID VARCHAR(12), NAME VARCHAR(50), \

    40 VALUE VARCHAR(600), TRUSTED INT(2), PRIMARY KEY(ID, NAME));";

    41 

    42 const char MIDP_PACKAGE[] = "CREATE TABLE MIDP_PACKAGE ( ID VARCHAR(12) \

    43 PRIMARY KEY, TYPE VARCHAR(50), SECURITY_DOMAIN VARCHAR(50), \

    44 SECURITY_DOMAIN_CATEGORY VARCHAR(10), HASH VARCHAR(40), CERT_HASH VARCHAR(10), \

    45 RMS VARCHAR(256), VALID_CERTS VARCHAR(30), ON_SCREEN_KEYPAD INT(2), \

    46 SECURITY_WARNINGS INT(2));";

    47 

    48 const char MIDP_PERMISSIONS[] = "CREATE TABLE MIDP_PERMISSIONS ( ID \

    49 VARCHAR(12), CLASS VARCHAR(100), NAME VARCHAR(50), ACTION VARCHAR(50), \

    50 FUNCTION_GROUP VARCHAR(50));";

    51 

    52 const char MIDP_FUNC_GRP_SETTINGS[] = "CREATE TABLE MIDP_FUNCTION_GRP_SETTINGS \

    53 ( ID VARCHAR(12), FUNCTION_GROUP VARCHAR(50), ALLOWED_SETTINGS INT(3), \

    54 CURRENT_SETTING INT(3), BLANKET_PROMPT INT(3), PRIMARY KEY(ID, \

    55 FUNCTION_GROUP));";

    56 

    57 const char PUSH_REGISTRATIONS[] = "CREATE TABLE PUSH_REGISTRATIONS \

    58 ( ID VARCHAR(12), URL VARCHAR(256) PRIMARY KEY, NAME VARCHAR(50), \

    59 FILTER VARCHAR(100), REGISTRATION_TYPE INT(1));";

    60 

    61 const char ALARM_REGISTRATIONS[] = "CREATE TABLE ALARM_REGISTRATIONS \

    62 ( ID VARCHAR(12) PRIMARY KEY, ALARM_TIME VARCHAR(50));";

    63 

    64 const char RUNTIME_SETTINGS[] = "CREATE TABLE RUNTIME_SETTINGS ( \

    65 EXTENSIONS VARCHAR PRIMARY KEY);";

    66 

    67 const char OTA_STATUS[] = "CREATE TABLE OTA_STATUS ( ID VARCHAR(12), \

    68 CREATION_TIME VARCHAR(50), TYPE INT(2), OTA_CODE INT(4), URL VARCHAR(256), \

    69 LATEST_RETRY_TIME VARCHAR(50), RETRY_COUNT INT(2));";

    70 

    71 const char PREINSTALL[] = "CREATE TABLE PREINSTALL ( NAME VARCHAR(50), \

    72 VENDOR VARCHAR(50), VERSION VARCHAR(50), INSTALL_STATE INT(1));";

    73 

    74 }    // java

    75 }    // storage

    76 

    77 #endif // JAVASTORAGETABLES_H

    78