Location: PHPKode > projects > Gallery 2 Google Map Integration > map/classes/GalleryStorage/schema.tpl
## mysql
# mapMap
CREATE TABLE DB_TABLE_PREFIXmapMap(
 DB_COLUMN_PREFIXitemId varchar(11) NOT NULL,
 DB_COLUMN_PREFIXfield varchar(128) NOT NULL,
 DB_COLUMN_PREFIXvalue varchar(255),
 DB_COLUMN_PREFIXsetId int(11),
 DB_COLUMN_PREFIXsetType int(11),
 INDEX DB_TABLE_PREFIXmapMap_75985(DB_COLUMN_PREFIXitemId)
) TYPE=DB_TABLE_TYPE ;

INSERT INTO DB_TABLE_PREFIXSchema (
 DB_COLUMN_PREFIXname,
 DB_COLUMN_PREFIXmajor,
 DB_COLUMN_PREFIXminor
) VALUES('mapMap', 1, 1);

## postgres
# mapMap
CREATE TABLE DB_TABLE_PREFIXmapMap(
 DB_COLUMN_PREFIXitemId varchar(11) NOT NULL,
 DB_COLUMN_PREFIXfield VARCHAR(128) NOT NULL,
 DB_COLUMN_PREFIXvalue VARCHAR(255),
 DB_COLUMN_PREFIXsetId INTEGER,
 DB_COLUMN_PREFIXsetType INTEGER
);

CREATE INDEX DB_TABLE_PREFIXmapMap_75985 ON DB_TABLE_PREFIXmapMap(DB_COLUMN_PREFIXitemId);

INSERT INTO DB_TABLE_PREFIXSchema (
 DB_COLUMN_PREFIXname,
 DB_COLUMN_PREFIXmajor,
 DB_COLUMN_PREFIXminor
) VALUES('mapMap', 1, 1);

## oracle
# mapMap
CREATE TABLE DB_TABLE_PREFIXmapMap(
 DB_COLUMN_PREFIXitemId varchar(11) NOT NULL,
 DB_COLUMN_PREFIXfield VARCHAR2(128) NOT NULL,
 DB_COLUMN_PREFIXvalue VARCHAR2(255),
 DB_COLUMN_PREFIXsetId INTEGER,
 DB_COLUMN_PREFIXsetType INTEGER
);

CREATE INDEX DB_TABLE_PREFIXmapMap_75985
   ON DB_TABLE_PREFIXmapMap(DB_COLUMN_PREFIXitemId);

INSERT INTO DB_TABLE_PREFIXSchema (
 DB_COLUMN_PREFIXname,
 DB_COLUMN_PREFIXmajor,
 DB_COLUMN_PREFIXminor
) VALUES('mapMap', 1, 1);

## db2
# mapMap
CREATE TABLE DB_TABLE_PREFIXmapMap(
 DB_COLUMN_PREFIXitemId varchar(11) NOT NULL,
 DB_COLUMN_PREFIXfield VARCHAR(128) NOT NULL,
 DB_COLUMN_PREFIXvalue VARCHAR(255),
 DB_COLUMN_PREFIXsetId INTEGER,
 DB_COLUMN_PREFIXsetType INTEGER
);

CREATE INDEX DB_TABLE_PREFIXCusto65_75985
   ON DB_TABLE_PREFIXmapMap(DB_COLUMN_PREFIXitemId);

INSERT INTO DB_TABLE_PREFIXSchema (
 DB_COLUMN_PREFIXname,
 DB_COLUMN_PREFIXmajor,
 DB_COLUMN_PREFIXminor
) VALUES('mapMap', 1, 1);

Return current item: Gallery 2 Google Map Integration