![(please configure the [header_logo] section in trac.ini)](/tanec/chrome/site/your_project_logo.png){kind=logo}
- Timestamp:
- Dec 20, 2022, 11:51:30 PM (2 years ago)
- Location:
- trunk/SQL
- Files:
-
- 2 edited
-
Structure.sql (modified) (25 diffs)
-
Update.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/SQL/Structure.sql
r57 r67 1 1 -- phpMyAdmin SQL Dump 2 -- version 4.9.5deb22 -- version 5.1.1deb5ubuntu1 3 3 -- https://www.phpmyadmin.net/ 4 4 -- 5 5 -- Počítač: localhost:3306 6 -- Vytvořeno: Stř 27. kvě 2020, 19:397 -- Verze serveru: 10. 3.22-MariaDB-1ubuntu18 -- Verze PHP: 7.4.36 -- Vytvořeno: Úte 20. pro 2022, 23:38 7 -- Verze serveru: 10.6.11-MariaDB-0ubuntu0.22.04.1 8 -- Verze PHP: 8.1.2-1ubuntu2.9 9 9 10 10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 11 SET AUTOCOMMIT = 0;12 11 START TRANSACTION; 13 12 SET time_zone = "+00:00"; … … 27 26 `Name` varchar(255) NOT NULL, 28 27 `Group` int(11) DEFAULT NULL 29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 29 30 -- 31 -- VZTAHY TABULKY `Dance`: 32 -- `Group` 33 -- `DanceGroup` -> `Id` 34 -- 30 35 31 36 -- -------------------------------------------------------- … … 40 45 `NameEn` varchar(255) NOT NULL, 41 46 `Dance` int(11) NOT NULL 42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 47 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 48 49 -- 50 -- VZTAHY TABULKY `DanceFigure`: 51 -- `Dance` 52 -- `Dance` -> `Id` 53 -- 43 54 44 55 -- -------------------------------------------------------- … … 51 62 `Id` int(11) NOT NULL, 52 63 `Name` varchar(255) NOT NULL 53 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 65 66 -- 67 -- VZTAHY TABULKY `DanceGroup`: 68 -- 54 69 55 70 -- -------------------------------------------------------- … … 72 87 `TimeImport` datetime DEFAULT NULL, 73 88 `RemoteId` varchar(255) DEFAULT NULL 74 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 89 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 90 91 -- 92 -- VZTAHY TABULKY `Event`: 93 -- 75 94 76 95 -- -------------------------------------------------------- … … 85 104 `Method` varchar(255) DEFAULT NULL, 86 105 `URL` varchar(255) DEFAULT NULL 87 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 106 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 107 108 -- 109 -- VZTAHY TABULKY `EventSource`: 110 -- 88 111 89 112 -- -------------------------------------------------------- … … 95 118 CREATE TABLE `MeetItem` ( 96 119 `Id` int(11) NOT NULL, 97 `Message` text NOT NULL,120 `Message` mediumtext NOT NULL, 98 121 `Name` varchar(255) NOT NULL, 99 122 `Age` int(11) DEFAULT NULL, … … 110 133 `RemoteId` varchar(255) DEFAULT NULL, 111 134 `Hidden` int(11) DEFAULT 0 112 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 136 137 -- 138 -- VZTAHY TABULKY `MeetItem`: 139 -- `Source` 140 -- `MeetSource` -> `Id` 141 -- 113 142 114 143 -- -------------------------------------------------------- … … 123 152 `URL` varchar(255) NOT NULL, 124 153 `Method` varchar(255) NOT NULL, 125 `Enabled` int(11) NOT NULL DEFAULT 1 126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 154 `Enabled` int(11) NOT NULL DEFAULT 1, 155 `InsertURL` varchar(255) NOT NULL 156 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 157 158 -- 159 -- VZTAHY TABULKY `MeetSource`: 160 -- 127 161 128 162 -- -------------------------------------------------------- … … 139 173 `Imdb` varchar(255) NOT NULL, 140 174 `Csfd` varchar(255) NOT NULL 141 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 175 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 176 177 -- 178 -- VZTAHY TABULKY `Movie`: 179 -- 142 180 143 181 -- -------------------------------------------------------- … … 152 190 `URL` varchar(255) NOT NULL, 153 191 `Dance` int(11) NOT NULL 154 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 193 194 -- 195 -- VZTAHY TABULKY `Music`: 196 -- `Dance` 197 -- `Dance` -> `Id` 198 -- 155 199 156 200 -- -------------------------------------------------------- … … 166 210 `URL` varchar(255) NOT NULL, 167 211 `Group` int(11) DEFAULT NULL 168 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 212 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 213 214 -- 215 -- VZTAHY TABULKY `Resource`: 216 -- `Dance` 217 -- `Dance` -> `Id` 218 -- `Group` 219 -- `ResourceGroup` -> `Id` 220 -- 169 221 170 222 -- -------------------------------------------------------- … … 178 230 `Name` varchar(255) NOT NULL, 179 231 `URL` varchar(255) NOT NULL 180 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 232 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 233 234 -- 235 -- VZTAHY TABULKY `ResourceGroup`: 236 -- 181 237 182 238 -- -------------------------------------------------------- … … 191 247 `Address` varchar(255) NOT NULL, 192 248 `URL` varchar(255) NOT NULL 193 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 194 195 -- 196 -- Klíče pro exportované tabulky 197 -- 198 199 -- 200 -- Klíče pro tabulku `Dance` 249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 250 251 -- 252 -- VZTAHY TABULKY `School`: 253 -- 254 255 -- 256 -- Indexy pro exportované tabulky 257 -- 258 259 -- 260 -- Indexy pro tabulku `Dance` 201 261 -- 202 262 ALTER TABLE `Dance` … … 205 265 206 266 -- 207 -- Klíče protabulku `DanceFigure`267 -- Indexy pro tabulku `DanceFigure` 208 268 -- 209 269 ALTER TABLE `DanceFigure` … … 213 273 214 274 -- 215 -- Klíče protabulku `DanceGroup`275 -- Indexy pro tabulku `DanceGroup` 216 276 -- 217 277 ALTER TABLE `DanceGroup` … … 219 279 220 280 -- 221 -- Klíče protabulku `Event`281 -- Indexy pro tabulku `Event` 222 282 -- 223 283 ALTER TABLE `Event` … … 226 286 227 287 -- 228 -- Klíče protabulku `EventSource`288 -- Indexy pro tabulku `EventSource` 229 289 -- 230 290 ALTER TABLE `EventSource` … … 232 292 233 293 -- 234 -- Klíče protabulku `MeetItem`294 -- Indexy pro tabulku `MeetItem` 235 295 -- 236 296 ALTER TABLE `MeetItem` … … 240 300 241 301 -- 242 -- Klíče protabulku `MeetSource`302 -- Indexy pro tabulku `MeetSource` 243 303 -- 244 304 ALTER TABLE `MeetSource` … … 246 306 247 307 -- 248 -- Klíče protabulku `Movie`308 -- Indexy pro tabulku `Movie` 249 309 -- 250 310 ALTER TABLE `Movie` … … 253 313 254 314 -- 255 -- Klíče protabulku `Music`315 -- Indexy pro tabulku `Music` 256 316 -- 257 317 ALTER TABLE `Music` … … 260 320 261 321 -- 262 -- Klíče protabulku `Resource`322 -- Indexy pro tabulku `Resource` 263 323 -- 264 324 ALTER TABLE `Resource` … … 268 328 269 329 -- 270 -- Klíče protabulku `ResourceGroup`330 -- Indexy pro tabulku `ResourceGroup` 271 331 -- 272 332 ALTER TABLE `ResourceGroup` … … 274 334 275 335 -- 276 -- Klíče protabulku `School`336 -- Indexy pro tabulku `School` 277 337 -- 278 338 ALTER TABLE `School` -
trunk/SQL/Update.php
r66 r67 98 98 ALTER TABLE `ResourceGroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 99 99 ALTER TABLE `School` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 100 101 -- rev 66 102 ALTER TABLE `MeetSource` ADD `InsertURL` VARCHAR(255) NOT NULL AFTER `Enabled`;
Note:
See TracChangeset
for help on using the changeset viewer.
