14 lines
481 B
Plaintext
14 lines
481 B
Plaintext
DROP TABLE IF EXISTS `freifunk`
|
|
#NL
|
|
CREATE TABLE IF NOT EXISTS `freifunk` (
|
|
`id` BIGINT unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
|
|
`description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
|
|
`source_id` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
|
|
`loc` POINT NOT NULL,
|
|
`protocol_id` SMALLINT unsigned NOT NULL,
|
|
`link` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
|
|
UNIQUE (id)
|
|
);
|
|
#NL
|