source: trunk/database.sql

Last change on this file was 3, checked in by chronos, 8 years ago
  • Modified: Updated to work with PHP7. Old database class replaced by Common package.
File size: 1.4 KB
Line 
1CREATE TABLE `app_errors` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `time` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
4 `message` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
5 `exception` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
6 `address` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
7 `application` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
8 `state` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
9 `version` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
10 `release_date` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
11 `method` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
12 `unit` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
13 `line_number` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
14 `remote_addr` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
15 `remote_host` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
16 `url` text CHARACTER SET utf8 NOT NULL,
17 PRIMARY KEY (`id`)
18) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
19
20CREATE TABLE `projekty` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `title` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
23 `description` text CHARACTER SET utf8 NOT NULL,
24 `link` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
25 `image` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
26 `finished` int(11) NOT NULL DEFAULT '0',
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
Note: See TracBrowser for help on using the repository browser.