Albatross Projects - Revision history

PeterHarding at 06:36, 7 February 2008

2008-02-07T06:36:58Z

← Older revision		Revision as of 16:36, 7 February 2008
Line 16:		Line 16:
	CREATE TABLE Project (		CREATE TABLE Project (
	Project_ID int(11) default null,		Project_ID int(11) default null,

			Title varchar(256) default null,

	RequestorName varchar(64) default null,		RequestorName varchar(64) default null,
Line 275:		Line 277:
	CREATE TABLE Project (		CREATE TABLE Project (
	Project_ID int(11) default null,		Project_ID int(11) default null,

			Title varchar(256) default null,

	RequestorName varchar(64) default null,		RequestorName varchar(64) default null,

PeterHarding at 05:54, 7 February 2008

2008-02-07T05:54:25Z

← Older revision		Revision as of 15:54, 7 February 2008
Line 62:		Line 62:
	</pre>		</pre>

	===~~Release~~===		===ReleaseOrder===

	<pre>		<pre>
	DROP TABLE IF EXISTS ~~Release~~;		DROP TABLE IF EXISTS ReleaseOrder;

	CREATE TABLE ~~Release~~ (		CREATE TABLE ReleaseOrder (
	Release_ID int(11) NOT NULL auto_increment,		Release_ID int(11) NOT NULL auto_increment,

Line 140:		Line 140:

	CREATE TABLE ChangeRequest (		CREATE TABLE ChangeRequest (
	~~Request_ID~~ int(11) NOT NULL auto_increment,		Change_ID int(11) NOT NULL auto_increment,

	Title varchar(256) default NULL,		Title varchar(256) default NULL,
Line 186:		Line 186:
	LastActivityDate date default NULL,		LastActivityDate date default NULL,

	PRIMARY KEY (~~Request_ID~~)		PRIMARY KEY (Change_ID)
	) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;		) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
	</pre>		</pre>
Line 217:		Line 217:

	CREATE TABLE ChangeRequest (		CREATE TABLE ChangeRequest (
	~~Request_ID~~ int(11) NOT NULL auto_increment,		Change_ID int(11) NOT NULL auto_increment,
	Title varchar(256) default NULL,		Title varchar(256) default NULL,
	AAB_Ticket varchar(32) default NULL,		AAB_Ticket varchar(32) default NULL,
Line 263:		Line 263:
	LastActivityDate date default NULL,		LastActivityDate date default NULL,

	PRIMARY KEY (~~Request_ID~~)		PRIMARY KEY (Change_ID)
	) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;		) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

Line 322:		Line 322:

	--		--
	-- Table structure for table `~~Release~~`		-- Table structure for table `ReleaseOrder`
	--		--

	DROP TABLE IF EXISTS ~~Release~~;		DROP TABLE IF EXISTS ReleaseOrder;

	CREATE TABLE ~~Release~~ (		CREATE TABLE ReleaseOrder(
	Release_ID int(11) NOT NULL auto_increment,		Release_ID int(11) NOT NULL auto_increment,

PeterHarding at 05:16, 7 February 2008

2008-02-07T05:16:57Z

← Older revision		Revision as of 15:16, 7 February 2008
Line 22:		Line 22:
	RequestorMobile varchar(20) default null,		RequestorMobile varchar(20) default null,

			SubmitterOrganisation varchar(32) default null,
	SubmitterName varchar(64) default null,		SubmitterName varchar(64) default null,
	SubmitterEmail varchar(32) default null,		SubmitterEmail varchar(32) default null,
Line 280:		Line 281:
	RequestorMobile varchar(20) default null,		RequestorMobile varchar(20) default null,

			SubmitterOrganisation varchar(32) default null,
	SubmitterName varchar(64) default null,		SubmitterName varchar(64) default null,
	SubmitterEmail varchar(32) default null,		SubmitterEmail varchar(32) default null,

PeterHarding at 05:14, 7 February 2008

2008-02-07T05:14:47Z

Show changes

PeterHarding at 03:24, 7 February 2008

2008-02-07T03:24:27Z

← Older revision		Revision as of 13:24, 7 February 2008
Line 7:		Line 7:
	=Capacity Forecasting Tool=		=Capacity Forecasting Tool=

	=Project Management ~~Applciaction~~=		=Project Management Applicaction=

	== Tables==		== Tables==

PeterHarding at 03:24, 7 February 2008

2008-02-07T03:24:03Z

← Older revision		Revision as of 13:24, 7 February 2008
Line 6:		Line 6:

	=Capacity Forecasting Tool=		=Capacity Forecasting Tool=

			=Project Management Applciaction=

			== Tables==

	<pre>		<pre>
Line 328:		Line 332:
	</pre>		</pre>

	===Simplifying the HTML===		==Simplifying the HTML==
	====Customized CSS====		===Customized CSS===
	<pre>		<pre>
	@page Section1 {		@page Section1 {

PeterHarding at 03:22, 7 February 2008

2008-02-07T03:22:46Z

← Older revision		Revision as of 13:22, 7 February 2008
Line 328:		Line 328:
	</pre>		</pre>

	===CSS===		===Simplifying the HTML===
			====Customized CSS====
	<pre>		<pre>
	@page Section1 {		@page Section1 {
Line 395:		Line 395:
	}		}
	</pre>		</pre>

			====Simplified HTML====

	<pre>		<pre>

PeterHarding at 03:21, 7 February 2008

2008-02-07T03:21:13Z

← Older revision		Revision as of 13:21, 7 February 2008
Line 328:		Line 328:
	</pre>		</pre>

			===CSS===

			<pre>
			@page Section1 {
			size:210.0mm 842.0pt;
			margin:17.85pt 36.0pt 17.85pt 36.0pt;
			marks: cross;
			}

			.cr_table {
			background:white;
			padding:3pt 3pt 3pt 3pt;
			}

			div.Section1 {
			page:Section1;
			}

			td {
			font-size:9.0pt;
			font-family:Verdana;
			font-weight:bold;
			color:navy;
			background:#FFFF99;
			padding:5pt 5pt 5pt 5pt;
			}

			td.img {
			background:white;
			valign:bottom;
			border:1px solid black;
			}

			td.input {
			background:white;
			valign:bottom;
			border:1px solid black;
			}

			td.border {
			border:1px solid black;
			}

			h1 {
			font-size:15.0pt;
			font-family:Verdana;
			color:navy;
			}


			p.spacer {
			line-height:0.0pt;
			}

			p.note {
			font-family:Verdana;
			font-size:9.0pt;
			font-weight: bold;
			font-style: italic;
			color:red;
			line-height:4.0pt;
			}

			input {
			border:none;
			}
			</pre>

			<pre>
			<html>
			<head>
			<title>Change Request</title>
			<link href="new.css" rel="stylesheet" type="text/css" />
			</head>

			<body lang=EN-AU link=blue vlink=purple>

			<center>

			<div class=Section1>

			<table class=cr_table border=1 cellspacing=0 cellpadding=0 width="100%">
			<tr>
			<td class="img">
			<p align=center><img width=162 height=40 src="abn-amro.gif"></p>
			</td>
			<td width="52%" class="border">
			<h1 align=center>Change Management Request</h1>
			</td>
			<td class="img">
			<p align=center><img width=152 height=55 src="verizon.gif" alt="Verizon Business Logo" ></p>
			</td>
			</tr>
			</table>

			<table class=cr_table border=0 cellspacing=0 cellpadding=0 width="100%">
			<tr>
			<td>
			<p>This form is intended for personnel of AAB TNS, IBM or EDS to register a
			network-related IMAC, if online portal access is not available. On completion, the document should be
			emailed to the appropriate email address at the bottom of this page. You should receive a prompt
			acknowledgement, with a Change Number that may be used to check progress.</p>
			</td>
			</tr>
			</table>

			<p class="note">NB. If your requirement is non-standard, you should use the Project Request (blue) form instead.</p>

			<table border=1 cellspacing=0 cellpadding=0 width="100%">
			<tr>
			<td align="right" width="10%">TITLE:</td>
			<td class="input"><input type="text" name="Title" size="150"></td>
			</tr>
			</table>

			<table border=1 cellspacing=1 cellpadding=0 align=left width="100%">
			<tr>
			<td align="right" width="10%">AAB Ticket#</td>
			<td class="input" width=227>
			<input style='border:none;' type="text" name="AAB_Ticket" size="60"> </td>
			<td align="right" width="10%" >VzB IMAC#:</td>
			<td class="input" width=191>
			<input type="text" name="IMAC_No" size="50"> </td>
			</td>
			</tr>
			</table>


			</div>
			</center>
			</body>
			</html>
			</pre>


	See... [Images:Project.zip]		See... [Images:Project.zip]

PeterHarding at 00:00, 7 February 2008

2008-02-07T00:00:43Z

← Older revision		Revision as of 10:00, 7 February 2008
Line 6:		Line 6:

	=Capacity Forecasting Tool=		=Capacity Forecasting Tool=

			<pre>
			DROP TABLE IF EXISTS Project;

	CREATE TABLE Project (		CREATE TABLE Project (
Line 55:		Line 58:
	</pre>		</pre>

	===~~Releaser~~===		===Release===

	<pre>		<pre>

PeterHarding at 23:59, 6 February 2008

2008-02-06T23:59:47Z

← Older revision		Revision as of 09:59, 7 February 2008
Line 1:		Line 1:

	=Office Automation=		=Office Automation=

Line 8:		Line 7:
	=Capacity Forecasting Tool=		=Capacity Forecasting Tool=

	~~See...~~		CREATE TABLE Project (
			Project_ID int(11) default null,

	~~See https://ft.performiq.com.au/ for demo version of application~~		RequestorName varchar(64) default null,
			RequestorEmail varchar(32) default null,
	~~=Project Management Tool=~~		RequestorPhone varchar(20) default null,
			RequestorMobile varchar(20) default null,
	~~See https://verizon.performiq.com.au/ for demo version of application~~

	~~==MySQL Tables==~~

	~~===ProjectRequest===~~		SubmitterName varchar(64) default null,
			SubmitterEmail varchar(32) default null,
			SubmitterPhone varchar(20) default null,
			SubmitterMobile varchar(20) default null,
			SubmitterHDTicketNo varchar(32) default null,

	~~<pre>~~		DesiredInServiceDate date,
	~~DROP TABLE IF EXISTS ReleaseOrder;~~		Region varchar(32) default null,
			SubmitDate date,

	~~CREATE TABLE ReleaseOrder (~~		FinancialApprover varchar(64) default null,
	~~Project_ID int~~(11) ~~NOT NULL auto_increment~~,

	~~Title varchar(256)~~ ~~default null~~,		ProjectObjective text,
			SolutionOutline text,

	~~RequestorName~~ varchar(64) default null,		Site1_AAB_TNS_SiteCode varchar(32) default null,
	~~RequestorEmail~~ varchar(32) default null,		Site1_Country varchar(32) default null,
	~~RequestorPhone~~ varchar(20) default null,		Site1_ContactPerson varchar(64) default null,
	~~RequestorMobile~~ varchar(20) default null,		Site1_ContactEmail varchar(32) default null,
			S1te1_ContactPhone varchar(20) default null,
			S1te1_ContactMobile varchar(20) default null,
			Site1_Description text,

	~~VzB_ChangeManager~~ varchar(32) default null,		Site2_AAB_TNS_SiteCode varchar(32) default null,
	~~VzB_ProjectId~~ varchar(32) default null,		Site2_Country varchar(32) default null,
	~~ProjectManager~~ varchar(32) default null,		Site2_ContactPerson varchar(64) default null,
	~~AllocatedDate date,~~		Site2_ContactEmail varchar(32) default null,
	~~RelationshipManager~~ varchar(32) default null,		S2te1_ContactPhone varchar(20) default null,
	~~AAB_Ticket~~ varchar(32) default null,		S2te1_ContactMobile varchar(20) default null,
	~~SS_Number~~ varchar(32) default null,		Site2_Description text,
	~~RFS_Number varchar(32) default null~~,

	~~Description~~ text,		ConnectedProjects text,

	~~PropsalDocument varchar(64) default null,~~		PreliminaryApprovals text,
	~~ProposalVersion varchar(20) default null,~~
	~~ProposalDate date~~,

	PRIMARY KEY (Project_ID)		PRIMARY KEY (Project_ID)
Line 53:		Line 55:
	</pre>		</pre>

	===~~ReleaseOrder~~===		===Releaser===

	<pre>		<pre>
	DROP TABLE IF EXISTS ~~ReleaseOrder~~;		DROP TABLE IF EXISTS Release;

	CREATE TABLE ~~ReleaseOrder~~ (		CREATE TABLE Release(
	Release_ID int(11) NOT NULL auto_increment,		Release_ID int(11) NOT NULL auto_increment,