1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| -- phpMyAdmin SQL Dump
-- version 2.6.4-pl1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Lundi 30 Janvier 2006 à 17:28
-- Version du serveur: 4.1.14
-- Version de PHP: 5.0.5
--
-- Base de données: `sysfile_db`
--
-- --------------------------------------------------------
--
-- Structure de la table `groups`
--
CREATE TABLE `groups` (
`groups_id` int(2) NOT NULL auto_increment,
`groups_name` varchar(25) collate latin1_general_cs NOT NULL default '',
`groups_comment` varchar(50) collate latin1_general_cs NOT NULL default '',
PRIMARY KEY (`groups_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `objects`
--
CREATE TABLE `objects` (
`objects_id` int(4) NOT NULL auto_increment,
`objects_name` varchar(15) character set latin1 NOT NULL default '',
`objects_location` varchar(50) character set latin1 NOT NULL default '',
`objects_idOwner` int(2) NOT NULL default '0',
`objects_rightsOwner` char(3) character set latin1 default 'rwx',
`objects_rightsGroup` char(3) character set latin1 default NULL,
`objects_rightsWorld` char(3) character set latin1 default NULL,
`objects_type` char(1) character set latin1 NOT NULL default '',
PRIMARY KEY (`objects_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `users`
--
CREATE TABLE `users` (
`user_id` int(2) NOT NULL auto_increment,
`user_login` varchar(10) NOT NULL default '',
`user_pass` varchar(30) NOT NULL default '',
`users_group` int(2) NOT NULL default '0',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; |
Partager