Subversion Repositories Applications.papyrus

Rev

Rev 448 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 448 Rev 482
Line 29... Line 29...
29 
  `id_identifiant_session` varchar(32) NOT NULL default '',
 29 
  `id_identifiant_session` varchar(32) NOT NULL default '',
30 
  `id_donnees` text NOT NULL,
 30 
  `id_donnees` text NOT NULL,
31 
  `id_date` date NOT NULL default '0000-00-00',
 31 
  `id_date` date NOT NULL default '0000-00-00',
32 
  PRIMARY KEY  (`id_identifiant_session`)
 32 
  PRIMARY KEY  (`id_identifiant_session`)
33 
) ;
 33 
) ;
- 
 
 34 
 
- 
 
 35 
-- Table pour faire des inscriptions avec wikini
- 
 
 36 
-- OPTIONNELLE
- 
 
 37 
CREATE TABLE `interwikini_users` (
- 
 
 38 
  `name` varchar(80) NOT NULL default '',
- 
 
 39 
  `password` varchar(32) NOT NULL default '',
- 
 
 40 
  `email` varchar(50) NOT NULL default '',
- 
 
 41 
  `motto` text NOT NULL,
- 
 
 42 
  `revisioncount` int(10) unsigned NOT NULL default '20',
- 
 
 43 
  `changescount` int(10) unsigned NOT NULL default '50',
- 
 
 44 
  `doubleclickedit` enum('Y','N') NOT NULL default 'Y',
- 
 
 45 
  `signuptime` datetime NOT NULL default '0000-00-00 00:00:00',
- 
 
 46 
  `show_comments` enum('Y','N') NOT NULL default 'N',
- 
 
 47 
  PRIMARY KEY  (`name`),
- 
 
 48 
  KEY `idx_name` (`name`),
- 
 
 49 
  KEY `idx_signuptime` (`signuptime`)
- 
 
 50 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- 
 
 51
34 

            52