Commit | Line | Data |
ec791002 |
1 | <?xml version="1.0" encoding="utf-8"?> |
2 | <!-- |
3 | Created by SQL::Translator::Producer::SqlfXML |
4 | Created on Fri Aug 15 15:08:18 2003 |
5 | |
6 | --> |
7 | <sqlt:schema xmlns:sqlt="http://sqlfairy.sourceforge.net/sqlfairy.xml"> |
8 | |
9 | <sqlt:table order="1" name="Basic"> |
10 | <sqlt:fields> |
11 | <sqlt:field |
12 | name="id" |
13 | is_primary_key="1" is_foreign_key="0" |
14 | size="10" data_type="int" is_auto_increment="1" order="1" |
15 | is_nullable="0" /> |
16 | <sqlt:field |
17 | name="title" |
18 | is_primary_key="0" is_foreign_key="0" |
19 | size="100" is_auto_increment="0" data_type="varchar" |
20 | order="2" default_value="hello" is_nullable="0" /> |
21 | <sqlt:field |
22 | name="description" |
23 | size="0" data_type="text" order="3" default_value="" /> |
24 | <sqlt:field name="email" size="255" data_type="varchar" order="4" /> |
25 | <sqlt:field name="explicitnulldef" size="0" data_type="varchar" order="5" /> |
26 | <sqlt:field name="explicitemptystring" size="0" |
27 | data_type="varchar" order="6" default_value="" /> |
28 | <sqlt:field name="emptytagdef" size="0" |
29 | data_type="varchar" order="7" default_value="" > |
30 | <comments>Hello World</comments> |
31 | </sqlt:field> |
32 | </sqlt:fields> |
33 | <sqlt:indices> |
34 | <sqlt:index name="titleindex" fields="title" type="NORMAL" /> |
35 | </sqlt:indices> |
36 | <sqlt:constraints> |
37 | <sqlt:constraint name="" type="PRIMARY KEY" fields="id" |
38 | reference_table="" options="" deferrable="1" match_type="" |
39 | expression="" on_update="" on_delete="" /> |
40 | <sqlt:constraint name="emailuniqueindex" type="UNIQUE" fields="email" /> |
41 | </sqlt:constraints> |
42 | </sqlt:table> |
43 | <sqlt:view name="email_list" fields="email" order="1"> |
44 | <sqlt:sql>SELECT email FROM Basic WHERE email IS NOT NULL</sqlt:sql> |
45 | </sqlt:view> |
46 | <sqlt:trigger name="foo_trigger" database_event="insert" on_table="foo" |
47 | perform_action_when="after" order="1"> |
48 | <sqlt:action>update modified=timestamp();</sqlt:action> |
49 | </sqlt:trigger> |
50 | <sqlt:procedure name="foo_proc" order="1" owner="Nomar" parameters="foo,bar"> |
51 | <sqlt:sql>select foo from bar</sqlt:sql> |
52 | <sqlt:comments>Go Sox!</sqlt:comments> |
53 | </sqlt:procedure> |
54 | </sqlt:schema> |