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