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` ( |
|
| @@ 903-936 (lines=34) @@ | ||
| 900 | PRIMARY KEY (`id`) |
|
| 901 | ) CHARSET=utf8;" |
|
| 902 | ); |
|
| 903 | } elseif ($task === "suggestion") { |
|
| 904 | $mysqli_result = mysqli_query( |
|
| 905 | $dbTmp, |
|
| 906 | "CREATE TABLE IF NOT EXISTS `".$var['tbl_prefix']."suggestion` ( |
|
| 907 | `id` tinyint(12) NOT NULL AUTO_INCREMENT, |
|
| 908 | `label` varchar(255) NOT NULL, |
|
| 909 | `pw` text NOT NULL, |
|
| 910 | `pw_iv` text NOT NULL, |
|
| 911 | `pw_len` int(5) NOT NULL, |
|
| 912 | `description` text NOT NULL, |
|
| 913 | `author_id` int(12) NOT NULL, |
|
| 914 | `folder_id` int(12) NOT NULL, |
|
| 915 | `comment` text NOT NULL, |
|
| 916 | `suggestion_type` varchar(10) NOT NULL default 'new', |
|
| 917 | PRIMARY KEY (`id`) |
|
| 918 | ) CHARSET=utf8;" |
|
| 919 | ); |
|
| 920 | ||
| 921 | $mysqli_result = mysqli_query( |
|
| 922 | $dbTmp, |
|
| 923 | "CREATE TABLE IF NOT EXISTS `".$var['tbl_prefix']."export` ( |
|
| 924 | `id` int(12) NOT NULL, |
|
| 925 | `label` varchar(500) NOT NULL, |
|
| 926 | `login` varchar(100) NOT NULL, |
|
| 927 | `description` text NOT NULL, |
|
| 928 | `pw` text NOT NULL, |
|
| 929 | `path` varchar(500) NOT NULL, |
|
| 930 | `email` varchar(500) NOT NULL default 'none', |
|
| 931 | `url` varchar(500) NOT NULL default 'none', |
|
| 932 | `kbs` varchar(500) NOT NULL default 'none', |
|
| 933 | `tags` varchar(500) NOT NULL default 'none' |
|
| 934 | ) CHARSET=utf8;" |
|
| 935 | ); |
|
| 936 | } elseif ($task === "tokens") { |
|
| 937 | $mysqli_result = mysqli_query( |
|
| 938 | $dbTmp, |
|
| 939 | "CREATE TABLE IF NOT EXISTS `".$var['tbl_prefix']."tokens` ( |
|
