nilsteampassnet /
TeamPass
| @@ 345-363 (lines=19) @@ | ||
| 342 | KEY `restricted_inactif_idx` (`restricted_to`,`inactif`) |
|
| 343 | ) CHARSET=utf8;" |
|
| 344 | ); |
|
| 345 | } elseif ($task === "log_items") { |
|
| 346 | $mysqli_result = mysqli_query( |
|
| 347 | $dbTmp, |
|
| 348 | "CREATE TABLE IF NOT EXISTS `".$var['tbl_prefix']."log_items` ( |
|
| 349 | `id_item` int(8) NOT NULL, |
|
| 350 | `date` varchar(50) NOT NULL, |
|
| 351 | `id_user` int(8) NOT NULL, |
|
| 352 | `action` varchar(250) NULL, |
|
| 353 | `raison` text NULL, |
|
| 354 | `raison_iv` text NULL, |
|
| 355 | `encryption_type` VARCHAR(20) NOT NULL DEFAULT 'not_set' |
|
| 356 | ) CHARSET=utf8;" |
|
| 357 | ); |
|
| 358 | // create index |
|
| 359 | mysqli_query( |
|
| 360 | $dbTmp, |
|
| 361 | "CREATE INDEX teampass_log_items_id_item_IDX ON ".$var['tbl_prefix']."log_items (id_item,date);" |
|
| 362 | ); |
|
| 363 | } elseif ($task === "misc") { |
|
| 364 | $mysqli_result = mysqli_query( |
|
| 365 | $dbTmp, |
|
| 366 | "CREATE TABLE IF NOT EXISTS `".$var['tbl_prefix']."misc` ( |
|
| @@ 872-905 (lines=34) @@ | ||
| 869 | PRIMARY KEY (`id`) |
|
| 870 | ) CHARSET=utf8;" |
|
| 871 | ); |
|
| 872 | } elseif ($task === "suggestion") { |
|
| 873 | $mysqli_result = mysqli_query( |
|
| 874 | $dbTmp, |
|
| 875 | "CREATE TABLE IF NOT EXISTS `".$var['tbl_prefix']."suggestion` ( |
|
| 876 | `id` tinyint(12) NOT NULL AUTO_INCREMENT, |
|
| 877 | `label` varchar(255) NOT NULL, |
|
| 878 | `pw` text NOT NULL, |
|
| 879 | `pw_iv` text NOT NULL, |
|
| 880 | `pw_len` int(5) NOT NULL, |
|
| 881 | `description` text NOT NULL, |
|
| 882 | `author_id` int(12) NOT NULL, |
|
| 883 | `folder_id` int(12) NOT NULL, |
|
| 884 | `comment` text NOT NULL, |
|
| 885 | `suggestion_type` varchar(10) NOT NULL default 'new', |
|
| 886 | PRIMARY KEY (`id`) |
|
| 887 | ) CHARSET=utf8;" |
|
| 888 | ); |
|
| 889 | ||
| 890 | $mysqli_result = mysqli_query( |
|
| 891 | $dbTmp, |
|
| 892 | "CREATE TABLE IF NOT EXISTS `".$var['tbl_prefix']."export` ( |
|
| 893 | `id` int(12) NOT NULL, |
|
| 894 | `label` varchar(255) NOT NULL, |
|
| 895 | `login` varchar(100) NOT NULL, |
|
| 896 | `description` text NOT NULL, |
|
| 897 | `pw` text NOT NULL, |
|
| 898 | `path` varchar(500) NOT NULL, |
|
| 899 | `email` varchar(500) NOT NULL default 'none', |
|
| 900 | `url` varchar(500) NOT NULL default 'none', |
|
| 901 | `kbs` varchar(500) NOT NULL default 'none', |
|
| 902 | `tags` varchar(500) NOT NULL default 'none' |
|
| 903 | ) CHARSET=utf8;" |
|
| 904 | ); |
|
| 905 | } elseif ($task === "tokens") { |
|
| 906 | $mysqli_result = mysqli_query( |
|
| 907 | $dbTmp, |
|
| 908 | "CREATE TABLE IF NOT EXISTS `".$var['tbl_prefix']."tokens` ( |
|
