📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
otelscripti.demodesign.com.tr
/
admin
/
installers
/
Home
📝
Database.sql
← Geri Dön
-- ---------------------------- -- Table structure for `admin_groups` -- ---------------------------- CREATE TABLE `admin_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin_groups -- ---------------------------- INSERT INTO `admin_groups` VALUES ('1', 'Yönetici'); -- ---------------------------- -- Table structure for `admin_perms` -- ---------------------------- CREATE TABLE `admin_perms` ( `groupId` int(10) unsigned NOT NULL, `module` varchar(255) NOT NULL, `perm` varchar(255) NOT NULL, KEY `fk_admin_perms_groupId` (`groupId`), CONSTRAINT `fk_admin_perms_groupId` FOREIGN KEY (`groupId`) REFERENCES `admin_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `admin_users` -- ---------------------------- CREATE TABLE `admin_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `groupId` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_admin_users_groupId` (`groupId`), CONSTRAINT `fk_admin_users_groupId` FOREIGN KEY (`groupId`) REFERENCES `admin_groups` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin_users -- ---------------------------- INSERT INTO `admin_users` VALUES ('1', 'root', md5('12root34'), null); -- ---------------------------- -- Table structure for `modules` -- ---------------------------- CREATE TABLE `modules` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `table` varchar(255) NOT NULL, `modified` int(10) unsigned NOT NULL, `permissions` text NOT NULL, `type` varchar(255) DEFAULT NULL, `icon` varchar(255) DEFAULT NULL, `menuPattern` text, `controller` varchar(255) NOT NULL, `order` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `module_arguments` -- ---------------------------- CREATE TABLE `module_arguments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `value` longtext, `type` varchar(255) NOT NULL, `arguments` longtext NOT NULL, `language` varchar(5) NOT NULL, PRIMARY KEY (`id`), KEY `fk_module_arguments_module` (`module`), CONSTRAINT `fk_module_arguments_module` FOREIGN KEY (`module`) REFERENCES `modules` (`name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `menus` -- ---------------------------- CREATE TABLE `menus` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parentId` int(10) unsigned DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `title` varchar(255) NOT NULL, `hint` varchar(255) DEFAULT NULL, `link` varchar(255) DEFAULT NULL, `htmlID` varchar(255) DEFAULT NULL, `htmlClass` varchar(255) DEFAULT NULL, `target` varchar(20) DEFAULT NULL, `order` int(10) unsigned NOT NULL DEFAULT '0', `language` varchar(5) NOT NULL, PRIMARY KEY (`id`), KEY `fk_menus_parentId` (`parentId`), CONSTRAINT `fk_menus_parentId` FOREIGN KEY (`parentId`) REFERENCES `menus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `options` -- ---------------------------- CREATE TABLE `options` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `value` longtext, `type` varchar(255) NOT NULL, `arguments` longtext NOT NULL, `language` varchar(5) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
💾 Kaydet
İptal
📝 Yeniden Adlandır
İptal
Kaydet
🔐 Dosya İzinleri (chmod)
İzin Değeri:
Hızlı Seçim:
777
755
644
600
777
= Herkes okur/yazar/çalıştırır
755
= Sahip tam, diğerleri okur/çalıştırır
644
= Sahip okur/yazar, diğerleri okur
600
= Sadece sahip okur/yazar
İptal
Uygula