BEGIN CREATE TABLE [MYDB].[dbo].[zz_customer_history] ( [id] int IDENTITY(1,1) PRIMARY KEY, [customer_id] int NOT NULL, [date] int NOT NULL, [kind_from] varchar(10) NULL, [kind_to] varchar(10) NULL ) END

http://technet.microsoft.com/en-us/library/aa258255%28v=SQL.80%29.aspx

with default value USE [SL_repl_trans] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[yz3_stock_h]( [yz3_location] [smallint] DEFAULT 0, [yz3_style] [varchar](50) NOT NULL, [yz3_qty] [int] DEFAULT 0, [date] datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) GO 26.03.14 CREATE TABLE dbo.sl.zz_categories_main ( name varchar(255) PRIMARY KEY, meta_desc varchar(max) DEFAULT '' NOT NULL, h1 varchar(max) DEFAULT '' NOT NULL, title varchar(max) DEFAULT '' NOT NULL, description varchar(max) DEFAULT '' NOT NULL, ) GO 26.03.14 create with auto-increment BEGIN CREATE TABLE [SL_planning_module].[dbo].[supplier_orders_etas_log] ( [id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [supplier_id] varchar(255) NOT NULL DEFAULT '', [eta] int NOT NULL DEFAULT 0, [updated] datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) END 26.03.14

http://technet.microsoft.com/en-us/library/aa258255%28v=SQL.80%29.aspx

BEGIN CREATE TABLE [SL].[dbo].[zz_country_states] ( country_name VARCHAR(255) NOT NULL, alt_names VARCHAR(255) NOT NULL DEFAULT '', code2 VARCHAR(10) NOT NULL DEFAULT '', code3 VARCHAR(3) NOT NULL DEFAULT '', iso_cc INT NOT NULL DEFAULT 0, fips_code VARCHAR(10) NOT NULL DEFAULT '', fips_country_name VARCHAR(50) NOT NULL DEFAULT '', un_region VARCHAR(50) NOT NULL DEFAULT '', un_subregion VARCHAR(50) NOT NULL DEFAULT '', cdh_id INT NOT NULL DEFAULT 0, comments VARCHAR(255) NOT NULL DEFAULT '', lat VARCHAR(10) NOT NULL DEFAULT '', lng VARCHAR(10) NOT NULL DEFAULT '', ) END 26.03.14 BEGIN CREATE TABLE [SL].[dbo].[zz_country_states] ( country_name VARCHAR(50) NOT NULL DEFAULT '', subdiv VARCHAR(10) NOT NULL DEFAULT '', subdiv_name VARCHAR(100) NOT NULL DEFAULT '', level_name VARCHAR(50) NOT NULL DEFAULT '', alt_names VARCHAR(255) NOT NULL DEFAULT '', subdiv_star VARCHAR(10) NOT NULL DEFAULT '', subdiv_id INT NOT NULL DEFAULT 0, country_id INT NOT NULL DEFAULT 0, country_code_2 CHAR(2) NOT NULL DEFAULT '', country_code_3 CHAR(3) NOT NULL DEFAULT '', ) END 26.03.14 BEGIN CREATE TABLE [SL].[dbo].[zz_postal_codes] ( [id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, country_code VARCHAR(255) NOT NULL DEFAULT '', city VARCHAR(255) NOT NULL DEFAULT '', postal_codeVARCHAR(255) NOT NULL DEFAULT '', latitudeVARCHAR(255) NOT NULL DEFAULT '', longitudeVARCHAR(255) NOT NULL DEFAULT '', admin1VARCHAR(255) NOT NULL DEFAULT '', admin1_codeVARCHAR(255) NOT NULL DEFAULT '', admin2VARCHAR(255) NOT NULL DEFAULT '', admin2_codeVARCHAR(255) NOT NULL DEFAULT '', admin3VARCHAR(255) NOT NULL DEFAULT '', admin3_codeVARCHAR(255) NOT NULL DEFAULT '', ) END 26.03.14 BEGIN CREATE TABLE [SL_h].[dbo].[stock_stones] ( [id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [date] datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, stone_no INT NOT NULL DEFAULT 0, stone_code VARCHAR(255) NOT NULL DEFAULT '', shape VARCHAR(255) NOT NULL DEFAULT '', color VARCHAR(255) NOT NULL DEFAULT '', quality VARCHAR(255) NOT NULL DEFAULT '', qty INT NOT NULL DEFAULT 0, [value] FLOAT NOT NULL DEFAULT 0, year_usage INT NOT NULL DEFAULT 0, ) END 26.03.14 BEGIN CREATE TABLE [SL_h].[dbo].[backorders] ( [id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [date] datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, order_no INT NOT NULL DEFAULT 0, line INT NOT NULL DEFAULT 0, style VARCHAR(255) NOT NULL DEFAULT '', order_date INT NOT NULL DEFAULT 0, item_type VARCHAR(10) NOT NULL DEFAULT '', customer VARCHAR(255) NOT NULL DEFAULT '', customer_code INT NOT NULL DEFAULT 0, ordered INT NOT NULL DEFAULT 0, qty_supplied INT NOT NULL DEFAULT 0, in_packing INT NOT NULL DEFAULT 0, date_delivery INT NOT NULL DEFAULT 0, customer_order_no VARCHAR(255) NOT NULL DEFAULT '', ready_to_ship INT NOT NULL DEFAULT 0, backorder INT NOT NULL DEFAULT 0, ordered_usd float NOT NULL DEFAULT 0, unit_usd float NOT NULL DEFAULT 0, ) END 26.03.14 BEGIN CREATE TABLE [SL_h].[dbo].[cimco_po] ( [id] int NOT NULL IDENTITY(1,1) PRIMARY KEY ,[date] datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,PONo VARCHAR(255) NOT NULL DEFAULT '' ,POItemNO INT NOT NULL DEFAULT 0 ,CatalogueNo VARCHAR(255) NOT NULL DEFAULT '' ,PartName VARCHAR(255) NOT NULL DEFAULT '' ,OrderQty INT NOT NULL DEFAULT 0 ,RemainQty INT NOT NULL DEFAULT 0 ,UOM VARCHAR(255) NOT NULL DEFAULT '' ,Warehouse VARCHAR(255) NOT NULL DEFAULT '' ,BinLocation VARCHAR(255) NOT NULL DEFAULT '' ,Conversion INT NOT NULL DEFAULT 0 ,Amount Float NOT NULL DEFAULT 0 ,Cost Float NOT NULL DEFAULT 0 ,UnitPrice Float NOT NULL DEFAULT 0 ,SupplierCode VARCHAR(255) NOT NULL DEFAULT '' ,SupplierName VARCHAR(255) NOT NULL DEFAULT '' ,Type VARCHAR(255) NOT NULL DEFAULT '' ) END 26.03.14 BEGIN CREATE TABLE [SL].[dbo].[zz_supplier_tracker] ( [id] int NOT NULL IDENTITY(1,1) PRIMARY KEY ,supplier VARCHAR(255) NOT NULL DEFAULT '' ,[date] INT NOT NULL DEFAULT 0 ,amount_usd Float NOT NULL DEFAULT 0 ) END 26.03.14

• Home
• Notebook
• Search Engine
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2021