-- phpMyAdmin SQL Dump -- version 2.9.0 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 10. November 2006 um 14:49 -- Server Version: 5.0.18 -- PHP-Version: 5.1.2 -- -- Datenbank: `idoit` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `isys_person_intern` -- CREATE TABLE `isys_person_intern` ( `isys_person_intern__id` int(10) unsigned NOT NULL auto_increment, `isys_person_intern__isys_organisation_intern_iop__id` int(10) unsigned default NULL, `isys_person_intern__title` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__description` text collate latin1_german1_ci, `isys_person_intern__sort` int(10) unsigned default '5', `isys_person_intern__const` int(10) unsigned default NULL, `isys_person_intern__user_pass` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__last_name` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__first_name` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__department` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__position` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__photo` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__mail_address` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__phone_company` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__phone_mobile` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__phone_home` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__fax` varchar(255) collate latin1_german1_ci default NULL, `isys_person_intern__status` int(10) unsigned default '2', `isys_person_intern__property` int(10) unsigned default '0', PRIMARY KEY (`isys_person_intern__id`), KEY `isys_person_intern_FKIndex1` (`isys_person_intern__isys_organisation_intern_iop__id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=16 ; -- -- Daten für Tabelle `isys_person_intern` -- INSERT INTO `isys_person_intern` (`isys_person_intern__id`, `isys_person_intern__isys_organisation_intern_iop__id`, `isys_person_intern__title`, `isys_person_intern__description`, `isys_person_intern__sort`, `isys_person_intern__const`, `isys_person_intern__user_pass`, `isys_person_intern__last_name`, `isys_person_intern__first_name`, `isys_person_intern__department`, `isys_person_intern__position`, `isys_person_intern__photo`, `isys_person_intern__mail_address`, `isys_person_intern__phone_company`, `isys_person_intern__phone_mobile`, `isys_person_intern__phone_home`, `isys_person_intern__fax`, `isys_person_intern__status`, `isys_person_intern__property`) VALUES (1, 1, 'guest', NULL, 0, 0, '084e0343a0486ff05530df6c705c8bb4', '', 'guest', '', '', '', '', '', '', '', '', 2, 1), (11, NULL, 'reader', 'Reader', 0, 0, '1de9b0a30075ae8c303eb420c103c320', '', 'reader', '', '', '', '', '', '', '', '', 2, 1), (12, 1, 'editor', 'Editor', 0, 0, '5aee9dbd2a188839105073571bee1b1f', '', 'editor', '', '', '', '', '', '', '', '', 2, 1), (13, 1, 'author', '', 0, 0, '02bd92faa38aaa6cc0ea75e59937a1ef', '', 'author', '', '', '', 'author@synetics.de', '', '0211 12345678', '', '', 2, 1), (14, 1, 'archivar', 'Archivar', 0, 0, '4baf8329be21a4ad4f4401295cc130a9', '', 'archivar', '', '', '', '', '', '', '', '', 2, 1), (15, 1, 'admin', 'Admin', 0, 0, '21232f297a57a5a743894a0e4a801fc3', '', 'admin', '', '', '', '', '', '', '', '', 2, 1); -- -- Constraints der exportierten Tabellen -- -- -- Constraints der Tabelle `isys_person_intern` -- ALTER TABLE `isys_person_intern` ADD CONSTRAINT `isys_person_intern_ibfk_1` FOREIGN KEY (`isys_person_intern__isys_organisation_intern_iop__id`) REFERENCES `isys_organisation_intern_iop` (`isys_organisation_intern_iop__id`) ON DELETE NO ACTION ON UPDATE NO ACTION;