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 | --> |
94ed484b |
7 | <schema xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml"> |
ec791002 |
8 | |
87c5565e |
9 | <tables> |
10 | <table order="1" name="Basic"> |
11 | <fields> |
12 | <field |
13 | name="id" |
14 | is_primary_key="1" is_foreign_key="0" |
15 | size="10" data_type="int" is_auto_increment="1" order="1" |
16 | is_nullable="0"> |
17 | <extra ZEROFILL="1" /> |
18 | </field> |
19 | <field |
20 | name="title" |
21 | is_primary_key="0" is_foreign_key="0" |
22 | size="100" is_auto_increment="0" data_type="varchar" |
23 | order="2" default_value="hello" is_nullable="0" /> |
24 | <field |
25 | name="description" |
26 | size="0" data_type="text" order="3" default_value="" /> |
27 | <field name="email" size="255" data_type="varchar" order="4"> |
28 | <extra foo="bar" hello="world" bar="baz" /> |
29 | </field> |
30 | <field name="explicitnulldef" size="0" data_type="varchar" order="5" /> |
31 | <field name="explicitemptystring" size="0" |
32 | data_type="varchar" order="6" default_value="" /> |
33 | <field name="emptytagdef" size="0" |
34 | data_type="varchar" order="7" default_value="" > |
35 | <comments>Hello emptytagdef</comments> |
36 | </field> |
37 | </fields> |
94ed484b |
38 | |
87c5565e |
39 | <indices> |
40 | <index name="titleindex" fields="title" type="NORMAL" /> |
41 | </indices> |
94ed484b |
42 | |
87c5565e |
43 | <constraints> |
44 | <constraint name="" type="PRIMARY KEY" fields="id" |
45 | reference_table="" options="" deferrable="1" match_type="" |
46 | expression="" on_update="" on_delete="" /> |
47 | <constraint name="emailuniqueindex" type="UNIQUE" fields="email" /> |
48 | </constraints> |
49 | </table> |
50 | </tables> |
94ed484b |
51 | |
87c5565e |
52 | <views> |
53 | <view name="email_list" fields="email" order="1"> |
54 | <sql>SELECT email FROM Basic WHERE email IS NOT NULL</sql> |
55 | </view> |
56 | </views> |
94ed484b |
57 | |
87c5565e |
58 | <triggers> |
59 | <trigger name="foo_trigger" database_event="insert" on_table="foo" |
60 | perform_action_when="after" order="1"> |
61 | <action>update modified=timestamp();</action> |
62 | </trigger> |
63 | </triggers> |
94ed484b |
64 | |
87c5565e |
65 | <procedures> |
66 | <procedure name="foo_proc" order="1" owner="Nomar" parameters="foo,bar"> |
67 | <sql>select foo from bar</sql> |
68 | <comments>Go Sox!</comments> |
69 | </procedure> |
70 | </procedures> |
94ed484b |
71 | |
72 | </schema> |