CREATE TABLE new_table (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
bool_field tinyint(1) DEFAULT 0,
my_date datetime DEFAULT NULL
);
Archive for October, 2009
Create new MySQL table
Thursday, October 15th, 2009Adding field to existing MySQL table
Thursday, October 15th, 2009alter table table_name add new_field_name int(2) default 0;
Adding server side includes to JS and CSS files
Wednesday, October 7th, 2009Add the following to apache.conf to use server side includes in JS and CSS files:
AddType application/javascript .js
AddOutputFilter INCLUDES .js
AddType text/css .css
AddOutputFilter INCLUDES .css
Options Indexes FollowSymLinks MultiViews Includes
AllowOverride All
Order allow,deny
Allow from all