On Wednesday 31 October 2007 14:58, [EMAIL PROTECTED] wrote:
> Hi,
>
> What is/are the key(s) for the new Package table scheme you propose? I do not
> have access the SVN today, sorry.
In order to not need to change the other table definitions, "id" is kept
as primary key.
-- Packages
CREATE TABLE IF NOT EXISTS Packages(
id integer auto_increment not null unique primary key,
name VARCHAR(100), not null,
version VARCHAR(100) not null,
__class VARCHAR(100),
__group VARCHAR(100),
distro VARCHAR(32) not null,
summary VARCHAR(100),
repository VARCHAR(250),
license VARCHAR(100),
maintainer VARCHAR(100),
packager VARCHAR(250),
url VARCHAR(100),
vendor VARCHAR(100),
description text,
)TYPE=INNODB;
Regards,
Erich
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Oscar-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oscar-devel
