Revize a98f44ed
Přidáno uživatelem Tomáš Šimandl před více než 6 roky(ů)
| sources/create_table.sql | ||
|---|---|---|
| 38 | 38 |
|
| 39 | 39 |
-- -------------------------------------------------------- |
| 40 | 40 |
|
| 41 |
-- |
|
| 42 |
-- Struktura tabulky `log` |
|
| 43 |
-- |
|
| 44 |
|
|
| 45 |
CREATE TABLE IF NOT EXISTS `log` ( |
|
| 46 |
`id` int(11) NOT NULL, |
|
| 47 |
`id_user` int(11) NOT NULL, |
|
| 48 |
`user_name` varchar(10) COLLATE utf8_czech_ci NOT NULL, |
|
| 49 |
`id_diagram` int(11) NOT NULL, |
|
| 50 |
`event` varchar(10) COLLATE utf8_czech_ci NOT NULL, |
|
| 51 |
`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, |
|
| 52 |
`date_delay` datetime DEFAULT NULL, |
|
| 53 |
`change_jar` varchar(128) COLLATE utf8_czech_ci DEFAULT NULL, |
|
| 54 |
`new_version` varchar(128) COLLATE utf8_czech_ci DEFAULT NULL |
|
| 55 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; |
|
| 56 |
|
|
| 57 |
-- -------------------------------------------------------- |
|
| 58 |
|
|
| 59 | 41 |
-- |
| 60 | 42 |
-- Struktura tabulky `user` |
| 61 | 43 |
-- |
| ... | ... | |
| 82 | 64 |
ALTER TABLE `diagram` |
| 83 | 65 |
ADD PRIMARY KEY (`id`); |
| 84 | 66 |
|
| 85 |
-- |
|
| 86 |
-- Klíče pro tabulku `log` |
|
| 87 |
-- |
|
| 88 |
ALTER TABLE `log` |
|
| 89 |
ADD PRIMARY KEY (`id`); |
|
| 90 |
|
|
| 91 | 67 |
-- |
| 92 | 68 |
-- Klíče pro tabulku `user` |
| 93 | 69 |
-- |
| ... | ... | |
| 104 | 80 |
ALTER TABLE `diagram` |
| 105 | 81 |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; |
| 106 | 82 |
-- |
| 107 |
-- AUTO_INCREMENT pro tabulku `log` |
|
| 108 |
-- |
|
| 109 |
ALTER TABLE `log` |
|
| 110 |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; |
|
| 111 |
-- |
|
| 112 | 83 |
-- AUTO_INCREMENT pro tabulku `user` |
| 113 | 84 |
-- |
| 114 | 85 |
ALTER TABLE `user` |
Také k dispozici: Unified diff
Removed TABLE 'log' from database