CREATE TABLE pkg (
  pkg_id int primary key NOT NULL default '0'
	brief text, 
	description text, 
	name varchar(50), 
	title varchar(250), 
	version varchar(20), 
	installer varchar(50), 
	category varchar(50), 
	complexity int, 
  license_id int,
	url varchar(250), 
);

CREATE TABLE dependencies (
  pkg_id int
);

CREATE TABLE licenses (
  license_id int primary key NOT NULL default '0',
  name varchar(50)
  url text 
);

CREATE TABLE examples (
  ex_id integer primary key NOT NULL default '0',
  pkg_id int,
  filename varchar(60) NOT NULL default '',
  thumb varchar(70) NOT NULL default '',
  description text NOT NULL default '',
  ex_type varchar(20) NOT NULL default ''
);

CREATE TABLE resources (
  resource_id integer primary key NOT NULL,
  pkg_id int NOT NULL default '',
  url varchar(250) NOT NULL default '',
  description text
);

#CREATE TABLE reading (
#  reading_id integer primary key NOT NULL,
#  title varchar(100) NOT NULL default '',
#  filename varchar(50) NOT NULL default ''
#);


#CREATE TABLE static (
#  static_id integer primary key NOT NULL,
#  pagename varchar(50) NOT NULL default '',
#  title varchar(255) NOT NULL default '',
#  include varchar(50) NOT NULL default '',
#  template_type varchar(50)
#);