database economia-solidale

Page history last edited by Antonio Balderi 16 years, 5 months ago

Il database dell'attuale sito e' di tipo relazionale e realizzato con MySQL ed e' ricostruibile con i comandi SQL seguenti :

-- Database: `Sql103973_1`

-- --------------------------------------------------------

-- Struttura della tabella `rg_admins`

CREATE TABLE IF NOT EXISTS `rg_admins` (

`userid` int(11) unsigned NOT NULL default '0',

`authlevel` tinyint(1) unsigned NOT NULL default '0',

PRIMARY KEY (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti
userid	int(11)	Sì	0
authlevel	tinyint(1)	Sì	0	codifica 1

-- Struttura della tabella `rg_adverts`

CREATE TABLE IF NOT EXISTS `rg_adverts` (

`advertid` int(11) unsigned NOT NULL auto_increment,

`userid` int(11) unsigned NOT NULL default '0',

`type` tinyint(3) unsigned NOT NULL default '0',

`title` varchar(128) NOT NULL,

`msg` mediumtext NOT NULL,

`date` timestamp NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY (`advertid`),

KEY `type` (`type`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=99 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_banners`

CREATE TABLE IF NOT EXISTS `rg_banners` (

`userid` int(12) unsigned NOT NULL default '0',

`impressions` int(12) unsigned NOT NULL default '0',

PRIMARY KEY (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_calendar`

CREATE TABLE IF NOT EXISTS `rg_calendar` (

`gasid` smallint(5) unsigned NOT NULL default '0',

`date` date NOT NULL,

`time` time NOT NULL,

`producerid` smallint(5) unsigned NOT NULL default '0',

`referralid` int(11) unsigned NOT NULL default '0',

`text` mediumtext NOT NULL,

`auto` tinyint(3) unsigned NOT NULL default '1',

KEY `gasid` (`gasid`),

KEY `date` (`date`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_carsharing`

CREATE TABLE IF NOT EXISTS `rg_carsharing` (

`userid` int(11) unsigned NOT NULL default '0',

`weekdays` tinyint(3) unsigned NOT NULL default '0',

`date` date NOT NULL default '0000-00-00',

`starttime` time NOT NULL default '00:00:00',

`arrivaltime` time NOT NULL default '00:00:00',

`startaddress` varchar(64) NOT NULL,

`starttown` varchar(64) NOT NULL,

`startprov` varchar(31) NOT NULL,

`arrivaladdress` varchar(64) NOT NULL,

`arrivaltown` varchar(64) NOT NULL,

`arrivalprov` varchar(31) NOT NULL,

`num_seats` tinyint(1) unsigned NOT NULL default '1',

`desc` tinytext NOT NULL,

KEY `userid` (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_cashier`

CREATE TABLE IF NOT EXISTS `rg_cashier` (

`userid` int(11) unsigned NOT NULL default '0',

`authlevel` tinyint(1) unsigned NOT NULL default '0',

PRIMARY KEY (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_connections`

CREATE TABLE IF NOT EXISTS `rg_connections` (

`ip` int(11) NOT NULL default '0',

`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

PRIMARY KEY (`ip`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_control`

CREATE TABLE IF NOT EXISTS `rg_control` (

`status` tinyint(3) unsigned NOT NULL default '1',

`num_access` int(8) unsigned NOT NULL default '0',

PRIMARY KEY (`status`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti
status	tinyint(3)	Sì	1	codifica 2
num_access	int(8)	Sì	0

-- Struttura della tabella `rg_deposithistory`

CREATE TABLE IF NOT EXISTS `rg_deposithistory` (

`deposit_id` int(11) unsigned NOT NULL auto_increment,

`gasid` smallint(5) unsigned NOT NULL default '0',

`userid` int(11) unsigned NOT NULL default '0',

`deposit` float NOT NULL default '0',

`date` timestamp NOT NULL default CURRENT_TIMESTAMP,

PRIMARY KEY (`deposit_id`),

KEY `userid` (`userid`),

KEY `date` (`date`),

KEY `gasid` (`gasid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_factory_bank`

CREATE TABLE IF NOT EXISTS `rg_factory_bank` (

`producerid` smallint(5) unsigned NOT NULL default '0',

`iban` varchar(27) NOT NULL,

`currentist` varchar(64) NOT NULL,

UNIQUE KEY `producerid` (`producerid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_factory_gas_msg`

CREATE TABLE IF NOT EXISTS `rg_factory_gas_msg` (

`producerid` smallint(5) unsigned NOT NULL default '0',

`title` varchar(64) NOT NULL,

`msg` mediumtext NOT NULL,

`date` timestamp NOT NULL default CURRENT_TIMESTAMP,

PRIMARY KEY (`producerid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_gas`

CREATE TABLE IF NOT EXISTS `rg_gas` (

`gasid` smallint(5) unsigned NOT NULL auto_increment,

`gas_email` varchar(128) NOT NULL,

`gasname` varchar(32) NOT NULL default '',

`authlevel` tinyint(1) unsigned NOT NULL default '0',

`numusers` smallint(5) unsigned NOT NULL default '0',

`prov` varchar(31) NOT NULL,

`gas_session` tinyint(3) NOT NULL default '0',

`startdate` timestamp NOT NULL default '0000-00-00 00:00:00',

`flags` tinyint(3) unsigned NOT NULL default '0',

PRIMARY KEY (`gasid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=312 ;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti
gasid	smallint(5)	Sì	NULL	codifica 3
gas_email	varchar(128)	Sì	NULL
gasname	varchar(32)	Sì
authlevel	tinyint(1)	Sì	0	codifica 4
numusers	smallint(5)	Sì	0
prov	varchar(31)	Sì	NULL
gas_session	tinyint(3)	Sì	0
startdate	timestamp	Sì	0000-00-00 00:00:00
flags	tinyint(3)	Sì	0	codifica 5

forse occorre rivedere la scelta del codice gasid numerico nascosto e pensare ad un varchar(8) che sintetizzi il nome e sia in chiaro nella registrazione iniziale.

-- Struttura della tabella `rg_history`

CREATE TABLE IF NOT EXISTS `rg_history` (

`historyid` int(11) unsigned NOT NULL auto_increment,

`userid` int(11) unsigned NOT NULL default '0',

`gasid` smallint(5) unsigned NOT NULL default '0',

`producerid` smallint(5) unsigned NOT NULL default '0',

`first_referralid` int(11) unsigned NOT NULL default '0',

`referralid` int(11) unsigned NOT NULL default '0',

`referral_shopid` int(11) unsigned NOT NULL default '0',

`price` float NOT NULL default '0',

`additional_price` float NOT NULL default '0',

`date` date NOT NULL,

PRIMARY KEY (`historyid`),

KEY `gasid` (`gasid`),

KEY `date` (`date`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=70701 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_homenews`

CREATE TABLE IF NOT EXISTS `rg_homenews` (

`id` smallint(5) unsigned NOT NULL auto_increment,

`title` varchar(64) NOT NULL,

`subtitle` tinytext NOT NULL,

`msg` mediumtext NOT NULL,

`userid` int(11) unsigned NOT NULL default '0',

`date` timestamp NOT NULL default '0000-00-00 00:00:00',

`auth` tinyint(1) unsigned NOT NULL default '0',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_invalid_email`

CREATE TABLE IF NOT EXISTS `rg_invalid_email` (

`email` varchar(128) NOT NULL,

PRIMARY KEY (`email`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_logistic_group`

CREATE TABLE IF NOT EXISTS `rg_logistic_group` (

`userid` int(11) unsigned NOT NULL default '0',

`authlevel` tinyint(1) unsigned NOT NULL default '0',

PRIMARY KEY (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_news`

CREATE TABLE IF NOT EXISTS `rg_news` (

`newsid` smallint(5) unsigned NOT NULL auto_increment,

`userid` int(11) unsigned NOT NULL default '0',

`gasid` smallint(5) unsigned NOT NULL default '0',

`title` varchar(64) NOT NULL,

`msg` text NOT NULL,

`date` timestamp NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY (`newsid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=116 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_new_gas_entry`

CREATE TABLE IF NOT EXISTS `rg_new_gas_entry` (

`userid` int(11) unsigned NOT NULL default '0',

`entrydate` timestamp NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_ordermsg`

CREATE TABLE IF NOT EXISTS `rg_ordermsg` (

`gasid` smallint(5) unsigned NOT NULL default '1',

`userid` int(11) unsigned NOT NULL default '0',

`producerid` smallint(5) unsigned NOT NULL default '0',

`msg` tinytext NOT NULL,

KEY `gasid` (`gasid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_orders`

CREATE TABLE IF NOT EXISTS `rg_orders` (

`gasid` smallint(5) unsigned NOT NULL default '0',

`userid` int(11) unsigned NOT NULL default '0',

`productid` int(11) unsigned NOT NULL default '0',

`producerid` smallint(5) unsigned NOT NULL default '0',

`num` float NOT NULL default '0',

`save_num` smallint(5) unsigned NOT NULL default '0',

`referralid` int(11) unsigned NOT NULL default '0',

`first_referralid` int(11) unsigned NOT NULL default '0',

`referral_shopid` int(11) unsigned NOT NULL default '0',

`date` date NOT NULL default '0000-00-00',

`status` tinyint(3) unsigned NOT NULL default '0',

`firstrefstatus` tinyint(3) unsigned NOT NULL default '0',

`refstatus` tinyint(3) unsigned NOT NULL default '0',

KEY `gasid` (`gasid`),

KEY `producerid` (`producerid`),

KEY `first_referralid` (`first_referralid`),

KEY `referral_shopid` (`referral_shopid`),

KEY `userid` (`userid`),

KEY `firstrefstatus` (`firstrefstatus`),

KEY `refstatus` (`refstatus`),

KEY `date` (`date`),

KEY `productid` (`productid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti
gasid	smallint(5)	Sì	0
userid	int(11)	Sì	0
productid	int(11)	Sì	0
producerid	smallint(5)	Sì	0
num	float	Sì	0
save_num	smallint(5)	Sì	0
referralid	int(11)	Sì	0
first_referralid	int(11)	Sì	0
referral_shopid	int(11)	Sì	0
date	date	Sì	0000-00-00
status	tinyint(3)	Sì	0
firstrefstatus	tinyint(3)	Sì	0
refstatus	tinyint(3)	Sì	0

-- Struttura della tabella `rg_pollres`

CREATE TABLE IF NOT EXISTS `rg_pollres` (

`userid` int(11) unsigned NOT NULL default '0',

`pollid` smallint(5) unsigned NOT NULL default '0',

`vote` tinyint(3) unsigned NOT NULL default '0',

KEY `pollid` (`pollid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_polls`

CREATE TABLE IF NOT EXISTS `rg_polls` (

`pollid` smallint(5) unsigned NOT NULL auto_increment,

`userid` int(11) unsigned NOT NULL default '0',

`gasid` smallint(5) unsigned NOT NULL default '0',

`title` tinytext NOT NULL,

`question` mediumtext NOT NULL,

`options` tinytext NOT NULL,

`startdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

`enddate` timestamp NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY (`pollid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_priority_msg`

CREATE TABLE IF NOT EXISTS `rg_priority_msg` (

`gasid` smallint(5) unsigned NOT NULL default '0',

`userid` int(11) unsigned NOT NULL default '0',

`msg` mediumtext NOT NULL,

PRIMARY KEY (`gasid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_priority_msg_read`

CREATE TABLE IF NOT EXISTS `rg_priority_msg_read` (

`gasid` smallint(5) unsigned NOT NULL default '0',

`userid` int(11) unsigned NOT NULL default '0',

KEY `gasid` (`gasid`),

KEY `userid` (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_producercomments`

CREATE TABLE IF NOT EXISTS `rg_producercomments` (

`commentid` int(11) unsigned NOT NULL auto_increment,

`producerid` smallint(5) unsigned NOT NULL default '0',

`userid` int(11) unsigned NOT NULL default '0',

`type` tinyint(1) unsigned NOT NULL default '0',

`comment` mediumtext NOT NULL,

`datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,

PRIMARY KEY (`commentid`),

KEY `producerid` (`producerid`,`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_producerhistory`

CREATE TABLE IF NOT EXISTS `rg_producerhistory` (

`producerid` smallint(5) unsigned NOT NULL default '0',

`gasid` smallint(5) unsigned NOT NULL default '0',

`productid` int(11) unsigned NOT NULL default '0',

`productname` varchar(128) NOT NULL,

`date` date NOT NULL,

`num` smallint(5) unsigned NOT NULL default '0',

KEY `producerid` (`producerid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_producerreplies`

CREATE TABLE IF NOT EXISTS `rg_producerreplies` (

`replyid` int(11) unsigned NOT NULL auto_increment,

`producerid` smallint(5) unsigned NOT NULL default '0',

`userid` int(11) unsigned NOT NULL default '0',

`commentid` int(11) unsigned NOT NULL default '0',

`reply` mediumtext NOT NULL,

`datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,

PRIMARY KEY (`replyid`),

KEY `producerid` (`producerid`,`commentid`),

KEY `commentid` (`commentid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_producers`

CREATE TABLE IF NOT EXISTS `rg_producers` (

`producerid` smallint(5) unsigned NOT NULL auto_increment,

`producername` varchar(48) NOT NULL,

`shortname` varchar(16) NOT NULL,

`email` varchar(128) NOT NULL default '',

`website` text NOT NULL,

`address` varchar(64) NOT NULL default '',

`cap` varchar(5) NOT NULL default '',

`town` varchar(64) NOT NULL default '',

`prov` varchar(31) NOT NULL,

`phone` varchar(12) NOT NULL default '',

`cell` varchar(12) NOT NULL,

`fax` varchar(12) NOT NULL default '',

`categories` tinytext NOT NULL,

`startdate` timestamp NOT NULL default '0000-00-00 00:00:00',

`options` tinytext NOT NULL,

`creator_id` int(11) unsigned NOT NULL default '0',

`indicative_prices` tinyint(3) unsigned NOT NULL default '0',

`certified` tinyint(3) unsigned NOT NULL default '0',

`certificate_type` varchar(64) NOT NULL,

PRIMARY KEY (`producerid`),

KEY `creator_id` (`creator_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=810 ;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti
producerid	smallint(5)	Sì	NULL
producername	varchar(48)	Sì	NULL
shortname	varchar(16)	Sì	NULL
email	varchar(128)	Sì
website	text	Sì	NULL
address	varchar(64)	Sì
cap	varchar(5)	Sì
town	varchar(64)	Sì
prov	varchar(31)	Sì	NULL
phone	varchar(12)	Sì
cell	varchar(12)	Sì	NULL
fax	varchar(12)	Sì
categories	tinytext	Sì	NULL
startdate	timestamp	Sì	0000-00-00 00:00:00
options	tinytext	Sì	NULL
creator_id	int(11)	Sì	0
indicative_prices	tinyint(3)	Sì	0
certified	tinyint(3)	Sì	0
certificate_type	varchar(64)	Sì	NULL

-- Struttura della tabella `rg_producer_evaluation`

CREATE TABLE IF NOT EXISTS `rg_producer_evaluation` (

`producerid` smallint(5) unsigned NOT NULL default '0',

`info` mediumtext NOT NULL,

`can_visit` tinytext NOT NULL,

`structures` tinytext NOT NULL,

`management` tinytext NOT NULL,

`num_workers` varchar(64) NOT NULL,

`workers_agreement` varchar(64) NOT NULL,

`temporary_workers` varchar(64) NOT NULL,

`ingredients` varchar(64) NOT NULL,

`characteristic` tinytext NOT NULL,

`seasonal` tinytext NOT NULL,

`quantity_produced` varchar(64) NOT NULL,

`distribution` varchar(128) NOT NULL,

`sold_last_year` varchar(64) NOT NULL,

`history` mediumtext NOT NULL,

`principles` mediumtext NOT NULL,

KEY `producerid` (`producerid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_products`

CREATE TABLE IF NOT EXISTS `rg_products` (

`productid` int(11) unsigned NOT NULL auto_increment,

`tabindex` smallint(5) NOT NULL,

`producerid` smallint(5) unsigned NOT NULL default '0',

`productname` varchar(128) NOT NULL default '',

`desc` text NOT NULL,

`quantity` float unsigned NOT NULL default '1',

`unit` varchar(2) NOT NULL default 'Pz',

`price` float unsigned NOT NULL default '0',

`num_box` smallint(5) unsigned NOT NULL default '1',

`not_available` tinyint(1) unsigned NOT NULL default '0',

`num_available` smallint(5) unsigned NOT NULL default '10000',

`min_order` tinyint(3) unsigned NOT NULL default '1',

PRIMARY KEY (`productid`),

KEY `producerid` (`producerid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11271 ;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti

-- Struttura della tabella `rg_product_availability`

CREATE TABLE IF NOT EXISTS `rg_product_availability` (

`productid` int(11) unsigned NOT NULL default '0',

`referralid` int(11) unsigned NOT NULL default '0',

`not_available` tinyint(1) unsigned NOT NULL default '0',

`additional_price` float NOT NULL default '0',

KEY `productid` (`productid`,`referralid`),

KEY `referralid` (`referralid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_quality_evaluation`

CREATE TABLE IF NOT EXISTS `rg_quality_evaluation` (

`gasid` smallint(5) unsigned NOT NULL default '0',

`producerid` smallint(5) unsigned NOT NULL default '0',

`quality_vote` tinytext NOT NULL,

`quality_note` tinytext NOT NULL,

`objective_vote` tinytext NOT NULL,

`objective_note` tinytext NOT NULL,

`bio_vote` tinytext NOT NULL,

`bio_note` tinytext NOT NULL,

`employment_vote` tinytext NOT NULL,

`employment_note` tinytext NOT NULL,

`dimension_vote` tinytext NOT NULL,

`dimension_note` tinytext NOT NULL,

`distance_vote` tinytext NOT NULL,

`distance_note` tinytext NOT NULL,

`price_vote` tinytext NOT NULL,

`price_note` tinytext NOT NULL,

`packaging_vote` tinytext NOT NULL,

`packaging_note` tinytext NOT NULL,

`overall_vote` tinyint(1) unsigned NOT NULL default '0',

KEY `producerid` (`producerid`),

KEY `gasid` (`gasid`),

KEY `overall_vote` (`overall_vote`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_quality_group`

CREATE TABLE IF NOT EXISTS `rg_quality_group` (

`userid` int(11) unsigned NOT NULL default '0',

`authlevel` tinyint(3) unsigned NOT NULL default '0',

PRIMARY KEY (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_referrals`

CREATE TABLE IF NOT EXISTS `rg_referrals` (

`userid` int(11) unsigned NOT NULL default '0',

`referral_authlevel` tinyint(1) unsigned NOT NULL default '2',

`referral_producerid` smallint(5) unsigned NOT NULL default '0',

`referral_firstreferralid` int(11) unsigned NOT NULL default '0',

`referral_shopid` int(11) unsigned NOT NULL default '0',

`referral_ordersclosed` tinyint(3) unsigned NOT NULL default '0',

`referral_closeordersdate` datetime NOT NULL,

`referral_openordersdate` datetime NOT NULL,

`referral_closewday` tinyint(3) unsigned NOT NULL default '0',

`referral_openwday` tinyint(3) unsigned NOT NULL default '0',

`referral_deliverydate` datetime NOT NULL,

`referral_deliveryplace` tinytext NOT NULL,

`referral_deliveryplacedesc` tinytext NOT NULL,

`referral_deliverywday` tinyint(3) unsigned NOT NULL default '0',

`referral_orderscadence` tinyint(3) unsigned NOT NULL default '1',

`referral_flags` tinyint(3) unsigned NOT NULL default '0',

`referral_subgroupid` tinyint(3) unsigned NOT NULL default '0',

`referral_msg` mediumtext NOT NULL,

`categories` tinytext NOT NULL,

`referral_minorder` float NOT NULL default '0',

`gainperc` float NOT NULL default '0',

PRIMARY KEY (`userid`),

KEY `referral_producerid` (`referral_producerid`),

KEY `referral_shopid` (`referral_shopid`),

KEY `referral_deliverydate` (`referral_deliverydate`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti

-- Struttura della tabella `rg_shopjobs`

CREATE TABLE IF NOT EXISTS `rg_shopjobs` (

`jobid` tinyint(3) unsigned NOT NULL auto_increment,

`jobname` varchar(128) NOT NULL,

PRIMARY KEY (`jobid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_shop_voluntary`

CREATE TABLE IF NOT EXISTS `rg_shop_voluntary` (

`gasid` smallint(5) unsigned NOT NULL default '0',

`shopid` int(11) unsigned NOT NULL default '0',

`userid` int(11) unsigned NOT NULL default '0',

`date` timestamp NOT NULL default '0000-00-00 00:00:00',

`num_hours` float NOT NULL default '0',

`jobid` tinyint(3) unsigned NOT NULL default '0',

KEY `gasid` (`gasid`),

KEY `shopid` (`shopid`),

KEY `userid` (`userid`),

KEY `date` (`date`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_subgroups`

CREATE TABLE IF NOT EXISTS `rg_subgroups` (

`subgroupid` tinyint(3) unsigned NOT NULL default '0',

`gasid` smallint(5) unsigned NOT NULL default '0',

`subgroupname` varchar(64) NOT NULL,

KEY `gasid` (`gasid`),

KEY `subgroupid` (`subgroupid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_tempgroups`

CREATE TABLE IF NOT EXISTS `rg_tempgroups` (

`tempgroupid` int(11) unsigned NOT NULL auto_increment,

`userid` int(11) unsigned NOT NULL default '0',

`title` varchar(128) NOT NULL,

`desc` mediumtext NOT NULL,

`date` date NOT NULL default '0000-00-00',

PRIMARY KEY (`tempgroupid`),

KEY `userid` (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

-- Struttura della tabella `rg_tempgroupsusers`

CREATE TABLE IF NOT EXISTS `rg_tempgroupsusers` (

`tempgroupid` int(11) unsigned NOT NULL default '0',

`userid` int(11) unsigned NOT NULL default '0',

KEY `tempgroupid` (`tempgroupid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_timebank`

CREATE TABLE IF NOT EXISTS `rg_timebank` (

`userid` int(11) unsigned NOT NULL default '0',

`service` mediumtext NOT NULL,

`amount` smallint(5) NOT NULL default '5',

`given` smallint(5) NOT NULL default '0',

`got` smallint(5) NOT NULL default '0',

`onlymygas` tinyint(3) unsigned NOT NULL default '0',

PRIMARY KEY (`userid`),

KEY `onlymygas` (`onlymygas`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_towns`

CREATE TABLE IF NOT EXISTS `rg_towns` (

`townid` smallint(5) unsigned NOT NULL auto_increment,

`town` varchar(64) NOT NULL,

PRIMARY KEY (`townid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=751 ;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti
townid

-- Struttura della tabella `rg_travels`

CREATE TABLE IF NOT EXISTS `rg_travels` (

`userid` int(11) unsigned NOT NULL,

`service` mediumtext NOT NULL,

PRIMARY KEY (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Struttura della tabella `rg_users`

CREATE TABLE IF NOT EXISTS `rg_users` (

`userid` int(11) unsigned NOT NULL auto_increment,

`gasid` smallint(5) unsigned NOT NULL default '0',

`username` varchar(32) NOT NULL default '',

`password` varchar(32) NOT NULL default '',

`email` varchar(128) NOT NULL default '',

`name` varchar(64) NOT NULL default '',

`address` varchar(64) NOT NULL default '',

`cap` varchar(5) NOT NULL default '',

`townid` smallint(5) unsigned NOT NULL,

`prov` varchar(31) NOT NULL,

`phone` varchar(12) NOT NULL default '',

`cell` varchar(12) NOT NULL default '',

`authlevel` tinyint(3) unsigned NOT NULL default '0',

`regdate` timestamp NOT NULL default CURRENT_TIMESTAMP,

`logindate` timestamp NOT NULL default '0000-00-00 00:00:00',

`joingasdate` timestamp NOT NULL default '0000-00-00 00:00:00',

`assocgasdate` timestamp NOT NULL default '0000-00-00 00:00:00',

`last_click_time` timestamp NOT NULL default '0000-00-00 00:00:00',

`ip` int(11) NOT NULL default '0',

`job` varchar(64) NOT NULL,

`desc` mediumtext NOT NULL,

`flags` mediumint(8) unsigned NOT NULL default '0',

`factory_producerid` varchar(64) NOT NULL default '0',

`factory_authlevel` tinyint(3) unsigned NOT NULL default '0',

`factory_flags` tinyint(3) unsigned NOT NULL default '0',

`subgroupid` smallint(5) unsigned NOT NULL default '1',

`shop_authlevel` tinyint(3) unsigned NOT NULL default '0',

`referrals` varchar(128) NOT NULL,

`delegation_id` int(11) unsigned NOT NULL default '0',

`orderid` smallint(5) unsigned NOT NULL default '0',

`deposit` float NOT NULL default '0',

PRIMARY KEY (`userid`),

KEY `factory_producerid` (`factory_producerid`),

KEY `gasid` (`gasid`),

KEY `factory_authlevel` (`factory_authlevel`),

KEY `name` (`name`),

KEY `townid` (`townid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5849 ;

-- --------------------------------------------------------

Campo	Tipo	Null	Predefinito	Commenti
userid	int(11)	Yes	NULL
gasid	smallint(5)	Yes	0
username	varchar(32)	Yes
password	varchar(32)	Yes
email	varchar(128)	Yes
name	varchar(64)	Yes
address	varchar(64)	Yes
cap	varchar(5)	Yes
townid	smallint(5)	Yes
prov	varchar(31)	Yes
phone	varchar(12)	Yes
cell	varchar(12)	Yes
authlevel	tinyint(3)	Yes	0	Codifica 6
regdate	timestamp	Yes	CURRENT_TIMESTAMP
logindate	timestamp	Yes	0000-00-00 00:00:00
joingasdate	timestamp	Yes	0000-00-00 00:00:00
assocgasdate	timestamp	Yes	0000-00-00 00:00:00
last_click_time	timestamp	Yes	0000-00-00 00:00:00
ip	int(11)	Yes	0
job	varchar(64)	Yes
desc	mediumtext	Yes
flags	mediumint(8)	Yes	0	Codifica 7
factory_producerid	varchar(64)	Yes	0
factory_authlevel	tinyint(3)	Yes	0
factory_flags	tinyint(3)	Yes	0
subgroupid	smallint(5)	Yes	1
shop_authlevel	tinyint(3)	Yes	0	Codifica 8
referrals	varchar(128)	Yes
delegation_id	int(11)	Yes	0
orderid	smallint(5)	Yes	0
deposit	float	Yes	0