Initial add...separate .xml file for each table.
[moodle.git] / lib / db / schemaConfig.xml
CommitLineData
920d4432 1<?xml version="1.0"?>\r
2<schema>\r
3\r
4 <table name="config">\r
5\r
6 <field name="id" type="I" size="10">\r
7 <KEY/>\r
8 <AUTOINCREMENT/>\r
9 </field>\r
10\r
11 <field name="name" type="C" size="255">\r
12 <NOTNULL/>\r
13 </field>\r
14\r
15 <field name="value" type="C" size="255">\r
16 <NOTNULL/>\r
17 </field>\r
18 </table>\r
19 <sql>\r
20 <descr>Insert 1 row for testing only...comment out later</descr>\r
21 <query platform="postgres|postgres7">\r
22 insert into config(id,name,value) values (1,'1','1')\r
23 </query>\r
24 <query platform="mysql">\r
25 insert into config(id,name,value) values (1,'1','1')\r
26 </query>\r
27 <query platform="oci8po">\r
28 insert into config(id,name,value) values (1,'1','1')\r
29 </query>\r
30 </sql>\r
31</schema>\r
32\r