Some blank index.html files to prevent browsing
[moodle.git] / lib / db / schemaUser.xml
1 <?xml version="1.0"?>\r
2 <schema>\r
3   <table name="m_user">\r
4     <field name="id" type="I" size="10">\r
5       <KEY/>\r
6       <AUTOINCREMENT/>\r
7     </field>\r
8     <field name="confirmed" type="L" size="1" default="0">\r
9       <NOTNULL/>\r
10     </field>\r
11     <field name="deleted" type="L" size="1" default="0">\r
12       <NOTNULL/>\r
13     </field>\r
14     <field name="username" type="C" size="100" default="">\r
15       <NOTNULL/>\r
16     </field>\r
17     <field name="password" type="C" size="32" default="">\r
18       <NOTNULL/>\r
19     </field>\r
20     <field name="idnumber" type="C" size="12" default="">\r
21       <NOTNULL/>\r
22     </field>\r
23     <field name="firstname" type="C" size="20" default="">\r
24       <NOTNULL/>\r
25     </field>\r
26     <field name="lastname" type="C" size="20" default="">\r
27       <NOTNULL/>\r
28     </field>\r
29     <field name="email" type="C" size="100" default="">\r
30       <NOTNULL/>\r
31     </field>\r
32     <field name="icq" type="C" size="15" default="">\r
33     </field>\r
34     <field name="phone1" type="C" size="20" default="">\r
35     </field>\r
36     <field name="phone2" type="C" size="20" default="">\r
37     </field>\r
38     <field name="institution" type="C" size="40" default="">\r
39     </field>\r
40     <field name="department" type="C" size="30" default="">\r
41     </field>\r
42     <field name="address" type="C" size="70" default="">\r
43     </field>\r
44     <field name="city" type="C" size="20" default="">\r
45     </field>\r
46     <field name="country" type="C" size="20" default="">\r
47     </field>\r
48     <field name="lang" type="C" size="5" default="en">\r
49       <NOTNULL/>\r
50     </field>\r
51     <field name="timezone" type="F"  default="99">\r
52       <NOTNULL/>\r
53     </field>\r
54     <field name="firstaccess" type="I" size="10" default="">\r
55       <NOTNULL/>\r
56     </field>\r
57     <field name="lastaccess" type="I" size="10" default="">\r
58       <NOTNULL/>\r
59     </field>\r
60     <field name="lastlogin" type="I" size="10" default="">\r
61       <NOTNULL/>\r
62     </field>\r
63     <field name="currentlogin" type="I" size="10" default="">\r
64       <NOTNULL/>\r
65     </field>\r
66     <field name="lastIP" type="C" size="15" default="">\r
67     </field>\r
68     <field name="secret" type="C" size="15" default="">\r
69       <NOTNULL/>\r
70     </field>\r
71     <field name="picture" type="L" size="1" >\r
72     </field>\r
73     <field name="url" type="C" size="100" default="">\r
74     </field>\r
75     <field name="description" type="X">\r
76       <NOTNULL/>\r
77     </field>\r
78     <field name="mailformat" type="L" size="1" default="0">\r
79       <NOTNULL/>\r
80     </field>\r
81     <field name="maildisplay" type="L" size="1" default="0">\r
82       <NOTNULL/>\r
83     </field>\r
84     <field name="htmleditor" type="L" size="1" default="0">\r
85       <NOTNULL/>\r
86     </field>\r
87     <field name="autosubscribe" type="L" size="1" default="0">\r
88       <NOTNULL/>\r
89     </field>\r
90     <field name="timemodified" type="I" size="10" default="1">\r
91       <NOTNULL/>\r
92     </field>\r
93   </table>\r
94   <sql>\r
95     <descr>Insert 1 row for testing only...comment out later</descr>\r
96     <query platform="postgres|postgres7">\r
97       insert into m_user values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1)\r
98     </query>\r
99     <query platform="mysql">\r
100       insert into m_user values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1)\r
101     </query>\r
102     <query platform="oci8po">\r
103       insert into m_user values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1)\r
104     </query>\r
105   </sql>\r
106 </schema>\r