| Commit | Line | Data |
|---|
| aee4b66e |
1 | Schema: |
| 2 | Database: |
| 3 | |
| 4 | Foo: bar |
| 5 | Hello: world |
| 6 | |
| 7 | Table: Basic |
| 8 | ========================================================================== |
| 9 | |
| 10 | Fields |
| 11 | id |
| 12 | data_type: int |
| 13 | size: 10 |
| 14 | is_nullable: 0 |
| 15 | default_value: |
| 16 | is_primary_key: 1 |
| 17 | is_unique: 0 |
| 18 | is_auto_increment: 1 |
| 19 | is_foreign_key: 0 |
| 20 | foreign_key_reference: |
| 21 | is_valid: 1 |
| 22 | order: 1 |
| 23 | table: Basic |
| 24 | |
| 25 | title |
| 26 | data_type: varchar |
| 27 | size: 100 |
| 28 | is_nullable: 0 |
| 29 | default_value: hello |
| 30 | is_primary_key: 0 |
| 31 | is_unique: 1 |
| 32 | is_auto_increment: 0 |
| 33 | is_foreign_key: 0 |
| 34 | foreign_key_reference: |
| 35 | is_valid: 1 |
| 36 | order: 2 |
| 37 | table: Basic |
| 38 | |
| 39 | description |
| 40 | data_type: text |
| 41 | size: 0 |
| 42 | is_nullable: 1 |
| 43 | default_value: |
| 44 | is_primary_key: 0 |
| 45 | is_unique: 0 |
| 46 | is_auto_increment: 0 |
| 47 | is_foreign_key: 0 |
| 48 | foreign_key_reference: |
| 49 | is_valid: 1 |
| 50 | order: 3 |
| 51 | table: Basic |
| 52 | |
| 53 | email |
| 54 | data_type: varchar |
| 55 | size: 500 |
| 56 | is_nullable: 1 |
| 57 | default_value: |
| 58 | is_primary_key: 0 |
| 59 | is_unique: 1 |
| 60 | is_auto_increment: 0 |
| 61 | is_foreign_key: 0 |
| 62 | foreign_key_reference: |
| 63 | is_valid: 1 |
| 64 | order: 4 |
| 65 | table: Basic |
| 66 | |
| 67 | explicitnulldef |
| 68 | data_type: varchar |
| 69 | size: 0 |
| 70 | is_nullable: 1 |
| 71 | default_value: |
| 72 | is_primary_key: 0 |
| 73 | is_unique: 0 |
| 74 | is_auto_increment: 0 |
| 75 | is_foreign_key: 0 |
| 76 | foreign_key_reference: |
| 77 | is_valid: 1 |
| 78 | order: 5 |
| 79 | table: Basic |
| 80 | |
| 81 | explicitemptystring |
| 82 | data_type: varchar |
| 83 | size: 0 |
| 84 | is_nullable: 1 |
| 85 | default_value: |
| 86 | is_primary_key: 0 |
| 87 | is_unique: 0 |
| 88 | is_auto_increment: 0 |
| 89 | is_foreign_key: 0 |
| 90 | foreign_key_reference: |
| 91 | is_valid: 1 |
| 92 | order: 6 |
| 93 | table: Basic |
| 94 | |
| 95 | emptytagdef |
| 96 | data_type: varchar |
| 97 | size: 0 |
| 98 | is_nullable: 1 |
| 99 | default_value: |
| 100 | is_primary_key: 0 |
| 101 | is_unique: 0 |
| 102 | is_auto_increment: 0 |
| 103 | is_foreign_key: 0 |
| 104 | foreign_key_reference: |
| 105 | is_valid: 1 |
| 106 | order: 7 |
| 107 | table: Basic |
| 108 | |
| 109 | another_id |
| 110 | data_type: int |
| 111 | size: 10 |
| 112 | is_nullable: 1 |
| 113 | default_value: 2 |
| 114 | is_primary_key: 0 |
| 115 | is_unique: 0 |
| 116 | is_auto_increment: 0 |
| 117 | is_foreign_key: 1 |
| 118 | foreign_key_reference: Another |
| 119 | is_valid: 1 |
| 120 | order: 8 |
| 121 | table: Basic |
| 122 | |
| 123 | timest |
| 124 | data_type: timestamp |
| 125 | size: 0 |
| 126 | is_nullable: 1 |
| 127 | default_value: |
| 128 | is_primary_key: 0 |
| 129 | is_unique: 0 |
| 130 | is_auto_increment: 0 |
| 131 | is_foreign_key: 0 |
| 132 | foreign_key_reference: |
| 133 | is_valid: 1 |
| 134 | order: 9 |
| 135 | table: Basic |
| 136 | |
| 137 | |
| 138 | Indices |
| 139 | titleindex |
| 140 | table: Basic |
| 141 | fields: title |
| 142 | type: NORMAL |
| 143 | options: |
| 144 | is_valid: 1 |
| 145 | |
| 146 | |
| 147 | Constraints |
| 148 | ? |
| 149 | type: PRIMARY KEY |
| 150 | fields: id |
| 151 | expression: |
| 152 | match_type: |
| 153 | reference_fields: |
| 154 | reference_table: |
| 155 | deferrable: 1 |
| 156 | on_delete: |
| 157 | on_update: |
| 158 | options: |
| 159 | is_valid: 1 |
| 160 | |
| 161 | emailuniqueindex |
| 162 | type: UNIQUE |
| 163 | fields: email |
| 164 | expression: |
| 165 | match_type: |
| 166 | reference_fields: |
| 167 | reference_table: |
| 168 | deferrable: 1 |
| 169 | on_delete: |
| 170 | on_update: |
| 171 | options: |
| 172 | is_valid: 1 |
| 173 | |
| 174 | very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms |
| 175 | type: UNIQUE |
| 176 | fields: title |
| 177 | expression: |
| 178 | match_type: |
| 179 | reference_fields: |
| 180 | reference_table: |
| 181 | deferrable: 1 |
| 182 | on_delete: |
| 183 | on_update: |
| 184 | options: |
| 185 | is_valid: 1 |
| 186 | |
| 187 | ? |
| 188 | type: FOREIGN KEY |
| 189 | fields: another_id |
| 190 | expression: |
| 191 | match_type: |
| 192 | reference_fields: id |
| 193 | reference_table: Another |
| 194 | deferrable: 1 |
| 195 | on_delete: |
| 196 | on_update: |
| 197 | options: |
| 198 | is_valid: 1 |
| 199 | |
| 200 | Table: Another |
| 201 | ========================================================================== |
| 202 | |
| 203 | Fields |
| 204 | id |
| 205 | data_type: int |
| 206 | size: 10 |
| 207 | is_nullable: 0 |
| 208 | default_value: |
| 209 | is_primary_key: 1 |
| 210 | is_unique: 0 |
| 211 | is_auto_increment: 1 |
| 212 | is_foreign_key: 0 |
| 213 | foreign_key_reference: |
| 214 | is_valid: 1 |
| 215 | order: 1 |
| 216 | table: Another |
| 217 | |
| 218 | num |
| 219 | data_type: numeric |
| 220 | size: 10,2 |
| 221 | is_nullable: 1 |
| 222 | default_value: |
| 223 | is_primary_key: 0 |
| 224 | is_unique: 0 |
| 225 | is_auto_increment: 0 |
| 226 | is_foreign_key: 0 |
| 227 | foreign_key_reference: |
| 228 | is_valid: 1 |
| 229 | order: 2 |
| 230 | table: Another |
| 231 | |
| 232 | |
| 233 | Indices |
| 234 | |
| 235 | Constraints |
| 236 | ? |
| 237 | type: PRIMARY KEY |
| 238 | fields: id |
| 239 | expression: |
| 240 | match_type: |
| 241 | reference_fields: |
| 242 | reference_table: |
| 243 | deferrable: 1 |
| 244 | on_delete: |
| 245 | on_update: |
| 246 | options: |
| 247 | is_valid: 1 |
| 248 | |
projects / dbsrgits/SQL-Translator.git / blame