In my company we have a logo that said:
"PROUD to be 100% Microsoft Free"
If someone want to have really deeply problems more complex than using
JavaScript, the answer is "use the most spread virus in the world, use MS
products"
Regards,
Antonio Gallardo
El Jueves, 29 de Agosto de 2002 12:08, Jeff Kowalczyk escribi�:
> I converted the 1.8.7 Pg-tables.sql (schema 1.8.5) to a syntax that creates
> the tables in Microsoft SQL server 2000. I have no way to test sql-ledger
> compatibility (not running perl on windows) but maybe we could include this
> in the distro, so people who want to port it have something start with.
>
> The Pg-indices.sql index commands will work, with one exception:
> create index ap_invnumber_key on ap (lower(invnumber))
> the docs seem to indicate that you can't compute a text column for an
> index. I have a suspicion that MSSQL is going to be case-insensitive by
> default or some other detail that works around this; I will report here
> when I find out for sure.
>
> Be sure to check whether I got all the postgres details ported before using
> it. I have one indicator that we may need to choose different column data
> types when executing the 'update defaults' statement in default-charts.sql:
> "The text, ntext, and image data types cannot be compared or sorted, except
> when using IS NULL or LIKE operator."
> If that's going to be a problem for the application, an MSSql user will
> have to adapt some things...
>
> File: MSSql-tables.sql
> --------------------------------------------------------------
>
> CREATE TABLE dbo.makemodel (
> parts_id int PRIMARY KEY,
> name text
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.gl (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> source text,
> description text,
> transdate datetime DEFAULT GETDATE(),
> employee_id int
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.chart (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> accno text NOT NULL,
> description text,
> charttype char(1) DEFAULT 'A',
> category char(1),
> link text,
> gifi_accno text
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.gifi (
> accno text,
> description text
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.defaults (
> inventory_accno_id int,
> income_accno_id int,
> expense_accno_id int,
> fxgain_accno_id int,
> fxloss_accno_id int,
> invnumber text,
> sonumber text,
> yearend varchar(5),
> weightunit varchar(5),
> businessnumber text,
> version varchar(8),
> curr text,
> closedto datetime,
> revtrans bit DEFAULT 0,
> ponumber text
> ) ON [PRIMARY]
> GO
>
> INSERT INTO defaults (version) VALUES ('1.8.5')
> GO
>
> CREATE TABLE dbo.acc_trans (
> trans_id int PRIMARY KEY,
> chart_id int,
> amount float,
> transdate datetime DEFAULT GETDATE(),
> source text,
> cleared bit DEFAULT 0,
> fx_transaction bit DEFAULT 0
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.invoice (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> trans_id int,
> parts_id int,
> description text,
> qty float(4),
> allocated float(4),
> sellprice float,
> fxsellprice float,
> discount float(4),
> assemblyitem bit DEFAULT 0,
> unit varchar(5)
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.vendor (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> name varchar(35),
> addr1 varchar(35),
> addr2 varchar(35),
> addr3 varchar(35),
> addr4 varchar(35),
> contact varchar(35),
> phone varchar(20),
> fax varchar(20),
> email text,
> notes text,
> terms smallint DEFAULT 0,
> taxincluded bit,
> vendornumber text
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.customer (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> name varchar(35),
> addr1 varchar(35),
> addr2 varchar(35),
> addr3 varchar(35),
> addr4 varchar(35),
> contact varchar(35),
> phone varchar(20),
> fax varchar(20),
> email text,
> notes text,
> discount float(4),
> taxincluded bit,
> creditlimit float DEFAULT 0,
> terms smallint DEFAULT 0,
> shiptoname varchar(35),
> shiptoaddr1 varchar(35),
> shiptoaddr2 varchar(35),
> shiptoaddr3 varchar(35),
> shiptoaddr4 varchar(35),
> shiptocontact varchar(20),
> shiptophone varchar(20),
> shiptofax varchar(20),
> shiptoemail text,
> customernumber text
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.parts (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> partnumber text,
> description text,
> unit varchar(5),
> listprice float,
> sellprice float,
> lastcost float,
> priceupdate datetime DEFAULT GETDATE(),
> weight float(4),
> onhand float(4) DEFAULT 0,
> notes text,
> makemodel bit DEFAULT 0,
> assembly bit DEFAULT 0,
> alternate bit DEFAULT 0,
> rop float(4),
> inventory_accno_id int,
> income_accno_id int,
> expense_accno_id int,
> bin text,
> obsolete bit DEFAULT 0
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.assembly (
> id int PRIMARY KEY,
> parts_id int,
> qty float
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.ar (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> invnumber text,
> transdate datetime DEFAULT GETDATE(),
> customer_id int,
> taxincluded bit,
> amount float,
> netamount float,
> paid float,
> datepaid datetime,
> duedate datetime,
> invoice bit DEFAULT 0,
> shippingpoint text,
> terms smallint DEFAULT 0,
> notes text,
> curr char(3),
> ordnumber text,
> employee_id int
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.ap (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> invnumber text,
> transdate datetime DEFAULT GETDATE(),
> vendor_id int,
> taxincluded bit DEFAULT 0,
> amount float,
> netamount float,
> paid float,
> datepaid datetime,
> duedate datetime,
> invoice bit DEFAULT 0,
> ordnumber text,
> curr char(3),
> notes text,
> employee_id int
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.partstax (
> parts_id int PRIMARY KEY,
> chart_id int
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.tax (
> chart_id int PRIMARY KEY,
> rate float,
> taxnumber text
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.customertax (
> customer_id int PRIMARY KEY,
> chart_id int
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.vendortax (
> vendor_id int PRIMARY KEY,
> chart_id int
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.oe (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> ordnumber text,
> transdate datetime default GETDATE(),
> vendor_id int,
> customer_id int,
> amount float(8),
> netamount float(8),
> reqdate datetime,
> taxincluded bit,
> shippingpoint text,
> notes text,
> curr char(3),
> employee_id int
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.orderitems (
> trans_id int PRIMARY KEY,
> parts_id int,
> description text,
> qty float(4),
> sellprice float(8),
> discount float(4),
> unit varchar(5)
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.exchangerate (
> curr char(3) PRIMARY KEY,
> transdate datetime,
> buy float(8),
> sell float(8)
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE dbo.employee (
> id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
> login text,
> name varchar(35),
> addr1 varchar(35),
> addr2 varchar(35),
> addr3 varchar(35),
> addr4 varchar(35),
> workphone varchar(20),
> homephone varchar(20),
> startdate datetime default GETDATE(),
> enddate datetime,
> notes text
> ) ON [PRIMARY]
> GO
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> -------------------------------------------------------
> (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> Archive: http://www.mail-archive.com/[email protected]/
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
-------------------------------------------------------
(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive: http://www.mail-archive.com/[email protected]/
