/*

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

* All rights reserved.

* This component and the accompanying materials are made available

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

* which accompanies this distribution, and is available

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

*

* Initial Contributors:

* Nokia Corporation - initial contribution.

*

* Contributors:

*

* Description:  javastoragetables

*

*/

#ifndef JAVASTORAGETABLES_H

#define JAVASTORAGETABLES_H

namespace java

{

namespace storage

{

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

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

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

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

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

CONTENT_ID VARCHAR(256));";

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

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

AUTORUN INT(2));";

const char APPLICATION_PACKAGE_ATTRIBUTES[] = "CREATE TABLE \

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

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

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

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

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

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

SECURITY_WARNINGS INT(2));";

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

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

FUNCTION_GROUP VARCHAR(50));";

const char MIDP_FUNC_GRP_SETTINGS[] = "CREATE TABLE MIDP_FUNCTION_GRP_SETTINGS \

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

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

FUNCTION_GROUP));";

const char PUSH_REGISTRATIONS[] = "CREATE TABLE PUSH_REGISTRATIONS \

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

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

const char ALARM_REGISTRATIONS[] = "CREATE TABLE ALARM_REGISTRATIONS \

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

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

EXTENSIONS VARCHAR PRIMARY KEY);";

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

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

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

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

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

}    // java

}    // storage

#endif // JAVASTORAGETABLES_H