Commit | Line | Data |
c957e92d |
1 | <?xml version="1.0" encoding="UTF-8"?> |
2 | <!-- |
3 | Created by SQL::Translator::Producer::XML |
4 | Created on Fri Aug 1 11:24:58 2003 |
5 | |
6 | --> |
7 | |
8 | <sqlf:schema xmlns:sqlf="http://sqlfairy.sourceforge.net/sqlfairy.xml"> |
5ff70f1a |
9 | |
c957e92d |
10 | <sqlf:table> |
11 | <sqlf:name>Basic</sqlf:name> |
12 | <sqlf:order>1</sqlf:order> |
13 | <sqlf:fields> |
14 | <sqlf:field> |
15 | <sqlf:name>id</sqlf:name> |
16 | <sqlf:is_primary_key>1</sqlf:is_primary_key> |
17 | <sqlf:is_auto_increment>1</sqlf:is_auto_increment> |
18 | <sqlf:data_type>int</sqlf:data_type> |
5ff70f1a |
19 | <sqlf:is_nullable>0</sqlf:is_nullable> |
c957e92d |
20 | <sqlf:size>10</sqlf:size> |
21 | <sqlf:order>1</sqlf:order> |
22 | </sqlf:field> |
23 | <sqlf:field> |
24 | <sqlf:name>title</sqlf:name> |
25 | <sqlf:data_type>varchar</sqlf:data_type> |
26 | <sqlf:size>100</sqlf:size> |
27 | <sqlf:default_value>hello</sqlf:default_value> |
5ff70f1a |
28 | <sqlf:is_nullable>0</sqlf:is_nullable> |
c957e92d |
29 | <sqlf:order>2</sqlf:order> |
30 | </sqlf:field> |
31 | <sqlf:field> |
5ff70f1a |
32 | <sqlf:name>description</sqlf:name> |
c957e92d |
33 | <sqlf:data_type>text</sqlf:data_type> |
5ff70f1a |
34 | <sqlf:default_value></sqlf:default_value> |
c957e92d |
35 | <sqlf:order>3</sqlf:order> |
36 | </sqlf:field> |
37 | <sqlf:field> |
5ff70f1a |
38 | <sqlf:name>email</sqlf:name> |
c957e92d |
39 | <sqlf:data_type>varchar</sqlf:data_type> |
5ff70f1a |
40 | <sqlf:is_nullable>1</sqlf:is_nullable> |
41 | <sqlf:size>255</sqlf:size> |
c957e92d |
42 | <sqlf:order>4</sqlf:order> |
43 | </sqlf:field> |
5ff70f1a |
44 | <sqlf:field> |
45 | <sqlf:name>explicitnulldef</sqlf:name> |
46 | <sqlf:data_type>varchar</sqlf:data_type> |
47 | <sqlf:is_nullable>1</sqlf:is_nullable> |
48 | <sqlf:default_value>NULL</sqlf:default_value> |
49 | <sqlf:order>5</sqlf:order> |
50 | </sqlf:field> |
51 | <sqlf:field> |
52 | <sqlf:name>explicitemptystring</sqlf:name> |
53 | <sqlf:data_type>varchar</sqlf:data_type> |
54 | <sqlf:is_nullable>1</sqlf:is_nullable> |
55 | <sqlf:default_value>EMPTY_STRING</sqlf:default_value> |
b3530353 |
56 | <sqlf:order>6</sqlf:order> |
57 | </sqlf:field> |
58 | <sqlf:field> |
5952d39c |
59 | <sqlf:name>emptytagdef</sqlf:name> |
b3530353 |
60 | <sqlf:data_type>varchar</sqlf:data_type> |
61 | <sqlf:is_nullable>1</sqlf:is_nullable> |
62 | <sqlf:default_value/> |
63 | <sqlf:order>7</sqlf:order> |
5ff70f1a |
64 | </sqlf:field> |
65 | </sqlf:fields> |
66 | |
67 | <sqlf:indices> |
c957e92d |
68 | <sqlf:index> |
5ff70f1a |
69 | <sqlf:fields>title</sqlf:fields> |
c957e92d |
70 | <sqlf:name>titleindex</sqlf:name> |
71 | <sqlf:type>NORMAL</sqlf:type> |
72 | </sqlf:index> |
73 | </sqlf:indices> |
5ff70f1a |
74 | |
75 | <sqlf:constraints> |
c957e92d |
76 | <sqlf:constraint> |
77 | <sqlf:deferrable>1</sqlf:deferrable> |
78 | <sqlf:fields>email</sqlf:fields> |
79 | <sqlf:name>emailuniqueindex</sqlf:name> |
80 | <sqlf:type>UNIQUE</sqlf:type> |
81 | </sqlf:constraint> |
82 | </sqlf:constraints> |
83 | </sqlf:table> |
84 | |
85 | </sqlf:schema> |