Advanced Search

Return to Snippet

Revision: 12374
at March 12, 2009 13:14 by smoover
Initial Code 
CREATE TABLE `ENTERYOURTABLENAMEHERE` (
`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 200 ) NOT NULL ,
`created` DATETIME NOT NULL ,
`modified` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
UNIQUE (
`name`
)
) ENGINE = MYISAM
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
sql: Create minimum table

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, table

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL