Diff of /alx-src/branches/alx-web-050/sql/alx_web.sql

Parent Directory | Revision Log | Patch

	revision 1606 by niro, Thu Dec 2 21:43:17 2010 UTC	revision 1607 by niro, Thu Dec 2 21:46:31 2010 UTC
#	Line 37  CREATE TABLE IF NOT EXISTS `cfg_comments	Line 37  CREATE TABLE IF NOT EXISTS `cfg_comments
37	`serial` int(11) NOT NULL default '0',	`serial` int(11) NOT NULL default '0',
38	`txt` text NOT NULL,	`txt` text NOT NULL,
39	PRIMARY KEY  (`id`)	PRIMARY KEY  (`id`)
40	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
41
42	-- --------------------------------------------------------	-- --------------------------------------------------------
43
#	Line 84  CREATE TABLE IF NOT EXISTS `cfg_modules`	Line 84  CREATE TABLE IF NOT EXISTS `cfg_modules`
84	PRIMARY KEY  (`id`),	PRIMARY KEY  (`id`),
85	KEY `module` (`module`),	KEY `module` (`module`),
86	KEY `serial` (`serial`)	KEY `serial` (`serial`)
87	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ;	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
88
89	-- --------------------------------------------------------	-- --------------------------------------------------------
90
#	Line 146  CREATE TABLE IF NOT EXISTS `cfg_other_me	Line 146  CREATE TABLE IF NOT EXISTS `cfg_other_me
146	KEY `exec` (`exec`),	KEY `exec` (`exec`),
147	KEY `workdir` (`workdir`),	KEY `workdir` (`workdir`),
148	KEY `icon` (`icon`)	KEY `icon` (`icon`)
149	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
150
151	-- --------------------------------------------------------	-- --------------------------------------------------------
152
#	Line 162  CREATE TABLE IF NOT EXISTS `cfg_printers	Line 162  CREATE TABLE IF NOT EXISTS `cfg_printers
162	`ip` varchar(100) default NULL,	`ip` varchar(100) default NULL,
163	`share` varchar(100) default NULL,	`share` varchar(100) default NULL,
164	PRIMARY KEY  (`id`)	PRIMARY KEY  (`id`)
165	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=434 ;	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
166
167	-- --------------------------------------------------------	-- --------------------------------------------------------
168
#	Line 194  CREATE TABLE IF NOT EXISTS `cfg_sessions	Line 194  CREATE TABLE IF NOT EXISTS `cfg_sessions
194	`browseradrs` varchar(100) NOT NULL default '',	`browseradrs` varchar(100) NOT NULL default '',
195	`flg_modified` tinyint(1) NOT NULL default '0',	`flg_modified` tinyint(1) NOT NULL default '0',
196	PRIMARY KEY  (`id`)	PRIMARY KEY  (`id`)
197	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=441 ;	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
198
199	-- --------------------------------------------------------	-- --------------------------------------------------------
200
#	Line 278  CREATE TABLE IF NOT EXISTS `list_monitor	Line 278  CREATE TABLE IF NOT EXISTS `list_monitor
278	PRIMARY KEY  (`id`),	PRIMARY KEY  (`id`),
279	KEY `vendor` (`vendor`),	KEY `vendor` (`vendor`),
280	KEY `model` (`model`)	KEY `model` (`model`)
281	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1809 ;	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
282
283	-- --------------------------------------------------------	-- --------------------------------------------------------
284
#	Line 301  CREATE TABLE IF NOT EXISTS `ssh_auth_ser	Line 301  CREATE TABLE IF NOT EXISTS `ssh_auth_ser
301	`id` int(11) NOT NULL auto_increment,	`id` int(11) NOT NULL auto_increment,
302	`public_key` text NOT NULL,	`public_key` text NOT NULL,
303	PRIMARY KEY  (`id`)	PRIMARY KEY  (`id`)
304	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
305
306	-- --------------------------------------------------------	-- --------------------------------------------------------
307
#	Line 323  CREATE TABLE IF NOT EXISTS `state_connec	Line 323  CREATE TABLE IF NOT EXISTS `state_connec
323	KEY `ip` (`ip`),	KEY `ip` (`ip`),
324	KEY `mac` (`mac`),	KEY `mac` (`mac`),
325	KEY `state` (`state`)	KEY `state` (`state`)
326	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=54988 ;	) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

---

Colored Diff Long Colored Diff Full Colored Diff Unidiff Context Diff Side by Side

Legend: Removed from v.1606   changed lines   Added in v.1607