Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

    Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

    Parent Directory Parent Directory | Revision Log Revision Log

    Revision 10646 - (show annotations) (download) (as text)
    Wed Aug 30 13:56:46 2017 UTC (6 years, 8 months ago) by niro
    File MIME type: application/x-sh
    File size: 11685 byte(s) 
    -support arch detecting features in the sql schema and fixed an schema error
    1 create_database_schema()
    2 {
    3 TABLE_DEFINITION=(
    4 "meta_schema"
    5 "version int(11) NOT NULL PRIMARY KEY"
    6 )
    7 sql_create_table
    8
    9 TABLE_DEFINITION=(
    10 "meta_values"
    11 "version int(11) NOT NULL PRIMARY KEY"
    12 )
    13 sql_create_table
    14
    15 TABLE_DEFINITION=(
    16 "cfg_citrix_serverlist"
    17 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    18 "serial int(11) NOT NULL"
    19 "host varchar(255) NOT NULL"
    20 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    21 )
    22 sql_create_table
    23
    24 TABLE_DEFINITION=(
    25 "cfg_comments"
    26 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    27 "serial int(11) NOT NULL"
    28 "txt text"
    29 )
    30 sql_create_table
    31
    32 TABLE_DEFINITION=(
    33 "cfg_fluxbox_autostart"
    34 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    35 "serial int(11) NOT NULL"
    36 "name varchar(255) NOT NULL"
    37 "exec varchar(255) NOT NULL"
    38 "comment varchar(255) DEFAULT NULL"
    39 )
    40 sql_create_table
    41
    42 TABLE_DEFINITION=(
    43 "cfg_fluxbox_menuitem"
    44 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    45 "serial int(11) NOT NULL"
    46 "name varchar(255) NOT NULL"
    47 "exec varchar(255) NOT NULL"
    48 "workdir varchar(255) DEFAULT NULL"
    49 "icon varchar(255) DEFAULT NULL"
    50 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    51 )
    52 sql_create_table
    53
    54 TABLE_DEFINITION=(
    55 "cfg_fluxbox_theme"
    56 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    57 "serial int(11) NOT NULL"
    58 "theme varchar(255) NOT NULL"
    59 )
    60 sql_create_table
    61
    62 TABLE_DEFINITION=(
    63 "cfg_graphic"
    64 "serial int(11) NOT NULL PRIMARY KEY"
    65 "resolution varchar(255) DEFAULT NULL"
    66 "depth varchar(288) DEFAULT NULL"
    67 "monitorid int(11) DEFAULT NULL"
    68 "refresh_rate int(3) NOT NULL DEFAULT '60'"
    69 "module varchar(255) DEFAULT NULL"
    70 "hdmi varchar(10) NOT NULL DEFAULT 'disable'"
    71 )
    72 sql_create_table
    73
    74 TABLE_DEFINITION=(
    75 "cfg_idesk_icon"
    76 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    77 "serial int(11) NOT NULL"
    78 "name varchar(255) NOT NULL"
    79 "command varchar(255) NOT NULL"
    80 "icon varchar(255) NOT NULL"
    81 "filename varchar(255) NOT NULL"
    82 "xpos varchar(255) NOT NULL"
    83 "ypos varchar(255) NOT NULL"
    84 "width varchar(255) NOT NULL"
    85 "height varchar(255) NOT NULL"
    86 "default_icon varchar(255) NOT NULL"
    87 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    88 )
    89 sql_create_table
    90
    91 TABLE_DEFINITION=(
    92 "cfg_input"
    93 "serial int(11) NOT NULL PRIMARY KEY"
    94 "keymap varchar(255) DEFAULT NULL"
    95 )
    96 sql_create_table
    97
    98 TABLE_DEFINITION=(
    99 "cfg_modules"
    100 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    101 "serial int(11) NOT NULL"
    102 "module varchar(255) DEFAULT NULL"
    103 "arg varchar(255) DEFAULT NULL"
    104 )
    105 sql_create_table
    106
    107 TABLE_DEFINITION=(
    108 "cfg_network"
    109 "serial int(11) NOT NULL PRIMARY KEY"
    110 "hostname varchar(255) DEFAULT NULL"
    111 "domain varchar(255) DEFAULT NULL"
    112 "networking varchar(255) DEFAULT NULL"
    113 "netmask varchar(255) DEFAULT NULL"
    114 "dns varchar(255) DEFAULT NULL"
    115 "gateway varchar(255) DEFAULT NULL"
    116 "broadcast varchar(255) DEFAULT NULL"
    117 "ip varchar(255) DEFAULT NULL"
    118 "module varchar(255) DEFAULT NULL"
    119 "forcemacto varchar(17) DEFAULT NULL"
    120 "wireless_bitrate varchar(5) DEFAULT NULL"
    121 "wireless_channel varchar(10) DEFAULT NULL"
    122 "wireless_essid varchar(255) DEFAULT NULL"
    123 "wireless_frequency varchar(255) DEFAULT NULL"
    124 "wireless_mode varchar(255) DEFAULT NULL"
    125 "wireless_nick varchar(255) DEFAULT NULL"
    126 "wireless_auth_mode varchar(255) DEFAULT NULL"
    127 "wireless_key_length varchar(255) DEFAULT NULL"
    128 "wireless_key text"
    129 "wireless_key_ascii text"
    130 )
    131 sql_create_table
    132
    133 TABLE_DEFINITION=(
    134 "cfg_printers"
    135 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    136 "serial int(11) NOT NULL"
    137 "printer_name varchar(255) NOT NULL"
    138 "port varchar(255) NOT NULL"
    139 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    140 )
    141 sql_create_table
    142
    143 TABLE_DEFINITION=(
    144 "cfg_scm_egk"
    145 "serial int(11) NOT NULL PRIMARY KEY"
    146 "facility tinyint(1) NOT NULL DEFAULT '1'"
    147 )
    148 sql_create_table
    149
    150 TABLE_DEFINITION=(
    151 "cfg_screensaver"
    152 "serial int(11) NOT NULL PRIMARY KEY"
    153 "screensaver varchar(255) NOT NULL"
    154 "timeout int(11) DEFAULT '10'"
    155 "password varchar(255) DEFAULT NULL"
    156 )
    157 sql_create_table
    158
    159 TABLE_DEFINITION=(
    160 "cfg_sessions_citrix"
    161 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    162 "serial int(11) NOT NULL"
    163 "name varchar(255) NOT NULL"
    164 "session varchar(255) NOT NULL"
    165 "filename varchar(255) DEFAULT NULL"
    166 "username varchar(255) DEFAULT NULL"
    167 "domain varchar(255) DEFAULT NULL"
    168 "password varchar(255) DEFAULT NULL"
    169 "serverlist varchar(255) NOT NULL"
    170 "autostart tinyint(1) NOT NULL DEFAULT '1'"
    171 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    172 "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    173 )
    174 sql_create_table
    175
    176 TABLE_DEFINITION=(
    177 "cfg_sessions_rdesktop"
    178 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    179 "serial int(11) NOT NULL"
    180 "name varchar(255) NOT NULL"
    181 "server varchar(255) NOT NULL"
    182 "filename varchar(255) DEFAULT NULL"
    183 "username varchar(255) DEFAULT NULL"
    184 "password varchar(255) DEFAULT NULL"
    185 "domain varchar(255) DEFAULT NULL"
    186 "shell varchar(255) DEFAULT NULL"
    187 "autostart tinyint(1) NOT NULL DEFAULT '1'"
    188 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    189 "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    190 )
    191 sql_create_table
    192
    193 TABLE_DEFINITION=(
    194 "cfg_sessions_storefront"
    195 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    196 "serial int(11) NOT NULL"
    197 "name varchar(255) NOT NULL"
    198 "session varchar(255) NOT NULL"
    199 "filename varchar(255) DEFAULT NULL"
    200 "username varchar(255) DEFAULT NULL"
    201 "domain varchar(255) DEFAULT NULL"
    202 "password varchar(255) DEFAULT NULL"
    203 "store varchar(255) NOT NULL"
    204 "autostart tinyint(1) NOT NULL DEFAULT '1'"
    205 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    206 "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    207 )
    208 sql_create_table
    209
    210 TABLE_DEFINITION=(
    211 "cfg_storefront_store"
    212 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    213 "serial int(11) NOT NULL"
    214 "store varchar(255) NOT NULL"
    215 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    216 )
    217 sql_create_table
    218
    219 TABLE_DEFINITION=(
    220 "cfg_vnc"
    221 "serial int(11) NOT NULL PRIMARY KEY"
    222 "service tinyint(1) NOT NULL DEFAULT '1'"
    223 )
    224 sql_create_table
    225
    226 TABLE_DEFINITION=(
    227 "client_auth"
    228 "serial int(11) NOT NULL PRIMARY KEY"
    229 "user varchar(255) DEFAULT NULL"
    230 "root varchar(255) DEFAULT NULL"
    231 "vnc varchar(255) DEFAULT NULL"
    232 )
    233 sql_create_table
    234
    235 TABLE_DEFINITION=(
    236 "client_locations"
    237 "location varchar(255) NOT NULL PRIMARY KEY"
    238 "bootserver varchar(255) NOT NULL"
    239 "controlserver varchar(255) NOT NULL"
    240 "pxe_default_entry varchar(255) NOT NULL"
    241 "pxe_prompt tinyint(1) NOT NULL"
    242 "pxe_timeout smallint(1) NOT NULL"
    243 "updateserver varchar(255) NOT NULL"
    244 "username varchar(255) NOT NULL"
    245 "password varchar(255) NOT NULL"
    246 "rsync varchar(255) NOT NULL"
    247 "repository varchar(255) NOT NULL"
    248 "helpdesk_unit varchar(255) NOT NULL"
    249 "helpdesk_phone varchar(255) NOT NULL"
    250 "set_default tinyint(1) NOT NULL DEFAULT '0'"
    251 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    252 )
    253 sql_create_table
    254
    255 TABLE_DEFINITION=(
    256 "client_serials"
    257 "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    258 "location varchar(255) NOT NULL"
    259 "mtime int(11) DEFAULT NULL"
    260 "mac varchar(17) NOT NULL"
    261 "hwdetected tinyint(1) NOT NULL DEFAULT '0'"
    262 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    263 )
    264 sql_create_table
    265
    266 TABLE_DEFINITION=(
    267 "client_version"
    268 "serial int(11) NOT NULL PRIMARY KEY"
    269 "os varchar(50) NOT NULL"
    270 "utils varchar(50) NOT NULL"
    271 "arch varchar(50) NOT NULL"
    272 )
    273 sql_create_table
    274
    275 TABLE_DEFINITION=(
    276 "state_connected"
    277 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    278 "mtime int(11) DEFAULT NULL"
    279 "serial int(11) NOT NULL"
    280 "ip varchar(255) DEFAULT NULL"
    281 "mac varchar(255) DEFAULT NULL"
    282 "netboot tinyint(1) NOT NULL DEFAULT '0'"
    283 )
    284 sql_create_table
    285
    286 TABLE_DEFINITION=(
    287 "values_storefront_store"
    288 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    289 "name varchar(255) NOT NULL"
    290 "store varchar(255) NOT NULL"
    291 "user varchar(255) DEFAULT NULL"
    292 "password varchar(255) DEFAULT NULL"
    293 "domain varchar(255) DEFAULT NULL"
    294 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    295 )
    296 sql_create_table
    297
    298 TABLE_DEFINITION=(
    299 "values_citrix_session"
    300 "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    301 "session varchar(255) NOT NULL"
    302 "description varchar(255) DEFAULT NULL"
    303 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    304 )
    305 sql_create_table
    306
    307 TABLE_DEFINITION=(
    308 "values_graphic_depth"
    309 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    310 "value varchar(255) NOT NULL"
    311 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    312 )
    313 sql_create_table
    314
    315 TABLE_DEFINITION=(
    316 "values_graphic_module"
    317 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    318 "value varchar(255) NOT NULL"
    319 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    320 )
    321 sql_create_table
    322
    323 TABLE_DEFINITION=(
    324 "values_graphic_refresh_rate"
    325 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    326 "value varchar(255) NOT NULL"
    327 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    328 )
    329 sql_create_table
    330
    331 TABLE_DEFINITION=(
    332 "values_graphic_resolution"
    333 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    334 "value varchar(255) NOT NULL"
    335 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    336 )
    337 sql_create_table
    338
    339 TABLE_DEFINITION=(
    340 "values_input_keymap"
    341 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    342 "value varchar(255) NOT NULL"
    343 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    344 )
    345 sql_create_table
    346
    347 TABLE_DEFINITION=(
    348 "values_network_module"
    349 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    350 "value varchar(255) NOT NULL"
    351 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    352 "description varchar(255) DEFAULT NULL"
    353 )
    354 sql_create_table
    355
    356 TABLE_DEFINITION=(
    357 "values_network_wireless_auth_mode"
    358 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    359 "value varchar(255) NOT NULL"
    360 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    361 )
    362 sql_create_table
    363
    364 TABLE_DEFINITION=(
    365 "values_network_wireless_bitrate"
    366 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    367 "value varchar(255) NOT NULL"
    368 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    369 )
    370 sql_create_table
    371
    372 TABLE_DEFINITION=(
    373 "values_network_wireless_channel"
    374 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    375 "value varchar(255) NOT NULL"
    376 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    377 )
    378 sql_create_table
    379
    380 TABLE_DEFINITION=(
    381 "values_network_wireless_frequency"
    382 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    383 "value varchar(255) NOT NULL"
    384 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    385 )
    386 sql_create_table
    387
    388 TABLE_DEFINITION=(
    389 "values_network_wireless_key_length"
    390 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    391 "value varchar(255) NOT NULL"
    392 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    393 )
    394 sql_create_table
    395
    396 TABLE_DEFINITION=(
    397 "values_network_wireless_mode"
    398 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    399 "value varchar(255) NOT NULL"
    400 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    401 )
    402 sql_create_table
    403
    404 TABLE_DEFINITION=(
    405 "values_printers_port"
    406 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    407 "value varchar(255) NOT NULL"
    408 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    409 )
    410 sql_create_table
    411
    412 TABLE_DEFINITION=(
    413 "values_screensaver_screensaver"
    414 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    415 "value varchar(255) NOT NULL"
    416 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    417 )
    418 sql_create_table
    419
    420 TABLE_DEFINITION=(
    421 "values_storefront_session"
    422 "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    423 "session varchar(255) NOT NULL"
    424 "description varchar(255) DEFAULT NULL"
    425 "store varchar(255) NOT NULL"
    426 "enabled tinyint(1) NOT NULL DEFAULT '1'"
    427 )
    428 sql_create_table
    429
    430 TABLE_DEFINITION=(
    431 "client_boot"
    432 "serial int(255) NOT NULL PRIMARY KEY"
    433 "cmdline varchar(255) DEFAULT NULL"
    434 )
    435 sql_create_table
    436 }