Introduction

This is a brief guide on how to create a new database on both MS SQL and MySQL.

MS SQL

In SQL Server Management Studio, Create a new Database (of any name) and then run the query below to create the table.

• Note: This is just a guide, you can create any table with the name you want. "tyme_raws" table is required for the transaction.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tyme_raw](
	[raw_id] [int] IDENTITY(1,1) NOT NULL,
	[raw_clock_no] [varchar](2) NOT NULL,
	[raw_date] [varchar](8) NOT NULL,
	[raw_time] [varchar](6) NOT NULL,
	[raw_card_no] [varchar](12) NOT NULL,
	[raw_job_code] [varchar](4) NOT NULL,
	[raw_trans_code] [varchar](4) NOT NULL,
	[raw_processed] [tinyint] NOT NULL,
	[raw_sync_id] [varchar](50) NOT NULL,
 CONSTRAINT [PK__tyme_raw__0B8D48FA7F60ED59] PRIMARY KEY CLUSTERED 
(
	[raw_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tyme_raw] ADD  CONSTRAINT [DF__tyme_raw__raw_cl__014935CB]  DEFAULT ('01') FOR [raw_clock_no]
GO

ALTER TABLE [dbo].[tyme_raw] ADD  CONSTRAINT [DF__tyme_raw__raw_pr__023D5A04]  DEFAULT ('0') FOR [raw_processed]
GO

ALTER TABLE [dbo].[tyme_raw] ADD  CONSTRAINT [DF__tyme_raw__raw_sy__03317E3D]  DEFAULT ('0') FOR [raw_sync_id]
GO

MySQL

In MyPHPAdmin, Create a new Database (of any name) and then run the query below to create the table.

• Note: This is just a guide, you can create any table with the name you want. "tyme_raws" table is required for the transaction.

CREATE TABLE `tyme_raws` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `raw_unique` varchar(24) NOT NULL,
  `raw_datetime` bigint(14) unsigned NOT NULL DEFAULT '0',
  `raw_clock_no` varchar(2) CHARACTER SET utf8 NOT NULL DEFAULT '01',
  `raw_date` int(8) unsigned NOT NULL DEFAULT '0',
  `raw_time` varchar(6) NOT NULL DEFAULT '0',
  `raw_card_no` int(10) unsigned NOT NULL DEFAULT '0',
  `raw_job_code` int(4) unsigned NOT NULL DEFAULT '0',
  `raw_trans_code` int(4) unsigned NOT NULL DEFAULT '0',
  `raw_processed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `raw_sync_id` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `raw_type` int(2) NOT NULL DEFAULT '0',
  `raw_device` varchar(12) NOT NULL DEFAULT '',
  `raw_remarks` varchar(255) NOT NULL DEFAULT '',
  `raw_editby` int(11) NOT NULL DEFAULT '0',
  `raw_edittime` int(25) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `raw_unique` (`raw_unique`),
  KEY `raw_datetime` (`raw_datetime`),
  KEY `raw_proc` (`raw_processed`,`raw_datetime`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;