Wiki
Clone wikiTymeSync / Remote Database
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;
Updated