Hi,
First Up all, Thanks For Tera-WURFL support.
I have clarification on, Whether Tera-WURFL will support with back end postgreSQL database ? Please any one tell suggestion on this one.
Thanks in advance.
CREATE TABLE `TeraWurflCache` (
`user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`cache_data` mediumtext NOT NULL,
PRIMARY KEY (`user_agent`)
)
CREATE TABLE `TeraWurflIndex` (
`deviceID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`matcher` varchar(64) NOT NULL,
PRIMARY KEY (`deviceID`)
)
CREATE TABLE `TeraWurflMerge` (
`deviceID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`fall_back` varchar(64) DEFAULT NULL,
`actual_device_root` tinyint(1) DEFAULT '0',
`match` tinyint(1) DEFAULT '1',
`capabilities` mediumtext,
PRIMARY KEY (`deviceID`),
KEY `fallback` (`fall_back`),
KEY `useragent` (`user_agent`),
KEY `dev_root` (`actual_device_root`),
KEY `idxmatch` (`match`)
)
CREATE TABLE `TeraWurflSettings` (
`id` varchar(64) NOT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE `TeraWurfl_CatchAll` (
`deviceID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`fall_back` varchar(64) DEFAULT NULL,
`actual_device_root` tinyint(1) DEFAULT '0',
`match` tinyint(1) DEFAULT '1',
`capabilities` mediumtext,
PRIMARY KEY (`deviceID`),
KEY `fallback` (`fall_back`),
KEY `useragent` (`user_agent`),
KEY `dev_root` (`actual_device_root`),
KEY `idxmatch` (`match`)
)
-- en postgresql
CREATE TABLE TeraWurflCache (
user_agent varchar(255) NOT NULL DEFAULT '',
cache_data text NOT NULL,
PRIMARY KEY (user_agent)
)
;
CREATE TABLE TeraWurflIndex (
deviceID varchar(64) NOT NULL DEFAULT '',
matcher varchar(64) NOT NULL,
PRIMARY KEY (deviceID)
)
;
CREATE TABLE TeraWurflMerge (
deviceID varchar(64) NOT NULL DEFAULT '',
user_agent varchar(255) DEFAULT NULL,
fall_back varchar(64) DEFAULT NULL,
actual_device_root smallint DEFAULT '0',
match smallint DEFAULT '1',
capabilities text,
PRIMARY KEY (deviceID)
)
;
CREATE INDEX TeraWurflMerge_fallback_idx on TeraWurflMerge(fall_back);
CREATE INDEX TeraWurflMerge_useragent_idx on TeraWurflMerge(user_agent);
CREATE INDEX TeraWurflMerge_dev_root_idx on TeraWurflMerge(actual_device_root);
CREATE INDEX TeraWurflMerge_match_idx on TeraWurflMerge(match);
CREATE TABLE TeraWurflSettings (
id varchar(64) NOT NULL,
value varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
)
;
CREATE TABLE TeraWurfl_CatchAll (
deviceID varchar(64) NOT NULL DEFAULT '',
user_agent varchar(255) DEFAULT NULL,
fall_back varchar(64) DEFAULT NULL,
actual_device_root smallint DEFAULT '0',
match smallint DEFAULT '1',
capabilities text,
PRIMARY KEY (deviceID)
)
;
CREATE INDEX TeraWurfl_CatchAll_fallback_idx on TeraWurfl_CatchAll (fall_back);
CREATE INDEX TeraWurfl_CatchAll_useragent_idx on TeraWurfl_CatchAll (user_agent);
CREATE INDEX TeraWurfl_CatchAll_dev_root_idx on TeraWurfl_CatchAll (actual_device_root);
CREATE INDEX TeraWurfl_CatchAll_match_idx on TeraWurfl_CatchAll (match);
Return to Installation / Configuration
Users browsing this forum: No registered users and 2 guests