Annotation of /alx-src/branches/alx-web-070/scripts/sql-schema/include/values.sh
Parent Directory
| 
Revision Log
Revision 8485 -
(hide annotations)
(download)
(as text)
Fri Feb 5 12:06:33 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 4465 byte(s)
Fri Feb 5 12:06:33 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 4465 byte(s)
-added initial schema script
| 1 | niro | 8485 | create_database_values() |
| 2 | { | ||
| 3 | # meta | ||
| 4 | echo "INSERT INTO ${MCORE_SQL_DB}.meta( version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" | ||
| 5 | mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta( version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" || die "updating version" | ||
| 6 | |||
| 7 | VALUE_DEFINITION=( | ||
| 8 | "values_graphic_depth, value, enabled, id" | ||
| 9 | "24, 1" | ||
| 10 | "16, 1" | ||
| 11 | "8, 1" | ||
| 12 | ) | ||
| 13 | sql_set_value | ||
| 14 | |||
| 15 | VALUE_DEFINITION=( | ||
| 16 | "values_graphic_module, value, enabled, id" | ||
| 17 | "vesa, 1" | ||
| 18 | "ati, 1" | ||
| 19 | "cirrus, 1" | ||
| 20 | "i710, 1" | ||
| 21 | "intel, 1" | ||
| 22 | "nv, 1" | ||
| 23 | "nouveau, 1" | ||
| 24 | "mach64, 1" | ||
| 25 | "mga, 1" | ||
| 26 | "openchrome, 1" | ||
| 27 | "radeon, 1" | ||
| 28 | "s3, 1" | ||
| 29 | "s3virge, 1" | ||
| 30 | "savage, 1" | ||
| 31 | "sis, 1" | ||
| 32 | "trident, 1" | ||
| 33 | "tseng, 1" | ||
| 34 | "vmware, 1" | ||
| 35 | ) | ||
| 36 | sql_set_value | ||
| 37 | |||
| 38 | VALUE_DEFINITION=( | ||
| 39 | "values_graphic_refresh_rate, value, enabled, id" | ||
| 40 | "60, 1" | ||
| 41 | "75, 1" | ||
| 42 | "85, 1" | ||
| 43 | "100, 1" | ||
| 44 | ) | ||
| 45 | sql_set_value | ||
| 46 | |||
| 47 | VALUE_DEFINITION=( | ||
| 48 | "values_input_keymap, value, enabled, id" | ||
| 49 | "us, 1" | ||
| 50 | "de, 1" | ||
| 51 | ) | ||
| 52 | sql_set_value | ||
| 53 | |||
| 54 | VALUE_DEFINITION=( | ||
| 55 | "values_graphic_resolution, value, enabled, id" | ||
| 56 | "640x480, 1" | ||
| 57 | "800x600, 1" | ||
| 58 | "1024x768, 1" | ||
| 59 | "1280x960, 1" | ||
| 60 | "1280x1024, 1" | ||
| 61 | "1360x768, 1" | ||
| 62 | "1366x768, 1" | ||
| 63 | "1400x1050, 1" | ||
| 64 | "1440x900, 1" | ||
| 65 | "1600x1200, 1" | ||
| 66 | "1680x1050, 1" | ||
| 67 | "1280x720, 1" | ||
| 68 | "1920x1080, 1" | ||
| 69 | "auto, 1" | ||
| 70 | ) | ||
| 71 | sql_set_value | ||
| 72 | |||
| 73 | VALUE_DEFINITION=( | ||
| 74 | "values_network_module, value, enabled, id" | ||
| 75 | ", 1" | ||
| 76 | "3c509, 1" | ||
| 77 | "5c59x, 1" | ||
| 78 | "8139cp, 1" | ||
| 79 | "8139too, 1" | ||
| 80 | "8390, 1" | ||
| 81 | "amd8111e, 1" | ||
| 82 | "atl1c, 1" | ||
| 83 | "atl1e, 1" | ||
| 84 | "atl1, 1" | ||
| 85 | "atl2, 1" | ||
| 86 | "b44, 1" | ||
| 87 | "bnx2, 1" | ||
| 88 | "cnic, 1" | ||
| 89 | "e100, 1" | ||
| 90 | "e1000, 1" | ||
| 91 | "e1000e, 1" | ||
| 92 | "forcedeth, 1" | ||
| 93 | "igb, 1" | ||
| 94 | "ipg, 1" | ||
| 95 | "jme, 1" | ||
| 96 | "natsemi, 1" | ||
| 97 | "ne2k-pci, 1" | ||
| 98 | "ns83820, 1" | ||
| 99 | "pcnet32, 1" | ||
| 100 | "qla3xxx, 1" | ||
| 101 | "r8169, 1" | ||
| 102 | "sis190, 1" | ||
| 103 | "sis900, 1" | ||
| 104 | "skge, 1" | ||
| 105 | "sky2, 1" | ||
| 106 | "tg3, 1" | ||
| 107 | "typhoon, 1" | ||
| 108 | "via-rhine, 1" | ||
| 109 | "via-velocity, 1" | ||
| 110 | "adm8211, 1" | ||
| 111 | "airo, 1" | ||
| 112 | "at76c50x-usb, 1" | ||
| 113 | "ar9170usb, 1" | ||
| 114 | "ath5k, 1" | ||
| 115 | "ath9k, 1" | ||
| 116 | "atmel, 1" | ||
| 117 | "atmel_pci, 1" | ||
| 118 | "b43, 1" | ||
| 119 | "b43legacy, 1" | ||
| 120 | "hostap_pci, 1" | ||
| 121 | "hostap_plx, 1" | ||
| 122 | "ipw2100, 1" | ||
| 123 | "ipw2200, 1" | ||
| 124 | "iwl3945, 1" | ||
| 125 | "iwl4965, 1" | ||
| 126 | "iwldvm, 1" | ||
| 127 | "iwlwifi, 1" | ||
| 128 | "libertas_tf, 1" | ||
| 129 | "libertas_tf_usb, 1" | ||
| 130 | "mwl8k, 1" | ||
| 131 | "orinoco, 1" | ||
| 132 | "orinoco_nortel, 1" | ||
| 133 | "orinoco_plx, 1" | ||
| 134 | "orinico_tmd, 1" | ||
| 135 | "orinoco_usb, 1" | ||
| 136 | "p54pci, 1" | ||
| 137 | "p54usb, 1" | ||
| 138 | "prism54, 1" | ||
| 139 | "mdis_wlan, 1" | ||
| 140 | "rt2400pci, 1" | ||
| 141 | "rt2500pci, 1" | ||
| 142 | "rt2500usb, 1" | ||
| 143 | "rt2800pci, 1" | ||
| 144 | "rt2800usb, 1" | ||
| 145 | "rt61pci, 1" | ||
| 146 | "rt73usb, 1" | ||
| 147 | "rtl8180, 1" | ||
| 148 | "rtl8187, 1" | ||
| 149 | "usb8xxx, 1" | ||
| 150 | "wl1251, 1" | ||
| 151 | "wl1271, 1" | ||
| 152 | "zd1201, 1" | ||
| 153 | "zd1211rw, 1" | ||
| 154 | ) | ||
| 155 | sql_set_value | ||
| 156 | |||
| 157 | VALUE_DEFINITION=( | ||
| 158 | "values_printers_port, value, enabled, id" | ||
| 159 | "lpt1, 1" | ||
| 160 | "usb1, 1" | ||
| 161 | "usb2, 1" | ||
| 162 | "com1, 1" | ||
| 163 | "com2, 1" | ||
| 164 | ) | ||
| 165 | sql_set_value | ||
| 166 | |||
| 167 | VALUE_DEFINITION=( | ||
| 168 | "values_screensaver_screensaver, value, enabled, id" | ||
| 169 | ", 1" | ||
| 170 | "blank, 1" | ||
| 171 | "random, 1" | ||
| 172 | "ant, 1" | ||
| 173 | "ant3d, 1" | ||
| 174 | "apollonian, 1" | ||
| 175 | "ball, 1" | ||
| 176 | "bat, 1" | ||
| 177 | "blot, 1" | ||
| 178 | "bomb, 1" | ||
| 179 | "bouboule, 1" | ||
| 180 | "bounce, 1" | ||
| 181 | "braid, 1" | ||
| 182 | "bubble, 1" | ||
| 183 | "bug, 1" | ||
| 184 | "clock, 1" | ||
| 185 | "coral, 1" | ||
| 186 | "crystal, 1" | ||
| 187 | "daisy, 1" | ||
| 188 | "dclock, 1" | ||
| 189 | "decay, 1" | ||
| 190 | "deco, 1" | ||
| 191 | "demon, 1" | ||
| 192 | "dilemma, 1" | ||
| 193 | "discrete, 1" | ||
| 194 | "dragon, 1" | ||
| 195 | "drift, 1" | ||
| 196 | "euler2d, 1" | ||
| 197 | "eyes, 1" | ||
| 198 | "fadeplot, 1" | ||
| 199 | "fiberlamp, 1" | ||
| 200 | "flag, 1" | ||
| 201 | "flame, 1" | ||
| 202 | "flow, 1" | ||
| 203 | "forest, 1" | ||
| 204 | "galaxy, 1" | ||
| 205 | "goop, 1" | ||
| 206 | "grav, 1" | ||
| 207 | "helix, 1" | ||
| 208 | "hop, 1" | ||
| 209 | "hyper, 1" | ||
| 210 | "ico, 1" | ||
| 211 | "ifs, 1" | ||
| 212 | "image, 1" | ||
| 213 | "juggle, 1" | ||
| 214 | "julia, 1" | ||
| 215 | "kaleid, 1" | ||
| 216 | "kumppa, 1" | ||
| 217 | "laser, 1" | ||
| 218 | "life, 1" | ||
| 219 | "life1d, 1" | ||
| 220 | "life3d, 1" | ||
| 221 | "lightning, 1" | ||
| 222 | "lisa, 1" | ||
| 223 | "lissie, 1" | ||
| 224 | "loop, 1" | ||
| 225 | "lyapunov, 1" | ||
| 226 | "mandelbrot, 1" | ||
| 227 | "marquee, 1" | ||
| 228 | "matrix, 1" | ||
| 229 | "maze, 1" | ||
| 230 | "mountain, 1" | ||
| 231 | "munch, 1" | ||
| 232 | "nose, 1" | ||
| 233 | "pacman, 1" | ||
| 234 | "penrose, 1" | ||
| 235 | "petal, 1" | ||
| 236 | "petri, 1" | ||
| 237 | "polyominoes, 1" | ||
| 238 | "puzzle, 1" | ||
| 239 | "pyro, 1" | ||
| 240 | "qix, 1" | ||
| 241 | "roll, 1" | ||
| 242 | "rotor, 1" | ||
| 243 | "scooter, 1" | ||
| 244 | "shape, 1" | ||
| 245 | "sierpinski, 1" | ||
| 246 | "slip, 1" | ||
| 247 | "solitare, 1" | ||
| 248 | "space, 1" | ||
| 249 | "sphere, 1" | ||
| 250 | "spiral, 1" | ||
| 251 | "spline, 1" | ||
| 252 | "star, 1" | ||
| 253 | "starfish, 1" | ||
| 254 | "strange, 1" | ||
| 255 | "swarm, 1" | ||
| 256 | "swirl, 1" | ||
| 257 | "t3d, 1" | ||
| 258 | "tetris, 1" | ||
| 259 | "thornbird, 1" | ||
| 260 | "tik_tak, 1" | ||
| 261 | "toneclock, 1" | ||
| 262 | "triangle, 1" | ||
| 263 | "tube, 1" | ||
| 264 | "turtle, 1" | ||
| 265 | "vines, 1" | ||
| 266 | "voters, 1" | ||
| 267 | "wator, 1" | ||
| 268 | "wire, 1" | ||
| 269 | "world, 1" | ||
| 270 | "worm, 1" | ||
| 271 | "xcl, 1" | ||
| 272 | "xjack, 1" | ||
| 273 | ) | ||
| 274 | sql_set_value | ||
| 275 | } |