aboutsummaryrefslogblamecommitdiffstats
path: root/vendor/examples/sql/mysql.propertystorage.sql
blob: 1b5ca5ac6ec1e19979c2e62fbcd8fca242e8a4ec (plain) (tree)
1
2
3
4
5
6
7
8
9








                                                                            
CREATE TABLE propertystorage (
    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    path VARBINARY(1024) NOT NULL,
    name VARBINARY(100) NOT NULL,
    valuetype INT UNSIGNED,
    value MEDIUMBLOB
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE UNIQUE INDEX path_property ON propertystorage (path(600), name(100));