root/dbauthplugin/0.10/install/create-tables-mysql-5.0.sql

Revision 838, 0.6 kB (checked in by brad, 3 years ago)

DbAuthPlugin:

DbAuthPlugin upgrade to 0.10, added CentralDatabaseManager? for connections other than SQLite, and trac.ini options to fit to disparate db schemas

Line 
1 CREATE TABLE `trac_cookies` (
2   `envname` varchar(40) NOT NULL,
3   `cookie` varchar(40) NOT NULL,
4   `username` varchar(40) NOT NULL,
5   `ipnr` varchar(15) NOT NULL,
6   `unixtime` int(11) NOT NULL
7 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
8 CREATE TABLE `trac_permissions` (
9   `envname` varchar(40) NOT NULL,
10   `username` varchar(40) NOT NULL,
11   `groupname` varchar(40) NOT NULL
12 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
13 CREATE TABLE `trac_users` (
14   `envname` varchar(40) NOT NULL,
15   `username` varchar(40) NOT NULL,
16   `password` varchar(40) NOT NULL,
17   `email` varchar(100) default NULL,
18   UNIQUE KEY `envname` (`envname`,`username`)
19 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Note: See TracBrowser for help on using the browser.