if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[sale_ad_accounting_delete]') and OBJECTPROPERTY(id, N'I...  
drop procedure dbo.[sale_ad_accounting_delete]
GO

-- 
-- 
-- Dumping data for table `accounting_codes`
-- 
INSERT INTO `accounting_codes` VALUES (1, 'Accountancy');

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[sale_ad_accounting_get]') and OBJECTPROPERTY(id, N'IsPr...  
drop procedure dbo.[sale_ad_accounting_get]
GO

CREATE TABLE [dbo].[AccountingTransaction]
(
[AccountingTransactionID] [int] NOT NULL IDENTITY(1, 1),

CREATE TABLE [dbo].[AccountingTransactionType]
(
[AccountingTransactionTypeID] [int] NOT NULL IDENTITY(1, 1),

CREATE TABLE [dbo].[DisburesementAccountingTransaction]
(
[TransactionID] [int] NULL

CREATE TABLE [dbo].[ObligationAccountingTransaction]
(
[TransactionID] [int] NULL

CREATE TABLE [dbo].[OtherInternalAccountingTransaction]
(
[TransactionID] [int] NULL

CREATE TABLE [dbo].[ReceptAccountingTransaction]
(
[TransactionID] [int] NULL

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[sale_ad_accounting_update]') and OBJECTPROPERTY(id, N'I...  
drop procedure dbo.[sale_ad_accounting_update]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[sale_ad_accounting_getall]') and OBJECTPROPERTY(id, N'I...  
drop procedure dbo.[sale_ad_accounting_getall]
GO

CREATE TABLE [dbo].[ExternalAccountingTransaction]
(
[TransactionID] [int] NULL,

CREATE TABLE [dbo].[PaymentAccountingTransaction]
(
[TransactionID] [int] NULL,

CREATE TABLE [dbo].[SalesAccountingTransaction]
(
[TransactionID] [int] NULL,

-- 
-- 
-- Dumping data for table `accounting_in_codes`
-- 
INSERT INTO `accounting_in_codes` VALUES (1, 'Loans received');

   if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[sale_ad_accounting_insert]') and OBJECTPROPERTY(id, ...  
drop procedure dbo.[sale_ad_accounting_insert]
GO

CREATE TABLE [dbo].[AccountingPeriod]
(
[AccountingPeriodID] [int] NOT NULL IDENTITY(1, 1),

    <VatFromPeriod>2006006</VatFromPeriod>
    <VatToPeriod>2006006</VatToPeriod>
    <AccountingPractice>NO</AccountingPractice>
    <LastClosedPeriod>2006006</LastClosedPeriod>
    <NotDistributedRevenueAccount>2090</NotDistributedRevenueAccount>

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'warehouse_sync_ad_accounting')
     BEGIN
          DROP  Procedure  dbo.warehouse_sync_ad_accounting

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[sale_ad_accounting_getpaged]') and OBJECTPROPERTY(id, N...  
drop procedure dbo.[sale_ad_accounting_getpaged]
GO

CREATE TABLE [dbo].[InternalAccountingTransaction]
(
[TransactionID] [int] NULL,

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[sale_ad_accounting_add]') and OBJECTPROPERTY(id, N'IsPr...  
drop procedure dbo.[sale_ad_accounting_add]
GO

PRIMARY KEY (sid)
);
INSERT INTO services (sid, sname, sfee) VALUES (1, 'Accounting', '1500.00');

insert into emp values('John Smith', 'Sales');
insert into emp values('Anna Jackson', 'Marketing');
insert into emp values('Jack Lebeau', 'Accounting');

insert into "emp" values('John Smith', 'Sales');
insert into "emp" values('Anna Jackson', 'Marketing');
insert into "emp" values('Jack Lebeau', 'Accounting');