sql/00/adslight_2.3_migrate.yml
adslight_listing:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: lid
attributes: ' int(15) NOT NULL auto_increment'
-
name: cid
attributes: ' int(15) NOT NULL DEFAULT ''0'' '
-
name: title
attributes: ' varchar(100) NOT NULL DEFAULT '''' '
-
name: status
attributes: ' int(3) NOT NULL DEFAULT ''0'' '
-
name: expire
attributes: ' char(3) NOT NULL DEFAULT '''' '
-
name: type
attributes: ' varchar(15) NOT NULL DEFAULT '''' '
-
name: desctext
attributes: ' text NOT NULL '
-
name: tel
attributes: ' varchar(15) NOT NULL DEFAULT '''' '
-
name: price
attributes: ' decimal(20,2) NOT NULL DEFAULT ''0.00'' '
-
name: typeprice
attributes: ' varchar(15) NOT NULL DEFAULT '''' '
-
name: typeusure
attributes: ' varchar(15) NOT NULL DEFAULT '''' '
-
name: date
attributes: ' int(10) NOT NULL DEFAULT ''0'' '
-
name: email
attributes: ' varchar(100) NOT NULL DEFAULT '''' '
-
name: submitter
attributes: ' varchar(60) NOT NULL DEFAULT '''' '
-
name: usid
attributes: ' varchar(6) NOT NULL DEFAULT '''' '
-
name: town
attributes: ' varchar(200) NOT NULL DEFAULT '''' '
-
name: country
attributes: ' varchar(200) NOT NULL DEFAULT '''' '
-
name: contactby
attributes: ' varchar(50) NOT NULL DEFAULT '''' '
-
name: premium
attributes: ' char(3) NOT NULL DEFAULT '''' '
-
name: valid
attributes: ' varchar(11) NOT NULL DEFAULT '''' '
-
name: photo
attributes: ' varchar(100) NOT NULL DEFAULT ''0'' '
-
name: hits
attributes: ' int(11) NOT NULL DEFAULT ''0'' '
-
name: item_rating
attributes: ' double(6,4) NOT NULL DEFAULT ''0.0000'' '
-
name: item_votes
attributes: ' int(11) unsigned NOT NULL DEFAULT ''0'' '
-
name: user_rating
attributes: ' double(6,4) NOT NULL DEFAULT ''0.0000'' '
-
name: user_votes
attributes: ' int(11) unsigned NOT NULL DEFAULT ''0'' '
-
name: comments
attributes: ' int(11) unsigned NOT NULL DEFAULT ''0'' '
-
name: remind
attributes: ' int(11) NOT NULL DEFAULT ''0'' '
keys:
PRIMARY:
columns: lid
unique: true
adslight_categories:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: cid
attributes: ' int(11) NOT NULL auto_increment'
-
name: pid
attributes: ' int(5) unsigned NOT NULL DEFAULT ''0'' '
-
name: title
attributes: ' varchar(50) NOT NULL DEFAULT '''' '
-
name: cat_desc
attributes: ' varchar(200) NOT NULL DEFAULT '''' '
-
name: cat_keywords
attributes: ' varchar(1000) NOT NULL DEFAULT '''' '
-
name: img
attributes: ' varchar(150) NOT NULL DEFAULT ''default.png'' '
-
name: cat_order
attributes: ' int(5) NOT NULL DEFAULT ''0'' '
-
name: affprice
attributes: ' int(5) NOT NULL DEFAULT ''1'' '
-
name: cat_moderate
attributes: ' int(5) NOT NULL DEFAULT ''1'' '
-
name: moderate_subcat
attributes: ' int(5) NOT NULL DEFAULT ''1'' '
keys:
PRIMARY:
columns: cid
unique: true
adslight_type:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: id_type
attributes: ' int(11) NOT NULL auto_increment'
-
name: nom_type
attributes: ' varchar(150) NOT NULL DEFAULT '''' '
keys:
PRIMARY:
columns: id_type
unique: true
adslight_price:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: id_price
attributes: ' int(11) NOT NULL auto_increment'
-
name: nom_price
attributes: ' varchar(150) NOT NULL DEFAULT '''' '
keys:
PRIMARY:
columns: id_price
unique: true
adslight_usure:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: id_usure
attributes: ' int(11) NOT NULL auto_increment'
-
name: nom_usure
attributes: ' varchar(150) NOT NULL DEFAULT '''' '
keys:
PRIMARY:
columns: id_usure
unique: true
adslight_ip_log:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: ip_id
attributes: ' int(11) NOT NULL auto_increment'
-
name: lid
attributes: ' int(11) NOT NULL DEFAULT ''0'' '
-
name: date
attributes: ' varchar(25) '
-
name: submitter
attributes: ' varchar(60) NOT NULL DEFAULT '''' '
-
name: ipnumber
attributes: ' varchar(150) NOT NULL DEFAULT '''' '
-
name: email
attributes: ' varchar(100) NOT NULL DEFAULT '''' '
keys:
PRIMARY:
columns: ip_id
unique: true
adslight_item_votedata:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: ratingid
attributes: ' int(11) unsigned NOT NULL auto_increment'
-
name: lid
attributes: ' int(11) unsigned NOT NULL DEFAULT ''0'' '
-
name: ratinguser
attributes: ' int(11) unsigned NOT NULL DEFAULT ''0'' '
-
name: rating
attributes: ' tinyint(3) unsigned NOT NULL DEFAULT ''0'' '
-
name: ratinghostname
attributes: ' varchar(60) NOT NULL DEFAULT '''' '
-
name: ratingtimestamp
attributes: ' int(10) NOT NULL DEFAULT ''0'' '
keys:
PRIMARY:
columns: ratingid
unique: true
ratinghostname:
columns: ratinghostname
unique: false
ratinguser:
columns: ratinguser
unique: false
adslight_user_votedata:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: ratingid
attributes: ' int(11) unsigned NOT NULL auto_increment'
-
name: usid
attributes: ' int(11) unsigned NOT NULL DEFAULT ''0'' '
-
name: ratinguser
attributes: ' int(11) unsigned NOT NULL DEFAULT ''0'' '
-
name: rating
attributes: ' tinyint(3) unsigned NOT NULL DEFAULT ''0'' '
-
name: ratinghostname
attributes: ' varchar(60) NOT NULL DEFAULT '''' '
-
name: ratingtimestamp
attributes: ' int(10) NOT NULL DEFAULT ''0'' '
keys:
PRIMARY:
columns: ratingid
unique: true
ratinghostname:
columns: ratinghostname
unique: false
ratinguser:
columns: ratinguser
unique: false
adslight_pictures:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: cod_img
attributes: ' int(11) NOT NULL auto_increment'
-
name: title
attributes: ' varchar(255) NOT NULL '
-
name: date_added
attributes: ' int(10) NOT NULL DEFAULT ''0'' '
-
name: date_modified
attributes: ' int(10) NOT NULL DEFAULT ''0'' '
-
name: lid
attributes: ' int(11) NOT NULL DEFAULT ''0'' '
-
name: uid_owner
attributes: ' varchar(50) NOT NULL '
-
name: url
attributes: ' text NOT NULL '
keys:
PRIMARY:
columns: cod_img
unique: true
adslight_replies:
options: 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
columns:
-
name: r_lid
attributes: ' int(11) NOT NULL auto_increment'
-
name: lid
attributes: ' int(11) NOT NULL DEFAULT ''0'' '
-
name: title
attributes: ' varchar(50) NOT NULL DEFAULT '''' '
-
name: date
attributes: ' int(10) NOT NULL DEFAULT ''0'' '
-
name: submitter
attributes: ' varchar(60) NOT NULL DEFAULT '''' '
-
name: message
attributes: ' text NOT NULL '
-
name: tele
attributes: ' varchar(15) NOT NULL DEFAULT '''' '
-
name: email
attributes: ' varchar(100) NOT NULL DEFAULT '''' '
-
name: r_usid
attributes: ' int(11) NOT NULL DEFAULT ''0'' '
keys:
PRIMARY:
columns: r_lid
unique: true