2 FS::dbdef - Database objects
7 $dbdef = new FS::dbdef (@dbdef_table_objects);
8 $dbdef = load FS::dbdef "filename";
10 $dbdef->save("filename");
12 $dbdef->addtable($dbdef_table_object);
14 @table_names = $dbdef->tables;
16 $FS_dbdef_table_object = $dbdef->table;
19 FS::dbdef objects are collections of FS::dbdef_table objects and
20 represnt a database (a collection of tables).
24 Creates a new FS::dbdef object
27 Loads an FS::dbdef object from a file.
30 Saves an FS::dbdef object to a file.
33 Adds this FS::dbdef_table object.
36 Returns the names of all tables.
39 Returns the named FS::dbdef_table object.
42 Each FS::dbdef object should have a name which corresponds
43 to its name within the SQL database engine.
46 the FS::dbdef_table manpage, the FS::Record manpage,
49 beginning of abstraction into a class (not really)
51 ivan@sisd.com 97-dec-4
53 added primary_key ivan@sisd.com 98-jan-20
55 added datatype (very kludgy and needs to be cleaned)
56 ivan@sisd.com 98-feb-21
58 perltrap (sigh) masked by mysql 3.20->3,21 ivan@sisd.com 98-
61 Change 'type' to 'atype' in agent_type Changed attributes to
62 special words which are changed in fs-setup ie. double(10,2)
63 <=> MONEYTYPE Changed order of some of the field definitions
64 because Pg6.3 is picky Changed 'day' to 'daytime' in
65 cust_main Changed type of tax from tinyint to real Change
66 'password' to '_password' in svc_acct Pg6.3 does not allow
67 'field char(x) NULL' bmccane@maxbaud.net 98-apr-3
69 rewrite: now properly OO. See also
70 FS::dbdef_{table,column,unique,index}
72 ivan@sisd.com 98-apr-17
74 gained some extra functions ivan@sisd.com 98-may-11
76 now knows how to Freeze and Thaw itself ivan@sisd.com 98-
79 pod ivan@sisd.com 98-sep-23