Revize d4e61447
Přidáno uživatelem Tomáš Šimandl před více než 6 roky(ů)
sources/create_table.sql | ||
---|---|---|
28 | 28 |
|
29 | 29 |
CREATE TABLE IF NOT EXISTS `diagram` ( |
30 | 30 |
`id` int(11) NOT NULL, |
31 |
`session_id` varchar(32) COLLATE utf8_czech_ci NOT NULL, |
|
32 | 31 |
`name` varchar(255) COLLATE utf8_czech_ci NOT NULL, |
33 |
`component_count` int(11) NOT NULL DEFAULT '0', |
|
34 | 32 |
`created` datetime NOT NULL, |
33 |
`last_update` datetime NOT NULL, |
|
35 | 34 |
`user_id` int(11) NOT NULL, |
36 |
`vertices_position` text COLLATE utf8_czech_ci NOT NULL, |
|
37 |
`hash` varchar(32) COLLATE utf8_czech_ci NOT NULL DEFAULT '', |
|
38 | 35 |
`public` tinyint(1) NOT NULL DEFAULT '0' |
36 |
`graph_json` text COLLATE utf8_czech_ci NOT NULL DEFAULT '', |
|
37 |
-- `session_id` varchar(32) COLLATE utf8_czech_ci NOT NULL, |
|
38 |
-- `component_count` int(11) NOT NULL DEFAULT '0', |
|
39 |
-- `vertices_position` text COLLATE utf8_czech_ci NOT NULL, |
|
40 |
-- `hash` varchar(32) COLLATE utf8_czech_ci NOT NULL DEFAULT '', |
|
39 | 41 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; |
40 | 42 |
|
41 | 43 |
-- -------------------------------------------------------- |
Také k dispozici: Unified diff
Changed diagram table and Diagram class