Forum Replies Created
-
AuthorPosts
-
mreaves53
MemberI do not know which install the IT guy used. I replaced 5.13 with 5.02 this a.m. and everything works fine. I can connect through the tunnel without any problem. I am clueless.
Thanks,
MemberThe server is running Windows Xp Pro Version 2002 Service Pack 2, Apache 2.0.55, php 5.1.1, and
MySQL 5.0.18.
What else would be helpful.
thanks,
MemberI am not sure what you mean by direct connect. I have SQLyog installed on the same machine as the MySQL server and I can connect by going to that machie.
Thanks,
MemberIt is when I am trying to connect. SQLyog works fine on the same machine with the MySQL server. SQLyog works to connect from the server to my individual workstation. When I try to connect from my work station to the machine with the MySQL server I get the error 73 required message. I can connect to the server using MySQL Broswer.
I am stumped.
Thanks,
MemberPHP version 5.1.1
MySQL version 5.0.18
SQLyog version 5.13
Error message No. 73 >required.
Thanks
MemberI am using SQLyog 5.02 and when I check the mode I get: STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Here is a copy of the sql.txt that Sqlyog created. I am using the export tool. The backup will not work because of the table type.
The error first starts in the master_projects table.
/*
SQLyog Enterprise – MySQL GUI v5.02
Host – 5.0.18-nt : Database – ttd
*********************************************************************
Server version : 5.0.18-nt
*/
/*Table structure for table `audit` */
CREATE TABLE `audit` (
`no` varchar(50) NOT NULL,
`trail` longtext,
`initial` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `costs` */
CREATE TABLE `costs` (
`level` varchar(5) NOT NULL,
`rate` int(2) default NULL,
PRIMARY KEY (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `costs_admin` */
CREATE TABLE `costs_admin` (
`level` varchar(5) default NULL,
`rate` varchar(5) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers` */
CREATE TABLE `developers` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers_admin` */
CREATE TABLE `developers_admin` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers_cood` */
CREATE TABLE `developers_cood` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers_copy` */
CREATE TABLE `developers_copy` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers_finance` */
CREATE TABLE `developers_finance` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers_it` */
CREATE TABLE `developers_it` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers_maint` */
CREATE TABLE `developers_maint` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers_mm` */
CREATE TABLE `developers_mm` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `developers_night` */
CREATE TABLE `developers_night` (
`no` varchar(15) default NULL,
`user` varchar(25) default NULL,
`hr` float default NULL,
`status` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `hma` */
CREATE TABLE `hma` (
`dept` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*Table structure for table `lincoln` */
CREATE TABLE `lincoln` (
`dept` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*Table structure for table `managers` */
CREATE TABLE `managers` (
`manager` varchar(50) default NULL,
`email` varchar(50) default NULL,
`dept` varchar(50) default NULL,
`user` varchar(50) default NULL,
`password` varchar(15) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `master_projects` */
CREATE TABLE `master_projects` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`phours` int(2) default '0',
`ahours` varchar(5) default '0',
`projstatus` char(1) default 'O',
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`owner` char(1) default NULL,
`development` char(1) default 'n',
`coordinators` char(1) default 'n',
`multimedia` char(1) default 'n',
`admin` char(1) default 'n',
`it` char(1) default 'n',
`maintance` char(1) default 'n',
`finance` char(1) default 'n',
`night` char(1) default 'n',
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`resume_dt` date default '1900-01-01',
`changelog` timestamp NULL default CURRENT_TIMESTAMP,
`acost` varchar(10) default NULL,
PRIMARY KEY (;
/*Table structure for table `master_projects_copy` */
CREATE TABLE `master_projects_copy` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`phours` int(2) default '0',
`ahours` varchar(5) default '0',
`projstatus` char(1) default 'O',
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`owner` char(1) default NULL,
`development` char(1) default 'n',
`coordinators` char(1) default 'n',
`multimedia` char(1) default 'n',
`admin` char(1) default 'n',
`it` char(1) default 'n',
`maintance` char(1) default 'n',
`finance` char(1) default 'n',
`night` char(1) default 'n',
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`resume_dt` date default '1900-01-01',
`changelog` timestamp NULL default NULL,
`acost` varchar(10) default NULL,
PRIMARY KEY (;
/*Table structure for table `montgomery` */
CREATE TABLE `montgomery` (
`dept` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*Table structure for table `printing` */
CREATE TABLE `printing` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`bw` varchar(10) default NULL,
`color` varchar(10) default NULL,
`bound` char(1) default NULL,
`outside` varchar(10) default NULL,
`dateworked` date default NULL,
`dateentered` date default NULL,
`tl` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `printing_admin` */
CREATE TABLE `printing_admin` (
`user` varchar(25) default NULL,
`no` varchar(50) default NULL,
`bw` decimal(8,2) default NULL,
`color` decimal(8,2) default NULL,
`bound` char(1) default NULL,
`outside` decimal(8,2) default NULL,
`dateworked` date default NULL,
`dateentered` date default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `printing_cood` */
CREATE TABLE `printing_cood` (
`user` varchar(25) default NULL,
`no` varchar(50) default NULL,
`bw` decimal(8,2) default NULL,
`color` decimal(8,2) default NULL,
`bound` char(1) default NULL,
`outside` decimal(8,2) default NULL,
`dateworked` date default NULL,
`dateentered` date default NULL,
`tl` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `printing_finance` */
CREATE TABLE `printing_finance` (
`user` varchar(25) default NULL,
`no` varchar(50) default NULL,
`bw` decimal(8,2) default NULL,
`color` decimal(8,2) default NULL,
`bound` char(1) default NULL,
`outside` decimal(8,2) default NULL,
`dateworked` date default NULL,
`dateentered` date default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `printing_it` */
CREATE TABLE `printing_it` (
`user` varchar(25) default NULL,
`no` varchar(50) default NULL,
`bw` decimal(8,2) default NULL,
`color` decimal(8,2) default NULL,
`bound` char(1) default NULL,
`outside` decimal(8,2) default NULL,
`dateworked` date default NULL,
`dateentered` date default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `printing_maint` */
CREATE TABLE `printing_maint` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`bw` varchar(10) default NULL,
`color` varchar(10) default NULL,
`bound` char(1) default NULL,
`outside` varchar(10) default NULL,
`dateworked` date default NULL,
`dateentered` date default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `printing_mm` */
CREATE TABLE `printing_mm` (
`user` varchar(25) default NULL,
`no` varchar(50) default NULL,
`bw` decimal(8,2) default NULL,
`color` decimal(8,2) default NULL,
`bound` char(1) default NULL,
`outside` decimal(8,2) default NULL,
`dateworked` date default NULL,
`dateentered` date default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `printing_night` */
CREATE TABLE `printing_night` (
`user` varchar(25) default NULL,
`no` varchar(50) default NULL,
`bw` decimal(8,2) default NULL,
`color` decimal(8,2) default NULL,
`bound` char(1) default NULL,
`outside` decimal(8,2) default NULL,
`dateworked` date default NULL,
`dateentered` date default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projectcosts` */
CREATE TABLE `projectcosts` (
`no` varchar(25) default NULL,
`materials` varchar(10) default NULL,
`multimedia` varchar(10) default NULL,
`vendor` varchar(10) default NULL,
`inter` varchar(10) default NULL,
`other` varchar(10) default NULL,
`tl` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projectcosts_admin` */
CREATE TABLE `projectcosts_admin` (
`no` varchar(25) default NULL,
`materials` varchar(10) default NULL,
`vendor` varchar(10) default NULL,
`other` varchar(10) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projectcosts_cood` */
CREATE TABLE `projectcosts_cood` (
`no` varchar(25) default NULL,
`materials` varchar(10) default NULL,
`vendor` varchar(10) default NULL,
`other` varchar(10) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projectcosts_finance` */
CREATE TABLE `projectcosts_finance` (
`no` varchar(25) default NULL,
`materials` varchar(10) default NULL,
`vendor` varchar(10) default NULL,
`other` varchar(10) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projectcosts_it` */
CREATE TABLE `projectcosts_it` (
`no` varchar(25) default NULL,
`materials` varchar(10) default '0.00',
`vendor` varchar(10) default '0.00',
`other` varchar(10) default '0.00',
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=;
/*Table structure for table `projectcosts_maint` */
CREATE TABLE `projectcosts_maint` (
`no` varchar(25) default NULL,
`materials` varchar(10) default NULL,
`vendor` varchar(10) default NULL,
`other` varchar(10) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projectcosts_mm` */
CREATE TABLE `projectcosts_mm` (
`no` varchar(25) default NULL,
`materials` varchar(10) default NULL,
`vendor` varchar(10) default NULL,
`other` varchar(10) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projectcosts_night` */
CREATE TABLE `projectcosts_night` (
`no` varchar(25) default NULL,
`materials` varchar(10) default NULL,
`vendor` varchar(10) default NULL,
`other` varchar(10) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projecthours` */
CREATE TABLE `projecthours` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`hours` decimal(8,2) default NULL,
`type` varchar(15) default NULL,
`dateworked` date default NULL,
`dateentered` datetime default NULL,
`notes` longtext,
`projstatus` char(1) default NULL,
`tl` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projecthours_admin` */
CREATE TABLE `projecthours_admin` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`hours` decimal(8,2) default NULL,
`type` varchar(15) default NULL,
`dateworked` date default NULL,
`dateentered` datetime default NULL,
`notes` longtext,
`projstatus` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projecthours_cood` */
CREATE TABLE `projecthours_cood` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`hours` decimal(8,2) default NULL,
`type` varchar(15) default NULL,
`dateworked` date default NULL,
`dateentered` datetime default NULL,
`notes` longtext,
`projstatus` char(1) default NULL,
`tl` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projecthours_finance` */
CREATE TABLE `projecthours_finance` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`hours` decimal(8,2) default NULL,
`type` varchar(15) default NULL,
`dateworked` date default NULL,
`dateentered` datetime default NULL,
`notes` longtext,
`projstatus` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projecthours_it` */
CREATE TABLE `projecthours_it` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`hours` decimal(8,2) default NULL,
`type` varchar(15) default NULL,
`dateworked` date default NULL,
`dateentered` datetime default NULL,
`notes` longtext,
`projstatus` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projecthours_maint` */
CREATE TABLE `projecthours_maint` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`hours` decimal(8,2) default NULL,
`type` varchar(15) default NULL,
`dateworked` date default NULL,
`dateentered` datetime default NULL,
`notes` longtext,
`projstatus` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projecthours_mm` */
CREATE TABLE `projecthours_mm` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`hours` decimal(8,2) default NULL,
`type` varchar(15) default NULL,
`dateworked` date default NULL,
`dateentered` datetime default NULL,
`notes` longtext,
`projstatus` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projecthours_night` */
CREATE TABLE `projecthours_night` (
`user` varchar(25) default NULL,
`no` varchar(15) default NULL,
`hours` decimal(8,2) default NULL,
`type` varchar(15) default NULL,
`dateworked` date default NULL,
`dateentered` datetime default NULL,
`notes` longtext,
`projstatus` char(1) default NULL,
`tl` timestamp NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `projects` */
CREATE TABLE `projects` (
`no` varchar(15) NOT NULL,
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`acost` varchar(10) default '0',
`phours` varchar(10) default '0',
`ahours` varchar(10) default '0',
`projstatus` char(1) default 'O',
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`owner` char(1) default 'n',
`changelog` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE=MyISAM DEFAULT CHARS;
/*Table structure for table `projects_admin` */
CREATE TABLE `projects_admin` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`acost` varchar(10) default '0',
`phours` varchar(10) default '0',
`ahours` varchar(10) default '0.00',
`projstatus` char(1) default NULL,
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`owner` char(1) default 'n',
`changelog` timestamp NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE=M;
/*Table structure for table `projects_cood` */
CREATE TABLE `projects_cood` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`acost` varchar(10) default '0',
`phours` varchar(10) default '0',
`ahours` varchar(10) default '0.00',
`projstatus` char(1) default NULL,
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`owner` char(1) default 'n',
`changelog` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE=M;
/*Table structure for table `projects_finance` */
CREATE TABLE `projects_finance` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`acost` varchar(10) default '0',
`phours` varchar(10) default '0',
`ahours` varchar(10) default '0.00',
`projstatus` char(1) default NULL,
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`owner` char(1) default 'n',
`changelog` timestamp NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE=M;
/*Table structure for table `projects_it` */
CREATE TABLE `projects_it` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`acost` varchar(10) default NULL,
`phours` varchar(10) default '0',
`ahours` varchar(10) default NULL,
`projstatus` char(1) default NULL,
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`owner` char(1) default 'n',
`changelog` timestamp NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE=MyISA;
/*Table structure for table `projects_maint` */
CREATE TABLE `projects_maint` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`acost` varchar(10) default '0',
`phours` varchar(10) default '0',
`ahours` varchar(10) default '0',
`projstatus` char(1) default 'O',
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`owner` char(1) default 'n',
`changelog` timestamp NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE;
/*Table structure for table `projects_mm` */
CREATE TABLE `projects_mm` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`acost` varchar(10) default '0',
`phours` varchar(10) default '0',
`ahours` varchar(10) default '0',
`projstatus` char(1) default NULL,
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`resume_dt` date default '1900-01-01',
`owner` char(1) default 'n',
`changelog` timestamp NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE;
/*Table structure for table `projects_night` */
CREATE TABLE `projects_night` (
`no` varchar(15) NOT NULL default '',
`name` varchar(100) default NULL,
`description` longtext,
`psd` date default '1900-01-01',
`asd` date default '1900-01-01',
`pfd` date default '1900-01-01',
`afd` date default '1900-01-01',
`manager` varchar(15) default NULL,
`number_developers` int(2) default '0',
`pcost` varchar(10) default '0',
`tcost` varchar(10) default NULL,
`printcost` varchar(10) default NULL,
`lcost` varchar(10) default NULL,
`ocost` varchar(10) default NULL,
`acost` varchar(10) default '0',
`phours` varchar(10) default '0',
`ahours` varchar(10) default '0.00',
`projstatus` char(1) default NULL,
`requestor` varchar(50) default NULL,
`tc` varchar(50) default NULL,
`prop_dt` date default '1900-01-01',
`denied_dt` date default '1900-01-01',
`hold_dt` date default '1900-01-01',
`owner` char(1) default 'n',
`changelog` timestamp NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`no`)
) ENGINE=M;
/*Table structure for table `tcs` */
CREATE TABLE `tcs` (
`name` varchar(50) default NULL,
`email` varbinary(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `test` */
DROP VIEW IF EXISTS `test`;
CREATE UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test` AS select `users_cood`.`user` AS `user`,`users_cood`.`password` AS `password`,`users_cood`.`level` AS `level`,`users_cood`.`name` AS `name`,`users_cood`.`censtatus` AS `censtatus` from `users_cood`;
/*Table structure for table `users` */
CREATE TABLE `users` (
`user` varchar(25) NOT NULL,
`password` varchar(15) default NULL,
`level` char(1) default NULL,
`name` varchar(50) default NULL,
`censtatus` char(1) default NULL,
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*Table structure for table `users_admin` */
CREATE TABLE `users_admin` (
`user` varchar(25) NOT NULL,
`password` varchar(15) default NULL,
`level` char(1) default NULL,
`name` varchar(50) default NULL,
`censtatus` char(1) default NULL,
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*Table structure for table `users_cood` */
CREATE TABLE `users_cood` (
`user` varchar(25) NOT NULL,
`password` varchar(15) default NULL,
`level` char(1) default '1',
`name` varchar(50) default NULL,
`censtatus` char(1) default 'a',
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYN;
/*Table structure for table `users_finance` */
CREATE TABLE `users_finance` (
`user` varchar(25) NOT NULL default '',
`password` varchar(15) default NULL,
`level` char(1) default NULL,
`name` varchar(50) default NULL,
`censtatus` char(1) default NULL,
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=lati;
/*Table structure for table `users_it` */
CREATE TABLE `users_it` (
`user` varchar(25) NOT NULL default '',
`password` varchar(15) default NULL,
`level` char(1) default NULL,
`name` varchar(50) default NULL,
`censtatus` char(1) default NULL,
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=lati;
/*Table structure for table `users_maint` */
CREATE TABLE `users_maint` (
`user` varchar(25) NOT NULL default '',
`password` varchar(15) default NULL,
`level` char(1) default NULL,
`name` varchar(50) default NULL,
`censtatus` char(1) default NULL,
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=lati;
/*Table structure for table `users_mm` */
CREATE TABLE `users_mm` (
`user` varchar(25) NOT NULL default '',
`password` varchar(15) default NULL,
`level` char(1) default '1',
`name` varchar(50) default NULL,
`censtatus` char(1) default 'a',
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=;
/*Table structure for table `users_night` */
CREATE TABLE `users_night` (
`user` varchar(25) NOT NULL default '',
`password` varchar(15) default NULL,
`level` char(1) default '1',
`name` varchar(50) default NULL,
`censtatus` char(1) default 'a',
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=;
/*View structure for view `test` */
drop view if exists `test`;
drop table if exists `test`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test` AS select `users_cood`.`user` AS `user`,`users_cood`.`password` AS `password`,`users_cood`.`level` AS `level`,`users_cood`.`name` AS `name`,`users_cood`.`censtatus` AS `censtatus` from `users_cood`;
/* Procedure structure for procedure `cordtotal` */
drop procedure if exists `cordtotal`;
DELIMITER $$;
CREATE PROCEDURE `cordtotal`(IN a varchar(50))
BEGIN
SELECT @ocost := materials + multimedia + vendor + other from projectcosts_cood where no = a;
UPDATE projects_cood set ocost = @ocost;
SELECT @pcost := sum((bw*.015)+(color * .1)+outside) from printing_cood where no = a;
UPDATE projects_cood set printcost = @pcost where no = a;
SELECT @laborcost:=sum(projecthours_cood.hours*costs.rate) from projecthours_cood,users_cood,costs where no = a and projecthours_cood.user = users_cood.user and users_cood.level = costs.level;
UPDATE projects_cood set lcost = @laborcost where no = a;
SELECT @totcost:= printcost + ocost + lcost from projects_cood where no = a;
UPDATE projects_cood set tcost = @totcost where no = a;
END$$
DELIMITER ;$$
/* Procedure structure for procedure `projecttotal` */
drop procedure if exists `projecttotal`;
DELIMITER $$;
CREATE PROCEDURE `projecttotal`(In a varchar(50))
BEGIN
SELECT @ocost := materials + multimedia + vendor + other from projectcosts where no = a;
UPDATE projects set ocost = @ocost;
SELECT @pcost := sum((bw*.015)+(color * .1)+outside) from printing where no = a;
UPDATE projects set printcost = @pcost where no = a;
SELECT @laborcost:=sum(projecthours.hours*costs.rate) from projecthours,users,costs where no = a and projecthours.user = users.user and users.level = costs.level;
UPDATE projects set lcost = @laborcost where no = a;
SELECT @totcost:= printcost + ocost + lcost from projects where no = a;
UPDATE projects set tcost = @totcost where no = a;
END$$
DELIMITER ;$$
/* Procedure structure for procedure `totalcost` */
drop procedure if exists `totalcost`;
DELIMITER $$;
CREATE PROCEDURE `totalcost`(IN a varchar(15))
BEGIN
DECLARE grand decimal (8,2);
DECLARE oottotal decimal (8,2);
DECLARE labtotal decimal (8,2);
DECLARE printtotal decimal (8,2);
call projecttotal (a);
call cordtotal(a);
SELECT @cordtotal:= tcost, @pcost:= printcost, @labor:= lcost, @outcost:= ocost from projects_cood where no =a;
Select @total:=tcost, @ppcost:=printcost, @projectlabor:=lcost, @projout:=ocost from projects where no =a;
SET @grand = @cordtotal + @total;
SET @oototal = @outcost + @projout;
SET @labtotal = @labor + @projectlabor;
SET @printotal = @pcost + @ppcost;
UPDATE master_projects set tcost = @grand, printcost = @printotal, lcost = @labtotal, ocost = @oototal where no = a;
END$$
DELIMITER ;$$
Thanks,
MemberThanks for the info and heads up. I wrote the script like you suggested. Worked fine.
Thanks,
-
AuthorPosts
