2026-08-09 09:16:09 -04:00
|
|
|
<?php
|
|
|
|
|
|
|
|
|
|
$SQL = "create table dropdowns
|
|
|
|
|
|
|
|
|
|
(
|
|
|
|
|
|
|
|
|
|
dropdown_serial serial,
|
|
|
|
|
dropdown_dropdowntype bigint unsigned default 0,
|
|
|
|
|
dropdown_value varchar(100) default null,
|
|
|
|
|
dropdown_default boolean default false,
|
|
|
|
|
dropdown_active boolean default false,
|
|
|
|
|
|
|
|
|
|
dropdown_creator varchar(100) default null,
|
|
|
|
|
dropdown_created datetime default null,
|
|
|
|
|
dropdown_changer varchar(100) default null,
|
|
|
|
|
dropdown_changed datetime default null,
|
|
|
|
|
|
|
|
|
|
primary key (dropdown_serial),
|
|
|
|
|
unique key (dropdown_dropdowntype, dropdown_value),
|
|
|
|
|
|
|
|
|
|
foreign key (dropdown_dropdowntype)
|
|
|
|
|
references dropdowntypes(dropdowntype_serial)
|
|
|
|
|
on update cascade
|
|
|
|
|
on delete restrict
|
|
|
|
|
|
|
|
|
|
)
|
|
|
|
|
|
2026-08-09 20:00:09 -04:00
|
|
|
default character set = utf8mb4";
|
2026-08-09 09:16:09 -04:00
|
|
|
|
|
|
|
|
?>
|
