Code:
1
<!DOCTYPE maps SYSTEM "../../../lib/tools/dtd/MapsDefinition2.0.dtd">
2
<maps>
3
<map>
4
<map-name>ModuleNameMap</map-name>
5
<schema>
6
<schema-major>1</schema-major>
7
<schema-minor>0</schema-minor>
8
</schema>
9
<member>
10
<member-name>itemId</member-name>
11
<member-type>INTEGER</member-type>
12
<primary/>
13
</member>
14
<member>
15
<member-name>stringStorage</member-name>
16
<member-type>STRING</member-type>
17
<member-size>MEDIUM</member-size>
18
<required/>
19
</member>
20
</map>
21
</maps>
Code:
1
## mysql
2
# ModuleNameMap
3
CREATE TABLE DB_TABLE_PREFIXModuleNameMap (
4
DB_COLUMN_PREFIXitemId int(11) NOT NULL,
5
DB_COLUMN_PREFIX stringStorage varchar(128) NOT NULL
6
) TYPE=DB_TABLE_TYPE
7
/*!40100 DEFAULT CHARACTER SET utf8 */;
8
9
INSERT INTO DB_TABLE_PREFIXSchema (
10
DB_COLUMN_PREFIXname,
11
DB_COLUMN_PREFIXmajor,
12
DB_COLUMN_PREFIXminor
13
) VALUES('PersoonNaamMap', 1, 0);