USE [master]
GO
/****** Object: Database [demo] Script Date: 06/19/2012 11:08:15 ******/
CREATE DATABASE [demo] ON PRIMARY
( NAME = N'demo', FILENAME = N'D:\Program Files\Microsoft SQL Server\DB_FILES\demo.mdf' , SIZE = 262144KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'demo_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\DB_FILES\demo_log.ldf' , SIZE = 65536KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [demo] SET COMPATIBILITY_LEVEL = 90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [demo].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [demo] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [demo] SET ANSI_NULLS OFF
GO
ALTER DATABASE [demo] SET ANSI_PADDING OFF
GO
ALTER DATABASE [demo] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [demo] SET ARITHABORT OFF
GO
ALTER DATABASE [demo] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [demo] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [demo] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [demo] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [demo] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [demo] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [demo] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [demo] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [demo] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [demo] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [demo] SET DISABLE_BROKER
GO
ALTER DATABASE [demo] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [demo] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [demo] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [demo] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [demo] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [demo] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [demo] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [demo] SET READ_WRITE
GO
ALTER DATABASE [demo] SET RECOVERY SIMPLE
GO
ALTER DATABASE [demo] SET MULTI_USER
GO
ALTER DATABASE [demo] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [demo] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'demo', N'ON'
GO
USE [demo]
GO
/****** Object: Table [dbo].[VISIT_INOUT_STORE] Script Date: 06/19/2012 11:08:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[VISIT_INOUT_STORE](
[ID] [varchar](32) NOT NULL,
[STORE_ID] [numeric](10, 0) NOT NULL,
[EMP_ID] [numeric](10, 0) NOT NULL,
[IS_PLANED] [int] NOT NULL,
[BIZ_DATE] [varchar](12) NOT NULL,
[INTIME] [datetime] NULL,
[OUTTIME] [datetime] NULL,
[IMG_IDX] [varchar](100) NULL,
[MEMO] [varchar](200) NULL,
[UPLOAD_DATE] [datetime] NOT NULL,
[USAGE_FLAG] [int] NOT NULL,
[IN_LON] [varchar](50) NULL,
[IN_LAT] [varchar](50) NULL,
[OUT_LON] [varchar](50) NULL,
[OUT_LAT] [varchar](50) NULL,
[IN_CELLID] [varchar](100) NULL,
[OUT_CELLID] [varchar](100) NULL,
[TRANS_ID] [varchar](32) NULL,
[sr_id] [numeric](10, 0) NULL,
[FUNC_CODE] [varchar](32) NULL,
[MEMO1] [varchar](200) NULL,
[MEMO2] [varchar](200) NULL,
[MEMO3] [varchar](200) NULL,
[MEMO4] [varchar](200) NULL,
[MEMO5] [varchar](200) NULL,
[MEMO6] [varchar](200) NULL,
[MEMO7] [varchar](200) NULL,
[MEMO8] [varchar](200) NULL,
[MEMO9] [varchar](200) NULL,
[MEMO10] [varchar](200) NULL,
[MODEL_CODE] [varchar](32) NULL,
[EXCEPTION] [varchar](1000) NULL,
[CELL_ID] [varchar](64) NULL,
[DISTANCE] [varchar](64) NULL,
[IS_MY_STORE] [int] NULL,
[MOBILE_CLICK_TIME] [datetime] NULL,
[MOBILE_UPLOAD_TIME] [datetime] NULL,
[INOUT_TIMES] [int] NULL,
[PHOTOS] [varchar](200) NULL,
[ORG_ID] [numeric](10, 0) NULL,
[EMP_ORG_ID] [varchar](50) NULL,
[EMP_ORG_CODE] [varchar](50) NULL,
CONSTRAINT [PK_VISIT_INOUT_STORE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [�