[drupal-devel] Critical error in use of timestamp!
Bèr Kessels
berdrupal at tiscali.be
Thu Mar 17 10:47:16 UTC 2005
Carl,
Just a quick thing: Could you please consider writing new mails instead of
replying to old ones. your replies break the threads. Yesterday you did the
same. Read more about mailinglist guidelines here:
http://lists.drupal.org/listinfo/drupal-devel
Bèr
Op donderdag 17 maart 2005 10:51, schreef Carl McDade:
> I just spent two days trying to find out why database backups are not
> running. It would seem that naming database columns with a reserved word
> is the problem. Timestamp is used as a column name in about 15 instances.
>
> Phpmyadmin and mySQL adminstrator both take the reserved word literally
> and execute errors when trying to name a column with time when running
> the script.
>
> This is a basic database knowledge thing. Never should programming
> language, database or columntypes reserved words be used as column names.
>
> This use is present in 4.5.2 and 4.6
>
> -- MySQL dump 8.22
> --
> -- Host: localhost Database: drupal_devel
> -- Server version 3.23.52-nt
>
> --
> -- Table structure for table 'access'
> --
>
> CREATE TABLE access (
> aid tinyint(10) NOT NULL auto_increment,
> mask varchar(255) NOT NULL default '',
> type varchar(255) NOT NULL default '',
> status tinyint(2) NOT NULL default '0',
> PRIMARY KEY (aid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'accesslog'
> --
>
> CREATE TABLE accesslog (
> aid int(10) NOT NULL auto_increment,
> title varchar(255) default NULL,
> path varchar(255) default NULL,
> url varchar(255) default NULL,
> hostname varchar(128) default NULL,
> uid int(10) unsigned default '0',
> timestamp int(11) unsigned NOT NULL default '0',
> KEY accesslog_timestamp (timestamp),
> PRIMARY KEY (aid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'aggregator_category'
> --
>
> CREATE TABLE aggregator_category (
> cid int(10) NOT NULL auto_increment,
> title varchar(255) NOT NULL default '',
> description longtext NOT NULL,
> block tinyint(2) NOT NULL default '0',
> PRIMARY KEY (cid),
> UNIQUE KEY title (title)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'aggregator_category_feed'
> --
>
> CREATE TABLE aggregator_category_feed (
> fid int(10) NOT NULL default '0',
> cid int(10) NOT NULL default '0',
> PRIMARY KEY (fid,cid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'aggregator_category_item'
> --
>
> CREATE TABLE aggregator_category_item (
> iid int(10) NOT NULL default '0',
> cid int(10) NOT NULL default '0',
> PRIMARY KEY (iid,cid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'aggregator_feed'
> --
>
> CREATE TABLE aggregator_feed (
> fid int(10) NOT NULL auto_increment,
> title varchar(255) NOT NULL default '',
> url varchar(255) NOT NULL default '',
> refresh int(10) NOT NULL default '0',
> checked int(10) NOT NULL default '0',
> link varchar(255) NOT NULL default '',
> description longtext NOT NULL,
> image longtext NOT NULL,
> etag varchar(255) NOT NULL default '',
> modified int(10) NOT NULL default '0',
> block tinyint(2) NOT NULL default '0',
> PRIMARY KEY (fid),
> UNIQUE KEY link (url),
> UNIQUE KEY title (title)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'aggregator_item'
> --
>
> CREATE TABLE aggregator_item (
> iid int(10) NOT NULL auto_increment,
> fid int(10) NOT NULL default '0',
> title varchar(255) NOT NULL default '',
> link varchar(255) NOT NULL default '',
> author varchar(255) NOT NULL default '',
> description longtext NOT NULL,
> timestamp int(11) default NULL,
> PRIMARY KEY (iid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'authmap'
> --
>
> CREATE TABLE authmap (
> aid int(10) unsigned NOT NULL auto_increment,
> uid int(10) NOT NULL default '0',
> authname varchar(128) NOT NULL default '',
> module varchar(128) NOT NULL default '',
> PRIMARY KEY (aid),
> UNIQUE KEY authname (authname)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'blocks'
> --
>
> CREATE TABLE blocks (
> module varchar(64) DEFAULT '' NOT NULL,
> delta varchar(32) NOT NULL default '0',
> status tinyint(2) DEFAULT '0' NOT NULL,
> weight tinyint(1) DEFAULT '0' NOT NULL,
> region tinyint(1) DEFAULT '0' NOT NULL,
> custom tinyint(2) DEFAULT '0' NOT NULL,
> throttle tinyint(1) DEFAULT '0' NOT NULL,
> visibility tinyint(1) DEFAULT '0' NOT NULL,
> pages text NOT NULL,
> types text NOT NULL
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'book'
> --
>
> CREATE TABLE book (
> nid int(10) unsigned NOT NULL default '0',
> parent int(10) NOT NULL default '0',
> weight tinyint(3) NOT NULL default '0',
> log longtext,
> PRIMARY KEY (nid),
> KEY parent (parent)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'boxes'
> --
>
> CREATE TABLE boxes (
> bid tinyint(4) NOT NULL auto_increment,
> title varchar(64) NOT NULL default '',
> body longtext,
> info varchar(128) NOT NULL default '',
> format int(4) NOT NULL default '0',
> PRIMARY KEY (bid),
> UNIQUE KEY title (title),
> UNIQUE KEY info (info)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'cache'
> --
>
> CREATE TABLE cache (
> cid varchar(255) NOT NULL default '',
> data longtext,
> expire int(11) NOT NULL default '0',
> created int(11) NOT NULL default '0',
> headers text,
> PRIMARY KEY (cid),
> INDEX expire (expire)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'comments'
> --
>
> CREATE TABLE comments (
> cid int(10) NOT NULL auto_increment,
> pid int(10) NOT NULL default '0',
> nid int(10) NOT NULL default '0',
> uid int(10) NOT NULL default '0',
> subject varchar(64) NOT NULL default '',
> comment longtext NOT NULL,
> hostname varchar(128) NOT NULL default '',
> timestamp int(11) NOT NULL default '0',
> score mediumint(9) NOT NULL default '0',
> status tinyint(3) unsigned NOT NULL default '0',
> format int(4) NOT NULL default '0',
> thread varchar(255) NOT NULL,
> users longtext,
> name varchar(60) default NULL,
> mail varchar(64) default NULL,
> homepage varchar(255) default NULL,
> PRIMARY KEY (cid),
> KEY lid (nid)
> ) TYPE=MyISAM;
>
> --
> -- Table structre for table 'node_last_comment'
> --
>
> CREATE TABLE node_comment_statistics (
> nid int(10) unsigned NOT NULL auto_increment,
> last_comment_timestamp int(11) NOT NULL default '0',
> last_comment_name varchar(60) default NULL,
> last_comment_uid int(10) NOT NULL default '0',
> comment_count int(10) unsigned NOT NULL default '0',
> PRIMARY KEY (nid),
> KEY node_comment_timestamp (last_comment_timestamp)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'directory'
> --
>
> CREATE TABLE directory (
> link varchar(255) NOT NULL default '',
> name varchar(128) NOT NULL default '',
> mail varchar(128) NOT NULL default '',
> slogan longtext NOT NULL,
> mission longtext NOT NULL,
> timestamp int(11) NOT NULL default '0',
> PRIMARY KEY (link)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'files'
> --
>
> CREATE TABLE files (
> fid int(10) unsigned NOT NULL default '0',
> nid int(10) unsigned NOT NULL default '0',
> filename varchar(255) NOT NULL default '',
> filepath varchar(255) NOT NULL default '',
> filemime varchar(255) NOT NULL default '',
> filesize int(10) unsigned NOT NULL default '0',
> list tinyint(1) unsigned NOT NULL default '0',
> PRIMARY KEY (fid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'filter_formats'
> --
>
> CREATE TABLE filter_formats (
> format int(4) NOT NULL auto_increment,
> name varchar(255) NOT NULL default '',
> roles varchar(255) NOT NULL default '',
> cache tinyint(2) NOT NULL default '0',
> PRIMARY KEY format (format)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'filters'
> --
>
> CREATE TABLE filters (
> format int(4) NOT NULL default '0',
> module varchar(64) NOT NULL default '',
> delta tinyint(2) DEFAULT '0' NOT NULL,
> weight tinyint(2) DEFAULT '0' NOT NULL,
> INDEX (weight)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'flood'
> --
>
> CREATE TABLE flood (
> event varchar(64) NOT NULL default '',
> hostname varchar(128) NOT NULL default '',
> timestamp int(11) NOT NULL default '0'
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'forum'
> --
>
> CREATE TABLE forum (
> nid int(10) unsigned NOT NULL default '0',
> tid int(10) unsigned NOT NULL default '0',
> PRIMARY KEY (nid),
> KEY tid (tid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'history'
> --
>
> CREATE TABLE history (
> uid int(10) NOT NULL default '0',
> nid int(10) NOT NULL default '0',
> timestamp int(11) NOT NULL default '0',
> PRIMARY KEY (uid,nid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'locales_meta'
> --
>
> CREATE TABLE locales_meta (
> locale varchar(12) NOT NULL default '',
> name varchar(64) NOT NULL default '',
> enabled int(2) NOT NULL default '0',
> isdefault int(2) NOT NULL default '0',
> plurals int(1) NOT NULL default '0',
> formula varchar(128) NOT NULL default '',
> PRIMARY KEY (locale)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'locales_source'
> --
>
> CREATE TABLE locales_source (
> lid int(11) NOT NULL auto_increment,
> location varchar(128) NOT NULL default '',
> source blob NOT NULL,
> PRIMARY KEY (lid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'locales_target'
> --
>
> CREATE TABLE locales_target (
> lid int(11) NOT NULL default '0',
> translation blob NOT NULL,
> locale varchar(12) NOT NULL default '',
> plid int(11) NOT NULL default '0',
> plural int(1) NOT NULL default '0',
> KEY lid (lid),
> KEY lang (locale),
> KEY plid (plid),
> KEY plural (plural)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'menu'
> --
>
> CREATE TABLE menu (
> mid int(10) unsigned NOT NULL default '0',
> pid int(10) unsigned NOT NULL default '0',
> path varchar(255) NOT NULL default '',
> title varchar(255) NOT NULL default '',
> description varchar(255) NOT NULL default '',
> weight tinyint(4) NOT NULL default '0',
> type int(2) unsigned NOT NULL default '0',
> PRIMARY KEY (mid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'moderation_filters'
> --
>
> CREATE TABLE moderation_filters (
> fid int(10) unsigned NOT NULL auto_increment,
> filter varchar(255) NOT NULL default '',
> minimum smallint(6) NOT NULL default '0',
> PRIMARY KEY (fid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'moderation_roles'
> --
>
> CREATE TABLE moderation_roles (
> rid int(10) unsigned NOT NULL default '0',
> mid int(10) unsigned NOT NULL default '0',
> value tinyint(4) NOT NULL default '0',
> KEY idx_rid (rid),
> KEY idx_mid (mid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'moderation_votes'
> --
>
> CREATE TABLE moderation_votes (
> mid int(10) unsigned NOT NULL auto_increment,
> vote varchar(255) default NULL,
> weight tinyint(4) NOT NULL default '0',
> PRIMARY KEY (mid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'node'
> --
>
> CREATE TABLE node (
> nid int(10) unsigned NOT NULL auto_increment,
> type varchar(16) NOT NULL default '',
> title varchar(128) NOT NULL default '',
> uid int(10) NOT NULL default '0',
> status int(4) NOT NULL default '1',
> created int(11) NOT NULL default '0',
> changed int(11) NOT NULL default '0',
> comment int(2) NOT NULL default '0',
> promote int(2) NOT NULL default '0',
> moderate int(2) NOT NULL default '0',
> teaser longtext NOT NULL,
> body longtext NOT NULL,
> revisions longtext NOT NULL,
> sticky int(2) NOT NULL default '0',
> format int(4) NOT NULL default '0',
> PRIMARY KEY (nid),
> KEY node_type (type(4)),
> KEY node_title_type (title,type(4)),
> KEY status (status),
> KEY uid (uid),
> KEY node_moderate (moderate),
> KEY node_promote_status (promote, status),
> KEY node_created (created),
> KEY node_changed (changed),
> KEY node_status_type (status, type, nid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table `node_access`
> --
>
> CREATE TABLE node_access (
> nid int(10) unsigned NOT NULL default '0',
> gid int(10) unsigned NOT NULL default '0',
> realm varchar(255) NOT NULL default '',
> grant_view tinyint(1) unsigned NOT NULL default '0',
> grant_update tinyint(1) unsigned NOT NULL default '0',
> grant_delete tinyint(1) unsigned NOT NULL default '0',
> PRIMARY KEY (nid,gid,realm)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'profile_fields'
> --
>
> CREATE TABLE profile_fields (
> fid int(10) NOT NULL auto_increment,
> title varchar(255) default NULL,
> name varchar(128) default NULL,
> explanation TEXT default NULL,
> category varchar(255) default NULL,
> page varchar(255) default NULL,
> type varchar(128) default NULL,
> weight tinyint(1) DEFAULT '0' NOT NULL,
> required tinyint(1) DEFAULT '0' NOT NULL,
> register tinyint(1) DEFAULT '0' NOT NULL,
> visibility tinyint(1) DEFAULT '0' NOT NULL,
> options text,
> KEY category (category),
> UNIQUE KEY name (name),
> PRIMARY KEY (fid)
> );
>
> --
> -- Table structure for table 'profile_values'
> --
>
> CREATE TABLE profile_values (
> fid int(11) unsigned default '0',
> uid int(11) unsigned default '0',
> value text,
> KEY uid (uid),
> KEY fid (fid)
> );
>
>
> --
> -- Table structure for table 'url_alias'
> --
>
> CREATE TABLE url_alias (
> pid int(10) unsigned NOT NULL auto_increment,
> src varchar(128) NOT NULL default '',
> dst varchar(128) NOT NULL default '',
> PRIMARY KEY (pid),
> UNIQUE KEY dst (dst)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'permission'
> --
>
> CREATE TABLE permission (
> rid int(10) unsigned NOT NULL default '0',
> perm longtext,
> tid int(10) unsigned NOT NULL default '0',
> KEY rid (rid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'poll'
> --
>
> CREATE TABLE poll (
> nid int(10) unsigned NOT NULL default '0',
> runtime int(10) NOT NULL default '0',
> voters longtext NOT NULL,
> active int(2) unsigned NOT NULL default '0',
> PRIMARY KEY (nid)
> ) TYPE=MyISAM;
>
> --
> -- Table structure for table 'poll_choices'
>
> Carl McDade
Regards,
Bèr
--
[ Bèr Kessels | Drupal services www.webschuur.com ]
More information about the drupal-devel
mailing list